PostgreSQL, PostGIS, pgRouting & QGIS

PostgreSQL, PostGIS, pgRouting & QGIS

PostgreSQL is a powerful, open source object-relational database system. PostGIS and pgRouting are spatial database extensions for PostgreSQL that add support for geographic objects and geospatial routing. QGIS is a free and open source geographic information system.

These free and open source applications were used to query and process data in SQL, including spatial functions, and provide finished data for final visualization in R and RStudio.


Contact the principal investigator: higeomancer at

Maps and other information products published under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

Data ("Patterns" and "Places") provided by SafeGraph through a 1-year non-commercial data license agreement.