Municipalities 2020 (Scale 1:1,000,000) - Data Table
Click here for a data sample
The 'table' is part of the 'tilastointialueet_kunta1000k_2020' dataset collection. The table comprises of structured data focusing on municipalities in 2020, as described by the original data source, 'Tilastokeskus' from Finland. Each row in the table represents a unique data entry, identifiable by the combination of two special columns, 'extract_date' and '_row_number'. The '_extract_date' indicates the date when the data was extracted, and the '_row_number' represents the row number in the data extracted on the specified date. The data contained within the table is enriched with a variety of columns providing detailed information about each municipality. This includes its name, ID, geographic coordinates, and more. The table also includes multiple columns starting with 'geom', which store geospatial data in various formats. These geographic coordinates are presented using the WGS 84 coordinate reference system, with longitude presented first, followed by latitude. The data in this table could be used for a range of data analytics purposes. For example, the geographic information could be used to analyze spatial distribution and trends of different municipalities. Similarly, the data extraction dates could be utilized to track changes and trends over time, giving valuable insights into the evolution of municipalities.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column contains the date when the data on the row was extracted from the source. It helps in keeping track of the data extraction history. |
|---|
| _row_number | long | This column holds the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. Together with '_extract_date', it uniquely identifies each row. |
|---|
| geom_geojson | string | This column stores the geometric representation of the data in GeoJSON format. This format is useful for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains the geometric data in text format. It provides another way to visualize the geographic data. |
|---|
| geom_type | string | This column specifies the type of the geometric data. It helps in understanding the nature of the geographic data. |
|---|
| geom_centroid | string | This column includes the centroid of the geometric data. The centroid is the geographical center point of the data. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the center of the geometric data. It aids in pinpointing the geographic location. |
|---|
| geom_center_y | double | This column holds the y-coordinate of the center of the geometric data. It helps in locating the geographic position. |
|---|
| gml_id | string | This column includes a unique identifier for each row. It helps in easy identification and referencing of the data. |
|---|
| kunta | string | This column stores a string value. The exact meaning and use of this column are not provided by the data source. |
|---|
| name | string | This column includes the name associated with the data. It could be the name of a place, person, event, or other entities. |
|---|
| namn | string | This column contains a string value. The specific meaning and usage of this column are not provided by the data source. |
|---|
| nimi | string | This column holds a string value. The exact meaning and use of this column are not provided by the data source. |
|---|
| vuosi | long | This column contains an integer value. The specific meaning and use of this column are not provided by the data source. |
|---|
