PostGIS

Detroit Zoning Analysis

The list of work order tickets for Detroit provided by the researcher was converted into a GIS polygon data set containing 355,500 polygons using Python script in ArcGIS Pro. Polygons were mapped using the string of coordinates found in the “Polygon” field. For the ticket polygons / parcel zoning analysis, PostGIS software was used on...

Read more about Detroit Zoning Analysis

Introduction to PostGIS

PostGreSQL is a powerful open source object-relational database system. PostGIS provides spatial objects for PostgreSQL database with numerous spatial data processing capabilities. In this CGA's self-led tutorial the widely used geospatial relational database PostgreSQL/ PostGIS, will be introduced. Installation and configuration of PostGIS on an Amazon instance will be covered followed by spatial data loading, the use of Spatial SQL for spatial analysis, and export of results. The use of QGIS as a PostGIS query and...

Read more about Introduction to PostGIS

Measurement of partisan segregation for 180 million U.S. voters using advanced geospatial data science

Partisan segregation among people has important political and social implications. Historically, such measurements have been limited to county levels but this innovative work enabled Harvard researchers to analyze partisanship down to the level of individuals for the first time. In this work, CGA along with the Department of Government Professor Ryan Enos and graduate student Jacob Brown have leveraged advances in geospatial data science to measure partisan segregation down to the...

Read more about Measurement of partisan segregation for 180 million U.S. voters using advanced geospatial data science