Regional Statistics Interface 2021 Collection

The dataset collection at hand is a comprehensive assembly of related data tables. These tables are meticulously organized into columns and rows to present related data in a structured format. This particular collection is sourced from Statistics Finland (Tilastokeskus), a reliable and credible data source based in Finland. The information contained within these tables is provided through the Statistics Finland's service interface (WFS). This makes the dataset collection a rich and valuable resource for a wide range of data analysis 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

ELY Areas 2021 - Scaled 1:1,000,000TSV
The table is a component of a structured dataset collection, which comprises data related to the ELY-areas for the year 2021 at a scale of 1:1 000 000, sourced from the 'Statistics Finland' ('Tilastokeskus') website, located in Finland. The table contains several fields, including unique identifiers, geographic data, and descriptive information about each ELY-area. The geographic data, embedded in fields that begin with 'geom_', is crucial for geospatial analytics. It includes various forms of geographic information, such as GeoJSON data, geotext, geographic data type, geographic centroid, and coordinates of the geographic center. This geo-information is presented using the WGS 84 coordinate reference system, with the axis order of longitude followed by latitude. The table also...
History Version Record of ELY Areas 2021 (Scale 1:1,000,000)TSV
The 'table__history' is a part of a dataset collection, which contains historical and geographical data. The contents of the table are derived from the ELY-areas 2021 (1:1 000 000) which gives an overview of different regions in Finland, as obtained from the 'Statistics Finland' (Tilastokeskus) website. This history table maintains the version history of the base table rows, including the date of extraction from the data source and the date when a new version of the row was extracted. The most recent version of the row is indicated by a null value in the '_end_date' column. The table uniquely identifies each row using the combination of '_start_date' and '_row_number', where '_row_number' represents the sequence of the row as it was in the raw data. In addition to historical data, the...

Column Descriptions

ELY Areas 2021 - Scaled 1:1,000,000

Column	Type	Comment
_extract_date	date	This special column stores the date when the data on each row was extracted from the data source. The format is YYYY-MM-DD.
_row_number	long	This special column stores the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. Together with '_extract_date', this column uniquely identifies each row.
ely	string	This column contains a string type code representing different regions.
geom_geojson	string	This column contains geographical data in GeoJSON format, which represents different geographical shapes.
geom_geotext	string	This column stores geographical data as text. It represents different geographical shapes similar to the 'geom_geojson' column.
geom_type	string	This column indicates the type of the geographical shape represented in the 'geom_geojson' and 'geom_geotext' columns. It can be either ST_MULTIPOLYGON or ST_POLYGON.
geom_centroid	string	This column contains the central point of the geographical shape represented in the 'geom_geojson' and 'geom_geotext' columns. It is stored as a POINT type.
geom_center_x	double	This column contains the x-coordinate of the central point in the geographical shape.
geom_center_y	double	This column contains the y-coordinate of the central point in the geographical shape.
gml_id	string	This column contains a unique string identifier for the data row.
id	long	This column contains a unique integer identifier for the data row.
name	string	This column contains the English names of different regions.
namn	string	This column contains the names of different regions in other languages.
nimi	string	This column contains the names of different regions in Finnish language.
vuosi	long	This column contains the year when the data was collected. The format is YYYY.

History Version Record of ELY Areas 2021 (Scale 1:1,000,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 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 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 in combination with the '_start_date' column.
ely	string	This column contains a string that represents the ELY (Centre for Economic Development, Transport and the Environment) of the region.
geom_geojson	string	This column contains the geometry of the region in GeoJSON format, a popular format for encoding geographic data structures.
geom_geotext	string	This column contains the geometry of the region in a text format.
geom_type	string	This column specifies the type of the geometry, e.g., polygon or multipolygon.
geom_centroid	string	This column contains the centroid of the geometry in point format.
geom_center_x	double	This column contains the x-coordinate of the center of the geometry.
geom_center_y	double	This column contains the y-coordinate of the center of the geometry.
gml_id	string	This column contains a unique identifier for each row in the GML (Geography Markup Language) format.
id	long	This column contains a unique integer identifier for each row.
name	string	This column contains the English name of the ELY Centre.
namn	string	This column contains the name of the ELY Centre in Swedish.
nimi	string	This column contains the name of the ELY Centre in Finnish.
vuosi	long	This column contains the year of the data.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024