Version History of Paavo Postal Code Areas (Extending to Marine Areas) 2020
The table under discussion serves as a history table, maintaining a version history of its base table rows. It is a part of a dataset collection that encompasses data related to postal areas extending to maritime areas for the year 2020. This data originates from Finland's 'Tilastokeskus' (Statistics Finland), a reliable source for statistical information.
The table contains a rich variety of columns, including unique identifiers, geographic information, and administrative details, all of which can be used for a wide range of data analytics purposes. For instance, the geographic data, presented using the WGS 84 coordinate reference system, can be employed for geospatial data analytics, enabling the visualization and analysis of data based on geographic locations.
Specifically, the table includes a column that marks the row number in the raw data extracted from the source. Additionally, it contains 'start date' and 'end date' columns, which together with the row number, uniquely identify each row in this history table. The 'start date' denotes when the row was extracted from the source, whereas the 'end date' indicates when a new version of the row was extracted. If the 'end date' is null, it signifies that the row is the most recent version.
A few examples of how this data could be utilized include studying the geographical spread of postal areas over time, analyzing changes in the size of postal areas, and understanding the relationship between administrative regions and postal areas. Furthermore, the data could be used to create temporal visualizations, showcasing the evolution of postal areas in Finland.
In sum, this table provides a valuable resource for both historical and geographical analysis, offering a comprehensive view of postal areas in Finland for the year 2020.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | The date when the row was extracted from the data source. It forms a unique combination with the '_row_number' to identify 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. It forms a unique combination with the '_start_date' to identify each row in the version history table. |
geom_geojson | string | The GeoJSON representation of the geographic object. |
geom_geotext | string | The textual representation of the geographic object. |
geom_type | string | The type of the geographic object, such as 'ST_POLYGON'. |
geom_centroid | string | The centroid of the geographic object represented as a point. |
geom_center_x | double | The X-coordinate of the center of the geographic object. |
geom_center_y | double | The Y-coordinate of the center of the geographic object. |
gml_id | string | The unique identifier of the geographic object. |
kunta | string | The municipality code. |
kuntanro | long | The number of the municipality. |
namn | string | The name of the location in another language. |
nimi | string | The name of the location. |
objectid | long | The unique identifier of the object. |
pinta_ala | double | The area of the location in square meters. |
posti_alue | string | The postal code of the location. |
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 | 76306fec-ba7f-4072-8d08-60a7567dc48f |
Package id | 248ac4c7-392c-4934-a4b0-311c720799f4 |
Position | 1 |
Revision id | 281e8363-2b09-435f-8361-1c19590e3350 |
State | active |
Table | postialue_pno_meri_2020__table__history |