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

Statistical Areas ELY1000K 2014 - Data Collection

The dataset collection in question comprises a set of related data tables, which are sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. The tables are organized in a systematic manner, featuring rows and columns for easy data interpretation. The contents of these tables stem from the Statistical Interface Service (WFS), as described by the data source. This dataset collection provides a rich source of statistical information and is instrumental for various analytical and research 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

  • 2014 ELY Areas (Scale 1:1 000 000) - Extracted Data TableTSV

    The table 'table' is a part of the 'tilastointialueet_ely1000k_2014' dataset collection. This table holds structured data related to the ELY areas in Finland for the year 2014. The data is sourced from the Statistics Finland ('Tilastokeskus') web site. Each row in the table represents a specific ELY area, identified by a unique row number and an extraction date when the data was retrieved. The ELY area is identified by a code in the 'ely' column. The name of the ELY Centre is provided in three different languages: English ('name'), Swedish ('namn'), and Finnish ('nimi'). The geographic information about each ELY area is represented by multiple columns starting with 'geom_'. These columns contain geographic data in multiple formats like GeoJSON, GeoText, and centroid coordinates. This...

  • Version History of ELY Areas 2014 (1:1 000 000)TSV

    The 'table__history' is a meticulously organized history table that is part of the wider 'tilastointialueet_ely1000k_2014' dataset, which contains relevant data that has been structured into rows and columns. This particular table is a repository of the version history of its base table rows, tracing the changes in the data over time. The table primarily holds data on the ELY-alueet 2014 (ELY areas 2014) at a scale of 1:1,000,000, which can be translated to a diverse range of geospatial analytics. The data is supplied by 'Tilastokeskus' (Statistics Finland) based in Finland. Columns in this table are rich with geographic information, including a set of 'geom_' prefixed columns, which provide detailed geospatial data. This data, which is based on the WGS 84 coordinate reference system,...

Column Descriptions

2014 ELY Areas (Scale 1:1 000 000) - Extracted Data Table

Column Type Comment
_extract_date date The date when the data on the row of the table was extracted from the Statistics Finland (Tilastokeskus) database. This column helps in tracking the history of the data.
_row_number long The number of the row in the data extracted from the source on the extract date specified by the column '_extract_date'. This column, in combination with '_extract_date', uniquely identifies each row.
ely string A string identifier representing a specific region in Finland. This information is crucial for regional analysis.
geom_geojson string The geographical coordinates of the ELY Centre, represented in GeoJSON format. This data is important for geospatial analysis and visualizations.
geom_geotext string The geographical boundaries of the ELY Centre, represented in geotext format. This information is used in mapping and geographical analysis.
geom_type string The type of the geographical object represented in the 'geom_geojson' and 'geom_geotext' columns. This column helps in understanding the type of geographical data being used.
geom_centroid string The geographical coordinates of the centroid of the ELY Centre region. This data is crucial for geographical analysis and mapping.
geom_center_x double The X coordinate of the centroid of the ELY Centre region. This information is crucial for geographical analysis and mapping.
geom_center_y double The Y coordinate of the centroid of the ELY Centre region. This information is crucial for geographical analysis and mapping.
gml_id string A unique identifier for each row, which includes information about the year and the respective ELY Centre.
name string The English name of the ELY Centre. This information helps in understanding the data in an international context.
namn string The Swedish name of the ELY Centre. This information helps in understanding the data in a Swedish-speaking context.
nimi string The Finnish name of the ELY Centre. This information helps in understanding the data in a Finnish-speaking context.
vuosi long The year when the data was recorded. This column is important for temporal analysis of the data.

Version History of ELY Areas 2014 (1:1 000 000)

Column Type Comment
_start_date date The date when the row was first captured from the data source, indicating the start of that version of the row.
_end_date date The date when a new version of the row was captured from the data source, indicating the end of that version of the row. If this value is null, it signifies that this version of the row is the most recent.
_row_number long The row number in the raw data extracted from the data source. This, combined with '_start_date', forms a unique identifier for each row in this version history table.
ely string A string identifier representing different regions in Finland.
geom_geojson string Geospatial data in GeoJSON format, representing the geometrical shape of the region.
geom_geotext string Geospatial data in text format, representing the geometrical shape of the region.
geom_type string The type of the geometrical shape, in this case a 'ST_MULTIPOLYGON', which represents a complex shape with multiple boundaries.
geom_centroid string The central point of the geometrical shape.
geom_center_x double The X-coordinate of the center of the geometrical shape.
geom_center_y double The Y-coordinate of the center of the geometrical shape.
gml_id string A unique string identifier for each row, typically adhering to a specific naming convention.
name string The English name of the region.
namn string The Swedish name of the region.
nimi string The Finnish name of the region.
vuosi long The year the data was recorded, represented as an integer.

Additional Info

Last Updated November 11, 2024
Created November 11, 2024