A day in SQL HELL: or how I learned to like (or at least appreciate) SQL by ziggy
In short: the secret to who owns nyc will probably be found in a really complicated sql statement
Here's how this all started. I was working on my project to analyze heat/hot water complaints. I downloaded all the complaints for this heat season (there's over 200,00), geocoded them to obtain the bbls, and then imported them into postgres. I wanted to match complaints with their owners in order to find out whose responsible for not providing tenants' with essential services.
So I fired up PSQL and started typing out some queries.