2020 Postal Area Statistics Interface

The 'postialue_pno_2020' dataset collection encompasses a group of tables sourced from the Statistics Finland (Tilastokeskus) website, located in Finland. It includes data that is meticulously organized into columns and rows to facilitate easy interpretation and analysis. The data source describes the dataset as a Statistics Finland Service Interface (WFS). This implies that the dataset provides a range of statistical services, likely related to the postal area data in Finland for the year 2020. The tables in this collection are interconnected, providing a comprehensive and coherent view of the data. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2020 Postal Area Data StructureTSV
The table under examination is a part of a larger dataset collection and is primarily dedicated to geographical information, specifically related to postal code regions in Finland. The data originates from the Finnish statistical authority, 'Tilastokeskus' (Statistics Finland). The table encompasses a variety of columns, each bearing crucial data. Two of these columns are '_extract_date' and '_row_number'. The former column holds the date when the data was extracted, while the latter indicates the row number in the extracted data, making each row unique when combined. The table prominently features geographical data columns, those beginning with 'geom_', which contain a wealth of geographical information useful for geospatial data analytics. This includes the geographical shape of the...
Version History of the Paavo Postal Code Areas 2020 DatasetTSV
The 'table__history' is a rich and comprehensive collection of geospatial data sourced from 'Tilastokeskus' (Statistics Finland), a reputable source in Finland. The table is part of the 'postialue_pno_2020' dataset and serves as a historical repository for previous versions of its base table rows, providing a detailed trail of changes over time. The table includes a myriad of geographical information, such as coordinates and other geospatial data, presented using the WGS 84 coordinate reference system. This data is primarily represented in columns starting with 'geom_', including the types of geographical shapes (like polygons), their centroids (geographical centers), and the x and y coordinates of their centers. These details are crucial for geospatial data analytics, as they enable...

Column Descriptions

2020 Postal Area Data Structure

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the source.
_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'.
geom_geojson	string	This column contains the geographical data in GeoJSON format.
geom_geotext	string	This column contains the geographical data in text format.
geom_type	string	This column specifies the type of geographical data, for example, polygon or multipolygon.
geom_centroid	string	This column gives the geographical coordinates of the centroid of the geographical area represented by the geometric data in the row.
geom_center_x	double	This column gives the x-coordinate of the center of the geographical area represented by the geometric data in the row.
geom_center_y	double	This column gives the y-coordinate of the center of the geographical area represented by the geometric data in the row.
gml_id	string	This column contains a unique identifier for each row.
kunta	string	This column contains a numeric code representing a municipality.
kuntanro	long	This column contains a numeric code representing a municipality.
namn	string	This column contains the name of the geographical area or feature in the local language.
nimi	string	This column contains the name of the geographical area or feature in the local language.
objectid	long	This column contains a unique identifier for each row.
pinta_ala	double	This column gives the area of the geographical area represented by the geometric data in the row.
posti_alue	string	This column contains the postal code of the geographical area represented by the geometric data in the row.
vuosi	long	This column contains the year of the data.

Version History of the Paavo Postal Code Areas 2020 Dataset

Column	Type	Comment
_start_date	date	This column contains the date when the row was first extracted from the data source. It aids in identifying the version history of each row.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If the value is null, it indicates that this row is the most recent version.
_row_number	long	This column represents the number of the row in the raw data from the data source. Together with '_start_date', it uniquely identifies each row in this history table.
geom_geojson	string	This column contains the geometric data of the area in GeoJSON format. It helps in visual representation of the area on map interfaces.
geom_geotext	string	This column contains the geometric data of the area in GeoTEXT format. It is another format for representing the area geometrically.
geom_type	string	This column specifies the type of the geometric data, such as 'Polygon' or 'MultiPolygon'.
geom_centroid	string	This column contains the centroid of the geometric figure representing the area. It can be used to determine the central point of the area.
geom_center_x	double	This column contains the X-coordinate of the center of the geometric figure.
geom_center_y	double	This column contains the Y-coordinate of the center of the geometric figure.
gml_id	string	This column contains the unique identifier for each row in the data source.
kunta	string	This column contains the municipality code.
kuntanro	long	This column contains the municipality number.
namn	string	This column contains the name of the municipality in Swedish.
nimi	string	This column contains the name of the municipality in Finnish.
objectid	long	This column contains a unique identifier for each object in the data source.
pinta_ala	double	This column contains the surface area of the municipality.
posti_alue	string	This column contains the postal code of the municipality.
vuosi	long	This column indicates the year when the data was recorded.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024