Regional Units History (1:4 500 000) Version History
The 'table__history' is a historical record sourced from the Finnish website 'Tilastokeskus' (Statistics Finland). This table is part of the 'tilastointialueet_seutukunta4500k' dataset collection and provides valuable chronological data on regions (Seutukunnat) at a scale of 1:4,500,000.
The table records changes over time, tracking the version history of each row from its base table. The table's contents include geographical data, names of regions, and time-bound details. The geographic coordinates in the table are presented using the WGS 84 coordinate reference system, with the axis order of longitude first, followed by latitude, making it a useful resource for geospatial data analytics.
The table also comprises various columns containing the start date and row number, which together uniquely identify each row. The start date marks the day the row was extracted from the data source, while the end date indicates when a new version of the row was extracted. A null value in the end date column signifies that the row is the most recent version.
The columns with names starting with 'geom_' house geographic information. For instance, one might find data on the geographic type, such as polygons or multipolygons, as well as the coordinates for the centroid point of the geographic region.
Apart from the geographic details, the table also includes other columns that provide information about the regions, such as their names in different languages and unique identifiers.
The data from this table could be utilized in several ways. For instance, it could be used to analyze the geographic changes over time in various Finnish regions. It could also be used to develop a geospatial visual representation of these regions at different points in time. Furthermore, the historical data could be leveraged to study the evolution of these regions, making it an invaluable asset in historical and sociocultural research.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column represents the date when the row was extracted from the data source. It forms a combination with '_row_number' that uniquely identifies each row in this version history table. |
| _end_date | date | This column represents the date when a new version of the row was extracted from the data source. If the value of this column is null, it means that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. It forms a unique combination with '_start_date' to identify each row in this version history table. |
| geom_geojson | string | This column contains the geographical data in GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains the geographical data in text format. It provides a textual representation of the geographical data. |
| geom_type | string | This column identifies the type of the geographical data. It indicates whether the data is a MultiPolygon or a Polygon. |
| geom_centroid | string | This column contains the centroid of the geographical data. The centroid is the geometric center of a shape. |
| geom_center_x | double | This column represents the X-coordinate of the geometric center of a shape. |
| geom_center_y | double | This column represents the Y-coordinate of the geometric center of a shape. |
| gml_id | string | This column contains the unique identifier of the data row. |
| name | string | This column contains the English name of the area. |
| namn | string | This column contains the name of the area in the local language. |
| nimi | string | This column contains the name of the area in another local language. |
| seutukunta | string | This column contains a unique code representing a specific region in Finland. |
| vuosi | long | This column represents the year when the data was collected. |
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 | 6793c7eb-61f9-4ff5-a5e2-cd66b43534e5 |
| Package id | 14de74bf-ca9f-4e5d-bdb7-d2244cc7cf77 |
| Position | 1 |
| Revision id | d5c6f623-26de-42d6-8d29-f298619433e6 |
| State | active |
| Table | tilastointialueet_seutukunta4500k__table__history |