About this Dataset

BLM OR Culverts Point Hub

CULVERTS_PUB_PT: This dataset defines attributes for major and minor culvert structures. According to BLM Manual 9100, a culvert is “a conduit or passageway, not classified as a bridge, under a road, trail, or other facility usually consisting of a round pipe, a pipe-arch, or an open or closed bottom box or arch.” Major culverts are defined as “a culvert having a clear opening of more than 35 square feet or multiple installations of culverts placed adjacent or contiguous as units and having a combined clear opening of more than 35 square feet.” This dataset only reflects the most current condition of the culvert as of the last visit and does not track the history of the culvert over time. Historic (removed) features may be retained in the parent Structures dataset.
Organization: Department of the Interior
Last updated: 2024-02-09T05:14:35.015784
Tags: culvert, disturbance, environment, facility, geospatial, hydrology, management, oregon, structure, washington

Tables

Table 1

@usgov.doi_gov_blm_or_culverts_point_hub.table_1

3.11 MB
28,220 rows
62 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "globalid" VARCHAR,
  "name" VARCHAR,
  "structure_type" VARCHAR,
  "status" VARCHAR,
  "project_name" VARCHAR,
  "structure_date" VARCHAR,
  "last_maintenance_date" VARCHAR,
  "inspection_date" VARCHAR,
  "fams_key" VARCHAR,
  "milepost" DOUBLE,
  "roadnum" VARCHAR,
  "routeseg" VARCHAR,
  "elevation_ft" DOUBLE  -- Elevation (ft),
  "shape" VARCHAR,
  "material" VARCHAR,
  "ditch_relief_culvert" VARCHAR  -- Ditch Relief Culvert?,
  "width_inches" DOUBLE  -- Width (inches),
  "height_inches" DOUBLE  -- Height (inches),
  "length_ft" DOUBLE  -- Length (ft),
  "inlet_fill_depth_ft" DOUBLE  -- Inlet Fill Depth (ft),
  "outlet_fill_depth_ft" DOUBLE  -- Outlet Fill Depth (ft),
  "downspout_type" VARCHAR,
  "downspout_length_ft" DOUBLE  -- Downspout Length (ft),
  "outlet_drop_ft" DOUBLE  -- Outlet Drop (ft),
  "plunge_pool" VARCHAR  -- Plunge Pool?,
  "plunge_pool_maximum_depth_ft" DOUBLE  -- Plunge Pool Maximum Depth (ft),
  "plunge_pool_length_ft" DOUBLE  -- Plunge Pool Length (ft),
  "plunge_pool_scour_line_width_ft" DOUBLE  -- Plunge Pool Scour Line Width (ft),
  "broken_seams_splits_or_disbanded" VARCHAR  -- Broken Seams, Splits Or Disbanded?,
  "rusted_out" VARCHAR,
  "flow_bypassing" VARCHAR  -- Flow Bypassing?,
  "skewed" VARCHAR  -- Skewed?,
  "warped_shifted" VARCHAR  -- Warped/Shifted?,
  "crimp_damage" VARCHAR  -- Crimp Damage?,
  "other_damage" VARCHAR  -- Other Damage?,
  "inlet_debris" VARCHAR  -- Inlet Debris?,
  "outlet_debris" VARCHAR  -- Outlet Debris?,
  "downcutting" VARCHAR  -- Downcutting?,
  "dissipator" VARCHAR  -- Dissipator?,
  "erosion_of_fill" VARCHAR  -- Erosion Of Fill?,
  "bankfull_width_ft" DOUBLE  -- Bankfull Width (ft),
  "replacement_priority" VARCHAR,
  "alternative" VARCHAR,
  "local_link" VARCHAR,
  "administrative_unit_code" VARCHAR,
  "facility_admin" VARCHAR,
  "reason" VARCHAR,
  "reason_2" VARCHAR,
  "plan_id" VARCHAR,
  "initiative" VARCHAR,
  "initiative_2" VARCHAR,
  "budget_code" DOUBLE,
  "workagent" VARCHAR,
  "coordinate_source" VARCHAR,
  "accuracy_ft" DOUBLE  -- Accuracy (ft),
  "structures_unique_identifier" VARCHAR,
  "current" VARCHAR,
  "structure_date_accuracy" VARCHAR,
  "last_maint_date_accuracy" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);