Version History of Postal Code Areas 2018
The history table is a comprehensive collection of data, offering a detailed perspective of its base table rows over time. Its contents are derived from 'Paavo-postinumeroalueet 2018', which translates to 'Paavo Postal Code Areas 2018'. This information is vital in understanding the evolution of postal code areas over time in Finland, as sourced from the 'Statistics Finland' (Tilastokeskus) website.
The table incorporates an array of columns, each contributing to the richness of the data. Some columns provide geographic information valuable for geospatial data analytics, all presented using the WGS 84 coordinate reference system, with longitude first, followed by latitude. Examples include 'geom_geojson' and 'geom_geotext', which contain geographic data in geojson and geotext formats, respectively. Other columns like 'geom_centroid', 'geom_center_x', and 'geom_center_y' provide the geographic center of each postal code area.
This table also contains information about the postal code area itself, such as its name ('namn' and 'nimi'), its area ('pinta_ala'), and the year of the data ('vuosi'). These details offer valuable insights into the spatial distribution and dimension of each postal code area.
Unique to this history table are two special columns, '_start_date' and '_end_date'. The '_start_date' column signifies the date when the row was extracted from the source, while the '_end_date' indicates when a new version of the row was extracted. If '_end_date' is null, it indicates that the row is the most recent version. The '_row_number' column contains the number of the row in the raw data, and together with '_start_date', these columns uniquely identify each row in this history table.
This rich dataset can be used in various data analytics scenarios. For instance, it could be used to study changes in the size of postal areas over time, to examine population shifts based on postal code areas, or to analyze the spatial distribution of postal areas for logistics optimization. Additionally, the historical data can inform predictive models to forecast future changes in postal code areas.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source, which allows tracking the version history of the data. It forms a unique pair with the '_row_number' to identify each row in the history table. |
| _end_date | date | This column records the date when a new version of the row was extracted from the data source. A null value in this column indicates that the row is the most recent version of the data. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the source, and together with '_start_date', it uniquely identifies each row in the history table. |
| geom_geojson | string | This column stores the geometric data of the area in GeoJSON format, a popular open standard format designed for representing simple geographical features. |
| geom_geotext | string | This column contains the geometric data of the area in text format, which provides a human-readable representation of the geographical features. |
| geom_type | string | This column specifies the type of the geometry represented in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column holds the coordinates of the centroid, or geometric center, of the area. |
| geom_center_x | double | This column contains the x-coordinate of the geometric center of the area. |
| geom_center_y | double | This column contains the y-coordinate of the geometric center of the area. |
| gml_id | string | This column is a unique identifier for each row in the table. |
| kunta | string | This column contains a code representing the municipality where the area is located. |
| kuntanro | long | This column contains a number associated with the municipality. |
| namn | string | This column holds the name of the area in Swedish. |
| nimi | string | This column contains the name of the area in Finnish. |
| objectid | long | This column is a unique identifier for the row, similar to 'gml_id'. |
| pinta_ala | double | This column records the area of the region in square meters. |
| posti_alue | string | This column contains the postal code associated with the area. |
| shape_leng | double | This column records the length of the boundary of the area. |
| vuosi | long | This column contains the year when the data was recorded. |
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 | 86d34bed-372a-42e5-a8a2-875857c38c0a |
| Package id | 81ba2eff-e3b5-480a-b7fa-2d13eec8b017 |
| Position | 1 |
| Revision id | b25f8445-eeee-4d62-abdd-29d9df3a414e |
| State | active |
| Table | postialue_pno_2018__table__history |