Name: Signed Routes
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Signed Routes

This file includes all signed Interstate, US, and State routes for the State of Oregon.
Organization: State of Oregon
Last updated: 2024-02-09T16:06:41.287272
Tags: north-america, or, oregon, pacific-northwest, roadnetwork, trans_gis, transportation, united-states, us, usa

Tables

Table 1

@usgov.state_of_oregon_signed_routes.table_1

91.39 kB
2,764 rows
21 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "hwyname" VARCHAR,
  "hwynumb" DOUBLE,
  "st_hwy_sfx" VARCHAR,
  "rdwy_id" DOUBLE,
  "mlge_typ" VARCHAR,
  "ovlp_cd" DOUBLE,
  "begmp" DOUBLE,
  "endmp" DOUBLE,
  "all_rte" VARCHAR,
  "jrsdct" VARCHAR,
  "road_name" VARCHAR,
  "lrm_key" VARCHAR,
  "i_sign" DOUBLE,
  "us_sign_1" VARCHAR,
  "us_sign_2" VARCHAR,
  "or_sign_1" VARCHAR,
  "or_sign_2" VARCHAR,
  "lrs_key" VARCHAR,
  "effectv_dt" BIGINT,
  "gis_prc_dt" TIMESTAMP
);