Install and load
Run these commands in a Haybarn SQL session. The extension is available from the community repository.
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.
Usage example
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 & setupAbout 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