To download the data set, please sign up or log in

Statistical Regions Dataset Collection, 2013 Edition

This dataset collection is a compilation of related tables sourced from the Statistics Finland (Tilastokeskus) website. These tables are organized in a structured format that consists of rows and columns, providing a comprehensive data set. The data is served via the Statistics Finland's service interface (WFS). The content of this collection is related to statistical areas, providing valuable information for various research and statistical analysis purposes. 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 Version Data of ELY Areas 2013 - Scaled 1:4,500,000TSV

    The 'table__history' is a part of a dataset collection named 'tilastointialueet_ely4500k_2013'. This history table serves as a repository for the version history of its base table rows, tracking changes over time. It contains data detailing the ELY-areas for the year 2013 at a scale of 1:4,500,000. The data is sourced from 'Tilastokeskus' (Statistics Finland), based in Finland. The table includes various columns which offer a wealth of information about each row's timeline and contents. Unique row identifiers are formed by coupling the extraction date and the row's number from the original dataset. Monitoring when a row was extracted and when a new version of it was introduced is possible through the '_start_date' and '_end_date' columns, respectively. When a row's '_end_date' is null,...

  • Regional Division ELY Areas 2013 (Scale 1:4,500,000) - Dataset TableTSV

    The table is part of a dataset collection that represents the 'ELY-areas 2013' (Centers for Economic Development, Transport and the Environment in Finland) at a scale of 1:4 500 000. The data has been sourced from the Statistics Finland website ('Tilastokeskus') based in Finland. The table contains various columns, each providing unique information about the ELY areas. The columns contain data such as the extraction date of the data row, the row number, geographical information in the form of GeoJSON and GeoText, the type of geometry represented (i.e., MultiPolygon), the centroid of the geometry, the X and Y coordinates of the center of the geometry, a unique identifier, a GML ID, and the name of the ELY area in three languages - English, Swedish, and Finnish. There are specific columns...

Column Descriptions

Regional Division ELY Areas 2013 (Scale 1:4,500,000) - Dataset Table

Column Type Comment
_extract_date date This column indicates the date when the data on the row was extracted from the data source. It provides an understanding of the currency of the data.
_row_number long This column represents the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This, in combination with '_extract_date', uniquely identifies each row.
ely string This column contains a coded representation of different regions in Finland.
geom_geojson string This column contains the geometric representation of the region in GeoJSON format, a popular format for encoding a variety of geographic data structures.
geom_geotext string This column provides the geometric representation of the region in text format.
geom_type string This column specifies the type of the geometric data.
geom_centroid string This column contains the central point of the geometric shape representing the region.
geom_center_x double This column represents the X-coordinate of the central point of the geometric shape.
geom_center_y double This column represents the Y-coordinate of the central point of the geometric shape.
gid long This column contains a unique identifier for each row in the table.
gml_id string This column contains a unique identifier for each geographical feature in the table.
name string This column contains the English names of different regions in Finland.
namn string This column contains the names of different regions in Finland in another language, possibly Swedish.
nimi string This column contains the names of different regions in Finland in Finnish language.
vuosi long This column indicates the year to which the data pertains. For example, data extracted in 2013.

Historical Version Data of ELY Areas 2013 - Scaled 1:4,500,000

Column Type Comment
_start_date date This column contains the date when the row was extracted from the data source. It forms a unique identifier for each row in the version history table in combination with the '_row_number' column.
_end_date date This column contains the date when a new version of the row was extracted from the data source. If the value of this column is null, it 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 data source. It forms a unique identifier for each row in the version history table in combination with the '_start_date' column.
ely string This column contains a string type value, likely representing a certain classification or code within the data.
geom_geojson string This column contains GeoJSON representations of multi-polygonal geographic shapes.
geom_geotext string This column contains text representations of multi-polygonal geographic shapes.
geom_type string This column specifies the type of the geographic shape represented in 'geom_geojson' and 'geom_geotext' columns. The type is 'ST_MULTIPOLYGON' indicating multi-polygonal shapes.
geom_centroid string This column contains the geographic coordinates of the centroid point of the multi-polygonal shapes.
geom_center_x double This column contains the x-coordinate of the center point of the multi-polygonal shapes.
geom_center_y double This column contains the y-coordinate of the center point of the multi-polygonal shapes.
gid long This column contains an integer value, likely a unique identifier or a classification code within the data.
gml_id string This column contains a unique string identifier for each row in the data.
name string This column contains the English names of the geographic areas represented by the multi-polygonal shapes.
namn string This column contains the local names of the geographic areas represented by the multi-polygonal shapes.
nimi string This column contains another form of local names for the geographic areas represented by the multi-polygonal shapes.
vuosi long This column contains an integer value representing a year, probably the year when the data were collected.

Additional Info

Last Updated November 11, 2024
Created November 11, 2024