{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 13, "name": "Culvert Work Rec", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 3000000, "maxScale": 0, "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 }, "defaultVisibility": false, "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 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "fc_fs_recm_typ_cd", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "AssetGUID", "type": "esriFieldTypeGUID", "alias": "AssetGUID", "length": 38, "domain": null }, { "name": "InspGUID", "type": "esriFieldTypeGUID", "alias": "InspGUID", "length": 38, "domain": null }, { "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" } }, { "name": "work_recm_type_other", "type": "esriFieldTypeString", "alias": "If other, please describe. ", "length": 255, "domain": null }, { "name": "fc_fs_recm_comm", "type": "esriFieldTypeString", "alias": "Work Recommendation Comment", "length": 3999, "domain": null }, { "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" } }, { "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" } }, { "name": "work_rect_cmpt_date", "type": "esriFieldTypeDate", "alias": "Work Recommendation Completion Date", "length": 8, "domain": null }, { "name": "qty_matl", "type": "esriFieldTypeDouble", "alias": "Estimated Quantity of Primary Material Needed for Work Rec", "domain": null }, { "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" } }, { "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" } }, { "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" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "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" } }, { "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" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "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": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInventory", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "AssetGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{753992AE-8710-4021-98B6-129C65249F3B}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }