Table 5 Schema for WEATHER table.
Name | Type | Description |
|---|---|---|
Source | Varchar | Specify data source |
Date | Date | Day of the statistics |
Gid | Array | Unique geographical ID, for more details see gadm.org |
Country | Varchar | English name for the country |
Countrycode | Varchar | ISO 3166-1 alpha-3 country codes |
Adm_area_1 | Varchar | Level-1 administrative country subdivision |
Adm_area_2 | Varchar | Level-2 administrative country subdivision |
Adm_area_3 | Varchar | Level-3 administrative country subdivision |
Samplesize | Int | Number of grid points |
Precipitation_max_avg | Float | Average of the daily maximum precipitation |
Precipitation_max_std | Float | Standard deviation of the daily maximum precipitation |
Precipitation_mean_avg | Float | Average of the daily mean precipitation |
Precipitation_mean_std | Float | Standard deviation of the daily mean precipitation |
Humidity_max_avg | Float | Average of the daily maximum specific humidity |
Humidity_max_std | Float | Standard deviation of the daily maximum specific humidity |
Humidity_mean_avg | Float | Average of the daily mean specific humidity |
Humidity_mean_std | Float | Standard deviation of the daily mean specific humidity |
Humidity_min_avg | Float | Average of the daily minimum specific humidity |
Humidity_min_std | Float | Standard deviation of the daily minimum specific humidity |
Sunshine_max_avg | Float | Average of the daily maximum short wave radiation |
Sunshine_max_std | Float | Standard deviation of the daily maximum short wave radiation |
Sunshine_mean_avg | Float | Average of the daily minimum short wave radiation |
Sunshine_mean_std | Float | Standard deviation of the daily minimum short wave radiation |
Temperature_max_avg | Float | Average of the daily maximum temperature |
Temperature_max_std | Float | Standard deviation of the daily maximum temperature |
Temperature_mean_avg | Float | Average of the daily mean temperature |
Temperature_mean_std | Float | Standard deviation of the daily mean temperature |
Temperature_min_avg | Float | Average of the daily minimum temperature |
Temperature_min_std | Float | Standard deviation of the daily minimum temperature |
Windgust_max_avg | Float | Average of the daily maximum wind gust |
Windgust_max_std | Float | Standard deviation of the daily maximum wind gust |
Windgust_mean_avg | Float | Average of the daily mean wind gust |
Windgust_mean_std | Float | Standard deviation of the daily mean wind gust |
Windgust_min_avg | Float | Average of the daily minimum wind gust |
Windgust_min_std | Float | Standard deviation of the daily minimum wind gust |
Windspeed_max_avg | Float | Average of the daily maximum wind speed |
Windspeed_max_std | Float | Standard deviation of the daily maximum wind speed |
Windspeed_mean_avg | Float | Average of the daily mean wind speed |
Windspeed_mean_std | Float | Standard deviation of the daily mean wind speed |
Windspeed_min_avg | Float | Average of the daily minimum wind speed |
Windspeed_min_std | Float | Standard deviation of the daily minimum wind speed |
Cloudaltitude_max_valid | Float | Percentage of points with a valid value of cloudaltitude_max |
Cloudaltitude_max_avg | Float | Average of the daily maximum cloud base altitude |
Cloudaltitude_max_std | Float | Standard deviation of the daily maximum cloud base altitude |
Cloudaltitude_min_valid | Float | Percentage of points with a valid value of cloudaltitude_min |
Cloudaltitude_min_avg | Float | Average of the daily minimum cloud base altitude |
Cloudaltitude_min_std | Float | Standard deviation of the daily minimum cloud base altitude |
Cloudaltitude_mean_valid | Float | Percentage of points with a valid value of cloudaltitude_mean |
Cloudaltitude_mean_avg | Float | Average of the daily mean cloud base altitude |
Cloudaltitude_mean_std | Float | Standard deviation of the daily mean cloud base altitude |
Cloudfrac_max_avg | Float | Average of the daily maximum cloud area fraction |
Cloudfrac_max_std | Float | Standard deviation of the daily maximum cloud area fraction |
Cloudfrac_min_avg | Float | Average of the daily minimum cloud area fraction |
Cloudfrac_min_std | Float | Standard deviation of the daily minimum cloud area fraction |
Cloudfrac_mean_avg | Float | Average of the daily mean cloud area fraction |
Cloudfrac_mean_std | Float | Standard deviation of the daily mean cloud area fraction |
