BLM OR Harvest Land Treatments Polygon Hub
Department of the Interior
@usgov.doi_gov_blm_or_harvest_land_treatments_polygon_hub
Department of the Interior
@usgov.doi_gov_blm_or_harvest_land_treatments_polygon_hub
CREATE TABLE table_1 (
"forestry_treatment" VARCHAR,
"treatment_date_accuracy" VARCHAR,
"vmap_treatment_identifier" VARCHAR,
"national_flag_code" VARCHAR,
"program_area" VARCHAR,
"monitoring" VARCHAR,
"treatments_unique_identifier" VARCHAR,
"globalid" VARCHAR,
"objectid" BIGINT,
"treatment_name" VARCHAR,
"project_name" VARCHAR,
"unit_number" VARCHAR,
"environmental_assessment_unit" VARCHAR,
"harvest_type" VARCHAR,
"method" VARCHAR,
"harvest_rx" VARCHAR,
"treatment_target" VARCHAR,
"status" VARCHAR,
"treatment_date" VARCHAR,
"treatment_date_fy" VARCHAR,
"sale_date" VARCHAR,
"sale_date_fy" VARCHAR,
"blm_organization_code" VARCHAR,
"plan_id" VARCHAR,
"workagent" VARCHAR,
"budget_code" VARCHAR,
"program_element" VARCHAR,
"gis_acres" DOUBLE,
"treatment_acres" DOUBLE,
"snags_ac" DOUBLE,
"reason" VARCHAR,
"reason_2" VARCHAR,
"initiative" VARCHAR,
"initiative_2" VARCHAR,
"contract_id" VARCHAR,
"contractor" VARCHAR,
"local_link" VARCHAR,
"nfpors_treatment_identifier" DOUBLE,
"nfpors_project_identifier" DOUBLE,
"rips_key" VARCHAR,
"nisims_identifier" VARCHAR,
"archaeological_clearance_date" VARCHAR,
"botany_clearance_date" VARCHAR,
"wildlife_clearance_date" VARCHAR,
"coordinate_source" VARCHAR,
"accuracy_ft" DOUBLE,
"shape_area" DOUBLE,
"shape_length" DOUBLE
);
Anyone who has the link will be able to view this.