Centres for Economic Development, Transport and the Environment (ELY) Areas, 2014 (Scale 1:4,500,000)

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

Click here for a data sample

The table in question is a part of a larger dataset collection and contains data related to ELY-areas for the year 2014, sourced from the statistical center 'Tilastokeskus' in Finland. The table comprises various columns that include geographic, temporal, and descriptive data.

Among the columns, two special ones, '_extract_date' and '_row_number', form a unique identification for each row. The '_extract_date' column indicates the date when the particular data row was extracted from the source, and '_row_number' represents the row number in the data extracted on that particular date.

The table also includes geographic data in columns starting with 'geom_', which can be utilized for geospatial analytics. This geographic data, such as 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', represents various aspects of the geographical location and structure of the ELY-areas. These coordinates are presented using the WGS 84 coordinate reference system with axis order longitude first, followed by latitude.

The table also includes columns labeled 'ely', 'name', 'namn', 'nimi', and 'vuosi', which provide additional descriptive data. For example, 'name', 'namn', and 'nimi' provide the names of the ELY areas in different languages, and 'vuosi' indicates the year of the data.

Such a table can be utilized in various data analytics applications. For instance, the geospatial data can be used to map the ELY areas, track changes over time, or perform spatial analyses. The information could also be used to analyze trends or patterns related to specific ELY areas, potentially informing policy or decision-making in those regions.

Field Descriptions

Name Data type Description
_extract_datedateThis column represents the date when the data on the row of the table was extracted from the data source. It is used together with the '_row_number' to uniquely identify each row.
_row_numberlongThis column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This column is used in combination with '_extract_date' to uniquely identify each row.
elystringThis string column represents a certain entity or group in the dataset.
geom_geojsonstringThis column contains GeoJSON-formatted geographical data, representing the geographical boundaries of the entity or group represented in the 'ely' column.
geom_geotextstringThis column contains geographical data in text format, similar to the data in 'geom_geojson' column but in a different format.
geom_typestringThis column indicates the type of the geographical data stored in 'geom_geojson' and 'geom_geotext' columns.
geom_centroidstringThis column contains the coordinates of the centroid point of the geographical area represented in 'geom_geojson' and 'geom_geotext' columns.
geom_center_xdoubleThis column represents the X-coordinate of the center of the geographical area represented in 'geom_geojson' and 'geom_geotext' columns.
geom_center_ydoubleThis column represents the Y-coordinate of the center of the geographical area represented in 'geom_geojson' and 'geom_geotext' columns.
gml_idstringThis string column contains a unique identifier for each row in the table.
namestringThis column contains the English name of the entity or group represented in the 'ely' column.
namnstringThis column contains the name of the entity or group represented in the 'ely' column in a different language.
nimistringThis column contains the name of the entity or group represented in the 'ely' column in another different language.
vuosilongThis integer column represents the year related to the data in the row.

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
Iddf77c157-c046-4892-9e7d-3d38684e1853
Package id4983d0b6-d6e0-4d62-beec-6bf06b6a11b4
Revision id906f6c02-b6b0-447d-a4de-3ee7d9648863
Stateactive
Tabletilastointialueet_ely4500k_2014__table