Statistics Interface Large Area Dataset 2015

The dataset collection in question is a compilation of statistical area data. It includes one or more tables of interconnected data, structured in the form of rows and columns. The data in the collection is sourced from the 'Statistics Centre' (Tilastokeskus), a recognized institution in Finland. The description provided by the data source, translated to English, is 'Statistical Centre's Service Interface (WFS)'. This suggests that the dataset collection is likely a representation of statistical data provided through a web feature service by the Statistics Centre. The dataset collection might include various statistical area details, possibly related to the greater area of 1000 square kilometers, as suggested by the year 2015, which may indicate the time period the data covers. 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 2015: Detailed Geographic and Statistical Data (Scale 1:1 000 000)TSV
The table contains rich data that provides a detailed insight into the Major Regions of Finland in 2015. The data is sourced from the Statistics Finland (Tilastokeskus) website. Each row in the table represents a unique data entry, which is extracted on a specific date and identified by a unique row number. The data includes the region's name in Finnish, Swedish, and English, along with a unique identifier ('gml_id') for each region. The table holds geographical data with coordinates in the WGS 84 coordinate reference system. This includes MultiPolygon geographical data, the centroid point of the region, as well as the longitude ('geom_center_x') and latitude ('geom_center_y') of the region's center. The table also includes the area ('shape_star') and perimeter ('shape_stle') of each...
Version History of Major Areas 2015 (1:1 000 000)TSV
The table under consideration is a historical record, which is a part of a larger dataset. It encompasses various geographical and temporal aspects, tracking the evolution of its base data over a period of time. The data in the table is sourced from 'Tilastokeskus' (Statistic Centre), based in Finland. The table primarily contains data about major regions in Finland as of 2015, specifically captured at a scale of 1:1,000,000. The table is structured with a series of columns, each serving a unique purpose. For instance, some columns represent geographical data that can be used for geospatial data analytics. These include details such as geographical shapes, centroids, and center points, all represented in the WGS 84 coordinate reference system, with longitude presented before latitude....

Column Descriptions

Large Areas 2015: Detailed Geographic and Statistical Data (Scale 1:1 000 000)

Column	Type	Comment
_extract_date	date	This column records the date when the data on each row was extracted from the data source.
_row_number	long	This column records the row number in the data extracted from the source on the extract date specified by the column '_extract_date'.
geom_geojson	string	This column contains the geometry of the area as a MultiPolygon in GeoJSON format.
geom_geotext	string	This column contains the geometry of the area as a MultiPolygon in text format.
geom_type	string	This column specifies the type of the geometry, which is a MultiPolygon.
geom_centroid	string	This column contains the centroid of the MultiPolygon as a point.
geom_center_x	double	This column records the x-coordinate of the center of the MultiPolygon.
geom_center_y	double	This column records the y-coordinate of the center of the MultiPolygon.
gml_id	string	This column represents the unique identifier for each row, formatted as 'suuralue1000k_2015' followed by a number.
name	string	This column contains the name of the area in English.
namn	string	This column contains the name of the area in Swedish.
nimi	string	This column contains the name of the area in Finnish.
shape_star	double	This column records a geometric parameter of the area, likely related to the size or shape.
shape_stle	double	This column records another geometric parameter of the area, possibly related to the perimeter or complexity of the shape.
suuralue	string	This column contains a numeric code representing the area.
vuosi	double	This column records the year related to the data row, which is 2015 in all records in the dataset.

Version History of Major Areas 2015 (1:1 000 000)

Column	Type	Comment
_start_date	date	This column represents the date when the row was extracted from the data source. This, in conjunction with '_row_number', uniquely identifies each row in the history table.
_end_date	date	This contains 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	The '_row_number' column contains the number of the row in the raw data extracted from the data source. It is part of the unique identifier for each row, along with '_start_date'.
geom_geojson	string	This column contains geometric data in GeoJSON format, a common format for encoding a variety of geographic data structures.
geom_geotext	string	The 'geom_geotext' column contains geometric data in text format.
geom_type	string	This column specifies the type of geometric data contained in the row. In our case, it is 'ST_MULTIPOLYGON', indicating the data represents multiple polygons.
geom_centroid	string	This column contains the centroid, or the geometric center, of the polygon represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	The 'geom_center_x' column represents the x-coordinate of the geometric center of the polygon.
geom_center_y	double	This column represents the y-coordinate of the geometric center of the polygon.
gml_id	string	This is an identifier for each row, which appears to incorporate the dataset name and an individual identifier for each area.
name	string	The 'name' column contains the English name of the area represented by the row.
namn	string	This column contains the name of the area in another language, possibly Swedish given the country of origin of the data.
nimi	string	The 'nimi' column contains the name of the area in another language, likely Finnish, considering the data source's location.
shape_star	double	This column contains a numeric value related to the shape of the area. The exact nature of this value is unclear without further context.
shape_stle	double	Like 'shape_star', this column contains a numeric value related to the shape of the area. The exact meaning is unclear without additional information.
suuralue	string	The 'suuralue' column seems to be a categorical variable, possibly indicating a larger administrative area that each row belongs to.
vuosi	double	The 'vuosi' column contains the year associated with the data in each row, likely indicating the year the data was collected or is relevant for.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024