Statistics Centre's Service Interface (WFS) Mailing Area Data Collection 2024

This dataset collection comprises groupings of related data tables, sourced from the 'Tilastokeskus' (Statistics Finland) web site in Finland. The tables within this dataset collection contain related data organized in a structured table format, with columns and rows representing distinct data points. The data within these tables is provided by the Statistics Finland's service interface (WFS). The dataset collection is designed to provide comprehensive, organized and accessible data for various data analysis and 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

Paavo Postal Code Areas 2024 Data TableTSV
The table under consideration is a constituent of a broader dataset, which contains an array of data tables. This specific table carries a wealth of information concerning postal areas for the year 2024, as suggested by its sourced description, 'Paavo-postinumeroalueet 2024', a Finnish term translated to 'Paavo postal code areas 2024'. The table comprises several columns, each with distinct data content. There are two unique columns, namely the extract date and row number. The extract date indicates when the data was pulled from its source, and the row number represents the specific row's position in the data extracted on the specified date. The combination of these two columns uniquely identifies each row in the table. Apart from these, the table includes a range of columns containing...
Version History of Postal Code Areas 2024TSV
The 'table__history' is a part of the 'postialue_pno_2024' dataset collection. It serves as a history table, providing a version history of its base table rows. The table is sourced from 'Tilastokeskus' (Statistics Finland) and focuses on Paavo postal code areas projected for the year 2024. The table encompasses various columns providing diverse types of data. One set of columns hold geographic information, indispensable for geospatial data analytics. These columns contain data such as geojson and geotext values, the geometry type, centroid coordinates, and the X and Y center coordinates. It's worth noting that the geographic coordinates are presented using the WGS 84 coordinate reference system, with the longitude listed first, followed by the latitude. Beyond geospatial data, the...

Column Descriptions

Paavo Postal Code Areas 2024 Data Table

Column	Type	Comment
_extract_date	date	The date when the data on the row of the table was extracted from the source.
_row_number	long	The row number in the data extracted from the source on the extract date. The combination of _extract_date and _row_number uniquely identifies each row.
geom_geojson	string	Column indicating the geometric shape of the area in GeoJSON format.
geom_geotext	string	Column indicating the geometric shape of the area in plain text format.
geom_type	string	Geometric type of the area, such as polygon or multipolygon.
geom_centroid	string	Geometric center of the area in point representation.
geom_center_x	double	X-coordinate of the geometric center of the area.
geom_center_y	double	Y-coordinate of the geometric center of the area.
gml_id	string	Unique identifier of the postal area in GML format.
kunta	string	Municipality number or identifier.
kuntanro	long	Municipality number, similar to 'kunta'.
namn	string	Name of the area in Swedish.
nimi	string	Name of the area in Finnish.
objectid	long	Unique object identifier.
pinta_ala	long	Surface area of the postal area.
posti_alue	string	Postal code of the area.
vuosi	long	The year for which the data is relevant.

Version History of Postal Code Areas 2024

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source.
_end_date	date	The date when a new version of the row was extracted from the data source. Null value indicates the row is the most recent version.
_row_number	long	A unique identifier for each row in the version history table, which is formed by combining this with the '_start_date'.
geom_geojson	string	Representing the geographic features of the postal area in GeoJSON format.
geom_geotext	string	Text representation of the geographic features of the postal area.
geom_type	string	Type of the geographic feature, for instance, polygon for areas.
geom_centroid	string	The central point of the geometric feature.
geom_center_x	double	The X-coordinate of the geometric feature's center point.
geom_center_y	double	The Y-coordinate of the geometric feature's center point.
gml_id	string	An identifier provided by the source.
kunta	string	Municipality code.
kuntanro	long	Municipality number.
namn	string	The name of the postal area in Swedish.
nimi	string	The name of the postal area in Finnish.
objectid	long	An integral identifier of the object.
pinta_ala	long	The area size of the postal area.
posti_alue	string	Postal area code.
vuosi	long	The year the data is derived from.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024