Spatial Data Overview

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
• 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 CockroachDB (blog post)
• Using GeoServer with CockroachDB