{ "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" }