TV019

Properties of Attributes in entity 2 table: Cone Counts

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(10)	enum	nominal
ENTITY	N	N	numeric(1,0)	range	ratio	integer	2.-2.	1.	number
LOC_NAME	N	Y	varchar(40)	freetext	nominal
LOC_CODE	N	Y	char(6)	freetext	nominal
SPECIES	N	Y	char(6)	taxa	nominal
PLOT	Y	N	char(7)	place	nominal
TREENR	Y	N	numeric(3,0)	range	ratio	integer	1.-89.	1.	number
TAG	N	N	numeric(5,0)	range	ratio	integer	1.-9892.	1.	number
YEAR	Y	N	numeric(4,0)	range	ratio	integer	1959.-2022.	1.	year (yyyy)
CONECOUNT	N	Y	numeric(4,0)	range	ratio	integer	0.-5000.	1.	number
STATUS	N	N	char(1)	enum	nominal
COMMENT	N	Y	varchar(100)	freetext	nominal
TREE_VIGOR	N	N	char(1)	enum	nominal
CROWN_PCT	N	Y	numeric(3,0)	range	ratio	natural	0.-100.		percent
CROWN_RATIO	N	Y	numeric(3,0)	range	interval	whole	0.-100.		percent
WEATHER_VISIBILITY	N	Y	char(254)	freetext	nominal
SAMPLEDATE	N	Y	datetime	range	datetime		Aug 30 2019-Sep 24 2022		date as date type