Statistics Area Large Region Collection 2018

This dataset collection consists of related data tables derived from the statistical interface service (WFS) of the 'Tilastokeskus' (Statistics Finland) website in Finland. The collection includes data tables that provide comprehensive statistical information. The specifics of the data are not divulged for technical reasons, but they are meticulously organized in tables format, making it an invaluable resource for researchers, analysts, and data enthusiasts seeking Finnish statistical 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

Large Areas 2018 (1:1 000 000) - Data Table from Finnish Statistical Data CollectionTSV
This table, part of the 'tilastointialueet_suuralue1000k_2018' dataset collection, houses detailed information about the Large Areas of 2018 (1:1 000 000) in Finland. The data originates from 'Tilastokeskus' (Statistics Finland). The table is structured with a variety of columns, each hosting specific types of data. Among the contents of the table, there are two special columns: '_extract_date' and '_row_number'. The former indicates the date when the specific row's data was extracted, while the latter represents the row number in the data extracted on that particular date. These two columns together establish a unique identifier for each row. The dataset also includes several columns that begin with 'geom_', representing geographic information. This data is crucial for geospatial data...
Version History of Major Regions 2018 (1:1 000 000)TSV
The 'table__history' is a critical component of a comprehensive dataset collection, focusing on the version history of its base table rows. It is a history table that contains chronological data changes for each row, allowing users to track and analyze changes over time. This table is sourced from the 'Tilastokeskus' website, located in Finland. The table provides a rich source of information for various data analytics purposes, particularly for research and analysis related to the 'Large Areas 2018 (1:1 000 000)' theme. The table has various columns that hold specific information. For example, it has columns that store geographical data, such as the 'geom_' columns, which are useful for geospatial data analytics. This geographic information is presented using the WGS 84 coordinate...

Column Descriptions

Large Areas 2018 (1:1 000 000) - Data Table from Finnish Statistical Data Collection

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted. It helps track when each record was pulled from the source.
_row_number	long	This column contains the row number in the data as it was extracted from the source. In combination with '_extract_date', each row can be uniquely identified.
geom_geojson	string	A representation of geographic objects in GeoJSON format. This can include features such as points, lines, and polygons.
geom_geotext	string	A geometrical representation of the data in text format. It compliments the 'geom_geojson' column and provides a readable format of the same data.
geom_type	string	Specifies the type of the geometry. For example, in our table, it indicates that the geometry is of type 'ST_MULTIPOLYGON'.
geom_centroid	string	The centroid or the geometric center of a shape. It is calculated as the average of all points in the shape.
geom_center_x	double	The X-coordinate of the geometric center of a shape.
geom_center_y	double	The Y-coordinate of the geometric center of a shape.
gml_id	string	This is a unique identifier for each row in the table.
name	string	The English name of the geographical area.
namn	string	The name of the geographical area in Swedish.
nimi	string	The name of the geographical area in Finnish.
suuralue	string	A coded representation of a geographical area.
vuosi	long	Year of the data record. In our table, all records are from the year 2018.

Version History of Major Regions 2018 (1:1 000 000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source, marking the start of the row's existence in the table.
_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 combination with '_start_date' to identify each row in the table.
geom_geojson	string	This column contains the geometry data of the row in GeoJSON format, a popular format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geometry data of the row in text format.
geom_type	string	This column specifies the type of the geometry data stored in the row, for example 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the centroid (geometric center) of the geometry data in the row.
geom_center_x	double	This column contains the x-coordinate of the geometric center of the data.
geom_center_y	double	This column contains the y-coordinate of the geometric center of the data.
gml_id	string	This column contains a unique identifier for each row, provided by the data source.
name	string	This column contains a name associated with the row. The language of the name depends on the originating source.
namn	string	This column contains a translated name associated with the row. The language of the name depends on the originating source.
nimi	string	This column contains another translated name associated with the row. The language of the name depends on the originating source.
suuralue	string	This column contains a string that represents a specific area or zone related to the row.
vuosi	long	This column contains an integer that represents a specific year associated with the row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024