Version History of Regions 2024 (1:4 500 000)
The table 'table__history' is a rich compilation of version history data from its base table, interspersed with geospatial attributes. The base table presents data on provinces of Finland as projected for the year 2024. The data in the table is sourced from 'Tilastokeskus' (Statistics Finland), a Finnish government agency.
The table records include several key attributes such as the date of data extraction, the unique row number, and geospatial data. The date of data extraction is split into two columns, indicating the start and end date of each table row's life cycle. When a row ends with no designated end date, it signifies that the row represents the most recent version of the data.
The table also incorporates geographic information in columns beginning with 'geom_', where the geographic coordinates are presented using the WGS 84 coordinate reference system. This includes longitude followed by latitude. The geographic data available includes information such as geotext, type, centroid, and center coordinates.
For every row, there's a unique identifier composed of the start date and row number. This unique identifier can be used to track the evolution of each data row over time.
The data in this table can be used for a variety of data analytics applications. For example, the geospatial data can be utilized to create detailed maps of provinces and analyze trends over time. The version history can provide insights into the changes in the province data. Furthermore, the information about provinces in different languages can help in multi-lingual data analysis and research.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a combination with '_row_number' that uniquely identifies each row in the 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 means that the row is the most recent version of the row. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. It forms a unique pair with '_start_date' to identify each row in this version history table. |
| geom_geojson | string | This column contains geometry data in GeoJSON format. The values represent various types of geographical shapes such as polygons and multipolygons. |
| geom_geotext | string | This column contains textual representation of the geometry data in various formats such as polygons and multipolygons. |
| geom_type | string | This column indicates the type of the geometry object used to represent the geographical data. It could be either a polygon or a multipolygon. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid of the geometry object. The centroid is the geometric center of a shape. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometry object. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometry object. |
| gml_id | string | This column contains a unique identifier of the geometry object. |
| maakunta | string | This column holds the region code. The value corresponds to a specific region in Finland. |
| name | string | This column contains the English name of the region represented by the 'maakunta' code. |
| namn | string | This column holds the Swedish name of the region represented by the 'maakunta' code. |
| nimi | string | This column contains the Finnish name of the region represented by the 'maakunta' code. |
| vuosi | long | This column contains the year associated with the data row. It indicates the year of the data. |
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 | 21da9d09-147c-446a-a4ea-dfa26da9f19b |
| Package id | 09bcca84-8376-4b08-9ecd-1e56452c3b26 |
| Position | 1 |
| Revision id | d56111ef-7588-438e-8014-af4358091ad0 |
| State | active |
| Table | tilastointialueet_maakunta4500k_2024__table__history |