ELY Areas 2017 (Scale 1:1,000,000) - Dataset Table from the Finnish Statistics Bureau
The table in discussion is a part of a larger dataset collection that focuses on the ELY-areas for the year 2017, represented at a scale of 1:1 million. This table is sourced from the Statistics Finland (Tilastokeskus) website, which is based in Finland. The gathered data is organized into several columns, capturing a diverse range of information.
Two of these columns are particularly noteworthy: one captures the date when the data for each row was extracted, while the other signifies the row number from the original data source. Together, these columns uniquely identify each row in the table.
The table also comprises columns that contain geographic data. These are especially useful for geospatial data analytics, as they present geographic coordinates using the WGS 84 coordinate reference system, where the axis order is longitude first, followed by latitude.
The geographic information includes a variety, from the geojson and geotext format of the geographical area to the type of geometry used. It also captures the centroid of the geometry and the X and Y coordinates of the center of the geometry.
Other columns in the table provide details about the region's unique identifier, the region's Finnish and Swedish names, and the year the data was recorded.
Data from this table could be put to various uses in data analytics. For instance, the geographic information could be used to create visual maps of the regions for better understanding of the area distribution. The region names could be used in analyzing trends over time and comparing data between different ELY areas. Additionally, the unique identifiers could be used for merging this data with other related datasets for a more comprehensive analysis.
Field Descriptions
Name | Data type | Description |
---|---|---|
_extract_date | date | This column holds the date when the data was extracted, helping to identify the specific version of the data. |
_row_number | long | This column contains the row number of the data extracted, which, when combined with the '_extract_date', uniquely identifies each row. |
ely | string | This string column represents a certain code related to the data. |
geom_geojson | string | This column contains geospatial data in GeoJSON format, defining the geographical structure of the data. |
geom_geotext | string | This column contains the geographical data in text format, providing a human-readable representation of the geographical structure. |
geom_type | string | This column describes the type of geographical data structure, in this case, a multi-polygon. |
geom_centroid | string | This column gives the centroid of the geographical structure, representing the center point of the geographical area. |
geom_center_x | double | This column provides the X coordinate of the center of the geographical area. |
geom_center_y | double | This column provides the Y coordinate of the center of the geographical area. |
gid | long | This integer column appears to be a unique identifier for the data. |
gml_id | string | This string column seems to be another form of unique identifier for the data. |
name | string | This column contains the English name of the entity the data represents. |
namn | string | This column contains the name of the entity in another language, providing multi-lingual support. |
nimi | string | This column also contains the name of the entity in another language, further enhancing multi-lingual support. |
vuosi | double | This real type column seems to represent the year related to the data. |
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 | d3b0599a-e448-40f9-8b4f-48e1d70830ef |
Package id | 8ad3f748-85fc-4751-844c-012532e1d106 |
Revision id | e95eaeea-1631-4e01-b55c-b01bc6fd7315 |
State | active |
Table | tilastointialueet_ely1000k_2017__table |