You are the Man, Stan! Eric
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Sufficool, Stanley Sent: Thursday, May 29, 2008 4:21 PM To: PostGIS Users Discussion Subject: RE: [postgis-users] hexagonal grid Generate a hexagonal grid of 64x128 hexes, then follow the slice/dice from bostongis at step 4. Substitute the values in generate series with your datasource min/max X/Y extents. =============================== create table hex_grid (gid serial not null primary key, the_geom geometry not null); INSERT INTO hex_grid (the_geom) SELECT translate(the_geom, x_series, y_series) from generate_series(0 - 128, 10000 + 128, 128) as x_series, generate_series(0 - 128, 10000 + 128, 256) as y_series, ( SELECT 'POLYGON((0 0,64 64,64 128,0 192,-64 128,-64 64,0 0))'::geometry as the_geom UNION SELECT translate('POLYGON((0 0,64 64,64 128,0 192,-64 128,-64 64,0 0))'::geometry, 64, 128) as the_geom ) as one_hex =============================== -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matias Massigoge Sent: Thursday, May 29, 2008 12:58 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] hexagonal grid Thanks Paul!! On Thu, May 29, 2008 at 4:42 PM, Paul Ramsey <[EMAIL PROTECTED]> wrote: > Try this: > > http://www.bostongis.com/blog/index.php?/archives/35-Map-Dicing-and-ot > her-stuff.html > > P. > > On Thu, May 29, 2008 at 12:34 PM, Matias Massigoge > <[EMAIL PROTECTED]> wrote: >> Hi all, >> >> I'm looking for something similar but squared. >> This theme have been covered in the past? >> Sorry, I'm newby. >> Thanks all. >> >> MatÃas >> >> >> >> On Thu, May 29, 2008 at 12:42 PM, Brent Wood <[EMAIL PROTECTED]> >> wrote: >>> >>>> On Thu, May 29, 2008 at 7:08 AM, Randall, Eric >>>> <[EMAIL PROTECTED]> >>> wrote: >>>> > Has anyone created a method for generating a hexagonal grid over >>>> > a polygon >>>> envelope using postgis? Thought I'd ask before setting out. >>>> Thanks. >>> >>> Hi Eric >>> >>> I haven't specifically done this in PostGIS, but have briefly looked >>> into something similar with a colleague who uses R extensively, and >>> was looking at cellular automata modelling over a hexagonal grid. He >>> was using such a dataset in R, & there were a few ways this could be >>> transferred to PostGIS, including the R:gdal package, or a >>> dump/parse/reformat/import script. >>> >>> Cheers, >>> >>> Brent Wood _______________________________________________ >>> 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 >> > _______________________________________________ > 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 _______________________________________________ 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
