-
Notifications
You must be signed in to change notification settings - Fork 0
MVW PostgreSQL tables
Grace-Amondi edited this page Apr 28, 2021
·
4 revisions
The following tables are necessary to make the MapViewer work and to display geographical data in it.
Spatial tables containing geographical background
| Resource | Type | Description |
|---|---|---|
| coastlines | spatial table | Coastal lines at high resolution, displayed by the MapViewer at scales > 1:5000000 |
| coasts | spatial table | Coastal lines at low resolution, displayed by the MapViewer at scales < 1:5000000 |
| countries | spatial table | Country polygons |
| fao_rwdb_rivers | spatial table | River line strings from FAO RWDB2 River-Surface Water Body Network |
| populated_places | spatial table | Point location of towns from Natural Earth Populated Places |
| surface_water | spatial table | Water body polygons from FAO RWDB2 Surface Water Bodies |
Grids and gridded data
| Resource | Type | Description |
|---|---|---|
| grid_083dd | spatial table | Grid of 1/12 dd cells. Contains also several columns with thematic data, such as the themes of the MapViewer's "FAO Land Management" layer. |
| grid_1dd | spatial table | Grid of 1 dd cells. There are two spatial columns: CELL with quadrilateral-shaped geometries (i.e. proper cells) and CORR_CELL with quadrilateral cells cut by coastlines (so geometries contain only the continental part of the cell and not the sea). |
| grid_1dd_gpcc | table | Contains precipitation data from the Global Precipitation Climatology Centre (GPCC) of the Deutscher Wetterdienst. Data columns have a _MM suffix to refer to a month (e.g. RAIN_07 contains precipitation data of July). YEAR is the column specifying the year of data. G1D_ID is the reference to the ID column of GRID_1DD. |
| grid_1dd_spi | table | Contains data of the Standardized Precipitation Index (SPI) from the Global Precipitation Climatology Centre (GPCC) of the Deutscher Wetterdienst. Seven time scales are available: 1, 3, 6, 9, 12, 24, and 48 months. Data columns have a double _MMTS suffix to refer to month and time scale (e.g. SPI_1124 contains SPI-12 data of November). YEAR is the column specifying the year of data. G1D_ID is the reference to the ID column of GRID_1DD. |
| grid_1dd_gpcc_year | view | Join between GRID_1DD and GRID_1DD_GPCC on GRID_1DD_GPCC.G1D_ID=GRID_1DD.ID |
| grid_1dd_spi_year | view | Join between GRID_1DD and GRID_1DD_SPI on GRID_1DD_SPI.G1D_ID=GRID_1DD.ID |