Name: DNR Managed Culvert

Display Field: LEGACYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Point locations for Reference Asset Culverts. DNR Asset Management data model. Replacement for legacy base features workflow.

Copyright Text: Michigan Department of Natural Resources

Min. Scale: 781710

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 198181.2212
YMin: 195933.7181
XMax: 736310.875799999
YMax: 747725.475499999
Spatial Reference: 102123 (3078)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"7969f101aa79bdd15c3630a13a798aa5","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAASCAYAAABSO15qAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABNUlEQVQ4jc2TvUoDQRSFv1lmo4URmwREQRtfQoI2FoqtJEHFNg+RCAOJPknUZCsrYxP8wdraUkFBthDUFO4mOyO7C1FJqrHQAxfOhbkfd4Yzkl9K/iNAo72CMD2q5dukP/RW0ToPhORez6hU+tTba2AU0aCM2n38CaiVrmkcLVA/2UI4LuFHF7V3hfIy+DObHLQzCLeL7i/hygLQGr1CbecBiOtLqhgCp6lvTiNlHsOi3RtMZPJEOnZzdgDNVGpM1g4QaRcnNmLSDuA4Il4Dg7EDCMJkVJjAcgN6RAnp3Q4QhD4yGXkaD1DNeVx3GW0GRM4lqviCupBIfwOhszi6QyR8hLkfH2WtA6olL+29Ao3WLOY5IPfWSaN8vI4wd/QHN6OAOMrfVSsODw21v30OxDXU33/nTxA+a2Uu/y9hAAAAAElFTkSuQmCC","contentType":"image/png","width":12,"height":13,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• LEGACYID (type: esriFieldTypeString, alias: Legacy ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ASSETTYPE (type: esriFieldTypeString, alias: Asset Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ASSETDETAILTYPE (type: esriFieldTypeString, alias: Asset Detail Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DESCRIP (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Excellent: Excellent], [Very Good: Very Good], [Good: Good], ... 4 more ...)
• OWNEDBY (type: esriFieldTypeString, alias: Owned By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [County: County], [DNR-FISH: DNR-FISH], [DNR-FOD: DNR-FOD], ... 19 more ...)
• ADMINBY (type: esriFieldTypeString, alias: Administered By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Algonac State Park: Algonac State Park], [Allegan Field Office: Allegan Field Office], [Allegan State Game Area: Allegan State Game Area], ... 248 more ...)
• MAINTBY (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Algonac State Park: Algonac State Park], [Allegan Field Office: Allegan Field Office], [Allegan State Game Area: Allegan State Game Area], ... 248 more ...)
• FUNCTION_ (type: esriFieldTypeString, alias: Function, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Access: Access], [Easement: Easement], [Forestry: Forestry], ... 12 more ...)
• SURFMATERIAL (type: esriFieldTypeString, alias: Surface Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Athletic Track: Athletic Track], [Boardwalk: Boardwalk], [Brickpaver: Brickpaver], ... 19 more ...)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• COLLECTTYPE (type: esriFieldTypeSmallInteger, alias: Collect Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-99: Unknown], [-2: Other], [0: Consumer Grade Smart Device (5m)], ... 6 more ...)
• EDITTYPE (type: esriFieldTypeSmallInteger, alias: Edit Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: New], [1: Attribute Change], [2: Reposition], ... 6 more ...)
• DataSource (type: esriFieldTypeString, alias: Data Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• 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)
• ESRIGNSS_LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)

Templates:

Name: DNR Managed Culvert
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ASSETTYPE: Stormwater
• ASSETDETAILTYPE: Culvert

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/24/2026 6:56:26 AM

Schema Last Edit Date: 10/7/2025 11:43:37 AM

Data Last Edit Date: 10/7/2025 11:43:37 AM

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