PostGIS & Postgres
Creating VIEWS in PostGIS
Overview: This short article gives users a brief guide on creating VIEWS in PostGIS, in addition to referencing additional learning. What is a VIEW? In short, A PostgreSQL/PostGIS view is a virtual table created from a SQL query. It doesn't store ...
Database Best Practices
This short article is designed to help you better understand how to get the most out of your data in both XMAP and QGIS by applying simple but effective 'best practice' principles to your PostGIS database. The golden rules: Schema names, table names ...
Connecting to a Cloud Database through Microsoft Access
Overview This article is for connecting to a cloud database in order to edit non-spatial data through Microsoft Access. This guide is for those using Windows. Method Required Installations Install Microsoft Access (if not installed already) Install ...