Historical Version Records of Large Areas 2017 (1:1 000 000)
The 'table__history' is a comprehensive data collection that serves as a historical record of its base table, which is a part of the 'tilastointialueet_suuralue1000k_2017' dataset. This history table captures the evolution of information over time, specifically tracking changes in the base table's rows. Each row in this history table is uniquely identified by a combination of the extraction start date and the row number from the raw data source.
The table contains a wealth of information, including geographical data, names in different languages, and time-stamp data. The geographical data is particularly rich, including data types such as MultiPolygon and Point, stored in various columns. This geospatial information is represented using the WGS 84 coordinate reference system, which orders the coordinates as longitude first, followed by latitude. This makes the data highly valuable for geospatial data analytics, such as mapping or studying spatial patterns and relationships.
The table also stores the names of different regions in three languages, which can be useful for multilingual studies or localization purposes. In addition, each row contains a time-stamp indicating the year, which could be useful for temporal analysis or tracing regional changes over time.
The table also includes the start and end dates of each row's extraction from the data source. This provides valuable insights into the timeline of the data, depicting when a row was first extracted and when a new version of the same row was subsequently extracted. If the end date of a row is null, it indicates that the row is the most recent version.
This data, sourced from the 'Tilastokeskus' website in Finland, could be utilized in various ways. For example, analysts could track changes in geographic boundaries over time, study regional name changes in different languages, or examine temporal trends in the data. This makes the table a valuable resource for researchers, data scientists, and analysts interested in historical and geographical studies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It is part of a combination that uniquely identifies each row in this 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 source. It is part of a combination with '_start_date' that uniquely identifies each version in the history. |
| geom_geojson | string | This column contains geometric data in the GeoJSON format, which represents the physical location related to the data row. |
| geom_geotext | string | This column contains geometric data in text format, which represents the physical location related to the data row. |
| geom_type | string | This column specifies the type of geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column contains the centroid point of the geometric shape, which is the average position of all the points in the shape. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometric shape. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometric shape. |
| gml_id | string | This column contains a unique identifier for the row. |
| name | string | This column contains the English name of the geographic area related to the data row. |
| namn | string | This column contains the Swedish name of the geographic area related to the data row. |
| nimi | string | This column contains the Finnish name of the geographic area related to the data row. |
| suuralue | string | This column contains a numerical identifier for the large area (in Finnish 'suuralue') related to the data row. |
| vuosi | double | This column contains the year related to 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 | 54494cfb-d7d5-4534-835f-a8d22a81a1e2 |
| Package id | 72a97bad-3065-42ff-9538-c29043c4913d |
| Position | 1 |
| Revision id | afbff48c-7775-4474-8f47-78dfc82599d3 |
| State | active |
| Table | tilastointialueet_suuralue1000k_2017__table__history |