2016 Postal Area Data Collection

The dataset collection under discussion is a compilation of data tables derived from the 'Tilastokeskus' (Statistics Finland) web site in Finland. Its main focus is on postal area data for the year 2016. The tables in this collection contain interconnected data, organized in rows and columns, providing a comprehensive view of the subject matter. The original source describes it as a 'Service Interface (WFS)' from the Statistics Finland, indicating that the data might have been retrieved using a web feature service, a standard protocol for serving geographic information over the web. This dataset collection is a valuable resource for anyone interested in postal area statistics of Finland for the year 2016. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2016 Postal Code Areas - Dataset TableTSV
The table is part of a dataset collection that delves into the postal areas of 2016, as provided by the Finnish Statistical Bureau (Tilastokeskus). The table encompasses a wide range of data, including intricate geographic information that can be leveraged for geospatial data analytics. This geographic data, represented under columns beginning with 'geom_', uses the WGS 84 coordinate reference system, with longitude listed before latitude. The table also contains unique identifiers for each postal area, as well as associated region names, both in Finnish and in other local languages. It offers insight into the surface area of each postal region, allowing for spatial distribution analysis. Additionally, data pertaining to the year of record is also included. Two unique columns in the...
Version History of Postal Area Data 2016TSV
The 'table__history' is a robust data resource that captures a detailed version history of its base table rows. It belongs to a broader dataset collection associated with geographical postal areas for the year 2016. The contents of this table are derived from 'Tilastokeskus', a Finnish statistical agency, serving as a rich source of information for varied applications in data analytics. The table features a diverse range of columns encompassing geographical, demographic, and temporal data. Some of the notable columns include start and end dates indicating when the row was extracted and when a new version was created respectively. A unique feature of this table is its ability to track version history, made possible by the combination of the row number and start date. If the end date is...

Column Descriptions

2016 Postal Code Areas - Dataset Table

Column	Type	Comment
_extract_date	date	This column holds the date when the data on the row was extracted from the database. It is a special column that helps identify each row uniquely in combination with the _row_number.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the _extract_date column. It is a special column that, in combination with _extract_date, provides a unique identifier for each row.
geom_geojson	string	This column contains geospatial data in GeoJSON format, a widely used open standard format designed for representing simple geographical features.
geom_geotext	string	This column contains geospatial data in text format. The data usually represents geographic features and their spatial extents.
geom_type	string	This column contains information about the type of the geometry that the geospatial data represents.
geom_centroid	string	This column contains the coordinates of the centroid of the geometric shape represented by the geospatial data in the row.
geom_center_x	double	This column contains the X-coordinate of the center of the geometric shape represented by the geospatial data in the row.
geom_center_y	double	This column contains the Y-coordinate of the center of the geometric shape represented by the geospatial data in the row.
gml_id	string	This string column stores the unique identifier for each geographical markup language data element.
kunta	string	This string column contains the municipality code.
kuntanro	long	This integer column contains the municipality number, which is a unique identifier for each municipality.
namn	string	This string column represents the name of the geographical area in a foreign language.
nimi	string	This string column represents the name of the geographical area.
pinta_ala	double	This real (floating-point) column contains the area of the geographic region in square meters.
posti_alue	string	This string column represents the postal area code.
shape_star	double	This real (floating-point) column represents a shape-related parameter of the geographic area.
shape_stle	double	This real (floating-point) column represents a shape-related parameter of the geographic area.
vuosi	long	This integer column contains the year when the data for the row was collected or updated.

Version History of Postal Area Data 2016

Column	Type	Comment
_start_date	date	The date when the row was first extracted from the data source.
_end_date	date	The date when a new version of the row was extracted from the data source. If this value is null, it indicates that the row is the most recent version.
_row_number	long	The number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson	string	Contains geometric data in GeoJSON format. It could represent multiple polygons (areas).
geom_geotext	string	Contains geometric data in text format, typically representing multiple polygons.
geom_type	string	The type of the geometry, in this case, it's a multi polygon.
geom_centroid	string	The central point of the geometric shape described in the row.
geom_center_x	double	The X coordinate of the geometric object's center.
geom_center_y	double	The Y coordinate of the geometric object's center.
gml_id	string	A unique identifier for the row.
kunta	string	A string that represents the municipality.
kuntanro	long	An integer number associated with the municipality.
namn	string	Name of the place or area, in Finnish.
nimi	string	Name of the place or area, in Finnish. It seems to be similar to 'namn'.
pinta_ala	double	The area of the place or region, in square meters.
posti_alue	string	Postal code of the area.
shape_star	double	Contains geometric data related to the shape, possibly its area.
shape_stle	double	Contains geometric data related to the shape. It might represent its length or perimeter.
vuosi	long	The year associated with the row's data, most likely the year of data collection or relevancy.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024