2016 Major Areas Dataset (Scale 1:4 500 000)
The table in question is part of a dataset that pertains to 'Suuralueet 2016 (1:4 500 000)', which translates to Major Areas 2016 (1:4 500 000). This dataset is hosted on the 'Tilastokeskus' (Statistics Finland) website, which is based in Finland. The table's data primarily revolves around geospatial information pertaining to these major areas, with a special focus on data extracted in the year 2016.
The data in the table is organized via a series of columns. Two key columns, '_extract_date' and '_row_number', are used to identify each row uniquely. The '_extract_date' column indicates the date when the row's data was collected, while '_row_number' signifies the row's specific position in the sequence of data extraction.
A significant portion of the columns start with 'geom_', indicating that they contain geographic information suitable for geospatial data analytics. For instance, columns like 'geom_centroid', 'geom_center_x', and 'geom_center_y' provide geographic coordinates. These coordinates follow the WGS 84 coordinate reference system, with the order being longitude first, followed by latitude.
Other columns provide further details about these major areas, such as their names in different languages and the year ('vuosi') to which the data pertains. This comprehensive data can prove to be extremely useful in a variety of analytics scenarios.
For instance, researchers studying population distribution or environmental changes can use this geospatial data to understand the landscape better. Similarly, businesses looking for expansion opportunities can analyze this data to identify suitable locations based on various geographic parameters. Additionally, government agencies can utilize this data for planning and development purposes, such as infrastructure development or disaster management.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | The date when the data on the row of the table was extracted from the data source. |
| _row_number | long | The row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This combination uniquely identifies each row. |
| geom_geojson | string | The geometric representation of the data in GeoJSON format, a popular format for encoding a variety of geographic data structures. |
| geom_geotext | string | The geometric representation of the data in text format. |
| geom_type | string | The type of the geometric representation, in this case, it is 'ST_MULTIPOLYGON', indicating the data represents multiple polygonal areas. |
| geom_centroid | string | The centroid, or geometric center of the polygonal area. |
| geom_center_x | double | The X-coordinate of the center of the polygonal area. |
| geom_center_y | double | The Y-coordinate of the center of the polygonal area. |
| gml_id | string | The unique identifier for each row in String format. |
| name | string | The English name of the area. |
| namn | string | The Swedish name of the area. |
| nimi | string | The Finnish name of the area. |
| suuralue | string | An identifier for the large area, stored as a String. |
| vuosi | double | The year of the data, stored as Real type. |
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 | e85a9ac3-98cc-4938-85da-e9b0a8c1fba1 |
| Package id | 36bc39de-99d7-4661-9118-9bc20d3101d1 |
| Revision id | f7deba41-b02a-414d-a346-8673b61ea759 |
| State | active |
| Table | tilastointialueet_suuralue4500k_2016__table |