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

2019 Postal Area Statistics from Finnish Statistical Services

The dataset collection in question is a compilation of related data tables, sourced from the 'Tilastokeskus' (Statistics Finland), a website based in Finland. The collected data is organized into specific tables, each presenting related information in a structured way, with data organized into rows and columns. The dataset is obtained from Tilastokeskus' service interface (WFS). It's important to note that the data collection is compiled in 2019, which may indicate the timeliness of the data and the relevance of the 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

  • 2019 Postal Code Areas Data (Extracted From Finnish Statistical Database)TSV

    The table, part of the 'postialue_pno_2019' dataset collection, contains a rich collection of data pertaining to the postal code areas in Finland for the year 2019. This information is sourced from 'Tilastokeskus' (Statistics Finland). The table provides a diverse range of data, from geographic data to postal area details. Geographic data is represented in multiple formats, making the table versatile for various forms of geospatial data analytics. It includes coordinates in the form of 'geom_center_x' and 'geom_center_y', which follow the WGS 84 coordinate reference system. This system orders the axis starting with longitude, then latitude. There's also the 'geom_geojson' column that provides geographic data in the GeoJSON format, and 'geom_geotext' which provides data in the WKT...

  • Version History of Postal Area Codes 2019TSV

    The table in focus, titled 'table__history', is a historical data table derived from the dataset collection 'postialue_pno_2019'. As a history table, it is designed to store the version history of its base table rows, meaning it tracks changes made over time to the data in its corresponding base table. This table is a valuable resource for examining the evolution of the postal areas in Finland, as it is sourced from the Finnish Statistical Office, 'Tilastokeskus'. Interestingly, this table is equipped with a unique set of columns that hold a variety of data. For instance, it contains columns that track when each row was extracted from the data source and when a new version of the row was extracted. This is particularly useful for maintaining data integrity and tracking changes over...

Column Descriptions

2019 Postal Code Areas Data (Extracted From Finnish Statistical Database)

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.
_row_number long This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. Together with '_extract_date', it uniquely identifies each row.
geom_geojson string This column contains the geometric representation of the postal area in GeoJSON format, a type of open standard format designed for representing simple geographical features.
geom_geotext string This column contains the geometric representation of the postal area in geotext format.
geom_type string This column specifies the type of the geometric object that is represented in 'geom_geojson' and 'geom_geotext' columns.
geom_centroid string This column contains the central point (centroid) of the geometric shape representing the postal area.
geom_center_x double This column contains the x-coordinate of the centroid of the geometric shape representing the postal area.
geom_center_y double This column contains the y-coordinate of the centroid of the geometric shape representing the postal area.
gml_id string This is a string type column, presumably an identifier for the geographical markup language (GML) representation of the postal area.
kunta string This string type column likely contains the municipality code or similar identifier for the postal area.
kuntanro long This is a 64-bit integer type column that appears to be another identifier for the municipality, perhaps a numerical one.
namn string This string type column contains the name of the postal area.
nimi string This string type column also contains the name of the postal area, perhaps in a different language or format.
objectid long This is a 64-bit integer type column that appears to be a unique identifier for each row or object in the dataset.
pinta_ala double This real type column likely refers to the area of the postal region, likely in square meters or similar unit.
posti_alue string This string type column contains the postal code or similar identifier for the postal area.
shape_leng double This real type column likely refers to the length of the perimeter of the postal area, likely in meters or similar unit.
vuosi long This 64-bit integer type column contains the year when the data in the row was recorded or became effective.

Version History of Postal Area Codes 2019

Column Type Comment
_start_date date This column contains the date when the row was extracted from the data source. It is part of a unique identifier for each row in the 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 means that the row is the most recent version.
_row_number long This column contains the number of the row in the raw data. Combined with '_start_date', it creates a unique identifier for each row in the history table.
geom_geojson string This column contains geometric data in GeoJSON format. It represents the spatial features of the row.
geom_geotext string This column contains geometric data in text format. It is another representation of the spatial features of the row.
geom_type string This column specifies the type of geometric data contained in the row, such as 'ST_MULTIPOLYGON'.
geom_centroid string This column contains the central point of the geometric data represented as a point.
geom_center_x double This column contains the X-coordinate of the central point of the geometric data.
geom_center_y double This column contains the Y-coordinate of the central point of the geometric data.
gml_id string This column contains the Global Markup Language (GML) ID, a unique identifier for each row.
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 municipality in Swedish.
nimi string This column contains the name of the municipality in Finnish.
objectid long This column contains a unique identifier for each row.
pinta_ala double This column contains the area of the municipality in square meters.
posti_alue string This column contains the postal area code for the municipality.
shape_leng double This column contains the length of the shape boundary of the municipality.
vuosi long This column contains the year of the data.

Additional Info

Last Updated November 11, 2024
Created November 11, 2024