Regional Development Areas (ELY) in Finland, 2020 (Scale: 1:4 500 000)
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_date | date | This 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_number | long | This 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. |
ely | string | This is a string column that seems to contain some sort of identifier or code. |
geom_geojson | string | This column contains geojson data, which is a format for encoding a variety of geographic data structures. |
geom_geotext | string | This column contains geotext data, which may be a textual representation of the geographic data. |
geom_type | string | This 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_centroid | string | This column contains the centroid of the geographic data, which is the center point of the shape. |
geom_center_x | double | This column contains the x-coordinate of the center of the geographic shape. |
geom_center_y | double | This column contains the y-coordinate of the center of the geographic shape. |
gml_id | string | This column contains a unique identifier for each row in the table. |
id | long | This column contains an integer identifier for each row. |
name | string | This column contains the English name of the ELY Centre. |
namn | string | This column contains the name of the ELY Centre in another language, possibly Swedish. |
nimi | string | This column contains the name of the ELY Centre in another language, possibly Finnish. |
vuosi | long | This 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 | |
Country | fi |
Database | fi_tilastokeskus |
Extract date | 2024-11-11 |
Id | f2f4a99e-da47-42bf-98dd-d837646f68b0 |
Package id | 00001bf9-9287-495b-97ec-997968f09c07 |
Revision id | d005bf39-5b4a-4428-afee-820237296da0 |
State | active |
Table | tilastointialueet_ely4500k_2020__table |