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.
Copyright Text: Michigan Department of Natural Resources
Min. Scale: 0
Max. Scale: 0
Default Visibility: false
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":[255,255,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:
IsSystemMaintained : True
Global ID Field: globalid
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- 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: isActiveComment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- globalid (type: esriFieldTypeGlobalID, alias: globalid, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Templates:
Name: LegacyPolygonCrosswalk
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 2/21/2025 2:24:54 PM
Schema Last Edit Date: 11/7/2024 9:37:13 PM
Data Last Edit Date: 2/21/2025 2:24:54 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat