Statistics Area Municipality 1000K 2015 Collection
Tables
-
Municipalities 2015 (1:1 000 000) Dataset TableTSV
The table in discussion, part of a specific dataset collection, houses a well-organized set of data regarding municipalities as of 2015 in a very detailed format. It is sourced from 'Tilastokeskus' (Statistics Finland), a Finnish website. The data is represented in columns and rows, wherein each row signifies a unique set of data, and each column represents a specific aspect or attribute of that data. The table incorporates various geographical data, which can be highly valuable for geospatial data analytics. It includes columns that represent geographic information in various formats such as GeoJSON and GeoText, and even the type of geometry. It also provides the centroid coordinates and the X and Y coordinates of the geometric center. These coordinates are represented using the WGS 84...
-
Version History of Municipalities 2015 (1:1 000 000) TableTSV
The 'table__history' is a historical data table that contains the version history of its original base rows, providing an evolutionary perspective on the data. It belongs to the 'tilastointialueet_kunta1000k_2015' dataset collection, which is a group of related tables that provide a rich and multifaceted view of the data. The table was sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland. The table presents a comprehensive set of columns that capture various aspects of the data. For instance, it contains special columns like '_start_date' and '_end_date', which respectively indicate the date when a row was extracted from the data source and when a new version of the row was extracted. The '_row_number' column indicates the number of the row in the raw data, and...
Column Descriptions
Municipalities 2015 (1:1 000 000) Dataset Table
Column | Type | Comment |
---|---|---|
_extract_date | date | This column contains the date when the data on the row was extracted from the source. This, together with '_row_number', uniquely identifies each row. |
_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'. This, together with '_extract_date', uniquely identifies each row. |
geom_geojson | string | This column contains the geographical data in GeoJSON format, a format for encoding geographic data structures. |
geom_geotext | string | This column contains the geographical data in text format that describes the geospatial topology. |
geom_type | string | This column specifies the type of the geographical data, which is 'ST_MULTIPOLYGON', indicating that the data represents a collection of polygons. |
geom_centroid | string | This column contains the geographical coordinates of the centroid for the geographical area represented by the row. |
geom_center_x | double | This column contains the x-coordinate of the center point of the geographical area represented by the row. |
geom_center_y | double | This column contains the y-coordinate of the center point of the geographical area represented by the row. |
gml_id | string | This column contains a unique identifier for each row. The identifiers have the format 'kunta1000k_2015.XXX'. |
kunta | string | This column contains a numerical code that represents different municipalities in Finland. |
name | string | This column contains the name of the municipality in English. |
namn | string | This column contains the name of the municipality in Swedish. |
nimi | string | This column contains the name of the municipality in Finnish. |
shape_star | double | This column contains numerical values which may represent the area of the municipal region in square meters. |
shape_stle | double | This column contains numerical values which may represent the perimeter of the municipal region in meters. |
vuosi | double | This column contains the year the data was recorded, which is 2015 in this dataset. |
Version History of Municipalities 2015 (1:1 000 000) Table
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. It is part of a combination with '_row_number' that uniquely identifies each row in the version history table. |
_end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value of this column is null, it means 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 is part of a combination with '_start_date' that uniquely identifies each row in the version history table. |
geom_geojson | string | This column contains the geometric representation of the area in GeoJSON format. |
geom_geotext | string | This column contains the geometric representation of the area in Well-Known Text (WKT) format. |
geom_type | string | This column indicates the type of the geometry used in the 'geom_geotext' and 'geom_geojson' columns. |
geom_centroid | string | This column contains the centroid of the area represented by the geometry, which is the center point of the area. |
geom_center_x | double | This column contains the x-coordinate of the center of the area represented by the geometry. |
geom_center_y | double | This column contains the y-coordinate of the center of the area represented by the geometry. |
gml_id | string | This column contains a unique identifier in GML format. |
kunta | string | This column contains a string type data representing the municipality or area. |
name | string | This column contains the English name of the municipality or area. |
namn | string | This column contains the Swedish name of the municipality or area. |
nimi | string | This column contains the Finnish name of the municipality or area. |
shape_star | double | This column contains the area of the shape in square units. |
shape_stle | double | This column contains the length of the shape's perimeter. |
vuosi | double | This column contains the year, represented as a real type data, associated with the data record. |
Additional Info
Last Updated | November 12, 2024 |
---|---|
Created | November 11, 2024 |