Database Reference
In-Depth Information
[[-10.101000000000001, -10.101000000000001],
[24.081081081081081, 24.702702702702709],
[18.071428571428569, 19.785714285714281], [6.5,
-28.5], [12.66666666666667,
-3.833333333333333], [1.5, 11.5],
[10.928571428571431, 11.214285714285721],
[7.7727272727272734, 5.954545454545455], [6.5,
5.0], [2.666666666666667, 5.0], [3.5, 7.5],
999999999, [10, 6, 7, 8, 9], [10, 5, 0, 9], [7,
4, 1, 2, 6], [5, 2, 1, 0], [10, 5, 2, 6], [8,
3, 4, 7], [9, 0, 3, 8], [4, 1, 0, 3]]
(1 row)
The complete code that uses the
chp04.voronoi_fast
function is as follows:
WITH astext AS (
SELECT ST_AsText(the_geom) AS pstring, gid
FROM (
SELECT (ST_DumpPoints(the_geom)).geom AS
the_geom, gid AS gid FROM
chp04.voronoi_test_points
) AS point_dump
),
astextcomma AS (
SELECT replace(pstring, ' ', ',') AS pstring,
gid
FROM astext
),
startingbracket AS (
SELECT replace(pstring, 'POINT(', '[') AS
pstring, gid
FROM astextcomma
),
endingbracket AS (
SELECT replace(pstring, ')', ']') AS pstring,
gid
FROM startingbracket
