Alien Plant Threat Assessment

n_35_00 35.00	lower_river_campground_yosemite_valley Lower River Campground, Yosemite Valley	level_open_flat_flood_plain_in_yosemite_valley Level, Open, Flat Flood Plain In Yosemite Valley.	unnamed_4 Unnamed: 4	unnamed_5 Unnamed: 5	n_6_21_1999_0_00_00 6/21/1999–0:00:00	hado7 HADO7	mariposa Mariposa	graham_roy Graham Roy	melinda_schroeder Melinda Schroeder	n_273038_00 273038.00	n_4180339_00 4180339.00	n_273120_00 273120.00	n_4180140_00 4180140.00	n_11 11	n_7_30 7.30	gps GPS	revisit_point_for_area Revisit Point For Area	n_4 4	n_0_00 0.00	n_0_00_1 0.00.1	n_3860_00 3860.00	n_3970_00 3970.00	unnamed_25 Unnamed: 25	campground Campground	unnamed_27 Unnamed: 27	pipo_cade PIPO/CADE	pinus_ponderosa_calocedrus_decurrens_alliance Pinus Ponderosa-Calocedrus Decurrens Alliance	unnamed_30 Unnamed: 30	area Area	n_1 1	n_1_1 1.1	note_revisit_of_site_1 Note: Revisit Of Site 1
1	Lower River Campground, Yosemite Valley	Level, open, flat flood plain in Yosemite Valley.	q	y	Wed Jun 24 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	HADO7	Mariposa	Graham Roy	Patrick Whitmarsh	273038	4180339	273120	4180140	11	7.3	GPS	Point for area	4			3860	3970		Campground		PIPO/CADE	Pinus ponderosa-Calocedrus decurrens Alliance		area	1	1	Area surveyed/sampled: 360x100m; Flooded in 1997. Campground closed after flood.
2	Southside Drive, Yosemite Valley	Southside Drive, between El Capitan Bridge and Sentinel Bridge.	s	y	Wed Jul 08 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	ELCA7	Mariposa	Justin Adams, Graham Roy	Brad Jelinek, Aaron King	268399	4178111	268482	4177912	11	12	GPS	Survey start	3		3	3958	3958		Road	Ponderosa Pine, Mixed Conifer	PIPO/CADE	Pinus ponderosa-Calocedrus decurrens Alliance		linear	1		Area surveyed: 6kmx5m each side
3	Northside Drive, Yosemite Valley	El Capitan Meadow. The length of the pullout on Northside Drive for observing El Capitan beginning at the bridge over the Merced River.	s	y	Wed Jul 08 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	ELCA7	Mariposa	Graham Roy, Brent Johnson	Justin Adams, Brad Jelenik	268051	4178468	268134	4178269	11	11	GPS	Survey start	12		3	3958	3966		Road	Meadow		Montane meadow		linear	1		Area surveyed: 1km x5m each side
4	Inspiration Point Trail from Discovery View	Aproximately 1.9 km of trail from Wawona Tunnel to Inspiration Point.	s	y	Fri Jul 10 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	ELCA7	Mariposa	Justin Adams	Brad Jelinek	264042	4177612	264125	4177413	11	6.5	GPS	Survey start	188	50	19	4381	4381		Trail	Douglas Fir, Mixed Conifer	PIPO/CADE/PSME	Pinus ponderosa-Calocedrus decurrens Alliance		linear	1		Area surveyed: 2km x3m each side
5	Bridalveil Falls Trail, Yosemite Valley	Bridalveil Falls Loop from parking lot on Wawona Road to intersection with South Side Drive. Included the Vista Point Trail.	s	y	Fri Jul 10 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	ELCA7	Mariposa	Graham Roy	Aaron King	266551	4177727	266633	4177528	11		USGS_QUAD	Survey start		280		4035	4029	100	Trail	Mixed Conifer		Pinus ponderosa-Calocedrus decurrens Alliance		linear	1		Area surveyed: 1km x5m each side
6	Old Wawona Rd to Inspiration Point Trail	From the Bridalveil Falls parking lot to the intersection with the Inspiration Point trail. The total distance is 3.2 km.	s	y	Fri Jul 10 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	ELCA7	Mariposa	Graham Roy	Aaron King	265850	4177527	265933	4177328	11		GPS	Survey start	14	22	3	4035	4962		Trail	Douglas Fir, Mixed Conifer		Pseudotsuga menziesii Forest Alliance		linear	1		Area surveyed: 2km x 5m each side
7	Mariposa Grove Trail	Wawona Trail from the Mariposa Grove to Wawona Hotel	s	y	Mon Jul 13 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	WAWO7	Mariposa	Aaron King	Justin Adams	269290	4153873	269372	4153673	11	12	GPS	Survey start	190			5256	5718		Trail			A. concolor-P. lambertiana Alliance and P. ponderosa-C. decurrens All.		linear	1		Area surveyed: 11km x5m each side
8	Wawona Concession Corral	Flat meadow and staging area bordered by a road to the north and S Fork Merced River to the south. Horse trails impact a meadow on the east of the stables, so it was included.	q	y	Mon Jul 13 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	WAWO7	Mariposa	Brad Jelenik	Graham Roy	265438	4158037	265520	4157837	11	13	GPS	Point for area	16			4000	3935		Corral	Ponderosa Pine Forest	PIPO/CADE/QUKE	Pinus ponderosa-Calocedrus decurrens-Quercus kelloggii Assoc	Getting Dry	area	1	1	Area surveyed/sampled: 50x50m
9	Wawona Campground	Wawona Campground off of Wawona Rd. Divided into three sections, and most samples taken in the upper and lower sections. Survey was conducted in all three sections.	q	y	Wed Jul 15 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	WAWO7	Mariposa	Aaron King	Justin Adams	262773	4159433	262855	4159233	11	8.6	GPS	Point for area	196			3927	3890		Campground	Ponderosa Pine, Mixed Conifer	PIPO/CADE/CHFO	Pinus ponderosa-Calocedrus decurrens/Chamaebatia foliolosa		area	1	1	Area surveyed/sampled: 400x100m
10	Wawona Campground (Control)	50+m north of the Wawona Campground in an open canopy ponderosa pine forest with incense-cedar and scattered black oak. Chamaebatia foliosa dense and patchy in shrub layer.	q	n	Thu Jul 16 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	WAWO7	Mariposa	Graham Roy	Brad Jelinek	262765	4159527	262847	4159327	11	18	GPS	Point for area	19	308	21	3899	3899	50	Camp control	Ponderosa Pine, Mixed Conifer	PIPO/CADE/CHFO	Pinus ponderosa-Calocedrus decurrens/Chamaebatia foliolosa		area		1	Area surveyed/sampled: 50x50m


