{"repo":"ahuarte47/duckdb-raster","free":true,"listed":false,"github":"https://github.com/ahuarte47/duckdb-raster","clone":"git clone https://github.com/ahuarte47/duckdb-raster.git","description":"DuckDB Extension for reading and writing raster files using SQL.","language":"C","stars":52,"topics":["duckdb","duckdb-extension","earth-observation","raster","spatial"],"license":"MIT","category":"databases-storage","readme_excerpt":"DuckDB Raster Extension A DuckDB extension for reading and writing geospatial raster data using SQL. It exposes raster files (e.g. GeoTIFF, COG, VRT) as standard DuckDB tables, with one row per tile and one datacube column per band. You can filter, transform, and aggregate raster data using plain SQL, and write results back to any GDAL-supported raster format. How do I get it? Loading from community The DuckDB Raster Extension is available as a signed community extension. See more details on its DuckDB CE web page. To install and load it, you can run the following SQL commands in DuckDB: Function Reference Table Functions Function Summary --- --- RT Drivers Returns the list of supported GDAL raster drivers and file formats. RT Read Reads a raster file (or a mosaic of raster files) and returns a table with the raster data. RT ReadCells Reads a raster file (or a mosaic of raster files) and returns a table with one row per value cell in the raster. RT Write ( COPY TO ) Exports a data table to a new raster file. Scalar Functions Function Summary --- --- RT Array2Cube Packages a plain SQL array into a datacube column. RT Cube2Array Extracts pixel values from a datacube column into a plain SQL array. RT Cube2Type Changes the pixel data type of a datacube. RT Cube Applies a unary operation to the datacube element-wise ( RT CubeNeg , RT CubeAbs , …). RT Cube Applies a binary operation between two datacubes or a datacube and a scalar. Operators + , - , , / , ^ , % are also supported. ","default_branch":null,"files":null,"tree":[],"storefront":"/r/ahuarte47","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ahuarte47/duckdb-raster/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}