The RHEAS databaseΒΆ
The back-end of RHEAS is a PostGIS database (a spatially-enabled PostgreSQL database) that stores the necessary data to run RHEAS including model parameters, meteorological data (both forecasts and nowcasts), and remote sensing as well as in-situ observations.
The VIC and DSSAT model parameters are contained under the vic and dssat schemas. Depending on the requested spatial resolution for the models, appropriate model parameters and corresponding files are chosen. Tables in the vic schema include soils which contains the soil parameters, and input which contains the necessary files to run the VIC model. Each record in the input table should contain the following columns:
- resolution: model spatial resolution
- snowbandfile: VIC elevation band file
- vegparam: VIC vegetation parameter file
- veglib: VIC vegetation library file
- soilfile: VIC soil parameter file
- rootzones: number of root zones
- basefile: DSSAT input file template
The requirements for running DSSAT also include the type of cultivar(s), planting start dates, a global crop mask and soil properties which have been ingested in the database from various sources. Soil properties and cultivar information are stored as vector tables (soils and cultivar respectively), while planting start dates and the crop mask are stored as raster maps with the type of crop as an additional column in the crops and cropland tables respectively.
Multiple remote sensing datasets can be ingested into the database and are available either to be used as input (i.e. precipitation, temperature, wind speed) or assimilated (i.e. soil moisture, water storage, LAI, evapotranspiration). The following table summarizes the available datasets, their characteristics and the database schema/table they will be installed in.
| Variable | Dataset | Time Coverage | Temporal Resolution | Spatial Resolution | Spatial Coverage | Table | Mode |
|---|---|---|---|---|---|---|---|
| Precipitation | CHIRPS | 1981- | Daily | 5km | Africa | precip.chirps | IN |
| Precipitation | TRMM | 1998- | Daily | 0.25 o | Global | precip.trmm | IN |
| Precipitation | RFE2 | 2001- | Daily | 0.10 o | Africa | precip.rfe2 | IN |
| Precipitation | CMORPH | 1998- | Daily | 0.25 o | Global | precip.cmorph | IN |
| Precipitation | GPM | 2014- | Daily | 0.10 o | Global | precip.gpm | IN |
| Meteorology | NCEP | 1981- | Daily | 1.875 o | Global | *.ncep | IN |
| Meteorology | PRISM | 1981- | Daily | 4km | CONUS | *.prism | IN |
| Soil moisture | AMSR-E | 2002-2011 | Daily | 0.25 o | Global | soilm.amsre | AS |
| Soil moisture | SMOS | 2009- | Daily | ~40km | Global | soilm.smos | AS |
| Soil moisture | SMAP | 2015- | Daily | 3/9km | Global | soilm.smap | AS |
| Evapotranspiration | MOD16 | 2000- | 8 days | 1km | Global | evap.modis | AS |
| Water storage | GRACE | 2002- | Monthly | 1.0 o | Global | tws.grace | AS |
| Snow cover | MOD10 | 2001- | Daily | 1km | Global | snow.mod10 | AS |
| Snow cover | MODSCAG | 2001- | Daily | 1km | Global | snow.modscag | AS |
| Leaf Area Index | MCD15 | 2002- | 8 days | 1km | Global | lai.modis | AS |
| Meteorology | IRI | 2000- | Monthly | 2.5 o | Global | *.iri | FC |
| Meteorology | NMME | 2000- | Daily | 0.5 o | Global | *.nmme | FC |
There are three modes for the datasets: IN corresponds to datasets being used as inputs to the model, AS refers to datasets being assimilated, and FC are datasets that are used to provide the meteorological (i.e. precipitation, temperature, and in some cases wind speed) forecasts.