Statistics Interface (WFS) Dataset Collection 2024

The dataset collection 'tilastointialueet_ely4500k_2024' is a comprehensive grouping of related data tables. These tables, compiled into an organized format of columns and rows, provide a detailed statistical overview. The data for these tables is sourced directly from the 'Tilastokeskus' (Statistical Center) website, located in Finland. The dataset description provided by the source, 'Tilastokeskuksen palvelurajapinta (WFS)' translates to 'Statistical Center's Service Interface (WFS)'. This implies that the data is meticulously gathered and managed by the Statistical Center of Finland, providing an in-depth view of the subject matter covered in the dataset collection. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

ELY Areas 2024 Projection at 1:4,500,000 ScaleTSV
The table under consideration is part of a dataset collection that presents ELY areas data for the year 2024 at a scale of 1:4,500,000. ELY, or Centre for Economic Development, Transport and the Environment, is a regional administrative agency in Finland. The table incorporates a varied range of columns that encapsulate diverse information. The data is geographical in nature, making it highly valuable for geospatial data analytics. Columns starting with 'geom_' contain this geographic information. For instance, 'geom_type' specifies the type of geographic shape represented, such as a polygon or multipolygon. The centroid of these shapes is stored in 'geom_centroid', while 'geom_center_x' and 'geom_center_y' store the longitude and latitude respectively, in the WGS 84 coordinate...
Version History of ELY Areas 2024 (Scale 1:4,500,000) TableTSV
The 'table__history' is a version history table that forms part of the dataset collection 'tilastointialueet_ely4500k_2024'. It comprises of the historical versions of the base table rows, with each row representing a particular version of the data from the ELY-areas 2024 at a scale of 1:4,500,000. The table includes a unique combination of '_start_date' and '_row_number' to identify each row. The '_start_date' column indicates the date when the row was extracted from the data source, while the '_row_number' column represents the row number in the raw data. The '_end_date' column contains the date when a new version of the row was extracted. If '_end_date' is null, it indicates that the row is the most recent version. In addition to these, the table incorporates geographical...

Column Descriptions

ELY Areas 2024 Projection at 1:4,500,000 Scale

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the data source. The format of the date is YYYY-MM-DD.
_row_number	long	This column contains the row number in the data extracted from the source. Each row number is unique for each extraction date.
ely	string	This column contains a string-type unique identifier for a specific geography within Finland.
geom_geojson	string	This column contains the geographical data of the region in GeoJSON format.
geom_geotext	string	This column contains the geographical data of the region in a text format.
geom_type	string	This column indicates the type of the geographical data which can be either a Polygon or a MultiPolygon.
geom_centroid	string	This column contains the coordinates of the centroid (geographical center) of the region.
geom_center_x	double	This column contains the x-coordinate (longitude) of the centroid of the region.
geom_center_y	double	This column contains the y-coordinate (latitude) of the centroid of the region.
gml_id	string	This column contains a unique GML (Geography Markup Language) identifier for each row.
id	long	This column contains an integer-type unique identifier for each row.
name	string	This column contains the English name of the region.
namn	string	This column contains the Swedish name of the region.
nimi	string	This column contains the Finnish name of the region.
vuosi	long	This column contains the year associated with the data row. The data type of this column is integer.

Version History of ELY Areas 2024 (Scale 1:4,500,000) Table

Column	Type	Comment
_start_date	date	Contains the date when the row was extracted from the data source, enabling tracking of the version history of the table rows.
_end_date	date	Holds the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the most recent version.
_row_number	long	Represents the number of the row in the raw data extracted from the data source. Combined with '_start_date', it uniquely identifies each row in this version history table.
ely	string	String data type column, holding a unique identifier for each ELY (Centre for Economic Development, Transport and the Environment) in Finland.
geom_geojson	string	Stores geometric data in GeoJSON format, representing the geographical boundaries of each ELY.
geom_geotext	string	Holds the geometric boundaries of each ELY as text, providing a human-readable format for the geographic data.
geom_type	string	Specifies the type of geometric shape used to represent the ELY boundaries, such as polygon or multipolygon.
geom_centroid	string	Contains the central point (centroid) of the geometric shape representing the ELY boundaries.
geom_center_x	double	Represents the X-coordinate of the centroid of the geometric shape representing the ELY boundaries.
geom_center_y	double	Represents the Y-coordinate of the centroid of the geometric shape representing the ELY boundaries.
gml_id	string	A string type column that contains a unique identifier for each row, provided by the data source.
id	long	An integer type column, representing a unique identifier for each row in the table.
name	string	Holds the English name of each ELY.
namn	string	Contains the Swedish name of each ELY.
nimi	string	Stores the Finnish name of each ELY.
vuosi	long	An integer type column, representing the year for which the row's data is relevant.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024