{
 "currentVersion": 11.2,
 "cimVersion": "3.2.0",
 "id": 4,
 "name": "DDOTSGIS.BRIDGE.BRIDGE",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "STRUCNAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "BRKEY",
   "type": "esriFieldTypeString",
   "alias": "BRKEY",
   "length": 15,
   "domain": null
  },
  {
   "name": "BRIDGE_ID",
   "type": "esriFieldTypeString",
   "alias": "BRIDGE_ID",
   "length": 30,
   "domain": null
  },
  {
   "name": "STRUCT_NUM",
   "type": "esriFieldTypeString",
   "alias": "STRUCT_NUM",
   "length": 15,
   "domain": null
  },
  {
   "name": "STRUCNAME",
   "type": "esriFieldTypeString",
   "alias": "STRUCNAME",
   "length": 50,
   "domain": null
  },
  {
   "name": "FEATINT",
   "type": "esriFieldTypeString",
   "alias": "FEATINT",
   "length": 24,
   "domain": null
  },
  {
   "name": "FHWA_REGN",
   "type": "esriFieldTypeString",
   "alias": "FHWA_REGN",
   "length": 1,
   "domain": null
  },
  {
   "name": "DISTRICT",
   "type": "esriFieldTypeString",
   "alias": "DISTRICT",
   "length": 2,
   "domain": null
  },
  {
   "name": "COUNTY",
   "type": "esriFieldTypeString",
   "alias": "COUNTY",
   "length": 3,
   "domain": null
  },
  {
   "name": "FACILITY",
   "type": "esriFieldTypeString",
   "alias": "FACILITY",
   "length": 18,
   "domain": null
  },
  {
   "name": "LOCATION",
   "type": "esriFieldTypeString",
   "alias": "LOCATION",
   "length": 25,
   "domain": null
  },
  {
   "name": "CUSTODIAN",
   "type": "esriFieldTypeString",
   "alias": "CUSTODIAN",
   "length": 2,
   "domain": null
  },
  {
   "name": "OWNER",
   "type": "esriFieldTypeString",
   "alias": "OWNER",
   "length": 2,
   "domain": null
  },
  {
   "name": "ADMINAREA",
   "type": "esriFieldTypeString",
   "alias": "ADMINAREA",
   "length": 2,
   "domain": null
  },
  {
   "name": "BRIDGEGROUP",
   "type": "esriFieldTypeString",
   "alias": "BRIDGEGROUP",
   "length": 20,
   "domain": null
  },
  {
   "name": "NSTATECODE",
   "type": "esriFieldTypeString",
   "alias": "NSTATECODE",
   "length": 3,
   "domain": null
  },
  {
   "name": "N_FHWA_REG",
   "type": "esriFieldTypeString",
   "alias": "N_FHWA_REG",
   "length": 1,
   "domain": null
  },
  {
   "name": "BB_PCT",
   "type": "esriFieldTypeSmallInteger",
   "alias": "BB_PCT",
   "domain": null
  },
  {
   "name": "BB_BRDGEID",
   "type": "esriFieldTypeString",
   "alias": "BB_BRDGEID",
   "length": 15,
   "domain": null
  },
  {
   "name": "PROPWORK",
   "type": "esriFieldTypeString",
   "alias": "PROPWORK",
   "length": 2,
   "domain": null
  },
  {
   "name": "WORKBY",
   "type": "esriFieldTypeString",
   "alias": "WORKBY",
   "length": 1,
   "domain": null
  },
  {
   "name": "NBIIMPCOST",
   "type": "esriFieldTypeInteger",
   "alias": "NBIIMPCOST",
   "domain": null
  },
  {
   "name": "NBIRWCOST",
   "type": "esriFieldTypeInteger",
   "alias": "NBIRWCOST",
   "domain": null
  },
  {
   "name": "NBITOTCOST",
   "type": "esriFieldTypeInteger",
   "alias": "NBITOTCOST",
   "domain": null
  },
  {
   "name": "NBIYRCOST",
   "type": "esriFieldTypeSmallInteger",
   "alias": "NBIYRCOST",
   "domain": null
  },
  {
   "name": "YEARBUILT",
   "type": "esriFieldTypeSmallInteger",
   "alias": "YEARBUILT",
   "domain": null
  },
  {
   "name": "YEARRECON",
   "type": "esriFieldTypeSmallInteger",
   "alias": "YEARRECON",
   "domain": null
  },
  {
   "name": "HISTSIGN",
   "type": "esriFieldTypeString",
   "alias": "HISTSIGN",
   "length": 1,
   "domain": null
  },
  {
   "name": "DESIGNLOAD",
   "type": "esriFieldTypeString",
   "alias": "DESIGNLOAD",
   "length": 1,
   "domain": null
  },
  {
   "name": "SERVTYPON",
   "type": "esriFieldTypeString",
   "alias": "SERVTYPON",
   "length": 1,
   "domain": null
  },
  {
   "name": "SERVTYPUND",
   "type": "esriFieldTypeString",
   "alias": "SERVTYPUND",
   "length": 1,
   "domain": null
  },
  {
   "name": "SUMLANES",
   "type": "esriFieldTypeSmallInteger",
   "alias": "SUMLANES",
   "domain": null
  },
  {
   "name": "MAINSPANS",
   "type": "esriFieldTypeSmallInteger",
   "alias": "MAINSPANS",
   "domain": null
  },
  {
   "name": "APPSPANS",
   "type": "esriFieldTypeSmallInteger",
   "alias": "APPSPANS",
   "domain": null
  },
  {
   "name": "MAXSPAN",
   "type": "esriFieldTypeDouble",
   "alias": "MAXSPAN",
   "domain": null
  },
  {
   "name": "LENGTH",
   "type": "esriFieldTypeDouble",
   "alias": "LENGTH",
   "domain": null
  },
  {
   "name": "DECK_AREA",
   "type": "esriFieldTypeDouble",
   "alias": "DECK_AREA",
   "domain": null
  },
  {
   "name": "BRIDGEMED",
   "type": "esriFieldTypeString",
   "alias": "BRIDGEMED",
   "length": 1,
   "domain": null
  },
  {
   "name": "SKEW",
   "type": "esriFieldTypeSmallInteger",
   "alias": "SKEW",
   "domain": null
  },
  {
   "name": "MATERIALMAIN",
   "type": "esriFieldTypeString",
   "alias": "MATERIALMAIN",
   "length": 1,
   "domain": null
  },
  {
   "name": "DESIGNMAIN",
   "type": "esriFieldTypeString",
   "alias": "DESIGNMAIN",
   "length": 2,
   "domain": null
  },
  {
   "name": "MATERIALAPPR",
   "type": "esriFieldTypeString",
   "alias": "MATERIALAPPR",
   "length": 1,
   "domain": null
  },
  {
   "name": "DESIGNAPPR",
   "type": "esriFieldTypeString",
   "alias": "DESIGNAPPR",
   "length": 2,
   "domain": null
  },
  {
   "name": "DKSTRUCTYP",
   "type": "esriFieldTypeString",
   "alias": "DKSTRUCTYP",
   "length": 1,
   "domain": null
  },
  {
   "name": "DKMEMBTYPE",
   "type": "esriFieldTypeString",
   "alias": "DKMEMBTYPE",
   "length": 1,
   "domain": null
  },
  {
   "name": "DKSURFTYPE",
   "type": "esriFieldTypeString",
   "alias": "DKSURFTYPE",
   "length": 1,
   "domain": null
  },
  {
   "name": "DKPROTECT",
   "type": "esriFieldTypeString",
   "alias": "DKPROTECT",
   "length": 1,
   "domain": null
  },
  {
   "name": "DECKWIDTH",
   "type": "esriFieldTypeDouble",
   "alias": "DECKWIDTH",
   "domain": null
  },
  {
   "name": "LFTCURBSW",
   "type": "esriFieldTypeDouble",
   "alias": "LFTCURBSW",
   "domain": null
  },
  {
   "name": "RTCURBSW",
   "type": "esriFieldTypeDouble",
   "alias": "RTCURBSW",
   "domain": null
  },
  {
   "name": "STRFLARED",
   "type": "esriFieldTypeString",
   "alias": "STRFLARED",
   "length": 1,
   "domain": null
  },
  {
   "name": "REFVUC",
   "type": "esriFieldTypeString",
   "alias": "REFVUC",
   "length": 1,
   "domain": null
  },
  {
   "name": "REFHUC",
   "type": "esriFieldTypeString",
   "alias": "REFHUC",
   "length": 1,
   "domain": null
  },
  {
   "name": "HCLRURT",
   "type": "esriFieldTypeDouble",
   "alias": "HCLRURT",
   "domain": null
  },
  {
   "name": "HCLRULT",
   "type": "esriFieldTypeDouble",
   "alias": "HCLRULT",
   "domain": null
  },
  {
   "name": "LFTBRNAVCL",
   "type": "esriFieldTypeDouble",
   "alias": "LFTBRNAVCL",
   "domain": null
  },
  {
   "name": "NAVCNTROL",
   "type": "esriFieldTypeString",
   "alias": "NAVCNTROL",
   "length": 1,
   "domain": null
  },
  {
   "name": "NAVHC",
   "type": "esriFieldTypeDouble",
   "alias": "NAVHC",
   "domain": null
  },
  {
   "name": "NAVVC",
   "type": "esriFieldTypeDouble",
   "alias": "NAVVC",
   "domain": null
  },
  {
   "name": "PARALSTRUC",
   "type": "esriFieldTypeString",
   "alias": "PARALSTRUC",
   "length": 1,
   "domain": null
  },
  {
   "name": "TEMPSTRUC",
   "type": "esriFieldTypeString",
   "alias": "TEMPSTRUC",
   "length": 1,
   "domain": null
  },
  {
   "name": "NBISLEN",
   "type": "esriFieldTypeString",
   "alias": "NBISLEN",
   "length": 1,
   "domain": null
  },
  {
   "name": "LATITUDE",
   "type": "esriFieldTypeDouble",
   "alias": "LATITUDE",
   "domain": null
  },
  {
   "name": "LONGITUDE",
   "type": "esriFieldTypeDouble",
   "alias": "LONGITUDE",
   "domain": null
  },
  {
   "name": "VCLROVER",
   "type": "esriFieldTypeDouble",
   "alias": "VCLROVER",
   "domain": null
  },
  {
   "name": "VCLRUNDER",
   "type": "esriFieldTypeDouble",
   "alias": "VCLRUNDER",
   "domain": null
  },
  {
   "name": "PLACECODE",
   "type": "esriFieldTypeString",
   "alias": "PLACECODE",
   "length": 5,
   "domain": null
  },
  {
   "name": "IMPLEN",
   "type": "esriFieldTypeDouble",
   "alias": "IMPLEN",
   "domain": null
  },
  {
   "name": "FIPS_STATE",
   "type": "esriFieldTypeString",
   "alias": "FIPS_STATE",
   "length": 2,
   "domain": null
  },
  {
   "name": "TOT_LENGTH",
   "type": "esriFieldTypeDouble",
   "alias": "TOT_LENGTH",
   "domain": null
  },
  {
   "name": "NEXTINSPID",
   "type": "esriFieldTypeString",
   "alias": "NEXTINSPID",
   "length": 32,
   "domain": null
  },
  {
   "name": "CREWHRS",
   "type": "esriFieldTypeSingle",
   "alias": "CREWHRS",
   "domain": null
  },
  {
   "name": "FLAGGERHRS",
   "type": "esriFieldTypeSingle",
   "alias": "FLAGGERHRS",
   "domain": null
  },
  {
   "name": "HELPERHRS",
   "type": "esriFieldTypeSingle",
   "alias": "HELPERHRS",
   "domain": null
  },
  {
   "name": "SNOOPERHRS",
   "type": "esriFieldTypeSingle",
   "alias": "SNOOPERHRS",
   "domain": null
  },
  {
   "name": "SPCREWHRS",
   "type": "esriFieldTypeSingle",
   "alias": "SPCREWHRS",
   "domain": null
  },
  {
   "name": "SPEQUIPHRS",
   "type": "esriFieldTypeSingle",
   "alias": "SPEQUIPHRS",
   "domain": null
  },
  {
   "name": "ON_OFF_SYS",
   "type": "esriFieldTypeString",
   "alias": "ON_OFF_SYS",
   "length": 1,
   "domain": null
  },
  {
   "name": "RATINGDATE",
   "type": "esriFieldTypeDate",
   "alias": "RATINGDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "RATER_INI",
   "type": "esriFieldTypeString",
   "alias": "RATER_INI",
   "length": 3,
   "domain": null
  },
  {
   "name": "ORLOAD",
   "type": "esriFieldTypeDouble",
   "alias": "ORLOAD",
   "domain": null
  },
  {
   "name": "ORTYPE",
   "type": "esriFieldTypeString",
   "alias": "ORTYPE",
   "length": 1,
   "domain": null
  },
  {
   "name": "IRLOAD",
   "type": "esriFieldTypeDouble",
   "alias": "IRLOAD",
   "domain": null
  },
  {
   "name": "IRTYPE",
   "type": "esriFieldTypeString",
   "alias": "IRTYPE",
   "length": 1,
   "domain": null
  },
  {
   "name": "POSTING",
   "type": "esriFieldTypeString",
   "alias": "POSTING",
   "length": 1,
   "domain": null
  },
  {
   "name": "REQ_OP_RAT",
   "type": "esriFieldTypeSmallInteger",
   "alias": "REQ_OP_RAT",
   "domain": null
  },
  {
   "name": "DEF_OP_RAT",
   "type": "esriFieldTypeString",
   "alias": "DEF_OP_RAT",
   "length": 1,
   "domain": null
  },
  {
   "name": "FC_DETAIL",
   "type": "esriFieldTypeString",
   "alias": "FC_DETAIL",
   "length": 5,
   "domain": null
  },
  {
   "name": "ALTORLOAD",
   "type": "esriFieldTypeDouble",
   "alias": "ALTORLOAD",
   "domain": null
  },
  {
   "name": "ALTORMETH",
   "type": "esriFieldTypeString",
   "alias": "ALTORMETH",
   "length": 4,
   "domain": null
  },
  {
   "name": "ALTIRLOAD",
   "type": "esriFieldTypeDouble",
   "alias": "ALTIRLOAD",
   "domain": null
  },
  {
   "name": "ALTIRMETH",
   "type": "esriFieldTypeString",
   "alias": "ALTIRMETH",
   "length": 4,
   "domain": null
  },
  {
   "name": "OTHERLOAD",
   "type": "esriFieldTypeDouble",
   "alias": "OTHERLOAD",
   "domain": null
  },
  {
   "name": "TRUCK1OR",
   "type": "esriFieldTypeDouble",
   "alias": "TRUCK1OR",
   "domain": null
  },
  {
   "name": "TRUCK2OR",
   "type": "esriFieldTypeDouble",
   "alias": "TRUCK2OR",
   "domain": null
  },
  {
   "name": "TRUCK3OR",
   "type": "esriFieldTypeDouble",
   "alias": "TRUCK3OR",
   "domain": null
  },
  {
   "name": "TRUCK1IR",
   "type": "esriFieldTypeDouble",
   "alias": "TRUCK1IR",
   "domain": null
  },
  {
   "name": "TRUCK2IR",
   "type": "esriFieldTypeDouble",
   "alias": "TRUCK2IR",
   "domain": null
  },
  {
   "name": "TRUCK3IR",
   "type": "esriFieldTypeDouble",
   "alias": "TRUCK3IR",
   "domain": null
  },
  {
   "name": "SRSTATUS",
   "type": "esriFieldTypeString",
   "alias": "SRSTATUS",
   "length": 1,
   "domain": null
  },
  {
   "name": "USERKEY1",
   "type": "esriFieldTypeString",
   "alias": "USERKEY1",
   "length": 30,
   "domain": null
  },
  {
   "name": "USERKEY2",
   "type": "esriFieldTypeString",
   "alias": "USERKEY2",
   "length": 30,
   "domain": null
  },
  {
   "name": "USERKEY3",
   "type": "esriFieldTypeString",
   "alias": "USERKEY3",
   "length": 30,
   "domain": null
  },
  {
   "name": "USERKEY4",
   "type": "esriFieldTypeString",
   "alias": "USERKEY4",
   "length": 30,
   "domain": null
  },
  {
   "name": "USERKEY5",
   "type": "esriFieldTypeString",
   "alias": "USERKEY5",
   "length": 30,
   "domain": null
  },
  {
   "name": "USERKEY6",
   "type": "esriFieldTypeString",
   "alias": "USERKEY6",
   "length": 30,
   "domain": null
  },
  {
   "name": "USERKEY7",
   "type": "esriFieldTypeString",
   "alias": "USERKEY7",
   "length": 30,
   "domain": null
  },
  {
   "name": "USERKEY8",
   "type": "esriFieldTypeString",
   "alias": "USERKEY8",
   "length": 30,
   "domain": null
  },
  {
   "name": "USERKEY9",
   "type": "esriFieldTypeString",
   "alias": "USERKEY9",
   "length": 30,
   "domain": null
  },
  {
   "name": "USERKEY10",
   "type": "esriFieldTypeString",
   "alias": "USERKEY10",
   "length": 30,
   "domain": null
  },
  {
   "name": "USERKEY11",
   "type": "esriFieldTypeString",
   "alias": "USERKEY11",
   "length": 30,
   "domain": null
  },
  {
   "name": "USERKEY12",
   "type": "esriFieldTypeString",
   "alias": "USERKEY12",
   "length": 30,
   "domain": null
  },
  {
   "name": "USERKEY13",
   "type": "esriFieldTypeString",
   "alias": "USERKEY13",
   "length": 30,
   "domain": null
  },
  {
   "name": "USERKEY14",
   "type": "esriFieldTypeString",
   "alias": "USERKEY14",
   "length": 30,
   "domain": null
  },
  {
   "name": "USERKEY15",
   "type": "esriFieldTypeString",
   "alias": "USERKEY15",
   "length": 30,
   "domain": null
  },
  {
   "name": "BTRIGGER",
   "type": "esriFieldTypeString",
   "alias": "BTRIGGER",
   "length": 1,
   "domain": null
  },
  {
   "name": "TRACEFLAG",
   "type": "esriFieldTypeString",
   "alias": "TRACEFLAG",
   "length": 1,
   "domain": null
  },
  {
   "name": "CREATEDATETIME",
   "type": "esriFieldTypeDate",
   "alias": "CREATEDATETIME",
   "length": 8,
   "domain": null
  },
  {
   "name": "CREATEUSERKEY",
   "type": "esriFieldTypeString",
   "alias": "CREATEUSERKEY",
   "length": 32,
   "domain": null
  },
  {
   "name": "MODTIME",
   "type": "esriFieldTypeDate",
   "alias": "MODTIME",
   "length": 8,
   "domain": null
  },
  {
   "name": "USERKEY",
   "type": "esriFieldTypeString",
   "alias": "USERKEY",
   "length": 32,
   "domain": null
  },
  {
   "name": "DOCREFKEY",
   "type": "esriFieldTypeString",
   "alias": "DOCREFKEY",
   "length": 255,
   "domain": null
  },
  {
   "name": "NOTES",
   "type": "esriFieldTypeString",
   "alias": "NOTES",
   "length": 2000,
   "domain": null
  },
  {
   "name": "bridge_status",
   "type": "esriFieldTypeString",
   "alias": "bridge_status",
   "length": 8,
   "domain": null
  },
  {
   "name": "bridge_lifecycle_phase",
   "type": "esriFieldTypeString",
   "alias": "bridge_lifecycle_phase",
   "length": 8,
   "domain": null
  },
  {
   "name": "IMPACT",
   "type": "esriFieldTypeDouble",
   "alias": "IMPACT",
   "domain": null
  },
  {
   "name": "ORFACTOR",
   "type": "esriFieldTypeSingle",
   "alias": "ORFACTOR",
   "domain": null
  },
  {
   "name": "IRFACTOR",
   "type": "esriFieldTypeSingle",
   "alias": "IRFACTOR",
   "domain": null
  },
  {
   "name": "PRECISE_LAT",
   "type": "esriFieldTypeDouble",
   "alias": "PRECISE_LAT",
   "domain": null
  },
  {
   "name": "PRECISE_LON",
   "type": "esriFieldTypeDouble",
   "alias": "PRECISE_LON",
   "domain": null
  },
  {
   "name": "BRIDGE_GD",
   "type": "esriFieldTypeString",
   "alias": "BRIDGE_GD",
   "length": 32,
   "domain": null
  },
  {
   "name": "BRIDGE_LB",
   "type": "esriFieldTypeString",
   "alias": "BRIDGE_LB",
   "length": 50,
   "domain": null
  },
  {
   "name": "SU4",
   "type": "esriFieldTypeString",
   "alias": "SU4",
   "length": 50,
   "domain": null
  },
  {
   "name": "SU5",
   "type": "esriFieldTypeString",
   "alias": "SU5",
   "length": 50,
   "domain": null
  },
  {
   "name": "SU6",
   "type": "esriFieldTypeString",
   "alias": "SU6",
   "length": 50,
   "domain": null
  },
  {
   "name": "SU7",
   "type": "esriFieldTypeString",
   "alias": "SU7",
   "length": 50,
   "domain": null
  },
  {
   "name": "NRL",
   "type": "esriFieldTypeString",
   "alias": "NRL",
   "length": 50,
   "domain": null
  },
  {
   "name": "MPO",
   "type": "esriFieldTypeString",
   "alias": "MPO",
   "length": 50,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R592_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "I16862BRIDGE_GD",
   "fields": "BRIDGE_GD",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_16862_BRKEY",
   "fields": "BRKEY",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "BRMBridgeLines",
   "relatedTableId": 2,
   "role": "esriRelRoleDestination",
   "keyField": "BRKEY",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{663C7F33-07CB-4237-8B2B-EEFBC4B3ABA5}"
  }
 ],
 "capabilities": "Data,Map,Query",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "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,
  "supportsTimeRelation": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": {
  "timeZone": "Eastern Standard Time",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}