Kamil Nešetřil

Environmental data management and analytics

User Tools

Site Tools


Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
en:concept [2022-10-27] – external edit 127.0.0.1en:concept [2022-11-24] (current) – external edit 127.0.0.1
Line 49: Line 49:
   * lookup tables etc.   * lookup tables etc.
 Tables containing data noted with asterisk (*) are organized to the snowflake schema. \\  Tables containing data noted with asterisk (*) are organized to the snowflake schema. \\ 
-We are using the [[https://www.postgresql.org/|PostgreSQL]] database management system. Interpretations and non-point data (arcs, polygons, etc.) are stored in PostgreSQL due to the spatial extension [[http://www.postgis.net|PostGIS]]. That spatial data and georeferenced images are served via [[https://docs.qgis.org/2.14/en/docs/user_manual/working_with_ogc/ogc_server_support.html|QGIS Server]] as the mapping service (e.g. WMS or WMTS), that can be loaded as a basemap to our web application or to any GIS. +We are using the [[https://www.postgresql.org/|PostgreSQL]] database management system. Interpretations and non-point data (arcs, polygons, etc.) are stored in PostgreSQL due to the spatial extension [[http://www.postgis.net|PostGIS]]. That spatial data and georeferenced images are served via [[qgis>https://docs.qgis.org/2.14/en/docs/user_manual/working_with_ogc/ogc_server_support.html|QGIS Server]] as the mapping service (e.g. WMS or WMTS), that can be loaded as a basemap to our web application or to any GIS. 
Last modified: 2022-11-24