Statistics Finland Service Interface (WFS) - Dataset Collection 2020

This dataset collection is a compilation of data tables sourced from the website of 'Tilastokeskus' (Statistics Finland), a reputable organization residing in Finland. The collection comprises of several tables, each of which houses a unique set of data that is interrelated and organized in a tabular structure, including columns and rows for easy comprehension and analysis. The information provided by the data source, 'Tilastokeskuksen palvelurajapinta (WFS)' translates to 'Statistics Finland's service interface (WFS)'. This indicates that the dataset collection includes data that is likely to be statistical in nature and useful for various data analysis and research purposes. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Regional Administrative Agency Areas 2020 (1:4 500 000)TSV
The table in focus, an integral part of a specific dataset collection, contains data pertaining to the AVI regions for the year 2020 at a scale of 1:4 500 000. These regions are represented by identifiable codes. This table offers valuable insights into geographic information, making it a useful tool for geospatial data analytics. Each row of data contains an extraction date, offering a snapshot of the data as it existed at that specific point in time. The row number, in combination with the extraction date, provides a unique identifier for each row. The geographic coordinates are presented in the WGS 84 coordinate reference system, with longitude listed before latitude. The table houses a variety of other data columns, which include the specific AVI region code, the geographic details...
Version History of AVI Regions 2020 (1:4 500 000)TSV
The table 'table__history' is a historical record that is part of the dataset collection 'tilastointialueet_avi4500k_2020'. This table provides valuable insights into the version history of its base table rows, presenting a chronological sequence of data from the time it was extracted until a new version of the row was generated. This is particularly useful in tracing the evolution of data over time. The table features a unique identification system for each row, formed by the combination of the start date and row number of the data extraction. The table also includes columns for geographic information which can be utilized for geospatial data analytics. The geographic coordinates used in these columns are presented using the WGS 84 coordinate reference system, with axis order longitude...

Column Descriptions

Regional Administrative Agency Areas 2020 (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 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'.
avi	string	This column contains numerical identifiers, possibly representing different administrative divisions.
geom_geojson	string	This column contains geographical data in the form of GeoJSON, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geographical data in text format, presumably describing the shapes of geographical features.
geom_type	string	This column specifies the type of the geographical data stored, such as Polygon or MultiPolygon.
geom_centroid	string	This column contains the geographical coordinates of the centroid, or geometric center, of the data in the row.
geom_center_x	double	This column contains the X-coordinate of the geometric center of the data in the row, typically representing longitude.
geom_center_y	double	This column contains the Y-coordinate of the geometric center of the data in the row, typically representing latitude.
gml_id	string	This column contains unique identifiers for the data rows, presumably used in the Geographic Markup Language (GML) format.
id	long	This column contains numerical identifiers for the data rows.
name	string	This column contains the names of administrative divisions in English.
namn	string	This column contains the names of administrative divisions in Swedish.
nimi	string	This column contains the names of administrative divisions in Finnish.
vuosi	long	This column contains the year associated with the data in the row.

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

Column	Type	Comment
_start_date	date	This column contains the date when a row was extracted from the data source. This column, along with '_row_number', uniquely identifies each row in the history table.
_end_date	date	This column has the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version.
_row_number	long	This is the number of the row in the raw data extracted from the data source. It forms a unique identifier in combination with the '_start_date' column.
avi	string	This column contains a string identifier related to the dataset.
geom_geojson	string	This column contains geospatial data in GeoJSON format, providing spatial representation for the data row.
geom_geotext	string	This column contains geospatial data in text format, offering another way to represent the spatial data.
geom_type	string	This column specifies the type of the geospatial data represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the central point of the geospatial data.
geom_center_x	double	This column has the X-coordinate of the geospatial data's center.
geom_center_y	double	This column holds the Y-coordinate of the geospatial data's center.
gml_id	string	This column contains a unique string identifier for the row.
id	long	This column contains an integer identifier for the row.
name	string	This column contains the English name for the data row.
namn	string	This column contains the name for the data row in another language.
nimi	string	This column contains the name for the data row in another language.
vuosi	long	This column contains an integer representing the year related to the data row.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024