Version History of Major Areas 2015 (1:4 500 000) Table
The table, named as 'table__history', is a historical data collection that tracks the changes in the rows of its base table over time. It is a part of the dataset identified as 'tilastointialueet_suuralue4500k_2015'. This table primarily focuses on the version history of the base table, which represents 'Suuralueet 2015' or 'Large Areas 2015', at a scale of 1:4,500,000.
The table provides a structured and systematic record of each row's lifecycle from the raw data extracted from the source. Each row in the table is uniquely identified by a combination of the date when the row was extracted, and the row number. To track the version history of each row, two additional columns namely, the start date and end date of the row version, are included in this table. Therefore, if the end date is null, it signifies that the row is the most recent version.
Geospatial data is a significant part of this table, with several columns providing geographical information. This includes the type of geometry, geotext, geojson, and the centroid, which can be utilized for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
This table also provides region names in different languages and shape attributes for these regions. These could be used for multilingual data analytics or geographical shape analysis. The data about the large areas in Finland in 2015, which this table represents, could be used for various analytics purposes, such as historical trends in geospatial data, regional classification, or multilingual analysis.
This table is sourced from the website of 'Tilastokeskus' (Statistics Finland) located in Finland. It is a rich source for historical and geospatial data analytics for the country.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a combination with the '_row_number' column that 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 for this column is null, it indicates that the row is the most recent version. |
| _row_number | long | This column contains the row number from the raw data extracted from the data source. It forms a unique identifier for each row when combined with the '_start_date' column. |
| geom_geojson | string | This column contains geo-spatial data in the format of GeoJSON, which is used to represent simple geographical features. |
| geom_geotext | string | This column contains geo-spatial data in text format. It's used to represent complex geographical features such as a collection of polygons. |
| geom_type | string | This column specifies the type of geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column contains the centroid coordinates of the geographical feature represented in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geographical feature represented in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geographical feature represented in the 'geom_geojson' and 'geom_geotext' columns. |
| gml_id | string | This column contains unique identifiers for the rows. |
| name | string | This column contains the names of the geographical areas in English. |
| namn | string | This column contains the names of the geographical areas in Swedish. |
| nimi | string | This column contains the names of the geographical areas in Finnish. |
| shape_star | double | This column contains the area size of the geographical features represented in the 'geom_geojson' and 'geom_geotext' columns. |
| shape_stle | double | This column contains the perimeter length of the geographical features represented in the 'geom_geojson' and 'geom_geotext' columns. |
| suuralue | string | This column contains identifiers for the large areas that the geographical features belong to. |
| vuosi | double | This column contains the year the data was recorded. |
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 | 0596511d-7b4a-408e-8cc9-c49954db4f78 |
| Package id | 8f0a1630-d412-446f-b9ef-851590c8d945 |
| Position | 1 |
| Revision id | 5f3de1d1-6e1c-4b09-9da5-a64f770ddcac |
| State | active |
| Table | tilastointialueet_suuralue4500k_2015__table__history |