About this Dataset

Aspen Characteristics - Aspen Delineation Project [ds361]

The database represents point locations and associated stand assessment data collected within aspen stands in the Lake Tahoe Basin Management Unit (Placer and Eldorado Counties); Alturas Field Office-BLM (Modoc County); California Tahoe Conservancy (Placer and Eldorado Counties), the Stanislaus National Forest (Tuolumne County); Humboldt-Toiyabe National Forest(Alpine County); and Tahoe National Forest (Nevada and Sierra Counties); and the California Department of Fish and Game (Modoc County). This is a multi-agency contributed dataset gathered by the agencies listed above during the summers of 2001-2005. Assessment data and GIS delineations were collected using a standardized protocol developed by members of the Aspen Delineation Project, a cooperative project of the US Forest Service, the Bureau of Land Management and the California Department of Fish and Game. Surveying was completed by foot surveys of watersheds surveyed. This is the current completed data set for aspen distribution of land administered by these agencies. Data captures location of aspen stands and vegetative characteristics of the aspen stand, and if browsing of the aspen was present or absent. Also associated with this database is a polygon layer (ADP_POLY) containing aspen stands delineated in conjunction with the aspen assessment information. Data Compilation: The Aspen Delineation Project (ADP) is a collaborative effort of the U.S. Forest Service's Pacific Southwest Region, the California Department of Fish and Games Resource Assessment Program, and the California Office of Bureau of Land Management. Principal Investigator for ADP is David Burton; visit: www.aspensite.org for more information regarding the ADP. The Department of Fish and Games, Resource Assessment Program compiled this information from the collaborating agencies and other researchers, and formatted the data into a common database for the purpose of facilitating access to data related to the conservation of Quaking Aspen in California. This information portal falls within the ADP goals to help agencies and land managers identify, map, treat, and monitor aspen habitats. This dataset is a portion of a master database compiled during a year long effort in 2005 to pull together current GIS layers and maps depicting Aspen communities in California.
Organization: State of California
Last updated: 2024-03-30T00:29:10.673173
Tags: aspen-delineation-project, authcdfw, california-department-of-fish-and-wildlife, california-natural-resources-agency, caopendata, cdfw, cn-quaking-aspen, distribution, ds036120071217wm, inventory, management, montane-forests, planning, plant, sn-populus-tremuloides, stand, tree, vegetation-characteristics

Tables

Table 1

@usgov.ca_gov_aspen_characteristics_aspen_delineation_project_e73fd218.table_1

151.59 KB
958 rows
84 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "unq_pt_id" VARCHAR,
  "stand_id" VARCHAR,
  "date" TIMESTAMP,
  "surveyor" VARCHAR,
  "source_nm" VARCHAR,
  "loss_potn" VARCHAR,
  "stand_dim" VARCHAR,
  "stand_ac" VARCHAR,
  "os_all" VARCHAR,
  "os_ratio" VARCHAR,
  "os_decdnt" VARCHAR,
  "os_conspp" VARCHAR,
  "os_nosurv" VARCHAR,
  "ms_all" VARCHAR,
  "ms_ratio" VARCHAR,
  "ms_shade" VARCHAR,
  "ms_nosurv" VARCHAR,
  "us_regen" VARCHAR,
  "us_suppr" VARCHAR,
  "us_supprby" VARCHAR,
  "us_rgnpoor" VARCHAR,
  "us_rgncon" VARCHAR,
  "brw_intsty" VARCHAR,
  "brw_hedge" VARCHAR,
  "brw_cattle" VARCHAR,
  "brw_deer" VARCHAR,
  "brw_sheep" VARCHAR,
  "brw_elk" VARCHAR,
  "brw_unk" VARCHAR,
  "us_nosurv" VARCHAR,
  "riparian" VARCHAR,
  "spring" VARCHAR,
  "meadow" VARCHAR,
  "pond" VARCHAR,
  "outcrop" VARCHAR,
  "moraine" VARCHAR,
  "lavaflow" VARCHAR,
  "talus" VARCHAR,
  "insect" VARCHAR,
  "disease" VARCHAR,
  "blowdown" VARCHAR,
  "sagebrush" VARCHAR,
  "cornlily" VARCHAR,
  "conifer_lg" VARCHAR,
  "fire" VARCHAR,
  "gully" VARCHAR,
  "beaver" VARCHAR,
  "dist_road" BIGINT,
  "treatment" VARCHAR,
  "trtmt_desc" VARCHAR,
  "smi_nosurv" VARCHAR,
  "arch_carv" VARCHAR,
  "arch_other" VARCHAR,
  "arch_desc" VARCHAR,
  "trl_camp" VARCHAR,
  "structure" VARCHAR,
  "struc_desc" VARCHAR,
  "elevation" BIGINT,
  "slope" BIGINT,
  "quad" VARCHAR,
  "utm_east" BIGINT,
  "utm_north" BIGINT,
  "utm_zone" VARCHAR,
  "gps_loc" VARCHAR,
  "gps_dist" VARCHAR,
  "gps_bear" VARCHAR,
  "gpsp_unit" VARCHAR,
  "gpsp_form" VARCHAR,
  "gpsp_db" VARCHAR,
  "gpsp_gis" VARCHAR,
  "unq_asp_id" VARCHAR,
  "key_code" VARCHAR,
  "source" VARCHAR,
  "key_num" BIGINT,
  "id1" BIGINT,
  "id2" BIGINT,
  "id3" BIGINT,
  "id4" BIGINT,
  "stand" VARCHAR,
  "sourcethm" VARCHAR,
  "comment" VARCHAR
);