Large Regions 2021 (Scale 1:1,000,000) - Data Table
The table in focus, part of a larger dataset collection, is a rich source of geospatial data representing the 'Major Regions 2021' in Finland. The data is sourced from 'Tilastokeskus' (Statistics Finland), a reputable web source in Finland. The table is organized into several columns, each providing unique yet interconnected information.
Two columns, '_extract_date' and '_row_number', play a special role in the table. They capture the date of data extraction and the row number, respectively. Together, they ensure that each row of data can be uniquely identified.
The table also includes a series of 'geom_' columns. These columns contain geographic information which can be utilized for geospatial data analytics. They hold details such as geographic coordinates, types of geometry, and centroid of the geometric shapes. Notably, the geographic coordinates are presented using the WGS 84 coordinate reference system, with the longitude given first, followed by the latitude.
Other key columns in the table include 'name', 'namn', 'nimi', 'suuralue', and 'vuosi'. These columns capture the name of the regions in different languages, the identifier of the area, and the year of the data, respectively.
This table is a versatile tool in data analytics. For instance, it can be used to study regional demographics or to analyze spatial patterns in various socio-economic factors across Finland. The geographic information can also be used to create detailed maps for visual analytics. Furthermore, by tracking the '_extract_date', analysts can study temporal changes in the data over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row was extracted from the source. It is part of a unique identifier for each row when combined with '_row_number'. |
| _row_number | long | This column contains the row number from the data extracted from the source, creating a unique identifier for each row when combined with '_extract_date'. |
| geom_geojson | string | This column stores the geometric representation of the data in GeoJSON format. |
| geom_geotext | string | This column stores the geometric representation of the data in text format. |
| geom_type | string | This column indicates the type of the geometry. In this case, it is a multipolygon. |
| geom_centroid | string | This column contains the centroid point of the multipolygon, which is a point that defines its geometric center. |
| geom_center_x | double | This column contains the X-coordinate of the geometric center of the multipolygon. |
| geom_center_y | double | This column contains the Y-coordinate of the geometric center of the multipolygon. |
| gml_id | string | This column provides the unique identifier for the row in GML (Geography Markup Language) format. |
| name | string | This column provides the name of the area in English. |
| namn | string | This column provides the name of the area in Swedish. |
| nimi | string | This column provides the name of the area in Finnish. |
| suuralue | string | This column provides the code representing the large area to which the data pertains. |
| vuosi | long | This column indicates the year of 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 | 4a2ed331-95a7-4e9c-820c-f8a301d62b2b |
| Package id | 2e9909ee-2f8a-4f26-96a4-2f17fcbc2f41 |
| Revision id | daf3064e-d6a4-4af9-a79b-bc7c03f887df |
| State | active |
| Table | tilastointialueet_suuralue1000k_2021__table |