This is an all SQL etl script transforming a shape file of demolition permits taken from OpenDataPhilly. This data has been inserted into Postgis via the QGIS DB manager. This script normalizes the starting SQL table to Third Normal Form, preserving geospatial attributes.
The full report for this project can be found on my website