Historical Version Records for Subregions 2020 (1:4 500 000)
The 'table__history' is part of a larger dataset collection and represents a historical record of its base table rows, providing a timeline of changes. This table is particularly useful for version control, allowing users to track changes over time to each specific row, identified by a unique combination of a start date and a row number. The start date indicates when the row data was extracted, and the end date signifies when a new version of the same row was updated. If the end date is null, it denotes that the data in the row is the most current.
The table holds geographical data, specifically pertaining to regions in Finland, as sourced from the Finnish Statistics Bureau, 'Tilastokeskus'. This geographic data includes attributes like polygonal and multipolygonal shapes, centroid points, and central x and y coordinates, which are represented using the WGS 84 coordinate reference system, with longitude preceding latitude. This information could be leveraged in geospatial analytics to visualize regional boundaries, calculate areas, or analyze spatial relationships.
Additionally, the table comprises multilingual names of these regions in Finnish and Swedish, along with a unique identifier for each region. It also provides information on the year of data collection.
In terms of data analytics, this table could be instrumental in many ways. For instance, by utilizing the version history, analysts can study how regional boundaries have evolved over time. The geographic data can be used to create detailed maps for visual representation, or to perform spatial analyses, such as identifying neighboring regions or calculating distances between centroids. The language-based columns can support multilingual data projects or sociolinguistic studies in Finland.
This table, with its rich historical and geographical information, is a valuable resource for a wide range of data analytics applications, particularly those focusing on temporal changes and geospatial relationships in Finnish regions.
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 a unique identifier in conjunction with the '_row_number' column. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
| _row_number | long | This column contains the number of the row as extracted from the raw data. It is part of the unique identifier in combination with the '_start_date' column. |
| geom_geojson | string | This column contains the geographical information represented in GeoJSON format. The values could be polygons or multipolygons, representing specific areas. |
| geom_geotext | string | This column contains the geographical information in text format. The text is a representation of the geometry of the areas. |
| geom_type | string | This column specifies the type of the geographical information. It could be either a polygon or a multipolygon. |
| geom_centroid | string | This column contains the geographical point that represents the center of the geometrical shape. It is represented in POINT format. |
| geom_center_x | double | This column contains the X-coordinate of the center point of the geometrical shape. |
| geom_center_y | double | This column contains the Y-coordinate of the center point of the geometrical shape. |
| gml_id | string | This column contains the unique identifier of the row. The identifier is a string value. |
| name | string | This column contains the names of the areas. |
| namn | string | This column contains the names of the areas in a different language. |
| nimi | string | This column contains the names of the areas in another language. |
| seutukunta | string | This column contains string values. The specific meaning of these values is not provided by the data source. |
| vuosi | long | This column contains integer values representing years. The specific context of these years is not provided by the data source. |
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 | 95362fa2-85c8-4fd0-89cd-ea092f6650f7 |
| Package id | 4684f1cd-97fd-4900-a474-6ce24114812a |
| Position | 1 |
| Revision id | 3b37cc23-9a49-4294-b67c-0671f6578836 |
| State | active |
| Table | tilastointialueet_seutukunta4500k_2020__table__history |