Version History of Large Areas 2021 (1:4 500 000)
The 'table__history' is an integral part of a larger collection of tables, specifically the 'tilastointialueet_suuralue4500k_2021'. It is a historical table signifying the version history of its base table rows. This is a rich and diverse table containing a wealth of information, including geographical data, that could prove beneficial in the field of geospatial data analytics.
The table's content primarily revolves around 'Major Areas 2021' at a scale of 1:4 500 000. It includes geographical identifiers, names in multiple languages, and the year of data collection. This information is meticulously organized into several columns, each containing specific types of data.
For instance, there are columns that contain the dates signifying when a row was added ('_start_date') and when it was modified ('_end_date'). If the '_end_date' column's value is null, it implies that the row is the most recent version. Another column, '_row_number', is used to uniquely identify each row in the table in combination with the '_start_date'.
Geographical data is present in a series of 'geom_' columns, which hold valuable information such as the geographical format, center coordinates, and centroid of each area. This data is presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
The table also includes the names of the major areas in various languages, giving it a universal appeal. The table is sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland.
The data in this table could be utilized in various ways. For instance, one could track the historical changes in the geographical boundaries of these major areas. In the field of data analytics, this data could help to understand the spatial distribution and evolution of different areas over time. Additionally, the multi-language column could be used to create a universal platform that caters to different linguistic groups, aiding in global research collaborations.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The _start_date column contains the date when the row was extracted from the data source. This, in combination with the _row_number, makes each row in the version history table uniquely identifiable. |
| _end_date | date | The _end_date column contains the date when a new version of the row was extracted from the data source. If this value is null, it signifies that the row is the most recent version. |
| _row_number | long | The _row_number column contains the number of the row in the raw data extracted from the source. It helps to uniquely identify each row in combination with the _start_date. |
| geom_geojson | string | The geom_geojson column contains geographical coordinates in GeoJSON format which represent the geometry of the area. |
| geom_geotext | string | The geom_geotext column holds the geographical data in text format. |
| geom_type | string | The geom_type column specifies the type of the geographical data. It is typically a type of shape, such as 'ST_MULTIPOLYGON', that indicates the data is a multipolygon shape. |
| geom_centroid | string | The geom_centroid column contains the geographical coordinates of the centroid or geometric center of the area. |
| geom_center_x | double | The geom_center_x column contains the x-coordinate (longitude) of the geometric center of the area. |
| geom_center_y | double | The geom_center_y column contains the y-coordinate (latitude) of the geometric center of the area. |
| gml_id | string | The gml_id column contains a unique identifier for each area. |
| name | string | The name column contains the English name of the area. |
| namn | string | The namn column contains the name of the area in Swedish. |
| nimi | string | The nimi column contains the name of the area in Finnish. |
| suuralue | string | The suuralue column contains a numerical identifier for each large area. |
| vuosi | long | The vuosi column contains the year to which the data pertains. |
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 | 657f5c70-a752-4874-a3c6-538538c5600c |
| Package id | ccdd3d49-7721-42e4-85e5-7a43943bb377 |
| Position | 1 |
| Revision id | b954c8ea-dc44-464b-a411-37fd3e4095e1 |
| State | active |
| Table | tilastointialueet_suuralue4500k_2021__table__history |