Statistics Centre Service Interface (WFS) - Dataset Collection 2015

The dataset collection under discussion comprises a series of related data tables, which are sourced from 'Tilastokeskus' (Statistics Finland), a website based in Finland. These tables are organized in an easy-to-understand format, with data displayed in rows and columns for convenient interpretation. They provide a valuable statistical service interface, as indicated by the data source. This interface is particularly useful for those who require in-depth and comprehensive statistics. The dataset collection is noteworthy for its meticulous arrangement and the breadth of data it offers, making it an essential resource for those requiring detailed 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

Statistical Areas 2015 - Overview (Scale 1:4,500,000)TSV
The table in question hails from the dataset collection 'tilastointialueet_avi4500k_2015' and contains a wealth of information relating to the AVI-areas for the year 2015 at a scale of 1:4,500,000. This data has been sourced from 'Tilastokeskus' (Statistics Finland) website, located in Finland. The table contains a multitude of columns, each providing unique insights into the dataset. Two of these columns, 'extract_date' and '_row_number', are particularly noteworthy. The former provides the date when the data was extracted from the source, while the latter signifies the row number in the data extracted on that specific date. Together, they uniquely identify each row in the table. In addition to this, the table contains columns starting with 'geom' that hold geographic information,...
Version History of AVI Regions 2015 (1:4 500 000) TableTSV
The table in focus is a historical table that contains an organized collection of related data, specifically, the version history of its base table rows. It originates from the 'Tilastokeskus' (Statistics Finland) website in Finland. This historical table is a part of a larger dataset collection, which consists of one or more related tables. The content of the table is derived from the 2015 AVI areas at a 1:4 500 000 scale. AVI stands for 'alueviranomainen', which is Finnish for regional administration. These areas are represented through a variety of columns that contain detailed information about each row. The table includes special columns: '_start_date', '_end_date', and '_row_number'. These columns provide valuable information about the extraction and version history of each row....

Column Descriptions

Statistical Areas 2015 - Overview (Scale 1:4,500,000)

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. It is a part of the unique identifier for each row in combination with the '_row_number' column.
_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 forms a unique identifier for each row in combination with the '_extract_date' column.
avi	string	This column contains a string representative of an administrative division.
geom_geojson	string	This column contains geometric data in GeoJSON format, typically representing geographical features.
geom_geotext	string	This column contains geometric data in text format, specifically in the form of multiple polygons.
geom_type	string	This column specifies the type of geometry represented in the 'geom_geojson' column. The column only contains the value 'ST_MULTIPOLYGON', indicating that the data is composed of multiple polygons.
geom_centroid	string	This column contains the central point of the geographical feature represented by the geometry data.
geom_center_x	double	This column contains the x-coordinate of the central point of the geographical feature represented by the geometry data.
geom_center_y	double	This column contains the y-coordinate of the central point of the geographical feature represented by the geometry data.
gid	long	This column contains an integer value, likely serving as an identifier.
gml_id	string	This column contains a string value, likely serving as another form of identifier.
name	string	This column contains the English names of the geographical areas represented in the data.
namn	string	This column contains the names of the geographical areas in a different language, likely Swedish or Finnish.
nimi	string	This column contains the names of the geographical areas in another language, likely Finnish.
shape_star	double	This column contains a real number, possibly representing an area or other geometric measurement associated with the geographical feature.
shape_stle	double	This column contains a real number, possibly representing a perimeter or other geometric measurement associated with the geographical feature.
vuosi	double	This column contains a real number, likely representing a year, as suggested by the sample value 2015.0.

Version History of AVI Regions 2015 (1:4 500 000) Table

Column	Type	Comment
_start_date	date	This column represents the date when the row was extracted from the data source. It is part of the combination with '_row_number' that uniquely identifies each row in this history table.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If the value of this column 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. It is used in conjunction with '_start_date' to uniquely identify each row in this version history table.
avi	string	This column holds a string value representing a certain classification or category.
geom_geojson	string	This column stores the geometric configuration of the area in GeoJSON format which is a geospatial data interchange format based on JavaScript Object Notation (JSON).
geom_geotext	string	This column contains the geometric configuration of the area in text format. This can be used for visual representations or analytics.
geom_type	string	This column indicates the type of the geometry stored in the 'geom_geojson' and 'geom_geotext' columns. The value is 'ST_MULTIPOLYGON' indicating that the geometry is a multipolygon.
geom_centroid	string	This column holds the geographical point that represents the center of the area's geometry.
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.
gid	long	This column holds an integer value which serves as a unique identifier for the area.
gml_id	string	This column contains a unique string identifier for the row.
name	string	This column stores the English name of the area.
namn	string	This column holds the name of the area in another language.
nimi	string	This is another column that stores the name of the area but in a different language.
shape_star	double	This column contains a real number which might represent a certain property of the area's shape.
shape_stle	double	This column holds a real number which could represent another property of the area's shape.
vuosi	double	This column stores a real number which seems to represent a specific year.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024