PostGIS Cookbook - Second Edition

Getting ready

We will create a small arbitrary point dataset to feed into our function around which we will calculate the Voronoi diagram:

DROP TABLE IF EXISTS chp04.voronoi_test_points; CREATE TABLE chp04.voronoi_test_points ( x numeric, y numeric ) WITH (OIDS=FALSE); ALTER TABLE chp04.voronoi_test_points ADD COLUMN gid serial; ALTER TABLE chp04.voronoi_test_points ADD PRIMARY KEY (gid); INSERT INTO chp04.voronoi_test_points (x, y) VALUES (random() * 5, random() * 7); INSERT INTO chp04.voronoi_test_points (x, y) VALUES (random() * 2, random() * 8); INSERT INTO chp04.voronoi_test_points (x, y) VALUES (random() * 10, random() * 4); INSERT INTO chp04.voronoi_test_points (x, y) VALUES (random() * 1, random() * 15); INSERT INTO chp04.voronoi_test_points ...