Paavo Postal Code Areas (Extending to Sea Areas) - 2022 Edition

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

Click here for a data sample

The table in question is a part of a larger dataset collection and contains a comprehensive set of information related to postal zones extending to sea areas for the year 2022, sourced from 'Tilastokeskus' (Statistics Finland). The data provides various geographic details, which are vital for conducting geospatial data analytics. The geographical coordinates are presented using the WGS 84 coordinate reference system, where the longitude is presented first, followed by the latitude.

The table includes a variety of columns, providing specific information. For instance, the table includes columns providing geographic information in different formats, such as GeoJSON and GeoText. These columns offer a valuable resource for mapping and visualizing the data geographically. A column is dedicated to the type of geographic data presented, which can be useful in specifying the visualization tools used.

Moreover, the table captures the centroid of the geographic data, which can be used to find the center point of the geographic area. Additional columns present the x and y coordinates of this center point, which can aid in location pinning on maps.

The table also contains columns with specific identification numbers for each postal zone, which can be used to cross-reference with other tables or datasets. The table also includes columns that contain the names of the postal zones in different languages, which can be useful in international communication and localization efforts.

The table features two special columns, namely '_extract_date' and '_row_number'. The '_extract_date' column records the date when the data on the row was extracted, while the '_row_number' column records the row number of the data extracted on that date. Together, these two columns provide a unique identifier for each row, ensuring that each row represents a unique data extraction instance.

The data in the table can be utilized in a multitude of ways. For example, it can help in understanding the spatial distribution of postal zones, enabling efficient route planning for logistics and delivery companies. Furthermore, the detailed geographical data can assist urban planners in infrastructure development and planning. Lastly, the table could be used by researchers to study population distribution and urbanization trends.

Field Descriptions

Name Data type Description
_extract_datedateThis column contains the date when the data on the row of the table was extracted from the source.
_row_numberlongThis column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'.
geom_geojsonstringThis column contains geojson formatted geographical data.
geom_geotextstringThis column contains geographical data in geotext format.
geom_typestringThis column specifies the type of geographical data represented in the table.
geom_centroidstringThis column contains the centroid point of the geographical area.
geom_center_xdoubleThis column contains the longitude of the center point of the geographical area.
geom_center_ydoubleThis column contains the latitude of the center point of the geographical area.
gml_idstringThis column is a unique identifier for each row in the table.
kuntastringThis column contains a unique identifier for the municipality.
kuntanrolongThis column contains the number associated with the municipality.
namnstringThis column contains the name of the geographical area in Swedish.
nimistringThis column contains the name of the geographical area in Finnish.
objectidlongThis column contains a unique object identifier for each row in the table.
pinta_alalongThis column contains the area size of the geographical area in square meters.
posti_aluestringThis column contains the postal code of the geographical area.
vuosilongThis column contains the year 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
Id9df2407e-505d-4ab5-a8b4-0dd70b80fb61
Package id09e9dc95-4581-4230-b05a-0db73c9a1f51
Revision ida3751a3d-ee5f-4981-a3bd-0febccd10ed2
Stateactive
Tablepostialue_pno_meri_2022__table