2019 Postal Area Data Collection

The dataset collection in question consists of a group of interrelated data tables obtained from the 'Tilastokeskus' (Statistics Finland) website in Finland. These tables contain valuable information that is organized in an easy-to-understand table format, with clearly defined columns and rows. The dataset compiled from this source is especially useful for those seeking to gain insights from the 'Tilastokeskus' service interface (WFS). This dataset collection will serve as a rich source of data for various research and analytical purposes. 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 Paavo Postal Areas Extending to Marine Regions Data TableTSV
The table is a detailed compilation of geo-related data extending to sea areas for the year 2019. It forms a part of a comprehensive dataset that hosts a variety of tables with similar data. The data in this table was sourced from the Statistics Finland (Tilastokeskus) website, based in Finland. The table is composed of several columns, each hosting unique data that plays an important role in data analytics. For instance, two special columns, one containing the date of data extraction and the other hosting the row number from the extracted data, together form a unique identifier for each row. This ensures that each data entry can be traced back to its source extraction date, and its position in that extraction. The table also contains numerous columns with geographic data that can be...
Version History of Paavo Postal Code Areas Extending to Sea Areas, 2019TSV
The 'table__history' is a history table that keeps track of the version history of its base table rows. It's part of a larger dataset collection that focuses on postal areas extending to sea areas in 2019, sourced from the 'Statistics Finland' (Tilastokeskus) website. The table contains various columns providing a diverse range of data. It includes columns that provide geographic information, which can be utilized for geospatial data analytics. This geographic information is presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. For example, the 'geom_centroid' column provides a geographic point that represents the centroid of the postal areas. The table also includes columns that capture the row's version history. The...

Column Descriptions

2019 Paavo Postal Areas Extending to Marine Regions Data Table

Column	Type	Comment
_extract_date	date	The date when the data on the row of the table was extracted from the data source.
_row_number	long	The row number in the data extracted from the source on the extract date specified by the '_extract_date' column. The combination of '_extract_date' and '_row_number' uniquely identifies each row.
geom_geojson	string	Contains geographical data in GeoJSON format representing multipolygon geometries.
geom_geotext	string	Contains geographical data in text format also representing multipolygon geometries.
geom_type	string	Specifies the type of the geometry represented in 'geom_geojson' and 'geom_geotext' columns. In this case, the type is ST_MULTIPOLYGON, indicating the data represents a multipolygon.
geom_centroid	string	Provides the centroid coordinates of the multipolygon geometries.
geom_center_x	double	The x-coordinate (longitude) of the centroid of the multipolygon geometries.
geom_center_y	double	The y-coordinate (latitude) of the centroid of the multipolygon geometries.
gml_id	string	A unique identifier for each row in the dataset.
kunta	string	Municipality code represented in string format.
kuntanro	long	Municipality code represented in numeric format.
namn	string	Name of the location in the source language.
nimi	string	Name of the location translated into a different language.
objectid	long	An identifier for each object in the table.
pinta_ala	double	The area of the location, likely in square meters.
posti_alue	string	The postal code area for the location.
shape_leng	double	The perimeter length of the multipolygon geometries.
vuosi	long	Year associated with the data.

Version History of Paavo Postal Code Areas Extending to Sea Areas, 2019

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source.
_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 extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson	string	This column contains geospatial data in GeoJSON format, which describes the geographical features related to the row.
geom_geotext	string	This column contains geospatial data in textual format, which describes the geographical features related to the row.
geom_type	string	This column indicates the type of the geospatial data stored in the row.
geom_centroid	string	This column contains the centroid of the geospatial feature described in the row.
geom_center_x	double	This column contains the x-coordinate of the center of the geospatial feature.
geom_center_y	double	This column contains the y-coordinate of the center of the geospatial feature.
gml_id	string	This column contains the unique identifier of the row in GML format.
kunta	string	This column contains a string representation of the municipality number.
kuntanro	long	This column contains the municipality number as an integer.
namn	string	This column contains the name of the postal area in the local language.
nimi	string	This column contains the name of the postal area.
objectid	long	This column contains the unique identifier of the row.
pinta_ala	double	This column contains the surface area.
posti_alue	string	This column contains the postal code.
shape_leng	double	This column contains the length of the shape's boundary.
vuosi	long	This column contains the year related to the row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024