2022 Postal Area Data Collection from Finnish Statistical Interface

The dataset collection is a comprehensive compilation of related data tables sourced from the website of Tilastokeskus (Statistics Finland), a reputable organization based in Finland. The data tables within this collection provide extensive information and are organized in a user-friendly format, comprising of rows and columns for easy data interpretation. The original data description from the source, Tilastokeskus palvelurajapinta (Statistics Finland Service Interface), suggests that the data is up-to-date and relevant, making it a valuable resource for those seeking detailed statistical data from Finland. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2022 Postal Code Areas in FinlandTSV
The table in focus forms part of a larger dataset collection pertaining to postal code areas for the year 2022. This table provides a rich set of data, ranging from geographical coordinates to specific details about each postal area. The data is sourced from the 'Tilastokeskus' (Statistics Finland) website, based in Finland. The table is structured in a way that it offers comprehensive geographical information about each postal area. The information includes the geographic shape data, centroid of the area, and the coordinates of the center. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This kind of geospatial data is valuable for a variety of analytics purposes, such as visualizing...
Version History of Postal Code Areas 2022TSV
The 'table__history' is a comprehensive collection of data that provides a rich history of its base data rows. It is part of the 'postialue_pno_2022' dataset, which signifies its connection with postal area data. Specifically, this history table contains the version history of the Paavo postal code areas for the year 2022, a resource sourced from the 'Statistics Finland' website (Tilastokeskus) in Finland. The table includes a variety of columns that carry significant data, which can be utilized for various data analytics purposes. One key aspect of this table is its ability to track changes over time. This is facilitated by the '_start_date' and '_end_date' columns, which respectively record the date when a row was extracted from the data source and the date when a new version of that...

Column Descriptions

2022 Postal Code Areas in Finland

Column	Type	Comment
_extract_date	date	This column contains the date on which the data was extracted. It serves as a timestamp indicating when the data on a particular row was pulled from the source.
_row_number	long	This column provides a unique identifier for each row of data, representing the row number in the extracted data. Combined with the '_extract_date' column, it helps to uniquely identify each row.
geom_geojson	string	This column contains geometric data in the GeoJSON format, typically used for spatial features.
geom_geotext	string	This column contains geometric data represented as text. This could include coordinates for points, lines or polygons.
geom_type	string	This column specifies the type of geometric data contained in the row. For example, it could indicate whether the geometry is a point, line or polygon.
geom_centroid	string	This column gives the geometric centroid of the area represented in the row. This is the central point of the geometric shape.
geom_center_x	double	This column gives the x-coordinate of the geometric center of the area represented in the row.
geom_center_y	double	This column gives the y-coordinate of the geometric center of the area represented in the row.
gml_id	string	This column contains a unique identifier for each geometry represented in the table.
kunta	string	This column represents the municipality code in Finland.
kuntanro	long	This column represents the municipality number in Finland.
namn	string	This column contains the Swedish name of the area represented in the row.
nimi	string	This column contains the Finnish name of the area represented in the row.
objectid	long	This column contains a unique identifier for each object in the dataset.
pinta_ala	long	This column provides the surface area of the area represented in the row.
posti_alue	string	This column contains the postal code for the area represented in the row.
vuosi	long	This column indicates the year of the data.

Version History of Postal Code Areas 2022

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source, which is part of the 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 is null, it means 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 forms a unique identifier for each row in this version history table.
geom_geojson	string	Geographic data in GeoJSON format representing the spatial characteristics of the area.
geom_geotext	string	Geospatial data in text format representing the spatial characteristics of the area.
geom_type	string	The type of geometric data contained in the row.
geom_centroid	string	The central point of the geometric data.
geom_center_x	double	The X-coordinate of the center of the geometric data.
geom_center_y	double	The Y-coordinate of the center of the geometric data.
gml_id	string	An identifier for the geographic data.
kunta	string	A code representing a municipality in Finland.
kuntanro	long	A number representing a municipality in Finland.
namn	string	The name of the area in Swedish.
nimi	string	The name of the area in Finnish.
objectid	long	A unique identifier for the object.
pinta_ala	long	The surface area of the area represented.
posti_alue	string	The postal code of the area.
vuosi	long	The year the data was collected.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024