Learning the FOSS4g Stack: Python for Geospatial

"Welcome to the course
Goals and objectives - what you'll learn
Loading our software and data
Installing QGIS 3.8
Installing Postgres 11
Our data
Installing Python 3
Loading data into Postgres
A gentle overview of Python
The general overview
The Python language: strings
Reading and writing from files
The Python Language: numbers and lists
Statements and control
A simple program to convert temperature
Default Python modules
External modules: the magic of PIP
Blow your mind with SQLITE
Blow your mind with SQLITE: spatial!
Numpy
Linear Algebra with Numpy (also how to create a function)
Postgres and Python
Access Microsoft Excel with Python
Explicitly Spatial modules with Python
Geocoding modules
Section 6: Python with Desktop QGIS (ArcGIS and QGIS)
A quick intro to Arcpy
Extending Arcpy to run outside of ArcGIS
A quick intro to Qpy
Extending our use of Qpy
Applying what we learned in Qpy
Lab Question 1: How many TRI sites are within .5 miles of the interstate
Lab Question 2: How many schools are within .5 miles of Lindau Chemical
Lab Question 3: What % of white / non white are vulnerable to a TRI spi
Creating forms with Python
Creating forms using formlayout
Integrating forms with ArcGIS
Integrating forms with Postgres and PostGIS
Bonus Lecture: How to keep learning"