2021 Postal Area Data Collection from Finland's Statistical Services

The dataset collection in question is a comprehensive compilation of data tables related to postal codes for the year 2021. Originating from Finland's Statistics Bureau (Tilastokeskus), the collection is a rich source of information, meticulously organized in a table format with related data distributed across rows and columns. The tables within this collection provide detailed and structured data, all tied to the subject of postal codes. This dataset is an invaluable resource for anyone interested in or requiring detailed postal code information from Finland for the year 2021. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2021 Postal Code Areas DataTSV
The 'table' within the 'postialue_pno_2021' dataset collection is a comprehensive assembly of geographic and demographic data, sourced from the 'Statistics Finland' (Tilastokeskus) website in Finland. It provides valuable insights into different areas based on postal codes for the year 2021, as indicated by the 'Paavo-postinumeroalueet 2021' description. The table contains geographic data that can be used for geospatial analysis, presented using the WGS 84 coordinate reference system, with axis order longitude (geom_center_x) first, followed by latitude (geom_center_y). It provides polygonal geographical shapes, types, and centroid points, which are crucial for detailed geographic mapping and spatial data visualizations. The table also includes attributes that provide demographic and...
2021 Version History of Postal Code AreasTSV
The 'table__history' is a historical data table that is a part of the 'postialue_pno_2021' dataset. It contains the version history of its base table rows, providing a chronological view of data changes. This historical dataset is sourced from the 'Statistics Finland' (Tilastokeskus) website in Finland, making it a reliable and authoritative source of data. Its primary content is based on the 'Paavo Postal Code Areas 2021' table, providing information regarding postal code areas in Finland for the year 2021. The table includes numerous columns providing a variety of data. For instance, it includes geographic information, such as the type, geojson, geotext, centroid, center x, and center y of the geometry. This geospatial data, presented using the WGS 84 coordinate reference system, can...

Column Descriptions

2021 Postal Code Areas Data

Column	Type	Comment
_extract_date	date	This column holds the date when the data on the row was extracted from the data source. It is one of the special columns in the table used to uniquely identify each row.
_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'. It is another special column used to uniquely identify each row.
geom_geojson	string	This column contains the GeoJSON representation of the geographical area related to the data row.
geom_geotext	string	This column contains the textual representation of the geography of the data row in the form of polygons.
geom_type	string	This column specifies the type of the geographical data represented in the row. The sample value 'ST_POLYGON' indicates that the data is represented as a polygon.
geom_centroid	string	This column contains the geographical coordinate of the centroid of the geographical area related to the data row.
geom_center_x	double	This column represents the X-coordinate of the center point of the geographical area related to the data row.
geom_center_y	double	This column represents the Y-coordinate of the center point of the geographical area related to the data row.
gml_id	string	This column, of string type, appears to be a unique identifier for each row in the table.
kunta	string	This string-type column contains some form of municipality or region code.
kuntanro	long	This integer-type column seems to represent a municipality or region number.
namn	string	This column, of string type, could represent the name of the geographical area related to the data row.
nimi	string	This column is of string type and it might represent another format or translation of the name of the geographical area related to the data row.
objectid	long	This integer-type column seems to be a unique identifier for each row in the table.
pinta_ala	long	This column is of integer type and it could represent the area of the geographical zone related to the data row.
posti_alue	string	This column, of string type, seems to indicate a postal code related to the geographical area of the data row.
vuosi	long	This integer-type column seems to represent the year associated with the data row.

2021 Version History of Postal Code Areas

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. This column, in combination with '_row_number', uniquely identifies 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. Together with '_start_date', this column uniquely identifies each row in this version history table.
geom_geojson	string	Contains the geographic data in GeoJSON format. This data defines the spatial aspects of the data row.
geom_geotext	string	The geographic data in text format. This is another representation of the spatial data similar to 'geom_geojson'.
geom_type	string	The type of the geographic data. It indicates whether the data is a MultiPolygon or a Polygon.
geom_centroid	string	The centroid point of the geographic data, which is the geometric center of the shape defined by the spatial data.
geom_center_x	double	The x-coordinate of the center of the geographic data.
geom_center_y	double	The y-coordinate of the center of the geographic data.
gml_id	string	A unique identifier for each row.
kunta	string	The municipality in which the postal area is located. This is represented as a numeric code.
kuntanro	long	The number of the municipality. This corresponds to the 'kunta' column.
namn	string	The name of the postal area in the local language.
nimi	string	The name of the postal area in another local language. This allows for bilingual representation of the postal area name.
objectid	long	A unique identifier for each row. This corresponds to the 'gml_id' column.
pinta_ala	long	The area of the postal area in square meters.
posti_alue	string	The postal code of the area.
vuosi	long	The year when the data row was created or updated.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024