Postal Area and Sea Statistics 2022

The dataset collection is a comprehensive grouping of related tables, providing valuable data compiled from various sources. The information in this collection is derived from the Finnish web site 'Tilastokeskus' (Statistics Finland), a reputable data source known for its accurate and consistent statistical data. The dataset encompasses a wide range of information, all organized into tables for easy access and interpretation. Each table within the collection is carefully curated and structured in a format that allows for a systematic arrangement of data into rows and columns. The description provided by the data source, 'Tilastokeskus palvelurajapinta (WFS)' translates to 'Statistics Finland's service interface (WFS)', indicating that the content of this collection is relayed via an efficient service interface. This dataset collection can serve as a reliable resource for those seeking extensive and detailed information from Finnish statistical data. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2022 Version History of Paavo Postal Code Areas Extending to Marine AreasTSV
The 'table__history' is an expansive collection of data, compiled from the Finnish Statistics Bureau (Tilastokeskus), and organized into a structured format for ease of analysis. This table is part of the 'postialue_pno_meri_2022' dataset collection, and serves as a historical record, storing the version history of its base table rows. The contents of the table are primarily centered around the Paavo postal code areas, extending to marine areas, as of the year 2022. The records in the table are uniquely identified by a combination of the date the row was extracted from the data source ('_start_date') and the row number in the raw data ('_row_number'). This table also includes the '_end_date', marking when a new version of the row was extracted. Thus, allowing tracking of each row's...
Paavo Postal Code Areas (Extending to Sea Areas) - 2022 EditionTSV
The table in question is a part of a larger dataset collection and contains a comprehensive set of information related to postal zones extending to sea areas for the year 2022, sourced from 'Tilastokeskus' (Statistics Finland). The data provides various geographic details, which are vital for conducting geospatial data analytics. The geographical coordinates are presented using the WGS 84 coordinate reference system, where the longitude is presented first, followed by the latitude. The table includes a variety of columns, providing specific information. For instance, the table includes columns providing geographic information in different formats, such as GeoJSON and GeoText. These columns offer a valuable resource for mapping and visualizing the data geographically. A column is...

Column Descriptions

Paavo Postal Code Areas (Extending to Sea Areas) - 2022 Edition

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the source.
_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'.
geom_geojson	string	This column contains geojson formatted geographical data.
geom_geotext	string	This column contains geographical data in geotext format.
geom_type	string	This column specifies the type of geographical data represented in the table.
geom_centroid	string	This column contains the centroid point of the geographical area.
geom_center_x	double	This column contains the longitude of the center point of the geographical area.
geom_center_y	double	This column contains the latitude of the center point of the geographical area.
gml_id	string	This column is a unique identifier for each row in the table.
kunta	string	This column contains a unique identifier for the municipality.
kuntanro	long	This column contains the number associated with the municipality.
namn	string	This column contains the name of the geographical area in Swedish.
nimi	string	This column contains the name of the geographical area in Finnish.
objectid	long	This column contains a unique object identifier for each row in the table.
pinta_ala	long	This column contains the area size of the geographical area in square meters.
posti_alue	string	This column contains the postal code of the geographical area.
vuosi	long	This column contains the year the data was collected.

2022 Version History of Paavo Postal Code Areas Extending to Marine Areas

Column	Type	Comment
_start_date	date	This column indicates 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 records the date when a new version of the row was extracted from the data source. If the value is null, it 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. Together with '_start_date', it forms a unique identifier for each row in this version history table.
geom_geojson	string	This column contains geometric data in GeoJSON format, which represents the spatial data related to the row.
geom_geotext	string	This column holds geometric data in plaintext format, further detailing the spatial attributes of each row.
geom_type	string	This column specifies the type of the geometric data contained in the row.
geom_centroid	string	This column provides the centroid point of the geometric data associated with each row.
geom_center_x	double	This column gives the X-coordinate of the center point of the geometric data.
geom_center_y	double	This column gives the Y-coordinate of the center point of the geometric data.
gml_id	string	This is a unique identifier for each row, provided by the source.
kunta	string	This column contains municipality data related to each row.
kuntanro	long	This column holds the municipality number, further identifying each row's regional data.
namn	string	This column includes names, potentially of regions or other geographical entities, related to each row.
nimi	string	This column also contains names associated with each row, potentially differing from those in the 'namn' column.
objectid	long	This is an integer identifier provided by the source for each row.
pinta_ala	long	This column contains data on area size, potentially related to the geographic entities associated with each row.
posti_alue	string	This column holds postal area data relevant to each row.
vuosi	long	This column records the year related to each row's data.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024