Provincial Boundaries 2017: Version History (1:4 500 000)
The 'table__history' is a rich historical data collection that captures the version history of its base table rows. The table is part of a larger dataset collection, specifically focused on providing comprehensive statistics for the Finnish regions. The primary content of the table is derived from the base table, which is titled 'Regions 2017 (1:4 500 000)'.
The table encompasses a variety of columns, each providing unique and insightful data. For instance, the table contains specific columns that record the date a row was extracted from the data source and the date a new version of the row was extracted. These columns, when combined with the column that contains the number of the row in the raw data, allow for each row in this version history table to be uniquely identified. If a row's end date is null, it signifies that the row is the most recent version.
In addition, the table consists of multiple columns that store geographic information. These columns can be used to conduct geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The table also includes columns that store region-specific information like the name of the region in different languages and the year. This information can be used to trace changes in regional data over time, offering valuable insights into temporal trends and patterns.
The table is sourced from 'Tilastokeskus' (Statistics Finland) website, a reputable source for comprehensive data regarding Finland.
This table's data can be employed in various ways for data analytics. For example, the geographic information can be utilized to analyze regional trends or anomalies in a geospatial context. Additionally, the version history of rows can be used to track changes in regional data over time, enabling predictive modeling and trend analysis. Furthermore, the multi-lingual region names can support research studies aimed at international audiences or comparative regional studies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column represents the date a row was extracted from the data source. Along with '_row_number', it forms a unique identifier for each row in the table. The date is recorded in the format 'YYYY-MM-DD'. |
| _end_date | date | This column records the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the current row is the most recent version. |
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the data source. It is part of the unique identifier for each row when combined with '_start_date'. |
| geom_geojson | string | This column contains geometric data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column includes geometric data in a text format. It typically represents complex geometric structures like polygons. |
| geom_type | string | This column describes the type of geometric data contained in the rows. For instance, 'ST_MULTIPOLYGON' indicates a collection of polygons. |
| geom_centroid | string | This column stores the geometric center of a shape in the format 'POINT (X Y)'. It represents the location of the centroid of a geographic feature. |
| geom_center_x | double | This column represents the 'x' coordinate (longitude) of the centroid of the geographic feature. |
| geom_center_y | double | This column represents the 'y' coordinate (latitude) of the centroid of the geographic feature. |
| gml_id | string | This is a unique identifier for each row, assigned by the data source. |
| maakunta | string | This column contains codes representing different regions in Finland. |
| name | string | This column contains the English names of the regions represented in the 'maakunta' column. |
| namn | string | This column contains the names of the regions in another language, possibly Swedish or Finnish. |
| nimi | string | This column contains the names of the regions in a different language, likely Finnish. |
| vuosi | double | This column records the year associated with the data. It is represented as a real number. |
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 | 05d7e10e-f274-41a4-a332-c394fc42a9d0 |
| Package id | 38aa1506-ae17-4e04-979e-542bae2c412a |
| Position | 1 |
| Revision id | 30ead553-27bf-491b-8e1d-0a95ca190c55 |
| State | active |
| Table | tilastointialueet_maakunta4500k_2017__table__history |