{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "CulvertInspReport", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102723, "latestWkid": 3735, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119670700, "falseY": -95612900, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 66, 85, 137, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.1967036677155581E8, "ymin": -9.561250549341612E7, "xmax": 1.2360736677155581E8, "ymax": 7.591519013470328E7, "spatialReference": { "wkid": 102723, "latestWkid": 3735, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119670700, "falseY": -95612900, "xyUnits": 3.702424569851244E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "RoadName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "CountyMain", "type": "esriFieldTypeString", "alias": "CountyMain", "length": 50, "domain": null }, { "name": "MntBy", "type": "esriFieldTypeString", "alias": "MntBy", "length": 254, "domain": null }, { "name": "CardWidth", "type": "esriFieldTypeDouble", "alias": "CardWidth", "domain": null }, { "name": "InspGroup", "type": "esriFieldTypeString", "alias": "InspGroup", "length": 50, "domain": null }, { "name": "LocIn", "type": "esriFieldTypeString", "alias": "LocIn", "length": 254, "domain": null }, { "name": "Loc", "type": "esriFieldTypeString", "alias": "Loc", "length": 50, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "SHAPE_STLe", "type": "esriFieldTypeDouble", "alias": "SHAPE_STLe", "domain": null }, { "name": "GlobalID2", "type": "esriFieldTypeGUID", "alias": "GlobalID2", "length": 38, "domain": null }, { "name": "rownum", "type": "esriFieldTypeDouble", "alias": "rownum", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CountyMaint", "type": "esriFieldTypeString", "alias": "CountyMaint", "length": 50, "domain": null }, { "name": "MultiplierGasb", "type": "esriFieldTypeDouble", "alias": "MultiplierGasb", "domain": null }, { "name": "CostToConstruct", "type": "esriFieldTypeDouble", "alias": "CostToConstruct", "domain": null }, { "name": "CommentsGIS", "type": "esriFieldTypeString", "alias": "CommentsGIS", "length": 100, "domain": null }, { "name": "ID_SEARCH", "type": "esriFieldTypeString", "alias": "ID_SEARCH", "length": 50, "domain": null }, { "name": "SEGID", "type": "esriFieldTypeDouble", "alias": "SEGID", "domain": null }, { "name": "GISStatus", "type": "esriFieldTypeString", "alias": "GISStatus", "length": 10, "domain": null }, { "name": "CulvertID", "type": "esriFieldTypeDouble", "alias": "CulvertID", "domain": null }, { "name": "RoadNumber", "type": "esriFieldTypeInteger", "alias": "RoadNumber", "domain": null }, { "name": "RoadName", "type": "esriFieldTypeString", "alias": "RoadName", "length": 75, "domain": null }, { "name": "StationFeet", "type": "esriFieldTypeDouble", "alias": "StationFeet", "domain": null }, { "name": "StationMiles", "type": "esriFieldTypeDouble", "alias": "StationMiles", "domain": null }, { "name": "OPN", "type": "esriFieldTypeString", "alias": "OPN", "length": 2, "domain": null }, { "name": "PavementWidth", "type": "esriFieldTypeDouble", "alias": "PavementWidth", "domain": null }, { "name": "Length", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null }, { "name": "FL", "type": "esriFieldTypeDouble", "alias": "FL", "domain": null }, { "name": "DateBuilt", "type": "esriFieldTypeDate", "alias": "DateBuilt", "length": 8, "domain": null }, { "name": "RightType", "type": "esriFieldTypeString", "alias": "RightType", "length": 128, "domain": null }, { "name": "RightHeight", "type": "esriFieldTypeDouble", "alias": "RightHeight", "domain": null }, { "name": "RightWidth", "type": "esriFieldTypeDouble", "alias": "RightWidth", "domain": null }, { "name": "RightCulvertMaterial", "type": "esriFieldTypeString", "alias": "RightCulvertMaterial", "length": 128, "domain": null }, { "name": "RightHeadwallMaterial", "type": "esriFieldTypeString", "alias": "RightHeadwallMaterial", "length": 128, "domain": null }, { "name": "RightWingwallMaterialNE", "type": "esriFieldTypeString", "alias": "RightWingwallMaterialNE", "length": 128, "domain": null }, { "name": "RightWingwallMaterialSW", "type": "esriFieldTypeString", "alias": "RightWingwallMaterialSW", "length": 128, "domain": null }, { "name": "LeftType", "type": "esriFieldTypeString", "alias": "LeftType", "length": 128, "domain": null }, { "name": "LeftHeight", "type": "esriFieldTypeDouble", "alias": "LeftHeight", "domain": null }, { "name": "LeftWidth", "type": "esriFieldTypeDouble", "alias": "LeftWidth", "domain": null }, { "name": "LeftCulvertMaterial", "type": "esriFieldTypeString", "alias": "LeftCulvertMaterial", "length": 128, "domain": null }, { "name": "LeftHeadwallMaterial", "type": "esriFieldTypeString", "alias": "LeftHeadwallMaterial", "length": 128, "domain": null }, { "name": "LeftWingwallMaterialNE", "type": "esriFieldTypeString", "alias": "LeftWingwallMaterialNE", "length": 128, "domain": null }, { "name": "LeftWingwallMaterialSW", "type": "esriFieldTypeString", "alias": "LeftWingwallMaterialSW", "length": 128, "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "length": 8, "domain": null }, { "name": "InspectionRating", "type": "esriFieldTypeSmallInteger", "alias": "InspectionRating", "domain": null }, { "name": "InspectionComments", "type": "esriFieldTypeString", "alias": "InspectionComments", "length": 255, "domain": null }, { "name": "InspectionInspector", "type": "esriFieldTypeString", "alias": "InspectionInspector", "length": 10, "domain": null }, { "name": "InspectionMnt", "type": "esriFieldTypeString", "alias": "InspectionMnt", "length": 50, "domain": null }, { "name": "InspectionChn", "type": "esriFieldTypeString", "alias": "InspectionChn", "length": 50, "domain": null }, { "name": "InpsectionHdw", "type": "esriFieldTypeString", "alias": "InpsectionHdw", "length": 50, "domain": null }, { "name": "InspectionPav", "type": "esriFieldTypeString", "alias": "InspectionPav", "length": 50, "domain": null }, { "name": "InspectionGdr", "type": "esriFieldTypeString", "alias": "InspectionGdr", "length": 50, "domain": null }, { "name": "InspectionOther", "type": "esriFieldTypeString", "alias": "InspectionOther", "length": 50, "domain": null }, { "name": "CardinalOpening", "type": "esriFieldTypeDouble", "alias": "CardinalOpening", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "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": "picture", "type": "esriFieldTypeString", "alias": "picture", "length": 255, "domain": null }, { "name": "MaintenanceItems", "type": "esriFieldTypeString", "alias": "MaintenanceItems", "length": 50, "domain": null }, { "name": "MaintenanceDate", "type": "esriFieldTypeDate", "alias": "MaintenanceDate", "length": 8, "domain": null }, { "name": "MaintenancePerson", "type": "esriFieldTypeString", "alias": "MaintenancePerson", "length": 50, "domain": null }, { "name": "oldstateid", "type": "esriFieldTypeDouble", "alias": "oldstateid", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": null, "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "s123_CulvertInsp__ATTACH", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "CulvertID", "type": "esriFieldTypeSmallInteger", "alias": "CulvertID", "domain": null } ], "indexes": [ { "name": "R743_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_743", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_2182_REL_GLO", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_743", "fields": "GLOBALID,ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1706893839000 }, "serviceItemId": "c39613a009e74d4b84a71bd4a815bec8" }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 2, "name": "s123_CulvertInsp", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "RoadName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CountyMaint", "type": "esriFieldTypeString", "alias": "County Maint", "length": 50, "domain": { "type": "codedValue", "name": "Yes_No_lowercase", "description": "lower case", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MultiplierGasb", "type": "esriFieldTypeDouble", "alias": "MultiplierGasb", "domain": null }, { "name": "CostToConstruct", "type": "esriFieldTypeDouble", "alias": "CostToConstruct", "domain": null }, { "name": "CommentsGIS", "type": "esriFieldTypeString", "alias": "CommentsGIS", "length": 100, "domain": null }, { "name": "ID_SEARCH", "type": "esriFieldTypeString", "alias": "ID_SEARCH", "length": 50, "domain": null }, { "name": "SEGID", "type": "esriFieldTypeDouble", "alias": "SEGID", "domain": null }, { "name": "GISStatus", "type": "esriFieldTypeString", "alias": "Status", "length": 10, "domain": { "type": "codedValue", "name": "CON_CulvertService", "description": "CulvertINSP In service or Not", "codedValues": [ { "name": "In Service", "code": "IS" }, { "name": "Not in Service", "code": "NIS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CulvertID", "type": "esriFieldTypeDouble", "alias": "CulvertID", "domain": null }, { "name": "RoadNumber", "type": "esriFieldTypeInteger", "alias": "Road Number", "domain": null }, { "name": "RoadName", "type": "esriFieldTypeString", "alias": "Road Name", "length": 75, "domain": null }, { "name": "StationFeet", "type": "esriFieldTypeDouble", "alias": "Station Feet", "domain": null }, { "name": "StationMiles", "type": "esriFieldTypeDouble", "alias": "Station Miles", "domain": null }, { "name": "OPN", "type": "esriFieldTypeString", "alias": "OPN", "length": 2, "domain": { "type": "codedValue", "name": "CON_CulvertCont", "description": "CulvertINSP Continuous or not", "codedValues": [ { "name": "Continuous", "code": "1" }, { "name": "Non-Continuous", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PavementWidth", "type": "esriFieldTypeDouble", "alias": "Pavement Width", "domain": null }, { "name": "Length", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null }, { "name": "FL", "type": "esriFieldTypeDouble", "alias": "FL", "domain": null }, { "name": "DateBuilt", "type": "esriFieldTypeDate", "alias": "Date Built", "length": 8, "domain": null }, { "name": "RightType", "type": "esriFieldTypeString", "alias": "Right Type", "length": 128, "domain": { "type": "codedValue", "name": "CulvertType", "description": "Culvert Type", "codedValues": [ { "name": "Pipe", "code": "Pipe" }, { "name": "Arch", "code": "Arch" }, { "name": "Box", "code": "Box" }, { "name": "Elipse", "code": "Elipse" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RightHeight", "type": "esriFieldTypeDouble", "alias": "Right Height", "domain": null }, { "name": "RightWidth", "type": "esriFieldTypeDouble", "alias": "Right Width", "domain": null }, { "name": "RightCulvertMaterial", "type": "esriFieldTypeString", "alias": "Right Culvert Material", "length": 128, "domain": { "type": "codedValue", "name": "CulvertMaterial", "description": "Culvert Material", "codedValues": [ { "name": "Concrete Block", "code": "BLCKCONC" }, { "name": "Corrugated Metal Pipe", "code": "CMP" }, { "name": "Concrete", "code": "CONCRETE" }, { "name": "Plastic", "code": "PLASTIC" }, { "name": "Steel", "code": "STEEL" }, { "name": "Stone & Concrete", "code": "STONCONC" }, { "name": "Stone", "code": "STONE" }, { "name": "VSP", "code": "VSP" }, { "name": "Unknown", "code": "UNKNOWN" }, { "name": "Other", "code": "OTHER" }, { "name": "Gunite", "code": "GUNITE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RightHeadwallMaterial", "type": "esriFieldTypeString", "alias": "Right Headwall Material", "length": 128, "domain": { "type": "codedValue", "name": "HeadwallMaterial", "description": "Headwall Material", "codedValues": [ { "name": "Concrete Block", "code": "BLCKCONC" }, { "name": "Block", "code": "BLOCK" }, { "name": "Catch Basin", "code": "CATCHBSN" }, { "name": "Concrete", "code": "CONCRETE" }, { "name": "Drop Inlet", "code": "DROPINLT" }, { "name": "Stone and Block", "code": "STONCONC" }, { "name": "Stone", "code": "STONE" }, { "name": "Other", "code": "OTHER" }, { "name": "None", "code": "NONE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RightWingwallMaterialNE", "type": "esriFieldTypeString", "alias": "Right Wingwall Material NE", "length": 128, "domain": { "type": "codedValue", "name": "WingwallMaterial", "description": "Wingwall Material", "codedValues": [ { "name": "Concrete Block", "code": "BLCKCONC" }, { "name": "Block", "code": "BLOCK" }, { "name": "Catch Basin", "code": "CATCHBSN" }, { "name": "Concrete", "code": "CONCRETE" }, { "name": "Drop Inlet", "code": "DROPINLT" }, { "name": "Stone and Block", "code": "STONCONC" }, { "name": "Stone", "code": "STONE" }, { "name": "None", "code": "NONE" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RightWingwallMaterialSW", "type": "esriFieldTypeString", "alias": "Right Wingwall Material SW", "length": 128, "domain": { "type": "codedValue", "name": "WingwallMaterial", "description": "Wingwall Material", "codedValues": [ { "name": "Concrete Block", "code": "BLCKCONC" }, { "name": "Block", "code": "BLOCK" }, { "name": "Catch Basin", "code": "CATCHBSN" }, { "name": "Concrete", "code": "CONCRETE" }, { "name": "Drop Inlet", "code": "DROPINLT" }, { "name": "Stone and Block", "code": "STONCONC" }, { "name": "Stone", "code": "STONE" }, { "name": "None", "code": "NONE" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LeftType", "type": "esriFieldTypeString", "alias": "Left Type", "length": 128, "domain": null }, { "name": "LeftHeight", "type": "esriFieldTypeDouble", "alias": "Left Height", "domain": null }, { "name": "LeftWidth", "type": "esriFieldTypeDouble", "alias": "Left Width", "domain": null }, { "name": "LeftCulvertMaterial", "type": "esriFieldTypeString", "alias": "Left Culvert Material", "length": 128, "domain": { "type": "codedValue", "name": "CulvertMaterial", "description": "Culvert Material", "codedValues": [ { "name": "Concrete Block", "code": "BLCKCONC" }, { "name": "Corrugated Metal Pipe", "code": "CMP" }, { "name": "Concrete", "code": "CONCRETE" }, { "name": "Plastic", "code": "PLASTIC" }, { "name": "Steel", "code": "STEEL" }, { "name": "Stone & Concrete", "code": "STONCONC" }, { "name": "Stone", "code": "STONE" }, { "name": "VSP", "code": "VSP" }, { "name": "Unknown", "code": "UNKNOWN" }, { "name": "Other", "code": "OTHER" }, { "name": "Gunite", "code": "GUNITE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LeftHeadwallMaterial", "type": "esriFieldTypeString", "alias": "Left Headwall Material", "length": 128, "domain": { "type": "codedValue", "name": "HeadwallMaterial", "description": "Headwall Material", "codedValues": [ { "name": "Concrete Block", "code": "BLCKCONC" }, { "name": "Block", "code": "BLOCK" }, { "name": "Catch Basin", "code": "CATCHBSN" }, { "name": "Concrete", "code": "CONCRETE" }, { "name": "Drop Inlet", "code": "DROPINLT" }, { "name": "Stone and Block", "code": "STONCONC" }, { "name": "Stone", "code": "STONE" }, { "name": "Other", "code": "OTHER" }, { "name": "None", "code": "NONE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LeftWingwallMaterialNE", "type": "esriFieldTypeString", "alias": "Left Wingwall Material NE", "length": 128, "domain": { "type": "codedValue", "name": "WingwallMaterial", "description": "Wingwall Material", "codedValues": [ { "name": "Concrete Block", "code": "BLCKCONC" }, { "name": "Block", "code": "BLOCK" }, { "name": "Catch Basin", "code": "CATCHBSN" }, { "name": "Concrete", "code": "CONCRETE" }, { "name": "Drop Inlet", "code": "DROPINLT" }, { "name": "Stone and Block", "code": "STONCONC" }, { "name": "Stone", "code": "STONE" }, { "name": "None", "code": "NONE" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LeftWingwallMaterialSW", "type": "esriFieldTypeString", "alias": "Left Wingwall Material SW", "length": 128, "domain": { "type": "codedValue", "name": "WingwallMaterial", "description": "Wingwall Material", "codedValues": [ { "name": "Concrete Block", "code": "BLCKCONC" }, { "name": "Block", "code": "BLOCK" }, { "name": "Catch Basin", "code": "CATCHBSN" }, { "name": "Concrete", "code": "CONCRETE" }, { "name": "Drop Inlet", "code": "DROPINLT" }, { "name": "Stone and Block", "code": "STONCONC" }, { "name": "Stone", "code": "STONE" }, { "name": "None", "code": "NONE" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "InspectionRating", "type": "esriFieldTypeSmallInteger", "alias": "Rating", "domain": { "type": "codedValue", "name": "CulvertRating", "description": "CulvertRating", "codedValues": [ { "name": "1 = New", "code": 1 }, { "name": "2 = Good", "code": 2 }, { "name": "3 = Replace Prior to Paving", "code": 3 }, { "name": "4 = Replace Immediately", "code": 4 }, { "name": "9 = REVIEW", "code": 9 }, { "name": "00 = Storm Sewer", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspectionComments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "InspectionInspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 10, "domain": null }, { "name": "InspectionMnt", "type": "esriFieldTypeString", "alias": "Inspection Maint", "length": 50, "domain": { "type": "codedValue", "name": "Yes_No_lowercase", "description": "lower case", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspectionChn", "type": "esriFieldTypeString", "alias": "Inspection Channel", "length": 50, "domain": { "type": "codedValue", "name": "Yes_No_lowercase", "description": "lower case", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InpsectionHdw", "type": "esriFieldTypeString", "alias": "Inpsection Headwall", "length": 50, "domain": { "type": "codedValue", "name": "Yes_No_lowercase", "description": "lower case", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspectionPav", "type": "esriFieldTypeString", "alias": "Inspection Pavement", "length": 50, "domain": { "type": "codedValue", "name": "Yes_No_lowercase", "description": "lower case", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspectionGdr", "type": "esriFieldTypeString", "alias": "Inspection Guardrail", "length": 50, "domain": { "type": "codedValue", "name": "Yes_No_lowercase", "description": "lower case", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspectionOther", "type": "esriFieldTypeString", "alias": "Inspection Other", "length": 50, "domain": { "type": "codedValue", "name": "Yes_No_lowercase", "description": "lower case", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CardinalOpening", "type": "esriFieldTypeDouble", "alias": "Cardinal Opening", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "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": "picture", "type": "esriFieldTypeString", "alias": "picture", "length": 255, "domain": null }, { "name": "MaintenanceItems", "type": "esriFieldTypeString", "alias": "MaintenanceItems", "length": 50, "domain": { "type": "codedValue", "name": "MaintenanceItems", "description": "Inspection Maintenance items", "codedValues": [ { "name": "NONE", "code": "N" }, { "name": "CAMERA PIPE", "code": "C" }, { "name": "DITCH WORK", "code": "D" }, { "name": "TREE REMOVAL", "code": "T" }, { "name": "UTILITY HIT", "code": "U" }, { "name": "VACTOR/JET", "code": "V" }, { "name": "CATCH BASIN REPAIR", "code": "CB" }, { "name": "HEAD WALL REPAIR", "code": "HW" }, { "name": "MAN HOLE REPAIR", "code": "MH" }, { "name": "SEE LONG DESCRIPTION", "code": "L" }, { "name": "VACTOR & CAMERA", "code": "VC" }, { "name": "REPLACE", "code": "R" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintenanceDate", "type": "esriFieldTypeDate", "alias": "MaintenanceDate", "length": 8, "domain": null }, { "name": "MaintenancePerson", "type": "esriFieldTypeString", "alias": "MaintenancePerson", "length": 50, "domain": null }, { "name": "oldstateid", "type": "esriFieldTypeDouble", "alias": "oldstateid", "domain": null }, { "name": "NEWStationMiles", "type": "esriFieldTypeDouble", "alias": "NEWStationMiles", "domain": null } ], "indexes": [ { "name": "R539_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_539", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2125REL_GLOBALI", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_539", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1706892142000 }, "serviceItemId": "c39613a009e74d4b84a71bd4a815bec8" } ] }