Version History of Regional Units 2016 (1:4 500 000)
Click here for a data sample
The 'table__history' is a history table that provides an extensive chronicle of its base table rows. Its content is derived from the 'Seutukunnat 2016' dataset, which translates to 'Regions 2016' in English. This dataset, originating from 'Tilastokeskus' (Statistics Finland), offers valuable insights into various aspects of different regions in Finland. The data is structured in a way that allows for a comprehensive understanding of changes over time, as it includes a version history of its base table rows. The table includes unique identifiers for each row, signifying the number of the row in the raw data, and the date the row was extracted, which together form a combination that uniquely identifies each row in this version history table. The table also contains a date column indicating when a new version of the row was extracted. When this column value is null, it signifies that the row is the most recent version. The table also encompasses various columns containing geographic information. This data is displayed using the WGS 84 coordinate reference system, with the order of longitude followed by latitude, enabling detailed geospatial data analytics. For instance, the data could be utilized to analyze regional changes over time, track the development of specific regions, or model spatial trends and patterns. Furthermore, the table includes columns containing the region's names in three languages and a column indicating the year of the data, which adds a temporal dimension to the data analysis. This comprehensive data structure facilitates a wide range of data analytics possibilities, from temporal trend analysis to geospatial data modeling.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when the row was extracted from the data source, indicating the start of the version history for that particular row. |
|---|
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source, indicating the end of the version history for that row. If the value is null, it means that the row is the most recent version. |
|---|
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table. |
|---|
| geom_geojson | string | This column contains the geographical data in GeoJSON format. It represents the geographical boundaries of the statistical area. |
|---|
| geom_geotext | string | This column also contains the geographical data, but in a text format. It represents the geographical boundaries of the statistical area. |
|---|
| geom_type | string | This column indicates the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. In this case, it is a multi-polygon. |
|---|
| geom_centroid | string | This column contains the geographical coordinates of the centroid of the statistical area. The centroid is the geometric center of a shape. |
|---|
| geom_center_x | double | This column contains the X coordinate of the centroid of the statistical area. |
|---|
| geom_center_y | double | This column contains the Y coordinate of the centroid of the statistical area. |
|---|
| gml_id | string | This column contains a unique identifier for each row in the table. It can be used to reference a specific row. |
|---|
| name | string | This column contains the name of the statistical area in English. |
|---|
| namn | string | This column contains the name of the statistical area in Swedish. |
|---|
| nimi | string | This column contains the name of the statistical area in Finnish. |
|---|
| seutukunta | string | This column contains a code that represents the statistical area. |
|---|
| vuosi | double | This column contains the year for which the statistical data is relevant. |
|---|
