Municipalities 2016 (Scale 1:4,500,000) - Data Table
The table in question is part of a dataset collection that is primarily focused on municipalities in 2016 at a scale of 1:4 500 000. The data within the table is quite comprehensive and versatile, encompassing various areas of information, including geographic and temporal details.
The table houses geographical information with the prefix 'geom_', which can be applied in geospatial data analysis. This information includes geojson data, geotext, type, centroid, and center coordinates (x and y), all presented in WGS 84 coordinate reference system, where longitude comes first, followed by latitude.
The table also includes columns for the municipality code ('kunta'), and the name of the municipality in three different languages ('name', 'namn', 'nimi'), which can be useful for multilingual data analysis or for creating multilingual visualizations of the data.
The temporal aspect is covered by the 'vuosi' column containing the year of data, and '_extract_date' column, which holds the specific date when the row data was extracted.
Unique identifiers for each row are provided by a combination of '_row_number', which holds the row number in the data extracted and '_extract_date'.
The data in the table could be utilized in various data analytics applications. For example, the geographic information could be used to create detailed maps of municipalities, highlighting patterns or changes over time. The multilingual nature of the data could be used to analyze language use and cultural differences across regions.
The table's data is sourced from 'Tilastokeskus' (Statistics Finland), a website based in Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column stores the date when the data row was extracted from the source. It helps track when the data was updated. |
| _row_number | long | This column holds the row number of the extracted data. It, combined with the extract date, uniquely identifies each row. |
| geom_geojson | string | This column contains the geographical data of the area represented in GeoJSON format, a common format for encoding geographical data. |
| geom_geotext | string | The column includes the geographical data of the area in text format. |
| geom_type | string | This column specifies the type of the geographical data, which in this case is 'ST_MULTIPOLYGON', indicating that the data represents multiple polygon areas. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid or geometric center of the area. |
| geom_center_x | double | This column holds the x-coordinate of the geometric center of the area. |
| geom_center_y | double | This column holds the y-coordinate of the geometric center of the area. |
| gml_id | string | This string-type column stores a unique identifier for the data row. |
| kunta | string | This string-type column holds an identifier for the municipality or area. |
| name | string | This string-type column stores the name of the area or municipality. |
| namn | string | This string-type column also stores the name of the area or municipality, possibly in a different language or format. |
| nimi | string | This string-type column contains another version of the name of the area or municipality. |
| vuosi | double | This real-type column stores the year associated with the data row, indicating the time period the data represents. |
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 | 491cc92f-5873-4203-acfe-c195b990ac68 |
| Package id | 8bae0a88-fe50-4457-8f0c-da501f041e6e |
| Revision id | d2c240f4-6d22-4587-aead-31115e9c47c9 |
| State | active |
| Table | tilastointialueet_kunta4500k_2016__table |