Search Shortcut cmd + k | ctrl + k
eeagrid

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

Maintainer(s): ahuarte47

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);]