Historical Version Records of Regions (1:1 000 000)
The 'table__history' is a significant part of a larger dataset collection, storing valuable information on regional units (Seutukunnat) at a scale of 1:1,000,000. This information is sourced from the Finnish statistical agency, 'Tilastokeskus' (Statistics Finland).
The table serves as a historical record, storing version history of its base table rows. This historical data is useful in tracking changes over time and understanding trends. For instance, it could be instrumental in analyzing changes in regional boundaries or populations, among other things.
The table contains a set of columns with diverse types of information. These include unique identifiers for each row, geographic data, and other details about the regional units. Importantly, the table uniquely identifies each row with a combination of the date when the row was extracted from the source ('_start_date') and the row number in the raw data ('_row_number'). The table also tracks the date when a new version of the row was extracted ('_end_date'). If the end date is null, it indicates that the row is the most current version.
Geographical data is a major component of this table, stored in multiple columns. These columns contain geographic information in different formats, such as GeoJSON and GeoText, making it possible to shape a variety of geospatial analytics. They contain data about the type of geographic shape, the central point of the shape, and the coordinates of the center. These geographic coordinates are based on the WGS 84 coordinate reference system, with longitude listed first, followed by latitude.
The table also has columns with details about the regional units, including their names in different languages and identifiers. This can be used for multilingual studies or analyses focusing on specific regions.
In terms of data analytics, the table provides a wealth of opportunities. For instance, the geographical data can be used to create detailed maps or perform spatial analyses. The historical data allows for tracking changes over time, such as shifts in regional boundaries or names. The multilingual data can be used in cross-language studies or to provide localizations for various applications.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | Indicates the date when the row was extracted from the data source. This column, along with '_row_number', uniquely identifies each row in this version history table. |
| _end_date | date | Contains the date when a new version of the row was extracted from the data source. A null value indicates that the row is the most recent version. |
| _row_number | long | Represents the number of the row in the raw data extracted from the data source. This column, in conjunction with '_start_date', uniquely identifies each row in this version history table. |
| geom_geojson | string | Stores the geometric data of the regions in GeoJSON format. |
| geom_geotext | string | Contains the geometric data of the regions in textual format. |
| geom_type | string | Specifies the type of the geometric data, which can be either 'ST_MULTIPOLYGON' or 'ST_POLYGON'. |
| geom_centroid | string | Indicates the centroid of the geometric data. |
| geom_center_x | double | Represents the x-coordinate of the center of the geometric data. |
| geom_center_y | double | Indicates the y-coordinate of the center of the geometric data. |
| gml_id | string | A unique identifier for each row, provided by the source. |
| name | string | The English name of the region. |
| namn | string | The name of the region in Swedish. |
| nimi | string | The name of the region in Finnish. |
| seutukunta | string | A unique code assigned to each region. |
| vuosi | long | 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 | 3cd70def-c99d-43aa-8c3e-2c6f3bf99a97 |
| Package id | df82fc7a-ab24-48d0-ab22-437044422a04 |
| Position | 1 |
| Revision id | 4b6dcfec-ab6d-40f0-acac-e7271b384006 |
| State | active |
| Table | tilastointialueet_seutukunta1000k__table__history |