---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github.com/duckdb/community-extensions repository, check README there
title: geography
excerpt: |
DuckDB Community Extensions
Global spatial data processing on the sphere
extension:
name: geography
description: Global spatial data processing on the sphere
version: 0.1.1
language: C++
build: cmake
license: MIT
excluded_platforms: "wasm_mvp;wasm_eh;wasm_threads"
maintainers:
- paleolimbot
repo:
github: paleolimbot/duckdb-geography
ref: 05dcc8fd1df597907135e62a72a7b63aff3289cd
docs:
hello_world: |
SELECT * FROM s2_data_countries();
extended_description: |
The geography extension provides global spatial indexing and analysis on the sphere
using Google's s2geometry library. For full documentation, see the
[README](https://github.com/paleolimbot/duckdb-geography/blob/main/README.md)
and [function documentation](https://github.com/paleolimbot/duckdb-geography/blob/main/docs/function-reference.md).
extension_star_count: 51
extension_star_count_pretty: 51
extension_download_count: 3288
extension_download_count_pretty: 3.3k
image: '/images/community_extensions/social_preview/preview_community_extension_geography.png'
layout: community_extension_doc
---
### Compatibility Matrix
This table covers all DuckDB releases that have not reached [end-of-life](https://duckdb.org/release_calendar), including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.
| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
| :--- | :---: | :---: | :---: | :---: | :---: |
| Linux AMD64 | ✅ | ❌ | ✅ | ✅ | ❌ |
| Linux ARM64 | ✅ | ❌ | ✅ | ✅ | ❌ |
| macOS AMD64 | ✅ | ❌ | ✅ | ✅ | ❌ |
| macOS ARM64 | ✅ | ❌ | ✅ | ✅ | ❌ |
| Windows AMD64 | ✅ | ❌ | ✅ | ✅ | ❌ |
| Windows ARM64 | ❌ | ❌ | ❌ | ❌ | ❌ |
| WebAssembly | ❌ | ❌ | ❌ | ❌ | ❌ |
### Installing and Loading
```sql
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};
```
{% if page.docs.hello_world %}
### Example
```sql
{{ page.docs.hello_world }}```
{% endif %}
{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}
### Added Functions
| function_name | function_type | description | comment | examples |
|---------------------------------|---------------|-------------|---------|----------|
| s2 | scalar | NULL | NULL | |
| s2_arbitrarycellfromwkb | scalar | NULL | NULL | |
| s2_area | scalar | NULL | NULL | |
| s2_astext | scalar | NULL | NULL | |
| s2_aswkb | scalar | NULL | NULL | |
| s2_bounds_box | scalar | NULL | NULL | |
| s2_bounds_box_agg | aggregate | NULL | NULL | |
| s2_box | scalar | NULL | NULL | |
| s2_box_intersects | scalar | NULL | NULL | |
| s2_box_struct | scalar | NULL | NULL | |
| s2_box_union | scalar | NULL | NULL | |
| s2_box_wkb | scalar | NULL | NULL | |
| s2_cell_child | scalar | NULL | NULL | |
| s2_cell_contains | scalar | NULL | NULL | |
| s2_cell_edge_neighbor | scalar | NULL | NULL | |
| s2_cell_from_token | scalar | NULL | NULL | |
| s2_cell_intersects | scalar | NULL | NULL | |
| s2_cell_level | scalar | NULL | NULL | |
| s2_cell_parent | scalar | NULL | NULL | |
| s2_cell_range_max | scalar | NULL | NULL | |
| s2_cell_range_min | scalar | NULL | NULL | |
| s2_cell_token | scalar | NULL | NULL | |
| s2_cell_vertex | scalar | NULL | NULL | |
| s2_cellfromlonlat | scalar | NULL | NULL | |
| s2_cellfromwkb | scalar | NULL | NULL | |
| s2_contains | scalar | NULL | NULL | |
| s2_covering | scalar | NULL | NULL | |
| s2_covering_fixed_level | scalar | NULL | NULL | |
| s2_data_cities | table | NULL | NULL | |
| s2_data_city | scalar | NULL | NULL | |
| s2_data_countries | table | NULL | NULL | |
| s2_data_country | scalar | NULL | NULL | |
| s2_dependencies | table | NULL | NULL | |
| s2_difference | scalar | NULL | NULL | |
| s2_dimension | scalar | NULL | NULL | |
| s2_distance | scalar | NULL | NULL | |
| s2_dwithin | scalar | NULL | NULL | |
| s2_equals | scalar | NULL | NULL | |
| s2_format | scalar | NULL | NULL | |
| s2_geogfromtext | scalar | NULL | NULL | |
| s2_geogfromtext_novalidate | scalar | NULL | NULL | |
| s2_geogfromwkb | scalar | NULL | NULL | |
| s2_geogfromwkb_novalidate | scalar | NULL | NULL | |
| s2_intersection | scalar | NULL | NULL | |
| s2_intersects | scalar | NULL | NULL | |
| s2_is_valid | scalar | NULL | NULL | |
| s2_is_valid_reason | scalar | NULL | NULL | |
| s2_isempty | scalar | NULL | NULL | |
| s2_length | scalar | NULL | NULL | |
| s2_max_distance | scalar | NULL | NULL | |
| s2_mayintersect | scalar | NULL | NULL | |
| s2_num_points | scalar | NULL | NULL | |
| s2_perimeter | scalar | NULL | NULL | |
| s2_prepare | scalar | NULL | NULL | |
| s2_register_geoarrow_extensions | table | NULL | NULL | |
| s2_union | scalar | NULL | NULL | |
| s2_x | scalar | NULL | NULL | |
| s2_y | scalar | NULL | NULL | |
### Overloaded Functions
This extension does not add any function overloads.
### Added Types
| type_name | type_size | logical_type | type_category | internal |
|----------------|----------:|--------------|---------------|----------|
| GEOGRAPHY | 16 | BLOB | NULL | true |
| S2_BOX | 0 | STRUCT | COMPOSITE | true |
| S2_CELL | 8 | UBIGINT | NUMERIC | true |
| S2_CELL_CENTER | 8 | UBIGINT | NUMERIC | true |
| S2_CELL_UNION | 16 | LIST | COMPOSITE | true |
### Added Settings
This extension does not add any settings.