2015 Major Regions Data (1:4,500,000) Extracted From Finnish Statistical Database
The table, sourced from the 'Tilastokeskus' (Statistics Finland) website, represents comprehensive geographical and statistical data of 'Suuralueet 2015' - Major Areas in 2015, at a scale of 1:4 500 000. This table, part of the 'tilastointialueet_suuralue4500k_2015' dataset, contains various columns that offer rich insights about each area.
The table provides geographical location details through several 'geom_' prefixed columns, containing geographic coordinates in the WGS 84 coordinate reference system with axis order longitude first, followed by latitude. These columns contain information such as the geometric representation in both GeoJSON and geotext format, the geometric type, centroid of the area, and the X and Y coordinates of the center.
For statistical data, the 'name', 'namn', and 'nimi' columns provide the names of the major areas in English, Swedish, and Finnish respectively. The 'suuralue' column provides numerical identifiers for these areas, while 'vuosi' indicates the year of data collection. The 'shape_star' and 'shape_stle' columns offer further geographical data, providing the area and length of the boundary respectively.
Two special columns, '_extract_date' and '_row_number', offer meta-data about the data extraction process. The '_extract_date' column shows the date when the data row was extracted from the source, while the '_row_number' column provides the row number in the extracted data, with the combination of these two columns uniquely identifying each row.
The data in this table can be utilized for a wide range of data analytics applications. For instance, geospatial analysis could be performed to study geographical patterns and trends, or statistical analysis could be used to understand the distribution of areas. Similarly, the data can be used in predictive modeling, to forecast changes based on historical data, or in data visualization, to present the data in a more understandable and interactive format.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the source. It helps in tracking the freshness of the data. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date. It is unique and helps in identifying each row. |
| geom_geojson | string | This column contains geographical data in the form of GeoJSON, a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains geographical data in the form of text. It provides a textual representation of the geographical structure. |
| geom_type | string | This column specifies the type of the geometry of the geographical data. |
| geom_centroid | string | This column contains the geographical center point of the data in a POINT format. |
| geom_center_x | double | This column represents the X coordinate of the geographical center point of the data. |
| geom_center_y | double | This column represents the Y coordinate of the geographical center point of the data. |
| gml_id | string | This string column acts as an identifier for each record. |
| name | string | This column contains the English name of the geographical area. |
| namn | string | This column contains the name of the geographical area in Swedish. |
| nimi | string | This column contains the name of the geographical area in Finnish. |
| shape_star | double | This column contains a real number value representing a property of the geographical shape. |
| shape_stle | double | This column contains a real number value representing another property of the geographical shape. |
| suuralue | string | This string column represents a specific attribute of the geographical area. |
| vuosi | double | This column contains a real number representing 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 | c6704690-bf92-404d-9af1-0ce253973f80 |
| Package id | 8f0a1630-d412-446f-b9ef-851590c8d945 |
| Revision id | e468ff02-37fc-4993-960a-26684b83bbed |
| State | active |
| Table | tilastointialueet_suuralue4500k_2015__table |