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

About this Dataset

Culverts

This data identifies point locations of known culverts. The data was taken from the Drainage Facilities Management System (DFMS) and TransInfo (TI).
Organization: State of Oregon
Last updated: 2024-02-09T16:07:24.069649
Tags: 2022, bridge, trans_gis, transportation

Tables

Table 1

@usgov.state_of_oregon_culverts_37594.table_1

1.56 MB
22,423 rows
39 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "hwynumb" BIGINT,
  "st_hwy_sfx" VARCHAR,
  "rdwy_id" BIGINT,
  "mp" DOUBLE,
  "mlge_typ" VARCHAR,
  "ovlp_cd" BIGINT,
  "dfi" VARCHAR,
  "insp_dt" VARCHAR,
  "coll_srce" VARCHAR,
  "nbi_struc" VARCHAR,
  "facil_usge" VARCHAR,
  "yr_built" VARCHAR,
  "ornt" VARCHAR,
  "inlet_side" VARCHAR,
  "in_end_typ" VARCHAR,
  "outend_typ" VARCHAR,
  "struc_wd" DOUBLE,
  "no_brrl" BIGINT,
  "length" DOUBLE,
  "span" BIGINT,
  "rise" BIGINT,
  "matl" VARCHAR,
  "brrl_shape" VARCHAR,
  "ht_cov_in" DOUBLE,
  "ht_cov_out" DOUBLE,
  "stream_nm" VARCHAR,
  "odot_reg" BIGINT,
  "odot_dist" VARCHAR,
  "countyname" VARCHAR,
  "lrs_key" VARCHAR,
  "lrm_key" VARCHAR,
  "lat" DOUBLE,
  "longtd" DOUBLE,
  "datum_nm" VARCHAR,
  "effectv_dt" BIGINT,
  "gis_prc_dt" TIMESTAMP
);