Regional Units 2015 (Scale 1:1,000,000) Dataset Table
Click here for a data sample
The table contains geospatial data about the regions in Finland as of 2015, sourced from 'Tilastokeskus' (Statistics Finland). Each row in the table represents a distinct region, identified by a combination of the extraction date and the row number. The table provides comprehensive geographic details about each region, including geospatial details in GeoJSON and GeoText formats, a centroid point, and the center coordinates. These geospatial details follow the WGS 84 coordinate reference system, with the longitude listed first, followed by the latitude. Other details include the name of the region in various languages and the region's code. The data in this table could be utilized in several ways in data analytics. For example, it could be used to analyze geographic distribution and demographic trends in Finland, or to conduct geospatial analyses using the provided geographic coordinates. It could also be used to analyze regional differences in various metrics, using the region codes to combine this data with other datasets.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column records the date when the data in each row was extracted. It plays a crucial role in uniquely identifying each row in combination with the '_row_number' column. |
|---|
| _row_number | long | This column contains the row number from the data extracted on the date specified in the '_extract_date' column. This, in conjunction with '_extract_date', helps to uniquely identify each row. |
|---|
| geom_geojson | string | This column stores the geographical data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains geographical data represented as text, specifically in the form of MULTIPOLYGONs, which are used to define complex shaped geospatial objects. |
|---|
| geom_type | string | This column indicates the type of geometric object contained in the row. In the given sample, the type is 'ST_MULTIPOLYGON', suggesting complex shaped geospatial objects. |
|---|
| geom_centroid | string | This column represents the geometric center, or centroid, of the geospatial data as a point. This can be particularly useful for geographic computations. |
|---|
| geom_center_x | double | This column contains the X coordinate of the geometric center of the geospatial object. |
|---|
| geom_center_y | double | This column contains the Y coordinate of the geometric center of the geospatial object. |
|---|
| gml_id | string | This column contains a unique identifier for each geospatial feature, which is useful for linking and cross-referencing data. |
|---|
| name | string | This column contains the name of the region in the local language. |
|---|
| namn | string | This column contains the name of the region, potentially in a different local language or dialect. |
|---|
| nimi | string | This column also contains the name of the region, potentially in yet another local language or dialect. |
|---|
| seutukunta | string | This column contains a code representing the region. This can be useful for categorizing and grouping the data. |
|---|
| shape_star | double | This column contains data related to the shape of the geospatial object, though the specific meaning of this data is not clear from the provided information. |
|---|
| shape_stle | double | This column also contains data related to the shape of the geospatial object, though the specific meaning of this data is not clear from the provided information. |
|---|
| vuosi | double | This column contains real type data, which in the given sample is 2015.0. It could potentially indicate the year associated with the data. |
|---|
