Historical Variations of Finnish Regional Divisions (2014)
The 'table__history' is a comprehensive history table that contains detailed version history information for each row of its base table. This data is sourced from the 'Tilastokeskus' website, based in Finland. The table is part of a dataset collection that examines regional statistical areas in Finland, providing historical data from the year 2014.
Each row in the table is uniquely identified by a combination of the row number and the start date. The row number refers to the position of the row in the raw data, while the start date indicates when the row was initially extracted from the data source. To track changes, the table includes an end date column, which records when a new version of the row was extracted. If the end date is null, this signifies that the current row is the most recent version.
One of the most significant features of this table is its ability to store geospatial data. Columns with the 'geom_' prefix contain various forms of geographic information that can be used for geospatial data analytics. For instance, the geographic coordinates are represented in the WGS 84 coordinate reference system, with the longitude presented first, followed by the latitude.
The table also provides detailed information about regional divisions in Finland. It includes the Finnish names of the regions, their corresponding identification codes, and their geographic coordinates. This data can be used to analyze the geographical distribution and changes of these regions over time.
In terms of data analytics, this table can be utilized in multiple ways. For example, the table could be used to study trends in regional development, as it provides a historical view of the data. The geographic information could also be used to create detailed maps of the regions, or to conduct spatial analyses to identify patterns or anomalies. Furthermore, the version history information can assist in tracking changes, providing a deeper understanding of regional dynamics over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source, marking the beginning of the version's validity period. It forms a unique identifier in combination with the '_row_number'. |
| _end_date | date | It records the date when a new version of the row was extracted from the data source, indicating the end of the version's validity. If the value is null, it signifies 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 identifier in combination with the '_start_date'. |
| geom_geojson | string | This column stores the geometric data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains the geometric data in text format, which provides a human-readable representation of the geographic data. |
| geom_type | string | It specifies the type of the geometric object that the row represents. The sample values suggest that the geometric objects are of type 'ST_MULTIPOLYGON'. |
| geom_centroid | string | This column contains the central point (centroid) of the geometric object. It is a point that defines a geometric object's center of gravity. |
| geom_center_x | double | This column contains the X coordinate of the central point of the geometric object. |
| geom_center_y | double | It contains the Y coordinate of the central point of the geometric object. |
| gml_id | string | This column contains a string identifier for the row as provided by the source. |
| name | string | This column contains the name of the region as provided by the source. |
| namn | string | This column contains an alternate name for the region in another language. |
| nimi | string | This column contains another alternate name for the region in yet another language. |
| seutukunta | string | This column contains a string identifier for the region as provided by the source. |
| vuosi | long | This column contains the year associated with the data in the row. |
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 | 733e3c81-9317-4899-bab0-ab2a4076c0f2 |
| Package id | f3645557-7095-433a-95e6-bf146e3e794f |
| Position | 1 |
| Revision id | 316f9e56-bf0d-4ee1-a820-65b64dc362fb |
| State | active |
| Table | tilastointialueet_seutukunta1000k_2014__table__history |