2018 Postal Area Data Collection

This dataset collection is a compilation of related data tables gathered from the website of Tilastokeskus (Statistics Finland) in Finland. The dataset features a wealth of information provided by the Tilastokeskuksen palvelurajapinta (Statistics Finland's Service Interface). It encompasses a variety of data tables that are interlinked and provide a comprehensive understanding of the subject matter. The content of the dataset is meticulously arranged in a table format, with data systematically organized in rows and columns for easy comprehension and analysis. This dataset collection is diligently curated to offer valuable insights and serve as an authoritative source of information. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2018 Postal Areas Extending to Sea Regions - FinlandTSV
The table, which is part of a larger dataset collection, contains comprehensive data related to postal areas extending to maritime areas for the year 2018. It appears to source its data from the 'Tilastokeskus' website located in Finland. The data within the table is organized into various columns, each representing a specific attribute of the postal area. For instance, it includes geographic information, which can be used in geospatial data analytics, and is presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. Notably, there are two special columns in this table: the date when the data on the row was extracted and the row number on that particular extract date. These two columns uniquely identify each row in the table. The...
2018 Version History of Finnish Postal Areas Extending to Maritime RegionsTSV
The 'table__history' is a history table that contains the version history of its base table rows, making it an instrumental part of the dataset collection titled 'postialue_pno_meri_2018'. The data content of the table includes significant information about the Paavo postal code areas (extending to marine areas) in 2018, sourced from the Finnish Statistics Bureau (Tilastokeskus). The table includes columns that contain unique identifiers for each row, the start date of the row extraction from the source, and an end date that marks when a new version of the row was extracted. If the end date column is null, it signifies that the row is the most recent version. Geographical data is also a key component of this table. Columns with the 'geom_' prefix house geographic information, which...

Column Descriptions

2018 Postal Areas Extending to Sea Regions - Finland

Column	Type	Comment
_extract_date	date	This special column contains the date when the data on the row of the table was extracted from the data source.
_row_number	long	Another special column, it contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. The combination of '_extract_date' and '_row_number' uniquely identifies each row.
geom_geojson	string	This column contains geographical data in GeoJSON format, a format for encoding geographic data structures.
geom_geotext	string	This column contains geographical data in a text format.
geom_type	string	This column specifies the type of the geographic data stored in the table.
geom_centroid	string	The column holds the geographical centroid of the data object.
geom_center_x	double	This column contains the x-coordinate of the center of the geographical object.
geom_center_y	double	This column contains the y-coordinate of the center of the geographical object.
gml_id	string	This column contains the unique identifier of the geographical markup language object.
kunta	string	The column contains the municipality code.
kuntanro	long	This column contains the municipality number.
namn	string	The column holds the Swedish name of the municipality.
nimi	string	This column contains the Finnish name of the municipality.
objectid	long	The column holds a unique object identifier.
pinta_ala	double	This column contains the area of the municipality in square meters.
posti_alue	string	The column holds the postal code of the municipality.
shape_leng	double	This column contains the length of the perimeter of the municipality.
vuosi	long	The column contains the year of the data.

2018 Version History of Finnish Postal Areas Extending to Maritime Regions

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It forms a unique combination with the _row_number column to identify each row in the 'table__history' version history table.
_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 the row is the most recent version.
_row_number	long	This column contains the number of the row in the raw data extracted from the data source. It forms a unique combination with the _start_date column to identify each row in the 'table__history' version history table.
geom_geojson	string	Contains the geometry of the location in GeoJSON format.
geom_geotext	string	Contains the geometry of the location in text format.
geom_type	string	Specifies the type of geometry used for the location.
geom_centroid	string	Specifies the central point of the location's geometry.
geom_center_x	double	Specifies the X coordinate of the location's center.
geom_center_y	double	Specifies the Y coordinate of the location's center.
gml_id	string	Unique identifier for each row in the table.
kunta	string	Contains the municipality code.
kuntanro	long	Contains the municipality number.
namn	string	Contains the name of the municipality.
nimi	string	Contains the name of the area.
objectid	long	Unique identifier for each object in the table.
pinta_ala	double	Contains the area size.
posti_alue	string	Contains the postal code area.
shape_leng	double	Contains the length of the shape's boundary.
vuosi	long	Contains the year for which the data is applicable.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024