This ETL transformation was performed as an exercise in demonstrating proficiency using SQL in the PostgreSQL relational database with the PostGIS spatial extensions. I selected a spatial dataset of building demolition permits to load into the database and normalize to Third Normal Form. Once in place, this data can be combined with a secondary dataset on children with elevated blood lead levels to investigate correlations between demolition activity and elevated lead levels.
Through Spring and Summer 2018, a network of companies buying and selling access to the location of every customer of the four major carriers has been partially unveiled. Despite clear federal regulations governing receiving consent before providing access to customer data, some companies had rather loose consent policies.
This analysis will use spatial statistical analysis techniques in R to investigate possible correlated data, and the extent to which observed clustering is statistically significant.
This choropleth map was created as the final project for my Fundamentals of GIS class, using ArcGIS Desktop 10.5.1.