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 […]

Spatial Demographic Data – Use-cases

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 my previous post, I introduced some basic spatial concepts useful in working with US Census Bureau data. In this post, I’d […]

A Quick Spatial Primer for Using Census Data

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.   The world of geospatial information systems seems magical to the uninitiated and even after you are initiated, it still has […]