2018 Postal Area Data Tables

The dataset collection in question is a compilation of related data tables sourced from the website of Tilastokeskus (Statistics Finland), based in Finland. These tables provide a wealth of information, the specifics of which are defined by the data source as 'Tilastokeskuksen palvelurajapinta (WFS)', translated to English as 'Statistics Finland's Service Interface (WFS)'. This implies that the data provided is likely to be statistical in nature, possibly offering valuable insights into various aspects of Finnish demographics, economics, or other statistical categories. The comprehensive nature of this dataset collection makes it a rich resource for in-depth analysis and research. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2018 Postal Code Areas in FinlandTSV
The table is an integral part of the dataset collection named 'postialue_pno_2018'. It contains vital data that encompasses the Paavo postal code areas for the year 2018, which is a unique feature indicating the table's relevance to postal services in Finland. The table is structured with several columns, each serving a definitive purpose. Special columns such as 'extract_date' and '_row_number' provide information on when data was extracted and the specific row number in the extracted data, respectively. This combination helps to uniquely identify each row in the table. Columns starting with 'geom' contain geographic data useful for geospatial data analytics. For instance, geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order of...
Version History of Postal Code Areas 2018TSV
The history table is a comprehensive collection of data, offering a detailed perspective of its base table rows over time. Its contents are derived from 'Paavo-postinumeroalueet 2018', which translates to 'Paavo Postal Code Areas 2018'. This information is vital in understanding the evolution of postal code areas over time in Finland, as sourced from the 'Statistics Finland' (Tilastokeskus) website. The table incorporates an array of columns, each contributing to the richness of the data. Some columns provide geographic information valuable for geospatial data analytics, all presented using the WGS 84 coordinate reference system, with longitude first, followed by latitude. Examples include 'geom_geojson' and 'geom_geotext', which contain geographic data in geojson and geotext formats,...

Column Descriptions

2018 Postal Code Areas in Finland

Column	Type	Comment
_extract_date	date	The date when the data on the row was extracted from the source.
_row_number	long	The row number in the data extracted from the source on the specified extract date. It, combined with '_extract_date', uniquely identifies each row.
geom_geojson	string	Contains complex geographical data in GeoJSON format, representing different types of geographic shapes.
geom_geotext	string	This holds the text representation of the geographic shape data.
geom_type	string	Specifies the type of the geographical shape. For example, 'ST_MULTIPOLYGON' indicates a shape that includes multiple polygons.
geom_centroid	string	The geographical point that represents the centroid of the given geographic shape.
geom_center_x	double	The x-coordinate of the center point of the geographic shape.
geom_center_y	double	The y-coordinate of the center point of the geographic shape.
gml_id	string	A unique identifier for each row in the table.
kunta	string	A coded value representing the municipality where the geographic shape is located.
kuntanro	long	The number associated with the municipality.
namn	string	The Swedish name of the location represented by the geographic shape.
nimi	string	The Finnish name of the location represented by the geographic shape.
objectid	long	A unique identifier for each object in the dataset.
pinta_ala	double	The area of the geographic shape in square meters.
posti_alue	string	The postal code area that the geographic shape belongs to.
shape_leng	double	The length of the perimeter of the geographic shape.
vuosi	long	The year the data was collected.

Version History of Postal Code Areas 2018

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source, which allows tracking the version history of the data. It forms a unique pair with the '_row_number' to identify each row in the history table.
_end_date	date	This column records the date when a new version of the row was extracted from the data source. A null value in this column indicates that the row is the most recent version of the data.
_row_number	long	This column contains the number of the row in the raw data extracted from the source, and together with '_start_date', it uniquely identifies each row in the history table.
geom_geojson	string	This column stores the geometric data of the area in GeoJSON format, a popular open standard format designed for representing simple geographical features.
geom_geotext	string	This column contains the geometric data of the area in text format, which provides a human-readable representation of the geographical features.
geom_type	string	This column specifies the type of the geometry represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column holds the coordinates of the centroid, or geometric center, of the area.
geom_center_x	double	This column contains the x-coordinate of the geometric center of the area.
geom_center_y	double	This column contains the y-coordinate of the geometric center of the area.
gml_id	string	This column is a unique identifier for each row in the table.
kunta	string	This column contains a code representing the municipality where the area is located.
kuntanro	long	This column contains a number associated with the municipality.
namn	string	This column holds the name of the area in Swedish.
nimi	string	This column contains the name of the area in Finnish.
objectid	long	This column is a unique identifier for the row, similar to 'gml_id'.
pinta_ala	double	This column records the area of the region in square meters.
posti_alue	string	This column contains the postal code associated with the area.
shape_leng	double	This column records the length of the boundary of the area.
vuosi	long	This column contains the year when the data was recorded.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024