2021 Version History of Postal Code Areas
The 'table__history' is a historical data table that is a part of the 'postialue_pno_2021' dataset. It contains the version history of its base table rows, providing a chronological view of data changes. This historical dataset is sourced from the 'Statistics Finland' (Tilastokeskus) website in Finland, making it a reliable and authoritative source of data. Its primary content is based on the 'Paavo Postal Code Areas 2021' table, providing information regarding postal code areas in Finland for the year 2021.
The table includes numerous columns providing a variety of data. For instance, it includes geographic information, such as the type, geojson, geotext, centroid, center x, and center y of the geometry. This geospatial data, presented using the WGS 84 coordinate reference system, can be used to perform geospatial data analytics, including tracking changes in postal areas over time.
Another key aspect of this table is the presence of columns that track the start and end date of each row's existence in the raw data extracted from the data source. These columns, along with the row number, uniquely identify each row in this version history table. For example, a row with a null end date represents the most recent version of that row's data.
The table also contains information about the postal area, including its name in Finnish and Swedish, its municipality code, and the area in square meters. This kind of information can be used to study demographic changes, urban planning, or mail delivery efficiency in different areas.
In addition to the above, the table also includes the year of the data, providing a temporal context to the information.
In terms of data analytics, the wealth of information in this table opens up a range of possibilities. For example, the geospatial data could be used to analyze changes in the size and shape of postal code areas over time, potentially revealing trends in urban development. Similarly, the historical data could be used to track demographic changes within specific postal code areas, providing valuable insights for urban planning, resource allocation, or market research. Furthermore, the data could be used to optimize mail delivery routes, by analyzing the geographic and demographic data of postal code areas.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. This column, in combination with '_row_number', uniquely identifies each row in the version history table. |
| _end_date | date | The date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
| _row_number | long | The number of the row in the raw data extracted from the data source. Together with '_start_date', this column uniquely identifies each row in this version history table. |
| geom_geojson | string | Contains the geographic data in GeoJSON format. This data defines the spatial aspects of the data row. |
| geom_geotext | string | The geographic data in text format. This is another representation of the spatial data similar to 'geom_geojson'. |
| geom_type | string | The type of the geographic data. It indicates whether the data is a MultiPolygon or a Polygon. |
| geom_centroid | string | The centroid point of the geographic data, which is the geometric center of the shape defined by the spatial data. |
| geom_center_x | double | The x-coordinate of the center of the geographic data. |
| geom_center_y | double | The y-coordinate of the center of the geographic data. |
| gml_id | string | A unique identifier for each row. |
| kunta | string | The municipality in which the postal area is located. This is represented as a numeric code. |
| kuntanro | long | The number of the municipality. This corresponds to the 'kunta' column. |
| namn | string | The name of the postal area in the local language. |
| nimi | string | The name of the postal area in another local language. This allows for bilingual representation of the postal area name. |
| objectid | long | A unique identifier for each row. This corresponds to the 'gml_id' column. |
| pinta_ala | long | The area of the postal area in square meters. |
| posti_alue | string | The postal code of the area. |
| vuosi | long | The year when the data row was created or updated. |
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 | 74745a1c-6c0d-476d-a742-f2e7a04287d9 |
| Package id | 420caed5-97b4-426e-b57e-70274c88d880 |
| Position | 1 |
| Revision id | c52966c2-455b-428e-8eb4-ec6deeb7ea33 |
| State | active |
| Table | postialue_pno_2021__table__history |