Version History of Regional Boundaries 2020 (1:4 500 000) - History Table
The 'table__history' is a history table that contains the version history of its base rows, sourced from the 'Tilastokeskus' website in Finland. The table is part of a larger dataset collection that presents the regional statistical areas in Finland for the year 2020 at a scale of 1:4,500,000. The data includes information about different regions, such as North Ostrobothnia, South Savo, Central Finland, South Karelia, and Lapland, in various languages.
The table has a unique combination of the '_start_date' and '_row_number' columns that helps to identify each row in the version history table. The '_start_date' column refers to the date when the row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted from the same source. If the '_end_date' column is null, it signifies that the row is the most recent version.
Geographic information is stored in columns starting with 'geom_', which can be utilized for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. The data in these columns could be used to create geospatial visualizations of changes in the regional data over time.
The table also includes the 'maakunta' column that contains numerical identifiers for each region. This data, combined with the version history, could be used in time series analysis to track changes and trends in regional data over time. Similarly, the multilingual region names in the 'name', 'namn', and 'nimi' columns could be used in multilingual data analytics and localization studies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms part of a combination with '_row_number' that uniquely identifies each row in the version history table. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value of the column is null, it indicates that the row is the most recent version. |
| _row_number | long | Contains the number of the row in the raw data extracted from the data source. This, in combination with '_start_date', uniquely identifies each row in the version history table. |
| geom_geojson | string | Stores geometric data in the GeoJSON format, typically representing geographical features. |
| geom_geotext | string | Contains the geometric data in text format. |
| geom_type | string | Indicates the type of geometry stored in the 'geom' columns, such as polygons or multipolygons. |
| geom_centroid | string | This column contains the geometric central point of the geographical feature. |
| geom_center_x | double | Stores the X-coordinate of the geometric center of the geographical feature. |
| geom_center_y | double | Stores the Y-coordinate of the geometric center of the geographical feature. |
| gml_id | string | This is an identifier for the row, typically a combination of the dataset name and the row number. |
| maakunta | string | This column contains codes representing different regions or provinces. |
| name | string | This column contains the English names of the regions or provinces. |
| namn | string | This column contains the Swedish names for the regions or provinces. |
| nimi | string | This column contains the Finnish names for the regions or provinces. |
| vuosi | long | This column contains the year related to the data in the respective row. |
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 | e5c681e4-49a3-4b2e-a1dc-ac068b14bfa0 |
| Package id | a8069dd1-6570-4f1a-835e-b9fae76de0ea |
| Position | 1 |
| Revision id | 7e931785-b87b-43fc-ae46-291aed51a809 |
| State | active |
| Table | tilastointialueet_maakunta4500k_2020__table__history |