Regions Projection 2023 (Scale: 1:4,500,000)
Click here for a data sample
The table under discussion is an integral part of a larger dataset collection, which focuses on the geographical divisions of Finland in 2023. The data in the table is sourced from the Finnish statistical authority, 'Tilastokeskus' (Statistics Finland). The table contains several columns that store detailed geographical information valuable for geospatial data analytics. For instance, the table includes columns containing geographic information in both GeoJSON and GeoText formats, as well as columns indicating the type of geographical shape and their centroids. These geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. Other columns in the table contain unique identifiers, region codes, and names in different languages (Finnish, Swedish, and English) for the regions. The year of the data, 2023, is also stored in a separate column. Two special columns in the table, '_extract_date' and '_row_number', serve to uniquely identify each row. The former indicates the date when the data was extracted from the source, while the latter assigns a unique row number to each data entry. This table, with its rich geographical data, can be employed in many data analytics scenarios. For instance, it could be used to track population changes across different regions over time, guide resource allocation based on population density, or assist in environmental study by providing precise location data.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column represents the date when the data was extracted from the data source. It helps in tracking the freshness of the data. |
|---|
| _row_number | long | This column indicates the row number of the data as extracted from the source on the extract date. This, in combination with '_extract_date', uniquely identifies each row. |
|---|
| geom_geojson | string | This column holds the geometrical data in GeoJSON format. The data represents the geographical boundaries of the regions. |
|---|
| geom_geotext | string | This column contains geometrical data in text format. Just like 'geom_geojson', it represents the geographical boundaries of the regions, but in a different format. |
|---|
| geom_type | string | This column specifies the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. It can be either a multipolygon or a polygon. |
|---|
| geom_centroid | string | This column contains the geographical coordinates of the centroid of the region. The centroid is the geometric center of a region. |
|---|
| geom_center_x | double | This column contains the x-coordinate (longitude) of the centroid of the region. |
|---|
| geom_center_y | double | This column contains the y-coordinate (latitude) of the centroid of the region. |
|---|
| gml_id | string | This column represents a unique identifier for each region in the dataset. |
|---|
| maakunta | string | This column holds codes representing different regions. |
|---|
| name | string | This column contains the English names of the regions. |
|---|
| namn | string | This column holds the names of the regions in Swedish. |
|---|
| nimi | string | This column stores the names of the regions in Finnish. |
|---|
| vuosi | long | This column indicates the year to which the data belongs. |
|---|
