Version History of Paavo Postal Code Areas (Extending to Marine Areas) - 2017
The 'table__history' is a historical table that is part of a larger dataset collection related to Finnish postal code areas extending to marine areas in 2017. The table captures the version history of its base table rows, thus allowing for the tracking of changes over time. This is achieved through the use of special columns, such as '_start_date', '_end_date', and '_row_number', which provide information on when the row was extracted and the unique identifier of each row. For instance, if the '_end_date' is null, it signifies that the row is the most current version.
The table also encompasses a variety of other columns that provide detailed geographical insights. These include coordinates in the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The geographical data stored in columns that start with 'geom_' can be used for geospatial data analytics. Other columns indicate the area name in Finnish and Swedish, the area size, the postal code, and the year of data extraction.
The data in 'table__history' is sourced from 'Tilastokeskus' (Statistics Finland), providing an authentic and reliable source for analysis. The comprehensive nature of this table makes it suitable for a variety of data analytics applications. For instance, it can be used to analyze trends in geographical changes over time, track the growth or decline of specific areas, or even map and visualize Finnish postal code areas for marine-related studies.
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 this version history table. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. A null value indicates that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. Along with '_start_date', it forms a unique identifier for each row in this version history table. |
| geom_geojson | string | This column contains the geographical data of the row in GeoJSON format, a type of format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains the geographical data of the row in text format. |
| geom_type | string | This column specifies the type of geographical data stored in the geom_geojson and geom_geotext columns. In this case, it is 'ST_MULTIPOLYGON', indicating that the data represents multiple polygonal areas. |
| geom_centroid | string | This column contains the geographical center point of the row's geographical area, represented as a point in space. |
| geom_center_x | double | This column contains the x-coordinate of the geographical center point of the row's geographical area. |
| geom_center_y | double | This column contains the y-coordinate of the geographical center point of the row's geographical area. |
| gml_id | string | This is a unique identifier for each row. |
| kunta | string | This column contains a code representing the municipality in which the row's geographical area is located. |
| kuntanro | double | This column contains a number representing the municipality in which the row's geographical area is located. |
| namn | string | This column contains the name of the row's geographical area in the local language. |
| nimi | string | This column contains the name of the row's geographical area in Finnish. |
| objectid | double | This is a unique identifier for each row. |
| pinta_ala | double | This column contains the surface area of the row's geographical area, measured in square meters. |
| posti_alue | string | This column contains the postal code of the row's geographical area. |
| vuosi | double | This column contains the year when the data of the row 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 | 746d857b-99de-4d7e-82ae-d43e42532ceb |
| Package id | 7a102891-cd38-4d06-be6a-f235a19a1f83 |
| Position | 1 |
| Revision id | 13565a3f-4339-4822-9be2-8f5d1a2765cd |
| State | active |
| Table | postialue_pno_meri_2017__table__history |