Version History of Paavo Postal Code Areas (Extending to Marine Areas) 2020

To download the data set, please sign up or log in

Click here for a data sample

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_datedateThe 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_datedateThe 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_numberlongThe 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_geojsonstringThe GeoJSON representation of the geographic object.
geom_geotextstringThe textual representation of the geographic object.
geom_typestringThe type of the geographic object, such as 'ST_POLYGON'.
geom_centroidstringThe centroid of the geographic object represented as a point.
geom_center_xdoubleThe X-coordinate of the center of the geographic object.
geom_center_ydoubleThe Y-coordinate of the center of the geographic object.
gml_idstringThe unique identifier of the geographic object.
kuntastringThe municipality code.
kuntanrolongThe number of the municipality.
namnstringThe name of the location in another language.
nimistringThe name of the location.
objectidlongThe unique identifier of the object.
pinta_aladoubleThe area of the location in square meters.
posti_aluestringThe postal code of the location.
vuosilongThe 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
Countryfi
Databasefi_tilastokeskus
Extract date2024-11-11
Id76306fec-ba7f-4072-8d08-60a7567dc48f
Package id248ac4c7-392c-4934-a4b0-311c720799f4
Position1
Revision id281e8363-2b09-435f-8361-1c19590e3350
Stateactive
Tablepostialue_pno_meri_2020__table__history