CREATE TABLE site (
  "n_35_00" DOUBLE,
  "lower_river_campground_yosemite_valley" VARCHAR,
  "level_open_flat_flood_plain_in_yosemite_valley" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "n_6_21_1999_0_00_00" TIMESTAMP,
  "hado7" VARCHAR,
  "mariposa" VARCHAR,
  "graham_roy" VARCHAR,
  "melinda_schroeder" VARCHAR,
  "n_273038_00" DOUBLE,
  "n_4180339_00" DOUBLE,
  "n_273120_00" DOUBLE,
  "n_4180140_00" DOUBLE,
  "n_11" BIGINT,
  "n_7_30" DOUBLE,
  "gps" VARCHAR,
  "revisit_point_for_area" VARCHAR,
  "n_4" DOUBLE,
  "n_0_00" DOUBLE,
  "n_0_00_1" DOUBLE,
  "n_3860_00" DOUBLE,
  "n_3970_00" DOUBLE,
  "unnamed_24" VARCHAR,
  "unnamed_25" DOUBLE,
  "campground" VARCHAR,
  "unnamed_27" VARCHAR,
  "pipo_cade" VARCHAR,
  "pinus_ponderosa_calocedrus_decurrens_alliance" VARCHAR,
  "unnamed_30" VARCHAR,
  "area" VARCHAR,
  "n_1" BIGINT,
  "n_1_1" BIGINT,
  "note_revisit_of_site_1" VARCHAR
);