Dataset: Bridges

About this Dataset

Bridges

This file contains location and identification information for bridges in Oregon. This includes bridges owned by the state, cities, counties, and other owners such as railroad bridges that cross state highways. It does not include bridges that are owned by Federal agencies. A bridge is a structure including supports erected over a depression or an obstruction, such as water, highway, or railway, and having a track or passageway for carrying traffic or other moving loads and having an opening measured along the center of the roadway of more than 20 feet.
Organization: State of Oregon
Last updated: 2024-02-09T16:06:17.556567
Tags: 2020, or, oregon, pacific-northwest, trans_gis, united-states, usa

Tables

Table 1

@usgov.state_of_oregon_bridges_6ae19.table_1

1.33 MB
10343 rows
55 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "bridge_id" VARCHAR,
  "bridge_nam" VARCHAR,
  "carries" VARCHAR,
  "crosses" VARCHAR,
  "length_ft" DOUBLE,
  "width_ft" DOUBLE,
  "lanes" VARCHAR,
  "main_spans" BIGINT,
  "appr_spans" VARCHAR,
  "design" VARCHAR,
  "material" VARCHAR,
  "owner" VARCHAR,
  "road_ident" VARCHAR,
  "nbi_bridge" VARCHAR,
  "custodian" VARCHAR,
  "year" VARCHAR,
  "admin_area" VARCHAR,
  "odot_reg" VARCHAR,
  "odot_dist" VARCHAR,
  "cnty_name" VARCHAR,
  "city_name" VARCHAR,
  "movable_b" VARCHAR,
  "detour_len" DOUBLE,
  "appr_type" VARCHAR,
  "appr_mat" VARCHAR,
  "deck_rd_wd" DOUBLE,
  "struc_typ" VARCHAR,
  "deck_surf_typ" VARCHAR,
  "spans" VARCHAR,
  "railmat" VARCHAR,
  "timber_sub" VARCHAR,
  "posting" VARCHAR,
  "bridge_con" VARCHAR,
  "suf_rating" DOUBLE,
  "insp_date" TIMESTAMP,
  "weight_res" VARCHAR,
  "status" VARCHAR,
  "dkrating" VARCHAR,
  "suprating" VARCHAR,
  "subrating" VARCHAR,
  "culvrating" VARCHAR,
  "scourcrit" VARCHAR,
  "scour_vuln" VARCHAR,
  "railrating" VARCHAR,
  "structure_num" VARCHAR,
  "mp" DOUBLE,
  "hwy_and_con" VARCHAR,
  "sign_bridge" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "gis_prc_dt" TIMESTAMP,
  "effectv_dt" BIGINT
);