Name: Bridge_ODOT
Display Field: bridge_nam
Type: Table
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- bridge_id (type: esriFieldTypeString, alias: Bridge ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- bridge_nam (type: esriFieldTypeString, alias: Structure Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- carries (type: esriFieldTypeString, alias: Facility Carried, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- crosses (type: esriFieldTypeString, alias: Feature Intersected, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- length_ft (type: esriFieldTypeDouble, alias: Structure Length (Ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
- width_ft (type: esriFieldTypeDouble, alias: Deck Width (Ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
- lanes (type: esriFieldTypeString, alias: Through Lanes on the Structure, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- main_spans (type: esriFieldTypeString, alias: Main Unit Spans, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- appr_spans (type: esriFieldTypeString, alias: Approach Spans, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- design (type: esriFieldTypeString, alias: Main Span Design Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- material (type: esriFieldTypeString, alias: Main Span Material Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- owner (type: esriFieldTypeString, alias: Structure Owner, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- road_ident (type: esriFieldTypeString, alias: Road Identifier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- nbi_bridge (type: esriFieldTypeString, alias: On National Bridge Inventory, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- custodian (type: esriFieldTypeString, alias: Maintenance Responsibility, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- year (type: esriFieldTypeString, alias: Year of Construction, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- admin_area (type: esriFieldTypeString, alias: Administration Area, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- odot_reg (type: esriFieldTypeString, alias: ODOT Region, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- odot_dist (type: esriFieldTypeString, alias: ODOT District, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- cnty_name (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- city_name (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- movable_b (type: esriFieldTypeString, alias: Movable Bridge, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- detour_len (type: esriFieldTypeDouble, alias: Detour Length (Mi), SQL Type: sqlTypeOther, nullable: true, editable: true)
- appr_type (type: esriFieldTypeString, alias: Approach Span Design Type, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- appr_mat (type: esriFieldTypeString, alias: Approach Span Material Type, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- deck_rd_wd (type: esriFieldTypeDouble, alias: Curb to Curb Roadway Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
- struc_typ (type: esriFieldTypeString, alias: Deck Structure Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- deck_surf_typ (type: esriFieldTypeString, alias: Deck Surface Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- spans (type: esriFieldTypeString, alias: Description and Length of Spans, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- railmat (type: esriFieldTypeString, alias: Railing Material Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- timber_sub (type: esriFieldTypeString, alias: Timber Substructure, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- posting (type: esriFieldTypeString, alias: Bridge Posting Status, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- bridge_con (type: esriFieldTypeString, alias: Bridge Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- suf_rating (type: esriFieldTypeDouble, alias: Sufficiency Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)
- insp_date (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- weight_res (type: esriFieldTypeString, alias: Weight Restriction, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- status (type: esriFieldTypeString, alias: Posting Status, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- dkrating (type: esriFieldTypeString, alias: Deck Rating, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- suprating (type: esriFieldTypeString, alias: Superstructure Rating, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- subrating (type: esriFieldTypeString, alias: Substructure Rating, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- culvrating (type: esriFieldTypeString, alias: Culvert Rating, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- scourcrit (type: esriFieldTypeString, alias: Scour Critical, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- scour_vuln (type: esriFieldTypeString, alias: Scour Vulnerability, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- railrating (type: esriFieldTypeString, alias: Railing Safety Rating, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- structure_num (type: esriFieldTypeString, alias: Structure Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- mp (type: esriFieldTypeDouble, alias: Milepoint, SQL Type: sqlTypeOther, nullable: true, editable: true)
- hwy_and_con (type: esriFieldTypeString, alias: Highway and Connection, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- sign_bridge (type: esriFieldTypeString, alias: Sign Bridge, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- long (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- lat (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- gis_prc_dt (type: esriFieldTypeString, alias: GIS Process Date, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- effectv_dt (type: esriFieldTypeString, alias: Effective Date, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- feature_date_updated (type: esriFieldTypeDate, alias: Feature Date Updated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Templates:
Name: Bridge_ODOT
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
- Bridge (0) -- Related To: Bridge (0)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/1/2026 10:16:52 AM
Schema Last Edit Date: 2/17/2026 10:01:36 PM
Data Last Edit Date: 9/1/2026 10:16:52 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat