{
 "currentVersion": 10.22,
 "id": 300,
 "name": "fpfgis.SDE.tblBridgeConditionAppraisal_1",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "Item113",
 "typeIdField": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "Item8",
   "type": "esriFieldTypeInteger",
   "alias": "Structure No.",
   "domain": null
  },
  {
   "name": "Item58R",
   "type": "esriFieldTypeInteger",
   "alias": "Deck Condition Rating",
   "domain": {
    "type": "codedValue",
    "name": "dmnConditionRating_1",
    "codedValues": [
     {
      "name": "Excellent Condition",
      "code": 9
     },
     {
      "name": "Very Good Condition",
      "code": 8
     },
     {
      "name": "Good Condition",
      "code": 7
     },
     {
      "name": "Satisfactory Condition",
      "code": 6
     },
     {
      "name": "Fair Condition",
      "code": 5
     },
     {
      "name": "Poor Condition",
      "code": 4
     },
     {
      "name": "Serious Conditioin",
      "code": 3
     },
     {
      "name": "Critical Condition",
      "code": 2
     },
     {
      "name": "Imminent Failure Condition",
      "code": 1
     },
     {
      "name": "Failed Condition",
      "code": 10
     },
     {
      "name": "N/A",
      "code": 0
     }
    ]
   }
  },
  {
   "name": "Item59R",
   "type": "esriFieldTypeInteger",
   "alias": "Superstructure Condition Rating",
   "domain": {
    "type": "codedValue",
    "name": "dmnConditionRating_1",
    "codedValues": [
     {
      "name": "Excellent Condition",
      "code": 9
     },
     {
      "name": "Very Good Condition",
      "code": 8
     },
     {
      "name": "Good Condition",
      "code": 7
     },
     {
      "name": "Satisfactory Condition",
      "code": 6
     },
     {
      "name": "Fair Condition",
      "code": 5
     },
     {
      "name": "Poor Condition",
      "code": 4
     },
     {
      "name": "Serious Conditioin",
      "code": 3
     },
     {
      "name": "Critical Condition",
      "code": 2
     },
     {
      "name": "Imminent Failure Condition",
      "code": 1
     },
     {
      "name": "Failed Condition",
      "code": 10
     },
     {
      "name": "N/A",
      "code": 0
     }
    ]
   }
  },
  {
   "name": "Item60R",
   "type": "esriFieldTypeInteger",
   "alias": "Substructure Condition Rating",
   "domain": {
    "type": "codedValue",
    "name": "dmnConditionRating_1",
    "codedValues": [
     {
      "name": "Excellent Condition",
      "code": 9
     },
     {
      "name": "Very Good Condition",
      "code": 8
     },
     {
      "name": "Good Condition",
      "code": 7
     },
     {
      "name": "Satisfactory Condition",
      "code": 6
     },
     {
      "name": "Fair Condition",
      "code": 5
     },
     {
      "name": "Poor Condition",
      "code": 4
     },
     {
      "name": "Serious Conditioin",
      "code": 3
     },
     {
      "name": "Critical Condition",
      "code": 2
     },
     {
      "name": "Imminent Failure Condition",
      "code": 1
     },
     {
      "name": "Failed Condition",
      "code": 10
     },
     {
      "name": "N/A",
      "code": 0
     }
    ]
   }
  },
  {
   "name": "Item61R",
   "type": "esriFieldTypeInteger",
   "alias": "Channel and Channel Protection Rating",
   "domain": {
    "type": "codedValue",
    "name": "dmnConditionRating_1",
    "codedValues": [
     {
      "name": "Excellent Condition",
      "code": 9
     },
     {
      "name": "Very Good Condition",
      "code": 8
     },
     {
      "name": "Good Condition",
      "code": 7
     },
     {
      "name": "Satisfactory Condition",
      "code": 6
     },
     {
      "name": "Fair Condition",
      "code": 5
     },
     {
      "name": "Poor Condition",
      "code": 4
     },
     {
      "name": "Serious Conditioin",
      "code": 3
     },
     {
      "name": "Critical Condition",
      "code": 2
     },
     {
      "name": "Imminent Failure Condition",
      "code": 1
     },
     {
      "name": "Failed Condition",
      "code": 10
     },
     {
      "name": "N/A",
      "code": 0
     }
    ]
   }
  },
  {
   "name": "Item62R",
   "type": "esriFieldTypeInteger",
   "alias": "Culvert Condition Rating",
   "domain": {
    "type": "codedValue",
    "name": "dmnConditionRating_1",
    "codedValues": [
     {
      "name": "Excellent Condition",
      "code": 9
     },
     {
      "name": "Very Good Condition",
      "code": 8
     },
     {
      "name": "Good Condition",
      "code": 7
     },
     {
      "name": "Satisfactory Condition",
      "code": 6
     },
     {
      "name": "Fair Condition",
      "code": 5
     },
     {
      "name": "Poor Condition",
      "code": 4
     },
     {
      "name": "Serious Conditioin",
      "code": 3
     },
     {
      "name": "Critical Condition",
      "code": 2
     },
     {
      "name": "Imminent Failure Condition",
      "code": 1
     },
     {
      "name": "Failed Condition",
      "code": 10
     },
     {
      "name": "N/A",
      "code": 0
     }
    ]
   }
  },
  {
   "name": "Item113",
   "type": "esriFieldTypeString",
   "alias": "Scour Critical Bridges",
   "length": 1,
   "domain": {
    "type": "codedValue",
    "name": "dmnBridgeClassItem113",
    "codedValues": [
     {
      "name": "Bridge not over waterway.",
      "code": "N"
     },
     {
      "name": "Bridge Foundations (Including Piles) well above flood waters.",
      "code": "9"
     },
     {
      "name": "Bridge Foundations determined to be stable for calculated scour conditions.",
      "code": "8"
     },
     {
      "name": "Countermeasures have been installed to correct a previously existing problem with scour.",
      "code": "7"
     },
     {
      "name": "Scour calculation/evaluation has not been made.",
      "code": "6"
     },
     {
      "name": "Bridge foundations determined to be stable for calculated scour conditions.",
      "code": "5"
     },
     {
      "name": "Bridge foundations determined to stable for calculated scour; field review indicates action is required to protect exposed foundations from effects of additional erosion.",
      "code": "4"
     },
     {
      "name": "Bridge scour is critical; bridge foundations determined to be unstable for calculated scour conditions.",
      "code": "3"
     },
     {
      "name": "Bridge is scour critical; field review indicates that extensive scour has occured at bridge foundations. Immediate action is required.",
      "code": "2"
     },
     {
      "name": "Bridge is scour critical; field review indicates that failure of piers/abutments is imminent. Bridge is closed to traffic.",
      "code": "1"
     },
     {
      "name": "Bridge is scour critical; Bridge has failed and is closed to traffic.",
      "code": "0"
     }
    ]
   }
  },
  {
   "name": "Item71",
   "type": "esriFieldTypeString",
   "alias": "Waterway Adequacy",
   "length": 1,
   "domain": {
    "type": "codedValue",
    "name": "dmnBridgeClassItem71_1",
    "codedValues": [
     {
      "name": "Bridge not over a waterway.",
      "code": "N"
     },
     {
      "name": "Bridge deck above roadway approaches. Slight chance of overtopping roadway approaches.",
      "code": "8"
     },
     {
      "name": "Bridge deck above roadway appoaches. Occasional overtopping of roadway approaches with significant traffic delays.",
      "code": "5"
     },
     {
      "name": "Occasional overtopping of bridge deck and roadway approaches with significant traffic delays.",
      "code": "4"
     },
     {
      "name": "Frequent overtopping of bridge deck and roadway approaches with significant traffic delays.",
      "code": "3"
     },
     {
      "name": "Occasional or frequent overtopping of bridge deck and roadway approaches with severe traffic delays.",
      "code": "2"
     },
     {
      "name": "Bridge closed.",
      "code": "0"
     },
     {
      "name": "Bridge deck and roadway approaches above flood water elevations. Chance of overtopping is remote.",
      "code": "9"
     }
    ]
   }
  },
  {
   "name": "Item67",
   "type": "esriFieldTypeInteger",
   "alias": "Structure Evaluation",
   "domain": {
    "type": "codedValue",
    "name": "dmnBridgeClassItem67",
    "codedValues": [
     {
      "name": "Superior to present desirable criteria.",
      "code": 9
     },
     {
      "name": "Equal to present desirable criteria.",
      "code": 8
     },
     {
      "name": "Better than present minimum criteria.",
      "code": 7
     },
     {
      "name": "Equal to present minimum criteria.",
      "code": 6
     },
     {
      "name": "Somewhat better than minimum adequacy.",
      "code": 5
     },
     {
      "name": "Meets minimum tolerable criteria.",
      "code": 4
     },
     {
      "name": "Basically intolerable requiring high priority corrective action.",
      "code": 3
     },
     {
      "name": "Basically intolerable requiring high priority replacement.",
      "code": 2
     },
     {
      "name": "Bridge Closed.",
      "code": 0
     }
    ]
   }
  },
  {
   "name": "Item68",
   "type": "esriFieldTypeInteger",
   "alias": "Deck Geometry",
   "domain": {
    "type": "codedValue",
    "name": "dmnBridgeClassItem67",
    "codedValues": [
     {
      "name": "Superior to present desirable criteria.",
      "code": 9
     },
     {
      "name": "Equal to present desirable criteria.",
      "code": 8
     },
     {
      "name": "Better than present minimum criteria.",
      "code": 7
     },
     {
      "name": "Equal to present minimum criteria.",
      "code": 6
     },
     {
      "name": "Somewhat better than minimum adequacy.",
      "code": 5
     },
     {
      "name": "Meets minimum tolerable criteria.",
      "code": 4
     },
     {
      "name": "Basically intolerable requiring high priority corrective action.",
      "code": 3
     },
     {
      "name": "Basically intolerable requiring high priority replacement.",
      "code": 2
     },
     {
      "name": "Bridge Closed.",
      "code": 0
     }
    ]
   }
  },
  {
   "name": "Item69",
   "type": "esriFieldTypeInteger",
   "alias": "Underclearances, Vert & Horizontal",
   "domain": {
    "type": "codedValue",
    "name": "dmnBridgeClassItem67",
    "codedValues": [
     {
      "name": "Superior to present desirable criteria.",
      "code": 9
     },
     {
      "name": "Equal to present desirable criteria.",
      "code": 8
     },
     {
      "name": "Better than present minimum criteria.",
      "code": 7
     },
     {
      "name": "Equal to present minimum criteria.",
      "code": 6
     },
     {
      "name": "Somewhat better than minimum adequacy.",
      "code": 5
     },
     {
      "name": "Meets minimum tolerable criteria.",
      "code": 4
     },
     {
      "name": "Basically intolerable requiring high priority corrective action.",
      "code": 3
     },
     {
      "name": "Basically intolerable requiring high priority replacement.",
      "code": 2
     },
     {
      "name": "Bridge Closed.",
      "code": 0
     }
    ]
   }
  },
  {
   "name": "Item72",
   "type": "esriFieldTypeInteger",
   "alias": "Approach Rdwy Alignment",
   "domain": {
    "type": "codedValue",
    "name": "dmnBridgeClassItem72",
    "codedValues": [
     {
      "name": "Equal to present desirable criteria.",
      "code": 8
     },
     {
      "name": "Equal to present minimum criteria.",
      "code": 6
     },
     {
      "name": "Basically intolerable requiring high priority of corrective action.",
      "code": 3
     }
    ]
   }
  },
  {
   "name": "SufficiencyRating",
   "type": "esriFieldTypeDouble",
   "alias": "Sufficiency Rating",
   "domain": null
  },
  {
   "name": "Deficiency",
   "type": "esriFieldTypeString",
   "alias": "Deficiency",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "deficiency",
    "codedValues": [
     {
      "name": "Not Deficient",
      "code": "0"
     },
     {
      "name": "Structurally Deficient",
      "code": "1"
     },
     {
      "name": "Functionally Obsolete",
      "code": "-1"
     }
    ]
   }
  },
  {
   "name": "Item58Com",
   "type": "esriFieldTypeString",
   "alias": "Deck Comments",
   "length": 500,
   "domain": null
  },
  {
   "name": "Item59Com",
   "type": "esriFieldTypeString",
   "alias": "Superstructure Comments",
   "length": 500,
   "domain": null
  },
  {
   "name": "Item60Com",
   "type": "esriFieldTypeString",
   "alias": "Substructure Comments",
   "length": 500,
   "domain": null
  },
  {
   "name": "Item61Com",
   "type": "esriFieldTypeString",
   "alias": "Channel Comments",
   "length": 500,
   "domain": null
  },
  {
   "name": "Item62Com",
   "type": "esriFieldTypeString",
   "alias": "Culvert Comments",
   "length": 500,
   "domain": null
  },
  {
   "name": "Item113Com",
   "type": "esriFieldTypeString",
   "alias": "Scour Comments",
   "length": 500,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  }
 ],
 "relationships": [
  {
   "id": 14,
   "name": "BridgeIdentification",
   "relatedTableId": 1,
   "role": "esriRelRoleDestination",
   "keyField": "OBJECTID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, AMF",
 "useStandardizedQueries": true
}