Statistics Bureau Service Interface (WFS) - Dataset Collection 2023
Tables
-
ELY Areas Forecast for 2023 (Scale 1:4,500,000)TSV
The table in focus contains detailed information about the ELY areas for the year 2023, as indicated by its source, the Finnish statistical authority 'Tilastokeskus' (Statistics Finland). The data within the table provides a rich dataset, capturing various aspects of the ELY areas, including unique identifiers, names in multiple languages, and geographic details. The geographic details are particularly notable, as they are provided in various forms, such as GeoJSON and GeoText formats, along with centroid points and center coordinates, following the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The diversity of geographic data makes the table well-suited for geospatial data analytics, such as mapping ELY areas, identifying central points of...
-
History of ELY-areas 2023 Version Data (1:4 500 000)TSV
The 'table__history' is a comprehensive repository of version history data related to the ELY-areas for the year 2023, sourced from the Finnish statistical authority, 'Tilastokeskus' (Statistics Finland). With a focus on geospatial information, the table provides a wealth of data points for each row, including geographical coordinates, polygonal representations, and geographical centroid points, all presented using the WGS 84 coordinate reference system (longitude first, followed by latitude). In addition to geographical data, the table also holds important data points such as the ELY area identifiers and names in multiple languages including English, Finnish, and Swedish. The table also tracks the extraction date of each data row, allowing for chronological analysis of data changes. If...
Column Descriptions
ELY Areas Forecast for 2023 (Scale 1:4,500,000)
Column | Type | Comment |
---|---|---|
_extract_date | date | This column contains the date when the data on the row of the table was extracted from the data source. |
_row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
ely | string | The 'ely' column holds a string that represents a code related to the data entry. |
geom_geojson | string | This column contains a GeoJSON representation of the geographic data associated with the data entry. GeoJSON is a format for encoding a variety of geographic data structures. |
geom_geotext | string | This column contains a textual representation of the geographic data associated with the data entry. |
geom_type | string | The 'geom_type' column indicates the type of the geographic data associated with the data entry. It could be a polygon or a multipolygon. |
geom_centroid | string | This column holds the centroid point of the geographic data associated with the data entry. The centroid is the geometric center of a plane figure or shape. |
geom_center_x | double | This column holds the x-coordinate of the center of the geographic data associated with the data entry. |
geom_center_y | double | This column holds the y-coordinate of the center of the geographic data associated with the data entry. |
gml_id | string | The 'gml_id' column contains a unique identifier for the data entry. |
id | long | The 'id' column contains an integer that serves as a unique identifier for the data entry. |
name | string | The 'name' column holds the English name of the data entry. |
namn | string | The 'namn' column contains a string that represents a name related to the data entry. It seems to be in a language other than English. |
nimi | string | The 'nimi' column contains a string that represents a name related to the data entry. It appears to be in a language other than English. |
vuosi | long | The 'vuosi' column holds an integer that represents a year related to the data entry. |
History of ELY-areas 2023 Version Data (1:4 500 000)
Column | Type | Comment |
---|---|---|
_start_date | date | The date when the specific row was extracted from the data source, marking the start of the version of the row in the 'table__history'. |
_end_date | date | The date when a new version of the row was extracted from the data source, marking the end of the current version. If this column has a null value, it indicates the row is the most recent version. |
_row_number | long | The number of the row as per the raw data extracted from the data source. This column, combined with '_start_date', uniquely identifies each row in the history table. |
ely | string | A string type column representing the specific code for the ELY center. |
geom_geojson | string | Contains the geographical data in the GeoJSON format, describing the shape and the location of the ELY center. |
geom_geotext | string | Contains the geographical data in a textual format, describing the shape and the location of the ELY center. |
geom_type | string | The type of the geographical data representing the ELY center. It could be either a polygon or a multipolygon. |
geom_centroid | string | The geographical point representing the centroid of the geographical shape of the ELY center. |
geom_center_x | double | The x-coordinate (longitude) of the center of the geographical shape of the ELY center. |
geom_center_y | double | The y-coordinate (latitude) of the center of the geographical shape of the ELY center. |
gml_id | string | A string type column representing the unique identifier for the row in the 'tilastointialueet_ely4500k_2023' dataset. |
id | long | An integer type column acting as the identifier for the ELY center. |
name | string | The name of the ELY center in English. |
namn | string | The name of the ELY center in Swedish. |
nimi | string | The name of the ELY center in Finnish. |
vuosi | long | An integer type column representing the year related to the data of the ELY center. |
Additional Info
Last Updated | November 12, 2024 |
---|---|
Created | November 11, 2024 |