Regional Divisions 2019 (Scale 1:1,000,000)
Click here for a data sample
The table belongs to a dataset collection that encompasses data on the regional divisions of Finland in 2019 at a scale of 1:1,000,000. This table includes several columns that contain various types of valuable data. The geographic information, provided in columns beginning with 'geom_', is especially useful for geospatial data analytics. These columns present geographic coordinates using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. The data in these columns could be used, for example, to create detailed maps or to analyse spatial patterns and trends. For instance, the 'geom_centroid' column provides the central point of each region, which could be used to determine the geographic centre of various phenomena or to calculate distances between regions. The table also includes columns that contain the names of the regions in different languages, which could be used in multilingual data analyses or to provide multilingual support in data-driven applications. The column 'seutukunta' provides a unique code for each region, which can be used for linking the table with other datasets from 'Statistics Finland' (Tilastokeskus). The column 'vuosi' indicates the year of the data, which can be used to track changes over time. Two special columns in the table, '_extract_date' and '_row_number', record the date of data extraction and the row number in the extracted data, respectively. These columns can be used to track the history of the data extraction and to uniquely identify each row in the table. In summary, this table provides a rich resource for various types of data analytics, from geospatial analyses and temporal trend analyses to multilingual studies and data linking.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column contains the date when the data on each row was extracted from the source. This, in combination with the '_row_number' column, allows for unique identification of each row. |
|---|
| _row_number | long | This column holds the row number of the data that was extracted on the date specified in the '_extract_date' column. Together with '_extract_date', this provides a unique identifier for each row. |
|---|
| geom_geojson | string | This is a geometric column that holds the spatial data in GeoJSON format, a common format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains the spatial data in text format, providing a human-readable representation of the geographic data structures. |
|---|
| geom_type | string | This column indicates the type of the geometric object represented in the 'geom_geojson' and 'geom_geotext' columns. The sample value 'ST_MULTIPOLYGON' suggests that the data points form multiple polygon shapes. |
|---|
| geom_centroid | string | This column contains the geometric center or centroid of the polygon shape defined in the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| geom_center_x | double | This column holds the x-coordinate of the geometric center of the polygon shape defined in the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| geom_center_y | double | This column holds the y-coordinate of the geometric center of the polygon shape defined in the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| gml_id | string | This is an identifier column holding unique string values. |
|---|
| name | string | This column contains the names of geographical areas. |
|---|
| namn | string | This column seems to hold the names of geographical areas in a different language, possibly Swedish, as suggested by the sample values. |
|---|
| nimi | string | This column also holds the names of geographical areas, possibly in Finnish, as suggested by the sample values. |
|---|
| seutukunta | string | This column contains identifiers for the geographical areas represented in the 'name', 'namn', and 'nimi' columns. |
|---|
| vuosi | long | This column holds the year value, as suggested by the sample value '2019'. This might indicate the year the data was collected or to which the data refers. |
|---|
