Open Peace Natural Areas in Finland
Click here for a data sample
This table contains data from 'Helsinki City Environment Sector' sourced from the website of the sector. The data in this table is sourced from Finland (ISO country code 'FI'). The table contains information related to a natural area named 'ltj_avoinrauh_natura__rauh_naturaline'. The table includes various columns such as '_extract_date', '_row_number', 'id', 'tunnus', 'luokkatunn', 'luokan_nim', 'nimi', 'kuvaus', 'huom', 'digipvm', 'pvm_editoi', 'pinta_ala', 'kohdetekst', 'metadata', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns provide valuable information that can be utilized for data analytics. For example, the 'pinta_ala' column represents the surface area of the natural area. By analyzing this column, it is possible to identify the largest and smallest natural areas within the dataset. The 'kuvaus' column contains descriptions of the natural areas, which can be analyzed to gain insights into the characteristics and features of each area. The 'digipvm' column represents the digitalization date, which can be used to track the progress of the digitalization process. Additionally, the 'geom_geojson' column stores the geographical data of the natural areas in GeoJSON format, allowing for spatial analysis and mapping. Overall, this table provides a rich dataset for various data analytics purposes.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date on which the data was extracted. |
|---|
| _row_number | long | The number of the row in the table. |
|---|
| id | int | The unique identifier of the entry. |
|---|
| tunnus | string | The identifier of the item. |
|---|
| luokkatunn | string | The identifier of the class. |
|---|
| luokan_nim | string | The name of the class. |
|---|
| nimi | string | The name of the item. |
|---|
| kuvaus | string | The description of the item. |
|---|
| huom | string | Any additional notes or remarks. |
|---|
| digipvm | date | The date of the digital version. |
|---|
| pvm_editoi | date | The date of the latest edit. |
|---|
| pinta_ala | float | The surface area of the item. |
|---|
| kohdetekst | string | The target text. |
|---|
| metadata | string | The metadata information of the item. |
|---|
| geom_geojson | string | The geometry data in GeoJSON format. |
|---|
| geom_geotext | string | The geometry data in Geotext format. |
|---|
| geom_type | string | The type of geometry. |
|---|
| geom_centroid | string | A point representing the centroid of the geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry. |
|---|
| geom | binary | The geometry data. |
|---|
