Statistical Areas ELY1000K 2018 Collection

The dataset collection is an aggregation of related data tables that have been sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland. These tables contain a wealth of data provided by the service interface of Tilastokeskus, which has been organized in a structured table format for easier understanding and analysis. The dataset collection is designed to provide a comprehensive view of the data, allowing users to draw connections and insights from the collated information. 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 2018 (Scale 1:1,000,000) TableTSV
The table belongs to the dataset collection titled 'tilastointialueet_ely1000k_2018'. It contains data related to ELY-areas in 2018 at a scale of 1:1 000 000, which is sourced from the 'Tilastokeskus' website in Finland. The table consists of various columns that store a range of data types, including geographic information and date-time data. Two columns, 'extract_date' and '_row_number', play a crucial role in uniquely identifying each row of data. The '_extract_date' column represents the date when the data row was extracted from the source, whereas '_row_number' provides the row number in the data extracted from the source on the specified extract date. Columns beginning with 'geom' are storing geospatial data, which can be leveraged for geospatial data analytics. The geographic...
ELY Areas 2018 Version History (1:1 000 000)TSV
The 'table__history' is a comprehensive historical data repository that belongs to the 'tilastointialueet_ely1000k_2018' dataset collection. The primary purpose of this history table is to keep track of the version history of the base table rows, making it a valuable resource for tracking changes over time. The data included in the table is sourced from the 'Tilastokeskus' website, which is based in Finland. The table records the detailed information of ELY-areas in 2018 (1:1 000 000 scale). Each row in the table is uniquely identified by a combination of '_start_date' and '_row_number', which denote the date the row was extracted from the data source and the number of the row in the raw data respectively. The table also registers the '_end_date', indicating when a new version of the...

Column Descriptions

ELY Areas 2018 (Scale 1:1,000,000) Table

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'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row.
ely	string	This is a string type column that likely contains codes or identifiers related to the data.
geom_geojson	string	This column contains geometric data in the GeoJSON format. This data typically represents shapes or locations on a map.
geom_geotext	string	This column contains geometric data in a text format. Similar to the 'geom_geojson' column, it represents shapes or locations on a map.
geom_type	string	This column indicates the type of geometry stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the geometric center or centroid of the shape or location represented by the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	This column contains the X coordinate of the geometric centroid.
geom_center_y	double	This column contains the Y coordinate of the geometric centroid.
gml_id	string	This is a string type column that likely contains a unique identifier for each row in the table.
id	long	This is an integer type column that likely contains a unique identifier for each row in the table.
name	string	This is a string type column that likely contains names associated with the data in each row.
namn	string	This is a string type column that likely contains additional names or identifiers associated with the data in each row.
nimi	string	This is a string type column that likely contains additional names or identifiers associated with the data in each row.
vuosi	long	This is an integer type column that likely contains year information associated with the data in each row.

ELY Areas 2018 Version History (1:1 000 000)

Column	Type	Comment
_start_date	date	This is a special column that captures the date when a row was extracted from the data source. It forms a unique combination with '_row_number' to identify each row in the version history table.
_end_date	date	Another special column that records the date when a new version of a 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	This column contains the number of the row as it appears in the raw data extracted from the data source. It is used in conjunction with '_start_date' to uniquely identify each row in the history table.
ely	string	This column captures a coded string representation of the ELY Center, a regional administrative unit in Finland.
geom_geojson	string	This column contains the geographical data of the ELY Center in GeoJSON format, a widely used format for encoding a variety of geographic data structures.
geom_geotext	string	This column holds the geographical data of the ELY Center as a text string, represented in a format known as Well-Known Text (WKT).
geom_type	string	This column specifies the type of the geographical data represented, e.g., MultiPolygon.
geom_centroid	string	This column contains the geographical coordinates of the centroid (geometrical center) of the ELY Center region.
geom_center_x	double	This column records the X coordinate of the geographic center of the ELY Center region.
geom_center_y	double	This column records the Y coordinate of the geographic center of the ELY Center region.
gml_id	string	This column contains a unique identifier for each row in the table.
id	long	This column contains an integer value representing the ID of a row, as provided by the data source.
name	string	This column contains the English name of the ELY Center.
namn	string	This column contains the name of the ELY Center in Swedish.
nimi	string	This column contains the name of the ELY Center in Finnish.
vuosi	long	This column records the year of the data, represented as an integer.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024