About this Dataset

BLM OR Fire Water Sources Point Hub

FWTR_SRC_POINT: This theme depicts sources of water for fire management purposes that are accessible by engines, water tenders, pumps, or helicopter buckets. Water sources that are identified are judged to be useable during the period of a normal fire season. This theme does not depict water for uses other than fire fighting. For example, potable water is not identified in this theme.
Organization: Department of the Interior
Last updated: 2024-02-09T05:09:44.892916
Tags: environment, fire, fire-climate, fire-pond, geospatial, hydrology, inlandwaters, management, oregon, pump-chance, structure, washington, water, waterhole, wildfire, wildland-fire

Tables

Table 1

@usgov.doi_gov_blm_or_fire_water_sources_point_hub.table_1

63.59 kB
336 rows
35 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "globalid" VARCHAR,
  "fire_water_source_id" BIGINT,
  "water_source_name" VARCHAR,
  "established_year_yyyy" DOUBLE  -- Established Year (YYYY),
  "last_visit_date" VARCHAR,
  "last_visit_date_accuracy" VARCHAR,
  "sustainability" VARCHAR,
  "pump_distance_ft" DOUBLE  -- Pump Distance (ft),
  "water_depth_ft" DOUBLE  -- Water Depth (ft),
  "water_source" VARCHAR,
  "in_water_work_period" VARCHAR,
  "helicopter_type" VARCHAR,
  "tender_utilization" VARCHAR,
  "engine_utilization" VARCHAR,
  "portable_utilization" VARCHAR,
  "constructed" VARCHAR,
  "sealer" VARCHAR,
  "restriction_type" VARCHAR,
  "maintenance_needs" VARCHAR,
  "maintenance_priority" VARCHAR,
  "water_rights_number" VARCHAR,
  "blm_org_code" VARCHAR,
  "facility_admin" VARCHAR,
  "latitude_ddm" VARCHAR  -- Latitude (DDM),
  "longitude_ddm" VARCHAR  -- Longitude (DDM),
  "township" VARCHAR,
  "range" VARCHAR,
  "section" BIGINT,
  "quarter_section" VARCHAR,
  "surface_elevation_m" BIGINT  -- Surface Elevation (m),
  "coordinate_source" VARCHAR,
  "accuracy_ft" DOUBLE  -- Accuracy (ft),
  "x" DOUBLE,
  "y" DOUBLE
);