Version History of Postal Code Areas 2015
The 'table__history' is a historical record of the 'Paavo-postinumeroalueet 2015' dataset, originally sourced from the Statistics Finland (Tilastokeskus) website. This dataset captures geographic and demographic information related to Finnish postal areas for the year 2015. The table includes a variety of geographic data columns, like 'geom_geojson', 'geom_geotext', and 'geom_type', that can be used for geospatial analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with longitude preceding latitude.
The table also includes information like area names ('namn', 'nimi'), area codes ('kunta', 'kuntanro', 'posti_alue'), and area size ('pinta_ala'). Additionally, there are columns like 'shape_star' and 'shape_stle' that provide more specific geographic details. The table's data can be utilized in multiple ways, for example, to analyze population distribution across different regions, or to study the changes in geographical boundaries over time.
The 'table_history' has two special columns '_start_date' and '_end_date', which record when the data row was extracted and when it was updated, respectively. A null '_end_date' signifies the most recent version of the row. The '_row_number' column, in combination with '_start_date', uniquely identifies each row in this history table. This structure allows for a comprehensive understanding of chronological changes in the dataset.
This table, therefore, not only provides a snapshot of Finnish postal areas for 2015 but also enables a detailed study of the evolution of these areas over time.
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. If the value is null, it means that the row is the most recent version. |
| _row_number | long | The number of the row in the raw data. Together with '_start_date', it uniquely identifies each row in this version history table. |
| geom_geojson | string | Contains the geometry of the postal area in the GeoJSON format. |
| geom_geotext | string | Contains the geometry of the postal area in text format. |
| geom_type | string | Specifies the type of geometry used. |
| geom_centroid | string | Contains the centroid of the geometry. |
| geom_center_x | double | The X-coordinate of the center of the geometry. |
| geom_center_y | double | The Y-coordinate of the center of the geometry. |
| gml_id | string | The unique identifier of the postal area. |
| kunta | string | Contains the code of the municipality where the postal area is located. |
| kuntanro | long | The number of the municipality where the postal area is located. |
| namn | string | The name of the location in Swedish. |
| nimi | string | The name of the location in Finnish. |
| pinta_ala | double | The area of the postal area in square meters. |
| posti_alue | string | The postal code of the area. |
| shape_star | double | Contains the shape area of the postal region. |
| shape_stle | double | Contains the shape length of the postal region. |
| vuosi | long | The year when the data was collected. |
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 | cc735c6e-6146-4cef-9078-41ee61c08e2b |
| Package id | d8b0a34e-5e3a-4cc0-921f-e51bf242710c |
| Position | 1 |
| Revision id | 83f897e3-c821-4c9a-97b0-d67273fbb7e0 |
| State | active |
| Table | postialue_pno_2015__table__history |