About this Dataset

Oregon Highway Network

This statewide file includes all state owned highways, connections, frontage roads. Major changes/updates included in the 2017 layer: US-18 Dundee Bypass, I-5 Fern Valley, I-5 Woodburn Interchange, OR-140, OR-214 Sunrise Expressway, US-20 Pioneer Mountain to Eddyville.
Organization: State of Oregon
Last updated: 2024-02-09T16:04:03.676505
Tags: 2020, or, oregon, pacific-northwest, roadnetwork, state, trans_gis, transportation, united-states, us, usa

Tables

Table 1

@usgov.state_of_oregon_oregon_highway_network.table_1

458.11 kB
21,300 rows
14 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "hwyname" VARCHAR,
  "hwynumb" BIGINT,
  "st_hwy_sfx" VARCHAR,
  "rdwy_id" BIGINT,
  "mlge_typ" VARCHAR,
  "ovlap_cd" BIGINT,
  "rdwy_typ" VARCHAR,
  "begmp" DOUBLE,
  "endmp" DOUBLE,
  "lrs_key" VARCHAR,
  "lrm_key" VARCHAR,
  "gis_prc_dt" TIMESTAMP,
  "effectv_dt" BIGINT
);