AS011

Properties of Attributes in entity 4 table: Sampling History

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units	Missing Value Code
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	ratio	natural	4.-4.		number
YEAR	N	N	numeric(4,0)	range	interval	natural	2013.-2019.		year (yyyy)
DATE	Y	N	datetime	range	datetime		Aug 6 2013-Aug 15 2019		date as date type
STREAM	Y	N	char(10)	place	ordinal
SITE	Y	N	varchar(30)	enum	nominal
SITE_CODE	Y	N	char(10)	place	ordinal
VISIT_NO	N	N	char(1)	enum	ordinal
SAMPLING_TYPE	N	N	char(15)	enum	nominal
TOTAL_SAMPLING_EFFORT	N	N	char(4)	enum	nominal
SAMPLING_TEAM	N	N	char(15)	enum	nominal
REACH_LENGTH	N	Y	numeric(3,0)	range	ratio	natural	0.-1000.		meters
AVERAGE_WETTED_WIDTH	N	Y	numeric(4,2)	range	ratio	real	0.00-1000.00		meters
AREA_SAMPLED	N	Y	numeric(5,1)	range	ratio	real	0.0-1000.0		square meters
FIELD_LATITUDE_TOP_NET	N	Y	numeric(9,6)	range	ratio	real	44.2101-44.2670		decimal degrees latitude or longitude
FIELD_LONGITUDE_TOP_NET	N	Y	numeric(11,6)	range	ratio	real	-122.3064--122.1139		decimal degrees latitude or longitude
FIELD_LATITUDE_BOTTOM_NET	N	Y	numeric(9,6)	range	ratio	real	44.2105-44.2638		decimal degrees latitude or longitude
FIELD_LONGITUDE_BOTTOM_NET	N	Y	numeric(11,6)	range	ratio	real	-122.3064--122.1138		decimal degrees latitude or longitude
SHOCK_LEAD	N	Y	varchar(100)	freetext	nominal
NET_TEAM	N	Y	varchar(254)	freetext	nominal
PROCESSING	N	Y	varchar(100)	freetext	nominal
COMMENTS	N	Y	varchar(254)	freetext	nominal