Extension that adds support for working with the EEA Reference Grid System.
Installing and Loading
INSTALL eeagrid FROM community;
LOAD eeagrid;
Example
SELECT EEA_CoordXY2GridNum(5078600, 2871400);
----
23090257455218688
SELECT EEA_GridNum2CoordX(23090257455218688);
----
5078600
SELECT EEA_GridNum2CoordY(23090257455218688);
----
2871400
SELECT EEA_GridNumAt100m(23090257455218688);
----
23090257455218688
SELECT EEA_GridNumAt1km(23090257455218688);
----
23090257448665088
SELECT EEA_GridNumAt10km(23090257455218688);
----
23090255284404224
About eeagrid
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:
Coordinate Reference System (CRS)
: ETRS89 / LAEA Europe (EPSG:3035), which minimizes area distortion across Europe. The Geodetic Datum is the European Terrestrial Reference System 1989 (EPSG:6258). The Lambert Azimuthal Equal Area (LAEA) projection is centred at 10°E, 52°N. Coordinates are based on a false Easting of 4321000 meters, and a false Northing of 3210000 meters.Supported resolutions
: Typically available at 10 km, 1 km, and 100 m resolutions.Structure
: Regular square grid with unique cell codes and identifiers assigned based on position and resolution.Purpose
: Enables harmonized spatial analysis, mapping, and cross-border environmental assessments.
This grid system is widely used in European environmental datasets, including air quality, land use, biodiversity, and climate change indicators.
The extension provides functions to calculate grid cell identifiers (INT64
) from XY coordinates based on the EPSG:3035
coordinate reference system, and vice versa. Please see the function table for the current implementation status.
Added Functions
function_name | function_type | description | comment | examples |
---|---|---|---|---|
EEA_CoordXY2GridNum | scalar | Returns the EEA Reference Grid code to a given XY coordinate (EPSG:3035). | NULL | [SELECT EEA_CoordXY2GridNum(5078600, 2871400);] |
EEA_GridNum2CoordX | scalar | Returns the X-coordinate (EPSG:3035) of the grid cell corresponding to a given EEA Reference Grid code. | NULL | [SELECT EEA_GridNum2CoordX(23090257455218688);] |
EEA_GridNum2CoordY | scalar | Returns the Y-coordinate (EPSG:3035) of the grid cell corresponding to a given EEA Reference Grid code. | NULL | [SELECT EEA_GridNum2CoordY(23090257455218688);] |
EEA_GridNumAt100m | scalar | Returns the Grid code at 100 m resolution given an EEA reference Grid code. | NULL | [SELECT EEA_GridNumAt100m(23090257455218688);] |
EEA_GridNumAt10km | scalar | Returns the Grid code at 10 km resolution given an EEA reference Grid code. | NULL | [SELECT EEA_GridNumAt10km(23090257455218688);] |
EEA_GridNumAt1km | scalar | Returns the Grid code at 1 km resolution given an EEA reference Grid code. | NULL | [SELECT EEA_GridNumAt1km(23090257455218688);] |