Version History of 'Counties at 1:4 500 000 Scale' Table
The 'table__history' is a comprehensive historical record of geographical information derived from the dataset collection 'tilastointialueet_maakunta4500k'. This table maintains the version history of its base table rows, capturing alterations and updates over time. It includes the base table contents of 'Maakunnat' which can be translated to 'Regions' in English, offering a detailed geographical representation at a scale of 1:4 500 000.
The table contains multiple columns capturing varied data points. The '_start_date' and '_row_number' columns together uniquely identify each row in this version history table. The '_start_date' records the date a row was extracted from the original data source, while the '_end_date' denotes the date when a new version of the row was extracted. If the '_end_date' is null, it signals that the row is the most recent version.
Geographical information is stored in columns beginning with 'geom_', valuable for geospatial data analytics. They contain data in formats such as geojson and geotext, types of geographical features, centroid points, and center coordinates. These geographic coordinates are presented using the WGS 84 coordinate reference system, where the axis order is longitude first, followed by latitude.
The table also includes columns for Region IDs and names in multiple languages, useful for multilingual analyses. The 'vuosi' column contains the year of data extraction, giving a temporal dimension to the data.
This rich and detailed data could be utilized in various analytic scenarios. For instance, one could track geographical changes over time, allowing for trend analyses and predictive modeling in environmental studies. It could also support multilingual demographic studies or provide critical inputs for regional planning and development projects.
The 'table__history' is sourced from the 'Tilastokeskus' website in Finland. This ensures a reliable and authoritative source for the data, contributing to the robustness of any analysis performed on it.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column holds the date when a record was extracted from the data source. It forms a unique identifier in combination with the '_row_number' column for each row in this version history table. |
| _end_date | date | This column contains the date when a new version of a record was extracted from the data source. If the value of this column is null, it indicates that the record is the most recent version. |
| _row_number | long | This column contains the number of the row as in the raw data extracted from the source. It forms a unique identifier in combination with the '_start_date' column for each row in this version history table. |
| geom_geojson | string | This column contains geographical data in the GeoJSON format. It can represent a variety of geographical features, such as polygons and multipolygons. |
| geom_geotext | string | This column contains geographical data in a text-based format. Like the 'geom_geojson' column, it can represent a variety of geographical features. |
| geom_type | string | This column indicates the type of geographical feature represented in the 'geom_geojson' and 'geom_geotext' columns. Values can include 'ST_MULTIPOLYGON' and 'ST_POLYGON'. |
| geom_centroid | string | This column contains the geographical point that represents the centroid of the geographical feature. |
| geom_center_x | double | This column contains the X-coordinate of the center of the geographical feature. |
| geom_center_y | double | This column contains the Y-coordinate of the center of the geographical feature. |
| gml_id | string | This column contains a unique identifier for each geographical feature that is represented in the table. |
| maakunta | string | This column contains the code for the region that the geographical feature represents. |
| name | string | This column contains the English name of the region that the geographical feature represents. |
| namn | string | This column contains the name of the region in a language other than English and Finnish (likely Swedish, given the region). |
| nimi | string | This column contains the Finnish name of the region that the geographical feature represents. |
| vuosi | long | This column contains the year associated with the record. Given the nature of the table, this likely represents the year the data was collected or relevant to. |
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 | 2895eeed-5c5a-4416-aaa2-4120e728bb6f |
| Package id | fda345da-7b70-4084-bee7-af589948e158 |
| Position | 1 |
| Revision id | e6cd3b28-3df4-4269-bbd1-89ad4f568039 |
| State | active |
| Table | tilastointialueet_maakunta4500k__table__history |