TP108

Properties of Attributes in entity 19 table: Planted Trees (U-G, U-G2)

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DATACODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	ratio	integer	19.-19.	1.	number
YEAR	Y	N	numeric(4,0)	range	interval	integer	1998.-2009.	1.	year (yyyy)
DISTRICT	N	N	char(4)	place	nominal
BLOCK	N	N	char(1)	enum	nominal
TRT	N	N	char(1)	enum	nominal
PLOT	N	N	char(6)	place	nominal
QTR	N	Y	numeric(1,0)	range	ratio	integer	1.-4.	1.	number
TAGNO	N	Y	numeric(5,0)	range	ratio	integer	1.-99999.	1.	number
OLDTAG	N	Y	numeric(4,0)	range	ratio	integer	1.-9999.	1.	number
TREESPP	N	Y	char(6)	taxa	nominal
HEIGHT	N	Y	numeric(4,0)	range	ratio	integer	2.-2500.	1.	centimeters
HT2002	N	Y	numeric(4,0)	range	ratio	integer	11.-360.	1.	centimeters
LEADGRWTH1	N	Y	numeric(5,1)	range	ratio	real	0.0-99.0	0.1	centimeters
LEADGRWTH2	N	Y	numeric(5,1)	range	ratio	real	0.1-200.0		centimeters
DBH	N	Y	numeric(5,1)	range	ratio	real	1.0-25.0	0.1	centimeters
VIGOR	N	N	char(1)	enum	nominal
STATUS	N	N	char(1)	enum	nominal
PTYPE	N	N	char(1)	enum	nominal
COMMENTS	N	Y	varchar(254)	freetext	nominal
PERSONNEL	N	N	varchar(30)	freetext	nominal
SAMPLEDATE	N	N	datetime	range	datetime		Aug 22 1998-Sep 16 2009		date as date type
TREEID	Y	N	varchar(13)	freetext	nominal