Hi Brent,
I use something like this, should be adaptable to your use (but might not be the best way). this makes a 10000 foot sided cell, and translates it 10x and 10y. Eric select st_translate(geom, 0 ,yseries) as geom from (select generate_series(0,90000, 10000) as yseries,st_translate(geom, xseries ,0) as geom from (select generate_series(0, 90000, 10000) as xseries, geom from (select st_envelope(st_makeline(st_makepoint(1380000,630000),st_makepoint(1390000,640000))) as geom) as t1) as t2) as t3 -----Original Message----- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net]on Behalf Of pcr...@pcreso.com Sent: Sunday, October 17, 2010 1:39 PM To: postgis-users@postgis.refractions.net Subject: [postgis-users] How best to build a regular grid from points Hi, I have a set of 155,000,000 points on a regular grid. I need to convert these to a set of square polygons covering the area represented by the points. Can anyone suggest how this could be done in Postgis? Thanks, Brent Wood _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
