AN006

Properties of Attributes in entity 1 table: Site locations & characteristics

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	interval	natural	1.-1.		number
SITEID	Y	N	char(8)	place	ordinal
STATE	N	N	char(2)	enum	nominal
LULC_CATEGORY	N	N	char(3)	enum	nominal
STUDYYEAR	N	N	numeric(4,0)	range	datetime		2003.-2006.		number
STREAMNAME	N	N	char(20)	enum	nominal
BIOME	N	N	varchar(35)	enum	nominal
COORDINATE_N15_X	N	Y	numeric(7,4)	range	ratio	real	13.1810-44.6176		decimal degrees latitude or longitude
COORDINATE_N15_Y	N	Y	numeric(9,4)	range	ratio	real	-123.3303-110.8441		decimal degrees latitude or longitude
COORDINATE_1_X	N	Y	numeric(7,4)	range	ratio	real	13.1930-44.6095		decimal degrees latitude or longitude
COORDINATE_1_Y	N	Y	numeric(9,4)	range	ratio	real	-123.3305-110.8440		decimal degrees latitude or longitude
COORDINATE_6_X	N	Y	numeric(7,4)	range	ratio	real	13.2550-44.6176		decimal degrees latitude or longitude
COORDINATE_6_Y	N	Y	numeric(9,4)	range	ratio	real	-123.3311-110.8435		decimal degrees latitude or longitude
DRAINAGEAREA	N	N	numeric(9,1)	range	ratio	real	3.3-1584719.0		hectares
PCT_NATVEG	N	N	numeric(4,1)	range	ratio	real	0.0-100.0		percent
PCT_AGR	N	N	numeric(4,1)	range	ratio	real	0.0-100.0		percent
PCT_URB	N	N	numeric(4,1)	range	ratio	real	0.0-100.0		percent
PCT_CHANSLOPE	N	Y	numeric(5,2)	range	ratio	real	0.00-100.00		percent
NOTES	N	Y	varchar(185)	freetext	nominal