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

2017 Postal Area Data Collection from Finnish Statistical Interface (WFS)

The dataset collection in question originates from Finland, specifically from the 'Tilastokeskus' (Statistics Finland) website. The collection comprises of related data tables that provide up-to-date and comprehensive statistical information for the year 2017. Details within these tables are organized in a structured format, with columns and rows for easy accessibility and understanding of the data. The main focus of this dataset collection is postal area data. This may include, but is not limited to, information such as postal codes, geographical information, or population data. The exact contents of the dataset may vary, but the overall theme revolves around postal areas. The goal of this dataset collection is to provide a reliable and valuable resource for those interested in postal area statistics during the year 2017. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

  • 2017 Postal Area Statistics in Table FormatTSV

    The table in discussion is part of a dataset collection, which comprises related data tables that are structured in a table format. The data content of this table is largely centered around geographic information, with a focus on Paavo's postal code areas for the year 2017. This information is useful for carrying out geospatial data analytics, particularly with reference to postal code areas in Finland. The geographic coordinates in this table are presented using the WGS 84 coordinate reference system, where the order of axis is longitude first, followed by latitude. In terms of column descriptions, there are several columns that provide intricate details about each entry. There are columns that house geographic data in different formats such as GeoJSON and GeoText. There are also...

  • Version History of Paavo Postal Code Areas 2017TSV

    The history table is a unique data collection that captures the version history of its base table rows, which belong to the dataset collection pertaining to the Finnish Postal Codes of 2017. This table, sourced from 'Tilastokeskus' (The Statistical Bureau) in Finland, contains valuable data that can be used for various analytical purposes. The table includes information about the start and end dates of when the row was extracted from the data source. These date columns, together with the row number, create a unique identifier for each row's version history. For example, if the end date value is null, it indicates that the row is the most recent version. This feature makes the table ideal for tracking changes over time, which can be utilized in trend analysis. One of the significant...

Column Descriptions

2017 Postal Area Statistics in Table Format

Column Type Comment
_extract_date date This column contains the date when the data on the row of the table was extracted from the data source. It helps to understand when the specific data was collected.
_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'. The combination of '_extract_date' and '_row_number' uniquely identifies each row, providing a unique identifier for each record.
geom_geojson string This column contains geometric data in GeoJSON format, which is a format for encoding a variety of geographic data structures. It allows for the representation of spatial features and their non-spatial attributes.
geom_geotext string Similar to 'geom_geojson', this column contains geometric data but in a textual format. It is another way of representing spatial data.
geom_type string This column specifies the geometry type of the spatial data contained in the 'geom_geojson' and 'geom_geotext' columns. For example, it might be a polygon, line, or point.
geom_centroid string This column contains the geometric center (centroid) of the spatial element represented in the 'geom_geojson' and 'geom_geotext' columns. It is usually represented as a point.
geom_center_x double This column represents the x-coordinate of the geometric center (centroid) of the spatial element. It offers another way to represent the location of the centroid.
geom_center_y double This column represents the y-coordinate of the geometric center (centroid) of the spatial element. It complements the 'geom_center_x' column to provide a full coordinate for the centroid.
gml_id string This is a unique identifier for each record. It might be used for indexing or joining tables.
kunta string This column likely represents a code or identifier for a specific municipality or district in Finland.
kuntanro double This column seems to be a numerical identifier for a specific municipality or district, possibly correlated with the 'kunta' column.
namn string This column contains names of locations or areas, possibly in Swedish as it is one of Finland's official languages.
nimi string Similar to the 'namn' column, this column contains names of locations or areas, but likely in Finnish, another official language of Finland.
objectid double This column is another unique identifier for each record. It might be used for indexing or joining tables.
pinta_ala double This column might represent the surface area of the spatial element represented in the 'geom_geojson' and 'geom_geotext' columns.
posti_alue string This column likely represents postal code areas in Finland.
vuosi double This column likely represents the year associated with the data record.

Version History of Paavo Postal Code Areas 2017

Column Type Comment
_start_date date This column records the date when each row was extracted from the data source, serving as an important part of the unique identifier for each row in the history table.
_end_date date This column indicates the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the current row is the most recent version.
_row_number long This column contains the number of the row as it appears in the raw data extracted from the source. Together with '_start_date', it forms a unique identifier for each row in this history table.
geom_geojson string This column contains the geographical coordinates of the area in GeoJSON format, a popular format for encoding a variety of geographic data structures.
geom_geotext string This column holds the geographical coordinates of the area in text format.
geom_type string This column specifies the type of the geometry data stored in the column, typically a type of shape like 'ST_MULTIPOLYGON' for multiple polygons.
geom_centroid string This column contains the coordinates of the centroid, or geometric center, of the area.
geom_center_x double This column records the x-coordinate of the center of the geographical area.
geom_center_y double This column records the y-coordinate of the center of the geographical area.
gml_id string This column contains a unique string identifier for each row.
kunta string This column holds a code representing the municipality where the area is located.
kuntanro double This column contains numerical identifiers for the municipality.
namn string This column stores the name of the area.
nimi string This column holds the name of the area.
objectid double This is a unique real number identifier for each row.
pinta_ala double This column contains the area size of the geographical area in square meters.
posti_alue string This column holds the postal code of the area.
vuosi double This column records the year associated with the data.

Additional Info

Last Updated November 12, 2024
Created November 11, 2024