About this Dataset

Road Centerlines

OR-Trans is a GIS road centerline dataset compiled from numerous sources of data throughout the state. Each dataset is from the road authority responsible for (or assigned data maintenace for) the road data each dataset contains. Data from each dataset is compiled into a statewide dataset that has the best avaialble data from each road authority for their jurisdiction (or assigned data maintenance responsibility). Data is stored in a SQL database and exported in numerous formats.
Organization: State of Oregon
Last updated: 2024-02-09T16:04:39.120628
Tags: 2021, all-roads, highway, or, or_trans, oregon, oregon-transportation-network, ortrans, pacific-northwest, road, road-authority, roadnetwork, routes, streets, transportation, united-states, us, usa

Tables

Table 1

@usgov.state_of_oregon_or_trans.table_1

53.04 MB
749,714 rows
49 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "roadowner" VARCHAR,
  "roadmgr" VARCHAR,
  "originator" VARCHAR,
  "updater" VARCHAR,
  "owner_id" BIGINT,
  "mgr_id" BIGINT,
  "origtr_id" BIGINT,
  "ud_id" BIGINT,
  "meas_cd" BIGINT,
  "locl_id" DOUBLE,
  "locl_lrs" VARCHAR,
  "locl_fc" VARCHAR,
  "path_desc" VARCHAR,
  "locl_beg_m" DOUBLE,
  "locl_end_m" DOUBLE,
  "create_dt" VARCHAR,
  "ud_dt" VARCHAR,
  "validt_dt" VARCHAR,
  "rtir_dt" VARCHAR,
  "stat_cd" VARCHAR,
  "locl_len" DOUBLE,
  "l_low_add" DOUBLE,
  "l_high_add" DOUBLE,
  "r_low_add" DOUBLE,
  "r_high_add" DOUBLE,
  "number" VARCHAR,
  "prefix" VARCHAR,
  "name" VARCHAR,
  "type" VARCHAR,
  "suffix" VARCHAR,
  "alias_prefix" VARCHAR,
  "alias_name" VARCHAR,
  "alias_type" VARCHAR,
  "alias_suffix" VARCHAR,
  "l_zip" DOUBLE,
  "r_zip" DOUBLE,
  "lcity" VARCHAR,
  "rcity" VARCHAR,
  "lcnty" VARCHAR,
  "rcnty" VARCHAR,
  "lrs" VARCHAR,
  "beg_mrk" VARCHAR,
  "beg_offst" DOUBLE,
  "end_mrk" VARCHAR,
  "end_offst" DOUBLE,
  "effectv_dt" BIGINT,
  "gis_prc_dt" TIMESTAMP,
  "shape_length" DOUBLE  -- Shape, Length
);