Statistics Finland Postal Area Data Collection 2023

This dataset collection is a compilation of related data tables sourced from the website of Tilastokeskus (Statistics Finland), based in Finland. The data tables comprise a diverse range of data organized in a structured table format, with distinct rows and columns. The content of these tables is derived from the service interface of Statistics Finland, providing a valuable resource for understanding various statistical aspects. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2023 Postal Areas Data Table - FinlandTSV
The 'table' is a part of the 'postialue_pno_2023' dataset collection. It contains information related to Paavo postal code areas for the year 2023, sourced from the 'Statistics Finland' (Tilastokeskus) website in Finland. The data is structured in a specific format featuring a variety of columns, each representing a different aspect of the postal code area. Key columns include geographic data fields, which start with 'geom_'. These columns contain geographic information that can be used for geospatial data analytics. For instance, 'geom_geojson' and 'geom_geotext' contain geographic shapes information in different formats, while 'geom_center_x' and 'geom_center_y' provide geographic center coordinates of the postal code area. It's important to note that geographic coordinates are...
Version History of Postal Code Areas 2023TSV
The 'table__history' is part of the 'postialue_pno_2023' dataset collection. As a history table, it maintains the version history of its base table rows. This table was sourced from the website of the Statistics Finland, or 'Tilastokeskus', from Finland. The table contains unique data records representing the 'Paavo postal code areas 2023'. It contains a variety of data fields, including geographic, demographic, and administrative data. The geographic information is presented using the WGS 84 coordinate reference system, with the order of longitude first, followed by latitude. These coordinates are contained in columns beginning with 'geom_', and can be used for geospatial data analytics, such as visualizing the postal code areas on a map or analyzing spatial patterns and trends. The...

Column Descriptions

2023 Postal Areas Data Table - Finland

Column	Type	Comment
_extract_date	date	This column records the date when the data row was extracted from the source.
_row_number	long	This indicates 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 geometry data in GeoJSON format.
geom_geotext	string	This stores the geometric data as a text string.
geom_type	string	This designates the type of geometric data stored.
geom_centroid	string	This signifies the geometric center of a shape in the form of a point.
geom_center_x	double	This represents the X-coordinate of the geometric center of a shape.
geom_center_y	double	This represents the Y-coordinate of the geometric center of a shape.
gml_id	string	This is a unique identifier for each data entry.
kunta	string	This column contains string type data.
kuntanro	long	This is an integer type data field.
namn	string	This contains string type data.
nimi	string	This also contains string type data.
objectid	long	This is a unique identifier for each data entry.
pinta_ala	long	This column contains data of type Integer64.
posti_alue	string	This column contains string type data.
vuosi	long	This column contains integer type data, referring to a specific year.

Version History of Postal Code Areas 2023

Column	Type	Comment
_start_date	date	This represents the date when the data row was extracted from the source. This, in conjunction with '_row_number', uniquely identifies each row in the history table.
_end_date	date	This represents the date when a new version of the data row was extracted. If this is null, it indicates that the current row is the most recent version.
_row_number	long	This indicates the row number in the raw data extracted from the source. This, in conjunction with '_start_date', uniquely identifies each row in the history table.
geom_geojson	string	This contains the geographical data in GeoJSON format, a common format for encoding a variety of geographic data structures.
geom_geotext	string	This contains the geographical data in text format. The data can be in different formats such as POLYGON or MULTIPOLYGON.
geom_type	string	This indicates the type of the geographical data contained in 'geom_geojson' and 'geom_geotext'. Examples include 'ST_POLYGON' and 'ST_MULTIPOLYGON'.
geom_centroid	string	This represents the center point of the geographical area described in 'geom_geojson' and 'geom_geotext'.
geom_center_x	double	This indicates the X-coordinate of the center point of the geographical area.
geom_center_y	double	This indicates the Y-coordinate of the center point of the geographical area.
gml_id	string	This is a unique identifier for each row of the dataset.
kunta	string	This field contains the municipality code.
kuntanro	long	This field also contains the municipality code, similar to the 'kunta' field.
namn	string	This is the Swedish name of the area described in the row.
nimi	string	This is the Finnish name of the area described in the row.
objectid	long	This is a unique identifier for each object in the dataset.
pinta_ala	long	This represents the surface area of the geographical location.
posti_alue	string	This field contains the postal code of the area.
vuosi	long	This indicates the year related to the data row. In this case, it's 2023.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024