Historical Version Records of Regional Units 2013 (1:1 000 000)
The 'table__history' is a comprehensive chronicle of related data preserved in a structured format. This history table is sourced from 'Tilastokeskus' (Statistic Finland) and primarily focuses on the version history of its base table rows. It is an integral part of the dataset collection 'tilastointialueet_seutukunta1000k_2013' which provides a broad overview of regional units in Finland in 2013 at a scale of 1:1 000 000. In addition to the base table contents, this table has two unique columns that determine its temporal dynamism: the commencement date of data extraction and the date when a new version of the row was introduced. If the end date is not specified, it signifies that the row is the most recent version.
The table comprises of several geographic information columns, which are instrumental for geospatial data analytics. The geographic coordinates are represented using the WGS 84 coordinate reference system, with the longitude preceding the latitude. This allows for accurate mapping and spatial analysis of the data.
The table includes columns that contain unique identifiers, geographic information in various formats, and the name of the regional unit in different languages. It also includes a column that holds the year of the data.
The data in this table could be utilized in various ways in data analytics. For instance, the temporal element of the data could be used to track changes in the geographic boundaries of the regional units over time. The geographic information could be used to create detailed maps of the regional units, and the name and year information could be used to provide context to these maps. Moreover, the changes in the regional units could be correlated with other data sets to analyze the impact of these changes on various socio-economic factors.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. This value, combined with '_row_number', uniquely identifies each row in this 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 is null, it indicates 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, which when used in conjunction with '_start_date' uniquely identifies each row in the version history table. |
| geom_geojson | string | This column stores the geometric data of the region in GeoJSON format. |
| geom_geotext | string | This column stores the geometric data of the region in a text format. |
| geom_type | string | This column indicates the type of the geometric data stored. |
| geom_centroid | string | This column contains the centroid point of the geometric shape representing the region. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometric shape representing the region. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometric shape representing the region. |
| gml_id | string | This column holds the unique ID of the region as provided by the 'Tilastokeskus' (Statistics Finland) data source. |
| name | string | This column contains the name of the region in English. |
| namn | string | This column contains the name of the region in the original language from the data source. |
| nimi | string | This column also contains the name of the region in another language. |
| seutukunta | string | This column contains a specific code associated with the region, as provided by the data source. |
| vuosi | long | This column contains the year associated with the data 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 | 7e13dc81-5c6a-42a5-844b-17f12a876f95 |
| Package id | 30d5c858-98f8-43cf-93a9-b17290d3cb64 |
| Position | 1 |
| Revision id | 787ff12e-e8f7-4d8c-81f4-e828e06a940e |
| State | active |
| Table | tilastointialueet_seutukunta1000k_2013__table__history |