About this Dataset

All Public Roads

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 maintenance for) the road data each dataset contains. Data from each dataset is compiled into a statewide dataset that has the best available 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: 2025-01-31T22:13:42.061869
Tags: centerlines, highways, odot, oregon, ortrans, roads, street, transportation

Tables

Table 1

@usgov.state_of_oregon_all_public_roads.table_1

34.72 MB
792,196 rows
31 columns

CREATE TABLE table_1 (
  "roadowner" VARCHAR,
  "roadmgr" VARCHAR,
  "owner_id" DOUBLE,
  "mgr_id" DOUBLE,
  "prefix" VARCHAR,
  "name" VARCHAR,
  "type" VARCHAR,
  "suffix" VARCHAR,
  "alias_prefix" VARCHAR,
  "alias_name" VARCHAR,
  "alias_type" VARCHAR,
  "alias_suffix" VARCHAR,
  "ud_dt" TIMESTAMP,
  "create_dt" TIMESTAMP,
  "l_low_add" DOUBLE,
  "l_high_add" DOUBLE,
  "r_low_add" DOUBLE,
  "r_high_add" DOUBLE,
  "base_id" VARCHAR,
  "seg_mrk_id" VARCHAR,
  "hwynumb" DOUBLE,
  "lrs_local" VARCHAR,
  "lrs_key" VARCHAR,
  "begmp" DOUBLE,
  "endmp" DOUBLE,
  "originator" VARCHAR,
  "origtr_id" BIGINT,
  "shape_length" DOUBLE,
  "effectv_dt" BIGINT,
  "gis_prc_dt" TIMESTAMP,
  "objectid" BIGINT
);