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

2017 Postal Area and Sea Statistical Interface

The dataset collection in question is a comprehensive compilation of tables, sourced from the website of 'Tilastokeskus' (Statistics Finland), a reputable data source in Finland. These tables constitute a related set of data, organized in a tabular format with columns and rows. The dataset is characterized by its detailed information from the 'Tilastokeskus' service interface (WFS). This dataset collection provides a breadth of insights and could be an invaluable tool for research and analysis. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

  • Paavo Postal Code Areas Extending to Sea Areas - 2017TSV

    The table under consideration belongs to a dataset collection which extends to marine areas in 2017, as per the information provided by the source, 'Tilastokeskus' (Statistics Finland). This table contains various types of data, including geographical information and unique identifiers for each row of data. It encompasses a wide variety of fields such as geographic coordinates, area codes, and names of specific regions, providing a rich source of information for various types of data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This enables the data to be utilized for geospatial data analytics, for instance, to map the distribution of different postal areas across...

  • Version History of Paavo Postal Code Areas (Extending to Marine Areas) - 2017TSV

    The 'table__history' is a historical table that is part of a larger dataset collection related to Finnish postal code areas extending to marine areas in 2017. The table captures the version history of its base table rows, thus allowing for the tracking of changes over time. This is achieved through the use of special columns, such as '_start_date', '_end_date', and '_row_number', which provide information on when the row was extracted and the unique identifier of each row. For instance, if the '_end_date' is null, it signifies that the row is the most current version. The table also encompasses a variety of other columns that provide detailed geographical insights. These include coordinates in the WGS 84 coordinate reference system, with axis order longitude first, followed by...

Column Descriptions

Paavo Postal Code Areas Extending to Sea Areas - 2017

Column Type Comment
_extract_date date This column records the date when the data on a particular row was extracted from the data source. It serves as a record of when the data was last updated.
_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'. It helps to uniquely identify each row in the table.
geom_geojson string This column stores the geometric data of the postal areas in a GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures.
geom_geotext string This column contains the geometric data of the postal areas in a textual format. It provides a human-readable representation of the geographic data.
geom_type string This column specifies the type of the geometrical object. In this table, the type is ST_MULTIPOLYGON, indicating that the geometric data represents a complex shape with multiple boundaries.
geom_centroid string This column holds the geographic coordinates of the centroid (geometric center) of the postal areas. It represents the center point of each area.
geom_center_x double This column contains the x-coordinate of the centroid of the postal areas. It represents the longitude of the center point.
geom_center_y double This column contains the y-coordinate of the centroid of the postal areas. It represents the latitude of the center point.
gml_id string This is a unique identifier associated with each postal area. It helps to uniquely identify each postal area.
kunta string This column stores the municipality code. It represents the specific municipality that the postal area belongs to.
kuntanro double This column holds the municipality number. It is another way to identify the municipality that a postal area is part of.
namn string This column contains the name of the postal area. It provides a human-readable identifier for each area.
nimi string This column holds the name of the postal area. It is similar to 'namn', and gives a human-readable identifier for each area.
objectid double This column contains a unique identifier for each row in the table. It helps to uniquely identify each record in the table.
pinta_ala double This column holds the surface area of the postal area. It provides information about the size of each area.
posti_alue string This column stores the postal code of the area. It provides a way to identify the postal area.
vuosi double This column records the year when the data was collected. It provides information about the timeframe of the data.

Version History of Paavo Postal Code Areas (Extending to Marine Areas) - 2017

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 this version history table.
_end_date date This column contains the date when a new version of the row was extracted from the data source. A null value 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. Along with '_start_date', it forms a unique identifier for each row in this version history table.
geom_geojson string This column contains the geographical data of the row in GeoJSON format, a type of format for encoding a variety of geographic data structures.
geom_geotext string This column contains the geographical data of the row in text format.
geom_type string This column specifies the type of geographical data stored in the geom_geojson and geom_geotext columns. In this case, it is 'ST_MULTIPOLYGON', indicating that the data represents multiple polygonal areas.
geom_centroid string This column contains the geographical center point of the row's geographical area, represented as a point in space.
geom_center_x double This column contains the x-coordinate of the geographical center point of the row's geographical area.
geom_center_y double This column contains the y-coordinate of the geographical center point of the row's geographical area.
gml_id string This is a unique identifier for each row.
kunta string This column contains a code representing the municipality in which the row's geographical area is located.
kuntanro double This column contains a number representing the municipality in which the row's geographical area is located.
namn string This column contains the name of the row's geographical area in the local language.
nimi string This column contains the name of the row's geographical area in Finnish.
objectid double This is a unique identifier for each row.
pinta_ala double This column contains the surface area of the row's geographical area, measured in square meters.
posti_alue string This column contains the postal code of the row's geographical area.
vuosi double This column contains the year when the data of the row was recorded.

Additional Info

Last Updated November 12, 2024
Created November 11, 2024