Name: Michigan Forest Inventory - Completed Treatments

Display Field: TreatmentName

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Treatment history is captured at the following statuses: 3 – Proposal, 5 – Approved Proposal, 9 – Field Boundary. The following statuses are only shown in Treatment history: 11- Completed, 12 – Rejected Proposal, 14 – Terminated, 15 – Treatment Sequence Complete, and 16 – Treatment Sequence Terminated.

Copyright Text: Michigan Department of Natural Resources

Min. Scale: 435699.850973162

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 210821.913400002
YMin: 144087.359099999
XMax: 779563.7159
YMax: 768363.695099998
Spatial Reference: 102123 (3078)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSBackwardDiagonal","color":[85,255,0,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[85,255,0,255],"width":1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• PercentProposed (type: esriFieldTypeDouble, alias: Percent Proposed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AcresProposed (type: esriFieldTypeDouble, alias: Acres Proposed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ForestKey (type: esriFieldTypeInteger, alias: Forest Key, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [11: Baraga], [12: Crystal Falls], [32: Gwinn], ... 250 more ...)
• FCKey (type: esriFieldTypeString, alias: FC Key, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TreatmentName (type: esriFieldTypeString, alias: Treatment Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TreatmentType (type: esriFieldTypeInteger, alias: Treatment Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TreatmentMethod (type: esriFieldTypeInteger, alias: Treatment Method, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TreatmentPurpose (type: esriFieldTypeInteger, alias: Treatment Purpose, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Acres (type: esriFieldTypeDouble, alias: Acres, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ApprovedAcres (type: esriFieldTypeDouble, alias: Approved Acres, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ProposedStartDate (type: esriFieldTypeDate, alias: Proposed Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Sponsor (type: esriFieldTypeInteger, alias: Sponsor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SponsorAffliation (type: esriFieldTypeInteger, alias: Sponsor Affliation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ApprovalStatus (type: esriFieldTypeInteger, alias: Approval Status, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ApprovalStatusChangeDate (type: esriFieldTypeDate, alias: Approval Status Change Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ApprovalStatusChangeUser (type: esriFieldTypeInteger, alias: Approval Status Change User, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CovertypeObjective (type: esriFieldTypeInteger, alias: Covertype Objective, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unspecified], [11: 11 - Low Intensity Urban], [50: 50 - Water], ... 176 more ...)
• SequenceAgeMethod (type: esriFieldTypeInteger, alias: Sequence Age Method, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ApprovalDate (type: esriFieldTypeDate, alias: Approval Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OtherComments (type: esriFieldTypeString, alias: Other Comments, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• RxSpecs (type: esriFieldTypeString, alias: Prescription Specifications, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• NextSteps (type: esriFieldTypeString, alias: Next Steps, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• ImplementationNotes (type: esriFieldTypeString, alias: Implementation Notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• AcceptableRegen (type: esriFieldTypeString, alias: Acceptable Regen, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• DateTreatmentClosed (type: esriFieldTypeDate, alias: Date Treatment Closed , SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HarvestCommercial (type: esriFieldTypeInteger, alias: Harvest Commercial, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No], [2: Yes], [0: Unspecified])
• HarvestSalePropId (type: esriFieldTypeString, alias: Harvest Sale Prop ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DominantLimitingFactor (type: esriFieldTypeInteger, alias: Dominant Limiting Factor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TreatmentSequenceNumber (type: esriFieldTypeInteger, alias: Treatment Sequence Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• StandID (type: esriFieldTypeInteger, alias: Stand ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TreatmentID (type: esriFieldTypeInteger, alias: Treatment ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TreatmentNumber (type: esriFieldTypeSmallInteger, alias: Treatment Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• L4Code (type: esriFieldTypeInteger, alias: L4Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DominantAge (type: esriFieldTypeInteger, alias: Dominant Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AgeStructure (type: esriFieldTypeInteger, alias: Age Structure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BARange (type: esriFieldTypeInteger, alias: BA Range, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SaleID (type: esriFieldTypeSmallInteger, alias: Sale ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ProposalID (type: esriFieldTypeSmallInteger, alias: Proposal ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SaleName (type: esriFieldTypeString, alias: SALE_NAME, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SaleNumber (type: esriFieldTypeString, alias: SALE_NUM, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• ProposalStatusCode (type: esriFieldTypeString, alias: Proposal Status Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ProposalStatusShortDescription (type: esriFieldTypeString, alias: Proposal Status Short Description, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ProposalSequenceNumber (type: esriFieldTypeSmallInteger, alias: Proposal Sequence Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• BatchName (type: esriFieldTypeString, alias: Batch Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OriginalOBJMet (type: esriFieldTypeInteger, alias: OriginalOBJMet, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AmendmentID (type: esriFieldTypeInteger, alias: AmendmentID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PendingAdd (type: esriFieldTypeSmallInteger, alias: PendingAdd, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PendingRemove (type: esriFieldTypeSmallInteger, alias: PendingRemove, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LandscapeHabitatCondition (type: esriFieldTypeSmallInteger, alias: Landscape Habitat Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Big Trees ], [1: Large Contiguous Patch], [2: Mast], ... 7 more ...)
• FeaturedSpecies (type: esriFieldTypeSmallInteger, alias: Featured Species, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: American Marten], [1: American Woodcock], [2: Black Bear], ... 25 more ...)
• WLDFundingSource (type: esriFieldTypeSmallInteger, alias: WLD Funding Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: cSWG], [1: DRIP], [2: GLFWRA], ... 6 more ...)
• OOYOEFCKey (type: esriFieldTypeString, alias: OOYOEFCKey, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• TreesPerAcre (type: esriFieldTypeSmallInteger, alias: TreesPerAcre, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Michigan Forest Inventory - Completed Treatments
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• TreatmentType: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/18/2025 5:40:04 PM

Schema Last Edit Date: 3/18/2025 5:40:04 PM

Data Last Edit Date: 3/18/2025 5:40:04 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat