Version History of Postal Code Areas 2024
The 'table__history' is a part of the 'postialue_pno_2024' dataset collection. It serves as a history table, providing a version history of its base table rows. The table is sourced from 'Tilastokeskus' (Statistics Finland) and focuses on Paavo postal code areas projected for the year 2024.
The table encompasses various columns providing diverse types of data. One set of columns hold geographic information, indispensable for geospatial data analytics. These columns contain data such as geojson and geotext values, the geometry type, centroid coordinates, and the X and Y center coordinates. It's worth noting that the geographic coordinates are presented using the WGS 84 coordinate reference system, with the longitude listed first, followed by the latitude.
Beyond geospatial data, the table also includes columns housing postal area data, the respective municipality codes and names, the object ID, and the area size. These columns could be used in demographic or regional studies, enabling researchers to analyze population distribution, urban planning strategies, or postal service needs.
A unique aspect of this table is its two additional columns compared to its base table: '_start_date' and '_end_date'. The '_start_date' column signifies the date a row was extracted from the data source, while the '_end_date' marks the date when a new version of the row was extracted. If the '_end_date' value is null, it indicates that the row is the most recent version. Along with the '_row_number', which denotes the row's number in the raw data, these columns form a combination that distinctly identifies each row in this version history table.
In terms of data analytics, the data in this table can be utilized in numerous ways. For instance, the geographical data could be used to visualize the spatial distribution of postal areas, or to analyze the spatial changes over time, thanks to the version history. The postal area and municipality data could aid in studying trends in population migration or urban development over time. Moreover, the start and end dates of the data extraction can be used to trace the evolution of these trends.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. |
| _end_date | date | The date when a new version of the row was extracted from the data source. Null value indicates the row is the most recent version. |
| _row_number | long | A unique identifier for each row in the version history table, which is formed by combining this with the '_start_date'. |
| geom_geojson | string | Representing the geographic features of the postal area in GeoJSON format. |
| geom_geotext | string | Text representation of the geographic features of the postal area. |
| geom_type | string | Type of the geographic feature, for instance, polygon for areas. |
| geom_centroid | string | The central point of the geometric feature. |
| geom_center_x | double | The X-coordinate of the geometric feature's center point. |
| geom_center_y | double | The Y-coordinate of the geometric feature's center point. |
| gml_id | string | An identifier provided by the source. |
| kunta | string | Municipality code. |
| kuntanro | long | Municipality number. |
| namn | string | The name of the postal area in Swedish. |
| nimi | string | The name of the postal area in Finnish. |
| objectid | long | An integral identifier of the object. |
| pinta_ala | long | The area size of the postal area. |
| posti_alue | string | Postal area code. |
| vuosi | long | The year the data is derived from. |
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 | a36babac-e2ab-4d0c-bfac-1ec2f68a41f5 |
| Package id | 3a769d3f-2e0b-4590-8f6a-e610ebb0c4f2 |
| Position | 1 |
| Revision id | 63b9f8b0-bd75-4425-b3f6-d002b21d098e |
| State | active |
| Table | postialue_pno_2024__table__history |