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

About this Dataset

Mileposts

This data contains the location and legend of mileposts markers (signs) on state owned highways.
Organization: State of Oregon
Last updated: 2024-02-09T16:03:58.679941
Tags: 2020, highway, markers, mile, mile-markers, mile-posts, mileposts, odot, or, oregon, pacific-northwest, roadnetwork, trans_gis, transportation, transportation-network, united-states, us, usa

Tables

Table 1

@usgov.state_of_oregon_mileposts.table_1

712.23 kB
7,650 rows
21 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "hwyname" VARCHAR,
  "hwynumb" BIGINT,
  "st_hwy_sfx" VARCHAR,
  "rdwy_id" BIGINT,
  "mlge_typ" VARCHAR,
  "ovlp_cd" BIGINT,
  "mp" DOUBLE,
  "mp_desc" VARCHAR,
  "mp_disp" VARCHAR,
  "lrs_key" VARCHAR,
  "lrm_key" VARCHAR,
  "lat" DOUBLE,
  "longtd" DOUBLE,
  "hrz_col_m" BIGINT,
  "crd_rf_dtm" VARCHAR,
  "effectv_dt" BIGINT,
  "gis_prc_dt" TIMESTAMP,
  "globalid" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);