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_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. |
|
| country_name | VARCHAR | 255 | √ |
|
|
Country name. |
||
| country_code2 | CHAR | 2 | √ |
|
|
ISO 2 Code for country. |
||
| country_code3 | CHAR | 3 | √ |
|
|
ISO 3 Code for country. |
||
| dataset_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| dataset_name | MEDIUMTEXT | 16777215 | √ | null |
|
|
Describes the dataset. |
|
| dataset_description | MEDIUMTEXT | 16777215 | √ | null |
|
|
The name of this dataset. |
|
| climate_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| climate_name | VARCHAR | 255 | √ |
|
|
Describes the climate. |
||
| climate_name_short | CHAR | 10 | √ | null |
|
|
Shortened version of the climate name which is used in some table headers. |
|
| climate_data_type | enum('categorical', 'numeric', 'text', 'date') | 11 | √ | text |
|
|
Defines the data type of the climate. This can be of numeric, text, date or categorical types. |
|
| unit_name | VARCHAR | 255 | √ |
|
|
The name of the unit. This should be the name of the unit in full. |
||
| recording_date | DATETIME | 19 | √ | null |
|
|
The date at which this data point was recorded. |
|
| climate_value | VARCHAR | 255 | √ | null |
|
|
Value for the specific climate attribute. These are monthly averages and not daily. Monthly data is required for the current Germinate climate viisualizations and interface. |