{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 13, "name": "Culvert Work Rec", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 3000000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInventory", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "AssetGUID", "composite": false, "catalogID": "{753992AE-8710-4021-98B6-129C65249F3B}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": -90.19047115099994, "ymin": 41.70284597700004, "xmax": -71.05827446099994, "ymax": 47.479681293000056, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.98315284119521E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "cf92fa801b444288c781690f36180835", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAPCAYAAADtc08vAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABUklEQVQokWNhoBCwEJC3gdJHyDFARIJBvuo/A4PeS4aHLgwMDDdIMoCDgSfLhyHZToRBknsaQ0X+J4a3maQYoKHKoJftxBDKLc+gwXCCYWfEAYY1E7G5ggWbbj4G4fwohlIxkGYQCGfIFzjNsHv6V4aPjsQYYGPE4BhhxxAAF9BjsGGwZvC13sWwBCS4Aa8BwgwSpSAb0cUTGKpZzzMcqHrN8ASvAQGODKHOIBvRAcg7gQyZBrMYqlMYGBjmYDNAQ5RBpiqIIYsbi7cgpjOksW5kmNXwkuHhEViAssAkBRhEo0E2wAIOG+BnEGFIZKiR7mfIz/rJ8C0P2QANXQbrNJANOHVDgS9DCsMOhiWxFxgOTgO5AmwAKNq0GczFPjC8YQBhQsCCwUPgDsPF5i8MH0LBBvxk+P57NcPETasZQGmFOMDCwIoIA5B/fjJ8I1ozMgAARLFT0yKk8JEAAAAASUVORK5CYII=", "contentType": "image/png", "width": 12, "height": 11, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "fc_fs_recm_typ_cd", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "AssetGUID", "type": "esriFieldTypeGUID", "alias": "AssetGUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "AssetGUID" }, { "name": "InspGUID", "type": "esriFieldTypeGUID", "alias": "InspGUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "InspGUID" }, { "name": "fc_fs_recm_typ_cd", "type": "esriFieldTypeSmallInteger", "alias": "Culvert Work Recommendation Type", "domain": { "type": "codedValue", "name": "CulvertWorkRecType", "description": "Culvert Work Reccomendation Type", "codedValues": [ { "name": "Channel \u2013 Install/Repair Scour Countermeasures (Rock, CF)", "code": 1 }, { "name": "Channel - Monitor Scour", "code": 2 }, { "name": "Substructure - Repair Abutment / Wings / Headwall (Concrete, CF)", "code": 3 }, { "name": "Repair/Replace End Section (Each)", "code": 4 }, { "name": "Repair washouts/erosion (CF)", "code": 5 }, { "name": "Approach Pavement Repair (Asphalt, SF)", "code": 6 }, { "name": "Brush Cut (Brush, CY)", "code": 7 }, { "name": "Culvert Cleanout (Sediment, CF)", "code": 8 }, { "name": "Clean and/or paint/re-seal concrete for graffiti removal (Concrete, SF)", "code": 9 }, { "name": "Seal joints (Joint sealer, LF)", "code": 10 }, { "name": "Seal cracks (Crack sealer, LF)", "code": 11 }, { "name": "Barrel repair (Area, SF)", "code": 12 }, { "name": "Install Culvert Liner (Liner, LF)", "code": 13 }, { "name": "Replace Culvert (Culvert, LF)", "code": 14 }, { "name": "Channel Cleanout", "code": 15 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "fc_fs_recm_typ_cd" }, { "name": "work_recm_type_other", "type": "esriFieldTypeString", "alias": "If other, please describe. ", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "work_recm_type_other" }, { "name": "fc_fs_recm_comm", "type": "esriFieldTypeString", "alias": "Work Recommendation Comment", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "fc_fs_recm_comm" }, { "name": "insptype", "type": "esriFieldTypeSmallInteger", "alias": "Inspection Type", "domain": { "type": "codedValue", "name": "insp_type_cdtb", "description": "Inspection Type", "codedValues": [ { "name": "Routine", "code": 1 }, { "name": "Damage", "code": 2 }, { "name": "New Construction", "code": 3 }, { "name": "QA Reinspect", "code": 4 }, { "name": "RFA Reinspect", "code": 5 }, { "name": "Increased Frequency Reinspection", "code": 6 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "insptype" }, { "name": "work_rec_stat_cd", "type": "esriFieldTypeSmallInteger", "alias": "Work Recommendation Status", "domain": { "type": "codedValue", "name": "work_rec_stat_cdtb", "description": "Work Recommendation Status", "codedValues": [ { "name": "Open", "code": 0 }, { "name": "Assigned", "code": 10 }, { "name": "Complete", "code": 20 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "work_rec_stat_cd" }, { "name": "work_rect_cmpt_date", "type": "esriFieldTypeDate", "alias": "Work Recommendation Completion Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "work_rect_cmpt_date" }, { "name": "qty_matl", "type": "esriFieldTypeDouble", "alias": "Estimated Quantity of Primary Material Needed for Work Rec", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "qty_matl" }, { "name": "insp_cmpy_cd", "type": "esriFieldTypeSmallInteger", "alias": "Inspection Company", "domain": { "type": "codedValue", "name": "insp_cmpy_cdtb", "description": "Inspection Company", "codedValues": [ { "name": "MDOT", "code": 1 }, { "name": "HNTB", "code": 2 }, { "name": "Collins", "code": 3 }, { "name": "SME", "code": 4 }, { "name": "TUV", "code": 6 }, { "name": "RS&H", "code": 7 }, { "name": "Corby", "code": 8 }, { "name": "Spicer", "code": 9 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "insp_cmpy_cd" }, { "name": "insp_qc_stat_cd", "type": "esriFieldTypeSmallInteger", "alias": "Inspection QC Status", "domain": { "type": "codedValue", "name": "qc_stat_cdtb", "description": "QC Review Status", "codedValues": [ { "name": "QC Not Started", "code": 0 }, { "name": "QC Rejected - Issues to Address", "code": 1 }, { "name": "QC Complete - Accepted", "code": 2 }, { "name": "QC Comments Addressed - Ready for Verification", "code": 3 }, { "name": "QA Rejected - Issues to Address", "code": 4 }, { "name": "QA Complete - Accepted", "code": 5 }, { "name": "QA Comments Addressed - Ready for Verification", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "insp_qc_stat_cd" }, { "name": "insp_qa_stat_cd", "type": "esriFieldTypeSmallInteger", "alias": "Inspection QA Status", "domain": { "type": "codedValue", "name": "qa_stat_cdtb", "description": "QA Review Status", "codedValues": [ { "name": "QA Not Started", "code": 0 }, { "name": "QA Rejected - Issues to Address", "code": 4 }, { "name": "QA Complete - Accepted", "code": 5 }, { "name": "QA Comments Addressed - Ready for Verification", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "insp_qa_stat_cd" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "mdot_regn_cd", "type": "esriFieldTypeSmallInteger", "alias": "MDOT Region", "domain": { "type": "codedValue", "name": "mdot_regn_cdtb", "description": "MDOT Region", "codedValues": [ { "name": "Superior", "code": 1 }, { "name": "North", "code": 2 }, { "name": "Grand", "code": 3 }, { "name": "Bay", "code": 4 }, { "name": "Southwest", "code": 5 }, { "name": "University", "code": 6 }, { "name": "Metro", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mdot_regn_cd" }, { "name": "mdot_tsc_cd", "type": "esriFieldTypeInteger", "alias": "TSC", "domain": { "type": "codedValue", "name": "mdot_tsc_cdtb", "description": "MDOT Transportation Service Center", "codedValues": [ { "name": "Newberry", "code": 22 }, { "name": "Marshall", "code": 19 }, { "name": "Alpena", "code": 1 }, { "name": "Huron", "code": 28 }, { "name": "Taylor", "code": 25 }, { "name": "Kalamazoo", "code": 16 }, { "name": "Ishpeming", "code": 14 }, { "name": "Macomb", "code": 18 }, { "name": "Oakland", "code": 23 }, { "name": "Cadillac", "code": 4 }, { "name": "Crystal Falls", "code": 7 }, { "name": "Mt. Pleasant", "code": 20 }, { "name": "Gaylord", "code": 27 }, { "name": "Grand Rapids", "code": 11 }, { "name": "Detroit", "code": 9 }, { "name": "Jackson", "code": 15 }, { "name": "Muskegon", "code": 21 }, { "name": "Lansing", "code": 17 }, { "name": "Brighton", "code": 3 }, { "name": "Bay City", "code": 2 }, { "name": "Traverse City", "code": 26 }, { "name": "Davison", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mdot_tsc_cd" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R55_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_55", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G611AssetGUID", "fields": "AssetGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_55", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S24_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Culvert Work Rec", "description": "", "prototype": { "attributes": { "mdot_regn_cd": null, "mdot_tsc_cd": null, "AssetGUID": null, "InspGUID": null, "fc_fs_recm_typ_cd": null, "work_recm_type_other": null, "fc_fs_recm_comm": null, "insptype": null, "work_rec_stat_cd": null, "work_rect_cmpt_date": null, "qty_matl": null, "insp_cmpy_cd": null, "insp_qc_stat_cd": null, "insp_qa_stat_cd": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "Culvert RFA", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 3000000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInventory", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "AssetGUID", "composite": false, "catalogID": "{6C782A63-BAAF-4291-BF65-9D232AC2CC79}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": -89.93646880599994, "ymin": 41.739949445000036, "xmax": -82.53193682199998, "ymax": 47.47914603600003, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.98315284119521E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 0, 255, 197, 255 ], "size": 8, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "insp_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "AssetGUID", "type": "esriFieldTypeGUID", "alias": "AssetGUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "AssetGUID" }, { "name": "insp_name", "type": "esriFieldTypeString", "alias": "Inspector Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "insp_name" }, { "name": "insp_cmpy_cd", "type": "esriFieldTypeSmallInteger", "alias": "Inspector Company", "domain": { "type": "codedValue", "name": "insp_cmpy_cdtb", "description": "Inspection Company", "codedValues": [ { "name": "MDOT", "code": 1 }, { "name": "HNTB", "code": 2 }, { "name": "Collins", "code": 3 }, { "name": "SME", "code": 4 }, { "name": "TUV", "code": 6 }, { "name": "RS&H", "code": 7 }, { "name": "Corby", "code": 8 }, { "name": "Spicer", "code": 9 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "insp_cmpy_cd" }, { "name": "insp_date", "type": "esriFieldTypeDate", "alias": "Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "insp_date" }, { "name": "issue_desc", "type": "esriFieldTypeString", "alias": "Problems/Comments/Explanation", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "issue_desc" }, { "name": "imd_actn_req_type_cd", "type": "esriFieldTypeSmallInteger", "alias": "Immediate Action Requested", "domain": { "type": "codedValue", "name": "CulvertImmediateAction", "description": "Immediate Action types for Culverts", "codedValues": [ { "name": "Close Lane(s)", "code": 1 }, { "name": "Close Shoulder", "code": 2 }, { "name": "Repair Culvert/Embankment", "code": 3 }, { "name": "Culvert Cleanout", "code": 4 }, { "name": "Ditch Cleanout", "code": 5 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "imd_actn_req_type_cd" }, { "name": "imd_actn_oth_desc", "type": "esriFieldTypeString", "alias": "Immediate Action Request - If Other, describe:", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "imd_actn_oth_desc" }, { "name": "imd_actn_assign_cd", "type": "esriFieldTypeSmallInteger", "alias": "Immediate Action Requested By Assignee", "domain": { "type": "codedValue", "name": "crew_assignee_cd", "description": "MdotCulvert", "codedValues": [ { "name": "Concrete Crew", "code": 1 }, { "name": "Steel Crew", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "imd_actn_assign_cd" }, { "name": "imd_actn_rqstr", "type": "esriFieldTypeString", "alias": "Immediate Action Requested By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "imd_actn_rqstr" }, { "name": "imd_actn_rqst_date", "type": "esriFieldTypeDate", "alias": "Immediate Action Request Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "imd_actn_rqst_date" }, { "name": "imd_actn_req_comm", "type": "esriFieldTypeString", "alias": "Immediate Action Request Comments", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "imd_actn_req_comm" }, { "name": "imd_actn_cmptr", "type": "esriFieldTypeString", "alias": "Immediate Action Completed By", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "imd_actn_cmptr" }, { "name": "imd_actn_cmpt_date", "type": "esriFieldTypeDate", "alias": "Immediate Action Completion Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "imd_actn_cmpt_date" }, { "name": "imd_actn_cmpt_comm", "type": "esriFieldTypeString", "alias": "Immediate Action Completion Comments", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "imd_actn_cmpt_comm" }, { "name": "imd_actn_clos_date", "type": "esriFieldTypeDate", "alias": "Immediate Action Closure Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "imd_actn_clos_date" }, { "name": "imd_actn_open_date", "type": "esriFieldTypeDate", "alias": "Immediate Action Open Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "imd_actn_open_date" }, { "name": "prmy_intrmd_actn_rqst_type_cd", "type": "esriFieldTypeSmallInteger", "alias": "First Intermediate Action Requested", "domain": { "type": "codedValue", "name": "CulvertIntermediateAction", "description": "Intermediate Action types for Culverts", "codedValues": [ { "name": "Detailed Inspection", "code": 1 }, { "name": "Damage Inspection", "code": 2 }, { "name": "Repair Culvert/Embankment", "code": 3 }, { "name": "Culvert Cleanout", "code": 4 }, { "name": "Ditch Cleanout", "code": 5 }, { "name": "Scour Countermeasures", "code": 6 }, { "name": "Repair Culvert Barrel", "code": 7 }, { "name": "Repair Culvert Joints", "code": 8 }, { "name": "Monitor Condition", "code": 9 }, { "name": "Install Culvert Liner", "code": 10 }, { "name": "Replace Culvert", "code": 11 }, { "name": "Approach Pavement Repair", "code": 12 }, { "name": "Substructure - Repair Headwall/Wingwall", "code": 13 }, { "name": "Program Project", "code": 14 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "prmy_intrmd_actn_rqst_type_cd" }, { "name": "prmy_intrmd_actn_oth_desc", "type": "esriFieldTypeString", "alias": "First Intermediate Action - If Other, describe:", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "prmy_intrmd_actn_oth_desc" }, { "name": "prmy_intrmd_actn_assign_cd", "type": "esriFieldTypeSmallInteger", "alias": "First Intermediate Action Requested By Assignee", "domain": { "type": "codedValue", "name": "crew_assignee_cd", "description": "MdotCulvert", "codedValues": [ { "name": "Concrete Crew", "code": 1 }, { "name": "Steel Crew", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "prmy_intrmd_actn_assign_cd" }, { "name": "prmy_intrmd_actn_rqstr", "type": "esriFieldTypeString", "alias": "First Intermediate Action Requested By", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "prmy_intrmd_actn_rqstr" }, { "name": "prmy_intrmd_actn_rqst_date", "type": "esriFieldTypeDate", "alias": "First Intermediate Action Request Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "prmy_intrmd_actn_rqst_date" }, { "name": "prmy_intrmd_actn_cntc_cd", "type": "esriFieldTypeSmallInteger", "alias": "First Intermediate Action Contact", "domain": { "type": "codedValue", "name": "CulvertContact", "description": "Intermediate Action Contacts for Culverts", "codedValues": [ { "name": "BOBS - Culvert Specialist", "code": 1 }, { "name": "BOBS - Geotechnical", "code": 2 }, { "name": "TSC - Operations", "code": 3 }, { "name": "Region - Bridge", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "prmy_intrmd_actn_cntc_cd" }, { "name": "prmy_intrmd_actn_cntc_comm", "type": "esriFieldTypeString", "alias": "First Intermediate Action Contact Comment", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "prmy_intrmd_actn_cntc_comm" }, { "name": "prmy_intrmd_actn_cmptr", "type": "esriFieldTypeString", "alias": "First Intermediate Action Completed By", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "prmy_intrmd_actn_cmptr" }, { "name": "prmy_intrmd_actn_cmpt_date", "type": "esriFieldTypeDate", "alias": "First Intermediate Action Completion Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "prmy_intrmd_actn_cmpt_date" }, { "name": "prmy_intrmd_actn_comments", "type": "esriFieldTypeString", "alias": "First Intermediate Action Completion Comments", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "prmy_intrmd_actn_comments" }, { "name": "secd_intrmd_actn_rqst_type_cd", "type": "esriFieldTypeSmallInteger", "alias": "Second Intermediate Action Requested", "domain": { "type": "codedValue", "name": "CulvertIntermediateAction", "description": "Intermediate Action types for Culverts", "codedValues": [ { "name": "Detailed Inspection", "code": 1 }, { "name": "Damage Inspection", "code": 2 }, { "name": "Repair Culvert/Embankment", "code": 3 }, { "name": "Culvert Cleanout", "code": 4 }, { "name": "Ditch Cleanout", "code": 5 }, { "name": "Scour Countermeasures", "code": 6 }, { "name": "Repair Culvert Barrel", "code": 7 }, { "name": "Repair Culvert Joints", "code": 8 }, { "name": "Monitor Condition", "code": 9 }, { "name": "Install Culvert Liner", "code": 10 }, { "name": "Replace Culvert", "code": 11 }, { "name": "Approach Pavement Repair", "code": 12 }, { "name": "Substructure - Repair Headwall/Wingwall", "code": 13 }, { "name": "Program Project", "code": 14 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "secd_intrmd_actn_rqst_type_cd" }, { "name": "secd_intrmd_actn_oth_desc", "type": "esriFieldTypeString", "alias": "Second Intermediate Action - If Other, describe:", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "secd_intrmd_actn_oth_desc" }, { "name": "secd_intrmd_actn_assign_cd", "type": "esriFieldTypeSmallInteger", "alias": "Second Intermediate Action Requested By Assignee", "domain": { "type": "codedValue", "name": "crew_assignee_cd", "description": "MdotCulvert", "codedValues": [ { "name": "Concrete Crew", "code": 1 }, { "name": "Steel Crew", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "secd_intrmd_actn_assign_cd" }, { "name": "secd_intrmd_actn_rqstr", "type": "esriFieldTypeString", "alias": "Second Intermediate Action Requested By", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "secd_intrmd_actn_rqstr" }, { "name": "secd_intrmd_actn_rqst_date", "type": "esriFieldTypeDate", "alias": "Second Intermediate Action Request Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "secd_intrmd_actn_rqst_date" }, { "name": "secd_intrmd_actn_cntc_cd", "type": "esriFieldTypeSmallInteger", "alias": "Second Intermediate Action Contact", "domain": { "type": "codedValue", "name": "CulvertContact", "description": "Intermediate Action Contacts for Culverts", "codedValues": [ { "name": "BOBS - Culvert Specialist", "code": 1 }, { "name": "BOBS - Geotechnical", "code": 2 }, { "name": "TSC - Operations", "code": 3 }, { "name": "Region - Bridge", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "secd_intrmd_actn_cntc_cd" }, { "name": "secd_intrmd_actn_cntc_comm", "type": "esriFieldTypeString", "alias": "Second Intermediate Action Contact Comment", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "secd_intrmd_actn_cntc_comm" }, { "name": "secd_intrmd_actn_cmptr", "type": "esriFieldTypeString", "alias": "Second Intermediate Action Completed By", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "secd_intrmd_actn_cmptr" }, { "name": "secd_intrmd_actn_cmpt_date", "type": "esriFieldTypeDate", "alias": "Second Intermediate Action Completion Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "secd_intrmd_actn_cmpt_date" }, { "name": "secd_intrmd_actn_comments", "type": "esriFieldTypeString", "alias": "Second Intermediate Action Completion Comments", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "secd_intrmd_actn_comments" }, { "name": "fnl_actn_rqst_type", "type": "esriFieldTypeString", "alias": "Final Action Requested", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "fnl_actn_rqst_type" }, { "name": "fnl_actn_oth_desc", "type": "esriFieldTypeString", "alias": "Final Action - If Other, describe:", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "fnl_actn_oth_desc" }, { "name": "fnl_actn_assign_cd", "type": "esriFieldTypeSmallInteger", "alias": "Final Action Requested By Assignee", "domain": { "type": "codedValue", "name": "crew_assignee_cd", "description": "MdotCulvert", "codedValues": [ { "name": "Concrete Crew", "code": 1 }, { "name": "Steel Crew", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "fnl_actn_assign_cd" }, { "name": "fnl_actn_rqstr", "type": "esriFieldTypeString", "alias": "Final Action Requested By", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "fnl_actn_rqstr" }, { "name": "fnl_actn_rqst_date", "type": "esriFieldTypeDate", "alias": "Final Action Request Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "fnl_actn_rqst_date" }, { "name": "fnl_actn_cmptr", "type": "esriFieldTypeString", "alias": "Final Action Completed By", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "fnl_actn_cmptr" }, { "name": "fnl_actn_cmpt_date", "type": "esriFieldTypeDate", "alias": "Final Action Completion Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "fnl_actn_cmpt_date" }, { "name": "fnl_actn_comm", "type": "esriFieldTypeString", "alias": "Final Action Completion Comments", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "fnl_actn_comm" }, { "name": "rfa_stat_cd", "type": "esriFieldTypeSmallInteger", "alias": "RFA Status", "domain": { "type": "codedValue", "name": "rfa_stat_cdtb", "description": "RFA Status", "codedValues": [ { "name": "Open", "code": 1 }, { "name": "Open Reviewed/Confirmed RFA (by RFA Committee)", "code": 2 }, { "name": "Project Created/Assigned", "code": 3 }, { "name": "Closed", "code": 4 }, { "name": "Ready for Reinspection", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "rfa_stat_cd" }, { "name": "rfa_id", "type": "esriFieldTypeString", "alias": "RFA ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "rfa_id" }, { "name": "rfa_prty_cd", "type": "esriFieldTypeSmallInteger", "alias": "RFA Priority", "domain": { "type": "codedValue", "name": "rfa_prty_cdtb", "description": "RFA Priority", "codedValues": [ { "name": "Undetermined", "code": 0 }, { "name": "Priority Level 1", "code": 1 }, { "name": "Priority Level 2", "code": 2 }, { "name": "Priority Level 3", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "rfa_prty_cd" }, { "name": "mdot_regn_cd", "type": "esriFieldTypeSmallInteger", "alias": "MDOT Region", "domain": { "type": "codedValue", "name": "mdot_regn_cdtb", "description": "MDOT Region", "codedValues": [ { "name": "Superior", "code": 1 }, { "name": "North", "code": 2 }, { "name": "Grand", "code": 3 }, { "name": "Bay", "code": 4 }, { "name": "Southwest", "code": 5 }, { "name": "University", "code": 6 }, { "name": "Metro", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mdot_regn_cd" }, { "name": "mdot_tsc_cd", "type": "esriFieldTypeInteger", "alias": "TSC", "domain": { "type": "codedValue", "name": "mdot_tsc_cdtb", "description": "MDOT Transportation Service Center", "codedValues": [ { "name": "Newberry", "code": 22 }, { "name": "Marshall", "code": 19 }, { "name": "Alpena", "code": 1 }, { "name": "Huron", "code": 28 }, { "name": "Taylor", "code": 25 }, { "name": "Kalamazoo", "code": 16 }, { "name": "Ishpeming", "code": 14 }, { "name": "Macomb", "code": 18 }, { "name": "Oakland", "code": 23 }, { "name": "Cadillac", "code": 4 }, { "name": "Crystal Falls", "code": 7 }, { "name": "Mt. Pleasant", "code": 20 }, { "name": "Gaylord", "code": 27 }, { "name": "Grand Rapids", "code": 11 }, { "name": "Detroit", "code": 9 }, { "name": "Jackson", "code": 15 }, { "name": "Muskegon", "code": 21 }, { "name": "Lansing", "code": 17 }, { "name": "Brighton", "code": 3 }, { "name": "Bay City", "code": 2 }, { "name": "Traverse City", "code": 26 }, { "name": "Davison", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mdot_tsc_cd" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R53_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_53", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G609AssetGUID", "fields": "AssetGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_53", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S23_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Culvert RFA", "description": "", "prototype": { "attributes": { "mdot_tsc_cd": null, "mdot_regn_cd": null, "AssetGUID": null, "insp_name": null, "insp_cmpy_cd": null, "insp_date": null, "issue_desc": null, "imd_actn_req_type_cd": null, "imd_actn_oth_desc": null, "imd_actn_assign_cd": null, "imd_actn_rqstr": null, "imd_actn_rqst_date": null, "imd_actn_req_comm": null, "imd_actn_cmptr": null, "imd_actn_cmpt_date": null, "imd_actn_cmpt_comm": null, "imd_actn_clos_date": null, "imd_actn_open_date": null, "prmy_intrmd_actn_rqst_type_cd": null, "prmy_intrmd_actn_oth_desc": null, "prmy_intrmd_actn_assign_cd": null, "prmy_intrmd_actn_rqstr": null, "prmy_intrmd_actn_rqst_date": null, "prmy_intrmd_actn_cntc_cd": null, "prmy_intrmd_actn_cntc_comm": null, "prmy_intrmd_actn_cmptr": null, "prmy_intrmd_actn_cmpt_date": null, "prmy_intrmd_actn_comments": null, "secd_intrmd_actn_rqst_type_cd": null, "secd_intrmd_actn_oth_desc": null, "secd_intrmd_actn_assign_cd": null, "secd_intrmd_actn_rqstr": null, "secd_intrmd_actn_rqst_date": null, "secd_intrmd_actn_cntc_cd": null, "secd_intrmd_actn_cntc_comm": null, "secd_intrmd_actn_cmptr": null, "secd_intrmd_actn_cmpt_date": null, "secd_intrmd_actn_comments": null, "fnl_actn_rqst_type": null, "fnl_actn_oth_desc": null, "fnl_actn_assign_cd": null, "fnl_actn_rqstr": null, "fnl_actn_rqst_date": null, "fnl_actn_cmptr": null, "fnl_actn_cmpt_date": null, "fnl_actn_comm": null, "rfa_stat_cd": null, "rfa_id": null, "rfa_prty_cd": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "Culvert Inspection", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 3000000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInspectionQAQC", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{97394FBC-D873-4565-BDD2-3BE4839B8473}" }, { "id": 3, "name": "MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInventory", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "AssetGUID", "composite": false, "catalogID": "{D0D0B80C-FBE7-426A-B3D1-BB1A8661A97C}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": -90.19047115099994, "ymin": 41.70284871000007, "xmax": -82.44074895899996, "ymax": 47.47957516900004, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.98315284119521E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 170, 0, 255 ], "size": 8, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.6 } } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "insp_type_cd", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "AssetGUID", "type": "esriFieldTypeGUID", "alias": "AssetGUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "AssetGUID" }, { "name": "insp_type_cd", "type": "esriFieldTypeSmallInteger", "alias": "Inspection Type", "domain": { "type": "codedValue", "name": "insp_type_cdtb", "description": "Inspection Type", "codedValues": [ { "name": "Routine", "code": 1 }, { "name": "Damage", "code": 2 }, { "name": "New Construction", "code": 3 }, { "name": "QA Reinspect", "code": 4 }, { "name": "RFA Reinspect", "code": 5 }, { "name": "Increased Frequency Reinspection", "code": 6 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "insp_type_cd" }, { "name": "insp_field_vrfy_date", "type": "esriFieldTypeDate", "alias": "Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "insp_field_vrfy_date" }, { "name": "insp_user_cd", "type": "esriFieldTypeString", "alias": "Inspection User", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "insp_user_cd" }, { "name": "insp_cmpy_cd", "type": "esriFieldTypeSmallInteger", "alias": "Inspection Company", "domain": { "type": "codedValue", "name": "insp_cmpy_cdtb", "description": "Inspection Company", "codedValues": [ { "name": "MDOT", "code": 1 }, { "name": "HNTB", "code": 2 }, { "name": "Collins", "code": 3 }, { "name": "SME", "code": 4 }, { "name": "TUV", "code": 6 }, { "name": "RS&H", "code": 7 }, { "name": "Corby", "code": 8 }, { "name": "Spicer", "code": 9 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "insp_cmpy_cd" }, { "name": "insp_comm", "type": "esriFieldTypeString", "alias": "Inspection Comments", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "insp_comm" }, { "name": "insp_cret_uid", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "insp_cret_uid" }, { "name": "insp_cret_tmsp", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "insp_cret_tmsp" }, { "name": "insp_updt_uid", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "insp_updt_uid" }, { "name": "insp_updt_tmsp", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "insp_updt_tmsp" }, { "name": "water_depth_inlet", "type": "esriFieldTypeDouble", "alias": "Water Depth Inlet (inches)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "water_depth_inlet" }, { "name": "water_depth_outlet", "type": "esriFieldTypeDouble", "alias": "Water Depth Outlet (inches)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "water_depth_outlet" }, { "name": "hdwl_elmt_rtg_status_cd", "type": "esriFieldTypeSmallInteger", "alias": "Was the Headwall Element rated?", "domain": { "type": "codedValue", "name": "elmt_rtg_status_cdtb", "description": "Element Rating Status (i.e., Not Rated)", "codedValues": [ { "name": "N/R - Not Applicable", "code": 1 }, { "name": "N/R - Not Accessible", "code": 2 }, { "name": "Rating Conducted", "code": 3 }, { "name": "Element Partially Rated", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "hdwl_elmt_rtg_status_cd" }, { "name": "hdwl_elmt_rtg_comm", "type": "esriFieldTypeString", "alias": "Headwall Element Comment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "hdwl_elmt_rtg_comm" }, { "name": "hdwl_elmt_rtg_good", "type": "esriFieldTypeSmallInteger", "alias": "Headwall Element Rated Good (Each)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "hdwl_elmt_rtg_good" }, { "name": "hdwl_elmt_rtg_fair", "type": "esriFieldTypeSmallInteger", "alias": "Headwall Element Rated Fair (Each)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "hdwl_elmt_rtg_fair" }, { "name": "hdwl_elmt_rtg_poor", "type": "esriFieldTypeSmallInteger", "alias": "Headwall Element Rated Poor (Each)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "hdwl_elmt_rtg_poor" }, { "name": "hdwl_elmt_rtg_severe", "type": "esriFieldTypeSmallInteger", "alias": "Headwall Element Rated Severe (Each)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "hdwl_elmt_rtg_severe" }, { "name": "wngwl_elmt_rtg_status_cd", "type": "esriFieldTypeSmallInteger", "alias": "Was the Wingwall Element rated?", "domain": { "type": "codedValue", "name": "elmt_rtg_status_cdtb", "description": "Element Rating Status (i.e., Not Rated)", "codedValues": [ { "name": "N/R - Not Applicable", "code": 1 }, { "name": "N/R - Not Accessible", "code": 2 }, { "name": "Rating Conducted", "code": 3 }, { "name": "Element Partially Rated", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "wngwl_elmt_rtg_status_cd" }, { "name": "wngwl_elmt_rtg_comm", "type": "esriFieldTypeString", "alias": "Wingwall Element Comment", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "wngwl_elmt_rtg_comm" }, { "name": "wngwl_elmt_rtg_good", "type": "esriFieldTypeSmallInteger", "alias": "Wingwall Element Rated Good (Each)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "wngwl_elmt_rtg_good" }, { "name": "wngwl_elmt_rtg_fair", "type": "esriFieldTypeSmallInteger", "alias": "Wingwall Element Rated Fair (Each)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "wngwl_elmt_rtg_fair" }, { "name": "wngwl_elmt_rtg_poor", "type": "esriFieldTypeSmallInteger", "alias": "Wingwall Element Rated Poor (Each)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "wngwl_elmt_rtg_poor" }, { "name": "wngwl_elmt_rtg_severe", "type": "esriFieldTypeSmallInteger", "alias": "Wingwall Element Rated Severe (Each)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "wngwl_elmt_rtg_severe" }, { "name": "scour_elmt_rtg_status_cd", "type": "esriFieldTypeSmallInteger", "alias": "Was the Scour Element rated?", "domain": { "type": "codedValue", "name": "elmt_rtg_status_cdtb", "description": "Element Rating Status (i.e., Not Rated)", "codedValues": [ { "name": "N/R - Not Applicable", "code": 1 }, { "name": "N/R - Not Accessible", "code": 2 }, { "name": "Rating Conducted", "code": 3 }, { "name": "Element Partially Rated", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "scour_elmt_rtg_status_cd" }, { "name": "scour_elmt_rtg_comm", "type": "esriFieldTypeString", "alias": "Scour Element Comment", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "scour_elmt_rtg_comm" }, { "name": "scour_elmt_rtg_good", "type": "esriFieldTypeSmallInteger", "alias": "Scour Element Rated Good (Each)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "scour_elmt_rtg_good" }, { "name": "scour_elmt_rtg_fair", "type": "esriFieldTypeSmallInteger", "alias": "Scour Element Rated Fair (Each)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "scour_elmt_rtg_fair" }, { "name": "scour_elmt_rtg_poor", "type": "esriFieldTypeSmallInteger", "alias": "Scour Element Rated Poor (Each)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "scour_elmt_rtg_poor" }, { "name": "scour_elmt_rtg_severe", "type": "esriFieldTypeSmallInteger", "alias": "Scour Element Rated Severe (Each)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "scour_elmt_rtg_severe" }, { "name": "joint_elmt_rtg_status_cd", "type": "esriFieldTypeSmallInteger", "alias": "Was Joints Element Rated?", "domain": { "type": "codedValue", "name": "elmt_rtg_status_cdtb", "description": "Element Rating Status (i.e., Not Rated)", "codedValues": [ { "name": "N/R - Not Applicable", "code": 1 }, { "name": "N/R - Not Accessible", "code": 2 }, { "name": "Rating Conducted", "code": 3 }, { "name": "Element Partially Rated", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "joint_elmt_rtg_status_cd" }, { "name": "joint_elmt_rtg_comm", "type": "esriFieldTypeString", "alias": "Joints Element Comment", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "joint_elmt_rtg_comm" }, { "name": "joint_elmt_rtg_good", "type": "esriFieldTypeSmallInteger", "alias": "Joints Element Rated Good (Length, feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "joint_elmt_rtg_good" }, { "name": "joint_elmt_rtg_fair", "type": "esriFieldTypeSmallInteger", "alias": "Joints Element Rated Fair (Length, feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "joint_elmt_rtg_fair" }, { "name": "joint_elmt_rtg_poor", "type": "esriFieldTypeSmallInteger", "alias": "Joints Element Rated Poor (Length, feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "joint_elmt_rtg_poor" }, { "name": "joint_elmt_rtg_severe", "type": "esriFieldTypeSmallInteger", "alias": "Joints Element Rated Severe (Length, feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "joint_elmt_rtg_severe" }, { "name": "barl_elmt_rtg_cd", "type": "esriFieldTypeSmallInteger", "alias": "Was Barrel Element Rated?", "domain": { "type": "codedValue", "name": "elmt_rtg_status_cdtb", "description": "Element Rating Status (i.e., Not Rated)", "codedValues": [ { "name": "N/R - Not Applicable", "code": 1 }, { "name": "N/R - Not Accessible", "code": 2 }, { "name": "Rating Conducted", "code": 3 }, { "name": "Element Partially Rated", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "barl_elmt_rtg_cd" }, { "name": "barl_elmt_rtg_comm", "type": "esriFieldTypeString", "alias": "Barrel Element Comment", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "barl_elmt_rtg_comm" }, { "name": "barl_elmt_rtg_good", "type": "esriFieldTypeSmallInteger", "alias": "Barrel Element Rated Good (Length, feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "barl_elmt_rtg_good" }, { "name": "barl_elmt_rtg_fair", "type": "esriFieldTypeSmallInteger", "alias": "Barrel Element Rated Fair (Length, feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "barl_elmt_rtg_fair" }, { "name": "barl_elmt_rtg_poor", "type": "esriFieldTypeSmallInteger", "alias": "Barrel Element Rated Poor (Length, feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "barl_elmt_rtg_poor" }, { "name": "barl_elmt_rtg_severe", "type": "esriFieldTypeSmallInteger", "alias": "Barrel Element Rated Severe (Length, feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "barl_elmt_rtg_severe" }, { "name": "culv_appr_cpnt_rtg_cd", "type": "esriFieldTypeSmallInteger", "alias": "Culvert Approach Roadway and Embankment Component Rating", "domain": { "type": "codedValue", "name": "cpnt_rating_cdtb", "description": "Component Rating", "codedValues": [ { "name": "0 - Failed", "code": 0 }, { "name": "1 - Imminent Failure", "code": 1 }, { "name": "2 - Critical", "code": 2 }, { "name": "3 - Serious", "code": 3 }, { "name": "4 - Poor", "code": 4 }, { "name": "5 - Fair", "code": 5 }, { "name": "6 - Satisfactory", "code": 6 }, { "name": "7 - Good", "code": 7 }, { "name": "8 - Very Good", "code": 8 }, { "name": "9 - New", "code": 9 }, { "name": "N/R - See Comments", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "culv_appr_cpnt_rtg_cd" }, { "name": "culv_appr_cpnt_comm", "type": "esriFieldTypeString", "alias": "Culvert Approach Roadway and Embankment Component Comment", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "culv_appr_cpnt_comm" }, { "name": "culv_chnl_cpnt_rtg_cd", "type": "esriFieldTypeSmallInteger", "alias": "Culvert Channel Component Rating", "domain": { "type": "codedValue", "name": "cpnt_rating_cdtb", "description": "Component Rating", "codedValues": [ { "name": "0 - Failed", "code": 0 }, { "name": "1 - Imminent Failure", "code": 1 }, { "name": "2 - Critical", "code": 2 }, { "name": "3 - Serious", "code": 3 }, { "name": "4 - Poor", "code": 4 }, { "name": "5 - Fair", "code": 5 }, { "name": "6 - Satisfactory", "code": 6 }, { "name": "7 - Good", "code": 7 }, { "name": "8 - Very Good", "code": 8 }, { "name": "9 - New", "code": 9 }, { "name": "N/R - See Comments", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "culv_chnl_cpnt_rtg_cd" }, { "name": "culv_chnl_chnl_comm", "type": "esriFieldTypeString", "alias": "Culvert Channel Component Comment", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "culv_chnl_chnl_comm" }, { "name": "culv_strc_cpnt_rtg_cd", "type": "esriFieldTypeSmallInteger", "alias": "Culvert Structure Component Rating", "domain": { "type": "codedValue", "name": "cpnt_rating_cdtb", "description": "Component Rating", "codedValues": [ { "name": "0 - Failed", "code": 0 }, { "name": "1 - Imminent Failure", "code": 1 }, { "name": "2 - Critical", "code": 2 }, { "name": "3 - Serious", "code": 3 }, { "name": "4 - Poor", "code": 4 }, { "name": "5 - Fair", "code": 5 }, { "name": "6 - Satisfactory", "code": 6 }, { "name": "7 - Good", "code": 7 }, { "name": "8 - Very Good", "code": 8 }, { "name": "9 - New", "code": 9 }, { "name": "N/R - See Comments", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "culv_strc_cpnt_rtg_cd" }, { "name": "culv_strc_strc_comm", "type": "esriFieldTypeString", "alias": "Culvert Structure Comment", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "culv_strc_strc_comm" }, { "name": "culv_end_cpnt_rtg_cd", "type": "esriFieldTypeSmallInteger", "alias": "Culvert End Treatment Component Rating", "domain": { "type": "codedValue", "name": "cpnt_rating_cdtb", "description": "Component Rating", "codedValues": [ { "name": "0 - Failed", "code": 0 }, { "name": "1 - Imminent Failure", "code": 1 }, { "name": "2 - Critical", "code": 2 }, { "name": "3 - Serious", "code": 3 }, { "name": "4 - Poor", "code": 4 }, { "name": "5 - Fair", "code": 5 }, { "name": "6 - Satisfactory", "code": 6 }, { "name": "7 - Good", "code": 7 }, { "name": "8 - Very Good", "code": 8 }, { "name": "9 - New", "code": 9 }, { "name": "N/R - See Comments", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "culv_end_cpnt_rtg_cd" }, { "name": "culv_end_cpnt_comm", "type": "esriFieldTypeString", "alias": "Culvert End Treatment Comment", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "culv_end_cpnt_comm" }, { "name": "culv_cpnt_rtg_cd", "type": "esriFieldTypeSmallInteger", "alias": "Culvert Component (Calculated Min)", "domain": { "type": "codedValue", "name": "cpnt_rating_cdtb", "description": "Component Rating", "codedValues": [ { "name": "0 - Failed", "code": 0 }, { "name": "1 - Imminent Failure", "code": 1 }, { "name": "2 - Critical", "code": 2 }, { "name": "3 - Serious", "code": 3 }, { "name": "4 - Poor", "code": 4 }, { "name": "5 - Fair", "code": 5 }, { "name": "6 - Satisfactory", "code": 6 }, { "name": "7 - Good", "code": 7 }, { "name": "8 - Very Good", "code": 8 }, { "name": "9 - New", "code": 9 }, { "name": "N/R - See Comments", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "culv_cpnt_rtg_cd" }, { "name": "next_insp_freq", "type": "esriFieldTypeDouble", "alias": "Next Inspection Frequency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "next_insp_freq" }, { "name": "just_comm", "type": "esriFieldTypeString", "alias": "Justification Comment for Next Inspection Frequency", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "just_comm" }, { "name": "qc_stat_cd", "type": "esriFieldTypeSmallInteger", "alias": "QC Status (Calculated from QA/QC Related Table)", "domain": { "type": "codedValue", "name": "qc_stat_cdtb", "description": "QC Review Status", "codedValues": [ { "name": "QC Not Started", "code": 0 }, { "name": "QC Rejected - Issues to Address", "code": 1 }, { "name": "QC Complete - Accepted", "code": 2 }, { "name": "QC Comments Addressed - Ready for Verification", "code": 3 }, { "name": "QA Rejected - Issues to Address", "code": 4 }, { "name": "QA Complete - Accepted", "code": 5 }, { "name": "QA Comments Addressed - Ready for Verification", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "qc_stat_cd" }, { "name": "qa_stat_cd", "type": "esriFieldTypeSmallInteger", "alias": "QA Status (Calculated from QA/QC Related Table)", "domain": { "type": "codedValue", "name": "qa_stat_cdtb", "description": "QA Review Status", "codedValues": [ { "name": "QA Not Started", "code": 0 }, { "name": "QA Rejected - Issues to Address", "code": 4 }, { "name": "QA Complete - Accepted", "code": 5 }, { "name": "QA Comments Addressed - Ready for Verification", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "qa_stat_cd" }, { "name": "inlet_sfty_grate_cd", "type": "esriFieldTypeSmallInteger", "alias": "Safety grate or trash rack present at inlet?", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "inlet_sfty_grate_cd" }, { "name": "outlet_sfty_grate_cd", "type": "esriFieldTypeSmallInteger", "alias": "Safety grate or trash rack present at outlet?", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "outlet_sfty_grate_cd" }, { "name": "insp_complete_cd", "type": "esriFieldTypeString", "alias": "Inspection Complete?", "domain": { "type": "codedValue", "name": "insp_complete_cdtb", "description": "InspectionComplete", "codedValues": [ { "name": "In Progress", "code": "In Progress" }, { "name": "Ready for QC", "code": "Ready for QC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "In Progress", "modelName": "insp_complete_cd" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R57_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_57", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G613AssetGUID", "fields": "AssetGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_57", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S25_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Culvert Inspection", "description": "", "prototype": { "attributes": { "insp_complete_cd": "In Progress", "outlet_sfty_grate_cd": null, "AssetGUID": null, "insp_type_cd": null, "insp_field_vrfy_date": null, "insp_user_cd": null, "insp_cmpy_cd": null, "insp_comm": null, "insp_cret_uid": null, "insp_cret_tmsp": null, "insp_updt_uid": null, "insp_updt_tmsp": null, "water_depth_inlet": null, "water_depth_outlet": null, "hdwl_elmt_rtg_status_cd": null, "hdwl_elmt_rtg_comm": null, "hdwl_elmt_rtg_good": null, "hdwl_elmt_rtg_fair": null, "hdwl_elmt_rtg_poor": null, "hdwl_elmt_rtg_severe": null, "wngwl_elmt_rtg_status_cd": null, "wngwl_elmt_rtg_comm": null, "wngwl_elmt_rtg_good": null, "wngwl_elmt_rtg_fair": null, "wngwl_elmt_rtg_poor": null, "wngwl_elmt_rtg_severe": null, "scour_elmt_rtg_status_cd": null, "scour_elmt_rtg_comm": null, "scour_elmt_rtg_good": null, "scour_elmt_rtg_fair": null, "scour_elmt_rtg_poor": null, "scour_elmt_rtg_severe": null, "joint_elmt_rtg_status_cd": null, "joint_elmt_rtg_comm": null, "joint_elmt_rtg_good": null, "joint_elmt_rtg_fair": null, "joint_elmt_rtg_poor": null, "joint_elmt_rtg_severe": null, "barl_elmt_rtg_cd": null, "barl_elmt_rtg_comm": null, "barl_elmt_rtg_good": null, "barl_elmt_rtg_fair": null, "barl_elmt_rtg_poor": null, "barl_elmt_rtg_severe": null, "culv_appr_cpnt_rtg_cd": null, "culv_appr_cpnt_comm": null, "culv_chnl_cpnt_rtg_cd": null, "culv_chnl_chnl_comm": null, "culv_strc_cpnt_rtg_cd": null, "culv_strc_strc_comm": null, "culv_end_cpnt_rtg_cd": null, "culv_end_cpnt_comm": null, "culv_cpnt_rtg_cd": null, "next_insp_freq": null, "just_comm": null, "qc_stat_cd": null, "qa_stat_cd": null, "inlet_sfty_grate_cd": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "Culvert Inventory", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 3000000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertWorkRecommendation", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{753992AE-8710-4021-98B6-129C65249F3B}" }, { "id": 1, "name": "MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertRfa", "relatedTableId": 12, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{6C782A63-BAAF-4291-BF65-9D232AC2CC79}" }, { "id": 3, "name": "MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInspection", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{D0D0B80C-FBE7-426A-B3D1-BB1A8661A97C}" }, { "id": 4, "name": "MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertEndInventory", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{1AB95881-80C6-4D51-91A0-D2712059BFB7}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriDecimalDegrees" }, "hasMetadata": true, "extent": { "xmin": -90.19062411899995, "ymin": 41.70284597700004, "xmax": -82.42450370199998, "ymax": 47.479681293000056, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.98315284119521E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 112, 255, 255 ], "width": 4 } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "strucname", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "strc_num", "type": "esriFieldTypeString", "alias": "Structure Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "strc_num" }, { "name": "strc_num_seq", "type": "esriFieldTypeInteger", "alias": "Structure Number Sequence", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "strc_num_seq" }, { "name": "strc_type_cd", "type": "esriFieldTypeSmallInteger", "alias": "Structure Type", "domain": { "type": "codedValue", "name": "strc_type_cdtb", "description": "Ancillary Structure Types", "codedValues": [ { "name": "Sign Cantilever", "code": 1 }, { "name": "Sign Truss", "code": 2 }, { "name": "Culvert less than 10 feet", "code": 3 }, { "name": "Retaining Wall", "code": 4 }, { "name": "Storm Sewer", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "strc_type_cd" }, { "name": "CulvertMaterial", "type": "esriFieldTypeString", "alias": "Culvert Type/Material", "domain": { "type": "codedValue", "name": "CulvertMaterial_BOBS", "description": "Culvert Material", "codedValues": [ { "name": "Masonry", "code": "Masonry" }, { "name": "Aluminum", "code": "Aluminum" }, { "name": "Steel", "code": "Steel" }, { "name": "Metal", "code": "Metal" }, { "name": "Polyethylene", "code": "Polyethylene" }, { "name": "Polypropylene", "code": "Polypropylene" }, { "name": "PVC", "code": "PVC" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "Timber", "code": "Timber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CulvertMaterial" }, { "name": "Culv_dsgn_type_cd", "type": "esriFieldTypeString", "alias": "Culvert Design Type", "domain": { "type": "codedValue", "name": "culv_dsgn_type_cdtb", "description": "Culvert Design Type", "codedValues": [ { "name": "Corrugated", "code": "Corrugated" }, { "name": "Non-corrugated", "code": "Non-corrugated" }, { "name": "Reinforced Concrete", "code": "Reinforced Concrete" }, { "name": "Nonreinforced Concrete", "code": "Nonreinforced Concrete" }, { "name": "Prestressed Concrete", "code": "Prestressed Concrete" }, { "name": "Post-Tensioned Concrete", "code": "Post-Tensioned Concrete" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Culv_dsgn_type_cd" }, { "name": "ServiceStatus", "type": "esriFieldTypeSmallInteger", "alias": "Service Status", "domain": { "type": "codedValue", "name": "serv_stat_cdtb", "description": "Service Status", "codedValues": [ { "name": "Abandoned", "code": 1 }, { "name": "Active", "code": 2 }, { "name": "Proposed", "code": 3 }, { "name": "Removed", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceStatus" }, { "name": "strucname", "type": "esriFieldTypeString", "alias": "Structure Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "strucname" }, { "name": "invt_field_vrfy_date", "type": "esriFieldTypeDate", "alias": "Field Verification Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "invt_field_vrfy_date" }, { "name": "invt_field_vrfy_user", "type": "esriFieldTypeString", "alias": "Inventory Field Verification User", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "invt_field_vrfy_user" }, { "name": "invt_field_vrfy_cmpy_cd", "type": "esriFieldTypeSmallInteger", "alias": "Field Verification Company", "domain": { "type": "codedValue", "name": "insp_cmpy_cdtb", "description": "Inspection Company", "codedValues": [ { "name": "MDOT", "code": 1 }, { "name": "HNTB", "code": 2 }, { "name": "Collins", "code": 3 }, { "name": "SME", "code": 4 }, { "name": "TUV", "code": 6 }, { "name": "RS&H", "code": 7 }, { "name": "Corby", "code": 8 }, { "name": "Spicer", "code": 9 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "invt_field_vrfy_cmpy_cd" }, { "name": "invt_field_comm", "type": "esriFieldTypeString", "alias": "Field Verification Comments", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "invt_field_comm" }, { "name": "next_insp_freq", "type": "esriFieldTypeDouble", "alias": "Next Inspection Frequency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "next_insp_freq" }, { "name": "antcp_insp_date", "type": "esriFieldTypeDate", "alias": "Anticipated Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "antcp_insp_date" }, { "name": "aadt", "type": "esriFieldTypeInteger", "alias": "AADT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "aadt" }, { "name": "aadt_yr", "type": "esriFieldTypeSmallInteger", "alias": "AADT Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "aadt_yr" }, { "name": "owner_cd", "type": "esriFieldTypeSmallInteger", "alias": "Structure Owner", "domain": { "type": "codedValue", "name": "owner_cdtb", "description": "Structure Owner (Same list used for Maintainer)", "codedValues": [ { "name": "State Highway Agency", "code": 1 }, { "name": "County Highway Agency", "code": 2 }, { "name": "Town or Township Highway Agency", "code": 3 }, { "name": "City or Municipal Highway Agency", "code": 4 }, { "name": "State Park, Forest, or Reservation Agency", "code": 11 }, { "name": "Local Park, Forest, or Reservation Agency", "code": 12 }, { "name": "Other State Agencies", "code": 21 }, { "name": "Other Local Agencies", "code": 25 }, { "name": "Private-other than railroad", "code": 26 }, { "name": "Railroad", "code": 27 }, { "name": "State Toll Authority", "code": 31 }, { "name": "Local Toll Authority", "code": 32 }, { "name": "Other Federal Agencies-not listed below", "code": 60 }, { "name": "Indian Tribal Government", "code": 61 }, { "name": "Bureau of Indian Affairs", "code": 62 }, { "name": "Bureau of Fish and Wildlife", "code": 63 }, { "name": "US Forest Service", "code": 64 }, { "name": "National Park Service", "code": 66 }, { "name": "Tennessee Valley Authority", "code": 67 }, { "name": "Bureau of Land Management", "code": 68 }, { "name": "Bureau of Reclamation", "code": 69 }, { "name": "Corps of Engineers-Civil", "code": 70 }, { "name": "Corps of Engineers-Military", "code": 71 }, { "name": "Air Force", "code": 72 }, { "name": "Navy/Marines", "code": 73 }, { "name": "Army", "code": 74 }, { "name": "NASA", "code": 75 }, { "name": "Metropolitan Washington Airports Service", "code": 76 }, { "name": "Unknown", "code": 80 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "owner_cd" }, { "name": "owner_name_cd", "type": "esriFieldTypeSmallInteger", "alias": "Structure Owner Type", "domain": { "type": "codedValue", "name": "owner_name_cdtb", "description": "Owner Name", "codedValues": [ { "name": "MDOT", "code": 1 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "owner_name_cd" }, { "name": "custodian_name_cd", "type": "esriFieldTypeSmallInteger", "alias": "Structure Maintainer", "domain": { "type": "codedValue", "name": "owner_name_cdtb", "description": "Owner Name", "codedValues": [ { "name": "MDOT", "code": 1 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "custodian_name_cd" }, { "name": "acs_cd", "type": "esriFieldTypeSmallInteger", "alias": "Access Requirements", "domain": { "type": "codedValue", "name": "acs_cdtb", "description": "Physical or Security Access Requirements", "codedValues": [ { "name": "Secure fencing", "code": 1 }, { "name": "Keyed gate", "code": 2 }, { "name": "Access to Railroad Right-of-way", "code": 3 }, { "name": "Access to Private Right-of-way", "code": 4 }, { "name": "Other", "code": 99 }, { "name": "None", "code": 100 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "acs_cd" }, { "name": "acs_note", "type": "esriFieldTypeString", "alias": "Access Requirements Note", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "acs_note" }, { "name": "trfc_ctrl_cd", "type": "esriFieldTypeSmallInteger", "alias": "Traffic Control Needs", "domain": { "type": "codedValue", "name": "trfc_ctrl_cdtb", "description": "Traffic Control Type", "codedValues": [ { "name": "Shoulder closure", "code": 1 }, { "name": "Single lane closure", "code": 2 }, { "name": "Full road closure", "code": 3 }, { "name": "Other", "code": 99 }, { "name": "None", "code": 100 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "trfc_ctrl_cd" }, { "name": "trfc_ctrl_note", "type": "esriFieldTypeString", "alias": "Traffic Control Notes", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "trfc_ctrl_note" }, { "name": "rail_coord_cd", "type": "esriFieldTypeSmallInteger", "alias": "Railroad Coordination Required?", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "rail_coord_cd" }, { "name": "rail_name_cd", "type": "esriFieldTypeSmallInteger", "alias": "Railroad Name", "domain": { "type": "codedValue", "name": "rail_name_cdtb", "description": "Railroad Name", "codedValues": [ { "name": "Canadian National Railway", "code": 1 }, { "name": "Lake Superior & Ishpeming Rail", "code": 2 }, { "name": "Lake State Railway", "code": 3 }, { "name": "Huron & Eastern Railway", "code": 4 }, { "name": "Great Lakes Central Railroad", "code": 5 }, { "name": "Marquette Rail", "code": 6 }, { "name": "Saginaw Bay Southern", "code": 7 }, { "name": "Mid-Michigan Railroad", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "rail_name_cd" }, { "name": "rail_phne_num_cd", "type": "esriFieldTypeSmallInteger", "alias": "Railroad Phone Number", "domain": { "type": "codedValue", "name": "rail_phone_num_cdtb", "description": "Railroad Phone Contacts", "codedValues": [ { "name": "555-555-5555 (RR Name1)", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "rail_phne_num_cd" }, { "name": "JobNumber", "type": "esriFieldTypeString", "alias": "Job Number Installed or Refurb", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "JobNumber" }, { "name": "prmy_xstr", "type": "esriFieldTypeString", "alias": "Primary Cross Street", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "prmy_xstr" }, { "name": "location", "type": "esriFieldTypeString", "alias": "Location Description", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "location" }, { "name": "legal_cd", "type": "esriFieldTypeSmallInteger", "alias": "MDOT Legal System", "domain": { "type": "codedValue", "name": "legal_cd", "description": "MDOT Legal System", "codedValues": [ { "name": "MDOT", "code": 1 }, { "name": "County Primary", "code": 2 }, { "name": "County Local", "code": 3 }, { "name": "City Major", "code": 4 }, { "name": "City Minor", "code": 5 }, { "name": "Other", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "legal_cd" }, { "name": "nrst_rte_drtn_cd", "type": "esriFieldTypeSmallInteger", "alias": "Route Travel Direction", "domain": { "type": "codedValue", "name": "nrst_rte_drtn_cdtb", "description": "Travel Direction of the Route nearest to the structure", "codedValues": [ { "name": "NB", "code": 1 }, { "name": "SB", "code": 2 }, { "name": "WB", "code": 3 }, { "name": "EB", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "nrst_rte_drtn_cd" }, { "name": "mile_mrkr", "type": "esriFieldTypeDouble", "alias": "Mile Marker", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mile_mrkr" }, { "name": "PR", "type": "esriFieldTypeString", "alias": "Physical Reference ID number", "domain": null, "editable": true, "nullable": true, "length": 14, "defaultValue": null, "modelName": "PR" }, { "name": "PRMP", "type": "esriFieldTypeDouble", "alias": "PR Milepoint", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PRMP" }, { "name": "cs", "type": "esriFieldTypeInteger", "alias": "CS Control Section", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "cs" }, { "name": "cs_mp", "type": "esriFieldTypeDouble", "alias": "CS Milepoint", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "cs_mp" }, { "name": "placecode_cd", "type": "esriFieldTypeInteger", "alias": "City", "domain": { "type": "codedValue", "name": "placecode_cdtb", "description": "Place Code", "codedValues": [ { "name": "Acme Township", "code": 200 }, { "name": "Ada Township", "code": 240 }, { "name": "Adams Township", "code": 280 }, { "name": "Adams Township", "code": 300 }, { "name": "Adams Township", "code": 320 }, { "name": "Addison Township", "code": 400 }, { "name": "City of Adrian", "code": 440 }, { "name": "Adrian Township", "code": 460 }, { "name": "Aetna Township", "code": 500 }, { "name": "Aetna Township", "code": 520 }, { "name": "Akron Township", "code": 720 }, { "name": "Alabaster Township", "code": 760 }, { "name": "Alaiedon Township", "code": 800 }, { "name": "Alamo Township", "code": 840 }, { "name": "Albee Township", "code": 920 }, { "name": "Albert Township", "code": 940 }, { "name": "City of Albion", "code": 980 }, { "name": "Albion Township", "code": 1000 }, { "name": "Alcona Township", "code": 1040 }, { "name": "Algansee Township", "code": 1120 }, { "name": "Algoma Township", "code": 1160 }, { "name": "City of Algonac", "code": 1180 }, { "name": "Allegan Township", "code": 1280 }, { "name": "City of Allegan", "code": 1260 }, { "name": "Allen Township", "code": 1320 }, { "name": "City of Allen Park", "code": 1380 }, { "name": "Allendale Township", "code": 1360 }, { "name": "Allis Township", "code": 1480 }, { "name": "Allouez Township", "code": 1520 }, { "name": "City of Alma", "code": 1540 }, { "name": "Almena Township", "code": 1600 }, { "name": "Almer Township", "code": 1620 }, { "name": "Almira Township", "code": 1640 }, { "name": "Almont Township", "code": 1680 }, { "name": "Aloha Township", "code": 1720 }, { "name": "City of Alpena", "code": 1740 }, { "name": "Alpena Township", "code": 1760 }, { "name": "Alpine Township", "code": 1840 }, { "name": "Amber Township", "code": 1980 }, { "name": "Amboy Township", "code": 2020 }, { "name": "Ann Arbor Township", "code": 3020 }, { "name": "City of Ann Arbor", "code": 3000 }, { "name": "Antioch Township", "code": 3060 }, { "name": "Antrim Township", "code": 3120 }, { "name": "Antwerp Township", "code": 3140 }, { "name": "Arbela Township", "code": 3220 }, { "name": "Arcada Township", "code": 3260 }, { "name": "Arcadia Township", "code": 3280 }, { "name": "Arcadia Township", "code": 3320 }, { "name": "Arenac Township", "code": 3360 }, { "name": "Argentine Township", "code": 3420 }, { "name": "Argyle Township", "code": 3460 }, { "name": "Arlington Township", "code": 3500 }, { "name": "Armada Township", "code": 3540 }, { "name": "Arthur Township", "code": 3620 }, { "name": "Arvon Township", "code": 3660 }, { "name": "Ash Township", "code": 3680 }, { "name": "Ashland Township", "code": 3700 }, { "name": "Assyria Township", "code": 3860 }, { "name": "Athens Township", "code": 3900 }, { "name": "Atlas Township", "code": 4000 }, { "name": "Attica Township", "code": 4040 }, { "name": "City of Au Gres", "code": 4120 }, { "name": "Au Gres Township", "code": 4140 }, { "name": "Au Sable Township", "code": 4300 }, { "name": "Au Sable Township", "code": 4320 }, { "name": "Au Train Township", "code": 4460 }, { "name": "City of Auburn", "code": 4080 }, { "name": "City of Auburn Hills", "code": 4105 }, { "name": "Augusta Township", "code": 4180 }, { "name": "Aurelius Township", "code": 4240 }, { "name": "Austin Township", "code": 4380 }, { "name": "Austin Township", "code": 4400 }, { "name": "Avery Township", "code": 4580 }, { "name": "Backus Township", "code": 4720 }, { "name": "City of Bad Axe", "code": 4740 }, { "name": "Bagley Township", "code": 4780 }, { "name": "Bainbridge Township", "code": 4840 }, { "name": "Baldwin Township", "code": 4900 }, { "name": "Baldwin Township", "code": 4920 }, { "name": "Baltimore Township", "code": 5020 }, { "name": "Bangor Township", "code": 5120 }, { "name": "Bangor Township", "code": 5160 }, { "name": "City of Bangor", "code": 5140 }, { "name": "Banks Township", "code": 5240 }, { "name": "Baraga Township", "code": 5340 }, { "name": "Bark River Township", "code": 5420 }, { "name": "Baroda Township", "code": 5520 }, { "name": "Barry Township", "code": 5560 }, { "name": "Barton Township", "code": 5620 }, { "name": "Batavia Township", "code": 5800 }, { "name": "Bates Township", "code": 5860 }, { "name": "Bath Township", "code": 5900 }, { "name": "City of Battle Creek", "code": 5920 }, { "name": "Bay Township", "code": 6000 }, { "name": "City of Bay City", "code": 6020 }, { "name": "Bay De Noc Township", "code": 6040 }, { "name": "Bay Mills Township", "code": 6070 }, { "name": "Bear Creek Township", "code": 6380 }, { "name": "Bear Lake Township", "code": 6440 }, { "name": "Bear Lake Township", "code": 6480 }, { "name": "Bearinger Township", "code": 6400 }, { "name": "Beaugrand Township", "code": 6500 }, { "name": "Beaver Township", "code": 6540 }, { "name": "Beaver Township", "code": 6580 }, { "name": "Beaver Creek Township", "code": 6600 }, { "name": "Beaverton Township", "code": 6680 }, { "name": "City of Beaverton", "code": 6660 }, { "name": "Bedford Township", "code": 6720 }, { "name": "Bedford Township", "code": 6740 }, { "name": "City of Belding", "code": 6900 }, { "name": "Belknap Township", "code": 6920 }, { "name": "City of Belleville", "code": 7020 }, { "name": "Bellevue Township", "code": 7080 }, { "name": "Belvidere Township", "code": 7200 }, { "name": "Bengal Township", "code": 7240 }, { "name": "Bennington Township", "code": 7280 }, { "name": "Benona Township", "code": 7300 }, { "name": "Bentley Township", "code": 7360 }, { "name": "Benton Township", "code": 7400 }, { "name": "Benton Township", "code": 7420 }, { "name": "Benton Township", "code": 7440 }, { "name": "City of Benton Harbor", "code": 7520 }, { "name": "Benzonia Township", "code": 7600 }, { "name": "Bergland Township", "code": 7640 }, { "name": "City of Berkley", "code": 7660 }, { "name": "Berlin Township", "code": 7700 }, { "name": "Berlin Township", "code": 7720 }, { "name": "Berlin Township", "code": 7760 }, { "name": "Berrien Township", "code": 7820 }, { "name": "Bertrand Township", "code": 7920 }, { "name": "Bessemer Township", "code": 7980 }, { "name": "City of Bessemer", "code": 7960 }, { "name": "Bethany Township", "code": 8020 }, { "name": "Bethel Township", "code": 8060 }, { "name": "Big Creek Township", "code": 8220 }, { "name": "Big Prairie Township", "code": 8280 }, { "name": "Big Rapids Township", "code": 8320 }, { "name": "City of Big Rapids", "code": 8300 }, { "name": "Billings Township", "code": 8360 }, { "name": "Bingham Township", "code": 8400 }, { "name": "Bingham Township", "code": 8420 }, { "name": "Bingham Township", "code": 8440 }, { "name": "Birch Run Township", "code": 8560 }, { "name": "City of Birmingham", "code": 8640 }, { "name": "Bismark Township", "code": 8700 }, { "name": "Blackman Township", "code": 8760 }, { "name": "Blaine Township", "code": 8840 }, { "name": "Blair Township", "code": 8880 }, { "name": "Blendon Township", "code": 8940 }, { "name": "Bliss Township", "code": 8980 }, { "name": "Blissfield Township", "code": 9020 }, { "name": "Bloomer Township", "code": 9040 }, { "name": "Bloomfield Township", "code": 9060 }, { "name": "Bloomfield Township", "code": 9080 }, { "name": "Bloomfield Township", "code": 9110 }, { "name": "City of Bloomfield Hills", "code": 9180 }, { "name": "Bloomingdale Township", "code": 9240 }, { "name": "Blue Lake Township", "code": 9320 }, { "name": "Blue Lake Township", "code": 9340 }, { "name": "Blumfield Township", "code": 9400 }, { "name": "Boardman Township", "code": 9440 }, { "name": "Bohemia Township", "code": 9460 }, { "name": "Bois Blanc Township", "code": 9500 }, { "name": "Boon Township", "code": 9580 }, { "name": "Boston Township", "code": 9680 }, { "name": "Bourret Township", "code": 9720 }, { "name": "Bowne Township", "code": 9780 }, { "name": "City of Boyne City", "code": 9820 }, { "name": "Boyne Valley Township", "code": 9860 }, { "name": "Brady Township", "code": 9920 }, { "name": "Brady Township", "code": 9940 }, { "name": "Brampton Township", "code": 9980 }, { "name": "Branch Township", "code": 10020 }, { "name": "Brandon Township", "code": 10040 }, { "name": "Brant Township", "code": 10100 }, { "name": "Breen Township", "code": 10200 }, { "name": "Breitung Township", "code": 10220 }, { "name": "Brevort Township", "code": 10360 }, { "name": "Bridgehampton Township", "code": 10420 }, { "name": "Bridgeport Township", "code": 10460 }, { "name": "Bridgeton Township", "code": 10500 }, { "name": "Bridgewater Township", "code": 10560 }, { "name": "City of Bridgman", "code": 10580 }, { "name": "Brighton Township", "code": 10640 }, { "name": "City of Brighton", "code": 10620 }, { "name": "Briley Township", "code": 10660 }, { "name": "Brockway Township", "code": 10820 }, { "name": "Bronson Township", "code": 10880 }, { "name": "City of Bronson", "code": 10860 }, { "name": "Brookfield Township", "code": 10920 }, { "name": "Brookfield Township", "code": 10940 }, { "name": "Brooks Township", "code": 11060 }, { "name": "Broomfield Township", "code": 11140 }, { "name": "Brown Township", "code": 11160 }, { "name": "City of Brown City", "code": 11180 }, { "name": "Brownstown Township", "code": 11220 }, { "name": "Bruce Township", "code": 11280 }, { "name": "Bruce Township", "code": 11300 }, { "name": "City of Buchanan", "code": 11400 }, { "name": "Buchanan Township", "code": 11420 }, { "name": "Buckeye Township", "code": 11440 }, { "name": "Buel Township", "code": 11540 }, { "name": "Buena Vista Township", "code": 11560 }, { "name": "Bunker Hill Township", "code": 11640 }, { "name": "Burdell Township", "code": 11680 }, { "name": "Burleigh Township", "code": 11740 }, { "name": "Burlington Township", "code": 11820 }, { "name": "Burlington Township", "code": 11840 }, { "name": "Burns Township", "code": 11880 }, { "name": "Burnside Township", "code": 11900 }, { "name": "Burr Oak Township", "code": 11940 }, { "name": "Burt Township", "code": 11960 }, { "name": "Burt Township", "code": 11980 }, { "name": "Burtchville Township", "code": 12020 }, { "name": "City of Burton", "code": 12060 }, { "name": "Bushnell Township", "code": 12120 }, { "name": "Butler Township", "code": 12140 }, { "name": "Butman Township", "code": 12180 }, { "name": "Butterfield Township", "code": 12200 }, { "name": "Byron Township", "code": 12240 }, { "name": "City of Cadillac", "code": 12320 }, { "name": "Caldwell Township", "code": 12440 }, { "name": "Caledonia Township", "code": 12460 }, { "name": "Caledonia Township", "code": 12500 }, { "name": "Caledonia Township", "code": 12520 }, { "name": "California Township", "code": 12560 }, { "name": "Calumet Township", "code": 12600 }, { "name": "Calvin Township", "code": 12620 }, { "name": "Cambria Township", "code": 12700 }, { "name": "Cambridge Township", "code": 12720 }, { "name": "Camden Township", "code": 12780 }, { "name": "Campbell Township", "code": 12840 }, { "name": "Cannon Township", "code": 13080 }, { "name": "Canton Township", "code": 13120 }, { "name": "Carlton Township", "code": 13340 }, { "name": "Carmel Township", "code": 13380 }, { "name": "City of Caro", "code": 13420 }, { "name": "Carp Lake Township", "code": 13500 }, { "name": "Carp Lake Township", "code": 13520 }, { "name": "Carrollton Township", "code": 13540 }, { "name": "City of Carson City", "code": 13600 }, { "name": "Cascade Township", "code": 13660 }, { "name": "Casco Township", "code": 13700 }, { "name": "Casco Township", "code": 13720 }, { "name": "Case Township", "code": 13740 }, { "name": "City of Caseville", "code": 13760 }, { "name": "Caseville Township", "code": 13780 }, { "name": "Casnovia Township", "code": 13840 }, { "name": "City of Caspian", "code": 13860 }, { "name": "Castleton Township", "code": 13960 }, { "name": "Cato Township", "code": 14000 }, { "name": "Cedar Township", "code": 14040 }, { "name": "Cedar Creek Township", "code": 14100 }, { "name": "Cedar Creek Township", "code": 14120 }, { "name": "City of Cedar Springs", "code": 14200 }, { "name": "Cedarville Township", "code": 14240 }, { "name": "Center Township", "code": 14300 }, { "name": "City of Center Line", "code": 14320 }, { "name": "Centerville Township", "code": 14340 }, { "name": "Central Lake Township", "code": 14420 }, { "name": "Champion Township", "code": 14540 }, { "name": "Chandler Township", "code": 14560 }, { "name": "Chandler Township", "code": 14600 }, { "name": "Chapin Township", "code": 14660 }, { "name": "Charleston Township", "code": 14720 }, { "name": "Charlevoix Township", "code": 14800 }, { "name": "City of Charlevoix", "code": 14780 }, { "name": "City of Charlotte", "code": 14820 }, { "name": "Charlton Township", "code": 14840 }, { "name": "Chase Township", "code": 14880 }, { "name": "Chassell Township", "code": 14920 }, { "name": "City of Cheboygan", "code": 15000 }, { "name": "City of Chelsea", "code": 15020 }, { "name": "Cherry Grove Township", "code": 15060 }, { "name": "Cherry Valley Township", "code": 15100 }, { "name": "Chesaning Township", "code": 15160 }, { "name": "Cheshire Township", "code": 15200 }, { "name": "Chester Township", "code": 15260 }, { "name": "Chester Township", "code": 15280 }, { "name": "Chester Township", "code": 15300 }, { "name": "Chesterfield Township", "code": 15340 }, { "name": "Chestonia Township", "code": 15380 }, { "name": "Chikaming Township", "code": 15480 }, { "name": "China Township", "code": 15540 }, { "name": "Chippewa Township", "code": 15560 }, { "name": "Chippewa Township", "code": 15580 }, { "name": "Chippewa Township", "code": 15600 }, { "name": "Chocolay Township", "code": 15660 }, { "name": "Churchill Township", "code": 15740 }, { "name": "Clam Lake Township", "code": 15860 }, { "name": "Clam Union Township", "code": 15900 }, { "name": "City of Clare", "code": 15920 }, { "name": "Clarence Township", "code": 15960 }, { "name": "Clarendon Township", "code": 16020 }, { "name": "Clark Township", "code": 16060 }, { "name": "City of Clawson", "code": 16160 }, { "name": "Clay Township", "code": 16180 }, { "name": "Clay Banks Township", "code": 16200 }, { "name": "Clayton Township", "code": 16240 }, { "name": "Clayton Township", "code": 16260 }, { "name": "Clearwater Township", "code": 16340 }, { "name": "Clement Township", "code": 16360 }, { "name": "Cleon Township", "code": 16380 }, { "name": "Cleveland Township", "code": 16400 }, { "name": "Climax Township", "code": 16460 }, { "name": "Clinton Township", "code": 16500 }, { "name": "Clinton Township", "code": 16520 }, { "name": "Clinton Township", "code": 16540 }, { "name": "City of Clio", "code": 16620 }, { "name": "Clyde Township", "code": 16720 }, { "name": "Clyde Township", "code": 16760 }, { "name": "Coe Township", "code": 16880 }, { "name": "Cohoctah Township", "code": 16920 }, { "name": "Cold Springs Township", "code": 17000 }, { "name": "City of Coldwater", "code": 17020 }, { "name": "Coldwater Township", "code": 17040 }, { "name": "Coldwater Township", "code": 17060 }, { "name": "City of Coleman", "code": 17100 }, { "name": "Colfax Township", "code": 17120 }, { "name": "Colfax Township", "code": 17140 }, { "name": "Colfax Township", "code": 17160 }, { "name": "Colfax Township", "code": 17180 }, { "name": "Colfax Township", "code": 17200 }, { "name": "Coloma Township", "code": 17340 }, { "name": "City of Coloma", "code": 17320 }, { "name": "Colon Township", "code": 17370 }, { "name": "Columbia Township", "code": 17400 }, { "name": "Columbia Township", "code": 17420 }, { "name": "Columbia Township", "code": 17440 }, { "name": "Columbus Township", "code": 17480 }, { "name": "Columbus Township", "code": 17520 }, { "name": "Comins Township", "code": 17600 }, { "name": "Commerce Township", "code": 17640 }, { "name": "Comstock Township", "code": 17680 }, { "name": "Concord Township", "code": 17760 }, { "name": "Constantine Township", "code": 17860 }, { "name": "Convis Township", "code": 17880 }, { "name": "Conway Township", "code": 17920 }, { "name": "Cooper Township", "code": 17980 }, { "name": "City of Coopersville", "code": 18020 }, { "name": "Cornell Township", "code": 18280 }, { "name": "City of Corunna", "code": 18300 }, { "name": "Corwith Township", "code": 18320 }, { "name": "Cottrellville Township", "code": 18400 }, { "name": "Courtland Township", "code": 18500 }, { "name": "Covert Township", "code": 18560 }, { "name": "Covington Township", "code": 18600 }, { "name": "Crockery Township", "code": 18800 }, { "name": "Cross Village Township", "code": 18900 }, { "name": "City of Croswell", "code": 18920 }, { "name": "Croton Township", "code": 18980 }, { "name": "Crystal Township", "code": 19080 }, { "name": "Crystal Township", "code": 19100 }, { "name": "Crystal Falls Township", "code": 19150 }, { "name": "City of Crystal Falls", "code": 19140 }, { "name": "Crystal Lake Township", "code": 19180 }, { "name": "Cumming Township", "code": 19260 }, { "name": "Curtis Township", "code": 19320 }, { "name": "Custer Township", "code": 19400 }, { "name": "Custer Township", "code": 19440 }, { "name": "Custer Township", "code": 19460 }, { "name": "Dafter Township", "code": 19540 }, { "name": "Daggett Township", "code": 19580 }, { "name": "Dallas Township", "code": 19620 }, { "name": "Dalton Township", "code": 19660 }, { "name": "Danby Township", "code": 19720 }, { "name": "Davison Township", "code": 19900 }, { "name": "City of Davison", "code": 19880 }, { "name": "Day Township", "code": 19920 }, { "name": "Dayton Township", "code": 19960 }, { "name": "Dayton Township", "code": 19980 }, { "name": "City of Dearborn", "code": 21000 }, { "name": "City of Dearborn Heights", "code": 21020 }, { "name": "Decatur Township", "code": 21060 }, { "name": "Deep River Township", "code": 21120 }, { "name": "Deerfield Township", "code": 21140 }, { "name": "Deerfield Township", "code": 21160 }, { "name": "Deerfield Township", "code": 21200 }, { "name": "Deerfield Township", "code": 21220 }, { "name": "Deerfield Township", "code": 21240 }, { "name": "Delaware Township", "code": 21380 }, { "name": "Delhi Township", "code": 21420 }, { "name": "Delta Township", "code": 21520 }, { "name": "Denmark Township", "code": 21600 }, { "name": "Denton Township", "code": 21640 }, { "name": "Denver Township", "code": 21680 }, { "name": "Denver Township", "code": 21700 }, { "name": "Detour Township", "code": 21770 }, { "name": "City of Detroit", "code": 22000 }, { "name": "City of Dewitt", "code": 22120 }, { "name": "Dewitt Township", "code": 22140 }, { "name": "Dexter Township", "code": 22180 }, { "name": "City of Dexter", "code": 22160 }, { "name": "Dickson Township", "code": 22320 }, { "name": "Dorr Township", "code": 22680 }, { "name": "Douglass Township", "code": 22760 }, { "name": "Dover Township", "code": 22800 }, { "name": "Dover Township", "code": 22820 }, { "name": "Dover Township", "code": 22840 }, { "name": "City of Dowagiac", "code": 22880 }, { "name": "Doyle Township", "code": 22960 }, { "name": "Drummond Township", "code": 23080 }, { "name": "Dryden Township", "code": 23160 }, { "name": "Duncan Township", "code": 23340 }, { "name": "Dundee Township", "code": 23400 }, { "name": "Duplain Township", "code": 23460 }, { "name": "City of Durand", "code": 23500 }, { "name": "Dwight Township", "code": 23540 }, { "name": "Eagle Township", "code": 23580 }, { "name": "Eagle Harbor Township", "code": 23620 }, { "name": "East Bay Township", "code": 23800 }, { "name": "East China Township", "code": 23820 }, { "name": "City of East Grand Rapids", "code": 23980 }, { "name": "City of East Jordan", "code": 24020 }, { "name": "City of East Lansing", "code": 24120 }, { "name": "City of East Tawas", "code": 24420 }, { "name": "Easton Township", "code": 24220 }, { "name": "City of Eastpointe", "code": 24290 }, { "name": "Eaton Township", "code": 24520 }, { "name": "Eaton Rapids Township", "code": 24560 }, { "name": "City of Eaton Rapids", "code": 24540 }, { "name": "Echo Township", "code": 24640 }, { "name": "Eckford Township", "code": 24700 }, { "name": "City of Ecorse", "code": 24740 }, { "name": "Eden Township", "code": 24800 }, { "name": "Eden Township", "code": 24820 }, { "name": "Edenville Township", "code": 24830 }, { "name": "Edwards Township", "code": 25020 }, { "name": "Egelston Township", "code": 25080 }, { "name": "Elba Township", "code": 25120 }, { "name": "Elba Township", "code": 25160 }, { "name": "Elbridge Township", "code": 25200 }, { "name": "Elk Township", "code": 25260 }, { "name": "Elk Township", "code": 25280 }, { "name": "Elk Rapids Township", "code": 25340 }, { "name": "Elkland Township", "code": 25300 }, { "name": "Ellington Township", "code": 25380 }, { "name": "Ellis Township", "code": 25400 }, { "name": "Ellsworth Township", "code": 25440 }, { "name": "Elm River Township", "code": 25660 }, { "name": "Elmer Township", "code": 25500 }, { "name": "Elmer Township", "code": 25540 }, { "name": "Elmira Township", "code": 25620 }, { "name": "Elmwood Township", "code": 25700 }, { "name": "Elmwood Township", "code": 25720 }, { "name": "Ely Township", "code": 25820 }, { "name": "Emerson Township", "code": 25880 }, { "name": "Emmett Township", "code": 25935 }, { "name": "Emmett Township", "code": 25960 }, { "name": "Empire Township", "code": 26000 }, { "name": "Ensign Township", "code": 26140 }, { "name": "Ensley Township", "code": 26160 }, { "name": "Enterprise Township", "code": 26200 }, { "name": "Erie Township", "code": 26320 }, { "name": "Erwin Township", "code": 26340 }, { "name": "Escanaba Township", "code": 26380 }, { "name": "City of Escanaba", "code": 26360 }, { "name": "Essex Township", "code": 26400 }, { "name": "City of Essexville", "code": 26420 }, { "name": "Eureka Township", "code": 26520 }, { "name": "Evangeline Township", "code": 26580 }, { "name": "Evart Township", "code": 26660 }, { "name": "City of Evart", "code": 26640 }, { "name": "Eveline Township", "code": 26680 }, { "name": "Everett Township", "code": 26700 }, { "name": "Evergreen Township", "code": 26720 }, { "name": "Evergreen Township", "code": 26740 }, { "name": "Ewing Township", "code": 26840 }, { "name": "Excelsior Township", "code": 26860 }, { "name": "Exeter Township", "code": 26880 }, { "name": "Fabius Township", "code": 26920 }, { "name": "Fairbanks Township", "code": 26960 }, { "name": "Fairfield Township", "code": 27020 }, { "name": "Fairfield Township", "code": 27040 }, { "name": "Fairgrove Township", "code": 27100 }, { "name": "Fairhaven Township", "code": 27120 }, { "name": "Fairplain Township", "code": 27180 }, { "name": "Faithorn Township", "code": 27300 }, { "name": "City of Farmington", "code": 27380 }, { "name": "City of Farmington Hills", "code": 27440 }, { "name": "Fawn River Township", "code": 27540 }, { "name": "Fayette Township", "code": 27580 }, { "name": "Felch Township", "code": 27660 }, { "name": "City of Fennville", "code": 27740 }, { "name": "Fenton Township", "code": 27780 }, { "name": "City of Fenton", "code": 27760 }, { "name": "City of Ferndale", "code": 27880 }, { "name": "Ferris Township", "code": 27900 }, { "name": "Ferry Township", "code": 27940 }, { "name": "City of Ferrysburg", "code": 27960 }, { "name": "Fife Lake Township", "code": 28020 }, { "name": "Filer Township", "code": 28040 }, { "name": "Fillmore Township", "code": 28120 }, { "name": "City of Flat Rock", "code": 28360 }, { "name": "City of Flint", "code": 29000 }, { "name": "Flint Township", "code": 29020 }, { "name": "Florence Township", "code": 29060 }, { "name": "Flowerfield Township", "code": 29140 }, { "name": "Flushing Township", "code": 29220 }, { "name": "City of Flushing", "code": 29200 }, { "name": "Flynn Township", "code": 29240 }, { "name": "Ford River Township", "code": 29380 }, { "name": "Forest Township", "code": 29400 }, { "name": "Forest Township", "code": 29420 }, { "name": "Forest Township", "code": 29440 }, { "name": "Forest Home Township", "code": 29600 }, { "name": "Forester Township", "code": 29500 }, { "name": "Fork Township", "code": 29680 }, { "name": "Forsyth Township", "code": 29720 }, { "name": "Fort Gratiot Township", "code": 29760 }, { "name": "Foster Township", "code": 29860 }, { "name": "Frankenlust Township", "code": 30180 }, { "name": "Frankenmuth Township", "code": 30220 }, { "name": "City of Frankenmuth", "code": 30200 }, { "name": "City of Frankfort", "code": 30260 }, { "name": "Franklin Township", "code": 30280 }, { "name": "Franklin Township", "code": 30300 }, { "name": "Franklin Township", "code": 30320 }, { "name": "Fraser Township", "code": 30400 }, { "name": "City of Fraser", "code": 30420 }, { "name": "Frederic Township", "code": 30480 }, { "name": "Fredonia Township", "code": 30500 }, { "name": "Freedom Township", "code": 30520 }, { "name": "Freeman Township", "code": 30560 }, { "name": "Freesoil Township", "code": 30620 }, { "name": "Fremont Township", "code": 30680 }, { "name": "City of Fremont", "code": 30700 }, { "name": "Fremont Township", "code": 30720 }, { "name": "Fremont Township", "code": 30740 }, { "name": "Fremont Township", "code": 30760 }, { "name": "Frenchtown Township", "code": 30820 }, { "name": "Friendship Township", "code": 30860 }, { "name": "Frost Township", "code": 30900 }, { "name": "Fruitland Township", "code": 30980 }, { "name": "Fruitport Township", "code": 31020 }, { "name": "Fulton Township", "code": 31080 }, { "name": "City of Gaastra", "code": 31160 }, { "name": "Gaines Township", "code": 31220 }, { "name": "Gaines Township", "code": 31240 }, { "name": "City of Galesburg", "code": 31260 }, { "name": "Galien Township", "code": 31320 }, { "name": "Ganges Township", "code": 31360 }, { "name": "Garden Township", "code": 31400 }, { "name": "City of Garden City", "code": 31420 }, { "name": "Garfield Township", "code": 31540 }, { "name": "Garfield Township", "code": 31560 }, { "name": "Garfield Township", "code": 31580 }, { "name": "Garfield Township", "code": 31600 }, { "name": "Garfield Township", "code": 31620 }, { "name": "Garfield Township", "code": 31640 }, { "name": "City of Gaylord", "code": 31720 }, { "name": "Genesee Township", "code": 31800 }, { "name": "Geneva Township", "code": 31820 }, { "name": "Geneva Township", "code": 31840 }, { "name": "Genoa Township", "code": 31860 }, { "name": "Georgetown Township", "code": 31880 }, { "name": "Germfask Township", "code": 31940 }, { "name": "Gerrish Township", "code": 31960 }, { "name": "City of Gibraltar", "code": 32020 }, { "name": "Gibson Township", "code": 32040 }, { "name": "Gilead Township", "code": 32120 }, { "name": "Gilford Township", "code": 32160 }, { "name": "Gilmore Township", "code": 32180 }, { "name": "Gilmore Township", "code": 32200 }, { "name": "Girard Township", "code": 32280 }, { "name": "City of Gladstone", "code": 32300 }, { "name": "City of Gladwin", "code": 32320 }, { "name": "Gladwin Township", "code": 32340 }, { "name": "Glen Arbor Township", "code": 32380 }, { "name": "City of Gobles", "code": 32640 }, { "name": "Golden Township", "code": 32780 }, { "name": "Goodar Township", "code": 32860 }, { "name": "Goodland Township", "code": 32960 }, { "name": "Goodwell Township", "code": 33000 }, { "name": "Gore Township", "code": 33080 }, { "name": "Gourley Township", "code": 33160 }, { "name": "Grand Blanc Township", "code": 33300 }, { "name": "City of Grand Blanc", "code": 33280 }, { "name": "City of Grand Haven", "code": 33340 }, { "name": "Grand Haven Township", "code": 33360 }, { "name": "Grand Island Township", "code": 33380 }, { "name": "City of Grand Ledge", "code": 33420 }, { "name": "City of Grand Rapids", "code": 34000 }, { "name": "Grand Rapids Township", "code": 34020 }, { "name": "City of Grandville", "code": 34160 }, { "name": "Grant Township", "code": 34200 }, { "name": "Grant Township", "code": 34220 }, { "name": "Grant Township", "code": 34240 }, { "name": "Grant Township", "code": 34260 }, { "name": "Grant Township", "code": 34280 }, { "name": "Grant Township", "code": 34300 }, { "name": "Grant Township", "code": 34320 }, { "name": "Grant Township", "code": 34340 }, { "name": "Grant Township", "code": 34380 }, { "name": "City of Grant", "code": 34360 }, { "name": "Grant Township", "code": 34400 }, { "name": "Grant Township", "code": 34420 }, { "name": "Grass Lake Township", "code": 34500 }, { "name": "Grattan Township", "code": 34560 }, { "name": "Grayling Township", "code": 34660 }, { "name": "City of Grayling", "code": 34640 }, { "name": "Green Township", "code": 34740 }, { "name": "Green Township", "code": 34760 }, { "name": "Green Lake Township", "code": 34960 }, { "name": "Green Oak Township", "code": 35060 }, { "name": "Greenbush Township", "code": 34820 }, { "name": "Greenbush Township", "code": 34840 }, { "name": "Greendale Township", "code": 34860 }, { "name": "Greenland Township", "code": 35000 }, { "name": "Greenleaf Township", "code": 35020 }, { "name": "City of Greenville", "code": 35100 }, { "name": "Greenwood Township", "code": 35120 }, { "name": "Greenwood Township", "code": 35160 }, { "name": "Greenwood Township", "code": 35200 }, { "name": "Greenwood Township", "code": 35220 }, { "name": "Greenwood Township", "code": 35240 }, { "name": "Grim Township", "code": 35340 }, { "name": "Grosse Ile Township", "code": 35420 }, { "name": "City of Grosse Pointe", "code": 35480 }, { "name": "City of Grosse Pointe Farms", "code": 35520 }, { "name": "City of Grosse Pointe Park", "code": 35540 }, { "name": "City of Grosse Pointe Woods", "code": 35580 }, { "name": "Grout Township", "code": 35620 }, { "name": "Groveland Township", "code": 35640 }, { "name": "Gunplain Township", "code": 35720 }, { "name": "Gustin Township", "code": 35740 }, { "name": "Hadley Township", "code": 35840 }, { "name": "Hagar Township", "code": 35860 }, { "name": "Haight Township", "code": 35960 }, { "name": "Hamburg Township", "code": 36100 }, { "name": "Hamilton Township", "code": 36140 }, { "name": "Hamilton Township", "code": 36160 }, { "name": "Hamilton Township", "code": 36180 }, { "name": "Hamlin Township", "code": 36200 }, { "name": "Hamlin Township", "code": 36220 }, { "name": "Hampton Township", "code": 36260 }, { "name": "City of Hamtramck", "code": 36280 }, { "name": "Hancock Township", "code": 36320 }, { "name": "City of Hancock", "code": 36300 }, { "name": "Handy Township", "code": 36340 }, { "name": "Hanover Township", "code": 36400 }, { "name": "Hanover Township", "code": 36420 }, { "name": "City of Harbor Beach", "code": 36460 }, { "name": "City of Harbor Springs", "code": 36560 }, { "name": "Haring Township", "code": 36600 }, { "name": "City of Harper Woods", "code": 36700 }, { "name": "Harris Township", "code": 36760 }, { "name": "City of Harrison", "code": 36800 }, { "name": "Harrison Township", "code": 36820 }, { "name": "Harrisville Township", "code": 36880 }, { "name": "City of Harrisville", "code": 36860 }, { "name": "City of Hart", "code": 36920 }, { "name": "Hart Township", "code": 36940 }, { "name": "Hartford Township", "code": 36980 }, { "name": "City of Hartford", "code": 36960 }, { "name": "Hartland Township", "code": 37040 }, { "name": "Hartwick Township", "code": 37060 }, { "name": "Hastings Township", "code": 37140 }, { "name": "City of Hastings", "code": 37120 }, { "name": "Hatton Township", "code": 37160 }, { "name": "Hawes Township", "code": 37220 }, { "name": "Hay Township", "code": 37300 }, { "name": "Hayes Township", "code": 37320 }, { "name": "Hayes Township", "code": 37340 }, { "name": "Hayes Township", "code": 37360 }, { "name": "Haynes Township", "code": 37380 }, { "name": "City of Hazel Park", "code": 37420 }, { "name": "Hazelton Township", "code": 37440 }, { "name": "Heath Township", "code": 37460 }, { "name": "Hebron Township", "code": 37480 }, { "name": "Helena Township", "code": 37500 }, { "name": "Hematite Township", "code": 37580 }, { "name": "Henderson Township", "code": 37640 }, { "name": "Hendricks Township", "code": 37660 }, { "name": "Henrietta Township", "code": 37700 }, { "name": "Hersey Township", "code": 37840 }, { "name": "Hiawatha Township", "code": 37940 }, { "name": "Higgins Township", "code": 38020 }, { "name": "Highland Township", "code": 38080 }, { "name": "Highland Township", "code": 38100 }, { "name": "City of Highland Park", "code": 38180 }, { "name": "Hill Township", "code": 38300 }, { "name": "Hillman Township", "code": 38400 }, { "name": "City of Hillsdale", "code": 38460 }, { "name": "Hillsdale Township", "code": 38480 }, { "name": "Hinton Township", "code": 38540 }, { "name": "Holland Township", "code": 38620 }, { "name": "Holland Township", "code": 38660 }, { "name": "City of Holland", "code": 38640 }, { "name": "Holly Township", "code": 38720 }, { "name": "Holmes Township", "code": 38760 }, { "name": "Holton Township", "code": 38820 }, { "name": "Home Township", "code": 38840 }, { "name": "Home Township", "code": 38860 }, { "name": "Homer Township", "code": 38940 }, { "name": "Homer Township", "code": 38980 }, { "name": "Homestead Township", "code": 39000 }, { "name": "Hope Township", "code": 39120 }, { "name": "Hope Township", "code": 39160 }, { "name": "Hopkins Township", "code": 39200 }, { "name": "Horton Township", "code": 39320 }, { "name": "City of Houghton", "code": 39360 }, { "name": "Houghton Township", "code": 39380 }, { "name": "Howard Township", "code": 39480 }, { "name": "City of Howell", "code": 39540 }, { "name": "Howell Township", "code": 39560 }, { "name": "Hudson Township", "code": 39700 }, { "name": "Hudson Township", "code": 39740 }, { "name": "City of Hudson", "code": 39720 }, { "name": "Hudson Township", "code": 39760 }, { "name": "City of Hudsonville", "code": 39800 }, { "name": "Hulbert Township", "code": 39860 }, { "name": "Humboldt Township", "code": 39940 }, { "name": "Hume Township", "code": 39960 }, { "name": "City of Huntington Woods", "code": 40000 }, { "name": "Huron Township", "code": 40020 }, { "name": "Huron Township", "code": 40040 }, { "name": "Ida Township", "code": 40260 }, { "name": "Imlay Township", "code": 40300 }, { "name": "City of Imlay City", "code": 40320 }, { "name": "Independence Township", "code": 40400 }, { "name": "Indianfields Township", "code": 40440 }, { "name": "Ingallston Township", "code": 40600 }, { "name": "Ingersoll Township", "code": 40620 }, { "name": "Ingham Township", "code": 40640 }, { "name": "City of Inkster", "code": 40680 }, { "name": "Inland Township", "code": 40700 }, { "name": "Interior Township", "code": 40760 }, { "name": "Inverness Township", "code": 40820 }, { "name": "Inwood Township", "code": 40840 }, { "name": "Ionia Township", "code": 40880 }, { "name": "City of Ionia", "code": 40860 }, { "name": "Iosco Township", "code": 40900 }, { "name": "Ira Township", "code": 40920 }, { "name": "City of Iron Mountain", "code": 40960 }, { "name": "Iron River Township", "code": 41000 }, { "name": "City of Iron River", "code": 40980 }, { "name": "Ironwood Township", "code": 41080 }, { "name": "City of Ironwood", "code": 41060 }, { "name": "Irving Township", "code": 41120 }, { "name": "Isabella Township", "code": 41160 }, { "name": "Ishpeming Township", "code": 41240 }, { "name": "City of Ishpeming", "code": 41220 }, { "name": "City of Ithaca", "code": 41340 }, { "name": "City of Jackson", "code": 41420 }, { "name": "James Township", "code": 41480 }, { "name": "Jamestown Township", "code": 41520 }, { "name": "Jasper Township", "code": 41560 }, { "name": "Jefferson Township", "code": 41600 }, { "name": "Jefferson Township", "code": 41620 }, { "name": "Jerome Township", "code": 41760 }, { "name": "Johnstown Township", "code": 41860 }, { "name": "Jonesfield Township", "code": 41900 }, { "name": "City of Jonesville", "code": 41920 }, { "name": "Jordan Township", "code": 41960 }, { "name": "Joyfield Township", "code": 42000 }, { "name": "Juniata Township", "code": 42140 }, { "name": "Kalamazoo Township", "code": 42180 }, { "name": "City of Kalamazoo", "code": 42160 }, { "name": "Kalamo Township", "code": 42220 }, { "name": "Kalkaska Township", "code": 42280 }, { "name": "Kasson Township", "code": 42320 }, { "name": "Kawkawlin Township", "code": 42360 }, { "name": "Kearney Township", "code": 42400 }, { "name": "City of Keego Harbor", "code": 42460 }, { "name": "Keeler Township", "code": 42500 }, { "name": "Keene Township", "code": 42520 }, { "name": "Kenockee Township", "code": 42740 }, { "name": "City of Kentwood", "code": 42820 }, { "name": "Kimball Township", "code": 43160 }, { "name": "Kinderhook Township", "code": 43260 }, { "name": "City of Kingsford", "code": 43300 }, { "name": "Kingston Township", "code": 43400 }, { "name": "Kinross Township", "code": 43480 }, { "name": "Klacking Township", "code": 43640 }, { "name": "Kochville Township", "code": 43800 }, { "name": "Koehler Township", "code": 43820 }, { "name": "Koylton Township", "code": 43880 }, { "name": "Krakow Township", "code": 43900 }, { "name": "Lafayette Township", "code": 44080 }, { "name": "Lagrange Township", "code": 44140 }, { "name": "City of Laingsburg", "code": 44200 }, { "name": "Laird Township", "code": 44220 }, { "name": "Lake Township", "code": 44240 }, { "name": "Lake Township", "code": 44260 }, { "name": "Lake Township", "code": 44300 }, { "name": "Lake Township", "code": 44320 }, { "name": "Lake Township", "code": 44360 }, { "name": "Lake Township", "code": 44380 }, { "name": "Lake Township", "code": 44400 }, { "name": "City of Lake Angelus", "code": 44440 }, { "name": "City of Lake City", "code": 44480 }, { "name": "Lakefield Township", "code": 44540 }, { "name": "Lakefield Township", "code": 44560 }, { "name": "Laketon Township", "code": 45160 }, { "name": "Laketown Township", "code": 45180 }, { "name": "Lamotte Township", "code": 45460 }, { "name": "Lanse Township", "code": 45560 }, { "name": "Lansing Township", "code": 46020 }, { "name": "City of Lansing", "code": 46000 }, { "name": "City of Lapeer", "code": 46040 }, { "name": "Lapeer Township", "code": 46060 }, { "name": "Larkin Township", "code": 46160 }, { "name": "Lasalle Township", "code": 46260 }, { "name": "City of Lathrup Village", "code": 46320 }, { "name": "Lawrence Township", "code": 46460 }, { "name": "Leavitt Township", "code": 46560 }, { "name": "Lebanon Township", "code": 46580 }, { "name": "Lee Township", "code": 46600 }, { "name": "Lee Township", "code": 46620 }, { "name": "Lee Township", "code": 46640 }, { "name": "Leelanau Township", "code": 46700 }, { "name": "Leighton Township", "code": 46760 }, { "name": "Leland Township", "code": 46820 }, { "name": "Lenox Township", "code": 46900 }, { "name": "Leoni Township", "code": 46980 }, { "name": "Leonidas Township", "code": 47020 }, { "name": "Leroy Township", "code": 47060 }, { "name": "Leroy Township", "code": 47080 }, { "name": "Leroy Township", "code": 47120 }, { "name": "Leslie Township", "code": 47200 }, { "name": "City of Leslie", "code": 47180 }, { "name": "Lexington Township", "code": 47300 }, { "name": "Liberty Township", "code": 47360 }, { "name": "Liberty Township", "code": 47380 }, { "name": "Lilley Township", "code": 47440 }, { "name": "Lima Township", "code": 47460 }, { "name": "Limestone Township", "code": 47540 }, { "name": "Lincoln Township", "code": 47580 }, { "name": "Lincoln Township", "code": 47600 }, { "name": "Lincoln Township", "code": 47620 }, { "name": "Lincoln Township", "code": 47640 }, { "name": "Lincoln Township", "code": 47660 }, { "name": "Lincoln Township", "code": 47680 }, { "name": "Lincoln Township", "code": 47700 }, { "name": "Lincoln Township", "code": 47720 }, { "name": "City of Lincoln Park", "code": 47800 }, { "name": "City of Linden", "code": 47820 }, { "name": "Litchfield Township", "code": 48000 }, { "name": "City of Litchfield", "code": 47980 }, { "name": "Little Traverse Township", "code": 48080 }, { "name": "Littlefield Township", "code": 48020 }, { "name": "Livingston Township", "code": 48140 }, { "name": "City of Livonia", "code": 49000 }, { "name": "Locke Township", "code": 49040 }, { "name": "Lockport Township", "code": 49060 }, { "name": "Lodi Township", "code": 49120 }, { "name": "Logan Township", "code": 49140 }, { "name": "Logan Township", "code": 49160 }, { "name": "London Township", "code": 49180 }, { "name": "Long Lake Township", "code": 49240 }, { "name": "Long Rapids Township", "code": 49360 }, { "name": "Loud Township", "code": 49480 }, { "name": "Lovells Township", "code": 49520 }, { "name": "City of Lowell", "code": 49540 }, { "name": "Lowell Township", "code": 49560 }, { "name": "City of Ludington", "code": 49640 }, { "name": "City of Luna Pier", "code": 49700 }, { "name": "Lyndon Township", "code": 49780 }, { "name": "Lynn Township", "code": 49800 }, { "name": "Lyon Township", "code": 49820 }, { "name": "Lyon Township", "code": 49840 }, { "name": "Lyons Township", "code": 49920 }, { "name": "City of Mackinac Island", "code": 50280 }, { "name": "Mackinaw Township", "code": 50300 }, { "name": "Macomb Township", "code": 50480 }, { "name": "Macon Township", "code": 50520 }, { "name": "Madison Township", "code": 50540 }, { "name": "City of Madison Heights", "code": 50560 }, { "name": "Mancelona Township", "code": 50640 }, { "name": "Manchester Township", "code": 50680 }, { "name": "Manistee Township", "code": 50740 }, { "name": "City of Manistee", "code": 50720 }, { "name": "Manistique Township", "code": 50780 }, { "name": "City of Manistique", "code": 50760 }, { "name": "Manlius Township", "code": 50840 }, { "name": "Mansfield Township", "code": 50860 }, { "name": "City of Manton", "code": 50880 }, { "name": "Maple Forest Township", "code": 50940 }, { "name": "Maple Grove Township", "code": 50960 }, { "name": "Maple Grove Township", "code": 51000 }, { "name": "Maple Grove Township", "code": 51060 }, { "name": "Maple Ridge Township", "code": 51220 }, { "name": "Maple Ridge Township", "code": 51260 }, { "name": "Maple River Township", "code": 51280 }, { "name": "Maple Valley Township", "code": 51340 }, { "name": "Maple Valley Township", "code": 51380 }, { "name": "Marathon Township", "code": 51420 }, { "name": "Marcellus Township", "code": 51480 }, { "name": "Marengo Township", "code": 51520 }, { "name": "Marenisco Township", "code": 51560 }, { "name": "Marilla Township", "code": 51580 }, { "name": "City of Marine City", "code": 51600 }, { "name": "Marion Township", "code": 51620 }, { "name": "Marion Township", "code": 51640 }, { "name": "Marion Township", "code": 51680 }, { "name": "Marion Township", "code": 51700 }, { "name": "Marion Township", "code": 51720 }, { "name": "Markey Township", "code": 51780 }, { "name": "Marlette Township", "code": 51840 }, { "name": "City of Marlette", "code": 51820 }, { "name": "Marquette Township", "code": 51880 }, { "name": "Marquette Township", "code": 51920 }, { "name": "City of Marquette", "code": 51900 }, { "name": "Marshall Township", "code": 51960 }, { "name": "City of Marshall", "code": 51940 }, { "name": "Martin Township", "code": 52000 }, { "name": "Martiny Township", "code": 52060 }, { "name": "City of Marysville", "code": 52080 }, { "name": "Mason Township", "code": 52120 }, { "name": "Mason Township", "code": 52140 }, { "name": "City of Mason", "code": 52180 }, { "name": "Masonville Township", "code": 52220 }, { "name": "Mastodon Township", "code": 52300 }, { "name": "Matchwood Township", "code": 52320 }, { "name": "Mathias Township", "code": 52360 }, { "name": "Matteson Township", "code": 52400 }, { "name": "Mayfield Township", "code": 52480 }, { "name": "Mayfield Township", "code": 52500 }, { "name": "City of McBain", "code": 49980 }, { "name": "McKinley Township", "code": 50340 }, { "name": "McKinley Township", "code": 50360 }, { "name": "McMillan Township", "code": 50440 }, { "name": "McMillan Township", "code": 50460 }, { "name": "Meade Township", "code": 52600 }, { "name": "Meade Township", "code": 52640 }, { "name": "Mecosta Township", "code": 52780 }, { "name": "Medina Township", "code": 52820 }, { "name": "Mellen Township", "code": 52860 }, { "name": "Melrose Township", "code": 52880 }, { "name": "City of Melvindale", "code": 52940 }, { "name": "City of Memphis", "code": 52960 }, { "name": "Mendon Township", "code": 53000 }, { "name": "Menominee Township", "code": 53040 }, { "name": "City of Menominee", "code": 53020 }, { "name": "Mentor Township", "code": 53100 }, { "name": "Mentor Township", "code": 53120 }, { "name": "Meridian Township", "code": 53140 }, { "name": "Merrill Township", "code": 53160 }, { "name": "Merritt Township", "code": 53220 }, { "name": "Metamora Township", "code": 53360 }, { "name": "Metz Township", "code": 53440 }, { "name": "Meyer Township", "code": 53460 }, { "name": "Michigamme Township", "code": 53540 }, { "name": "Middle Branch Township", "code": 53660 }, { "name": "Middlebury Township", "code": 53680 }, { "name": "Midland Township", "code": 53800 }, { "name": "City of Midland", "code": 53780 }, { "name": "Mikado Township", "code": 53880 }, { "name": "Milan Township", "code": 53900 }, { "name": "City of Milan", "code": 53920 }, { "name": "Milford Township", "code": 53980 }, { "name": "Millbrook Township", "code": 54020 }, { "name": "Millen Township", "code": 54060 }, { "name": "Millington Township", "code": 54240 }, { "name": "Mills Township", "code": 54320 }, { "name": "Mills Township", "code": 54340 }, { "name": "Milton Township", "code": 54440 }, { "name": "Milton Township", "code": 54460 }, { "name": "Minden Township", "code": 54540 }, { "name": "Mitchell Township", "code": 54740 }, { "name": "Moffatt Township", "code": 54800 }, { "name": "Moltke Township", "code": 54860 }, { "name": "Monitor Township", "code": 54980 }, { "name": "City of Monroe", "code": 55020 }, { "name": "Monroe Township", "code": 55040 }, { "name": "Monroe Township", "code": 55060 }, { "name": "Montague Township", "code": 55120 }, { "name": "City of Montague", "code": 55100 }, { "name": "Montcalm Township", "code": 55140 }, { "name": "Monterey Township", "code": 55200 }, { "name": "Montmorency Township", "code": 55240 }, { "name": "Montrose Township", "code": 55300 }, { "name": "City of Montrose", "code": 55280 }, { "name": "Moore Township", "code": 55320 }, { "name": "Moorland Township", "code": 55440 }, { "name": "Moran Township", "code": 55480 }, { "name": "City of Morenci", "code": 55500 }, { "name": "Morton Township", "code": 55600 }, { "name": "Moscow Township", "code": 55640 }, { "name": "Mottville Township", "code": 55780 }, { "name": "City of Mt Clemens", "code": 55820 }, { "name": "Mt Forest Township", "code": 55920 }, { "name": "Mt Haley Township", "code": 55940 }, { "name": "Mt Morris Township", "code": 55980 }, { "name": "City of Mt Morris", "code": 55960 }, { "name": "City of Mt Pleasant", "code": 56020 }, { "name": "Mueller Township", "code": 56060 }, { "name": "Mullett Township", "code": 56100 }, { "name": "Mundy Township", "code": 56160 }, { "name": "Munising Township", "code": 56220 }, { "name": "City of Munising", "code": 56200 }, { "name": "Munro Township", "code": 56280 }, { "name": "City of Muskegon", "code": 56320 }, { "name": "Muskegon Township", "code": 56340 }, { "name": "City of Muskegon Heights", "code": 56360 }, { "name": "Mussey Township", "code": 56380 }, { "name": "Nadeau Township", "code": 56440 }, { "name": "Nahma Township", "code": 56500 }, { "name": "Napoleon Township", "code": 56640 }, { "name": "Negaunee Township", "code": 56880 }, { "name": "City of Negaunee", "code": 56860 }, { "name": "Nelson Township", "code": 56920 }, { "name": "Nester Township", "code": 56980 }, { "name": "City of New Baltimore", "code": 57100 }, { "name": "New Buffalo Township", "code": 57230 }, { "name": "City of New Buffalo", "code": 57220 }, { "name": "New Field Township", "code": 57300 }, { "name": "New Haven Township", "code": 57360 }, { "name": "New Haven Township", "code": 57400 }, { "name": "Newark Township", "code": 57040 }, { "name": "City of Newaygo", "code": 57080 }, { "name": "Newberg Township", "code": 57120 }, { "name": "Newkirk Township", "code": 57480 }, { "name": "Newton Township", "code": 57620 }, { "name": "Newton Township", "code": 57640 }, { "name": "Niles Township", "code": 57780 }, { "name": "City of Niles", "code": 57760 }, { "name": "Noble Township", "code": 57860 }, { "name": "Norman Township", "code": 57900 }, { "name": "North Allis Township", "code": 57940 }, { "name": "North Branch Township", "code": 58090 }, { "name": "City of North Muskegon", "code": 58640 }, { "name": "North Plains Township", "code": 58720 }, { "name": "North Shade Township", "code": 58800 }, { "name": "North Star Township", "code": 58880 }, { "name": "Northfield Township", "code": 58280 }, { "name": "Northville Township", "code": 59000 }, { "name": "City of Northville", "code": 58980 }, { "name": "City of Norton Shores", "code": 59140 }, { "name": "Norvell Township", "code": 59180 }, { "name": "Norway Township", "code": 59240 }, { "name": "City of Norway", "code": 59220 }, { "name": "Norwich Township", "code": 59280 }, { "name": "Norwich Township", "code": 59300 }, { "name": "Norwood Township", "code": 59340 }, { "name": "Nottawa Township", "code": 59360 }, { "name": "Nottawa Township", "code": 59400 }, { "name": "Novesta Township", "code": 59420 }, { "name": "City of Novi", "code": 59440 }, { "name": "Novi Township", "code": 59460 }, { "name": "Nunda Township", "code": 59500 }, { "name": "City of Oak Park", "code": 59920 }, { "name": "Oakfield Township", "code": 59580 }, { "name": "Oakland Township", "code": 59820 }, { "name": "Oceola Township", "code": 60120 }, { "name": "Ocqueoc Township", "code": 60160 }, { "name": "Odessa Township", "code": 60200 }, { "name": "Ogden Township", "code": 60260 }, { "name": "Ogemaw Township", "code": 60300 }, { "name": "Olive Township", "code": 60440 }, { "name": "Olive Township", "code": 60460 }, { "name": "Oliver Township", "code": 60520 }, { "name": "Oliver Township", "code": 60540 }, { "name": "City of Olivet", "code": 60580 }, { "name": "City of Omer", "code": 60660 }, { "name": "City of Onaway", "code": 60680 }, { "name": "Oneida Township", "code": 60700 }, { "name": "Onekama Township", "code": 60760 }, { "name": "Onondaga Township", "code": 60800 }, { "name": "Onota Township", "code": 60820 }, { "name": "Ontonagon Township", "code": 60880 }, { "name": "Ontwa Township", "code": 60900 }, { "name": "Orange Township", "code": 60920 }, { "name": "Orange Township", "code": 60940 }, { "name": "Orangeville Township", "code": 60980 }, { "name": "City of Orchard Lake Village", "code": 61020 }, { "name": "Oregon Township", "code": 61060 }, { "name": "Orient Township", "code": 61080 }, { "name": "Orion Township", "code": 61100 }, { "name": "Orleans Township", "code": 61160 }, { "name": "Oronoko Township", "code": 61180 }, { "name": "Osceola Township", "code": 61260 }, { "name": "Osceola Township", "code": 61280 }, { "name": "Oscoda Township", "code": 61340 }, { "name": "Oshtemo Township", "code": 61400 }, { "name": "Ossineke Township", "code": 61520 }, { "name": "Otisco Township", "code": 61580 }, { "name": "City of Otsego", "code": 61620 }, { "name": "Otsego Township", "code": 61640 }, { "name": "Otsego Lake Township", "code": 61680 }, { "name": "Otto Township", "code": 61780 }, { "name": "Overisel Township", "code": 61820 }, { "name": "Ovid Township", "code": 61840 }, { "name": "Ovid Township", "code": 61880 }, { "name": "City of Ovid", "code": 61860 }, { "name": "Owosso Township", "code": 61960 }, { "name": "City of Owosso", "code": 61940 }, { "name": "Oxford Township", "code": 62040 }, { "name": "Palmyra Township", "code": 62240 }, { "name": "Paradise Township", "code": 62320 }, { "name": "City of Parchment", "code": 62340 }, { "name": "Paris Township", "code": 62360 }, { "name": "Park Township", "code": 62460 }, { "name": "Park Township", "code": 62480 }, { "name": "Parma Township", "code": 62760 }, { "name": "Pavilion Township", "code": 62960 }, { "name": "Paw Paw Township", "code": 63000 }, { "name": "Peacock Township", "code": 63120 }, { "name": "Peaine Township", "code": 63140 }, { "name": "Peninsula Township", "code": 63340 }, { "name": "Penn Township", "code": 63380 }, { "name": "Pennfield Township", "code": 63440 }, { "name": "Pentland Township", "code": 63500 }, { "name": "Pentwater Township", "code": 63560 }, { "name": "Pere Marquette Township", "code": 63600 }, { "name": "Perry Township", "code": 63720 }, { "name": "City of Perry", "code": 63700 }, { "name": "City of Petersburg", "code": 63800 }, { "name": "City of Petoskey", "code": 63820 }, { "name": "Pickford Township", "code": 63980 }, { "name": "Pierson Township", "code": 64040 }, { "name": "City of Pinconning", "code": 64160 }, { "name": "Pinconning Township", "code": 64180 }, { "name": "Pine Township", "code": 64200 }, { "name": "Pine Grove Township", "code": 64280 }, { "name": "Pine River Township", "code": 64360 }, { "name": "Pinora Township", "code": 64440 }, { "name": "Pioneer Township", "code": 64460 }, { "name": "Pipestone Township", "code": 64480 }, { "name": "Pittsfield Township", "code": 64560 }, { "name": "Pittsford Township", "code": 64620 }, { "name": "Plainfield Township", "code": 64640 }, { "name": "Plainfield Township", "code": 64660 }, { "name": "City of Plainwell", "code": 64740 }, { "name": "Platte Township", "code": 64760 }, { "name": "Pleasant Plains Township", "code": 64880 }, { "name": "City of Pleasant Ridge", "code": 64900 }, { "name": "Pleasant View Township", "code": 64960 }, { "name": "Pleasanton Township", "code": 64860 }, { "name": "Plymouth Township", "code": 65080 }, { "name": "City of Plymouth", "code": 65060 }, { "name": "Pointe Aux Barques Township", "code": 65180 }, { "name": "Pokagon Township", "code": 65300 }, { "name": "Polkton Township", "code": 65320 }, { "name": "City of Pontiac", "code": 65440 }, { "name": "Port Austin Township", "code": 65700 }, { "name": "City of Port Huron", "code": 65820 }, { "name": "Port Huron Township", "code": 65840 }, { "name": "Port Sheldon Township", "code": 65940 }, { "name": "Portage Township", "code": 65540 }, { "name": "City of Portage", "code": 65560 }, { "name": "Portage Township", "code": 65600 }, { "name": "Porter Township", "code": 65720 }, { "name": "Porter Township", "code": 65740 }, { "name": "Porter Township", "code": 65760 }, { "name": "Portland Township", "code": 65880 }, { "name": "City of Portland", "code": 65860 }, { "name": "Portsmouth Township", "code": 65980 }, { "name": "Posen Township", "code": 66020 }, { "name": "City of Potterville", "code": 66100 }, { "name": "Powell Township", "code": 66120 }, { "name": "Prairie Ronde Township", "code": 66200 }, { "name": "Prairieville Township", "code": 66260 }, { "name": "Presque Isle Township", "code": 66340 }, { "name": "Pulaski Township", "code": 66440 }, { "name": "Pulawski Township", "code": 66460 }, { "name": "Putnam Township", "code": 66540 }, { "name": "Quincy Township", "code": 66660 }, { "name": "Quincy Township", "code": 66680 }, { "name": "Raber Township", "code": 66760 }, { "name": "Raisin Township", "code": 66840 }, { "name": "Raisinville Township", "code": 66900 }, { "name": "Ransom Township", "code": 67120 }, { "name": "Rapid River Township", "code": 67180 }, { "name": "Ravenna Township", "code": 67300 }, { "name": "Ray Township", "code": 67420 }, { "name": "Reading Township", "code": 67520 }, { "name": "City of Reading", "code": 67500 }, { "name": "Readmond Township", "code": 67540 }, { "name": "Redding Township", "code": 67600 }, { "name": "Redford Township", "code": 67625 }, { "name": "City of Reed City", "code": 67820 }, { "name": "Reeder Township", "code": 67840 }, { "name": "Reno Township", "code": 67960 }, { "name": "Republic Township", "code": 68000 }, { "name": "Resort Township", "code": 68060 }, { "name": "Reynolds Township", "code": 68120 }, { "name": "Rich Township", "code": 68160 }, { "name": "Richfield Township", "code": 68180 }, { "name": "Richfield Township", "code": 68200 }, { "name": "Richland Township", "code": 68260 }, { "name": "Richland Township", "code": 68280 }, { "name": "Richland Township", "code": 68300 }, { "name": "Richland Township", "code": 68320 }, { "name": "Richland Township", "code": 68340 }, { "name": "Richmond Township", "code": 68400 }, { "name": "Richmond Township", "code": 68420 }, { "name": "Richmond Township", "code": 68440 }, { "name": "City of Richmond", "code": 68380 }, { "name": "Ridgeway Township", "code": 68540 }, { "name": "Riga Township", "code": 68580 }, { "name": "Riley Township", "code": 68600 }, { "name": "Riley Township", "code": 68620 }, { "name": "City of River Rouge", "code": 68760 }, { "name": "Riverside Township", "code": 68820 }, { "name": "Riverton Township", "code": 68860 }, { "name": "City of Riverview", "code": 68880 }, { "name": "Rives Township", "code": 68920 }, { "name": "Robinson Township", "code": 69000 }, { "name": "City of Rochester", "code": 69020 }, { "name": "City of Rochester Hills", "code": 69035 }, { "name": "Rock River Township", "code": 69160 }, { "name": "City of Rockford", "code": 69080 }, { "name": "Rockland Township", "code": 69140 }, { "name": "City of Rockwood", "code": 69180 }, { "name": "Rogers Township", "code": 69240 }, { "name": "City of Rogers City", "code": 69260 }, { "name": "Rolland Township", "code": 69300 }, { "name": "Rollin Township", "code": 69340 }, { "name": "Rome Township", "code": 69360 }, { "name": "City of Romulus", "code": 69420 }, { "name": "Ronald Township", "code": 69440 }, { "name": "City of Roosevelt Park", "code": 69520 }, { "name": "Roscommon Township", "code": 69560 }, { "name": "Rose Township", "code": 69580 }, { "name": "Rose Township", "code": 69600 }, { "name": "City of Rose City", "code": 69680 }, { "name": "Rose Lake Township", "code": 69760 }, { "name": "City of Roseville", "code": 69800 }, { "name": "Ross Township", "code": 69820 }, { "name": "Roxand Township", "code": 70020 }, { "name": "City of Royal Oak", "code": 70040 }, { "name": "Royal Oak Township", "code": 70060 }, { "name": "Royalton Township", "code": 70100 }, { "name": "Rubicon Township", "code": 70140 }, { "name": "Rudyard Township", "code": 70220 }, { "name": "Rush Township", "code": 70260 }, { "name": "Rust Township", "code": 70380 }, { "name": "Rutland Township", "code": 70420 }, { "name": "Sage Township", "code": 70500 }, { "name": "Saginaw Township", "code": 70540 }, { "name": "City of Saginaw", "code": 70520 }, { "name": "Sagola Township", "code": 70600 }, { "name": "Salem Township", "code": 71100 }, { "name": "Salem Township", "code": 71130 }, { "name": "City of Saline", "code": 71140 }, { "name": "Saline Township", "code": 71160 }, { "name": "Sanborn Township", "code": 71240 }, { "name": "Sand Beach Township", "code": 71260 }, { "name": "Sands Township", "code": 71460 }, { "name": "Sandstone Township", "code": 71500 }, { "name": "City of Sandusky", "code": 71540 }, { "name": "Sanilac Township", "code": 71580 }, { "name": "Sauble Township", "code": 71680 }, { "name": "Saugatuck Township", "code": 71720 }, { "name": "City of Saugatuck", "code": 71700 }, { "name": "City of Sault Ste Marie", "code": 71740 }, { "name": "Schoolcraft Township", "code": 71840 }, { "name": "Schoolcraft Township", "code": 71880 }, { "name": "Scio Township", "code": 71940 }, { "name": "Sciota Township", "code": 71960 }, { "name": "Scipio Township", "code": 71980 }, { "name": "City of Scottville", "code": 72080 }, { "name": "Sebewa Township", "code": 72120 }, { "name": "Sebewaing Township", "code": 72200 }, { "name": "Secord Township", "code": 72240 }, { "name": "Selma Township", "code": 72380 }, { "name": "Seneca Township", "code": 72440 }, { "name": "Seney Township", "code": 72500 }, { "name": "Seville Township", "code": 72580 }, { "name": "Sharon Township", "code": 72760 }, { "name": "Shelby Township", "code": 72820 }, { "name": "Shelby Township", "code": 72860 }, { "name": "Sheridan Township", "code": 72980 }, { "name": "Sheridan Township", "code": 73000 }, { "name": "Sheridan Township", "code": 73040 }, { "name": "Sheridan Township", "code": 73060 }, { "name": "Sheridan Township", "code": 73080 }, { "name": "Sheridan Township", "code": 73120 }, { "name": "Sherman Township", "code": 73140 }, { "name": "Sherman Township", "code": 73160 }, { "name": "Sherman Township", "code": 73180 }, { "name": "Sherman Township", "code": 73200 }, { "name": "Sherman Township", "code": 73220 }, { "name": "Sherman Township", "code": 73240 }, { "name": "Sherman Township", "code": 73260 }, { "name": "Sherman Township", "code": 73280 }, { "name": "Sherman Township", "code": 73300 }, { "name": "Sherwood Township", "code": 73440 }, { "name": "Shiawassee Township", "code": 73520 }, { "name": "Sidney Township", "code": 73840 }, { "name": "Sigel Township", "code": 73880 }, { "name": "Silver Creek Township", "code": 73940 }, { "name": "Sims Township", "code": 74020 }, { "name": "Skandia Township", "code": 74110 }, { "name": "Slagle Township", "code": 74220 }, { "name": "Sodus Township", "code": 74440 }, { "name": "Solon Township", "code": 74460 }, { "name": "Solon Township", "code": 74500 }, { "name": "Somerset Township", "code": 74560 }, { "name": "Soo Township", "code": 74620 }, { "name": "South Arm Township", "code": 74680 }, { "name": "South Branch Township", "code": 74760 }, { "name": "South Branch Township", "code": 74820 }, { "name": "South Haven Township", "code": 75000 }, { "name": "City of South Haven", "code": 74980 }, { "name": "City of South Lyon", "code": 75100 }, { "name": "Southfield Township", "code": 74920 }, { "name": "City of Southfield", "code": 74900 }, { "name": "City of Southgate", "code": 74960 }, { "name": "Spalding Township", "code": 75350 }, { "name": "Sparta Township", "code": 75440 }, { "name": "Spaulding Township", "code": 75480 }, { "name": "Speaker Township", "code": 75500 }, { "name": "Spencer Township", "code": 75560 }, { "name": "Spring Arbor Township", "code": 75640 }, { "name": "Spring Lake Township", "code": 75840 }, { "name": "Springdale Township", "code": 75680 }, { "name": "City of Springfield", "code": 75700 }, { "name": "Springfield Township", "code": 75720 }, { "name": "Springfield Township", "code": 75760 }, { "name": "Springport Township", "code": 75880 }, { "name": "Springvale Township", "code": 75900 }, { "name": "Springville Township", "code": 75940 }, { "name": "Spurr Township", "code": 76000 }, { "name": "St Charles Township", "code": 70660 }, { "name": "City of St Clair", "code": 70680 }, { "name": "St Clair Township", "code": 70700 }, { "name": "City of St Clair Shores", "code": 70760 }, { "name": "St Ignace Township", "code": 70860 }, { "name": "City of St Ignace", "code": 70840 }, { "name": "St James Township", "code": 70920 }, { "name": "City of St Johns", "code": 70940 }, { "name": "City of St Joseph", "code": 70960 }, { "name": "St Joseph Township", "code": 70980 }, { "name": "City of St Louis", "code": 71000 }, { "name": "Stambaugh Township", "code": 76080 }, { "name": "Standish Township", "code": 76140 }, { "name": "City of Standish", "code": 76120 }, { "name": "Stannard Township", "code": 76180 }, { "name": "Stanton Township", "code": 76200 }, { "name": "City of Stanton", "code": 76220 }, { "name": "Star Township", "code": 76260 }, { "name": "Stephenson Township", "code": 76400 }, { "name": "City of Stephenson", "code": 76380 }, { "name": "City of Sterling Heights", "code": 76460 }, { "name": "Stockbridge Township", "code": 76580 }, { "name": "Stronach Township", "code": 76840 }, { "name": "City of Sturgis", "code": 76960 }, { "name": "Sturgis Township", "code": 76980 }, { "name": "Sugar Island Township", "code": 77020 }, { "name": "Sullivan Township", "code": 77100 }, { "name": "Summerfield Township", "code": 77120 }, { "name": "Summerfield Township", "code": 77140 }, { "name": "Summit Township", "code": 77200 }, { "name": "Summit Township", "code": 77220 }, { "name": "Sumner Township", "code": 77300 }, { "name": "Sumpter Township", "code": 77360 }, { "name": "Sunfield Township", "code": 77440 }, { "name": "Superior Township", "code": 77540 }, { "name": "Superior Township", "code": 77560 }, { "name": "Surrey Township", "code": 77580 }, { "name": "Suttons Bay Township", "code": 77620 }, { "name": "Swan Creek Township", "code": 77660 }, { "name": "City of Swartz Creek", "code": 77700 }, { "name": "Sweetwater Township", "code": 77740 }, { "name": "Sylvan Township", "code": 77760 }, { "name": "Sylvan Township", "code": 77800 }, { "name": "City of Sylvan Lake", "code": 77860 }, { "name": "Tallmadge Township", "code": 77980 }, { "name": "Tawas Township", "code": 78100 }, { "name": "City of Tawas City", "code": 78140 }, { "name": "City of Taylor", "code": 79000 }, { "name": "Taymouth Township", "code": 79100 }, { "name": "Tecumseh Township", "code": 79140 }, { "name": "City of Tecumseh", "code": 79120 }, { "name": "Tekonsha Township", "code": 79180 }, { "name": "Texas Township", "code": 79300 }, { "name": "City of The Village of Grosse Pointe Shores A Michigan City", "code": 82453 }, { "name": "Thetford Township", "code": 79460 }, { "name": "Thomas Township", "code": 79520 }, { "name": "Thompson Township", "code": 79580 }, { "name": "Thornapple Township", "code": 79620 }, { "name": "Three Oaks Township", "code": 79740 }, { "name": "City of Three Rivers", "code": 79760 }, { "name": "Tilden Township", "code": 79780 }, { "name": "Tittabawassee Township", "code": 79840 }, { "name": "Tobacco Township", "code": 79860 }, { "name": "Tompkins Township", "code": 79980 }, { "name": "Torch Lake Township", "code": 80100 }, { "name": "Torch Lake Township", "code": 80120 }, { "name": "City of Traverse City", "code": 80340 }, { "name": "City of Trenton", "code": 80420 }, { "name": "Trout Lake Township", "code": 80600 }, { "name": "Trowbridge Township", "code": 80620 }, { "name": "Troy Township", "code": 80680 }, { "name": "City of Troy", "code": 80700 }, { "name": "Turin Township", "code": 80780 }, { "name": "Turner Township", "code": 80840 }, { "name": "Tuscarora Township", "code": 80880 }, { "name": "Tuscola Township", "code": 80940 }, { "name": "Tyrone Township", "code": 81140 }, { "name": "Tyrone Township", "code": 81160 }, { "name": "Unadilla Township", "code": 81240 }, { "name": "Union Township", "code": 81280 }, { "name": "Union Township", "code": 81320 }, { "name": "Union Township", "code": 81340 }, { "name": "City of Utica", "code": 81540 }, { "name": "Valley Township", "code": 81580 }, { "name": "Van Buren Township", "code": 81660 }, { "name": "Vassar Township", "code": 81860 }, { "name": "City of Vassar", "code": 81840 }, { "name": "Venice Township", "code": 81880 }, { "name": "Vergennes Township", "code": 81920 }, { "name": "Vermontville Township", "code": 81980 }, { "name": "Vernon Township", "code": 82000 }, { "name": "Vernon Township", "code": 82040 }, { "name": "Verona Township", "code": 82140 }, { "name": "Vevay Township", "code": 82220 }, { "name": "Victor Township", "code": 82320 }, { "name": "Victory Township", "code": 82360 }, { "name": "Vienna Township", "code": 82380 }, { "name": "Vienna Township", "code": 82420 }, { "name": "City of Village of Clarkston", "code": 82450 }, { "name": "City of Village of Douglas", "code": 22740 }, { "name": "Volinia Township", "code": 82580 }, { "name": "Wakefield Township", "code": 82800 }, { "name": "City of Wakefield", "code": 82780 }, { "name": "Wakeshma Township", "code": 82840 }, { "name": "Wales Township", "code": 82900 }, { "name": "Walker Township", "code": 82940 }, { "name": "City of Walker", "code": 82960 }, { "name": "City of Walled Lake", "code": 83060 }, { "name": "Walton Township", "code": 83180 }, { "name": "Warner Township", "code": 83300 }, { "name": "City of Warren", "code": 84000 }, { "name": "Warren Township", "code": 84020 }, { "name": "Washington Township", "code": 84080 }, { "name": "Washington Township", "code": 84120 }, { "name": "Washington Township", "code": 84140 }, { "name": "Waterford Township", "code": 84240 }, { "name": "Waterloo Township", "code": 84300 }, { "name": "Watersmeet Township", "code": 84380 }, { "name": "Watertown Township", "code": 84400 }, { "name": "Watertown Township", "code": 84440 }, { "name": "Watertown Township", "code": 84460 }, { "name": "Watervliet Township", "code": 84520 }, { "name": "City of Watervliet", "code": 84500 }, { "name": "Watson Township", "code": 84580 }, { "name": "Waucedah Township", "code": 84700 }, { "name": "Waverly Township", "code": 84760 }, { "name": "Waverly Township", "code": 84820 }, { "name": "Wawatam Township", "code": 84840 }, { "name": "City of Wayland", "code": 84880 }, { "name": "Wayland Township", "code": 84900 }, { "name": "Wayne Township", "code": 84920 }, { "name": "City of Wayne", "code": 84940 }, { "name": "Weare Township", "code": 85040 }, { "name": "Webber Township", "code": 85060 }, { "name": "Webster Township", "code": 85100 }, { "name": "Weesaw Township", "code": 85120 }, { "name": "Weldon Township", "code": 85160 }, { "name": "Wellington Township", "code": 85180 }, { "name": "Wells Township", "code": 85240 }, { "name": "Wells Township", "code": 85260 }, { "name": "Wells Township", "code": 85280 }, { "name": "West Bloomfield Township", "code": 85480 }, { "name": "West Branch Township", "code": 85520 }, { "name": "West Branch Township", "code": 85540 }, { "name": "West Branch Township", "code": 85560 }, { "name": "City of West Branch", "code": 85580 }, { "name": "West Branch Township", "code": 85600 }, { "name": "West Traverse Township", "code": 86300 }, { "name": "City of Westland", "code": 86000 }, { "name": "Westphalia Township", "code": 86140 }, { "name": "Wexford Township", "code": 86500 }, { "name": "Wheatfield Township", "code": 86520 }, { "name": "Wheatland Township", "code": 86540 }, { "name": "Wheatland Township", "code": 86560 }, { "name": "Wheatland Township", "code": 86580 }, { "name": "Wheeler Township", "code": 86620 }, { "name": "City of White Cloud", "code": 86680 }, { "name": "White Lake Township", "code": 86860 }, { "name": "White Oak Township", "code": 86900 }, { "name": "White Pigeon Township", "code": 86940 }, { "name": "White River Township", "code": 86980 }, { "name": "White Water Township", "code": 87040 }, { "name": "Whitefish Township", "code": 86700 }, { "name": "Whiteford Township", "code": 86740 }, { "name": "Whitehall Township", "code": 86800 }, { "name": "City of Whitehall", "code": 86780 }, { "name": "Whitney Township", "code": 87080 }, { "name": "City of Whittemore", "code": 87140 }, { "name": "Wilber Township", "code": 87180 }, { "name": "Wilcox Township", "code": 87200 }, { "name": "Williams Township", "code": 87380 }, { "name": "City of Williamston", "code": 87420 }, { "name": "Williamstown Township", "code": 87440 }, { "name": "Wilmot Township", "code": 87640 }, { "name": "Wilson Township", "code": 87680 }, { "name": "Wilson Township", "code": 87700 }, { "name": "Windsor Township", "code": 87840 }, { "name": "Winfield Township", "code": 87880 }, { "name": "Winsor Township", "code": 87960 }, { "name": "Winterfield Township", "code": 87980 }, { "name": "Wise Township", "code": 88040 }, { "name": "Wisner Township", "code": 88080 }, { "name": "City of Wixom", "code": 88140 }, { "name": "Woodbridge Township", "code": 88300 }, { "name": "City of Woodhaven", "code": 88380 }, { "name": "Woodhull Township", "code": 88400 }, { "name": "Woodland Township", "code": 88440 }, { "name": "Woodstock Township", "code": 88640 }, { "name": "Worth Township", "code": 88760 }, { "name": "Wright Township", "code": 88780 }, { "name": "Wright Township", "code": 88820 }, { "name": "City of Wyandotte", "code": 88900 }, { "name": "City of Wyoming", "code": 88940 }, { "name": "City of Yale", "code": 89000 }, { "name": "Yankee Springs Township", "code": 89020 }, { "name": "Yates Township", "code": 89040 }, { "name": "York Township", "code": 89100 }, { "name": "City of Ypsilanti", "code": 89140 }, { "name": "Ypsilanti Township", "code": 89160 }, { "name": "Zeeland Township", "code": 89280 }, { "name": "City of Zeeland", "code": 89260 }, { "name": "Zilwaukee Township", "code": 89340 }, { "name": "City of Zilwaukee", "code": 89320 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "placecode_cd" }, { "name": "mdot_regn_cd", "type": "esriFieldTypeSmallInteger", "alias": "MDOT Region", "domain": { "type": "codedValue", "name": "mdot_regn_cdtb", "description": "MDOT Region", "codedValues": [ { "name": "Superior", "code": 1 }, { "name": "North", "code": 2 }, { "name": "Grand", "code": 3 }, { "name": "Bay", "code": 4 }, { "name": "Southwest", "code": 5 }, { "name": "University", "code": 6 }, { "name": "Metro", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mdot_regn_cd" }, { "name": "mdotcnty_cd", "type": "esriFieldTypeInteger", "alias": "MDOT County", "domain": { "type": "codedValue", "name": "mdotcnty_cdtb", "description": "MDOT County", "codedValues": [ { "name": "Alcona", "code": 1 }, { "name": "Alger", "code": 3 }, { "name": "Allegan", "code": 5 }, { "name": "Alpena", "code": 7 }, { "name": "Antrim", "code": 9 }, { "name": "Arenac", "code": 11 }, { "name": "Baraga", "code": 13 }, { "name": "Barry", "code": 15 }, { "name": "Bay", "code": 17 }, { "name": "Benzie", "code": 19 }, { "name": "Berrien", "code": 21 }, { "name": "Branch", "code": 23 }, { "name": "Calhoun", "code": 25 }, { "name": "Cass", "code": 27 }, { "name": "Charlevoix", "code": 29 }, { "name": "Cheboygan", "code": 31 }, { "name": "Chippewa", "code": 33 }, { "name": "Clare", "code": 35 }, { "name": "Clinton", "code": 37 }, { "name": "Crawford", "code": 39 }, { "name": "Delta", "code": 41 }, { "name": "Dickinson", "code": 43 }, { "name": "Eaton", "code": 45 }, { "name": "Emmet", "code": 47 }, { "name": "Genesee", "code": 49 }, { "name": "Gladwin", "code": 51 }, { "name": "Gogebic", "code": 53 }, { "name": "Grand Traverse", "code": 55 }, { "name": "Gratiot", "code": 57 }, { "name": "Hillsdale", "code": 59 }, { "name": "Houghton", "code": 61 }, { "name": "Huron", "code": 63 }, { "name": "Ingham", "code": 65 }, { "name": "Ionia", "code": 67 }, { "name": "Iosco", "code": 69 }, { "name": "Iron", "code": 71 }, { "name": "Isabella", "code": 73 }, { "name": "Jackson", "code": 75 }, { "name": "Kalamazoo", "code": 77 }, { "name": "Kalkaska", "code": 79 }, { "name": "Kent", "code": 81 }, { "name": "Keweenaw", "code": 83 }, { "name": "Lake", "code": 85 }, { "name": "Lapeer", "code": 87 }, { "name": "Leelanau", "code": 89 }, { "name": "Lenawee", "code": 91 }, { "name": "Livingston", "code": 93 }, { "name": "Luce", "code": 95 }, { "name": "Mackinac", "code": 97 }, { "name": "Macomb", "code": 99 }, { "name": "Manistee", "code": 101 }, { "name": "Marquette", "code": 103 }, { "name": "Mason", "code": 105 }, { "name": "Mecosta", "code": 107 }, { "name": "Menominee", "code": 109 }, { "name": "Midland", "code": 111 }, { "name": "Missaukee", "code": 113 }, { "name": "Monroe", "code": 115 }, { "name": "Montcalm", "code": 117 }, { "name": "Montmorency", "code": 119 }, { "name": "Muskegon", "code": 121 }, { "name": "Newaygo", "code": 123 }, { "name": "Oakland", "code": 125 }, { "name": "Oceana", "code": 127 }, { "name": "Ogemaw", "code": 129 }, { "name": "Ontonagon", "code": 131 }, { "name": "Osceola", "code": 133 }, { "name": "Oscoda", "code": 135 }, { "name": "Otsego", "code": 137 }, { "name": "Ottawa", "code": 139 }, { "name": "Presque Isle", "code": 141 }, { "name": "Roscommon", "code": 143 }, { "name": "Saginaw", "code": 145 }, { "name": "St Clair", "code": 147 }, { "name": "St Joseph", "code": 149 }, { "name": "Sanilac", "code": 151 }, { "name": "Schoolcraft", "code": 153 }, { "name": "Shiawassee", "code": 155 }, { "name": "Tuscola", "code": 157 }, { "name": "Van Buren", "code": 159 }, { "name": "Washtenaw", "code": 161 }, { "name": "Wayne", "code": 163 }, { "name": "Wexford", "code": 165 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mdotcnty_cd" }, { "name": "mdot_tsc_cd", "type": "esriFieldTypeInteger", "alias": "TSC", "domain": { "type": "codedValue", "name": "mdot_tsc_cdtb", "description": "MDOT Transportation Service Center", "codedValues": [ { "name": "Newberry", "code": 22 }, { "name": "Marshall", "code": 19 }, { "name": "Alpena", "code": 1 }, { "name": "Huron", "code": 28 }, { "name": "Taylor", "code": 25 }, { "name": "Kalamazoo", "code": 16 }, { "name": "Ishpeming", "code": 14 }, { "name": "Macomb", "code": 18 }, { "name": "Oakland", "code": 23 }, { "name": "Cadillac", "code": 4 }, { "name": "Crystal Falls", "code": 7 }, { "name": "Mt. Pleasant", "code": 20 }, { "name": "Gaylord", "code": 27 }, { "name": "Grand Rapids", "code": 11 }, { "name": "Detroit", "code": 9 }, { "name": "Jackson", "code": 15 }, { "name": "Muskegon", "code": 21 }, { "name": "Lansing", "code": 17 }, { "name": "Brighton", "code": 3 }, { "name": "Bay City", "code": 2 }, { "name": "Traverse City", "code": 26 }, { "name": "Davison", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mdot_tsc_cd" }, { "name": "grg_cd", "type": "esriFieldTypeSmallInteger", "alias": "Garage", "domain": { "type": "codedValue", "name": "mdot_grg_cdtb", "description": "MDOT Garage", "codedValues": [ { "name": "Garage", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "grg_cd" }, { "name": "precise_lat_barrel_start", "type": "esriFieldTypeDouble", "alias": "Start Latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "precise_lat_barrel_start" }, { "name": "precise_lon_barrel_start", "type": "esriFieldTypeDouble", "alias": "Start Longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "precise_lon_barrel_start" }, { "name": "precise_lat_barrel_end", "type": "esriFieldTypeDouble", "alias": "End Latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "precise_lat_barrel_end" }, { "name": "precise_lon_barrel_end", "type": "esriFieldTypeDouble", "alias": "End Longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "precise_lon_barrel_end" }, { "name": "SpatialQualityIndex", "type": "esriFieldTypeString", "alias": "Spatial Quality Index", "domain": { "type": "codedValue", "name": "SpatialQualityIndex_BOBS", "description": "Spatial Quality Index", "codedValues": [ { "name": "Survey Grade-3D", "code": "A" }, { "name": "Survey Grade-2D", "code": "B" }, { "name": "Mapping Grade", "code": "C" }, { "name": "Informational", "code": "D" }, { "name": "Unknown", "code": "E" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SpatialQualityIndex" }, { "name": "Beneath", "type": "esriFieldTypeSmallInteger", "alias": "Beneath", "domain": { "type": "codedValue", "name": "Beneath_BOBS", "description": "Beneath", "codedValues": [ { "name": "Mainline", "code": 1 }, { "name": "Ramp", "code": 2 }, { "name": "Service Drive", "code": 3 }, { "name": "Berm", "code": 4 }, { "name": "Local Road", "code": 5 }, { "name": "Driveway", "code": 6 }, { "name": "Railroad", "code": 7 }, { "name": "Pedestrian Walkway", "code": 8 }, { "name": "Other", "code": 12 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Beneath" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "Comments" }, { "name": "CulvertHeight", "type": "esriFieldTypeDouble", "alias": "Culvert Height", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CulvertHeight" }, { "name": "CulvertShape", "type": "esriFieldTypeSmallInteger", "alias": "Culvert Shape", "domain": { "type": "codedValue", "name": "CulvertShape_BOBS", "description": "Culvert Shape", "codedValues": [ { "name": "Circular", "code": 1 }, { "name": "Horizontal Elliptical", "code": 2 }, { "name": "Vertical Elliptical", "code": 3 }, { "name": "Pipe Arch", "code": 4 }, { "name": "Arch", "code": 5 }, { "name": "Low-profile Arch", "code": 6 }, { "name": "High-Profile Arch", "code": 7 }, { "name": "Pear", "code": 8 }, { "name": "Box", "code": 9 }, { "name": "Multi-cell Box", "code": 10 }, { "name": "3-Sided (Footings)", "code": 11 }, { "name": "Slab/superstructure and abutment", "code": 12 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CulvertShape" }, { "name": "CulvertWidth", "type": "esriFieldTypeDouble", "alias": "Culvert Width (inches)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CulvertWidth" }, { "name": "culv_span", "type": "esriFieldTypeString", "alias": "Culvert Span", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "culv_span" }, { "name": "depth_cover_feet", "type": "esriFieldTypeDouble", "alias": "Depth of Cover (ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "depth_cover_feet" }, { "name": "DitchVegetation", "type": "esriFieldTypeSmallInteger", "alias": "Ditch Vegetation", "domain": { "type": "codedValue", "name": "DitchVegetation", "description": "Ditch Vegetation", "codedValues": [ { "name": "None", "code": 1 }, { "name": "Partial", "code": 2 }, { "name": "Full", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DitchVegetation" }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "Last Inspected Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InspectionDate" }, { "name": "Liner", "type": "esriFieldTypeSmallInteger", "alias": "Liner", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Liner" }, { "name": "LinerDiameter", "type": "esriFieldTypeDouble", "alias": "Liner Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LinerDiameter" }, { "name": "LinerMaterial", "type": "esriFieldTypeSmallInteger", "alias": "Liner Material", "domain": { "type": "codedValue", "name": "LinerMaterial_BOBS", "description": "Liner Material", "codedValues": [ { "name": "Plastic-Smooth", "code": 1 }, { "name": "Plastic-Corrugated", "code": 2 }, { "name": "CIPP", "code": 3 }, { "name": "Other", "code": 4 }, { "name": "Fiberglass", "code": 5 }, { "name": "Unknown", "code": 6 }, { "name": "None", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LinerMaterial" }, { "name": "Route", "type": "esriFieldTypeInteger", "alias": "Route", "domain": { "type": "codedValue", "name": "mainrt_cdtb", "description": "MDOT Route Name", "codedValues": [ { "name": "I-69", "code": 1 }, { "name": "I-75", "code": 2 }, { "name": "I-94", "code": 3 }, { "name": "I-96", "code": 4 }, { "name": "I-194", "code": 5 }, { "name": "I-196", "code": 6 }, { "name": "I-275", "code": 7 }, { "name": "I-296", "code": 8 }, { "name": "I-375", "code": 9 }, { "name": "I-475", "code": 10 }, { "name": "I-496", "code": 11 }, { "name": "I-675", "code": 12 }, { "name": "I-696", "code": 13 }, { "name": "I-BL-69", "code": 14 }, { "name": "I-BL-75", "code": 15 }, { "name": "I-BL-94", "code": 16 }, { "name": "I-BL-96", "code": 17 }, { "name": "I-BL-196", "code": 18 }, { "name": "I-BS-75", "code": 19 }, { "name": "I-BS-96", "code": 20 }, { "name": "I-BS-196", "code": 21 }, { "name": "I-BS-375", "code": 22 }, { "name": "US-2", "code": 23 }, { "name": "US-8", "code": 24 }, { "name": "US-10", "code": 25 }, { "name": "US-12", "code": 26 }, { "name": "US-23", "code": 27 }, { "name": "US-24", "code": 28 }, { "name": "US-27", "code": 29 }, { "name": "US-31", "code": 30 }, { "name": "US-33", "code": 31 }, { "name": "US-41", "code": 32 }, { "name": "US-45", "code": 33 }, { "name": "US-127", "code": 34 }, { "name": "US-131", "code": 35 }, { "name": "US-141", "code": 36 }, { "name": "US-223", "code": 37 }, { "name": "US-BR-2", "code": 38 }, { "name": "US-BR-10", "code": 39 }, { "name": "US-BR-12", "code": 40 }, { "name": "US-BR-23", "code": 41 }, { "name": "US-BR-24", "code": 42 }, { "name": "US-BR-27", "code": 43 }, { "name": "US-BR-31", "code": 44 }, { "name": "US-BR-41", "code": 45 }, { "name": "US-BR-127", "code": 46 }, { "name": "US-BR-131", "code": 47 }, { "name": "US-BR-223", "code": 48 }, { "name": "M-1", "code": 49 }, { "name": "M-3", "code": 50 }, { "name": "M-5", "code": 51 }, { "name": "M-6", "code": 52 }, { "name": "M-8", "code": 53 }, { "name": "M-10", "code": 54 }, { "name": "M-11", "code": 55 }, { "name": "M-13", "code": 56 }, { "name": "M-14", "code": 57 }, { "name": "M-15", "code": 58 }, { "name": "M-17", "code": 59 }, { "name": "M-18", "code": 60 }, { "name": "M-19", "code": 61 }, { "name": "M-20", "code": 62 }, { "name": "M-21", "code": 63 }, { "name": "M-22", "code": 64 }, { "name": "M-24", "code": 65 }, { "name": "M-25", "code": 66 }, { "name": "M-26", "code": 67 }, { "name": "M-27", "code": 68 }, { "name": "M-28", "code": 69 }, { "name": "M-29", "code": 70 }, { "name": "M-30", "code": 71 }, { "name": "M-32", "code": 72 }, { "name": "M-33", "code": 73 }, { "name": "M-34", "code": 74 }, { "name": "M-35", "code": 75 }, { "name": "M-36", "code": 76 }, { "name": "M-37", "code": 77 }, { "name": "M-38", "code": 78 }, { "name": "M-39", "code": 79 }, { "name": "M-40", "code": 80 }, { "name": "M-42", "code": 81 }, { "name": "M-43", "code": 82 }, { "name": "M-44", "code": 83 }, { "name": "M-45", "code": 84 }, { "name": "M-46", "code": 85 }, { "name": "M-47", "code": 86 }, { "name": "M-48", "code": 87 }, { "name": "M-49", "code": 88 }, { "name": "M-50", "code": 89 }, { "name": "M-51", "code": 90 }, { "name": "M-52", "code": 91 }, { "name": "M-53", "code": 92 }, { "name": "M-54", "code": 93 }, { "name": "M-55", "code": 94 }, { "name": "M-57", "code": 95 }, { "name": "M-58", "code": 96 }, { "name": "M-59", "code": 97 }, { "name": "M-60", "code": 98 }, { "name": "M-61", "code": 99 }, { "name": "M-62", "code": 100 }, { "name": "M-63", "code": 101 }, { "name": "M-64", "code": 102 }, { "name": "M-65", "code": 103 }, { "name": "M-66", "code": 104 }, { "name": "M-67", "code": 105 }, { "name": "M-68", "code": 106 }, { "name": "M-69", "code": 107 }, { "name": "M-71", "code": 108 }, { "name": "M-72", "code": 109 }, { "name": "M-73", "code": 110 }, { "name": "M-75", "code": 111 }, { "name": "M-77", "code": 112 }, { "name": "M-78", "code": 113 }, { "name": "M-79", "code": 114 }, { "name": "M-80", "code": 115 }, { "name": "M-81", "code": 116 }, { "name": "M-82", "code": 117 }, { "name": "M-83", "code": 118 }, { "name": "M-84", "code": 119 }, { "name": "M-85", "code": 120 }, { "name": "M-86", "code": 121 }, { "name": "M-88", "code": 122 }, { "name": "M-89", "code": 123 }, { "name": "M-90", "code": 124 }, { "name": "M-91", "code": 125 }, { "name": "M-93", "code": 126 }, { "name": "M-94", "code": 127 }, { "name": "M-95", "code": 128 }, { "name": "M-96", "code": 129 }, { "name": "M-97", "code": 130 }, { "name": "M-99", "code": 131 }, { "name": "M-100", "code": 132 }, { "name": "M-102", "code": 133 }, { "name": "M-103", "code": 134 }, { "name": "M-104", "code": 135 }, { "name": "M-106", "code": 136 }, { "name": "M-107", "code": 137 }, { "name": "M-108", "code": 138 }, { "name": "M-109", "code": 139 }, { "name": "M-110", "code": 140 }, { "name": "M-113", "code": 141 }, { "name": "M-115", "code": 142 }, { "name": "M-116", "code": 143 }, { "name": "M-117", "code": 144 }, { "name": "M-119", "code": 145 }, { "name": "M-120", "code": 146 }, { "name": "M-121", "code": 147 }, { "name": "M-123", "code": 148 }, { "name": "M-124", "code": 149 }, { "name": "M-125", "code": 150 }, { "name": "M-129", "code": 151 }, { "name": "M-134", "code": 152 }, { "name": "M-136", "code": 153 }, { "name": "M-137", "code": 154 }, { "name": "M-138", "code": 155 }, { "name": "M-139", "code": 156 }, { "name": "M-140", "code": 157 }, { "name": "M-142", "code": 158 }, { "name": "M-143", "code": 159 }, { "name": "M-149", "code": 160 }, { "name": "M-150", "code": 161 }, { "name": "M-152", "code": 162 }, { "name": "M-153", "code": 163 }, { "name": "M-154", "code": 164 }, { "name": "M-156", "code": 165 }, { "name": "M-157", "code": 166 }, { "name": "M-168", "code": 167 }, { "name": "M-179", "code": 168 }, { "name": "M-183", "code": 169 }, { "name": "M-185", "code": 170 }, { "name": "M-186", "code": 171 }, { "name": "M-188", "code": 172 }, { "name": "M-189", "code": 173 }, { "name": "M-199", "code": 174 }, { "name": "M-201", "code": 175 }, { "name": "M-203", "code": 176 }, { "name": "M-204", "code": 177 }, { "name": "M-205", "code": 178 }, { "name": "M-209", "code": 179 }, { "name": "M-211", "code": 180 }, { "name": "M-212", "code": 181 }, { "name": "M-216", "code": 182 }, { "name": "M-217", "code": 183 }, { "name": "M-221", "code": 184 }, { "name": "M-222", "code": 185 }, { "name": "M-227", "code": 186 }, { "name": "M-231", "code": 187 }, { "name": "M-239", "code": 188 }, { "name": "M-247", "code": 189 }, { "name": "M-294", "code": 190 }, { "name": "M-311", "code": 191 }, { "name": "M-331", "code": 192 }, { "name": "M-553", "code": 193 }, { "name": "M-554", "code": 194 }, { "name": "M-BR-28", "code": 195 }, { "name": "M-BR-32", "code": 196 }, { "name": "M-BR-60", "code": 197 }, { "name": "OLD-12", "code": 198 }, { "name": "OLD-14", "code": 199 }, { "name": "OLD-17", "code": 200 }, { "name": "OLD-18", "code": 201 }, { "name": "OLD-20", "code": 202 }, { "name": "OLD-21", "code": 203 }, { "name": "OLD-23", "code": 204 }, { "name": "OLD-24", "code": 205 }, { "name": "OLD-27", "code": 206 }, { "name": "OLD-31", "code": 207 }, { "name": "OLD-37", "code": 208 }, { "name": "OLD-38", "code": 209 }, { "name": "OLD-42", "code": 210 }, { "name": "OLD-43", "code": 211 }, { "name": "OLD-45", "code": 212 }, { "name": "OLD-53", "code": 213 }, { "name": "OLD-54", "code": 214 }, { "name": "OLD-55", "code": 215 }, { "name": "OLD-59", "code": 216 }, { "name": "OLD-64", "code": 217 }, { "name": "OLD-65", "code": 218 }, { "name": "OLD-66", "code": 219 }, { "name": "OLD-69", "code": 220 }, { "name": "OLD-72", "code": 221 }, { "name": "OLD-78", "code": 222 }, { "name": "OLD-84", "code": 223 }, { "name": "OLD-96", "code": 224 }, { "name": "OLD-99", "code": 225 }, { "name": "OLD-106", "code": 226 }, { "name": "OLD-127", "code": 227 }, { "name": "OLD-131", "code": 228 }, { "name": "OLD-143", "code": 229 }, { "name": "OLD-153", "code": 230 }, { "name": "OLD-154", "code": 231 }, { "name": "OLD-155", "code": 232 }, { "name": "OLD-168", "code": 233 }, { "name": "OLD-196", "code": 234 }, { "name": "OLD-223", "code": 235 }, { "name": "CONN-1", "code": 236 }, { "name": "CONN-2", "code": 237 }, { "name": "CONN-3", "code": 238 }, { "name": "CONN-4", "code": 239 }, { "name": "CONN-5", "code": 240 }, { "name": "CONN-6", "code": 241 }, { "name": "CONN-7", "code": 242 }, { "name": "CONN-8", "code": 243 }, { "name": "CONN-9", "code": 244 }, { "name": "CONN-10", "code": 245 }, { "name": "CONN-13", "code": 246 }, { "name": "CONN-14", "code": 247 }, { "name": "CONN-15", "code": 248 }, { "name": "CONN-16", "code": 249 }, { "name": "CONN-17", "code": 250 }, { "name": "CONN-20", "code": 251 }, { "name": "CONN-22", "code": 252 }, { "name": "CONN-23", "code": 253 }, { "name": "CONN-24", "code": 254 }, { "name": "CONN-25", "code": 255 }, { "name": "CONN-30", "code": 256 }, { "name": "CONN-34", "code": 257 }, { "name": "CONN-44", "code": 258 }, { "name": "CONN-53", "code": 259 }, { "name": "CONN-58", "code": 260 }, { "name": "CONN-61", "code": 261 }, { "name": "CONN-69", "code": 262 }, { "name": "CONN-75", "code": 263 }, { "name": "CONN-81", "code": 264 }, { "name": "CONN-85", "code": 265 }, { "name": "CONN-96", "code": 266 }, { "name": "CONN-102", "code": 267 }, { "name": "CONN-104", "code": 268 }, { "name": "CONN-125", "code": 269 }, { "name": "CONN-127", "code": 270 }, { "name": "CONN-240", "code": 271 }, { "name": "CONN-496", "code": 272 }, { "name": "CONN-850", "code": 273 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Route" }, { "name": "StreamSubstrate", "type": "esriFieldTypeSmallInteger", "alias": "Stream Substrate", "domain": { "type": "codedValue", "name": "StreamSubstrate_BOBS", "description": "Stream Substrate", "codedValues": [ { "name": "Cobble", "code": 1 }, { "name": "Gravel", "code": 2 }, { "name": "Sand", "code": 3 }, { "name": "Silt", "code": 4 }, { "name": "Clay", "code": 5 }, { "name": "Organics", "code": 6 }, { "name": "Bedrock", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "StreamSubstrate" }, { "name": "Surface", "type": "esriFieldTypeSmallInteger", "alias": "Roadway Surface", "domain": { "type": "codedValue", "name": "Surface_BOBS", "description": "Surface", "codedValues": [ { "name": "No Deficiency", "code": 1 }, { "name": "Cracked", "code": 2 }, { "name": "Pothole(s)", "code": 3 }, { "name": "Washout", "code": 4 }, { "name": "Heaved", "code": 5 }, { "name": "Other", "code": 6 }, { "name": "Settled", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Surface" }, { "name": "rdwy_surf_cd", "type": "esriFieldTypeString", "alias": "Roadway Surface Type", "domain": { "type": "codedValue", "name": "rdwy_surf_cdtb", "description": "Roadway Surface Type", "codedValues": [ { "name": "Asphalt", "code": "Asphalt" }, { "name": "Brick", "code": "Brick" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Earth", "code": "Earth" }, { "name": "Gravel", "code": "Gravel " }, { "name": "Sealcoat", "code": "Sealcoat" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "rdwy_surf_cd" }, { "name": "flow_dir_cd", "type": "esriFieldTypeSmallInteger", "alias": "Flow Direction", "domain": { "type": "codedValue", "name": "flow_dir_cdtb", "description": "Flow Direction", "codedValues": [ { "name": "N", "code": 1 }, { "name": "NE", "code": 2 }, { "name": "E", "code": 3 }, { "name": "SE", "code": 4 }, { "name": "S", "code": 5 }, { "name": "SW", "code": 6 }, { "name": "W", "code": 7 }, { "name": "NW", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "flow_dir_cd" }, { "name": "NumberofBarrelsCells", "type": "esriFieldTypeSmallInteger", "alias": "Number of Barrels Cells", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumberofBarrelsCells" }, { "name": "CulvertLengthCalculated", "type": "esriFieldTypeDouble", "alias": "Culvert Length Calculated", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CulvertLengthCalculated" }, { "name": "skew_ang", "type": "esriFieldTypeDouble", "alias": "Skew Angle", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "skew_ang" }, { "name": "NumberofLanes", "type": "esriFieldTypeSmallInteger", "alias": "Number of Lanes", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumberofLanes" }, { "name": "DesignDischargeCFS", "type": "esriFieldTypeDouble", "alias": "Design Discharge (CFS)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DesignDischargeCFS" }, { "name": "DrainageAreaAcres", "type": "esriFieldTypeDouble", "alias": "Drainage Area Acres", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DrainageAreaAcres" }, { "name": "InletProtection", "type": "esriFieldTypeSmallInteger", "alias": "Inlet Protection", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "InletProtection" }, { "name": "OutletProtection", "type": "esriFieldTypeSmallInteger", "alias": "Outlet Protection", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OutletProtection" }, { "name": "perch_outlet_cd", "type": "esriFieldTypeSmallInteger", "alias": "Perched outlet present?", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "perch_outlet_cd" }, { "name": "last_insp_date", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_insp_date" }, { "name": "last_cpnt_rating_cd", "type": "esriFieldTypeSmallInteger", "alias": "Last Component Rating", "domain": { "type": "codedValue", "name": "cpnt_rating_cdtb", "description": "Component Rating", "codedValues": [ { "name": "0 - Failed", "code": 0 }, { "name": "1 - Imminent Failure", "code": 1 }, { "name": "2 - Critical", "code": 2 }, { "name": "3 - Serious", "code": 3 }, { "name": "4 - Poor", "code": 4 }, { "name": "5 - Fair", "code": 5 }, { "name": "6 - Satisfactory", "code": 6 }, { "name": "7 - Good", "code": 7 }, { "name": "8 - Very Good", "code": 8 }, { "name": "9 - New", "code": 9 }, { "name": "N/R - See Comments", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "last_cpnt_rating_cd" }, { "name": "last_insp_qc_stat_cd", "type": "esriFieldTypeSmallInteger", "alias": "Last Inspection QC Status", "domain": { "type": "codedValue", "name": "qc_stat_cdtb", "description": "QC Review Status", "codedValues": [ { "name": "QC Not Started", "code": 0 }, { "name": "QC Rejected - Issues to Address", "code": 1 }, { "name": "QC Complete - Accepted", "code": 2 }, { "name": "QC Comments Addressed - Ready for Verification", "code": 3 }, { "name": "QA Rejected - Issues to Address", "code": 4 }, { "name": "QA Complete - Accepted", "code": 5 }, { "name": "QA Comments Addressed - Ready for Verification", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "last_insp_qc_stat_cd" }, { "name": "last_insp_qa_stat_cd", "type": "esriFieldTypeSmallInteger", "alias": "Last Inspection QA Status", "domain": { "type": "codedValue", "name": "qa_stat_cdtb", "description": "QA Review Status", "codedValues": [ { "name": "QA Not Started", "code": 0 }, { "name": "QA Rejected - Issues to Address", "code": 4 }, { "name": "QA Complete - Accepted", "code": 5 }, { "name": "QA Comments Addressed - Ready for Verification", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "last_insp_qa_stat_cd" }, { "name": "rr_op_name", "type": "esriFieldTypeString", "alias": "Railroad Operator Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "rr_op_name" }, { "name": "rr_div", "type": "esriFieldTypeString", "alias": "Railroad Division", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "rr_div" }, { "name": "rr_mp", "type": "esriFieldTypeDouble", "alias": "Railroad Milepost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "rr_mp" }, { "name": "rr_xstr", "type": "esriFieldTypeString", "alias": "Nearest cross-roads", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "rr_xstr" }, { "name": "rr_num_trck_cross", "type": "esriFieldTypeSmallInteger", "alias": "Number of tracks crossed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "rr_num_trck_cross" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "yearbuilt", "type": "esriFieldTypeSmallInteger", "alias": "Year Built", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "yearbuilt" }, { "name": "owner_specialty_area_cd", "type": "esriFieldTypeString", "alias": "Owner Specialty Area", "domain": { "type": "codedValue", "name": "owner_specialty_area_cdtb", "description": "CulvertInventory", "codedValues": [ { "name": "Ancillary Structures", "code": "1" }, { "name": "ITS", "code": "2" }, { "name": "Structures", "code": "3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "owner_specialty_area_cd" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()", "required": true } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R52_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_52", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G608PR", "fields": "PR", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_52", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S22_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Culvert Inventory", "description": "", "prototype": { "attributes": { "owner_specialty_area_cd": null, "yearbuilt": null, "strc_num": null, "strc_num_seq": null, "strc_type_cd": null, "CulvertMaterial": null, "Culv_dsgn_type_cd": null, "ServiceStatus": null, "strucname": null, "invt_field_vrfy_date": null, "invt_field_vrfy_user": null, "invt_field_vrfy_cmpy_cd": null, "invt_field_comm": null, "next_insp_freq": null, "antcp_insp_date": null, "aadt": null, "aadt_yr": null, "owner_cd": null, "owner_name_cd": null, "custodian_name_cd": null, "acs_cd": null, "acs_note": null, "trfc_ctrl_cd": null, "trfc_ctrl_note": null, "rail_coord_cd": null, "rail_name_cd": null, "rail_phne_num_cd": null, "JobNumber": null, "prmy_xstr": null, "location": null, "legal_cd": null, "nrst_rte_drtn_cd": null, "mile_mrkr": null, "PR": null, "PRMP": null, "cs": null, "cs_mp": null, "placecode_cd": null, "mdot_regn_cd": null, "mdotcnty_cd": null, "mdot_tsc_cd": null, "grg_cd": null, "precise_lat_barrel_start": null, "precise_lon_barrel_start": null, "precise_lat_barrel_end": null, "precise_lon_barrel_end": null, "SpatialQualityIndex": null, "Beneath": null, "Comments": null, "CulvertHeight": null, "CulvertShape": null, "CulvertWidth": null, "culv_span": null, "depth_cover_feet": null, "DitchVegetation": null, "InspectionDate": null, "Liner": null, "LinerDiameter": null, "LinerMaterial": null, "Route": null, "StreamSubstrate": null, "Surface": null, "rdwy_surf_cd": null, "flow_dir_cd": null, "NumberofBarrelsCells": null, "CulvertLengthCalculated": null, "skew_ang": null, "NumberofLanes": null, "DesignDischargeCFS": null, "DrainageAreaAcres": null, "InletProtection": null, "OutletProtection": null, "perch_outlet_cd": null, "last_insp_date": null, "last_cpnt_rating_cd": null, "last_insp_qc_stat_cd": null, "last_insp_qa_stat_cd": null, "rr_op_name": null, "rr_div": null, "rr_mp": null, "rr_xstr": null, "rr_num_trck_cross": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "Culvert End Inventory", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "SystemCreateDate", "creatorField": "UserCreate", "editDateField": "SystemModifiedDate", "editorField": "UserModified" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 4, "name": "MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInventory", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "CulvertID", "composite": false, "catalogID": "{1AB95881-80C6-4D51-91A0-D2712059BFB7}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Bound", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Bound", "type": "esriFieldTypeSmallInteger", "alias": "Bound", "domain": { "type": "codedValue", "name": "nrst_rte_drtn_cdtb", "description": "Travel Direction of the Route nearest to the structure", "codedValues": [ { "name": "NB", "code": 1 }, { "name": "SB", "code": 2 }, { "name": "WB", "code": 3 }, { "name": "EB", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Bound" }, { "name": "ConditionIndex", "type": "esriFieldTypeSmallInteger", "alias": "Condition Index", "domain": { "type": "codedValue", "name": "cpnt_rating_cdtb", "description": "Component Rating", "codedValues": [ { "name": "0 - Failed", "code": 0 }, { "name": "1 - Imminent Failure", "code": 1 }, { "name": "2 - Critical", "code": 2 }, { "name": "3 - Serious", "code": 3 }, { "name": "4 - Poor", "code": 4 }, { "name": "5 - Fair", "code": 5 }, { "name": "6 - Satisfactory", "code": 6 }, { "name": "7 - Good", "code": 7 }, { "name": "8 - Very Good", "code": 8 }, { "name": "9 - New", "code": 9 }, { "name": "N/R - See Comments", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConditionIndex" }, { "name": "CulvertEndID", "type": "esriFieldTypeGUID", "alias": "CulvertEndID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "CulvertEndID" }, { "name": "CulvertID", "type": "esriFieldTypeGUID", "alias": "CulvertID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "CulvertID" }, { "name": "EmbankmentCondition", "type": "esriFieldTypeSmallInteger", "alias": "Embankment Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EmbankmentCondition" }, { "name": "EndExtension", "type": "esriFieldTypeSmallInteger", "alias": "End Extension", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EndExtension" }, { "name": "EndLocation", "type": "esriFieldTypeSmallInteger", "alias": "End Location", "domain": { "type": "codedValue", "name": "EndLocation_BOBS", "description": "End Location", "codedValues": [ { "name": "North", "code": 1 }, { "name": "South", "code": 2 }, { "name": "East", "code": 3 }, { "name": "West", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EndLocation" }, { "name": "EndSection", "type": "esriFieldTypeSmallInteger", "alias": "End Section", "domain": { "type": "codedValue", "name": "EndSectionType_BOBS", "description": "End Section Type", "codedValues": [ { "name": "None", "code": 1 }, { "name": "Headwall", "code": 2 }, { "name": "Headwall W/ Wingwalls", "code": 3 }, { "name": "Beveled (Concrete Only)", "code": 4 }, { "name": "Mitered Pipe", "code": 5 }, { "name": "Flared", "code": 6 }, { "name": "Sloped", "code": 7 }, { "name": "Drainage Structure", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EndSection" }, { "name": "EndSectionDetached", "type": "esriFieldTypeSmallInteger", "alias": "End Section Detached", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EndSectionDetached" }, { "name": "EndSectionMaterial", "type": "esriFieldTypeSmallInteger", "alias": "End Section Material", "domain": { "type": "codedValue", "name": "EndSectionMaterial_BOBS", "description": "End Section Material", "codedValues": [ { "name": "Metal", "code": 1 }, { "name": "Concrete", "code": 2 }, { "name": "Clay", "code": 3 }, { "name": "Plastic", "code": 4 }, { "name": "Masonry Units", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EndSectionMaterial" }, { "name": "ExtensionDimeSameAsCulvert", "type": "esriFieldTypeSmallInteger", "alias": "Extension Dime Same As Culvert", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ExtensionDimeSameAsCulvert" }, { "name": "ExtensionMaterialSameAsCulvert", "type": "esriFieldTypeSmallInteger", "alias": "Extension Material Same As Culvert", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ExtensionMaterialSameAsCulvert" }, { "name": "ExtensionShapeSameAsCulvert", "type": "esriFieldTypeSmallInteger", "alias": "Extension Shape Same As Culvert", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ExtensionShapeSameAsCulvert" }, { "name": "FootingExposed", "type": "esriFieldTypeSmallInteger", "alias": "Footing Exposed", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FootingExposed" }, { "name": "InstallYear", "type": "esriFieldTypeSmallInteger", "alias": "Install Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "InstallYear" }, { "name": "InvertAboveChannelBottom", "type": "esriFieldTypeSmallInteger", "alias": "Invert Above Channel Bottom", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "InvertAboveChannelBottom" }, { "name": "scour_prot_type_cd", "type": "esriFieldTypeSmallInteger", "alias": "Scour Protection Type", "domain": { "type": "codedValue", "name": "scour_prot_type_cd", "description": "Scour Protection Type", "codedValues": [ { "name": "Plain Riprap", "code": 1 }, { "name": "Heavy Riprap", "code": 2 }, { "name": "Field Stone", "code": 3 }, { "name": "Channel Armoring", "code": 4 }, { "name": "Articulating Concrete Block", "code": 5 }, { "name": "Gabion", "code": 6 }, { "name": "Grout-filled Bags", "code": 7 }, { "name": "Sheet Piling", "code": 8 }, { "name": "Other Scour Countermeasure", "code": 99 }, { "name": "None", "code": 100 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "scour_prot_type_cd" }, { "name": "Riprap", "type": "esriFieldTypeSmallInteger", "alias": "Riprap", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Riprap" }, { "name": "RiprapCondition", "type": "esriFieldTypeSmallInteger", "alias": "Riprap Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RiprapCondition" }, { "name": "SafetyGrate", "type": "esriFieldTypeSmallInteger", "alias": "Safety Grate", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SafetyGrate" }, { "name": "ScourPresent", "type": "esriFieldTypeSmallInteger", "alias": "Scour Present", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ScourPresent" }, { "name": "SedimentDepthGreater20", "type": "esriFieldTypeSmallInteger", "alias": "Sediment Depth Greater 20", "domain": { "type": "codedValue", "name": "Yes_no_BOBS", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SedimentDepthGreater20" }, { "name": "EndSectionExtLength_ft", "type": "esriFieldTypeDouble", "alias": "End Section Extension Length (ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EndSectionExtLength_ft" }, { "name": "EndSectionRemarks", "type": "esriFieldTypeString", "alias": "End Section Remarks", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "EndSectionRemarks" }, { "name": "invt_field_vrfy_date", "type": "esriFieldTypeDate", "alias": "Field Verification Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "invt_field_vrfy_date" }, { "name": "invt_field_vrfy_user", "type": "esriFieldTypeString", "alias": "Inventory Field Verification User", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "invt_field_vrfy_user" }, { "name": "invt_field_vrfy_cmpy_cd", "type": "esriFieldTypeSmallInteger", "alias": "Field Verification Company", "domain": { "type": "codedValue", "name": "insp_cmpy_cdtb", "description": "Inspection Company", "codedValues": [ { "name": "MDOT", "code": 1 }, { "name": "HNTB", "code": 2 }, { "name": "Collins", "code": 3 }, { "name": "SME", "code": 4 }, { "name": "TUV", "code": 6 }, { "name": "RS&H", "code": 7 }, { "name": "Corby", "code": 8 }, { "name": "Spicer", "code": 9 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "invt_field_vrfy_cmpy_cd" }, { "name": "UserCreate", "type": "esriFieldTypeString", "alias": "User Create", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "UserCreate" }, { "name": "SystemCreateDate", "type": "esriFieldTypeDate", "alias": "System Create Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SystemCreateDate" }, { "name": "UserModified", "type": "esriFieldTypeString", "alias": "User Modified", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "UserModified" }, { "name": "SystemModifiedDate", "type": "esriFieldTypeDate", "alias": "System Modified Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SystemModifiedDate" } ], "indexes": [ { "name": "R56_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_56", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G612CulvertID", "fields": "CulvertID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G612CulvertEndID", "fields": "CulvertEndID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_56", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Culvert End Inventory", "description": "", "prototype": { "attributes": { "invt_field_vrfy_cmpy_cd": null, "invt_field_vrfy_user": null, "Bound": null, "ConditionIndex": null, "CulvertEndID": null, "CulvertID": null, "EmbankmentCondition": null, "EndExtension": null, "EndLocation": null, "EndSection": null, "EndSectionDetached": null, "EndSectionMaterial": null, "ExtensionDimeSameAsCulvert": null, "ExtensionMaterialSameAsCulvert": null, "ExtensionShapeSameAsCulvert": null, "FootingExposed": null, "InstallYear": null, "InvertAboveChannelBottom": null, "scour_prot_type_cd": null, "Riprap": null, "RiprapCondition": null, "SafetyGrate": null, "ScourPresent": null, "SedimentDepthGreater20": null, "EndSectionExtLength_ft": null, "EndSectionRemarks": null, "invt_field_vrfy_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "Culvert Inspection QA/QC", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInspection", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "InspGUID", "composite": false, "catalogID": "{97394FBC-D873-4565-BDD2-3BE4839B8473}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "revw_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "revw_name", "type": "esriFieldTypeString", "alias": "Name of Reviewer/Updater", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "revw_name" }, { "name": "revw_cmpy_cd", "type": "esriFieldTypeSmallInteger", "alias": "Company of Reviewer", "domain": { "type": "codedValue", "name": "insp_cmpy_cdtb", "description": "Inspection Company", "codedValues": [ { "name": "MDOT", "code": 1 }, { "name": "HNTB", "code": 2 }, { "name": "Collins", "code": 3 }, { "name": "SME", "code": 4 }, { "name": "TUV", "code": 6 }, { "name": "RS&H", "code": 7 }, { "name": "Corby", "code": 8 }, { "name": "Spicer", "code": 9 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "revw_cmpy_cd" }, { "name": "revw_date", "type": "esriFieldTypeDate", "alias": "Review Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "revw_date" }, { "name": "revw_type_cd", "type": "esriFieldTypeSmallInteger", "alias": "Quality Review Type", "domain": { "type": "codedValue", "name": "revw_type_cdtb", "description": "Quality Review Type", "codedValues": [ { "name": "QC Reviewer - Initial Review", "code": 1 }, { "name": "Inspector - QC Comment Resolution", "code": 2 }, { "name": "QC Reviewer - QC Comment Verification", "code": 3 }, { "name": "QA Reviewer - Initial Review", "code": 4 }, { "name": "Inspector - QA Comment Resolution", "code": 5 }, { "name": "QA Reviewer - QA Comment Verification", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "revw_type_cd" }, { "name": "revw_comm", "type": "esriFieldTypeString", "alias": "Quality Review Comments", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "revw_comm" }, { "name": "revw_stat_cd", "type": "esriFieldTypeSmallInteger", "alias": "Quality Status After Review Complete", "domain": { "type": "codedValue", "name": "revw_stat_cdtb", "description": "Quality Status After Review Complete", "codedValues": [ { "name": "Not Started", "code": 0 }, { "name": "QC Rejected \u2013 Issues to Address", "code": 1 }, { "name": "QC Complete \u2013 Accepted", "code": 2 }, { "name": "QC Comments Addressed \u2013 Ready for Verification.", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "revw_stat_cd" }, { "name": "InspGUID", "type": "esriFieldTypeGUID", "alias": "Inspection GUID (Foreign key for the Inspection Table)", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "InspGUID" }, { "name": "qa_stat_cd", "type": "esriFieldTypeSmallInteger", "alias": "QA Status After Review Complete", "domain": { "type": "codedValue", "name": "qa_stat_cdtb", "description": "QA Review Status", "codedValues": [ { "name": "QA Not Started", "code": 0 }, { "name": "QA Rejected - Issues to Address", "code": 4 }, { "name": "QA Complete - Accepted", "code": 5 }, { "name": "QA Comments Addressed - Ready for Verification", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "qa_stat_cd" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R60_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_60", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G616InspGUID", "fields": "InspGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_60", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Culvert Inspection QA/QC", "description": "", "prototype": { "attributes": { "qa_stat_cd": null, "InspGUID": null, "revw_name": null, "revw_cmpy_cd": null, "revw_date": null, "revw_type_cd": null, "revw_comm": null, "revw_stat_cd": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 } ] }