2020 Postal Area Data Collection

This dataset collection encompasses a group of related data tables sourced from the website of Tilastokeskus (Statistics Finland) in Finland. The tables contain valuable information provided by Tilastokeskus's service interface (WFS). It's worth noting that these tables are organized in a manner that makes it easy to understand and analyze the data. Each table is a collection of related data, systematically arranged in columns and rows for clear data visualization and interpretation. The dataset collection is comprehensive and serves as a reliable source for conducting diverse data analysis tasks. 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 Extending to Sea Regions - 2020TSV
The table is a structured compilation of related data collected from the 'Tilastokeskus' website, located in Finland. The table forms part of a larger dataset collection named 'postialue_pno_meri_2020'. The data within this table encompasses geographical information which can be analyzed for geospatial data analytics. The table's content focuses on 'Paavo-postal areas (extending to sea areas) for the year 2020', providing a detailed view into the geographic characteristics of these areas. The data within the table is organized into several distinct columns, each containing specific information. A few notable columns contain the extraction date and row number, which together uniquely identify each row of data. For geographical data, there are several columns that store information in the...
Version History of Paavo Postal Code Areas (Extending to Marine Areas) 2020TSV
The table under discussion serves as a history table, maintaining a version history of its base table rows. It is a part of a dataset collection that encompasses data related to postal areas extending to maritime areas for the year 2020. This data originates from Finland's 'Tilastokeskus' (Statistics Finland), a reliable source for statistical information. The table contains a rich variety of columns, including unique identifiers, geographic information, and administrative details, all of which can be used for a wide range of data analytics purposes. For instance, the geographic data, presented using the WGS 84 coordinate reference system, can be employed for geospatial data analytics, enabling the visualization and analysis of data based on geographic locations. Specifically, the table...

Column Descriptions

Paavo Postal Code Areas Extending to Sea Regions - 2020

Column	Type	Comment
_extract_date	date	This column signifies the date of data extraction from the source. It helps in tracking the freshness of the data.
_row_number	long	This column contains the row number of the data extracted on a particular date, as specified by the '_extract_date' column. It helps in uniquely identifying each row.
geom_geojson	string	This column contains the geometrical data of the area in GeoJSON format, which is a widely used open standard format designed for representing simple geographical features.
geom_geotext	string	This column contains the geometrical data in text format. It is typically a sequence of coordinates forming polygons.
geom_type	string	This column specifies the type of the geometric data. In this case, it is a Polygon.
geom_centroid	string	This column contains the centroid of the geometrical area, which is the arithmetic mean position of all the points in the shape.
geom_center_x	double	This column signifies the X-coordinate of the center of the geometric area.
geom_center_y	double	This column signifies the Y-coordinate of the center of the geometric area.
gml_id	string	This column contains a unique identifier for each row, in the form of a string.
kunta	string	This column contains string values representing the municipality.
kuntanro	long	This column contains integer values representing the number of the municipality.
namn	string	This column contains the name of the area in the local language.
nimi	string	This column contains the name of the area in Finnish.
objectid	long	This column contains a unique integer identifier for each object.
pinta_ala	double	This column contains the area of the geographical region in square meters.
posti_alue	string	This column contains the postal code of the area.
vuosi	long	This column contains the year when the data was collected.

Version History of Paavo Postal Code Areas (Extending to Marine Areas) 2020

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. It forms a unique combination with the '_row_number' to identify each row in the version history table.
_end_date	date	The date when a new version of the row was extracted from the data source. If the 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. It forms a unique combination with the '_start_date' to identify each row in the version history table.
geom_geojson	string	The GeoJSON representation of the geographic object.
geom_geotext	string	The textual representation of the geographic object.
geom_type	string	The type of the geographic object, such as 'ST_POLYGON'.
geom_centroid	string	The centroid of the geographic object represented as a point.
geom_center_x	double	The X-coordinate of the center of the geographic object.
geom_center_y	double	The Y-coordinate of the center of the geographic object.
gml_id	string	The unique identifier of the geographic object.
kunta	string	The municipality code.
kuntanro	long	The number of the municipality.
namn	string	The name of the location in another language.
nimi	string	The name of the location.
objectid	long	The unique identifier of the object.
pinta_ala	double	The area of the location in square meters.
posti_alue	string	The postal code of the location.
vuosi	long	The year when the data was collected.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024