[postgis-users] How can I divide up a region into a grid of rectangles?

W. Matthew Wilson matt at tplus1.com
Thu Nov 10 13:21:34 PST 2011


I have a data set that tracks where people parked when their car got
towed.  Each row in the data has a latitude and a longitude and a
date.

I don't care about the date right now.  I want to aggregate this data
by neighborhood.  In order to keep stuff simple, how could I do
something like divide up city into a bunch of squares in a grid, and
then count up how many cars got towed in each square?

Later I'll worry about making the grids look more like actual
neighborhood boundaries.

Any ideas how to do something like this?

Thanks in advance!

Matt

-- 
W. Matthew Wilson
matt at tplus1.com
http://tplus1.com



More information about the postgis-users mailing list