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

2016 Postal Area Marine Statistical Interface Collection

The dataset collection in question is a compilation of related data tables sourced from the website of Tilastokeskus (Statistics Finland) in Finland. The collection encompasses a broad range of data, organized into a table format with various columns and rows for easy reference. The information provided in this collection stems from the Statistics Finland's service interface, shedding light on a multitude of statistical data and insights relevant to the year 2016. Please note that the dataset collection's specifics and contents might require further exploration for a detailed understanding. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

  • 2016 Coastal Area Postal Codes: An Organized Collection of Geometrical and Demographical DataTSV

    The table, which is a part of the dataset 'postialue_pno_meri_2016', gathers comprehensive data relevant to postal areas extending to marine areas in Finland, as sourced from the Finnish Statistics Bureau ('Tilastokeskus'). The data fields in the table can be broadly categorized into three groups: extraction details, geographic data, and postal area specifics. The extraction details contain two columns, one indicating the date when the data row was extracted, and the other specifying the row number of the data as extracted from the source. These two fields combined uniquely identify each row of data. The geographic data is represented by a collection of columns that start with 'geom_'. These fields encompass various geospatial data points such as geographic coordinates and geotext,...

  • Version History of Paavo Postal Code Areas (Extending to Sea Areas) 2016TSV

    The 'table__history' is a comprehensive collection of historic data that keeps track of the changes over time. This history table belongs to the 'postialue_pno_meri_2016' dataset and is vital for data analysis as it allows tracking of changes and trends over time. It contains geographic information that can be utilized for geospatial data analytics, presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The table reflects the version history of the base table rows, containing unique identifiers for each row, formed by a combination of the start date and the row number. Each row of data is marked with a start date, indicating when the row was extracted from the data source. The end date, on the other hand, signifies when a new...

Column Descriptions

2016 Coastal Area Postal Codes: An Organized Collection of Geometrical and Demographical Data

Column Type Comment
_extract_date date This column records the date when the data on the row was extracted from the data source. It is one of the two special columns that uniquely identifies each row of data in the table.
_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's the other special column that helps in uniquely identifying each row.
geom_geojson string This column represents the geographic data of the postal area in a geojson format, which is a format for encoding geographical data structure.
geom_geotext string This column contains the geographical data in geotext format. It represents the same data as in the 'geom_geojson' column but in a different format.
geom_type string This column specifies the type of the geographical data structure provided in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid string This column provides the geographical point that represents the centroid of a geographical area.
geom_center_x double This column gives the x-coordinate of the centroid of a geographical area.
geom_center_y double This column gives the y-coordinate of the centroid of a geographical area.
gml_id string This is an identifier column that contains unique identifiers for each row in the table.
kunta string This column contains the municipality code in Finland.
kuntanro long This column contains the municipality number, which is similar to the 'kunta' column.
namn string This column contains the name of the postal area in Swedish language.
nimi string This column contains the name of the postal area in Finnish language.
pinta_ala double This column represents the area size of the postal region.
posti_alue string This column contains the postal area code.
shape_star double This column represents the area of the shape of the postal region.
shape_stle double This column provides the length of the boundary of the postal region.
vuosi long This column represents the year when the data row was recorded.

Version History of Paavo Postal Code Areas (Extending to Sea Areas) 2016

Column Type Comment
_start_date date This column records the date when the row was extracted from the data source, helping to track the version history of the base table rows. For example, a date could be '2024-11-11'.
_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 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. It forms a unique identifier for each row in combination with the '_start_date' column.
geom_geojson string This column contains the geographical information in GeoJSON format. It represents the geographical features of the area.
geom_geotext string This column holds geometric data as text, which represents the geographical features of the area.
geom_type string This column specifies the type of geometric data present in the row. It could, for example, be 'ST_MULTIPOLYGON'.
geom_centroid string This column contains the geographical coordinates of the centroid of the area.
geom_center_x double This column includes the x-coordinate of the geographical center of the area.
geom_center_y double This column includes the y-coordinate of the geographical center of the area.
gml_id string This column contains a unique identifier for each row, as provided by the source.
kunta string This column holds the identifier for the municipality which the row represents.
kuntanro long This column includes a numerical identifier for the municipality.
namn string This column contains the name of the area, possibly in a local language.
nimi string This column holds the name of the area, possibly in another local language.
pinta_ala double This column provides the area of the region in square meters.
posti_alue string This column includes the postal code of the area.
shape_star double This column represents the area of the shape of the geographical entity.
shape_stle double This column indicates the perimeter of the shape of the geographical entity.
vuosi long This column records the year the data was collected, for instance, '2016'.

Additional Info

Last Updated November 11, 2024
Created November 11, 2024