BLM OR Biological Treatments Polygon Hub
Department of the Interior
@usgov.doi_gov_blm_or_biological_treatments_polygon_hub
Department of the Interior
@usgov.doi_gov_blm_or_biological_treatments_polygon_hub
CREATE TABLE table_1 (
"unit_number" VARCHAR,
"weed_target_2" VARCHAR,
"weed_target_3" VARCHAR,
"treatment_date_accuracy" VARCHAR,
"vmap_treatment_identifier" DOUBLE,
"national_flag_code" VARCHAR,
"program_area" VARCHAR,
"treatments_unique_identifier" VARCHAR,
"globalid" VARCHAR,
"objectid" BIGINT,
"treatment_name" VARCHAR,
"project_name" VARCHAR,
"biological_type" VARCHAR,
"biological_agent" VARCHAR,
"biological_agent_number" DOUBLE,
"biological_agent_source" VARCHAR,
"wind_speed_mph" DOUBLE,
"wind_direction" VARCHAR,
"air_temperature_f" DOUBLE,
"treatment_target" VARCHAR,
"weed_target_1" VARCHAR,
"phenology" VARCHAR,
"cover" DOUBLE,
"status" VARCHAR,
"treatment_date" VARCHAR,
"treatment_date_fy" BIGINT,
"blm_organization_code" VARCHAR,
"plan_id" VARCHAR,
"workagent" VARCHAR,
"budget_code" VARCHAR,
"program_element" VARCHAR,
"treatment_acres" DOUBLE,
"gis_acres" 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,
"monitoring" 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.