Version History of the Regions 2019 (1:4 500 000) Table
Click here for a data sample
The 'table__history' contains detailed historical data extracted from the Statistics Finland (Tilastokeskus) website. The table is part of a broader dataset collection focusing on the administrative regions of Finland in 2019 at a 1:4,500,000 scale. It serves as a historical record, preserving the version history of the base table rows. Every row in the table is uniquely identified by a combination of the '_start_date' and '_row_number' columns. These columns also provide insight into when a particular row was extracted from the source, and when a new version of the same row was extracted. Rows with a null '_end_date' are the most recent versions. The table also contains geographic information such as 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', which can be valuable for geospatial data analytics. The geographic coordinates use the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. Other columns such as 'name', 'namn', and 'nimi' provide the Finnish and Swedish names of the regions, while 'maakunta' and 'vuosi' give the region code and the year of the data respectively. This table can be utilized in various ways. For instance, it can be used for tracking changes in the administrative boundaries over time, for regional comparisons, or for correlating geospatial data with other relevant datasets, such as population or economic data.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | Date when the row was extracted from the data source, helping to track the changes over time. It forms a unique pair with '_row_number' to identify each row in this version history table. |
|---|
| _end_date | date | Date when a new version of the row was extracted from the data source. If this value is null, it indicates that the row is the most recent version. |
|---|
| _row_number | long | Number of the row in the raw data extracted from the data source. Paired with '_start_date', it uniquely identifies each row in this history table. |
|---|
| geom_geojson | string | Contains the geographical data in GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | Holds the geographical data in text format. It represents the same information as 'geom_geojson' but in a different format. |
|---|
| geom_type | string | Type of the geographic data structure. In this table, it refers to a specific type of geographical object - a multipolygon. |
|---|
| geom_centroid | string | Point representing the geometric center of the geographical object. Useful for analyzing the geographical distribution of the data. |
|---|
| geom_center_x | double | X-coordinate of the geometric center of the geographical object. It provides more detailed location data. |
|---|
| geom_center_y | double | Y-coordinate of the geometric center of the geographical object. It gives further precision to the location data. |
|---|
| gml_id | string | Unique identifier for each row in the table. |
|---|
| maakunta | string | Corresponds to a specific region in Finland. |
|---|
| name | string | English name of the region. |
|---|
| namn | string | Swedish name of the region. |
|---|
| nimi | string | Finnish name of the region. |
|---|
| vuosi | long | Year when the data was collected. |
|---|
