2014 Statistical Areas Collection for Finnish Municipalities

The dataset collection in question is an assembly of related data tables sourced from the 'Tilastokeskus' website, located in Finland. It comprises of a set of data tables that are meticulously organized into columns and rows, presenting an abundance of relevant data for diverse analysis. The data encapsulated within these tables originates from a service interface, translated to 'Statistics Center's service interface (WFS)'. This dataset collection provides a comprehensive set of information, making it a valuable resource for data-driven tasks and projects. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Municipalities 2014 (Scale 1:4,500,000) - Key Geometric and Statistical AttributesTSV
The 'table' is a part of the dataset collection 'tilastointialueet_kunta4500k_2014'. It contains related data organized in rows and columns. This table, in particular, contains data about 'Municipalities 2014' at a scale of 1:4,500,000, sourced from the 'Tilastokeskus' website in Finland. The table is rich with geographic information, which can be leveraged for geospatial data analytics. It contains columns for geographic coordinates presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. For example, the 'geom_center_x' and 'geom_center_y' columns provide the coordinates of the geographic center of each municipality. The table also includes information about the name of each municipality in different languages, and the year the...
Version History of Municipalities 2014 (1:4 500 000)TSV
The 'table__history' is a part of a dataset collection, 'tilastointialueet_kunta4500k_2014', sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland. It is a history table encapsulating the version history of its base tables' rows. It contains a unique identifier for each row, formed by a combination of the extraction date and the row number. The table's contents primarily consist of data related to the Finnish municipalities in 2014, with geographical data presented using WGS 84 coordinate reference system, in which the axis order is longitude first, followed by latitude. This geospatial data includes the type, centroid, centre x and y coordinates, and GeoJSON and GeoText representations of the geographical features. The table also contains information about the...

Column Descriptions

Municipalities 2014 (Scale 1:4,500,000) - Key Geometric and Statistical Attributes

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the source. It's part of a unique identifier for each row in conjunction with the '_row_number' column.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. Combined with the '_extract_date' column, it uniquely identifies each row.
geom_geojson	string	This column contains the geometric information of the data in GeoJSON format, which is a widely used format for encoding a variety of geographic data structures.
geom_geotext	string	This column stores the geometric information in text format, which provides an alternative way to visualize the data.
geom_type	string	This column specifies the type of geometric data used, in this case, it is 'ST_MULTIPOLYGON', indicating that the data represents multiple polygon areas.
geom_centroid	string	This column stores the geometric center (centroid) of the multipolygon areas represented in the data. It provides a single point that represents the center of the area.
geom_center_x	double	This column represents the X-coordinate of the centroid of the multipolygon areas. It's part of the spatial data of the dataset.
geom_center_y	double	This column represents the Y-coordinate of the centroid of the multipolygon areas. It's part of the spatial data of the dataset.
gml_id	string	This column contains a unique identifier for each row in the GML (Geography Markup Language) format.
kunta	string	This column contains a numerical code that represents the municipality where the data originates.
name	string	This column contains the name of the municipality in English.
namn	string	This column contains the name of the municipality in Swedish, which is one of the official languages in Finland.
nimi	string	This column contains the name of the municipality in Finnish, the other official language in Finland.
vuosi	long	This column contains the year when the data was collected.

Version History of Municipalities 2014 (1:4 500 000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source, marking the start of a specific version of a record.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source, marking the end of a specific version of a record. If this column's value is null, it indicates that the version of the row is the most recent.
_row_number	long	This column contains the number of the row as it appears in the raw data extracted from the data source. Together with the '_start_date', it uniquely identifies each row version in the table.
geom_geojson	string	This column contains the geographical representation of the area in GeoJSON format, a popular open standard format designed for representing simple geographical features.
geom_geotext	string	This column contains the textual representation of the geographical area in a format, which is readable by geographical information systems.
geom_type	string	This column specifies the type of the geographical representation stored. In this table, the values are of type 'ST_MULTIPOLYGON' indicating the area is represented by multiple polygons.
geom_centroid	string	This column contains the geographical coordinates of the centroid, or the geometric center, of the area.
geom_center_x	double	This column contains the x-coordinate (longitude) of the geometric center of the area.
geom_center_y	double	This column contains the y-coordinate (latitude) of the geometric center of the area.
gml_id	string	This column contains the unique identifier of the area provided by the data source.
kunta	string	This column contains the municipality code, a unique identifier for each municipality in Finland.
name	string	This column contains the Finnish name of the municipality.
namn	string	This column contains the Swedish name of the municipality.
nimi	string	This column repeats the Finnish name of the municipality.
vuosi	long	This column contains the year to which the data pertains.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024