Historical Versioning of Paavo Postal Areas Extending to Sea Areas 2021
The 'table__history' is a historical table sourced from 'Tilastokeskus' (the Statistical Bureau) in Finland. It contains an extensive collection of geographical and historical information, making it a rich resource for data analytics. The table is part of the 'postialue_pno_meri_2021' dataset collection. This table captures the version history of its base table rows, allowing users to track changes over time.
The data content covers geographical coordinates, area details, and postal codes, among other things. The geographical coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This can be utilized for geospatial data analytics. For instance, one could use this data to analyze changes in area names over time or assess geographical shifts in postal codes.
The chronological evolution of the data is captured by two special columns: '_start_date' and '_end_date'. The '_start_date' indicates when the row was extracted from the source, while the '_end_date' shows when a new version was extracted. If the '_end_date' is null, it signifies that the row is the most recent version. Together with the '_row_number', these three columns uniquely identify each row in the version history table.
The table also includes the column '_row_number', which provides the number of the row in the raw data extracted from the source. This combination of historical and geographical data can provide valuable insights for studies related to population distribution, urban planning, and more.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number' column for each row in this history table. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If this column contains a null value, it means that the row is the most recent version. |
| _row_number | long | This column contains the row number from the raw data extracted from the data source. It forms a unique identifier in combination with the '_start_date' column for each row in this history table. |
| geom_geojson | string | This column contains the geojson representation of the geography of the area. |
| geom_geotext | string | This column contains the textual representation of the geography of the area. |
| geom_type | string | This column specifies the type of the geographical representation, for example, polygon. |
| geom_centroid | string | This column contains the geographical point that represents the center of the area. |
| geom_center_x | double | This column contains the x-coordinate of the center of the area. |
| geom_center_y | double | This column contains the y-coordinate of the center of the area. |
| gml_id | string | This column contains the unique identifier of the row in the data source. |
| kunta | string | This column contains a string representation of the municipality code. |
| kuntanro | long | This column contains the numerical code of the municipality. |
| namn | string | This column contains the name of the area in Swedish. |
| nimi | string | This column contains the name of the area in Finnish. |
| objectid | long | This column contains the unique object identifier. |
| pinta_ala | long | This column contains the area size in square meters. |
| posti_alue | string | This column contains the postal area code. |
| vuosi | long | This column contains 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 | f0bf5a50-8171-4391-9840-5f4d85c429ae |
| Package id | 2043a820-5f28-4daa-b2f1-ad06d4c82d62 |
| Position | 1 |
| Revision id | b1290227-d055-4377-93b2-86520255e639 |
| State | active |
| Table | postialue_pno_meri_2021__table__history |