Login | Datasets | Logout
Jump to... Home PLOT search PLANT search COMMUNITY search Simple search Manage datasets Tutorial About FAQ ------- Site map VegBranch Data dictionary ERD

341010

VegBank Data Dictionary: Field Details

Search for a VegBank Field (enter a word, field name, etc.):    <<Hide search Match any word Match whole words only Search for VegBank Field >>

Search VegBank Tables Here

Table (DB Name)	plot
Table	Plot
Field	Parent
DB Field Name	PARENT_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	plot.PLOT_ID
List?	no
Notes	Recursive foreign key
Definition	Link to the parent plot when plot is nested within another plot.

 

Table (DB Name)	plot
Table	Plot
Field	Real Latitude
DB Field Name	realLatitude
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Latitude of the plot origin in degrees and decimals, datum =WGS84

 

Table (DB Name)	plot
Table	Plot
Field	Real Longitude
DB Field Name	realLongitude
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Longitude of the plot origin in degrees and decimals, datum = WGS84

 

Table (DB Name)	plot
Table	Plot
Field	Location Accuracy
DB Field Name	locationAccuracy
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Estimated accuracy of the location of the plot. Plot origin has a 95% or greater probability of being within this many meters of the reported location.

 

Table (DB Name)	plot
Table	Plot
Field	Confidentiality Status
DB Field Name	confidentialityStatus
Req'd?	required
Data Type	Integer
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list, default=0
Definition	Are the data to be considered confidential? 0=no, 1= 1km radius, 2=10km radius, 3=100km radius, 4=location embargo, 5=public embargo on all plot data, 6=full embargo on all plot data. This applies also to region.
closed List of Values: Value Description Sorting 0 Public 1 1 1 km radius (nearest 0.01 degree) 2 2 10 km radius (nearest 0.1 degree) 3 3 100 km radius (nearest degree) 4 4 Location embargo 5 5 Public embargo on data 6 6 Full embargo on data 7

 

Table (DB Name)	plot
Table	Plot
Field	Confidentiality Reason
DB Field Name	confidentialityReason
Req'd?	no
Data Type	varchar (200)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The reason for confidentiality. This field should not be open to public view. Reasons might include specific rare species, ownership, prepublication embargo, or many other reason

 

Table (DB Name)	plot
Table	Plot
Field	Latitude
DB Field Name	latitude
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Latitude of the plot origin in degrees and decimals, datum =WGS84, fuzzing applied

 

Table (DB Name)	plot
Table	Plot
Field	Longitude
DB Field Name	longitude
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Longitude of the plot origin in degrees and decimals, datum = WGS84, fuzzing applied

 

Table (DB Name)	plot
Table	Plot
Field	Author E
DB Field Name	authorE
Req'd?	no
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Original E-W coordinate as recorded by the author

 

Table (DB Name)	plot
Table	Plot
Field	Author N
DB Field Name	authorN
Req'd?	no
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Original N-S coordinate as recorded by the author