Regional Development Areas (ELY) in Finland, 2020 (Scale: 1:4 500 000)

To download the data set, please sign up or log in

Click here for a data sample

The table titled 'table' is part of a larger dataset collection known as 'tilastointialueet_ely4500k_2020'. It houses valuable data pertaining to the ELY areas in 2020 at a scale of 1:4,500,000. This data originates from Finland, specifically from the website of the 'Tilastokeskus' (Statistics Finland). The table is organized into several columns, each providing different data aspects.

Two special columns, '_extract_date' and '_row_number', form a unique identifier for each row. The '_extract_date' column indicates the date the data was extracted from the source, while the '_row_number' provides a unique row number for the extracted data.

The table also includes several 'geom_' prefixed columns, which contain geographic information. These columns hold significant potential for geospatial data analytics, especially as they present geographic coordinates using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.

Columns such as 'ely', 'id', and 'vuosi' provide information about the ELY code, identification number, and the year, respectively. There are also columns that give the name of the ELY Centre in different languages. The 'gml_id' column provides a unique identifier for each geographical location.

This table could be utilized in several ways for data analytics. For instance, the geographic data could be used to create visual representations of the ELY areas. Additionally, the time-stamped extraction dates could be used to observe any changes in the data over time. The multi-lingual name columns also provide an opportunity to analyze the data in a multilingual context.

Field Descriptions

Name Data type Description
_extract_datedateThis column contains the date when the data on the row of the table was extracted from the source. This is important to track the currency of the data.
_row_numberlongThis column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of '_extract_date' and '_row_number' uniquely identifies each row in the table.
elystringThis is a string column that seems to contain some sort of identifier or code.
geom_geojsonstringThis column contains geojson data, which is a format for encoding a variety of geographic data structures.
geom_geotextstringThis column contains geotext data, which may be a textual representation of the geographic data.
geom_typestringThis column specifies the type of the geographic data contained in the 'geom_geojson' and 'geom_geotext' columns. It can be either a polygon or a multipolygon.
geom_centroidstringThis column contains the centroid of the geographic data, which is the center point of the shape.
geom_center_xdoubleThis column contains the x-coordinate of the center of the geographic shape.
geom_center_ydoubleThis column contains the y-coordinate of the center of the geographic shape.
gml_idstringThis column contains a unique identifier for each row in the table.
idlongThis column contains an integer identifier for each row.
namestringThis column contains the English name of the ELY Centre.
namnstringThis column contains the name of the ELY Centre in another language, possibly Swedish.
nimistringThis column contains the name of the ELY Centre in another language, possibly Finnish.
vuosilongThis column contains an integer representing the year, possibly the year the data was collected or the year the data applies to.

No sample for this dataset

Additional Information

Last updated November 11, 2024
Created November 11, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Countryfi
Databasefi_tilastokeskus
Extract date2024-11-11
Idf2f4a99e-da47-42bf-98dd-d837646f68b0
Package id00001bf9-9287-495b-97ec-997968f09c07
Revision idd005bf39-5b4a-4428-afee-820237296da0
Stateactive
Tabletilastointialueet_ely4500k_2020__table