About this Dataset

Alien Plant Threat Assessment

Data on alien (non-native) plant species surveys within the boundaries of disturbed sites within Yosemite National Park. Surveys were supplemented by quadrat-based subsampling of some campgrounds, camps, developments and corrals to obtain native/non-native species ratios. Surveys primarily targeted areas of human disturbance, such as campgrounds, corrals, developments, roads, trails and pastures, where alien plant species were most likely to be introduced and dispersed.
Organization: Department of the Interior
Last updated: 2025-09-14T21:07:50.842377
Tags: alien-plants, disturbance, ecological-framework-biological-integrity-invasive-species-invasive-exotic-plants, exotic-species, non-native-invasive-species, plant-surveys

Tables

ALL SURVEY COORDS

@usgov.doi_gov_alien_plant_threat_assessment.all_survey_coords

22.66 kB
211 rows
15 columns

CREATE TABLE all_survey_coords (
  "id" BIGINT,
  "sitenum" DOUBLE,
  "site_location" VARCHAR,
  "coord_loc" VARCHAR,
  "utmx_nad83" DOUBLE,
  "utmy_nad83" DOUBLE,
  "utmx_nad27" DOUBLE,
  "utmy_nad27" DOUBLE,
  "coord_precision_m" DOUBLE,
  "elev_ft" DOUBLE,
  "coord_descrip" VARCHAR,
  "utmsource" VARCHAR,
  "wp" DOUBLE,
  "site_utm" DOUBLE,
  "surveytype" VARCHAR
);

AREA SURVEYS

@usgov.doi_gov_alien_plant_threat_assessment.area_surveys

18.92 kB
1,147 rows
16 columns

CREATE TABLE area_surveys (
  "n_3_00" DOUBLE  -- 3.00,
  "ruac10" VARCHAR,
  "rumex_acetosella" VARCHAR,
  "unnamed_3" DOUBLE  -- Unnamed: 3,
  "n_5_00" DOUBLE  -- 5.00,
  "n_4_00" DOUBLE  -- 4.00,
  "n_1" BIGINT  -- 1,
  "n_0" BIGINT  -- 0,
  "n_0_1" BIGINT  -- 0.1,
  "n_0_2" BIGINT  -- 0.2,
  "n_0_3" BIGINT  -- 0.3,
  "n_0_4" BIGINT  -- 0.4,
  "n_0_5" BIGINT  -- 0.5,
  "n_0_6" BIGINT  -- 0.6,
  "n_0_7" BIGINT  -- 0.7,
  "n_0_8" BIGINT  -- 0.8
);

JFLORA

@usgov.doi_gov_alien_plant_threat_assessment.jflora

128.64 kB
1,436 rows
16 columns

CREATE TABLE jflora (
  "camo20" VARCHAR,
  "calyptridium" VARCHAR,
  "monospermum" VARCHAR,
  "greene" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "portulacaceae" VARCHAR,
  "added_the_species" VARCHAR,
  "n_1" BIGINT  -- 1,
  "n_0" BIGINT  -- 0,
  "calyptridium_monospermum_greene" VARCHAR,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "calyptridium_monospermum" VARCHAR,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "calyptridium_monospermum_1" VARCHAR
);

LINEAR SURVEYS

@usgov.doi_gov_alien_plant_threat_assessment.linear_surveys

8.87 kB
719 rows
5 columns

