Layer: DNR Managed Water Infrastructure (ID:14)

View In: Map Viewer

Name: DNR Managed Water Infrastructure

Display Field: LEGACYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Point locations for all water related infrastructure. DNR Asset Management data model. Replacement for base features workflow.

Copyright Text: Michigan Department of Natural Resources

Min. Scale: 6127406

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"3d1d5cc8c7ee1e4a91b7986606712815","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABh0lEQVQ4jdWUXSuDYRjHf89sNtuklpdkmGJRXgonOFj5AHIgaucrRw7lEzgQckZ5PXOMnCxHohyYE4XmSGxoWobNXnge7UVetnkeTM2/7rrvuq5f/+u6uy41fyT1PwfvSr3APFADCLLZKmyIbAIBwEGP4MwMFlhAok6pqzUrE3Y3hqBICbAIVGcGSwmnimVS061+q8ucn583UglzVxCVcgyOiDBaBVNeKNNATMoReMUHy/Xgbof5awiJOXRsd8vHpYHNWh4uIhhf3w06GCiFDgOUayAiwWUUjkLgvIWDoELwqhXX7CW27TuYtMBgafqkxMHxFrjaYO8e+k94vI5R9CV47IzGneZkyVpVZjc3T3AcSt5PwxB4RiPruFVPYN1PxbQXxmuhuzgd3KKHmdR8GgsSBsSwKAP2RNENuSEe2HMInUboM0FTUbLHTxL4YuAKwoYfTh4TaYWyjtf9H8d6/yF5vqvP4HPAws/kyQ5W4UBk6f2WUigvAsPZwV3CVmoX/1r5s92U6gXNvnKx+dlLFAAAAABJRU5ErkJggg==","contentType":"image/png","width":16,"height":16,"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:

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:

ASSETTYPE: Water Infrastructure

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/7/2025 11:47:23 AM

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

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

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