About this Dataset

Mileposts

This data contains the location and legend of mileposts markers (signs) on state owned highways.

Additional metadata resouce: https://geoportalprod-ordot.msappproxy.net/geoportal/catalog/main/home.page
Organization: State of Oregon
Last updated: 2025-07-26T19:25:34.007619
Tags: highway, markers, mile, mile-markers, mile-posts, mileposts, or, oregon, pacific-northwest, roadnetwork, trans_gis, transportation, transportation-network, united-states, us, usa

Tables

Table 1

@usgov.state_of_oregon_mileposts_7f9d2.table_1

436.02 kB
7,662 rows
18 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "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,
  "lrm_key" VARCHAR,
  "lrs_key" VARCHAR,
  "lat" DOUBLE,
  "longtd" DOUBLE,
  "gis_prc_dt" TIMESTAMP,
  "effectv_dt" BIGINT
);