Regions of Finland 2016 (Scale 1:4 500 000)
The table, sourced from the 'Tilastokeskus' (Statistics Finland) website, is a part of a larger dataset collection and provides detailed geographic and demographic data relevant to the provinces of Finland in 2016. This information is particularly useful for geospatial data analytics, given its inclusion of geographic coordinates presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The table contains information about the province code, the Finnish name, Swedish name, and an alternate Finnish name for the province. The year of the data is also included in the table, signifying the time relevance of the data.
In addition to the demographic data, the table offers a wealth of geospatial data. This includes columns with geographic coordinates in both GeoJSON and GeoText format, as well as the type of geographic shape, its center, and centroid. This combination of demographic and geospatial data offers a multifaceted overview of each province, crucial for various forms of data analysis.
Two special columns, '_extract_date' and '_row_number', play a key role in the table. The '_extract_date' column shows the date the data for that row was extracted, while the '_row_number' indicates the row number in the data extracted from the source on the specified extract date. These two columns together uniquely identify each row in the table.
The table's data can be utilized in various ways in data analytics. For instance, it could be used to analyze population trends across different provinces over time, considering the demographic data. Additionally, the geospatial data could facilitate spatial analyses, such as evaluating spatial patterns or conducting regional planning. Another potential use could be in the field of environmental studies, where the geographic data could help understand the impact of environmental factors on different provinces.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row was extracted from the source. It is a part of a unique identifier for each row when combined with the '_row_number' column. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It helps in uniquely identifying each row when combined with the '_extract_date' column. |
| geom_geojson | string | This column contains geometric data of the regions in GeoJSON format. It provides spatial information in a format widely used in geospatial systems. |
| geom_geotext | string | This column provides geometric information in text format. It allows for a human-readable representation of the geometric data. |
| geom_type | string | This column specifies the type of the geometry. In this table, it is 'ST_MULTIPOLYGON', indicating the geometric data represents multiple polygons. |
| geom_centroid | string | This column contains the central point (centroid) of the geometric shape representing each region. It provides a single point reference for the geometric data. |
| geom_center_x | double | This column contains the X-coordinate of the centroid of the geometric shape. It provides the longitude of the central point of the region. |
| geom_center_y | double | This column contains the Y-coordinate of the centroid of the geometric shape. It provides the latitude of the central point of the region. |
| gml_id | string | This column contains unique identifiers for the data records, which also include the year that the data pertains to. |
| maakunta | string | This column contains the coded representation of the provinces in Finland. |
| name | string | This column contains the names of the provinces in English. |
| namn | string | This column contains the names of the provinces in Swedish, one of the national languages of Finland. |
| nimi | string | This column contains the names of the provinces in Finnish, the official language of Finland. |
| vuosi | double | This column contains the year that the data pertains to, which is 2016 in this case. |
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 | 7ced6646-3945-4c58-855c-992de41f60ed |
| Package id | 8fe60840-1096-4bbf-be7a-5e0e086f9ab5 |
| Revision id | d30a5923-d0f1-4bbd-8314-0ade714341ef |
| State | active |
| Table | tilastointialueet_maakunta4500k_2016__table |