Version History of Large Areas 2017 (Scale 1:4 500 000)
Click here for a data sample
The 'table__history' is a history table that forms part of the larger dataset collection. It contains a variety of information related to the 'Greater Regions 2017' (Suuralueet 2017) at a scale of 1:4,500,000, sourced from the 'Statistics Finland' (Tilastokeskus) website based in Finland. The table includes a unique combination of 'start_date' and '_row_number' that identifies each row in this version history table. The '_start_date' signifies the date when the row was extracted from the source, while the '_end_date' marks the date when a new version of the row was extracted. If '_end_date' is null, it indicates that the row is the most recent version. The table also features columns starting with 'geom' that contain geographic information, ideal for geospatial data analytics. These geographic coordinates follow the WGS 84 coordinate reference system, with an axis order of longitude first, then latitude. The table can be utilized in various data analytics applications. For example, it can be used to study the changes in the geographic boundaries over time, or it could be employed to analyze the spatial distribution of different variables across the regions. Moreover, the version history contained in the table could be used to track data changes over time, providing valuable insights into trends and patterns.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column marks the date when the row was extracted from the data source. It forms a unique combination with the '_row_number' to identify 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 is null, it indicates 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. It forms a unique combination with the '_start_date' to identify each row. |
|---|
| geom_geojson | string | This column contains the geographic data in GeoJSON format. It represents the geographic shape of the statistical area. |
|---|
| geom_geotext | string | This column contains the geographic data in Geotext format. It is another representation of the geographic shape of the statistical area. |
|---|
| geom_type | string | This column specifies the type of the geographic shape represented in 'geom_geojson' and 'geom_geotext' columns. The type is 'ST_MULTIPOLYGON' indicating a shape with multiple polygonal areas. |
|---|
| geom_centroid | string | This column contains the point coordinates that represent the centroid of the geographic shape of the statistical area. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the centroid of the geographic shape of the statistical area. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the centroid of the geographic shape of the statistical area. |
|---|
| gml_id | string | This column contains a unique identifier for each row in the table. |
|---|
| name | string | This column contains the English name of the statistical area. |
|---|
| namn | string | This column contains the Swedish name of the statistical area. |
|---|
| nimi | string | This column contains the Finnish name of the statistical area. |
|---|
| suuralue | string | This column contains a numerical identifier for the statistical area. |
|---|
| vuosi | double | This column contains the year of the data record. |
|---|
