Statistics Interface Tables Collection 2020

The dataset collection under consideration is a compilation of related data tables sourced from the website of 'Tilastokeskus' (Statistics Finland), located in Finland. Each table in the collection is a structured ensemble of related data, arranged in an organized manner using rows and columns. The dataset is characterized by a service interface (WFS) provided by the Statistics Finland, which forms the core description of the dataset. It is essential to note that the collection and its accompanying tables are based on statistical areas (tilastointialueet) for the year 2020, reflecting the specificity of the data they house. In essence, the dataset collection provides a comprehensive and detailed view of statistical data pertinent to various areas, fostering an in-depth understanding and facilitating thorough analysis. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Historical Versioning of ELY Areas 2020 (Scale 1:4,500,000)TSV
The 'table__history' is a history table that forms part of a dataset collection named 'tilastointialueet_ely4500k_2020'. This table contains data about ELY areas in 2020 at a scale of 1:4,500,000. This information is sourced from the 'Tilastokeskus' (Statistics Finland) website based in Finland. The table holds the version history of its base table rows, including information about when each row was extracted from the data source and when a new version of the row was extracted. If the end date for a row is null, this indicates that the row is the most recent version. Geographic coordinates, presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude, are included in this table. The data stored in this table can be utilized in various...
Regional Development Areas (ELY) in Finland, 2020 (Scale: 1:4 500 000)TSV
The table titled 'table' is part of a larger dataset collection known as 'tilastointialueet_ely4500k_2020'. It houses valuable data pertaining to the ELY areas in 2020 at a scale of 1:4,500,000. This data originates from Finland, specifically from the website of the 'Tilastokeskus' (Statistics Finland). The table is organized into several columns, each providing different data aspects. Two special columns, '_extract_date' and '_row_number', form a unique identifier for each row. The '_extract_date' column indicates the date the data was extracted from the source, while the '_row_number' provides a unique row number for the extracted data. The table also includes several 'geom_' prefixed columns, which contain geographic information. These columns hold significant potential for...

Column Descriptions

Regional Development Areas (ELY) in Finland, 2020 (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. This is important to track the currency of the data.
_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'. The combination of '_extract_date' and '_row_number' uniquely identifies each row in the table.
ely	string	This is a string column that seems to contain some sort of identifier or code.
geom_geojson	string	This column contains geojson data, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geotext data, which may be a textual representation of the geographic data.
geom_type	string	This column specifies the type of the geographic data contained in the 'geom_geojson' and 'geom_geotext' columns. It can be either a polygon or a multipolygon.
geom_centroid	string	This column contains the centroid of the geographic data, which is the center point of the shape.
geom_center_x	double	This column contains the x-coordinate of the center of the geographic shape.
geom_center_y	double	This column contains the y-coordinate of the center of the geographic shape.
gml_id	string	This column contains a unique identifier for each row in the table.
id	long	This column contains an integer identifier for each row.
name	string	This column contains the English name of the ELY Centre.
namn	string	This column contains the name of the ELY Centre in another language, possibly Swedish.
nimi	string	This column contains the name of the ELY Centre in another language, possibly Finnish.
vuosi	long	This column contains an integer representing the year, possibly the year the data was collected or the year the data applies to.

Historical Versioning of ELY Areas 2020 (Scale 1:4,500,000)

Column	Type	Comment
_start_date	date	This column represents the date when the row was extracted from the data source. It forms a unique identifier for each row in combination with the '_row_number'.
_end_date	date	This column signifies the date when a new version of the row was extracted from the data source. A null value in this column 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 source. It is used in conjunction with '_start_date' to uniquely identify each row in the table.
ely	string	This column contains a string representation of the ELY center code.
geom_geojson	string	This column contains the geometric data of the ELY center in GeoJSON format.
geom_geotext	string	This column contains textual representation of the geometric data of the ELY center.
geom_type	string	This column represents the type of geometric data stored (e.g., 'ST_MULTIPOLYGON', 'ST_POLYGON').
geom_centroid	string	This column contains the centroid of the geometric data of the ELY center.
geom_center_x	double	This column represents the x-coordinate of the geometric center of the ELY center.
geom_center_y	double	This column represents the y-coordinate of the geometric center of the ELY center.
gml_id	string	This column contains a string that uniquely identifies the geometric data of the ELY center.
id	long	This column contains a unique integer identifier for each row of data.
name	string	This column contains the English name of the ELY center.
namn	string	This column contains the name of the ELY center in another language.
nimi	string	This column contains the Finnish name of the ELY center.
vuosi	long	This column contains the year associated with the data. In the sample data provided, the year is 2020.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024