1. Home
  2. Datasets
  3. Statistical Regions ELY ...
To download the data set, please sign up or log in

Statistical Regions ELY 4500K: A Collection of Related Tables

The dataset collection in question is a comprehensive compilation of related data tables sourced from Tilastokeskus (Statistics Finland), a reliable source based in Finland. The collection encompasses a range of tables that contain related data organized in a structured tabular format, comprising of columns and rows. Notably, the content of the collection is derived from the statistical service interface (WFS) of Tilastokeskus. Each table in the collection offers unique data, with the collective aim of providing a broad and detailed overview of the subject matter the dataset collection 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

  • Centres for Economic Development, Transport and the Environment (1:4 500 000 scale) Data TableTSV

    The 'table' belongs to a dataset collection named 'tilastointialueet_ely4500k' and is a structured assembly of data composed of rows and columns. This table provides detailed information about ELY-areas at a scale of 1:4,500,000, sourced from the 'Tilastokeskus' website in Finland. Each row in the table represents a unique entry, with the columns providing specifics about the entry. Key columns include identifiers such as 'id', 'name', 'namn', and 'nimi', which provide names of the ELY-centers in different languages. The 'ely' column provides a numerical identifier for these centers. The columns starting with 'geom_' contain geographical data. For instance, 'geom_geojson' and 'geom_geotext' provide geographical coordinates in different formats, while 'geom_type' specifies the type of...

  • Version History of ELY Areas (Scale 1:4,500,000) - Historical Data TableTSV

    The 'table__history' is an extensive repository of version history for each row of its base table. The base table represents various ELY areas at a scale of 1:4,500,000, sourced from the 'Tilastokeskus' website in Finland. Each row in the table is uniquely identified by a combination of the '_start_date' and '_row_number'. The table includes additional columns, '_start_date' and '_end_date', which record when the data was extracted and when a new version was extracted respectively. If the '_end_date' column value is null, it signifies that this is the most recent version of the row. The table also carries a wealth of geographic information in columns prefixed with 'geom_'. This data can be used for geospatial data analytics, with geographic coordinates presented using the WGS 84...

Column Descriptions

Centres for Economic Development, Transport and the Environment (1:4 500 000 scale) Data Table

Column Type Comment
_extract_date date Indicates the date when the data on the row of the table was extracted from the data source. This, combined with '_row_number', uniquely identifies each row.
_row_number long Contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This, combined with '_extract_date', uniquely identifies each row.
ely string Represents a code associated with each ELY Centre. ELY Centres are responsible for the regional implementation and development tasks of the central government in Finland.
geom_geojson string Holds the geographical data of the ELY Centre in GeoJSON format. This format encodes geographical features with a JSON format. The information can include polygons and multipolygons.
geom_geotext string Stores the geographical data of the ELY Centre in text format. This information represents the geographical boundaries of the ELY Centre.
geom_type string Specifies the type of geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. It can be either a polygon or a multipolygon.
geom_centroid string This column contains the centroid point of the geographical data represented in the 'geom_geojson' and 'geom_geotext' columns. The centroid is the geometric center of a plane figure or shape.
geom_center_x double Indicates the X-coordinate of the centroid point of the geographical data.
geom_center_y double Indicates the Y-coordinate of the centroid point of the geographical data.
gml_id string Represents a unique identifier for each row in the dataset. The identifier is in GML (Geography Markup Language) format.
id long An integer that serves as a unique identifier for each ELY Centre.
name string Contains the English name of each ELY Centre.
namn string Holds the Swedish name of each ELY Centre.
nimi string Contains the Finnish name of each ELY Centre.
vuosi long Represents the year when the data for the ELY Centre was collected or updated.

Version History of ELY Areas (Scale 1:4,500,000) - Historical Data Table

Column Type Comment
_start_date date This column contains the date when the row was extracted from the data source. It forms a unique combination with '_row_number' to identify each row in this version history 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 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 combination with '_start_date' to identify each row in this version history table.
ely string This column stores a string that represents a particular ELY center.
geom_geojson string This column stores the geometric data of the ELY center in GeoJSON format.
geom_geotext string This column stores the geometric data of the ELY center in text format.
geom_type string This column indicates the type of the geometric data stored.
geom_centroid string This column stores the centroid of the geometric shape representing the ELY center.
geom_center_x double This column stores the x-coordinate of the geometric center of the ELY center.
geom_center_y double This column stores the y-coordinate of the geometric center of the ELY center.
gml_id string This column stores a unique identifier for each row in string format.
id long This column stores a unique integer identifier for each row.
name string This column stores the English name of the ELY center.
namn string This column stores the name of the ELY center in another language.
nimi string This column stores the Finnish name of the ELY center.
vuosi long This column stores an integer that represents the year.

Additional Info

Last Updated November 11, 2024
Created November 11, 2024