This is kind of a simplistic approach maybe - because a simple grid doesn't have to intersect with municipal features. But could you simply decide on a rounding level that would give you what you wanted? Round the lat/lons to a certain decimal level, then count by / group on those rounded lat/lons? Each one could represent centroid or a corner of a grid.
Mark On Thu, Nov 10, 2011 at 4:21 PM, W. Matthew Wilson <[email protected]> wrote: > 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 > [email protected] > http://tplus1.com > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
