[postgis-users] Voronoi tessellation

[Puneet Kishor]

On Mar 5, 2012, at 8:44 PM, Simon Greener wrote:

> Try
> http://postgis.refractions.net/pipermail/postgis-users/2007-June/016102.html



Y'know, I tried that. I got a cryptic error at

	points <- pg.spi.exec(sprintf("select x(%2$s) as x, y(%2$s) as y from %1$s;"

The error was

ERROR:  R interpreter expression evaluation error
DETAIL:  Error in pg.spi.exec(sprintf("select x(%2$s) as x, y(%2$s) as y from %1$s;",  : 
  error in SQL statement : syntax error at or near ";"
CONTEXT:  In R support function pg.spi.exec
In PL/R function voronoi

********** Error **********

ERROR: R interpreter expression evaluation error
SQL state: 22000
Detail: Error in pg.spi.exec(sprintf("select x(%2$s) as x, y(%2$s) as y from %1$s;",  : 
  error in SQL statement : syntax error at or near ";"
Context: In R support function pg.spi.exec
In PL/R function voronoi



> or
> http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut02
> Simon
> On Tue, 06 Mar 2012 13:41:41 +1100, Puneet Kishor <punk.kish at gmail.com> wrote:
> 
>> Given a set of points in "the_geom", how can I create a voronoi tessellation and store it as an additional geometry column? Are there a set of built in functions in Pg that I can use?
>> 
>> 
>> --
>> Puneet Kishor
>>