Database Reference
In-Depth Information
gid) AS ptloc, unnest(regindex) As ptindex
FROM reg),
vregions AS (
SELECT ST_Collect(ST_MakePoint(pts[ptindex +
1][1], pts[ptindex + 1][2]) ORDER BY ptloc ) AS
vregions
FROM regptloc CROSS JOIN arpt
GROUP BY gid
)
SELECT ST_ConvexHull(vregions) AS the_geom FROM
vregions
);
A thanks is deserved by Regina Obe for helping me to write the preceding query.
Nowwecanprocessmuchlargerdatasets.ThefollowingisaVoronoidiagramde-
rived from the address points from the
Improving proximity filtering with KNN - ad-
vanced
recipe, with the coloration based on the azimuth to the nearest street, also
calculated in that recipe.
