ELY Areas 2024 Projection at 1:4,500,000 Scale
The table under consideration is part of a dataset collection that presents ELY areas data for the year 2024 at a scale of 1:4,500,000. ELY, or Centre for Economic Development, Transport and the Environment, is a regional administrative agency in Finland. The table incorporates a varied range of columns that encapsulate diverse information.
The data is geographical in nature, making it highly valuable for geospatial data analytics. Columns starting with 'geom_' contain this geographic information. For instance, 'geom_type' specifies the type of geographic shape represented, such as a polygon or multipolygon. The centroid of these shapes is stored in 'geom_centroid', while 'geom_center_x' and 'geom_center_y' store the longitude and latitude respectively, in the WGS 84 coordinate reference system. The 'geom_geojson' and 'geom_geotext' columns store the geographic objects in different formats.
In addition, the table includes columns like 'ely', 'name', 'namn', and 'nimi', which store identifiers and names of the ELY centers in various languages, making the data accessible to a wider audience. 'Vuosi' indicates the year to which the data pertains.
Two special columns, '_extract_date' and '_row_number', play a pivotal role in uniquely identifying each row of data. The former stores the date of data extraction, while the latter indicates the row number of the extracted data.
With this rich set of data, an analyst could perform a variety of tasks. For example, one could study regional development by analyzing the spatial distribution of ELY areas. Alternatively, the data could be used to research the effects of economic policies across different ELY regions over time. The data is sourced from the website of 'Tilastokeskus' (Statistics Finland), underlining its credibility and reliability.
Field Descriptions
Name | Data type | Description |
---|---|---|
_extract_date | date | This column contains the date when the data on the row was extracted from the data source. The format of the date is YYYY-MM-DD. |
_row_number | long | This column contains the row number in the data extracted from the source. Each row number is unique for each extraction date. |
ely | string | This column contains a string-type unique identifier for a specific geography within Finland. |
geom_geojson | string | This column contains the geographical data of the region in GeoJSON format. |
geom_geotext | string | This column contains the geographical data of the region in a text format. |
geom_type | string | This column indicates the type of the geographical data which can be either a Polygon or a MultiPolygon. |
geom_centroid | string | This column contains the coordinates of the centroid (geographical center) of the region. |
geom_center_x | double | This column contains the x-coordinate (longitude) of the centroid of the region. |
geom_center_y | double | This column contains the y-coordinate (latitude) of the centroid of the region. |
gml_id | string | This column contains a unique GML (Geography Markup Language) identifier for each row. |
id | long | This column contains an integer-type unique identifier for each row. |
name | string | This column contains the English name of the region. |
namn | string | This column contains the Swedish name of the region. |
nimi | string | This column contains the Finnish name of the region. |
vuosi | long | This column contains the year associated with the data row. The data type of this column is integer. |
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 | |
Country | fi |
Database | fi_tilastokeskus |
Extract date | 2024-11-11 |
Id | ed7ef354-5b65-40f1-93fb-250914159d00 |
Package id | 01da5ded-3128-4dd4-9f36-e54366380ec9 |
Revision id | 44beb4d6-1714-46f4-8e39-ddd6de4d9a36 |
State | active |
Table | tilastointialueet_ely4500k_2024__table |