pgr_pointsAsPolygon¶
Name¶
pgr_pointsAsPolygon
— Draws an alpha shape around given set of points.
Synopsis¶
Returns the alpha shape as (multi)polygon geometry.
geometry pgr_pointsAsPolygon(text sql [, float8 alpha]);
Description¶
sql: |
SELECT id, x, y FROM vertex_result;
|
||||||
---|---|---|---|---|---|---|---|
alpha: | (optional) |
Returns a (multi)polygon geometry (with holes).
History
- Renamed in version 2.0.0
- Added alpha argument with default 0 (use optimal value) in version 2.1.0
- Supported to return a (multi)polygon geometry (with holes) in version 2.1.0
Examples¶
In the following query there is no way to control which point in the polygon is the first in the list, so you may get similar but different results than the following which are also correct.
SELECT ST_AsText(pgr_pointsAsPolygon('SELECT id::integer, ST_X(the_geom)::float AS x, ST_Y(the_geom)::float AS y
FROM edge_table_vertices_pgr'));
st_astext
------------------------------------------------------
POLYGON((2 4,3.5 4,4 3,4 2,4 1,2 0,0 2,0.5 3.5,2 4))
(1 row)
The query use the Sample Data network.
See Also¶
- pgr_drivingDistance - Driving Distance
- pgr_alphaShape - Alpha shape computation
Indices and tables