Properties of Attributes in entity 2 table: Snags
| Name |
Keyfield |
Nullable |
Attribute Type |
Domain |
Scale |
NumType |
Range |
Precision |
Units |
| DATACODE |
N |
N |
char(5) |
freetext |
nominal |
|
|
|
|
| FORMAT |
N |
N |
numeric(2,0) |
range
|
ratio |
integer |
1-2 |
1 |
number |
| STUDYID |
N |
N |
char(4) |
enum
|
nominal |
|
|
|
|
| STAND |
N |
N |
char(4) |
enum
|
nominal |
|
|
|
|
| YEAR |
N |
Y |
numeric(4,0) |
range
|
ratio |
integer |
1997-2005 |
1 |
year (yyyy) |
| MONTH |
N |
Y |
numeric(2,0) |
range
|
ratio |
integer |
8-11 |
1 |
month of year |
| DAY |
N |
Y |
numeric(2,0) |
range
|
ratio |
integer |
6-31 |
1 |
day of month |
| PLOT |
N |
N |
numeric(4,0) |
range
|
ratio |
integer |
1-84 |
1 |
number |
| SPECIES |
N |
Y |
char(6) |
taxa
|
nominal |
|
|
|
|
| TAG |
N |
N |
numeric(4,0) |
range
|
ratio |
integer |
1-8370 |
1 |
number |
| DBH |
N |
Y |
numeric(6,1) |
range
|
ratio |
real |
4.9-112.1 |
0.1 |
centimeters |
| POSITION |
N |
Y |
char(1) |
enum
|
nominal |
|
1-4 |
|
|
| STANDING |
N |
Y |
numeric(3,0) |
range
|
ratio |
integer |
0-100 |
1 |
percent |
| DECAY |
N |
Y |
char(1) |
enum
|
nominal |
|
0-5 |
|
|
| SCORCH |
N |
Y |
numeric(3,0) |
range
|
ratio |
integer |
0-100 |
1 |
meters |
| CRNCD1 |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| CRNCD2 |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| HEIGHT |
N |
Y |
numeric(5,2) |
range
|
ratio |
real |
0-55.3 |
|
meters |
| PREVHT |
N |
Y |
numeric(5,2) |
range
|
ratio |
real |
0.1-53.8 |
|
meters |
| COMMENTS |
N |
Y |
varchar(50) |
freetext |
nominal |
|
|
|
|
|
