1. Home
  2. Datasets
  3. 2021 Postal Area and Sea ...
To download the data set, please sign up or log in

2021 Postal Area and Sea Region Data Collection

This dataset collection comprises of a group of data tables sourced from the Statistics Finland (Tilastokeskus) website. The tables present a compilation of data related to postal areas in Finland for the year 2021. The data has been organized in a tabular format, with each table containing related data categorized into rows and columns for easy understanding and analysis. The data in the tables is provided via the Statistics Finland's service interface (WFS). 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 Extending to Sea Regions - Data TableTSV

    The table belongs to a dataset collection that contains information on postal code areas extending to marine areas for the year 2021, sourced from the Finnish website 'Tilastokeskus' (Statistics Finland). It encompasses a broad range of data points, including geographic information useful for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The table includes details such as the date of data extraction, the number of the row in the extracted data, and various types of geographic data in different formats. The geographic data provides a detailed representation of the postal code areas, including their type (for example, polygon), centroid, center x and y coordinates,...

  • Historical Versioning of Paavo Postal Areas Extending to Sea Areas 2021TSV

    The 'table__history' is a historical table sourced from 'Tilastokeskus' (the Statistical Bureau) in Finland. It contains an extensive collection of geographical and historical information, making it a rich resource for data analytics. The table is part of the 'postialue_pno_meri_2021' dataset collection. This table captures the version history of its base table rows, allowing users to track changes over time. The data content covers geographical coordinates, area details, and postal codes, among other things. The geographical coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This can be utilized for geospatial data analytics. For instance, one could use this data to analyze changes in area names over...

Column Descriptions

2021 Postal Code Areas Extending to Sea Regions - Data Table

Column Type Comment
_extract_date date This column contains the date when the data on the row was extracted from the source. It plays a crucial role in tracking the data extraction history.
_row_number long This column contains the row number in the data extracted from the source on the specific extract date. It works in combination with '_extract_date' to uniquely identify each row.
geom_geojson string This column stores the geographical data in GeoJSON format which represents simple geographical features.
geom_geotext string This column holds the geographical data in text format.
geom_type string This column specifies the type of the geographical data.
geom_centroid string This column contains the centroid point of the geographical data.
geom_center_x double This column holds the x-coordinate of the center of the geographical data.
geom_center_y double This column holds the y-coordinate of the center of the geographical data.
gml_id string This column holds the unique identifier for each row.
kunta string This column contains the municipality code.
kuntanro long This column holds the municipality number.
namn string This column contains the Swedish name for the municipality.
nimi string This column holds the Finnish name for the municipality.
objectid long This column contains the object's identifier.
pinta_ala long This column holds the surface area of the municipality.
posti_alue string This column contains the postal area code.
vuosi long This column holds the year of the data.

Historical Versioning of Paavo Postal Areas Extending to Sea Areas 2021

Column Type Comment
_start_date date This column contains the date when the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number' column for each row in this history table.
_end_date date This column contains the date when a new version of the row was extracted from the data source. If this column contains a null value, it means that the row is the most recent version.
_row_number long This column contains the row number from the raw data extracted from the data source. It forms a unique identifier in combination with the '_start_date' column for each row in this history table.
geom_geojson string This column contains the geojson representation of the geography of the area.
geom_geotext string This column contains the textual representation of the geography of the area.
geom_type string This column specifies the type of the geographical representation, for example, polygon.
geom_centroid string This column contains the geographical point that represents the center of the area.
geom_center_x double This column contains the x-coordinate of the center of the area.
geom_center_y double This column contains the y-coordinate of the center of the area.
gml_id string This column contains the unique identifier of the row in the data source.
kunta string This column contains a string representation of the municipality code.
kuntanro long This column contains the numerical code of the municipality.
namn string This column contains the name of the area in Swedish.
nimi string This column contains the name of the area in Finnish.
objectid long This column contains the unique object identifier.
pinta_ala long This column contains the area size in square meters.
posti_alue string This column contains the postal area code.
vuosi long This column contains the year when the data was collected.

Additional Info

Last Updated November 11, 2024
Created November 11, 2024