Version History of Major Regions 2018 (1:1 000 000)
The 'table__history' is a critical component of a comprehensive dataset collection, focusing on the version history of its base table rows. It is a history table that contains chronological data changes for each row, allowing users to track and analyze changes over time. This table is sourced from the 'Tilastokeskus' website, located in Finland. The table provides a rich source of information for various data analytics purposes, particularly for research and analysis related to the 'Large Areas 2018 (1:1 000 000)' theme.
The table has various columns that hold specific information. For example, it has columns that store geographical data, such as the 'geom_' columns, which are useful for geospatial data analytics. This geographic information is presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. For instance, a data analyst could use this to track geographical changes over time or analyze spatial patterns and trends.
Other columns in the table provide unique identifiers for each row, including '_start_date' and '_row_number'. The '_start_date' column holds the date when the row was extracted from the data source, while the '_end_date' indicates when a new version of the row was extracted. If the '_end_date' value is null, it signifies that the row is the most recent version. This feature makes the table crucial for historical data analysis, as it allows tracking of changes from the moment of extraction to the latest version.
In addition to these, the table also provides a variety of data in other columns like 'name', 'namn', 'nimi', 'suuralue', and 'vuosi', offering comprehensive insights into the Large Areas 2018 theme. For example, data analysts could use the 'vuosi' column to analyze trends over the years or use the 'name' and 'nimi' columns to differentiate and compare different areas.
To sum up, the 'table__history' is an essential part of the dataset collection, offering valuable historical and geospatial data for comprehensive analytics. Its usage is versatile, from tracking changes over time to analyzing spatial patterns and trends, making it indispensable for data-driven decision making.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source, marking the start of the row's existence in the 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 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 the table. |
| geom_geojson | string | This column contains the geometry data of the row in GeoJSON format, a popular format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains the geometry data of the row in text format. |
| geom_type | string | This column specifies the type of the geometry data stored in the row, for example 'ST_MULTIPOLYGON'. |
| geom_centroid | string | This column contains the centroid (geometric center) of the geometry data in the row. |
| geom_center_x | double | This column contains the x-coordinate of the geometric center of the data. |
| geom_center_y | double | This column contains the y-coordinate of the geometric center of the data. |
| gml_id | string | This column contains a unique identifier for each row, provided by the data source. |
| name | string | This column contains a name associated with the row. The language of the name depends on the originating source. |
| namn | string | This column contains a translated name associated with the row. The language of the name depends on the originating source. |
| nimi | string | This column contains another translated name associated with the row. The language of the name depends on the originating source. |
| suuralue | string | This column contains a string that represents a specific area or zone related to the row. |
| vuosi | long | This column contains an integer that represents a specific year associated with the 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 | 30e95d11-56b9-4e6d-858b-c2680245a305 |
| Package id | e3100c5c-13aa-426b-b60b-92ef9005de70 |
| Position | 1 |
| Revision id | 97ac6a11-c1cd-47ea-81be-0ed275562a7d |
| State | active |
| Table | tilastointialueet_suuralue1000k_2018__table__history |