ST_GeneratePoints

ST_GeneratePoints
Prev	8.11. 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.

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