Statistics Service Interface (WFS) - 2017 Data Tables Collection

This dataset collection is a comprehensive compilation of various related tables, all sourced from the Statistics Finland (Tilastokeskus) website, based in Finland. The data tables are organized in a structured manner with rows and columns, providing an efficient way to manage and analyze the data. The dataset description from the data source, translated to English, refers to this as the 'Statistical Service Interface (WFS)'. This implies that this collection is utilized to provide statistical services, possibly for analytical and research purposes. The tables included in this collection are all interconnected, providing a rich, multifaceted view of the 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

AVI Regions 2017 Scaled 1:1,000,000 Data TableTSV
The table, part of a dataset collection, encapsulates valuable information about the AVI areas in 2017, as per the data source. It includes diverse data fields, each holding unique information. For instance, the date when the data row was extracted and the row number from the source are included, providing a unique identifier for each row. Furthermore, the table contains geographic data, useful for geospatial analytics, represented in the WGS 84 coordinate reference system with axis order longitude first, followed by latitude. This geospatial data includes information such as geojson and geotext, along with the centroid and the X and Y coordinates of the center of the geometry. The table also contains identifiers, names in various languages, and the year of the data. Sourced from the...
Version History of AVI Regions 2017 (1:1 000 000) - Historical Data RecordsTSV
The 'table__history' is a part of a dataset collection that chronologically organizes data related to AVI areas in 2017. It is an enriched version of its base table, providing additional information about the temporal validity of each row. Moreover, it contains geographic data, which can be very valuable for geospatial data analytics. The table comprises a unique combination of columns, which help in identifying each row individually. This combination is formed by a start date, indicating when the row was extracted from the data source, and a row number that represents the position of the row in the raw data extracted from the source. There is also an end date, providing information about when a new version of the row was extracted. If this column shows a null value, it indicates that...

Column Descriptions

AVI Regions 2017 Scaled 1:1,000,000 Data Table

Column	Type	Comment
_extract_date	date	This column records the date on which the data row was extracted from the original data source.
_row_number	long	This column contains the row number of the data extracted from the source on the extraction date specified by the '_extract_date' column. The combination of '_extract_date' and '_row_number' uniquely identifies each row.
avi	string	This column holds a string value that represents a specific identifier.
geom_geojson	string	This column contains GeoJSON data, which is used to represent simple geographical features.
geom_geotext	string	This column contains geometric data in text form.
geom_type	string	This column indicates the type of geometric data represented.
geom_centroid	string	This column stores the centroid or geometric central point of the data.
geom_center_x	double	This column records the X-coordinate of the geometric center point.
geom_center_y	double	This column records the Y-coordinate of the geometric center point.
gid	long	This column contains an integer value that serves as a unique identifier.
gml_id	string	This column contains a string value that serves as an identifier.
name	string	This column holds the name in English of the entity represented in the data row.
namn	string	This column contains the name in Swedish of the entity represented in the data row.
nimi	string	This column holds the name in Finnish of the entity represented in the data row.
vuosi	double	This column records the year associated with the data row.

Version History of AVI Regions 2017 (1:1 000 000) - Historical Data Records

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It forms a unique identifier in combination with '_row_number'.
_end_date	date	This column contains 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	This column contains the number of the row in the raw data extracted from the data source. It forms a unique identifier in combination with '_start_date'.
avi	string	This column contains a string representation of a unique identifier for the administrative division.
geom_geojson	string	This column contains the geographical data in GeoJSON format representing the boundaries of the administrative division.
geom_geotext	string	This column contains the geographical data in text format representing the boundaries of the administrative division.
geom_type	string	This column contains the type of geographical data stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the central point of the geographical area of the administrative division.
geom_center_x	double	This column contains the X-coordinate of the central point of the geographical area of the administrative division.
geom_center_y	double	This column contains the Y-coordinate of the central point of the geographical area of the administrative division.
gid	long	This column contains an integer representation of a unique identifier for the administrative division.
gml_id	string	This column contains a unique identifier for the geographical data of the administrative division.
name	string	This column contains the English name of the administrative division.
namn	string	This column contains the Finnish name of the administrative division.
nimi	string	This column contains the Swedish name of the administrative division.
vuosi	double	This column contains the year of the data entry.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024