Historical Version Records for 'Regional Units 2016 (1:1 000 000)'
The 'table__history' is a part of a larger dataset collection that houses related data tables. This particular table is a history table, storing the version history of the base table rows, adding a unique aspect to its structure. The table is distinguished by two additional columns: '_start_date' and '_end_date', which respectively indicate the date of row extraction from the data source and the date when a new version of the row was extracted. If the '_end_date' value is null, this signifies that the row is the most recent version.
The table's contents are representative of the 'Seutukunnat 2016 (1:1 000 000)' base table, which could be loosely translated to 'Regions 2016 (1:1 000 000)'. Each row in the table is uniquely identified by a combination of the '_start_date' and '_row_number' columns. The '_row_number' column specifically notes the number of the row in the raw data extracted from the data source.
An interesting feature of this table is the presence of columns prefixed with 'geom_', which contain geographic information that can be utilized for geospatial data analytics. These geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude (geom_center_x) first, followed by latitude (geom_center_y).
The table encapsulates a wide range of data, including region names in different languages ('name', 'namn', 'nimi'), region codes ('seutukunta'), and year data ('vuosi'). The table also includes a 'gml_id' column, which provides a unique identifier for each row.
The table's contents are sourced from the 'Tilastokeskus' website from Finland.
Potential applications of the data in this table could include analyzing region-specific trends over time, conducting geospatial analytics to identify patterns or anomalies, or even comparing and contrasting data from different versions of the same row. The table's rich historical data and geographic information can provide a strong foundation for robust data analysis.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was initially extracted from the data source. |
| _end_date | date | This column holds 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. |
| _row_number | long | This column contains the number of the row in the raw data as extracted from the source. Together with '_start_date', it uniquely identifies each row in this version history table. |
| geom_geojson | string | This column contains geometric data in GeoJSON format, typically used to represent spatial data. |
| geom_geotext | string | This column contains geometric data in text format, typically used to represent spatial data. |
| geom_type | string | This column specifies the type of the geometric data, in this case, multi-polygon. |
| geom_centroid | string | This column describes the geometric center or centroid of the spatial data. |
| geom_center_x | double | This column contains the x-coordinate of the geometric center of the spatial data. |
| geom_center_y | double | This column contains the y-coordinate of the geometric center of the spatial data. |
| gml_id | string | This string type column contains unique identifiers for each row. |
| name | string | This column contains the English names of regions. |
| namn | string | This column contains the names of regions in Swedish. |
| nimi | string | This column contains the names of regions in Finnish. |
| seutukunta | string | This string type column contains codes representing different regions. |
| vuosi | double | This real type column indicates the year associated with the data entry. |
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 | 9885d7ca-3933-4e08-a9a1-9a8865cbbf6a |
| Package id | bfc3699b-0c38-4a04-bef6-1d3b7991113b |
| Position | 1 |
| Revision id | 5eb1fbd2-27ef-423b-b50a-92f59bb00cce |
| State | active |
| Table | tilastointialueet_seutukunta1000k_2016__table__history |