Geospatial analytics
Vertica provides functions that allows you to manipulate complex two and threedimensional spatial objects. These functions follow the Open Geospatial Consortium (OGC) standards. Vertica also provides data types and SQL functions that allow you to specify and store spatial objects in a database according to OGC standards.
Convert wellknown text (WKT) and wellknown binary (WKB)
Convert WKT and WKB.
Optimized spatial joins
Perform fast spatial joins using ST_Intersects and STV_Intersects.
Load and export spatial data from shapefiles
Easily load and export shapefiles.
Store and retrieve objects
Determine if:

An object contains selfintersection or selftangency points.

One object is entirely within another object, such as a point within a polygon.
Test the relationships between objects
For example, if they intersect or touch:

Identify the boundary of an object.

Identify vertices of an object.
Calculate

Shortest distance between two objects.

Size of an object (length, area).

Centroid for one or more objects.

Buffer around one or more objects.