mapmeld/postgis-zimbabwe

PostGIS tutorial with hosted read-only database and notebooks # postgis-zimbabwe A PostGIS tutorial for PyCon Zimbabwe 2018, with Python and SQL as the main languages. How you can help: - read about the PyZim community: twitter.com - donate to the PyZim community: patreon.com - donate to the Python Software Foundation: python.org ## Participatory 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 ## Topics - 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 ## Setup for public PostGIS and Jupyter Notebooks 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: digitalocean.com Installing and configuring PostGIS on Ubuntu: digitalocean.com Making PostgreSQL open to the web: bosnadev.com DigitalOcean firewall: digitalocean.com ## License Open source, MIT license