2023 Geospatial Data of Postal Code Areas Extending to Sea Zones

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

Click here for a data sample

The table in focus forms part of a group of related data tables, specifically belonging to the 'postialue_pno_meri_2023' dataset collection. The table’s contents revolve around the Paavo postal code areas (extending to maritime areas) for the year 2023, sourced from Finland's 'Tilastokeskus' (Statistics Finland) website.

The data in the table is organized into various columns, which include unique identifiers, geographic information, and other specific details. Two of these columns are '_extract_date' and '_row_number'. The '_extract_date' column denotes the date on which the data row was extracted from the source, while the '_row_number' column indicates the row number in the data extracted from the source on the specified extract date. Together, these two columns uniquely identify each row in the table.

The table also contains columns starting with 'geom_', which house geographic information relevant for geospatial data analytics. These geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.

In terms of data analytics, this table provides a rich source of information. For instance, analysts can use the geographic coordinates and area details to study population distribution patterns across different postal code areas. Additionally, they can track changes over time by comparing the data extraction dates. Furthermore, the unique identifiers in the table can be instrumental in merging this data with other datasets, thereby enriching the overall analysis and leading to more comprehensive insights.

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 data source. The data type of this column is Date.
_row_numberlongThis column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row. The data type of this column is Integer.
geom_geojsonstringThis column contains geographic data in the GeoJSON format. The data type of this column is String.
geom_geotextstringThis column contains geographic data in the Geotext format. The data type of this column is String.
geom_typestringThis column indicates the type of the geographic data. The data type of this column is String.
geom_centroidstringThis column contains the geographic center point of the data. The data type of this column is String.
geom_center_xdoubleThis column contains the X-coordinate of the geographic center point. The data type of this column is Float.
geom_center_ydoubleThis column contains the Y-coordinate of the geographic center point. The data type of this column is Float.
gml_idstringThis column contains the unique identifier for the geographic data. The data type of this column is String.
kuntastringThis column contains the code of the municipality. The data type of this column is String.
kuntanrolongThis column contains the number of the municipality. The data type of this column is Integer.
namnstringThis column contains the name of the area in Swedish. The data type of this column is String.
nimistringThis column contains the name of the area in Finnish. The data type of this column is String.
objectidlongThis column contains the object identifier. The data type of this column is Integer.
pinta_alalongThis column contains the surface area measurement. The data type of this column is Integer.
posti_aluestringThis column contains the postal code of the area. The data type of this column is String.
vuosilongThis column contains the year which the data is related to. The data type of this column is Integer.

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
Ide0883bec-ef30-48e8-83f6-5b0ff43c61e6
Package id1b3bb696-e510-4bc9-af00-5822f5a559e1
Revision id65fd1ae9-4111-454e-b308-e82d0b3adc04
Stateactive
Tablepostialue_pno_meri_2023__table