{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "CulvertLocation", "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.006096012192, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 39, 71, 153, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1312356.076711014, "ymin": 477594.81796984375, "xmax": 1448280.454139918, "ymax": 584881.508251667, "spatialReference": { "wkid": 102723, "latestWkid": 3735, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -119670700, "falseY": -95612900, "xyUnits": 3.702424569851244E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "CountyMaint", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID_1", "type": "esriFieldTypeOID", "alias": "OBJECTID_1", "domain": null }, { "name": "CountyMain", "type": "esriFieldTypeString", "alias": "CountyMain", "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": "GISStatus", "type": "esriFieldTypeString", "alias": "GISStatus", "length": 50, "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": "esriFieldTypeInteger", "alias": "CulvertID", "domain": null }, { "name": "created_us", "type": "esriFieldTypeString", "alias": "created_us", "length": 254, "domain": null }, { "name": "created_da", "type": "esriFieldTypeDate", "alias": "created_da", "length": 8, "domain": null }, { "name": "last_edite", "type": "esriFieldTypeString", "alias": "last_edite", "length": 254, "domain": null }, { "name": "last_edi_1", "type": "esriFieldTypeDate", "alias": "last_edi_1", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeString", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "CardWidth", "type": "esriFieldTypeDouble", "alias": "CardWidth", "domain": null }, { "name": "MntBy", "type": "esriFieldTypeString", "alias": "MntBy", "length": 254, "domain": { "type": "codedValue", "name": "Culvert_MntBy", "description": "Maintained By", "codedValues": [ { "name": "BCO/BCO", "code": "BCO/BCO" }, { "name": "FCO/FCO", "code": "FCO/FCO" }, { "name": "FCO/MOR", "code": "FCO/MOR" }, { "name": "FFD/FFD", "code": "FFD/FFD" }, { "name": "HAN/HAN", "code": "HAN/HAN" }, { "name": "HAN/MIL", "code": "HAN/MIL" }, { "name": "HAN/RLY", "code": "HAN/RLY" }, { "name": "HCO/MOR", "code": "HCO/MOR" }, { "name": "HCO/UNI", "code": "HCO/UNI" }, { "name": "IMO/LIB", "code": "IMO/LIB" }, { "name": "IMS/UNI", "code": "IMS/UNI" }, { "name": "IN/RLY", "code": "IN/RLY" }, { "name": "ISH/ISH", "code": "ISH/ISH" }, { "name": "ISP/BCO", "code": "ISP/BCO" }, { "name": "LEM/LEM", "code": "LEM/LEM" }, { "name": "LIB/LEM", "code": "LIB/LEM" }, { "name": "LIB/LIB", "code": "LIB/LIB" }, { "name": "MAD/MAD", "code": "MAD/MAD" }, { "name": "MIL/MIL", "code": "MIL/MIL" }, { "name": "MOR/MOR", "code": "MOR/MOR" }, { "name": "OXF/OXF", "code": "OXF/OXF" }, { "name": "PCO/PCO", "code": "PCO/PCO" }, { "name": "RLY/OXF", "code": "RLY/OXF" }, { "name": "RLY/RLY", "code": "RLY/RLY" }, { "name": "ROS/MOR", "code": "ROS/MOR" }, { "name": "ROS/ROS", "code": "ROS/ROS" }, { "name": "STC/STC", "code": "STC/STC" }, { "name": "UNI/LIB", "code": "UNI/LIB" }, { "name": "UNI/UNI", "code": "UNI/UNI" }, { "name": "WAY/WAY", "code": "WAY/WAY" }, { "name": "WCO/LIB", "code": "WCO/LIB" }, { "name": "WCO/MAD", "code": "WCO/MAD" }, { "name": "WCO/UNI", "code": "WCO/UNI" }, { "name": "HAN/IMV", "code": "HAN/IMV" }, { "name": "ISH/UNI", "code": "ISH/UNI" }, { "name": "ISP/UNI", "code": "ISP/UNI" }, { "name": "LIB/FFD", "code": "LIB/FFD" }, { "name": "MAD/STC", "code": "MAD/STC" }, { "name": "MAD/WAY", "code": "MAD/WAY" }, { "name": "MIL/OXF", "code": "MIL/OXF" }, { "name": "MOR/FCO", "code": "MOR/FCO" }, { "name": "OXF/PCO", "code": "OXF/PCO" }, { "name": "RLY/FCO", "code": "RLY/FCO" }, { "name": "ROS/HAN", "code": "ROS/HAN" }, { "name": "STC/ROS", "code": "STC/ROS" }, { "name": "STC/WAY", "code": "STC/WAY" }, { "name": "WAY/MIL", "code": "WAY/MIL" }, { "name": "WAY/PCO", "code": "WAY/PCO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LocIn", "type": "esriFieldTypeString", "alias": "LocIn", "length": 254, "domain": { "type": "codedValue", "name": "Culvert_MntBy", "description": "Maintained By", "codedValues": [ { "name": "BCO/BCO", "code": "BCO/BCO" }, { "name": "FCO/FCO", "code": "FCO/FCO" }, { "name": "FCO/MOR", "code": "FCO/MOR" }, { "name": "FFD/FFD", "code": "FFD/FFD" }, { "name": "HAN/HAN", "code": "HAN/HAN" }, { "name": "HAN/MIL", "code": "HAN/MIL" }, { "name": "HAN/RLY", "code": "HAN/RLY" }, { "name": "HCO/MOR", "code": "HCO/MOR" }, { "name": "HCO/UNI", "code": "HCO/UNI" }, { "name": "IMO/LIB", "code": "IMO/LIB" }, { "name": "IMS/UNI", "code": "IMS/UNI" }, { "name": "IN/RLY", "code": "IN/RLY" }, { "name": "ISH/ISH", "code": "ISH/ISH" }, { "name": "ISP/BCO", "code": "ISP/BCO" }, { "name": "LEM/LEM", "code": "LEM/LEM" }, { "name": "LIB/LEM", "code": "LIB/LEM" }, { "name": "LIB/LIB", "code": "LIB/LIB" }, { "name": "MAD/MAD", "code": "MAD/MAD" }, { "name": "MIL/MIL", "code": "MIL/MIL" }, { "name": "MOR/MOR", "code": "MOR/MOR" }, { "name": "OXF/OXF", "code": "OXF/OXF" }, { "name": "PCO/PCO", "code": "PCO/PCO" }, { "name": "RLY/OXF", "code": "RLY/OXF" }, { "name": "RLY/RLY", "code": "RLY/RLY" }, { "name": "ROS/MOR", "code": "ROS/MOR" }, { "name": "ROS/ROS", "code": "ROS/ROS" }, { "name": "STC/STC", "code": "STC/STC" }, { "name": "UNI/LIB", "code": "UNI/LIB" }, { "name": "UNI/UNI", "code": "UNI/UNI" }, { "name": "WAY/WAY", "code": "WAY/WAY" }, { "name": "WCO/LIB", "code": "WCO/LIB" }, { "name": "WCO/MAD", "code": "WCO/MAD" }, { "name": "WCO/UNI", "code": "WCO/UNI" }, { "name": "HAN/IMV", "code": "HAN/IMV" }, { "name": "ISH/UNI", "code": "ISH/UNI" }, { "name": "ISP/UNI", "code": "ISP/UNI" }, { "name": "LIB/FFD", "code": "LIB/FFD" }, { "name": "MAD/STC", "code": "MAD/STC" }, { "name": "MAD/WAY", "code": "MAD/WAY" }, { "name": "MIL/OXF", "code": "MIL/OXF" }, { "name": "MOR/FCO", "code": "MOR/FCO" }, { "name": "OXF/PCO", "code": "OXF/PCO" }, { "name": "RLY/FCO", "code": "RLY/FCO" }, { "name": "ROS/HAN", "code": "ROS/HAN" }, { "name": "STC/ROS", "code": "STC/ROS" }, { "name": "STC/WAY", "code": "STC/WAY" }, { "name": "WAY/MIL", "code": "WAY/MIL" }, { "name": "WAY/PCO", "code": "WAY/PCO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Loc", "type": "esriFieldTypeString", "alias": "Loc", "length": 50, "domain": { "type": "codedValue", "name": "Cul_LOC", "description": "twp abriviations for culvert location", "codedValues": [ { "name": "MADISON", "code": "MAD" }, { "name": "MORGAN", "code": "MOR" }, { "name": "REILY", "code": "RLY" }, { "name": "HANOVER", "code": "HAN" }, { "name": "MILFORD", "code": "MIL" }, { "name": "OXFORD", "code": "OXF" }, { "name": "ROSS", "code": "ROS" }, { "name": "LIBERTY", "code": "LIB" }, { "name": "WAYNE", "code": "WAY" }, { "name": "ST CLAIR", "code": "STC" }, { "name": "FAIRFIELD", "code": "FFD" }, { "name": "LEMON", "code": "LEM" }, { "name": "WEST CHESTER", "code": "WC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "InspGroup", "type": "esriFieldTypeString", "alias": "InspectionGroup", "length": 50, "domain": null }, { "name": "SHAPE_STLe", "type": "esriFieldTypeDouble", "alias": "SHAPE_STLe", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GlobalID_1", "type": "esriFieldTypeGlobalID", "alias": "GlobalID_1", "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": "GlobalID2", "type": "esriFieldTypeGUID", "alias": "GlobalID2", "length": 38, "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R767_pk", "fields": "OBJECTID_1", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_767", "fields": "GlobalID_1,OBJECTID_1", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_767", "fields": "GlobalID_1", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S485_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "gis.DBO.s123_CulvertInsp", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalID2", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1706876420000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "05030f08cb3843a69142405aab1fe022" } ], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "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": [ { "id": 1, "name": "gis.DBO.fc_CulvertLocation", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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": "05030f08cb3843a69142405aab1fe022" }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 2, "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": "05030f08cb3843a69142405aab1fe022" }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 3, "name": "CulvertLocation__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 } ], "indexes": [ { "name": "R771_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_771", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_2232_REL_GLO", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_771", "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": 1706876405000 }, "serviceItemId": "05030f08cb3843a69142405aab1fe022" } ] }