VegBank Data Dictionary - Search Fields
| Search VegBank Tables Here |
«previous | 21 | 22 | page 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | next» |
Table | Field | DB Field Name | Req'd? | Data Type | Misc Flag | List? | Definition |
---|---|---|---|---|---|---|---|
Observation | Previous Observation | PREVIOUSOBS_ID | no | Integer | FK | no | Link to data from the previous observation of this plot. |
Observation | Plot | PLOT_ID | required | Integer | FK | no | Link to data and metadata that do not change between observations and which are stored in the plot table. |
Observation | Project | PROJECT_ID | no | Integer | FK | no | Link between an observation and the project within which the observation was made |
Observation | Author Observation Code | authorObsCode | no | varchar (30) | n/a | no | This is the code or name that the author uses to identify this plot observation event. Where a plot has only one observation, this will often equal plot.authorPlotCode. |
Observation | Observation Start Date | obsStartDate | no | Date | n/a | no | The date of the observation, or the first day if the observation spanned more than one day. |
Observation | Observation End Date | obsEndDate | no | Date | n/a | no | If the observation event spanned more than a single day, this is the last day on which observations were made. |
Observation | Date Accuracy | dateAccuracy | no | varchar (30) | n/a | closed | Estimated accuracy of the observation date. |
Observation | Date Entered into VegBank | dateEntered | no | Date | n/a | no | Date that the observation was added to VegBank |
Observation | Cover Method | COVERMETHOD_ID | no | Integer | FK | no | Link to the scale used to estimate taxon cover. The database stores estimated cover to the nearest percent, but the conversion details are recovered by reference to the specific scale employed. |
Observation | Cover Dispersion | coverDispersion | no | varchar (30) | n/a | closed | Were cover values for the total taxon list collected from one contiguous area or dispersed subplots? |