Skip to content
DuckDB community extension

eeagrid

Extension that adds support for working with the EEA Reference Grid System.

01 / SETUP

Install and load

Run these commands in a Haybarn SQL session. The extension is available from the community repository.

Haybarn 2.0.0 · SQL
INSTALL eeagrid FROM community;
LOAD eeagrid FROM community;

Try it in a temporary SQL session with eeagrid already loaded. Queries run in this tab; examples using files or services need their own setup.

Using upstream DuckDB? Follow the maintainer’s installation instructions.

02 / QUERY

Usage example

SQL
SELECT EEA_CoordXY2GridNum(5078600, 2871400);
----
23090257455218688

SELECT EEA_GridNum2CoordX(23090257455218688);
----
5078600

SELECT EEA_GridNum2CoordX(23090257455218688, 1_000_000);
----
5000000

SELECT EEA_GridNum2CoordY(23090257455218688);
----
2871400

SELECT EEA_GridNum2CoordY(23090257455218688, 1_000);
----
2871000

SELECT EEA_GridNumAt100m(23090257455218688);
----
23090257455218688

SELECT EEA_GridNumAt1km(23090257455218688);
----
23090257448665088

SELECT EEA_GridNumAt10km(23090257455218688);
----
23090255284404224

Provided by ahuarte47. Not yet verified on Haybarn 2.0.0.

Sample data & setup

About this extension

The EEA Reference Grid extension adds support for working with the EEA Reference Grid System.

The EEA Reference Grid is a standardized spatial grid system used across Europe for environmental data analysis and reporting. It is maintained by the European Environment Agency (EEA) and forms the basis for aggregating and exchanging geospatial data in a consistent format:

Project overview from the community descriptor.

Documentation and resources

Project and build details
Repository
ahuarte47/duckdb-eeagrid
License
MIT
Maintainers
ahuarte47
Written in
C++
Build source
4f56d8aaa66a
Build definition
Community descriptor