ST_BUFFER_METERS: The PostGIS function you didn’t know you needed

After spending the better part of the day trying to get my projections right so I could draw a 100 meter buffer around points for 311 noise complaints for bars, clubs, and restaurants in New York City, I found these gems I’d like to share: They come from GIS Tutor and were a lifesaver.  ST_BUFFER is […]

Updating Demographics Around 7-11 Stores in Manhattan

Note: This is part of an infrequent 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.   Tomorrow, I’ll be presenting my Demographics Around 7-11 Stores in Manhattan for LocationTech NYC in a 5 minute Ignite-style talk.  I’ve been […]

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

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