Statistics Bureau's Service Interface (WFS) - Postal Area and Sea Data Collection 2023

This dataset collection consists of related data tables sourced from the 'Tilastokeskus' (Statistics Finland) website, which is based in Finland. The dataset is provided through Tilastokeskus' Service Interface (WFS), containing valuable statistical information. The dataset collection comprises multiple tables, each organized in a structured format with rows and columns to facilitate data analysis and interpretation. The data within these tables are interconnected, offering comprehensive insights for various research purposes. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2023 Geospatial Data of Postal Code Areas Extending to Sea ZonesTSV
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...
Version History of Extended Marine Area Postal Code Regions 2023TSV
The 'table__history' is a rich dataset, part of a larger collection known as 'postialue_pno_meri_2023', sourced from the 'Statistics Finland' ('Tilastokeskus') website. It stores an extensive range of data related to Finnish postal areas extending to maritime areas for the year 2023, presenting data in a structured format with each row signifying a unique data entry. The table holds the version history of its base table rows, enabling the tracking of changes over time. Each row in the table is distinctly identified by a combination of its '_start_date' and '_row_number'. The '_start_date' indicates the date when the row data was originally extracted, while the '_end_date' signifies when a new version of the same row was extracted. If the '_end_date' is null, this signifies the most...

Column Descriptions

2023 Geospatial Data of Postal Code Areas Extending to Sea Zones

Column	Type	Comment
_extract_date	date	This 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_number	long	This 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_geojson	string	This column contains geographic data in the GeoJSON format. The data type of this column is String.
geom_geotext	string	This column contains geographic data in the Geotext format. The data type of this column is String.
geom_type	string	This column indicates the type of the geographic data. The data type of this column is String.
geom_centroid	string	This column contains the geographic center point of the data. The data type of this column is String.
geom_center_x	double	This column contains the X-coordinate of the geographic center point. The data type of this column is Float.
geom_center_y	double	This column contains the Y-coordinate of the geographic center point. The data type of this column is Float.
gml_id	string	This column contains the unique identifier for the geographic data. The data type of this column is String.
kunta	string	This column contains the code of the municipality. The data type of this column is String.
kuntanro	long	This column contains the number of the municipality. The data type of this column is Integer.
namn	string	This column contains the name of the area in Swedish. The data type of this column is String.
nimi	string	This column contains the name of the area in Finnish. The data type of this column is String.
objectid	long	This column contains the object identifier. The data type of this column is Integer.
pinta_ala	long	This column contains the surface area measurement. The data type of this column is Integer.
posti_alue	string	This column contains the postal code of the area. The data type of this column is String.
vuosi	long	This column contains the year which the data is related to. The data type of this column is Integer.

Version History of Extended Marine Area Postal Code Regions 2023

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. This column, in combination with '_row_number', forms a unique identifier for each row in this version history table.
_end_date	date	The date when a new version of the row was extracted from the data source. If the value of this column is null, it signifies that the row is the most recent version.
_row_number	long	This column contains the number of the row in the raw data extracted from the data source, and forms a unique identifier for each row when combined with '_start_date'.
geom_geojson	string	Contains the geographical data of the area in GeoJSON format.
geom_geotext	string	Geospatial data represented in text format.
geom_type	string	Specifies the type of the geographical representation. For example, 'ST_POLYGON' refers to a polygon spatial object.
geom_centroid	string	Contains the centroid point of the geographical area.
geom_center_x	double	The X-coordinate of the center of the geographical area.
geom_center_y	double	The Y-coordinate of the center of the geographical area.
gml_id	string	Unique identifier for the geographical data.
kunta	string	Municipality code for the geographical area.
kuntanro	long	Municipality number, similar to 'kunta'.
namn	string	The name of the area in Swedish language.
nimi	string	The name of the area in Finnish language.
objectid	long	An integer that serves as a unique identifier for each object.
pinta_ala	long	Area of the geographical entity in square meters.
posti_alue	string	Postal code of the area.
vuosi	long	Year of the data, indicating when the data was collected or reported.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024