Large Areas 2013 (1:4 500 000) Dataset Table
The table, part of the 'tilastointialueet_suuralue4500k_2013' dataset collection, provides a comprehensive set of data pertaining to the large areas of Finland in 2013, as indicated by the data source description 'Suuralueet 2013 (1:4 500 000)'. The table is sourced from the 'Tilastokeskus' website based in Finland.
The table includes a range of columns covering various aspects of geographical data. Unique regional identifiers are provided in the form of 'gml_id', while the 'name', 'namn', and 'nimi' columns offer the region's name in various languages. The 'suuralue' and 'vuosi' columns specify the larger area code and the year the data relates to, respectively.
Geospatial data is a significant part of this table, with several 'geom_' prefixed columns. For instance, 'geom_geojson' and 'geom_geotext' present the geographical data in GeoJSON and text format respectively, while 'geom_type' indicates the type of the geographical shape. The 'geom_centroid', 'geom_center_x', and 'geom_center_y' columns present geographical coordinates. These coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
Two special columns, '_extract_date' and '_row_number', record the date of data extraction and the unique row number, respectively. These two columns can be utilized together to uniquely identify each row of data.
As for the utilization of this table in data analytics, it can be used in several ways. For instance, the geographical data can be used to perform geospatial analysis to study the spatial patterns and relationships of the large areas in Finland. Similarly, the time-specific data from the '_extract_date' column could be used to track changes in the data over time. The multilingual regional names can be helpful in creating localized data visualizations or reports.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on a particular row was extracted from the data source. It helps in tracking the timeline of data extraction. |
| _row_number | long | This column holds the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It helps in identifying each row uniquely when combined with '_extract_date'. |
| geom_geojson | string | This column holds geometric data in the GeoJSON format. It provides spatial representation of the geographical entities. |
| geom_geotext | string | This column stores geometric data in text format. It provides a textual representation of the geographical entities. |
| geom_type | string | This column indicates the type of the geometrical data stored in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column contains the central point of the geometric shape representing the geographic entity. |
| geom_center_x | double | This column holds the x-coordinate of the center point of the geometric entity. |
| geom_center_y | double | This column holds the y-coordinate of the center point of the geometric entity. |
| gml_id | string | This column holds the unique identifier for each row in the table. |
| name | string | This column contains the English names of the geographical entities. |
| namn | string | This column has the names of the geographical entities in Swedish. |
| nimi | string | This column holds the names of the geographical entities in Finnish. |
| suuralue | string | This column holds an identifier for the larger area to which the geographical entity belongs. |
| vuosi | long | This column indicates the year associated with the data in each row. |
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 | de76a445-da3e-4160-858e-1ab7207cefa5 |
| Package id | 4bf8ab2c-30ec-4738-8e82-2f83ee27ad5e |
| Revision id | 53af5ea5-3d59-4025-a7aa-8681846cdada |
| State | active |
| Table | tilastointialueet_suuralue4500k_2013__table |