Version History of Major Regions 2019 (1:1 000 000)
The table, referred to as a 'history' table, is part of a larger dataset collection. This particular table primarily serves to keep track of the version history of its base table rows, providing a comprehensive record of each row's updates over time. The contents of the base table, translated into English, are 'Major Areas 2019 (1:1 000 000)'. This suggests that the data within the table corresponds to different geographical regions or 'major areas' for the year 2019, possibly at a scale of 1:1 million.
The table contains several columns, some of which are unique to this history table. These include '_start_date' and '_end_date', which represent the lifespan of each row, marking when the data was first extracted and when it was last updated or replaced. The '_row_number' is also unique to each row and, along with the '_start_date', serves to uniquely identify each row in this version history table. If the '_end_date' is null, this indicates that the row is the most current version.
The table also contains geographic information, starting with 'geom_'. This data, likely represented in the WGS 84 coordinate reference system, can be used for geospatial data analytics, providing the geographical coordinates (longitude first, then latitude) of each major area. This is further supplemented by columns providing the name of each area in different languages.
This data could be utilized in several ways in data analytics. For example, tracking the changes in geographic data over time could reveal shifting boundaries or changes in administrative regions. Additionally, the multilingual data could be used for international studies or to aid in translations. It is worth mentioning that this table is sourced from the 'Tilastokeskus' website in Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when a row was extracted from the data source, providing a timestamp for the version history of the row. |
| _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 enumerates the rows in the raw data. Combined with '_start_date', it uniquely identifies each row in the version history table. |
| geom_geojson | string | This column contains spatial data in the GeoJSON format, describing the geometric shape of the areas represented in each row. |
| geom_geotext | string | This column provides the geometric shape of the areas in text format. |
| geom_type | string | This column indicates the type of geometry used for the geographic data in the row. For example, 'ST_MULTIPOLYGON' indicates a shape formed by multiple polygons. |
| geom_centroid | string | This column contains the central point (centroid) of the geometric shape for each area. |
| geom_center_x | double | This column contains the X-coordinate of the central point of the geometric shape for each area. |
| geom_center_y | double | This column contains the Y-coordinate of the central point of the geometric shape for each area. |
| gml_id | string | This column contains a unique identifier for each row, typically following a specific naming convention. |
| name | string | This column contains the English name of the area represented in each row. |
| namn | string | This column contains the name of the area in another language, possibly Swedish, given the similarity to the English names. |
| nimi | string | This column contains the name of the area in another language, possibly Finnish, given the dataset's origin. |
| suuralue | string | This column contains a numerical identifier for each area. |
| vuosi | long | This column contains a year, possibly indicating the year the data for each row was collected or relevant for. |
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 | c753271a-ec85-4c5e-8988-25ca7b1c3e6f |
| Package id | ea34732d-13b4-4170-bc63-a0dd05783666 |
| Position | 1 |
| Revision id | 2cc5ae5e-89bd-416c-b1fc-e76bb274745c |
| State | active |
| Table | tilastointialueet_suuralue1000k_2019__table__history |