SP001

Properties of Attributes in entity 2 table: Horizon Level Data (description, physical and chemical Data)

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
PROFILE	Y	N	numeric(3,0)	range	ratio	natural	1.-400.	1.	number
SERIES	N	Y	varchar(30)	freetext	nominal
HORIZON	Y	N	char(4)	freetext	nominal
DEPTH_T	N	Y	char(3)	freetext	nominal
DEPTH_B	N	Y	char(3)	freetext	nominal
BOUNDARY	N	Y	char(2)	enum	nominal
DRYCOLOR	N	Y	char(8)	freetext	nominal
MOISTCOL1	N	Y	char(8)	freetext	nominal
MOISTCOL2	N	Y	char(8)	freetext	nominal
MOISTCOL3	N	Y	char(8)	freetext	nominal
TEXTURE	N	Y	char(7)	enum	nominal
STRUCTURE	N	Y	char(18)	enum	nominal
CONSISTENC	N	Y	varchar(30)	enum	nominal
CONSDRY	N	Y	varchar(25)	enum	nominal
CONSMOIST	N	Y	varchar(25)	enum	nominal
CONSWET	N	Y	varchar(25)	enum	nominal
OTHER	N	Y	varchar(65)	freetext	nominal
ROOTS	N	Y	varchar(65)	freetext	nominal
DENSITY	N	Y	numeric(5,3)	range	ratio	real	0.500-1.500	0.001	grams per cubic centimeter
SAND	N	Y	numeric(4,1)	range	ratio	real	10.0-90.0	0.1	percent
SILT	N	Y	numeric(4,1)	range	ratio	real	10.0-80.0	0.1	percent
CLAY	N	Y	numeric(4,1)	range	ratio	real	1.0-50.0	0.1	percent
TEXT_CLASS	N	Y	char(7)	enum	nominal
PERCOLATIO	N	Y	numeric(5,1)	range	ratio	real	0.1-250.0	0.1	inches per hour
MT_THIRD	N	Y	numeric(4,1)	range	ratio	real	20.0-70.0	0.1	percent
MT_ONE	N	Y	numeric(4,1)	range	ratio	real	15.0-60.0	0.1	percent
MT_FIVE	N	Y	numeric(4,1)	range	ratio	real	2.0-55.0	0.1	percent
MT_FIFTEEN	N	Y	numeric(4,1)	range	ratio	real	10.0-50.0	0.1	percent
PH	N	Y	numeric(3,1)	range	ratio	real	4.0-7.0	0.1	pH units
CEC	N	Y	numeric(5,2)	range	ratio	real	10.00-70.00	0.01	milliequivalents per 100 grams
OM	N	Y	numeric(6,2)	range	ratio	real	0.10-22.00	0.01	percent
TOT_N	N	Y	numeric(6,4)	range	ratio	real	0.0010-1.0500	0.0000	percent
P	N	Y	numeric(5,2)	range	ratio	real	0.00-85.00	0.01	parts per million
K	N	Y	numeric(5,1)	range	ratio	real	0.0-3.0	0.1	milliequivalents per 100 grams
CA	N	Y	numeric(5,1)	range	ratio	real	0.0-25.0	0.1	milliequivalents per 100 grams
MG	N	Y	numeric(5,1)	range	ratio	real	0.0-20.0	0.1	milliequivalents per 100 grams
NA	N	Y	numeric(5,1)	range	ratio	real	0.0-1.0	0.1	milliequivalents per 100 grams
BASE_SAT	N	Y	numeric(5,1)	range	ratio	real	1.0-105.0	0.1	percent