- A working Docker installation
- Mac users
- Windows users
- Linux users (you're fine)
NOTE ON WINDOWS INSTALLATIONS: Windows Professional edition ships with 'Hyper-V', which is required for modern Docker installations. Very likely, you have the Home edition of Windows and will have to use Docker Toolbox, which is an older, clunkier method of using Docker. It can work, but we won't be spending significant time assisting with installation issues. It is highly recommended that you come to the workshop with a working installation of Docker to ensure you get the most from in-person instruction. Barring that, you will be asked to pair with someone whose installation works.
-
A QGIS 3.X installation
-
A working internet connection
Introduction to 'containers', Docker's command line tools, and the features most relevant to running PostGIS with QGIS
- docker concepts
- what can docker do?
- how to put files on docker
- communication with processes inside docker
A brief introduction to relational databases, the SQL standard, the Postgresql dialect of SQL, and the 'GIS' of 'PostGIS'
Instruction on loading and viewing layers in QGIS; connecting QGIS to a running PostGIS instance
- Loading and viewing layers
- Coloring layers
- Viewing layer attributes
- Connecting to a database
Two complex, real world datasets will be provided (as well as some instruction and assistance in making them available through PostGIS/QGIS) which invite a host of interesting questions. Sample queries will be demonstrated, we will work through queries suggested in class, and participants will have an opportunity to ask their own questions with instructor assistance.
Extra utilities that we may/may not have time to cover
- Using the COPY command to do bulk inserts
- pgsql2shp
- Application programming (demonstration only)