Geospatial Analytics

Vertica provides functions that allows you to manipulate complex two- and three-dimensional 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 Well-Known Text (WKT) and Well-Known 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:

Test the relationships between objects

For example, if they intersect or touch:

Calculate