---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github/duckdb/community-extensions repository, check README there
title: geotiff
excerpt: |
  DuckDB Community Extensions
  Read GeoTIFF rasters as (cell_id, value) via GDAL

extension:
  name: geotiff
  description: Read GeoTIFF rasters as (cell_id, value) via GDAL
  version: 0.1.2
  language: C++
  build: cmake
  licence: MIT
  maintainers:
    - babaknaimi
  excluded_platforms: "windows_amd64_mingw"

repo:
  github: babaknaimi/duckdb-geotiff
  ref: 3fa51dbe85cb890dea8416c07c90f30147b9d6a4
  

docs:
  hello_world: |
    -- one band -> (cell_id, value)
    INSTALL geotiff FROM community;
    LOAD geotiff;
    SELECT * FROM read_geotiff('cea.tif', band := 1) LIMIT 5;

    -- multiple bands -> (cell_id, band1, band2, ...)
    SELECT * FROM read_geotiff('cea.tif', band := [1,2,3]) LIMIT 5;
  extended_description: |
    The geotiff extension streams GeoTIFF rasters using GDAL and exposes them as
    DuckDB table functions. For a single band it returns (cell_id BIGINT, value DOUBLE).
    If you pass multiple bands (e.g., band := [1,2,3]) it returns a wide schema:
    (cell_id, band1, band2, …). This is optimized for fast CTAS/UPDATE patterns
    when building “wide” raster tables inside DuckDB.
extension_star_count: 2
extension_star_count_pretty: 2
extension_download_count: null
extension_download_count_pretty: n/a
image: '/images/community_extensions/social_preview/preview_community_extension_geotiff.png'
layout: community_extension_doc
---

### 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

<div class="extension_functions_table"></div>

| function_name | function_type | description | comment | examples |
|---------------|---------------|-------------|---------|----------|
| read_geotiff  | table         | NULL        | NULL    |          |