Statistics Finland's Service Interface 2020 Dataset Collection

The dataset collection in question comprises a set of related data tables, sourced from the Statistics Center's service interface (WFS) provided by 'Tilastokeskus' in Finland. This collection systematically organizes related data into tables, each consisting of columns and rows, for a comprehensive and interconnected overview. The data tables are primarily focused on statistical areas, with substantial coverage and details for the year 2020. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

History and Versioning for Large Areas 2020 (1:4 500 000)TSV
The 'table__history' is a historical data table sourced from the website of 'Tilastokeskus' in Finland. The table contains data about the 'Large areas 2020' (Suuralueet 2020) at a scale of 1:4,500,000. This data provides valuable insights on various geographical areas in Finland, with their names provided in multiple languages - Finnish, Swedish, and English. Each area is also associated with a unique identifier, which is an essential feature for data analysis and tracking changes over time. The table offers a rich set of geospatial data, with columns providing geographic information in different formats like geojson and geotext. This data, represented using the WGS 84 coordinate reference system, can be used for detailed geospatial analysis. The geospatial data includes the type of...
Large Districts 2020 (Scale 1:4 500 000) - Data TableTSV
The table in focus, belonging to the dataset collection 'tilastointialueet_suuralue4500k_2020', features data concerning large areas in 2020 at a 1:4,500,000 scale, sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland. The table is structured into various columns, each bearing distinct information about the data. Columns like 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' carry geographic information that could be instrumental for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, where longitude is followed by latitude. Other columns like 'name', 'namn', and 'nimi' provide the names of the large areas in various languages, offering a multi-lingual...

Column Descriptions

Large Districts 2020 (Scale 1:4 500 000) - Data Table

Column	Type	Comment
_extract_date	date	This column contains the date when the data row was extracted from the source. It helps track when the specific data was recorded.
_row_number	long	This column contains the row number of the data extracted from the source. Together with '_extract_date', it uniquely identifies each row in the table.
geom_geojson	string	This column contains the geometric data in GeoJSON format. It can be used to represent spatial features and their attributes.
geom_geotext	string	This column contains geometric data in text format, specifically as a multipolygon. This information can be used for spatial analysis.
geom_type	string	This column specifies the type of geometric data contained in the table. In this case, the type is ST_MULTIPOLYGON.
geom_centroid	string	This column contains the central point of each geographical feature in the table, represented as a point. This is useful for identifying the center of each spatial feature.
geom_center_x	double	This column contains the x-coordinate of the center of each geographical feature. It is part of the spatial data in the table.
geom_center_y	double	This column contains the y-coordinate of the center of each geographical feature. This is another component of the spatial data in the table.
gml_id	string	This column contains an identifier for each row. It is a string and can be used to uniquely identify each geographical feature.
name	string	This column contains the English name of the geographical area represented by the row.
namn	string	This column contains the name of the geographical area in Swedish. It is equivalent to the 'name' column but in a different language.
nimi	string	This column contains the name of the geographical area in Finnish. It is equivalent to the 'name' column but in a different language.
suuralue	string	This column contains an identifier for the large area of the geographical feature. It is a string and can be used to group or categorize the data.
vuosi	long	This column contains an integer representing the year of the data. This can be used to track changes over time.

History and Versioning for Large Areas 2020 (1:4 500 000)

Column	Type	Comment
_start_date	date	This column marks the date when a row was extracted from the data source, serving to identify each version of a row in the history table.
_end_date	date	This column indicates 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	It contains the number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson	string	This column contains the geometric data related to the row in GeoJSON format, which is a format for encoding geographic data structures.
geom_geotext	string	This column contains a text representation of the geometric data related to the row.
geom_type	string	This column specifies the type of the geometric data associated with the row.
geom_centroid	string	This column contains the point that represents the geometric center of the shape associated with the row.
geom_center_x	double	This column contains the x-coordinate of the geometric center of the shape associated with the row.
geom_center_y	double	This column contains the y-coordinate of the geometric center of the shape associated with the row.
gml_id	string	This column contains a unique identifier for each row.
name	string	This column contains the English name of the area related to the row.
namn	string	This column contains the Swedish name of the area related to the row.
nimi	string	This column contains the Finnish name of the area related to the row.
suuralue	string	This column contains a code representing a specific area.
vuosi	long	This column contains the year related to the data of the row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024