TP108

Properties of Attributes in entity 13 table: Overstory Trees (O-A, O-E, and O-G)

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	13.-13.	1.	number
YEAR	Y	N	numeric(4,0)	range	interval	integer	1998.-2016.	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
TREESPP	N	Y	char(6)	taxa	nominal
DBH	N	Y	numeric(5,1)	range	ratio	real	1.6-171.4	0.1	centimeters
STATUS	N	N	char(1)	enum	nominal
TOPHT	N	Y	numeric(5,2)	range	ratio	real	1.30-77.30	0.01	meters
CANOPY	N	N	char(1)	enum	nominal
TREEVIGOR	N	N	char(1)	enum	nominal
CROWN1	N	N	char(1)	enum	nominal
CROWN2	N	N	char(1)	enum	nominal
CROWN3	N	N	char(1)	enum	nominal
BOLE1	N	N	char(1)	enum	nominal
BOLE2	N	N	char(1)	enum	nominal
BOLE3	N	N	char(1)	enum	nominal
DISTURB1	N	N	char(1)	enum	nominal
DISTURB2	N	N	char(1)	enum	nominal
OLDTAG	N	Y	numeric(4,0)	range	ratio	integer	1.-9999.	1.	number
PLANTED	N	N	char(1)	enum	nominal
PTYPE	N	N	char(1)	enum	nominal
TCOMMENT	N	Y	varchar(254)	freetext	nominal
PERSONNEL	N	N	varchar(30)	freetext	nominal
SAMPLEDATE	N	N	datetime	range	datetime		Jun 4 1998-Aug 31 2016		date as date type
TREEID	Y	N	varchar(13)	freetext	nominal