Name: LegacyPolygonCrosswalk

Display Field: WaterBodyName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Crosswalk table between MDNR FISH legacy database lakes and the custom snapshot of the USGS NHDPlus HR dataset. Continually amended by Fisheries' staff to add and update waterbodies on a case by case basis.Point of Contact: Austin Bartos, bartosa@michigan.govData Steward: Michael Rubley, rubleym1@michigan.gov

Copyright Text: Michigan Department of Natural Resources

Min. Scale: 18489298

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 165635.180700004
YMin: 128816.164000005
XMax: 913835.217900004
YMax: 847185.380600005
Spatial Reference: 102123 (3078)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[56,168,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

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:

• WaterBodyKey (type: esriFieldTypeString, alias: Water Body Key, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WatersID (type: esriFieldTypeDouble, alias: Waters ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WaterBodyName (type: esriFieldTypeString, alias: Water Body Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MDNRID (type: esriFieldTypeString, alias: MDNR ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IHDLKID (type: esriFieldTypeDouble, alias: IHDLKID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NewKey (type: esriFieldTypeString, alias: New Key, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ReviewStatus (type: esriFieldTypeString, alias: Review Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Reviewed: Reviewed], [Needs review: Needs review], [Error: Error, explain in comments], ... 1 more ...)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• created_user (type: esriFieldTypeString, alias: created_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)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• AlternativeName (type: esriFieldTypeString, alias: Alternative Names, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• SpecialCase (type: esriFieldTypeString, alias: Special Case, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No name: No name], [Name change: Name change], [Duplicate: Duplicate], ... 7 more ...)
• ErrorComment (type: esriFieldTypeString, alias: Error Comment, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• WaterBodyKeyfcs (type: esriFieldTypeString, alias: Water Body Key fcs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MainframeID (type: esriFieldTypeString, alias: Mainframe ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WatersAskKey (type: esriFieldTypeString, alias: Waters Ask Key, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WatershedID (type: esriFieldTypeDouble, alias: Watershed ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WatersName (type: esriFieldTypeString, alias: Waters Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WatersDescription (type: esriFieldTypeString, alias: Waters Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentWaterbodyMDNRID (type: esriFieldTypeString, alias: parent Waterbody MDNR ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• isActive (type: esriFieldTypeSmallInteger, alias: is Active, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Inactive], [1: Active])
• isActiveComment (type: esriFieldTypeString, alias: is Active Comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: globalid, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)

Templates:

Name: LegacyPolygonCrosswalk
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/8/2025 6:03:03 AM

Schema Last Edit Date: 4/3/2025 6:13:28 AM

Data Last Edit Date: 4/3/2025 6:13:28 AM

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