{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "Inspections", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Inspector", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Inspect_Date", "type": "esriFieldTypeDate", "alias": "Inspect_Date", "length": 8, "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 255, "domain": null }, { "name": "Surf_Con", "type": "esriFieldTypeString", "alias": "Surf_Con", "length": 255, "domain": { "type": "codedValue", "name": "OverallCon", "description": "Overall Condition", "codedValues": [ { "name": "9 - EXCELLENT", "code": "9 - EXCELLENT " }, { "name": "8 - VERY GOOD", "code": "8 - VERY GOOD " }, { "name": "7 - GOOD", "code": "7 - GOOD " }, { "name": "6 - SATISFACTORY", "code": "6 - SATISFACTORY " }, { "name": "5 - FAIR", "code": "5 - FAIR " }, { "name": "4 - POOR", "code": "4 - POOR " }, { "name": "3 - SERIOUS", "code": "3 - SERIOUS " }, { "name": "2 - CRITICAL", "code": "2 - CRITICAL " }, { "name": "1 - IMMINENT FAILURE", "code": "1 - IMMINENT FAILURE " }, { "name": "0 - FAILED", "code": "0 - FAILED " }, { "name": "N - Not Applicable", "code": "N - Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Deck_Con", "type": "esriFieldTypeString", "alias": "Deck_Con", "length": 255, "domain": { "type": "codedValue", "name": "OverallCon", "description": "Overall Condition", "codedValues": [ { "name": "9 - EXCELLENT", "code": "9 - EXCELLENT " }, { "name": "8 - VERY GOOD", "code": "8 - VERY GOOD " }, { "name": "7 - GOOD", "code": "7 - GOOD " }, { "name": "6 - SATISFACTORY", "code": "6 - SATISFACTORY " }, { "name": "5 - FAIR", "code": "5 - FAIR " }, { "name": "4 - POOR", "code": "4 - POOR " }, { "name": "3 - SERIOUS", "code": "3 - SERIOUS " }, { "name": "2 - CRITICAL", "code": "2 - CRITICAL " }, { "name": "1 - IMMINENT FAILURE", "code": "1 - IMMINENT FAILURE " }, { "name": "0 - FAILED", "code": "0 - FAILED " }, { "name": "N - Not Applicable", "code": "N - Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SupStruc_Con", "type": "esriFieldTypeString", "alias": "SupStruc_Con", "length": 255, "domain": { "type": "codedValue", "name": "OverallCon", "description": "Overall Condition", "codedValues": [ { "name": "9 - EXCELLENT", "code": "9 - EXCELLENT " }, { "name": "8 - VERY GOOD", "code": "8 - VERY GOOD " }, { "name": "7 - GOOD", "code": "7 - GOOD " }, { "name": "6 - SATISFACTORY", "code": "6 - SATISFACTORY " }, { "name": "5 - FAIR", "code": "5 - FAIR " }, { "name": "4 - POOR", "code": "4 - POOR " }, { "name": "3 - SERIOUS", "code": "3 - SERIOUS " }, { "name": "2 - CRITICAL", "code": "2 - CRITICAL " }, { "name": "1 - IMMINENT FAILURE", "code": "1 - IMMINENT FAILURE " }, { "name": "0 - FAILED", "code": "0 - FAILED " }, { "name": "N - Not Applicable", "code": "N - Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SubStruc_Con", "type": "esriFieldTypeString", "alias": "SubStruc_Con", "length": 255, "domain": { "type": "codedValue", "name": "OverallCon", "description": "Overall Condition", "codedValues": [ { "name": "9 - EXCELLENT", "code": "9 - EXCELLENT " }, { "name": "8 - VERY GOOD", "code": "8 - VERY GOOD " }, { "name": "7 - GOOD", "code": "7 - GOOD " }, { "name": "6 - SATISFACTORY", "code": "6 - SATISFACTORY " }, { "name": "5 - FAIR", "code": "5 - FAIR " }, { "name": "4 - POOR", "code": "4 - POOR " }, { "name": "3 - SERIOUS", "code": "3 - SERIOUS " }, { "name": "2 - CRITICAL", "code": "2 - CRITICAL " }, { "name": "1 - IMMINENT FAILURE", "code": "1 - IMMINENT FAILURE " }, { "name": "0 - FAILED", "code": "0 - FAILED " }, { "name": "N - Not Applicable", "code": "N - Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cul_Con", "type": "esriFieldTypeString", "alias": "Cul_Con", "length": 255, "domain": { "type": "codedValue", "name": "OverallCon", "description": "Overall Condition", "codedValues": [ { "name": "9 - EXCELLENT", "code": "9 - EXCELLENT " }, { "name": "8 - VERY GOOD", "code": "8 - VERY GOOD " }, { "name": "7 - GOOD", "code": "7 - GOOD " }, { "name": "6 - SATISFACTORY", "code": "6 - SATISFACTORY " }, { "name": "5 - FAIR", "code": "5 - FAIR " }, { "name": "4 - POOR", "code": "4 - POOR " }, { "name": "3 - SERIOUS", "code": "3 - SERIOUS " }, { "name": "2 - CRITICAL", "code": "2 - CRITICAL " }, { "name": "1 - IMMINENT FAILURE", "code": "1 - IMMINENT FAILURE " }, { "name": "0 - FAILED", "code": "0 - FAILED " }, { "name": "N - Not Applicable", "code": "N - Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Head_Con", "type": "esriFieldTypeString", "alias": "Head_Con", "length": 255, "domain": { "type": "codedValue", "name": "OverallCon", "description": "Overall Condition", "codedValues": [ { "name": "9 - EXCELLENT", "code": "9 - EXCELLENT " }, { "name": "8 - VERY GOOD", "code": "8 - VERY GOOD " }, { "name": "7 - GOOD", "code": "7 - GOOD " }, { "name": "6 - SATISFACTORY", "code": "6 - SATISFACTORY " }, { "name": "5 - FAIR", "code": "5 - FAIR " }, { "name": "4 - POOR", "code": "4 - POOR " }, { "name": "3 - SERIOUS", "code": "3 - SERIOUS " }, { "name": "2 - CRITICAL", "code": "2 - CRITICAL " }, { "name": "1 - IMMINENT FAILURE", "code": "1 - IMMINENT FAILURE " }, { "name": "0 - FAILED", "code": "0 - FAILED " }, { "name": "N - Not Applicable", "code": "N - Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Rail_Con", "type": "esriFieldTypeString", "alias": "Rail_Con", "length": 255, "domain": { "type": "codedValue", "name": "OverallCon", "description": "Overall Condition", "codedValues": [ { "name": "9 - EXCELLENT", "code": "9 - EXCELLENT " }, { "name": "8 - VERY GOOD", "code": "8 - VERY GOOD " }, { "name": "7 - GOOD", "code": "7 - GOOD " }, { "name": "6 - SATISFACTORY", "code": "6 - SATISFACTORY " }, { "name": "5 - FAIR", "code": "5 - FAIR " }, { "name": "4 - POOR", "code": "4 - POOR " }, { "name": "3 - SERIOUS", "code": "3 - SERIOUS " }, { "name": "2 - CRITICAL", "code": "2 - CRITICAL " }, { "name": "1 - IMMINENT FAILURE", "code": "1 - IMMINENT FAILURE " }, { "name": "0 - FAILED", "code": "0 - FAILED " }, { "name": "N - Not Applicable", "code": "N - Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Chan_Con", "type": "esriFieldTypeString", "alias": "Chan_Con", "length": 255, "domain": { "type": "codedValue", "name": "OverallCon", "description": "Overall Condition", "codedValues": [ { "name": "9 - EXCELLENT", "code": "9 - EXCELLENT " }, { "name": "8 - VERY GOOD", "code": "8 - VERY GOOD " }, { "name": "7 - GOOD", "code": "7 - GOOD " }, { "name": "6 - SATISFACTORY", "code": "6 - SATISFACTORY " }, { "name": "5 - FAIR", "code": "5 - FAIR " }, { "name": "4 - POOR", "code": "4 - POOR " }, { "name": "3 - SERIOUS", "code": "3 - SERIOUS " }, { "name": "2 - CRITICAL", "code": "2 - CRITICAL " }, { "name": "1 - IMMINENT FAILURE", "code": "1 - IMMINENT FAILURE " }, { "name": "0 - FAILED", "code": "0 - FAILED " }, { "name": "N - Not Applicable", "code": "N - Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Life", "type": "esriFieldTypeString", "alias": "Life", "length": 255, "domain": null }, { "name": "Report", "type": "esriFieldTypeString", "alias": "Report", "length": 255, "domain": null }, { "name": "Road", "type": "esriFieldTypeString", "alias": "Road", "length": 255, "domain": { "type": "codedValue", "name": "RoadMat", "description": "Road and Shoulder Material", "codedValues": [ { "name": "Bituminous (asphalt)", "code": "Bituminous (asphalt)" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Gravel/earth", "code": "Gravel/earth" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Road_Com", "type": "esriFieldTypeString", "alias": "Road_Com", "length": 255, "domain": null }, { "name": "Shoul_Mat", "type": "esriFieldTypeString", "alias": "Shoul_Mat", "length": 255, "domain": { "type": "codedValue", "name": "RoadMat", "description": "Road and Shoulder Material", "codedValues": [ { "name": "Bituminous (asphalt)", "code": "Bituminous (asphalt)" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Gravel/earth", "code": "Gravel/earth" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Deck_Mat", "type": "esriFieldTypeString", "alias": "Deck_Mat", "length": 255, "domain": { "type": "codedValue", "name": "StructMat", "description": "Structure Material", "codedValues": [ { "name": "Aluminum", "code": "Aluminum" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Masonry", "code": "Masonry" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Steel", "code": "Steel" }, { "name": "Timber", "code": "Timber" }, { "name": "Other", "code": "Other" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Deck_Com", "type": "esriFieldTypeString", "alias": "Deck_Com", "length": 255, "domain": null }, { "name": "Sub_Mat", "type": "esriFieldTypeString", "alias": "Sub_Mat", "length": 255, "domain": { "type": "codedValue", "name": "StructMat", "description": "Structure Material", "codedValues": [ { "name": "Aluminum", "code": "Aluminum" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Masonry", "code": "Masonry" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Steel", "code": "Steel" }, { "name": "Timber", "code": "Timber" }, { "name": "Other", "code": "Other" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sub_Com", "type": "esriFieldTypeString", "alias": "Sub_Com", "length": 255, "domain": null }, { "name": "Sup_Mat", "type": "esriFieldTypeString", "alias": "Sup_Mat", "length": 255, "domain": { "type": "codedValue", "name": "StructMat", "description": "Structure Material", "codedValues": [ { "name": "Aluminum", "code": "Aluminum" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Masonry", "code": "Masonry" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Steel", "code": "Steel" }, { "name": "Timber", "code": "Timber" }, { "name": "Other", "code": "Other" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sup_Com", "type": "esriFieldTypeString", "alias": "Sup_Com", "length": 255, "domain": null }, { "name": "Pipe_Mat", "type": "esriFieldTypeString", "alias": "Pipe_Mat", "length": 255, "domain": { "type": "codedValue", "name": "StructMat", "description": "Structure Material", "codedValues": [ { "name": "Aluminum", "code": "Aluminum" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Masonry", "code": "Masonry" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Steel", "code": "Steel" }, { "name": "Timber", "code": "Timber" }, { "name": "Other", "code": "Other" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Pipe_Com", "type": "esriFieldTypeString", "alias": "Pipe_Com", "length": 255, "domain": null }, { "name": "Head_Mat", "type": "esriFieldTypeString", "alias": "Head_Mat", "length": 255, "domain": { "type": "codedValue", "name": "StructMat", "description": "Structure Material", "codedValues": [ { "name": "Aluminum", "code": "Aluminum" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Masonry", "code": "Masonry" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Steel", "code": "Steel" }, { "name": "Timber", "code": "Timber" }, { "name": "Other", "code": "Other" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Head_Com", "type": "esriFieldTypeString", "alias": "Head_Com", "length": 255, "domain": null }, { "name": "Rail_Com", "type": "esriFieldTypeString", "alias": "Rail_Com", "length": 255, "domain": null }, { "name": "Chan_Mat", "type": "esriFieldTypeString", "alias": "Chan_Mat", "length": 255, "domain": null }, { "name": "Chan_Com", "type": "esriFieldTypeString", "alias": "Chan_Com", "length": 255, "domain": null }, { "name": "Road_O", "type": "esriFieldTypeString", "alias": "Road_O", "length": 255, "domain": null }, { "name": "Stream", "type": "esriFieldTypeString", "alias": "Stream", "length": 255, "domain": null }, { "name": "Pave_Wid", "type": "esriFieldTypeDouble", "alias": "Pave_Wid", "domain": null }, { "name": "Townsh", "type": "esriFieldTypeString", "alias": "Townsh", "length": 255, "domain": { "type": "codedValue", "name": "Township", "description": "Township", "codedValues": [ { "name": "Preble", "code": "Preble" }, { "name": "Root", "code": "Root" }, { "name": "Union", "code": "Union" }, { "name": "Kirkland", "code": "Kirkland" }, { "name": "Washington", "code": "Washington" }, { "name": "St. Marys", "code": "St. Marys" }, { "name": "French", "code": "French" }, { "name": "Monroe", "code": "Monroe" }, { "name": "Blue Creek", "code": "Blue Creek" }, { "name": "Hartford", "code": "Hartford" }, { "name": "Wabash", "code": "Wabash" }, { "name": "Jefferson", "code": "Jefferson" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Struc_Type", "type": "esriFieldTypeString", "alias": "Struc_Type", "length": 255, "domain": null }, { "name": "Leng", "type": "esriFieldTypeDouble", "alias": "Leng", "domain": null }, { "name": "Cl_RD_Wd", "type": "esriFieldTypeDouble", "alias": "Cl_RD_Wd", "domain": null }, { "name": "Spans", "type": "esriFieldTypeDouble", "alias": "Spans", "domain": null }, { "name": "Skew", "type": "esriFieldTypeDouble", "alias": "Skew", "domain": null }, { "name": "Pi_Length", "type": "esriFieldTypeDouble", "alias": "Pi_Length", "domain": null }, { "name": "Vert_Open", "type": "esriFieldTypeDouble", "alias": "Vert_Open", "domain": null }, { "name": "Limit", "type": "esriFieldTypeDouble", "alias": "Limit", "domain": null }, { "name": "Other", "type": "esriFieldTypeDouble", "alias": "Other", "domain": null }, { "name": "Diam", "type": "esriFieldTypeDouble", "alias": "Diam", "domain": null }, { "name": "Depth", "type": "esriFieldTypeDouble", "alias": "Depth", "domain": null }, { "name": "Hor_Open", "type": "esriFieldTypeDouble", "alias": "Hor_Open", "domain": null }, { "name": "Year_Built", "type": "esriFieldTypeDouble", "alias": "Year_Built", "domain": null }, { "name": "Road_Mat", "type": "esriFieldTypeString", "alias": "Road_Mat", "length": 255, "domain": null }, { "name": "Rail_Cond", "type": "esriFieldTypeString", "alias": "Rail_Cond", "length": 255, "domain": { "type": "codedValue", "name": "OverallCon", "description": "Overall Condition", "codedValues": [ { "name": "9 - EXCELLENT", "code": "9 - EXCELLENT " }, { "name": "8 - VERY GOOD", "code": "8 - VERY GOOD " }, { "name": "7 - GOOD", "code": "7 - GOOD " }, { "name": "6 - SATISFACTORY", "code": "6 - SATISFACTORY " }, { "name": "5 - FAIR", "code": "5 - FAIR " }, { "name": "4 - POOR", "code": "4 - POOR " }, { "name": "3 - SERIOUS", "code": "3 - SERIOUS " }, { "name": "2 - CRITICAL", "code": "2 - CRITICAL " }, { "name": "1 - IMMINENT FAILURE", "code": "1 - IMMINENT FAILURE " }, { "name": "0 - FAILED", "code": "0 - FAILED " }, { "name": "N - Not Applicable", "code": "N - Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "End_Mark", "type": "esriFieldTypeString", "alias": "End_Mark", "length": 255, "domain": null }, { "name": "Rail_Mat", "type": "esriFieldTypeString", "alias": "Rail_Mat", "length": 255, "domain": null }, { "name": "EM_Mat", "type": "esriFieldTypeString", "alias": "EM_Mat", "length": 255, "domain": null }, { "name": "EM_Con", "type": "esriFieldTypeString", "alias": "EM_Con", "length": 255, "domain": { "type": "codedValue", "name": "OverallCon", "description": "Overall Condition", "codedValues": [ { "name": "9 - EXCELLENT", "code": "9 - EXCELLENT " }, { "name": "8 - VERY GOOD", "code": "8 - VERY GOOD " }, { "name": "7 - GOOD", "code": "7 - GOOD " }, { "name": "6 - SATISFACTORY", "code": "6 - SATISFACTORY " }, { "name": "5 - FAIR", "code": "5 - FAIR " }, { "name": "4 - POOR", "code": "4 - POOR " }, { "name": "3 - SERIOUS", "code": "3 - SERIOUS " }, { "name": "2 - CRITICAL", "code": "2 - CRITICAL " }, { "name": "1 - IMMINENT FAILURE", "code": "1 - IMMINENT FAILURE " }, { "name": "0 - FAILED", "code": "0 - FAILED " }, { "name": "N - Not Applicable", "code": "N - Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EM_Com", "type": "esriFieldTypeString", "alias": "EM_Com", "length": 255, "domain": null }, { "name": "Wat_Adeq", "type": "esriFieldTypeString", "alias": "Wat_Adeq", "length": 255, "domain": { "type": "codedValue", "name": "Waterway", "description": "Waterway Adequacy", "codedValues": [ { "name": "9 - Bridge above flood water elevation", "code": "9 - Bridge above flood water elevation" }, { "name": "8 - Bridge above approaches", "code": "8 - Bridge above approaches" }, { "name": "7 - Slight Chance of overtopping", "code": "7 - Slight Chance of overtopping" }, { "name": "6 - Occasional Overtopping of Approaches - Insignificant Delays", "code": "6 - Occasional Overtopping of Approaches - Insignificant Delays" }, { "name": "5 - Occasional Overtopping of Approaches - significant Delays", "code": "5 - Occasional Overtopping of Approaches - significant Delays" }, { "name": "4 - Occasional Overtopping of Deck and Approaches - significant Delays", "code": "4 - Occasional Overtopping of Deck and Approaches - significant Delays" }, { "name": "3 - Frequent Flooding - Significant Delays", "code": "3 - Frequent Flooding - Significant Delays" }, { "name": "2 - Frequent Floods - Sever Delays", "code": "2 - Frequent Floods - Sever Delays" }, { "name": "0 - Closed - Failure - Replace", "code": "0 - Closed - Failure - Replace" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Struct_Num", "type": "esriFieldTypeDouble", "alias": "Struct_Num", "domain": null } ], "indexes": [ { "name": "R14_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_6_Struct_Num", "fields": "Struct_Num", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Structure", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Struct_Num", "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": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": false }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }