About this Dataset

BLM OR Structures Line Hub

STRCT_ARC: Structures are discrete, physically existing things that are built. Structures are things created to support treatment, recreation or other management activities. STRCT_ARC contains, but is not limited to, features such as pipelines, fences, and trails.
Organization: Department of the Interior
Last updated: 2024-02-09T05:04:31.542988
Tags: boundaries, construction, geospatial, improvements, management, oregon, structure, structures, washington

Tables

Table 1

@usgov.doi_gov_blm_or_structures_line_hub.table_1

2.12 MB
19,157 rows
38 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,
  "current" VARCHAR,
  "cartographic_text" VARCHAR,
  "gis_miles" DOUBLE,
  "height_ft" DOUBLE  -- Height (ft),
  "alternative" VARCHAR,
  "archaeological_clearance_date" VARCHAR,
  "botany_clearance_date" VARCHAR,
  "wildlife_clearance_date" VARCHAR,
  "buffer_radius_m" DOUBLE  -- Buffer Radius (m),
  "local_link" VARCHAR,
  "coordinate_source" VARCHAR,
  "accuracy_ft" DOUBLE  -- Accuracy (ft),
  "structures_unique_identifier" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);