Statistics Finland Postal Area Data Collection

This dataset collection is an aggregation of different sets of related data tables obtained from the Statistics Finland (Tilastokeskus) website in Finland. The tables consist of various statistical data, which are organized in a structured format of columns and rows for easy accessibility and understanding. The data in these tables are updated periodically, as evident from the presence of data tables from different years. Among the tables, there are specific ones that provide maritime statistical data. All the data provided through this dataset collection originates from the Service Interface (WFS) of Statistics Finland (Tilastokeskus), ensuring the reliability and authenticity of the data. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Finland Postal Areas - Geospatial DataTSV
The table under discussion belongs to the dataset collection and contains a wealth of information related to postal areas, as implied by the table contents description provided by the data source - 'Paavo-postinumeroalueet', which translates to 'Paavo Postal Code Areas'. This information is sourced from 'Tilastokeskus' (Statistics Finland), a website based in Finland. The table contains several columns, two of which are of special interest: the '_extract_date' and '_row_number'. The '_extract_date' column indicates the date when the data on that specific row was extracted from the source, while the '_row_number' provides the specific row number in the data extracted from the source on that particular extract date. These two columns together serve as unique identifiers for each row in...
Version History of Postal Code Areas (Paavo)TSV
The 'table__history' is a history table that contains the version history of its base table rows. This particular table belongs to a dataset collection named 'postialue_pno'. The data in the table represents the postal area data from Finland as sourced from the Statistics Finland (Tilastokeskus) website. The table contains a wealth of information including geographic information and postal area details. This collection of data is highly structured and organized, allowing users to perform detailed data analytics. The table contains several columns, each providing unique information. For instance, there are columns that contain the start and end date of the data extraction. These columns, combined with the row number, provide a unique identifier for each row in the table. If the end date...

Column Descriptions

Finland Postal Areas - Geospatial Data

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source.
_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'.
geom_geojson	string	This column contains GeoJSON formatted geometrical data.
geom_geotext	string	This column contains geometrical data formatted as text.
geom_type	string	This column indicates the type of the geometrical data, such as polygon or multipolygon.
geom_centroid	string	This column contains the central point of the geometrical shape.
geom_center_x	double	This column represents the X coordinate of the geometrical shape's center.
geom_center_y	double	This column represents the Y coordinate of the geometrical shape's center.
gml_id	string	This is a unique identifier for each row in the dataset.
kunta	string	This column contains the municipality code.
kuntanro	long	This column contains the municipality number.
namn	string	This column contains the name of the location in Swedish.
nimi	string	This column contains the name of the location in Finnish.
objectid	long	This column is a unique identifier for each object in the dataset.
pinta_ala	long	This column contains the area of the location in square meters.
posti_alue	string	This column contains the postal code of the location.
vuosi	long	This column contains the year the data was collected.

Version History of Postal Code Areas (Paavo)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source, providing a timestamp for the start of the row's version history.
_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	Holds 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 the version history.
geom_geojson	string	Contains geospatial data in GeoJSON format. This could represent various geographic structures such as polygons and multipolygons.
geom_geotext	string	This column stores the geospatial data in a text format, representing various geographic structures such as polygons and multipolygons.
geom_type	string	Identifies the type of the geospatial data stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	Contains the centroid point of the geographic structure, represented as a point in the geospatial data.
geom_center_x	double	The X-coordinate of the center point of the geographic structure.
geom_center_y	double	The Y-coordinate of the center point of the geographic structure.
gml_id	string	A unique identifier for each row in the table.
kunta	string	Contains the municipality code in Finland where the geographical structure is located.
kuntanro	long	Contains the municipality number in Finland where the geographical structure is located.
namn	string	Name of the geographical structure in Swedish.
nimi	string	Name of the geographical structure in Finnish.
objectid	long	An integer identifier for each row in the table.
pinta_ala	long	The area of the geographical structure in square meters.
posti_alue	string	The postal code area where the geographical structure is located.
vuosi	long	The year related to the data row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024