{
"currentVersion": 10.22,
"id": 300,
"name": "fpfgis.SDE.tblBridgeConditionAppraisal_1",
"type": "Table",
"description": "",
"copyrightText": "",
"defaultVisibility": false,
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [
{
"id": 14,
"name": "BridgeIdentification",
"relatedTableId": 1,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleDestination",
"keyField": "OBJECTID",
"composite": true
}
],
"isDataVersioned": false,
"supportsRollbackOnFailureParameter": false,
"supportsStatistics": true,
"supportsAdvancedQueries": true,
"hasAttachments": true,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "GlobalID",
"displayField": "Item113",
"typeIdField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false
},
{
"name": "Item8",
"type": "esriFieldTypeInteger",
"alias": "Structure No.",
"domain": null,
"editable": true,
"nullable": true
},
{
"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
}
]
},
"editable": true,
"nullable": true
},
{
"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
}
]
},
"editable": true,
"nullable": true
},
{
"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
}
]
},
"editable": true,
"nullable": true
},
{
"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
}
]
},
"editable": true,
"nullable": true
},
{
"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
}
]
},
"editable": true,
"nullable": true
},
{
"name": "Item113",
"type": "esriFieldTypeString",
"alias": "Scour Critical Bridges",
"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"
}
]
},
"editable": true,
"nullable": true,
"length": 1
},
{
"name": "Item71",
"type": "esriFieldTypeString",
"alias": "Waterway Adequacy",
"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"
}
]
},
"editable": true,
"nullable": true,
"length": 1
},
{
"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
}
]
},
"editable": true,
"nullable": true
},
{
"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
}
]
},
"editable": true,
"nullable": true
},
{
"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
}
]
},
"editable": true,
"nullable": true
},
{
"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
}
]
},
"editable": true,
"nullable": true
},
{
"name": "SufficiencyRating",
"type": "esriFieldTypeDouble",
"alias": "Sufficiency Rating",
"domain": null,
"editable": true,
"nullable": true
},
{
"name": "Deficiency",
"type": "esriFieldTypeString",
"alias": "Deficiency",
"domain": {
"type": "codedValue",
"name": "deficiency",
"codedValues": [
{
"name": "Not Deficient",
"code": "0"
},
{
"name": "Structurally Deficient",
"code": "1"
},
{
"name": "Functionally Obsolete",
"code": "-1"
}
]
},
"editable": true,
"nullable": true,
"length": 50
},
{
"name": "Item58Com",
"type": "esriFieldTypeString",
"alias": "Deck Comments",
"domain": null,
"editable": true,
"nullable": true,
"length": 500
},
{
"name": "Item59Com",
"type": "esriFieldTypeString",
"alias": "Superstructure Comments",
"domain": null,
"editable": true,
"nullable": true,
"length": 500
},
{
"name": "Item60Com",
"type": "esriFieldTypeString",
"alias": "Substructure Comments",
"domain": null,
"editable": true,
"nullable": true,
"length": 500
},
{
"name": "Item61Com",
"type": "esriFieldTypeString",
"alias": "Channel Comments",
"domain": null,
"editable": true,
"nullable": true,
"length": 500
},
{
"name": "Item62Com",
"type": "esriFieldTypeString",
"alias": "Culvert Comments",
"domain": null,
"editable": true,
"nullable": true,
"length": 500
},
{
"name": "Item113Com",
"type": "esriFieldTypeString",
"alias": "Scour Comments",
"domain": null,
"editable": true,
"nullable": true,
"length": 500
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38
}
],
"types": [],
"templates": [
{
"name": "fpfgis.SDE.tblBridgeConditionAppraisal_1",
"description": "",
"prototype": {
"attributes": {
"Item113Com": null,
"Item8": null,
"Item58R": null,
"Item59R": null,
"Item60R": null,
"Item61R": null,
"Item62R": null,
"Item113": null,
"Item71": null,
"Item67": null,
"Item68": null,
"Item69": null,
"Item72": null,
"SufficiencyRating": null,
"Deficiency": null,
"Item58Com": null,
"Item59Com": null,
"Item60Com": null,
"Item61Com": null,
"Item62Com": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, AMF",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing",
"useStandardizedQueries": true
}