SWAMP_Bioassessment_AnalyteCrosswalk_v2.5_042412.xls

	A	B	C	D	E	F	G	H
1	DRAFT - The information in this tab is considered DRAFT and is under review. Please check back for updates.
2	Color-coded AnalyteNames indicate which tab data should be populated and the corresponding SWAMP Data Entry Form where the analyte can be found. For example, BankfullHeight data should be entered into the HabitatCollectionResults tab and it can be found in the Transect form.
3
4	For data entered into HabitatResults, analytes with a MethodName of FieldObservations will have values entered into the field HabitatResult.VariableResult. Collection device will be 'None' except for PictureCode where it will be 'Not Recorded' unless one records the device.
5
6	For data entered into HabitatResults, analytes with a MethodName of ObservedFieldMeasure or FieldMeasure will have values entered into the field HabitatResult.Result. Collection device will be 'None' for analytes that are estimated or a device is not used (e.g., Embeddedness, Cascade/Falls), 'Not Recorded' for analytes where a specific device name is not recorded or not needed (e.g., BankfullHeight, StationWaterDepth, WettedWidth), or the specific device in CollectionDeviceLookUp will be used (e.g., Densiometer for CanopyCover).
7	Field Results	Habitat Results	Transect	Slope	Discharge	Other
8	MatrixName	MethodName	AnalyteName	FractionName	UnitName	SWAMP_WS	EMAP	CSBP

