Geospatial Types

Geospatial types contain information about points, paths, and polygons on the surface of the Earth. For more information, see Working with Geospatial Features.

Data Type	Size	Size (Not Null)
GEOGRAPHYPOINT	8 bytes	8 bytes
GEOGRAPHY	See note

Important

The space consumed by the path and polygon data in Geography columns is dependent on the complexity of the objects. Very roughly, a Geography value consumes 24 bytes per vertex, plus a 64 byte overhead, plus some minor overhead for each “ring” in a multipolygon.

Indexing a Geography object may also consume more space than indexes over other data types. The rule of thumb is 40 bytes * the value of the RESOLUTION parameter of the index, per row.

Geospatial Types

Was this article helpful?

Was this article helpful?