Watershed Condition Classification: Priority Watersheds (Feature Layer)
Department of Agriculture
@usgov.usda_gov_watershed_condition_classification_priority_w_d34e9f99
Department of Agriculture
@usgov.usda_gov_watershed_condition_classification_priority_w_d34e9f99
CREATE TABLE table_1 (
"objectid" BIGINT,
"forest_name" VARCHAR,
"watershed_code" BIGINT,
"watershed_name" VARCHAR,
"watershed_condition_fs_area" VARCHAR,
"total_watershed_area_acres" DOUBLE,
"fs_ownership_percent" BIGINT,
"nonfs_area_percent" BIGINT,
"aquatic_biota_condition" VARCHAR,
"riparian_wetland_veg_condition" VARCHAR,
"water_quality_condition" VARCHAR,
"water_quantity_condition" VARCHAR,
"aquatic_habitat_condition" VARCHAR,
"roads_and_trails_condition" VARCHAR,
"soil_condition" VARCHAR,
"fire_effects_regime_condition" VARCHAR,
"forest_cover_condition" VARCHAR,
"forest_health_condition" VARCHAR,
"invasive_species_condition" VARCHAR,
"rangeland_vegetation_condition" VARCHAR,
"year_priority_identified" BIGINT,
"principal_reason" VARCHAR,
"selection_narrative" VARCHAR,
"known_partners" VARCHAR,
"approval_date" TIMESTAMP,
"estimated_completion_date" TIMESTAMP,
"essential_project_count" DOUBLE,
"essential_project_est_cost" DOUBLE,
"actual_completion_date" TIMESTAMP,
"restoration_action_plan" VARCHAR,
"restoration_action_plan_ind" VARCHAR,
"fs_unit_id" BIGINT,
"wrap_name" VARCHAR,
"wrap_approval_date" TIMESTAMP,
"accomplish_report_ind" VARCHAR,
"accomplish_report" VARCHAR,
"usfs_ownership_acres" DOUBLE,
"actual_completion_year" DOUBLE,
"crc_value" VARCHAR,
"shapearea" DOUBLE,
"shapelen" DOUBLE
);
Anyone who has the link will be able to view this.