9	samplewater	FieldMeasure	Alkalinity as CaCO3	Total	mg/L	x
10	habitat	FieldObservations	Angling Pressure	None	none		MAN_ANGL
11	habitat	FieldObservations	Back Water	None	none		BACKWATR
12	habitat	FieldMeasure	Bank Angle	None	degrees		ANGLE
13	habitat	FieldObservations	Bank Stability	None	none	x
14	habitat	FieldMeasure	Bankfull Height	None	m	x	BANKHT
15	habitat	FieldMeasure	Bankfull Width	None	m	x	BANKWID
16	habitat	FieldMeasure	Bankfull Width Reach	None	m		BANKFULL
17	habitat	FieldObservations	Bar Present	None	none		BARYES
18	habitat	FieldMeasure	Bar Width	None	m		BARWID
19	habitat	FieldMeasure	Bar Width	None	m		BARWID
20	habitat	FieldMeasure	Bearing	First Supplemental	degrees	x	BEAR2
21	habitat	FieldMeasure	Bearing	Main	degrees	x	BEARING
22	habitat	FieldMeasure	Bearing	Second Supplemental	degrees		BEAR3
23	habitat	FieldObservations	Beaver Flow Modifications	None	none		BvFlwMod
24	habitat	FieldObservations	Beaver Signs	None	none		BEAVER
25	habitat	FieldObservations	Bridges, Culverts	None	none		RES_BRID
26	habitat	FieldMeasure	Canopy Cover	None	none	x	DENSIOM
27	habitat	ObservedFieldMeasure	Cascade/Falls	None	%	x
28	habitat	FieldObservations	Channel Constraining Feature	None	none		FEATURES
29	habitat	FieldObservations	Channel Constraint	None	none		CONSTRNT
30	habitat	ObservedFieldMeasure	Channel Margin in Contact	None	%		PERCENT
31	habitat	FieldObservations	Channel Pattern	None	none		PATTERN
32	habitat	FieldObservations	Channel Unit	None	none		CHANUNCD
33	habitat	FieldObservations	Channel Unit	None	none		CHANUNIT
34	habitat	FieldObservations	Channelization	None	none		MAN_CHAN
35	habitat	FieldObservations	Chemical Treatment	None	none		Chemical Treatment
36	samplewater	FieldMeasure	Chlorophyll,Total	None	µg/L
37	habitat	FieldObservations	Commercial	None	none		IND_COML
38	habitat	FieldObservations	Construction	None	none		RES_CON
39	habitat	FieldObservations	CPOM	None	none	x
40	habitat	FieldObservations	Cropland	None	none		AGR_CROP
41	habitat	FieldObservations	Dams	None	none		MAN_DAMS
42	samplewater	FieldMeasure	Discharge	None	cfs		Discharge Direct Measurement
43	samplewater	FieldMeasure	Discharge	None	m3/s
44	habitat	FieldMeasure	Distance from Bank	None	m	x	DISTANCE
45	habitat	Velocity Area	Distance from Bank	None	cm	x	DISTANCE
46	habitat	Neutral Bouyant Object	Distance, Float	None	m	x	x
47	habitat	FieldObservations	Dominant Benthic Substrate	None	none		x
48	habitat	FieldObservations	Dominant Land Use	None	none	x	DLandUse
49	habitat	FieldObservations	Dredging	None	none		MAN_DRED
50	habitat	ObservedFieldMeasure	Dry	None	%	x
51	samplewater	FieldMeasure	ElectricalConductivity	None	µS/cm
52	habitat	FieldMeasure	Elevation Difference	First Supplemental	cm	x	x
53	habitat	FieldMeasure	Elevation Difference	Main	cm	x	x
54	habitat	FieldMeasure	Elevation Difference	Second Supplemental	cm		x
55	habitat	ObservedFieldMeasure	Embeddedness	None	%	x	EMBED
56	habitat	ObservedFieldMeasure	Embeddedness	None	%	x
57	habitat	FieldObservations	Evidence of Fire	None	none	x
58	habitat	FieldObservations	Evidence of Fire Intensity	None	none		IND_FIRE
59	habitat	FieldObservations	Evidence of Recent Rainfall	None	none	x
60	habitat	Timed Filling	Filling Time	None	seconds		x
61	habitat	FieldObservations	Fish Cover Artificial Structures	None	none	x	STRUCT
62	habitat	FieldObservations	Fish Cover Boulders	None	none	x	BOULDR
63	habitat	FieldObservations	Fish Cover Filamentous Algae	None	none	x	ALGAE
64	habitat	FieldObservations	Fish Cover Live Trees/Roots	None	none	x	ROOTS
65	habitat	FieldObservations	Fish Cover Macrophytes	None	none	x	MACPHY
66	habitat	FieldObservations	Fish Cover Overhang.Veg	None	none	x	OVRHNG
67	habitat	FieldObservations	Fish Cover Undercut Banks	None	none	x	UNDCUT
68	habitat	FieldObservations	Fish Cover Woody Debris <0.3 m	None	none	x	BRUSH
69	habitat	FieldObservations	Fish Cover Woody Debris >0.3 m	None	none	x	WOODY
70	habitat	FieldObservations	Fish Stocking	None	none		MAN_FISH
71	habitat	FieldObservations	Forest Dominant Age Class	None	none		ForAgeCl
72	habitat	ObservedFieldMeasure	Glide	None	%	x
73	habitat	FieldObservations	Glide/Pool Bank Stability	None	none		BANK_ST
74	habitat	FieldObservations	Glide/Pool Channel Alteration	None	none	x	CHAN_ALT
75	habitat	FieldObservations	Glide/Pool Channel Flow Status	None	none		CHAN_FLS
76	habitat	FieldObservations	Glide/Pool Channel Sinuosity	None	none		CHAN_SIN
77	habitat	FieldObservations	Glide/Pool Epifaunal Substrate	None	none	x	EPIF_SUB
78	habitat	FieldObservations	Glide/Pool Pool Substrate	None	none		POOL_SUB
79	habitat	FieldObservations	Glide/Pool Pool Variability	None	none		POOL_VAR
80	habitat	FieldObservations	Glide/Pool Riparian Zone Width	None	none		RIPA_V
81	habitat	FieldObservations	Glide/Pool Sediment Deposition	None	none	x	SEDI_DEP
82	habitat	FieldObservations	Glide/Pool Vegetative Protection	None	none		VEG_PRO
83	habitat	FieldObservations	HabitatType	None	none		x
84	habitat	FieldObservations	Height of Legacy Tree	None	m
85	habitat	FieldObservations	Hiking Trails	None	none		REC_TRLS
86	habitat	FieldMeasure	Incised Height	None	m		INCISED
87	habitat	FieldMeasure	Increment	None	m
88	habitat	FieldObservations	Industrial Plants	None	none		IND_IND
89	habitat	FieldObservations	Irrigation Equipment	None	none		AGR_IRRG
90	habitat	FieldMeasure	Length Downstream	None	m
91	habitat	FieldMeasure	Length Reach	Total	m	x	REACHLEN
92	habitat	FieldMeasure	Length, Segment	First Supplemental	m	x
93	habitat	FieldMeasure	Length, Segment	Main	m	x
94	habitat	FieldMeasure	Length, Segment	Second Supplemental	m
95	habitat	FieldMeasure	Length Upstream	None	m
96	habitat	FieldObservations	Liming	None	none		MAN_LIME
97	habitat	FieldObservations	Livestock Use	None	none		AGR_STCK
98	habitat	FieldObservations	Logging	None	none		IND_LOG
99	habitat	ObservedFieldMeasure	LWD >0.8 DLE, Length >15m	Above Bankfull Channel	none		XDLL
100	habitat	ObservedFieldMeasure	LWD >0.8 DLE, Length >15m	In Bankfull Channel	none		XDLL