Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| location_id | INT | 10 | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
||
| location_name | VARCHAR | 255 |
|
|
The site name where the location is. |
|||
| location_name_short | VARCHAR | 22 | √ | null |
|
|
Shortened site name which can be used in tables within Germinate. |
|
| location_region | VARCHAR | 255 | √ | null |
|
|
The region where the location is if this exists. |
|
| location_state | VARCHAR | 255 | √ | null |
|
|
The state where the location is if this exists. |
|
| location_type | VARCHAR | 255 | √ | null |
|
|
The name of the location type. |
|
| location_latitude | DECIMAL | 64,10 | √ | null |
|
|
Latitude of the location. |
|
| location_longitude | DECIMAL | 64,10 | √ | null |
|
|
Longitude of the location. |
|
| location_elevation | DECIMAL | 64,10 | √ | null |
|
|
The elevation of the site in metres. |
|
| location_coordinate_uncertainty | INT | 10 | √ | null |
|
|
Uncertainty associated with the coordinates in metres. Leave the value empty if the uncertainty is unknown. |
|
| country_name | VARCHAR | 255 | √ |
|
|
Country name. |
||
| country_code2 | CHAR | 2 | √ |
|
|
ISO 2 Code for country. |
||
| country_code3 | CHAR | 3 | √ |
|
|
ISO 3 Code for country. |