Demographics Around 7-Eleven Stores in Manhattan

This is part of a series of posts I’m doing on Census Bureau Demographic Data for Developers based on my experience creating a database of Census Data as part of my summer internship at Patch.com. In a previous post, I used the example of creating 100 meter buffers around the 17 7-Eleven stores in Manhattan and aggregating census […]

Spatial Demographic Data – Weighting Demographics with PostGIS

This is part of a series of posts I’m doing on Census Bureau Demographic Data for Developers based on my experience creating a database of Census Data as part of my summer internship at Patch.com. In a previous post, I discussed the idea behind what I’m calling “spatial weighting”, which is basically taking a percentage of the demographics […]

Why I love my DBAs; or How Not to Install PostGIS on a Mac

This summer, I had the good fortune of having people tirelessly laboring to ensure the servers I used to host my databases were in working order and able to execute the tasks I needed them to run.  I didn’t realize how much that meant until I had to do it myself.  I’ve been putting together […]

Geometry vs Geography; or How We Measure Area and Distance in a Spatial Database

This is part of a series of posts I’m doing on Census Bureau Demographic Data for Developers based on my experience creating a database of Census Data as part of my summer internship at Patch.com.   Here’s the bottom line: if you’re measuring distance over relatively small distances and doing area comparisons instead of returning an actual area […]