Municipalities 2014 (Scale 1:4,500,000) - Key Geometric and Statistical Attributes
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 data was collected. For example, the 'name' column provides the name of the municipality in English, while 'namn' and 'nimi' offer names in different languages. The 'vuosi' column indicates the year of data collection.
Two special columns in the table, '_extract_date' and '_row_number', serve to uniquely identify each row. '_extract_date' records the date when the data on the row was extracted from the source. '_row_number' gives the row number in the data extracted from the source on the extract date specified by the '_extract_date' column.
The data in the table could be utilized for various data analytics purposes. For instance, the geographic information could be used to create visualizations of municipalities in Finland. The municipality names in different languages can be used to analyze linguistic diversity among municipalities. The '_extract_date' and '_row_number' could be used to track changes in the data over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _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. |
No sample for this dataset
Additional Information
| Last updated | November 11, 2024 |
|---|---|
| Created | November 11, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2024-11-11 |
| Id | c66a7d1b-8540-41ce-9409-0609d8a9fa91 |
| Package id | 95050969-c4cc-445d-b88b-d7598ac18e25 |
| Revision id | 0895382b-7cf7-44ae-bf56-9b9324ad6dbe |
| State | active |
| Table | tilastointialueet_kunta4500k_2014__table |