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

201010

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)	graphic
Table	Graphic
Field	Graphic Description
DB Field Name	graphicDescription
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Description of the graphical file and associated metadata such as contributor, author, sensor, etc.

 

Table (DB Name)	graphic
Table	Graphic
Field	Graphic Type
DB Field Name	graphicType
Req'd?	no
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	no
Notes	may become a closed list
Definition	The type of the graphical file format (e.g. gif, tif, ,jpeg).

 

Table (DB Name)	graphic
Table	Graphic
Field	Graphic Date
DB Field Name	graphicDate
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Date that the graphic was produced.

 

Table (DB Name)	graphic
Table	Graphic
Field	Graphic Data
DB Field Name	graphicData
Req'd?	no
Data Type	oid
Misc Flag	n/a
References	n/a
List?	no
Notes	may be constrained by a maximum size
Definition	The graphical file data. - Max = 5 M total per plot

 

Table (DB Name)	graphic
Table	Graphic
Field	Accession Code
DB Field Name	accessionCode
Req'd?	no
Data Type	varchar (100)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Code that uniquely references this record, allowing reference to this record for this version of this database. Better than a primary key, which is automatically generated by a database and not globally unique. VegBank Accession codes are only generated by VegBank, and therefore data integrity can be guaranteed, unlike with a primary key (number).

 

Table (DB Name)	namedPlace
Table	Named Place
Field	ID
DB Field Name	NAMEDPLACE_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary for the namedPlace table
Definition	Database generated identifier assigned to each unique named place.

 

Table (DB Name)	namedPlace
Table	Named Place
Field	Place System
DB Field Name	placeSystem
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list
Definition	Name of the system of names. These can be treated as points as with place names, or as a coverage or set of polygons (e.g., geographic area names, HUC codes, Ecoregions, Quadrangles).
closed List of Values: Value Description Sorting region|state|province region or state or province 1 county county, canton, or parish 2 area|country|territory area, country, or territory 3 continent   4 quadrangle   5 HUC Code   6 TNC Conservation Region   7 EPA-Omernik Ecoregion   8 USFS-Bailey Ecoregion   9 Ecoregion A non-standard or generic ecoregion that is not specifically mentioned in this list. 10 Geographic Name User named places 11

 

Table (DB Name)	namedPlace
Table	Named Place
Field	Place Name
DB Field Name	placeName
Req'd?	required
Data Type	varchar (100)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The name of a place in or at which a plot is located. The system "Geographic Name" is an open list defined within this table. The other systems are generally closed lists constrained by aux_tables. These include at least USGSQuad, Continent, Country, State, County, HUC, and Ecoregion.

 

Table (DB Name)	namedPlace
Table	Named Place
Field	Place Description
DB Field Name	placeDescription
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This is the description of a named place.

 

Table (DB Name)	namedPlace
Table	Named Place
Field	Place Code
DB Field Name	placeCode
Req'd?	no
Data Type	varchar (15)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Optional code for location identification