Provinces 2024 - Version History (1:1 000 000)
Click here for a data sample
The 'table__history' is a historical dataset that stores the version history of its base data rows. It is a part of the 'tilastointialueet_maakunta1000k_2024' dataset collection. This table is sourced from 'Tilastokeskus' (Statistics Finland) and contains a record of provinces as projected for the year 2024 at a 1:1,000,000 scale. It includes geographic information such as polygons and multipolygons, centroid points, and center coordinates. These geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. Such geospatial data can be utilized for analytics such as mapping, spatial distribution analysis, and trend analysis. The table also includes unique identifiers for each row, and start and end dates, which indicate the time range for each version of the row. The dataset could be used, for example, to analyze temporal changes in provincial boundaries, or to study patterns in the version history of the dataset. The table has two additional columns compared to its base table, '_start_date' and '_end_date', which record when a row was extracted from the source and when a new version was extracted, respectively. These columns, in combination with '_row_number', uniquely identify each row in the history table. If the '_end_date' is null, it indicates that the row is the most recent version.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when the row was first extracted from the data source. The date format is YYYY-MM-DD (e.g., 2024-11-11). |
|---|
| _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 denotes that the row is the most recent version. |
|---|
| _row_number | long | This column contains the number of the row as extracted from the raw data source. It helps in uniquely identifying each row in combination with the '_start_date' column. |
|---|
| geom_geojson | string | This column contains geographical data in the GeoJSON format, which represents simple geographical features with their non-spatial attributes. |
|---|
| geom_geotext | string | This column contains geographical data in the geotext format. It represents the geographical location of the area using coordinates. |
|---|
| geom_type | string | This column indicates the type of geographical data stored in the row, such as 'Polygon' or 'MultiPolygon'. |
|---|
| geom_centroid | string | This column contains the centroid or geometric center of the area represented in the row. |
|---|
| geom_center_x | double | This column contains the X-coordinate of the center of the geographical area represented in the row. |
|---|
| geom_center_y | double | This column contains the Y-coordinate of the center of the geographical area represented in the row. |
|---|
| gml_id | string | This column contains the unique ID for each row, typically following a specific naming convention (e.g., 'maakunta1000k_2024.9'). |
|---|
| maakunta | string | This column contains a code representing the region or 'maakunta' in Finnish. |
|---|
| name | string | This column contains the name of the region in English (e.g., 'South Savo'). |
|---|
| namn | string | This column contains the name of the region in Swedish (e.g., 'Södra Savolax'). |
|---|
| nimi | string | This column contains the name of the region in Finnish (e.g., 'Etelä-Savo'). |
|---|
| vuosi | long | This column contains the year related to the data in each row (e.g., 2024). |
|---|
