Historical Version Records of 'Regions 2015 (1:1 000 000)' Table
The 'table__history' is a valuable source of information, providing a historical record of its corresponding base table. This history table originates from the 'Tilastokeskus' (Statistics Finland) website and forms part of the 'tilastointialueet_maakunta1000k_2015' dataset collection. The table offers a rich combination of data, including unique identifiers, date details, geographical information, and more. This table specifically focuses on the regions of Finland as of 2015, as described in the base table contents.
Each row in this history table is uniquely identified by a combination of a start date and a row number. These dates denote when the row was extracted from the data source and when a new version was extracted, providing a timeline of changes. If the end date is null, this signifies the most recent version of the row.
A standout feature of this table is its geospatial data, provided in columns starting with 'geom_'. This data includes geographic information in various formats, along with coordinate details for the center of the geographic area. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The table also includes a rich set of regional data. This includes the region's identifier, its name in various languages, and specific geospatial figures. These figures are represented in the form of 'shape_star' and 'shape_stle', which could be utilized in geospatial analysis.
The integration of historical, geographical, and regional data makes this table a potent tool for data analytics. It could be used to track regional changes over time, analyze the relationship between different regions, or study geospatial trends. For example, an analyst could use this data to examine regional growth patterns, compare the development of different regions, or create detailed geographical visualizations.
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 the '_row_number' column to uniquely identify each row in the 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. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. It forms a unique combination with the '_start_date' column for each row in the history table. |
| geom_geojson | string | This column contains the geographical data of the region in GeoJSON format, a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains the geographical data of the region in text format. |
| geom_type | string | This column identifies the type of the geographical data. |
| geom_centroid | string | This column contains the central point of the geographical data. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geographical data. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geographical data. |
| gml_id | string | This column contains the unique identification code for the region. |
| maakunta | string | This column contains a unique identification code for the region. |
| name | string | This column contains the name of the region in the primary language. |
| namn | string | This column contains the name of the region in another language. |
| nimi | string | This column contains the name of the region in another language. |
| shape_star | double | This column contains a real number representing a specific geographical attribute of the region. |
| shape_stle | double | This column contains a real number representing a specific geographical attribute of the region. |
| vuosi | double | This column contains the year associated with the data 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 | 0a4fb849-cc4e-48d4-a28b-e722c67adaaf |
| Package id | b4adac43-570a-46d2-a9d5-04b0a7c97451 |
| Position | 1 |
| Revision id | 2154d5c9-7113-49c1-b1af-6e2d15192899 |
| State | active |
| Table | tilastointialueet_maakunta1000k_2015__table__history |