A PostGIS tutorial for PyCon Zimbabwe 2018, with Python and SQL as the main languages.
How you can help:
- read about the PyZim community: https://twitter.com/hamub/status/1038060003003916288
- donate to the PyZim community: https://www.patreon.com/pyzim
- donate to the Python Software Foundation: https://www.python.org/psf/
My goal was to create a PostGIS demo which would be accessible to students if they have not installed Python, PostgreSQL, or PostGIS, and even if I end up running the workshop without an internet connection:
- SQL queries and Python scripts for interacting with local PostGIS
- Basic server config for a read-only PostGIS in the cloud
- (ideally forkable) Python notebooks for PostGIS in the cloud
- Finding and downloading geodata (govt data, OpenStreetMap)
- Setting up PostGIS
- SQL Review and Added Features of PostGIS
- Importing CSVs and geodata
- Python scripts for import, export, querying
- Sample queries with map frontends: point-in-polygon, nearest point, buffers, US census statistics, etc
I set up on DigitalOcean so that ports and resizing would be more readily available.
The documents linked here are old. The current version of PostgreSQL is '10'
Installing PostgreSQL on Ubuntu: https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-14-04
Installing and configuring PostGIS on Ubuntu: https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-postgis-on-ubuntu-14-04
Making PostgreSQL open to the web: https://bosnadev.com/2015/12/15/allow-remote-connections-postgresql-database-server/
DigitalOcean firewall: https://www.digitalocean.com/community/questions/opening-ports-on-my-server
Open source, MIT license