View= localhost, mysqli, cram_riv_01, table_content, rows=76

wetlandtypecode	vyear	grouptypecode	ecramid	cramver	wetlandclass	wetlandsubclass	wetlandtypedisplay	wetlandtyperowid	userid	userid_updatedby	aaname	projectname	assessmentareaid	projectid	SiteTag	Region	visitdate	createdate	Waterbody	lastupdate	practitioners	practitionerother	aacategorydesc	aacomment	legacygid	centroidlong	centroidlat	aasize_ha	county	ecoregion	aageomcomment	ispublic	isnottest	indexscore	buffer_landscape_cont	hydrology	physical_structure	biotic_structure	bankfulwidth	length	upstreamlatitude	upstreamlongitude	downstreamlatitude	downstreamlongitude	datum	flowingwater_riverine	hydroregime_riverine	tidalstage_riverine	tidalstage_estuarine	mouthcondition	encompass_estuarine	wetlandorigindesc	managetypes	depressionaltypedesc	encompass_depressional	hydrostate_depressional	hydroregime_depressional	connectstreamfloodplain	definedoutlet	definedinlet	inletoutletsamelocation	distincttopobasin	vpcategorydesc	surfacewater	hydrodescription	peatsoils	encompass_slope	hydrostate_slope	hydroregime_slope	lat_lon	comment	Qacode	id_key	Active	Sourcefilename
rnc	2013		2856	6.1	riverine	non-confined	riverine non-confined	5	181		Alamitos Creek at Almaden Equestrian Center		204R00374	SCVURPPP 2013			2013-07-15 00:00:00	2013-09-25 00:00:00		2015-07-22 00:00:00	Paul Randall (lead practitioner)	Carol Boland	ambient	Site location: Bottom of AA ~ 10 m upstream of bridge. Top of AA - upstream end eucalyptus grove. Edges of AA defined by tree canopy overhang. Comments: Right bank is disturbed (i.e., loose soil, lack of veg) possibly resulting from arrundo eradication actions. Equestrian center highly disturbing right bank.		-121.82269	37.19358	0.44235	Santa Clara	bay/delta		1	1	64	69.58	66.67	50	69.44	7.5	150	37.19321	-121.82229	31.7942	-122.82315	nad83	1	perennial	not recorded																									1	1
rnc	2011	sa	2021	5.0.2	riverine	non-confined	riverine non-confined	5	135		SMC03510 (Rio Alomar/Tijuana River)	SMC_SD	SMC03510				2011-07-21 00:00:00	2011-07-21 00:00:00		2014-03-03 00:00:00	Damon Owen (lead practitioner)	DO/MM	other		3125	-116.78284	32.56433	0.87902	San Diego	south coast		1	1	77	92	83	75	56	8.5	150			32.56433	-116.78284	nad83	1	perennial																								centroid used as lat_lon		2	1
rc	2015	sp	4219	6.1	riverine	confined	riverine confined	4	467		VDM-North-Impacted	Vista del Mar Elementary School					2015-06-05 00:00:00	2015-08-20 00:00:00		2015-09-03 00:00:00	Rosanne Humphrey (lead practitioner)			Impacted drainage just downstream of a stormwater outfall from the Vista del Mar Elementary School. Ephemeral drainage surrounded by dense Rhus integrofolia. No riparian vegetation in channel.		-117.0283	32.57225	0.02924	San Diego	south coast		1	1	43	52.79	50	25	44.44	1.4	100	32.57218	-117.02917	32.5726	-117.03007	wgs84	0	ephemeral	not recorded																									3	1
rnc	2010	sa	1189	5.0.2	riverine	non-confined	riverine non-confined	5	130		Jamul Creek	PSA_SMC_2010	910S06570				2010-06-01 00:00:00	2010-06-01 00:00:00		2014-03-03 00:00:00	Kirk Vail (lead practitioner)	G.Sibbald, K.Vail	other		1779	-116.88487	32.63572	0.66628	San Diego	south coast		1	1	80	83	75	75	86	4.1	150	32.6362	-116.88456	32.6352	-116.88499	nad83	1	perennial																										4	1
rnc	2009	sa	953	5.0.2	riverine	non-confined	riverine non-confined	5	135		Sweetwater River, lower	SMC_SD	SMC01258				2009-05-27 00:00:00	2009-05-27 00:00:00		2014-03-03 00:00:00	Damon Owen (lead practitioner)	D. Owen/N.Woodward	other		1473	-117.05941	32.64961	0.4163	San Diego	south coast		1	1	76	79	75	75	75	5.3	150			32.64961	-117.05941	nad83	1	perennial																								centroid used as lat_lon		5	1
rc	2010	sa	1206	5.0.2	riverine	confined	riverine confined	4	130		Cottonwood Creek	PSA_SMC_2010	911S12262				2010-06-08 00:00:00	2010-06-08 00:00:00		2014-03-03 00:00:00	Kirk Vail (lead practitioner)	G.Sibbald K.Vail	other		1841	-116.68037	32.65897	0.53897	San Diego	south coast		1	1	84	92	75	88	81	3.3	150	32.65945	-116.68031	32.65819	-116.68062	nad83	1	perennial																										6	1
rnc	2012		3131	6.1	riverine	non-confined	riverine non-confined	5	695		Dulzura Creek			Performance Curves			2012-06-27 00:00:00	2013-11-13 00:00:00		2014-03-03 00:00:00	Lisa Fong (lead practitioner), Chris Solek (other practitioner)	Sarah Stiles	other	Restoration work performed as part of Rancho Jamul Wetland Mitigation Bank. Restoration site initially had water transfer issues; dried up immediately following construction and burned twice in following years. Began to flow again in 2010.		-116.84129	32.66232	0.21212	San Diego	south coast		1	1	77	85.38	83.33	62.5	77.78	5.8	115	32.66274	-116.84097	32.66184	-116.84161		1	perennial	not recorded																									7	1
rnc	2010	sa	1320	5.0.2	riverine	non-confined	riverine non-confined	5	149		SMC01962 (Sweetwater River)	SMC_SD_2010	SMC01962				2010-06-08 00:00:00	2010-06-08 00:00:00		2014-03-03 00:00:00	Bill Isham (lead practitioner)	DO?MM	other		1994	-117.03553	32.66193	1.05012	San Diego	south coast		1	1	33	25	50	25	33	7.67	150			32.66193	-117.03553	nad83	1	perennial																								centroid used as lat_lon		8	1
rc	2012	sa	2215	6	riverine	confined	riverine confined	4	135		SMC19228	SMC_SD_2012					2012-07-16 00:00:00	2012-07-16 00:00:00		2014-03-03 00:00:00	Damon Owen (lead practitioner)	DO/MM	other		3485	-116.98523	32.6638	1.05985	San Diego	south coast		1	1	49	58	42	38	58		150			32.6638	-116.98523	nad83	1	perennial																								centroid used as lat_lon		9	1
rnc	2012		3243	6.1	riverine	non-confined	riverine non-confined	5	695		Jamul Creek						2012-06-27 00:00:00	2013-12-18 00:00:00		2014-03-03 00:00:00	Lisa Fong (lead practitioner), Chris Solek (other practitioner)	Sarah Stiles	mitigation	Wildlands, Inc. Rancho Jamul Mitigation Bank channel was formerly incised and aggrading; restoration graded only adjacent floodplain site seemed like depressional marsh but with flow-through		-116.86598	32.66877	0.36315	San Diego	south coast		1	1	66	93.29	66.67	25	80.56	32	100	32.66909	-116.86639	32.66835	-116.86584		1	perennial	not recorded																									10	1
rc	2010	sa	1310	5.0.2	riverine	confined	riverine confined	4	149		SMC06458 (unamed SR trib.)	SMC_SD_2010	SMC06458				2010-06-06 00:00:00	2010-06-06 00:00:00		2014-03-03 00:00:00	Bill Isham (lead practitioner)	DO/MM	other		1984	-117.01556	32.66952	1.39313	San Diego	south coast		1	1	32	25	42	25	36	15	150			32.66952	-117.01556	nad83	1	perennial																								centroid used as lat_lon		11	1
rnc	2009	sa	936	5.0.2	riverine	non-confined	riverine non-confined	5	130		Cottonwood Creek	SMC_PSA_2009	911PS4086				2009-05-20 00:00:00	2009-05-20 00:00:00		2014-03-03 00:00:00	Kirk Vail (lead practitioner)	G.Sibbald K.Vail	other		1449	-116.57219	32.67253	0.66903	San Diego	south coast		1	1	83	92	75	63	100	5.5	150	32.67205	-116.57173	32.67292	-116.57286	nad83	1	perennial																										12	1
rnc	2012		3129	6.1	riverine	non-confined	riverine non-confined	5	695		Bonita Meadows Mitigation (DOT)			Performance Curves			2012-06-18 00:00:00	2013-11-13 00:00:00		2014-03-03 00:00:00	Lisa Fong (lead practitioner), Chris Solek (other practitioner)		mitigation			-116.9994	32.67315	0.48475	San Diego	south coast		1	1	69	79.75	58.33	50	86.11	33.2	100	32.67273	-116.999	32.67342	-116.99962		1	perennial	not recorded																									13	1
rnc	2010	sa	1313	5.0.2	riverine	non-confined	riverine non-confined	5	149		SMC06714 (unamed SR trib)	SMC_SD_2010	SMC06714				2010-06-06 00:00:00	2010-06-06 00:00:00		2014-03-03 00:00:00	Bill Isham (lead practitioner)	DO/MM	other		1987	-117.00435	32.67597	0.59196	San Diego	south coast		1	1	63	75	75	50	50	4.83	150			32.67597	-117.00435	nad83	1	perennial																								centroid used as lat_lon		14	1
rc	2011	sa	1700	5.0.2	riverine	confined	riverine confined	4	130		Wilson Creek	PSA_RCMP_2011	911TJWIL3				2011-06-02 00:00:00	2011-06-02 00:00:00		2014-03-03 00:00:00	Kirk Vail (lead practitioner)	Glenn Sibbald Kirk Vail	other		2518	-116.69441	32.69442	0.37795	San Diego	south coast		1	1	89	100	83	88	83	3.2	150	32.6943	-116.69497	32.69449	-116.69363	nad83	1	perennial																										15	1
rnc	2011	sa	1703	5.0.2	riverine	non-confined	riverine non-confined	5	130		Pine Valley Creek 1142	PSA_SMC_2011	911S01142				2011-06-02 00:00:00	2011-06-02 00:00:00		2014-03-03 00:00:00	Kirk Vail (lead practitioner)	Glenn Sibbald Kirk Vail	other		2521	-116.65345	32.73625	0.5597	San Diego	south coast		1	1	85	100	92	75	72	4.7	150	32.73669	-116.65388	32.73566	-116.65285	nad83	1	perennial																										16	1
rc	2009	sa	941	5.0.2	riverine	confined	riverine confined	4	130		Pine Valley Creek 2058	SMC_PSA_2009	911PS2058				2009-05-26 00:00:00	2009-05-26 00:00:00		2014-03-03 00:00:00	Kirk Vail (lead practitioner)	G.Sibbald K.Vail	other		1455	-116.64552	32.75927	0.27023	San Diego	south coast		1	1	85	100	92	75	72	6.5	150	32.75944	-116.64463	32.75922	-116.64623	nad83	0	intermittent																										17	1
rc	2012		2123	6	riverine	confined	riverine confined	4	135		TC-MLS						2012-05-16 00:00:00	2012-05-16 00:00:00		2014-03-03 00:00:00	Damon Owen (lead practitioner)	DO/MM	other		3290	-117.19812	32.7755	3.43255	San Diego	south coast		1	1	29	25	33	25	31	9.3	150			32.77554	-117.20031	nad83	1	perennial																										18	1
rnc	2012		3253	6.1	riverine	non-confined	riverine non-confined	5	695		Tecolote Canyon Mitigation						2012-11-13 00:00:00	2013-12-19 00:00:00		2014-03-03 00:00:00	Lisa Fong (lead practitioner), Chris Solek (other practitioner)		mitigation			-117.18562	32.77755	0.34027	San Diego	south coast		1	1	71	93.29	50	50	91.67	11	130	32.77794	-117.18539	32.77684	-117.18596		1	perennial	not recorded																									19	1
rnc	2012	sa	2228	6	riverine	non-confined	riverine non-confined	5	135		SMC06918	SMC_SD_2012					2012-07-16 00:00:00	2012-07-16 00:00:00		2014-03-03 00:00:00	Damon Owen (lead practitioner)	DO/MM	other		3498	-117.1835	32.78111	1.09796	San Diego	south coast		1	1	76	92	67	75	69		150			32.78111	-117.1835	nad83	1	perennial																								centroid used as lat_lon		20	1
rc	2010	sa	1312	5.0.2	riverine	confined	riverine confined	4	149		SMC09286 (Murphy Cyn. Crk.)	SMC_SD_2010	SMC09286				2010-09-09 00:00:00	2010-09-09 00:00:00		2014-03-03 00:00:00	Bill Isham (lead practitioner)	DO/MM	other	moderate homeless community	1986	-117.11391	32.78217	0.60412	San Diego	south coast		1	1	50	38	67	38	56	4.83	150			32.78217	-117.11391	nad83	1	perennial																								centroid used as lat_lon		21	1
rnc	2009	sa	922	5.0.2	riverine	non-confined	riverine non-confined	5	130		Pine Valley Creek 0538	SMC_PSA_2009	911PS0538				2009-05-21 00:00:00	2009-05-21 00:00:00		2014-03-03 00:00:00	Kirk Vail (lead practitioner)	G.Sibbald K.Vail	other		1434	-116.62874	32.78378	0.4052	San Diego	south coast		1	1	86	100	92	75	78	5.5	150	32.78363	-116.62784	32.7839	-116.6293	nad83	1	perennial																										22	1
rc	2011	sa	1740	5.0.2	riverine	confined	riverine confined	4	130		Kitchen Creek KCKCRX	PSA_RCMP_2011	911KCKCRX				2011-06-14 00:00:00	2011-06-14 00:00:00		2014-03-03 00:00:00	Kirk Vail (lead practitioner)	Glenn Sibbald Kirk Vail	other		2582	-116.45134	32.78804	0.2236	San Diego	south coast		1	1	93	100	100	88	83	1.2	150	32.7874	-116.4514	32.78748	-116.45097	nad83	1	perennial																										23	1
rnc	2014	sp	4000	6.1	riverine	non-confined	riverine non-confined	5	131		911KCKCRX	RCMP_SWAMP_2014	Kitchen Creek	RCMP 2014			2014-06-17 00:00:00	2015-01-22 00:00:00		2015-01-22 00:00:00	Sean Mundell (lead practitioner), Billy Jakl (other practitioner)		ambient			-116.45129	32.78821	0.16631	San Diego	south coast		1	1	85	93.29	83.33	87.5	75	1.66	150	32.78873	-116.4515	32.7876	-116.4511	nad83	1	perennial	not recorded																									24	1
rnc	2009	sa	929	5.0.2	riverine	non-confined	riverine non-confined	5	130		Pine Valley Creek	SMC_PSA_2009	911PS3354				2009-05-21 00:00:00	2009-05-21 00:00:00		2014-03-03 00:00:00	Kirk Vail (lead practitioner)	G.Sibbald K.Vail	other		1441	-116.61799	32.79003	0.34964	San Diego	south coast		1	1	92	100	100	75	94	3.2	150			32.7895	-116.618	nad83	1	perennial																										25	1