About this Dataset

BLM OR Structures Point Hub

STRCT_PT: Structures are things created to support treatment, recreation or other management activities. STRCT_PT tends to contain but is not limited to site-features (non-linear) such as cattle guards, gates, fence ties, towers, wells etc.
Organization: Department of the Interior
Last updated: 2025-09-25T02:42:43.863581
Tags: boundaries, construction, geospatial, improvements, management, oregon, structure, structures, washington

Tables

Table 1

@usgov.doi_gov_blm_or_structures_point_hub_b529f.table_1

6.82 MB
61,497 rows
42 columns

CREATE TABLE table_1 (
  "structure_date_accuracy" VARCHAR,
  "last_maint_date_accuracy" VARCHAR,
  "treatment_unique_identifier" VARCHAR,
  "objectid" BIGINT,
  "globalid" VARCHAR,
  "name" VARCHAR,
  "structure_type" VARCHAR,
  "status" VARCHAR,
  "project_name" VARCHAR,
  "structure_date" VARCHAR,
  "last_maintenance_date" VARCHAR,
  "condition" VARCHAR,
  "materials" VARCHAR,
  "reason" VARCHAR,
  "reason_2" VARCHAR,
  "administrative_unit_code" VARCHAR,
  "facility_admin" VARCHAR,
  "plan_id" VARCHAR,
  "initiative" VARCHAR,
  "initiative_2" VARCHAR,
  "budget_code" VARCHAR,
  "workagent" VARCHAR,
  "fams_key" VARCHAR,
  "rips_key" VARCHAR,
  "nhd_reach_code" VARCHAR,
  "current" VARCHAR,
  "cartographic_text" VARCHAR,
  "elevation_ft" DOUBLE  -- Elevation (ft),
  "height_ft" DOUBLE  -- Height (ft),
  "alternative" VARCHAR,
  "archaeological_clearance_date" VARCHAR,
  "botany_clearance_date" VARCHAR,
  "wildlife_clearance_date" VARCHAR,
  "side_measure_m" DOUBLE  -- Side Measure (m),
  "buffer_radius_m" DOUBLE  -- Buffer Radius (m),
  "symbol_rotation_deg" DOUBLE  -- Symbol Rotation (deg),
  "local_link" VARCHAR,
  "coordinate_source" VARCHAR,
  "accuracy_ft" DOUBLE  -- Accuracy (ft),
  "structures_unique_identifier" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);