2015 Postal Area Data Collection from Finland Statistics Interface

The dataset collection in question gathers related data tables sourced from the website of Tilastokeskus (Statistics Finland), based in Finland. The data tables within this collection are associated with detailed statistical data provided through the Tilastokeskus service interface. The information is organized into a structured format of rows and columns, facilitating a clear understanding and analysis of the data. This specific collection is particularly relevant for those interested in the postal area statistics of 2015. 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 2015TSV
The table in question forms a part of a larger dataset collection and provides detailed insights into postal code areas as of 2015, as sourced from 'Tilastokeskus' (Statistics Finland), a website based in Finland. Each row in the table corresponds to unique data extracted from the source, with specifics about the extraction date and the row number encapsulated within specially designated columns. This data, when combined, ensures that each row can be distinctly identified. The table is rich in geographic data, with multiple columns dedicated to providing comprehensive geographic information. This data can be applied in geospatial data analytics, with geographic coordinates presented using the WGS 84 coordinate reference system. This system ensures that coordinates are recorded with the...
Version History of Postal Code Areas 2015TSV
The 'table__history' is a historical record of the 'Paavo-postinumeroalueet 2015' dataset, originally sourced from the Statistics Finland (Tilastokeskus) website. This dataset captures geographic and demographic information related to Finnish postal areas for the year 2015. The table includes a variety of geographic data columns, like 'geom_geojson', 'geom_geotext', and 'geom_type', that can be used for geospatial analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with longitude preceding latitude. The table also includes information like area names ('namn', 'nimi'), area codes ('kunta', 'kuntanro', 'posti_alue'), and area size ('pinta_ala'). Additionally, there are columns like 'shape_star' and 'shape_stle' that provide more specific...

Column Descriptions

Paavo Postal Code Areas 2015

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the data 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 the geographical data of the area in GeoJSON format, a type of format for encoding geographic data structures.
geom_geotext	string	This column contains the geographical data of the area in text format.
geom_type	string	This column specifies the type of the geographical data.
geom_centroid	string	This column contains the coordinates of the geographical center of the area.
geom_center_x	double	This column contains the x-coordinate of the geographical center of the area.
geom_center_y	double	This column contains the y-coordinate of the geographical center of the area.
gml_id	string	This column contains a unique identifier for each record.
kunta	string	This column contains a string representation of the municipality code.
kuntanro	long	This column contains the municipality number as an integer.
namn	string	This column contains the name of the area in Swedish.
nimi	string	This column contains the name of the area in Finnish.
pinta_ala	double	This column contains the surface area of the geographical area.
posti_alue	string	This column contains the postal code of the area.
shape_star	double	This column contains the total area of the geographical shape.
shape_stle	double	This column contains the perimeter length of the geographical shape.
vuosi	long	This column contains the year when the data was collected.

Version History of Postal Code Areas 2015

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source.
_end_date	date	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	The number of the row in the raw data. Together with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson	string	Contains the geometry of the postal area in the GeoJSON format.
geom_geotext	string	Contains the geometry of the postal area in text format.
geom_type	string	Specifies the type of geometry used.
geom_centroid	string	Contains the centroid of the geometry.
geom_center_x	double	The X-coordinate of the center of the geometry.
geom_center_y	double	The Y-coordinate of the center of the geometry.
gml_id	string	The unique identifier of the postal area.
kunta	string	Contains the code of the municipality where the postal area is located.
kuntanro	long	The number of the municipality where the postal area is located.
namn	string	The name of the location in Swedish.
nimi	string	The name of the location in Finnish.
pinta_ala	double	The area of the postal area in square meters.
posti_alue	string	The postal code of the area.
shape_star	double	Contains the shape area of the postal region.
shape_stle	double	Contains the shape length of the postal region.
vuosi	long	The year when the data was collected.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024