Database Reference
In-Depth Information
WITH stringprep AS (
SELECT chp04.voronoi_prep(the_geom, gid) FROM
chp04.voronoi_test_points
),
aggstring AS (
SELECT '[' ||
STRING_AGG((voronoi_prep).geomstring, ',' ORDER
BY (voronoi_prep).gid) || ']' AS inputtext
FROM stringprep
),
voronoi_string AS (
SELECT chp04.voronoi_fast(inputtext) AS
vstring FROM aggstring
),
vpoints AS (
SELECT split_part(vstring, ', 999999999,', 1)
|| ']' AS points
FROM voronoi_string
),
vids AS (
SELECT trim(trailing ']' FROM
split_part(vstring, ', 999999999,', 2)) || ']'
AS ids
FROM voronoi_string
),
arpt(pts) AS (
SELECT replace(replace((SELECT points FROM
vpoints), ']' ,'}'), '[', '{')::float8[][]
),
reg AS (
SELECT ROW_NUMBER() OVER() As gid, ('{' ||
region[1] || '}')::integer[] AS regindex
FROM regexp_matches((SELECT ids FROM vids),
'\[([0-9,\s]+)\]','g')
AS region
),
regptloc AS (
SELECT gid, ROW_NUMBER() OVER(PARTITION BY
