Sorry folks, I know it sounds like a lame question - and, yes I did read the manual... :-)
I'm trying to make Voronoi diagrams around points I have in a PostgreSQL table.
It should be rather easy - but I can't find a single example on using ST_VoronoiPolygons()
on real data (i.e. a table of points).
All I keep seeing is examples similar to that in the docs. like this:
SELECT
ST_VoronoiPolygons(geom) AS geom
FROM (SELECT 'MULTIPOINT (50 30, 60 30, 100 100,10 150, 110 120)'::geometry AS geom ) AS g
;
That works fine on my computer. But I want to make Voronoi polygons around my real point, not just example-points hard-coded in the SQL.
Can anybody point me to a working example of SQL that shows the use of ST_VoronoiPolygons()
with an existing PostgreSQL Point table as input.