History Version of Large Areas 2016 (Scale 1:4 500 000)
The history table is part of a dataset collection that captures vital information about major regions in Finland during the year 2016. This table contains a record of various versions of each row, allowing for historical tracking of changes. Each row is uniquely identified by a combination of the start date of data extraction and a row number. The start date signifies the day the row was extracted from the data source, while an end date represents the day a new version of the same row was extracted. If the end date is null, it implies that this is the most recent version of the row.
The data in this table provides a wealth of information. For instance, it includes geographical data that can be used for geospatial analytics. This data is presented using the WGS 84 coordinate reference system, with longitude preceding latitude. Each row includes geotext, geojson, and the type of geometric shape representing the region. The centroid and the center coordinates (x and y) are also provided.
In addition to geographical data, the table also includes information on the Finnish regions in three languages: Finnish, Swedish, and English. This multilingual dataset offers a unique opportunity for international researchers and analysts dealing with Finnish data.
The data in this table can be used for a wide range of data analytics purposes. For instance, analysts can track changes in geographic boundaries over time, or compare the development of different regions. Moreover, the multilingual nature of the data can aid in making this information accessible to a broader audience.
This table is sourced from the Finnish statistical authority, 'Tilastokeskus' (Statistics Finland).
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. This, combined with '_row_number', uniquely identifies each row in the history table. |
| _end_date | date | The date when a new version of the row was extracted from the data source. If the value is null, it means that the row is the most recent version. |
| _row_number | long | The number of the row in the raw data extracted from the data source. This, combined with '_start_date', uniquely identifies each row in the history table. |
| geom_geojson | string | The geometric data of the area in GeoJSON format. |
| geom_geotext | string | The geometric data of the area in text format. |
| geom_type | string | The type of the geometric data, which in this case is a multipolygon. |
| geom_centroid | string | The centroid point of the geometric data. |
| geom_center_x | double | The X coordinate of the center point of the geometric data. |
| geom_center_y | double | The Y coordinate of the center point of the geometric data. |
| gml_id | string | A unique identifier for each row. |
| name | string | The English name of the area. |
| namn | string | The Swedish name of the area. |
| nimi | string | The Finnish name of the area. |
| suuralue | string | A code that represents the area. |
| vuosi | double | The year, represented as a real number. |
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 | 1f96a7dd-19f9-4d06-8688-60326547400e |
| Package id | 36bc39de-99d7-4661-9118-9bc20d3101d1 |
| Position | 1 |
| Revision id | 743f5c44-8517-4e24-b8a5-28d460c68a31 |
| State | active |
| Table | tilastointialueet_suuralue4500k_2016__table__history |