Statistical Area Tables for Municipalities 2013

The dataset collection at hand is a compilation of related data tables. These tables, sourced from the 'Tilastokeskus' website in Finland, present a rich trove of information. The dataset collection is a methodical assembly of related data, organized meticulously in a tabular format comprising of columns and rows. It's interesting to note that the dataset collection is sourced from the service interface (WFS) of the Statistics Finland (Tilastokeskus), providing a high degree of authenticity and reliability to the data. 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 2013 (1:4 500 000) - Data TableTSV
This table, sourced from the 'Tilastokeskus' website in Finland, contains comprehensive data pertaining to the municipalities in 2013. The data has been meticulously organized, offering a wealth of information for potential analysis. The table includes geographic information about each municipality, encoded in several formats such as GeoJSON and GeoText. This data, represented using the WGS 84 coordinate reference system (longitude followed by latitude), provides insights into the exact location and boundaries of each municipality. This could be utilized in geospatial data analytics, for example, to study population distribution or infrastructure planning across different municipalities. In addition to the geographic data, the table also includes details about each municipality like its...
Version History of Municipalities 2013 (1:4 500 000)TSV
The table captures historical data pertaining to municipalities in Finland, as sourced from the 'Tilastokeskus' website. It serves as a historical record, tracking the changes in data over time. The information in the table is structured into multiple columns that contain various data points. Each column represents a unique attribute of the data, like dates of data extraction, row numbers, geographic coordinates, and municipality identifiers. The table's contents include geographical data related to municipalities as of 2013, which can be utilized for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This data captures the shape and position of the...

Column Descriptions

Municipalities 2013 (1:4 500 000) - Data 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 source. It helps to understand when the particular data was recorded.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date. It is used in conjunction with the '_extract_date' column to uniquely identify each row.
geom_geojson	string	This column contains the geometrical data of the regions in GeoJSON format, a type of format used for encoding geographic data structures.
geom_geotext	string	This column contains the geometrical data in text format, which represents the spatial features of the regions.
geom_type	string	This column specifies the type of the geographic data structure stored in the 'geom_geojson' and 'geom_geotext' columns. In this case, it is a multi-polygon type.
geom_centroid	string	This column contains the centroid or the geometric center of the multi-polygon geometrical data.
geom_center_x	double	This column contains the x-coordinate of the centroid or center point of the geographic data.
geom_center_y	double	This column contains the y-coordinate of the centroid or center point of the geographic data.
gml_id	string	This column serves as a unique identifier for each row in the table.
kunta	string	This column contains a unique code representing a specific municipality or region.
name	string	This column contains the name of the municipality or region.
namn	string	This column also contains the name of the municipality or region, possibly in a different language or format.
nimi	string	This column also contains the name of the municipality or region, possibly in a different language or format.
vuosi	long	This column represents the year the data was recorded or pertinent to.

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

Column	Type	Comment
_start_date	date	The date when the data row was initially extracted from the data source. This column, in combination with the '_row_number' column, uniquely identifies each row in the history table.
_end_date	date	The date when a new version of the data row was extracted from the source. If this column contains a null value, it means that the current row is the most recent version of the data.
_row_number	long	The number of the row as it was in the raw data extracted from the source. This column, in combination with the '_start_date' column, uniquely identifies each row in the history table.
geom_geojson	string	Contains the geographical data in the GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	Contains the geographical data in textual form.
geom_type	string	Identifies the type of the geographical data structure, for example, 'ST_MULTIPOLYGON'.
geom_centroid	string	Contains the geographical point that represents the centroid (geometric center) of the geographical data structure.
geom_center_x	double	The X coordinate of the center point of the geographical data structure.
geom_center_y	double	The Y coordinate of the center point of the geographical data structure.
gml_id	string	A unique identifier for each geographical feature in the data set.
kunta	string	A code representing a specific municipality in Finland.
name	string	The name of the municipality in Finland.
namn	string	This is another representation of the name of the municipality, typically in a different local language.
nimi	string	This is another representation of the name of the municipality, typically in a different local language.
vuosi	long	The year to which the data row is relevant.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024