Spatial Features

New in v20.2: CockroachDB supports efficiently storing and querying spatial data.

See the links below for more information about how to use CockroachDB for spatial use cases.

Getting Started

• Install CockroachDB
• Working with Spatial Data
• Spatial tutorial

Migrating spatial data into and out of CockroachDB

• Migrate from Shapefiles
• Migrate from GeoJSON
• Migrate from GeoPackage
• Migrate from OpenStreetMap
• Export Spatial Data

Reference

• Spatial indexes
• Spatial and GIS Glossary of Terms
• Known Limitations
• Spatial functions
• Client library compatibility

Spatial objects

• POINT
• LINESTRING
• POLYGON
• MULTIPOINT
• MULTILINESTRING
• MULTIPOLYGON
• GEOMETRYCOLLECTION

Data representations

• Well known text
• Well known binary
• GeoJSON
• SRID 4326 - longitude and latitude

Spatial functions

In addition to the generated reference documentation for spatial functions, we have written additional documentation for the following functions, including examples:

• ST_Contains
• ST_ConvexHull
• ST_CoveredBy
• ST_Covers
• ST_Disjoint
• ST_Equals
• ST_Intersects
• ST_Overlaps
• ST_Touches
• ST_Union
• ST_Within

See also

• Introducing Distributed Spatial Data in Free, Open Source CockroachDB (blog post)