Version History of Postal Area Codes 2019
The table in focus, titled 'table__history', is a historical data table derived from the dataset collection 'postialue_pno_2019'. As a history table, it is designed to store the version history of its base table rows, meaning it tracks changes made over time to the data in its corresponding base table. This table is a valuable resource for examining the evolution of the postal areas in Finland, as it is sourced from the Finnish Statistical Office, 'Tilastokeskus'.
Interestingly, this table is equipped with a unique set of columns that hold a variety of data. For instance, it contains columns that track when each row was extracted from the data source and when a new version of the row was extracted. This is particularly useful for maintaining data integrity and tracking changes over time. If the end date is null, it indicates that the row is the most recent version, providing a quick way to identify the latest data.
Additionally, the table includes several columns starting with 'geom_', which contain geographic information. This data, presented using the WGS 84 coordinate reference system with the axis order being longitude first, followed by latitude, is a powerful tool for geospatial data analytics. For instance, these columns can be used to map the postal areas or analyze spatial patterns and trends.
The table also contains columns that hold information about the postal areas, such as their names in different languages, their area in square meters, and their year of establishment. This rich set of data provides a multifaceted view of each postal area.
In terms of data analytics, this table can be used in a variety of ways. For example, the historical data can be used to track changes in the size or name of postal areas over time, providing insights into urban development patterns. The geospatial data can be used to visualize these changes on a map, making the data more accessible and easier to understand. Furthermore, the table could be used as a base for predictive analytics, to forecast future trends based on historical data.
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 unique identifier for 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. Combined with '_start_date', it creates a unique identifier for each row in the history table. |
| geom_geojson | string | This column contains geometric data in GeoJSON format. It represents the spatial features of the row. |
| geom_geotext | string | This column contains geometric data in text format. It is another representation of the spatial features of the row. |
| geom_type | string | This column specifies the type of geometric data contained in the row, such as 'ST_MULTIPOLYGON'. |
| geom_centroid | string | This column contains the central point of the geometric data represented as a point. |
| geom_center_x | double | This column contains the X-coordinate of the central point of the geometric data. |
| geom_center_y | double | This column contains the Y-coordinate of the central point of the geometric data. |
| gml_id | string | This column contains the Global Markup Language (GML) ID, a unique identifier for each row. |
| kunta | string | This column contains the municipality code. |
| kuntanro | long | This column contains the municipality number. |
| namn | string | This column contains the name of the municipality in Swedish. |
| nimi | string | This column contains the name of the municipality in Finnish. |
| objectid | long | This column contains a unique identifier for each row. |
| pinta_ala | double | This column contains the area of the municipality in square meters. |
| posti_alue | string | This column contains the postal area code for the municipality. |
| shape_leng | double | This column contains the length of the shape boundary of the municipality. |
| vuosi | long | This column contains 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 | c7a23b32-1f3b-4fce-a289-a97177715ca6 |
| Package id | 31f4c8eb-aed9-4eef-a4fe-d1aaa249b7a7 |
| Position | 1 |
| Revision id | 1f5e47f5-858c-42e7-ac11-2ea718dece0f |
| State | active |
| Table | postialue_pno_2019__table__history |