Provinces 2019 (1:4,500,000) - Table from the Finnish Statistics Dataset Collection
The table in question encompasses data pertaining to the Finnish regions as of 2019. This includes both geographic and informational data about different parts of Finland. The data is sourced from the Finnish statistical authority, 'Tilastokeskus'.
The table contains geographic data that can be used for geospatial data analytics. Specifically, it includes detailed geographic coordinates presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. This geographic data is held within multiple columns, including those that hold geotext, centroids, and center points.
Additionally, the table holds unique identifiers for each region, as well as names in different languages including Finnish, Swedish, and English. This allows for multi-lingual analysis and can be used to display data in the end users' native languages.
Two special columns, '_extract_date' and '_row_number', are also present in this table. '_extract_date' contains the date when the data on the row of the table was extracted from the data source and '_row_number' contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of these columns uniquely identifies each row.
This data could be utilized in many ways in data analytics. For example, the geographic data could be used to create detailed maps of Finland's regions, with the ability to overlay additional data points from other sources. The language-specific names can be used to build multi-lingual data visualizations or to cross-reference with other multi-lingual data sources. Finally, the extract date and row number could be used to track changes in the data over time, or to ensure data integrity during analysis.
Field Descriptions
Name | Data type | Description |
---|---|---|
_extract_date | date | The date when the data on the row was extracted from the data source. This column, in conjunction with '_row_number', uniquely identifies each row. |
_row_number | long | The row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This column, in conjunction with '_extract_date', uniquely identifies each row. |
geom_geojson | string | The geographical data of the region in GeoJSON format. |
geom_geotext | string | The geographical data of the region in geotext format. |
geom_type | string | The type of the geographical data. |
geom_centroid | string | The centroid of the geographical data. |
geom_center_x | double | The x-coordinate of the center of the geographical data. |
geom_center_y | double | The y-coordinate of the center of the geographical data. |
gml_id | string | The unique identifier of the row in the dataset. |
maakunta | string | The region identifier. |
name | string | The English name of the region. |
namn | string | The name of the region in Swedish. |
nimi | string | The name of the region in Finnish. |
vuosi | long | The year of 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 | 17ff6df0-e8bc-483b-af3d-7285332f11e3 |
Package id | e51a3a4c-9147-4ab7-8d86-490497dfd885 |
Revision id | b2b329d1-3c28-437b-87b6-29af2fc203e1 |
State | active |
Table | tilastointialueet_maakunta4500k_2019__table |