- direct QGIS connection to both Oracle Spatial and PostgreSQL/PostGIS
- editing data in the database, including concurrent work by multiple users
- spatial indexes and query optimisation
- data migration between Oracle, PostGIS, Microsoft SQL Server and file formats
Utility network and asset data are usually stored in enterprise databases. QGIS can work with them directly, without exports or copies. We will help you set up the connection so that work is fast and secure.
Oracle Spatial
- Oracle client configuration and connections in QGIS
- correct spatial layer metadata (USER_SDO_GEOM_METADATA) and spatial indexes
- working with views and limiting the data loaded
PostGIS
- database and schema design for GIS data
- roles and access rights
- database functions and triggers for data validation and automatic completion
Data migration
We have long experience migrating attribute and spatial data. We transfer data between databases and from other systems, check its topology and completeness, and prepare it for work in QGIS.