ST_GeneratePoints
Prev 8.11. ジオメトリ処理関数 Next

Name

ST_GeneratePoints — Converts a polygon or multi-polygon into a multi-point composed of randomly location points within the original areas.

Synopsis

geometry ST_GeneratePoints( g geometry , npoints numeric );

説明

ST_GeneratePoints generates pseudo-random points until the requested number are found within the input area.

Availability: 2.3.0

例

Original Polygon

Generated 12 Points overlaid on top of original polygon

SELECT ST_GeneratePoints(
        ST_Buffer(
                ST_GeomFromText(
                'LINESTRING(50 50,150 150,150 50)'
                ), 10, 'endcap=round join=round'), 12);

Prev Up Next
ST_FlipCoordinates Home ST_Intersection