NUMPOINTS()

Documentation

VoltDB Home » Documentation » Using VoltDB

NUMPOINTS()

NUMPOINTS() — Returns the number of points within a polygon GEOGRAPHY value.

Synopsis

NUMPOINTS( polygon )

Description

The NUMPOINTS() function returns the total number of points that comprise a polygon GEOGRAPHY value. The number of points includes the points from both the outer polygon and any inner polygons. It also includes all of the points defining the polygon. Which means the starting point for each polygon is counted twice — once as the starting point and once and the ending point — because this is required in the WKT representation of a polygon.

Example

The following example lists the countries of the world based on the number of points in their outlines.

SELECT NUMPOINTS(outline), name, capital FROM country
   ORDER BY NUMPOINTS(outline);