ST_GeneratePoints
Prev 8.13. Geometry Processing 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 integer );

geometry ST_GeneratePoints( g geometry , npoints integer , seed integer );

Description

ST_GeneratePoints generates pseudo-random points until the requested number are found within the input area. The optional seed must be greater than zero, and is used to regenerate a deterministic sequence of points.

Availability: 2.3.0

Enhanced: 3.0.0, added seed parameter

Examples

Original Polygon

Generated 12 Points overlaid on top of original polygon using a random seed value 1996

SELECT ST_GeneratePoints(geom, 12, 1996)
FROM (
	SELECT ST_Buffer(
		ST_GeomFromText(
		'LINESTRING(50 50,150 150,150 50)'),
		10, 'endcap=round join=round') AS geom
) AS s;

Prev Up Next
ST_FlipCoordinates Home  ST_GeometricMedian