CREATE TABLE linear_surveys (
  "n_47_00" DOUBLE  -- 47.00,
  "n_47_01" DOUBLE  -- 47.01,
  "brte12" VARCHAR,
  "bromus_tectorum" VARCHAR,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

SHRUB LINEINT1998

@usgov.doi_gov_alien_plant_threat_assessment.shrub_lineint1998

5.53 kB
59 rows
5 columns

CREATE TABLE shrub_lineint1998 (
  "n_1" BIGINT  -- 1,
  "n_1_00" DOUBLE  -- 1.00,
  "rubus_discolor" VARCHAR,
  "n_1_00_1" DOUBLE  -- 1.00.1,
  "n_10_00" DOUBLE  -- 10.00
);

SITE

@usgov.doi_gov_alien_plant_threat_assessment.site

52.85 kB
109 rows
35 columns

CREATE TABLE site (
  "n_35_00" DOUBLE  -- 35.00,
  "lower_river_campground_yosemite_valley" VARCHAR  -- Lower River Campground, Yosemite Valley,
  "level_open_flat_flood_plain_in_yosemite_valley" VARCHAR  -- Level, Open, Flat Flood Plain In Yosemite Valley.,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "n_6_21_1999_0_00_00" TIMESTAMP  -- 6/21/1999–0:00:00,
  "hado7" VARCHAR,
  "mariposa" VARCHAR,
  "graham_roy" VARCHAR,
  "melinda_schroeder" VARCHAR,
  "n_273038_00" DOUBLE  -- 273038.00,
  "n_4180339_00" DOUBLE  -- 4180339.00,
  "n_273120_00" DOUBLE  -- 273120.00,
  "n_4180140_00" DOUBLE  -- 4180140.00,
  "n_11" BIGINT  -- 11,
  "n_7_30" DOUBLE  -- 7.30,
  "gps" VARCHAR,
  "revisit_point_for_area" VARCHAR,
  "n_4" DOUBLE  -- 4,
  "n_0_00" DOUBLE  -- 0.00,
  "n_0_00_1" DOUBLE  -- 0.00.1,
  "n_3860_00" DOUBLE  -- 3860.00,
  "n_3970_00" DOUBLE  -- 3970.00,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" DOUBLE  -- Unnamed: 25,
  "campground" VARCHAR,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "pipo_cade" VARCHAR,
  "pinus_ponderosa_calocedrus_decurrens_alliance" VARCHAR,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "area" VARCHAR,
  "n_1" BIGINT  -- 1,
  "n_1_1" BIGINT  -- 1.1,
  "note_revisit_of_site_1" VARCHAR  -- Note: Revisit Of Site 1
);

SUBSAMPLE COVER1998

@usgov.doi_gov_alien_plant_threat_assessment.subsample_cover1998

21.81 kB
2,228 rows
8 columns

CREATE TABLE subsample_cover1998 (
  "n_8_00" DOUBLE  -- 8.00,
  "n_4_00" DOUBLE  -- 4.00,
  "n_2_00" DOUBLE  -- 2.00,
  "vumy11" VARCHAR,
  "vulpia_myuros_var_hirsuta" VARCHAR  -- Vulpia Myuros Var. Hirsuta,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" DOUBLE  -- Unnamed: 6,
  "n_2_00_1" DOUBLE  -- 2.00.1
);

SUBSAMPLE COVER1999

@usgov.doi_gov_alien_plant_threat_assessment.subsample_cover1999

17.15 kB
3,488 rows
7 columns

CREATE TABLE subsample_cover1999 (
  "n_33" BIGINT  -- 33,
  "n_1" BIGINT  -- 1,
  "n_1_1" BIGINT  -- 1.1,
  "brdi10" VARCHAR,
  "bromus_diandrus" VARCHAR,
  "n_4067" BIGINT  -- 4067,
  "n_5" BIGINT  -- 5
);

TblAccessioned Plant Specimens

@usgov.doi_gov_alien_plant_threat_assessment.tblaccessioned_plant_specimens

38.03 kB
233 rows
3 columns

CREATE TABLE tblaccessioned_plant_specimens (
  "n_139076_yose_41773_holcus_lanatus_l_6_26_1998_0_00_00_7af7a11a" VARCHAR  -- 139076,"YOSE",41773,,,"Holcus Lanatus L.",6/26/1998–0:00:00,,"D. Graham Roy",4007,,3860.00,"feet","109026","Yosemite Herbarium",1.00,"Lower River Campground, Yosemite Valley, Yosemite National Park, California. 30m Above The Entrance,
  "n__growing_in_sandy_sediment_from_1997_flood" VARCHAR  -- Growing In Sandy Sediment From 1997 Flood,
  "n__scattered_pinus_ponderosa_273038_00_4180339_00_2731_0a2fc63e" VARCHAR  -- Scattered Pinus Ponderosa.",,,,273038.00,4180339.00,273120.00,4180140.00,11.00,"NAD27",7.30,,,,,,41773.00,,,,1.00,"6625",,
);

TRAIL USE LEVEL

@usgov.doi_gov_alien_plant_threat_assessment.trail_use_level

3.03 kB
21 rows
3 columns

CREATE TABLE trail_use_level (
  "n_1" BIGINT  -- 1,
  "n_54" BIGINT  -- 54,
  "low" VARCHAR
);

TRANSECT LENGTH 1998

@usgov.doi_gov_alien_plant_threat_assessment.transect_length_1998

3.41 kB
94 rows
3 columns

CREATE TABLE transect_length_1998 (
  "n_1" BIGINT  -- 1,
  "n_1_1" BIGINT  -- 1.1,
  "n_376" BIGINT  -- 376
);

TREE CANOPY1998

@usgov.doi_gov_alien_plant_threat_assessment.tree_canopy1998

5.35 kB
16 rows
6 columns

CREATE TABLE tree_canopy1998 (
  "n_1" BIGINT  -- 1,
  "n_1_00" DOUBLE  -- 1.00,
  "n_375_00" DOUBLE  -- 375.00,
  "n_346_00" DOUBLE  -- 346.00,
  "unnamed_4" DOUBLE  -- Unnamed: 4,
  "unnamed_5" DOUBLE  -- Unnamed: 5
);

TREE CANOPY1999

@usgov.doi_gov_alien_plant_threat_assessment.tree_canopy1999

7.04 kB
386 rows
5 columns

CREATE TABLE tree_canopy1999 (
  "n_1" BIGINT  -- 1,
  "n_34_00" DOUBLE  -- 34.00,
  "n_1_1" BIGINT  -- 1.1,
  "n_3_00" DOUBLE  -- 3.00,
  "n_7_00" DOUBLE  -- 7.00
);

USGSQuad

@usgov.doi_gov_alien_plant_threat_assessment.usgsquad

6.1 kB
63 rows
5 columns

CREATE TABLE usgsquad (
  "donnel_lake" VARCHAR,
  "dola7" VARCHAR,
  "n_490c" VARCHAR  -- 490C,
  "n_3811938" BIGINT  -- 3811938,
  "n_1979" BIGINT  -- 1979
);

VOLUNT

@usgov.doi_gov_alien_plant_threat_assessment.volunt

10.74 kB
254 rows
8 columns

CREATE TABLE volunt (
  "n_1" BIGINT  -- 1,
  "stoneman_meadow" VARCHAR,
  "n_6_29_1998_0_00_00" TIMESTAMP  -- 6/29/1998–0:00:00,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "cv" VARCHAR,
  "cirsium_vulgare" VARCHAR,
  "n_733_00" DOUBLE  -- 733.00,
  "stigall" VARCHAR
);