Statistics Service Interface (WFS) - Large Area Data Collection 2013

The dataset collection at hand is an assembly of related data tables. These tables contain a variety of data, organized systematically in rows and columns. This collection is sourced from the Statistics Finland (Tilastokeskus) website, based in Finland. The dataset's origin is the service interface (WFS) of Statistics Finland, suggesting that it might contain statistical data specific to different regions in Finland. The data might be about larger areas, considering the year 2013, as indicated in the collection's name. However, without technical specifics, it is challenging to determine the exact content of the dataset collection. It is designed to offer researchers and analysts a comprehensive view of the related data, opening up possibilities for detailed study and 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

Large Areas 2013 (1:4 500 000) Dataset TableTSV
The table, part of the 'tilastointialueet_suuralue4500k_2013' dataset collection, provides a comprehensive set of data pertaining to the large areas of Finland in 2013, as indicated by the data source description 'Suuralueet 2013 (1:4 500 000)'. The table is sourced from the 'Tilastokeskus' website based in Finland. The table includes a range of columns covering various aspects of geographical data. Unique regional identifiers are provided in the form of 'gml_id', while the 'name', 'namn', and 'nimi' columns offer the region's name in various languages. The 'suuralue' and 'vuosi' columns specify the larger area code and the year the data relates to, respectively. Geospatial data is a significant part of this table, with several 'geom_' prefixed columns. For instance, 'geom_geojson'...
Version History of Major Areas 2013 (1:4 500 000) TableTSV
The 'table__history' is a historical record table, which is a part of the 'tilastointialueet_suuralue4500k_2013' dataset. This table holds the version history of each row of its base table, which represents the Major Regions of Finland in 2013 at a scale of 1:4 500 000. The table allows tracking changes in the data across time, offering valuable insights for studies related to regional changes and development. The table has a unique identifier for each row based on the combination of '_start_date' and '_row_number', representing when a particular row was extracted and its position in the raw data source respectively. If '_end_date' is null, it indicates that the version of the row is the most recent. The table's geographic information, prefixed with 'geom_', is particularly valuable...

Column Descriptions

Large Areas 2013 (1:4 500 000) Dataset Table

Column	Type	Comment
_extract_date	date	This column contains the date when the data on a particular row was extracted from the data source. It helps in tracking the timeline of data extraction.
_row_number	long	This column holds the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It helps in identifying each row uniquely when combined with '_extract_date'.
geom_geojson	string	This column holds geometric data in the GeoJSON format. It provides spatial representation of the geographical entities.
geom_geotext	string	This column stores geometric data in text format. It provides a textual representation of the geographical entities.
geom_type	string	This column indicates the type of the geometrical data stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the central point of the geometric shape representing the geographic entity.
geom_center_x	double	This column holds the x-coordinate of the center point of the geometric entity.
geom_center_y	double	This column holds the y-coordinate of the center point of the geometric entity.
gml_id	string	This column holds the unique identifier for each row in the table.
name	string	This column contains the English names of the geographical entities.
namn	string	This column has the names of the geographical entities in Swedish.
nimi	string	This column holds the names of the geographical entities in Finnish.
suuralue	string	This column holds an identifier for the larger area to which the geographical entity belongs.
vuosi	long	This column indicates the year associated with the data in each row.

Version History of Major Areas 2013 (1:4 500 000) Table

Column	Type	Comment
_start_date	date	This column marks the date when the row was extracted from the source data. It forms a unique identifier for each row in combination with the '_row_number' column.
_end_date	date	This column records the date when a new version of the row was extracted from the source data. If this column's value is null, it signifies 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 part of the unique identifier for each row when combined with the '_start_date' column.
geom_geojson	string	This column contains geometric data in the GeoJSON format, which describes the geographic features of the data.
geom_geotext	string	This column contains geometric data in text format. It can be used to visualize the geographic features of the data.
geom_type	string	This column specifies the type of geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. In this case, the geometry type is a multipolygon.
geom_centroid	string	This column holds the centroid of the geographic feature, which is the center point of the shape.
geom_center_x	double	This column contains the x-coordinate of the centroid of the geographic feature.
geom_center_y	double	This column contains the y-coordinate of the centroid of the geographic feature.
gml_id	string	This is a unique identifier for each row, provided by the source data.
name	string	This column holds the English names of the geographic features.
namn	string	This column contains the names of the geographic features in Swedish.
nimi	string	This column contains the names of the geographic features in Finnish.
suuralue	string	This column represents a category or grouping of the geographic features.
vuosi	long	This column represents the year related to the geographic data.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024