Regions Data (1:4 500 000 scale)
Click here for a data sample
The table is a part of a larger dataset collection, representing Regions at 1:4 500 000 scale. It contains a wealth of information, both quantitative and qualitative, with a particular focus on geospatial data. This data is organized into various columns, each containing a different type of information. For instance, two of these columns specify when the data on each row was extracted and the row number in the data extracted, which together can uniquely identify each row. Furthermore, several columns contain geographic information, presented using the WGS 84 coordinate reference system, which can be utilized for geospatial data analytics. This geographic data includes the type of geometric shape that represents the region (e.g., polygon or multipolygon), the geometric shape itself in both GeoJson and Geotext formats, and the geographic coordinates of the centroid and center of the shape. Other columns contain identifiers, names in different languages (e.g., English, Finnish, and Swedish), and the year associated with the data. The table's information can be leveraged for various data analytics purposes. For example, one could use the geographic data to visualize the regions on a map, explore how the regions have changed over time, or analyze patterns related to the regions' characteristics. This table is sourced from the website of Statistics Finland (Tilastokeskus) in Finland.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column represents the date when the data on the row was extracted from the data source. |
|---|
| _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'. The combination of '_extract_date' and '_row_number' uniquely identifies each row. |
|---|
| geom_geojson | string | This column holds the geographical data in GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column holds the geographical data in textual format. It is a human-readable description of the shape of the geographical region. |
|---|
| geom_type | string | This column specifies the type of the geographical data. It could be either a Polygon or a Multipolygon. |
|---|
| geom_centroid | string | This column holds the centroid of the geographical region. The centroid is the arithmetic mean position of all the points in the shape. |
|---|
| geom_center_x | double | This column represents the x-coordinate of the center of the geographical region. |
|---|
| geom_center_y | double | This column represents the y-coordinate of the center of the geographical region. |
|---|
| gml_id | string | This column contains the unique identifier of the row in the table. |
|---|
| maakunta | string | This column represents a region in Finland, which is the country where the data source is located. |
|---|
| name | string | This column contains the English name of the region in Finland. |
|---|
| namn | string | This column contains the name of the region in Swedish, which is one of the official languages in Finland. |
|---|
| nimi | string | This column contains the name of the region in Finnish, which is the national language of Finland. |
|---|
| vuosi | long | This column contains the year when the data was collected. |
|---|
