Large Areas 2020 (Scale 1:1 000 000) - Table from Dataset Collection
Click here for a data sample
The table is part of a larger dataset collection, focusing on the large areas of Finland in 2020. The data in the table provides detailed geographic information, making it a valuable resource for geospatial data analytics. The geographic coordinates in the table are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The table also provides unique identifiers for each entry by combining the date of data extraction and the row number. This allows for precise tracking and referencing of data. The table is sourced from the 'Tilastokeskus' (Statistics Finland) website. Examples of how this data could be utilized in analytics include identifying trends in regional data over time, mapping geographic patterns, or creating detailed visualizations of large areas in Finland.
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 aids in uniquely identifying each row in conjunction with the '_row_number' column. |
|---|
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It helps in uniquely identifying each row when combined with the '_extract_date'. |
|---|
| geom_geojson | string | This column contains the geometric representation of data points in GeoJSON format, a format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains the geometric representation of data points in text format. It provides a textual representation of the geometric data present in the 'geom_geojson' column. |
|---|
| geom_type | string | This column indicates the type of geometric data recorded in the 'geom_geojson' and 'geom_geotext' columns, such as 'ST_MULTIPOLYGON'. |
|---|
| geom_centroid | string | This column contains the central point, or centroid, of the geometric data represented in the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| geom_center_x | double | This column contains the x-coordinate (longitude) of the central point of the geometric data. |
|---|
| geom_center_y | double | This column contains the y-coordinate (latitude) of the central point of the geometric data. |
|---|
| gml_id | string | This column contains a unique identifier for each row of data. |
|---|
| name | string | This column contains the name of the geographic area represented by the data in English. |
|---|
| namn | string | This column contains the name of the geographic area represented by the data in Swedish. |
|---|
| nimi | string | This column contains the name of the geographic area represented by the data in Finnish. |
|---|
| suuralue | string | This column contains a numerical code representing the large area associated with the data row. |
|---|
| vuosi | long | This column contains the year associated with the data row. |
|---|
