Statistics Centre's Service Interface (WFS) Data Collection 2016

This dataset collection is a comprehensive group of related data tables, derived from the 'Tilastokeskus' (Statistics Finland) website in Finland. The tables within this collection provide a plethora of statistical data, as indicated by the service interface description from the data source. It's important to note that each table in the collection is meticulously organized in a tabular format, making it easy to understand and analyze the data provided. While the collection consists of various tables, they all share a common thread and are intrinsically linked, providing a well-rounded view of the data subject matter. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

AVI Areas 2016 (1:4 500 000) - History VersionTSV
The 'table__history' is a comprehensive historical data table that forms part of the dataset collection 'tilastointialueet_avi4500k_2016'. This table is a rich resource for tracking the version history of its base table rows, as it provides a detailed log of the data extraction process from the source, the 'Tilastokeskus' website located in Finland. The data content in this table can offer valuable insights into regional areas in Finland, specifically from the year 2016, as suggested by the source description 'AVI-alueet 2016 (1:4 500 000)', which translates to 'AVI Areas 2016 (1:4 500 000)'. The table comprises various columns related to geographical and historical information. Some columns contain the geographic information which can be utilized for geospatial data analytics, for...
Regional Administrative Agency Areas 2016 (1:4 500 000) Data TableTSV
The table in question is part of a dataset collection and contains important information about AVI regions for the year 2016, at a scale of 1:4,500,000. It is sourced from the Statistics Finland (Tilastokeskus) website, located in Finland. The data within this table is organized into various columns, each holding specific details about the data set. The table contains columns that hold geospatial data, apt for analytics that involve geographic data. For example, the geospatial data can be used to conduct spatial analysis, such as identifying regional patterns or assessing the geographical distribution of certain factors within the AVI regions. There are also columns in the table that depict the name of the regions in different languages, which could be utilized for multilingual data...

Column Descriptions

Regional Administrative Agency Areas 2016 (1:4 500 000) Data Table

Column	Type	Comment
_extract_date	date	This special column contains the date when the data on the row of the table was extracted from the data source.
_row_number	long	This special column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. Together with '_extract_date', it uniquely identifies each row.
avi	string	This column contains a string value that signifies a unique identifier.
geom_geojson	string	This column contains the geometric information of the data in GeoJSON format.
geom_geotext	string	This column contains the geometric information of the data in textual format.
geom_type	string	This column specifies the type of the geometric data.
geom_centroid	string	This column contains the centroid of the geometric data.
geom_center_x	double	This column represents the X-coordinate of the geometric center.
geom_center_y	double	This column represents the Y-coordinate of the geometric center.
gid	long	This column contains an integer that serves as a unique identifier.
gml_id	string	This column contains a string that serves as a unique identifier.
name	string	This column contains the name in English language.
namn	string	This column contains the name in a foreign language.
nimi	string	This column contains the name in another foreign language.
vuosi	double	This column contains a real number type value, likely representing a year.

AVI Areas 2016 (1:4 500 000) - History Version

Column	Type	Comment
_start_date	date	This column records the date when the row was extracted from the data source.
_end_date	date	This column logs the date when a new version of the row was extracted from the data source. If the value is null, it signifies 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.
avi	string	This string column is part of the base table and its content is not described by the source.
geom_geojson	string	This column contains GeoJSON formatted geometries.
geom_geotext	string	This column holds the textual representation of the geometries.
geom_type	string	This column specifies the type of the geometry, for example, 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the centroid of the geometry.
geom_center_x	double	This column records the X coordinate of the geometric center.
geom_center_y	double	This column captures the Y coordinate of the geometric center.
gid	long	This integer column is part of the base table and its content is not described by the source.
gml_id	string	This string column is part of the base table and its content is not described by the source.
name	string	This string column is part of the base table and its content is not described by the source.
namn	string	This string column is part of the base table and its content is not described by the source.
nimi	string	This string column is part of the base table and its content is not described by the source.
vuosi	double	This real number column is part of the base table and its content is not described by the source.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024