Subregions 2016 (1:4 500 000) - A Table from the Collection 'tilastointialueet_seutukunta4500k_2016'
The table in question is part of a larger dataset collection, and it features a range of data related to the Finnish sub-regional units (Seutukunnat) in 2016. The data content of this table is a rich mix of geographic and demographic information, making it a valuable resource for various forms of data analytics.
The table includes geographic data represented through multiple columns. For instance, the content of certain columns is dedicated to providing geospatial information in geojson and geotext formats, represented as multipolygons. The geographic coordinates within these columns are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This specific format is recognized for its ability to support geospatial data analytics.
In addition to geospatial data, the table also contains demographic information. There are columns that provide the names of the sub-regional units in different languages, making this dataset useful for multilingual data analyses.
A unique aspect of this table lies in its special columns: '_extract_date' and '_row_number'. The '_extract_date' column records the date when the data on the row was extracted, while the '_row_number' column holds the row number in the data extracted on the specified date. Together, these two columns can uniquely identify each row, providing a useful tool for tracking data changes over time.
The utilization of the data in this table can span multiple areas of data analytics. For instance, the geographic information can be used in geospatial analytics to understand the spatial distribution of the sub-regional units. Meanwhile, the demographic data can be used to conduct regional studies or comparative analyses between different areas.
The table is sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column represents the date when the data in each row was extracted from the source. |
| _row_number | long | This column contains the unique row number extracted from the source on the extract date specified in the '_extract_date' column. |
| geom_geojson | string | This column contains geometric data in GeoJSON format, which represents the geographic features of the areas. |
| geom_geotext | string | This column contains geometric data in text format, representing the geographic features of the areas. |
| geom_type | string | This column describes the type of geometric data contained in the records, which in this case is a multipolygon. |
| geom_centroid | string | This column contains geometric data representing the central point (centroid) of the geographic features. |
| geom_center_x | double | This column represents the X-coordinate of the central point of the geographic features. |
| geom_center_y | double | This column represents the Y-coordinate of the central point of the geographic features. |
| gml_id | string | This column contains a unique identifier for each record in the GML format. |
| name | string | This column contains the name of the area in English. |
| namn | string | This column contains the name of the area in a different language, possibly Swedish or Finnish. |
| nimi | string | This column contains the name of the area in another language, likely Finnish. |
| seutukunta | string | This column contains a code that represents the region of the area. |
| vuosi | double | This column represents the year to which the data pertains, in this case, 2016. |
No sample for this dataset
Additional Information
| Last updated | November 11, 2024 |
|---|---|
| Created | November 11, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2024-11-11 |
| Id | c1796f3b-71b5-408b-a58e-1a09afefe0a4 |
| Package id | 549231ba-4214-424f-b255-6fc77ae49018 |
| Revision id | 48b6ae47-6845-4877-82f8-19acb272f0e0 |
| State | active |
| Table | tilastointialueet_seutukunta4500k_2016__table |