Provinces 2016 (1:1 000 000) Table from Dataset Collection
The table named 'table' is an integral part of the dataset collection 'tilastointialueet_maakunta1000k_2016'. It provides data related to the regions of Finland in 2016 at a scale of 1:1 000 000. The data in the table is sourced from 'Tilastokeskus' (Statistics Finland).
The table contains a variety of columns which store diverse types of data. It has special columns like '_extract_date' and '_row_number', which contain the extraction date of the row data and the row number respectively. These columns uniquely identify each row in the table.
Geospatial data is also a significant part of this table. Columns starting with 'geom_' like 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y' hold geographic information. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
The table also has columns that hold details about regions such as 'maakunta', 'name', 'namn', 'nimi' and 'vuosi'. They contain region codes, names in different languages, and the year of the data, respectively.
This table proves to be a valuable resource for various data analytics tasks. For instance, using the geographic data, one could perform geospatial data analytics to study regional patterns or trends across Finland. The table could also be used to analyze changes in the regions over time by comparing data from different years.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains 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 these two columns uniquely identifies each row. |
| geom_geojson | string | This column contains the geometric data in GeoJSON format. |
| geom_geotext | string | This column contains the geometric data in text format. |
| geom_type | string | This column specifies the type of the geometric data. |
| geom_centroid | string | This column contains the centroid of the geometric data. |
| geom_center_x | double | This column contains the X coordinate of the center of the geometric data. |
| geom_center_y | double | This column contains the Y coordinate of the center of the geometric data. |
| gml_id | string | This column contains the unique identifier for the geometric data. |
| maakunta | string | This column contains the province code. |
| name | string | This column contains the name of the province in English. |
| namn | string | This column contains the name of the province in Swedish. |
| nimi | string | This column contains the name of the province in Finnish. |
| vuosi | double | This column contains the year associated with the data. |
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 | 7dcfc000-b50f-4337-b653-0a7903964068 |
| Package id | 909078bf-dc64-4bcd-ab87-8e250f88d478 |
| Revision id | bdd2e1c2-2a9e-46ba-a6a5-8a0d95488781 |
| State | active |
| Table | tilastointialueet_maakunta1000k_2016__table |