Python in a Jupyter Notebook was used to automate the implementation of a PostgreSQL database with PostGIS extension. LODES Census Origin-Destination data for California was collected HERE. This data was joined to spatial data for Census Block Groups and then Sub-regional Areas. The psycopg2 library was used to implement a PostgreSQL from the Jupyter Notebook. Geometry was added in the form of flowlines and aggregated data for Sub-regional Areas, then exported as shapefiles for ArcGIS Pro visualizations.
Check out the PROJECT SLIDES for more information on methods and findings.