Underwater Pollution - Water - Helsinki City Environment Department, Finland
Click here for a data sample
This table contains data on underwater pollution in open waters. It is sourced from the website of Helsingin kaupunkiympariston toimiala, a department in the City of Helsinki, Finland. The data is related to environmental monitoring and includes information such as the extraction date, row number, identification code, class identification, class name, name, description, notes, digital date, date of edit, surface area, target text, metadata, geometry in GeoJSON format, geometry in Geotext format, geometry type, centroid of geometry, x-coordinate of centroid, y-coordinate of centroid, and the raw geometry data.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted. |
|---|
| _row_number | long | The unique identifier for each row. |
|---|
| id | int | The unique identifier for each record. |
|---|
| tunnus | int | The code associated with the record. |
|---|
| luokkatunn | string | The class code of the record. |
|---|
| luokan_nim | string | The name of the class. |
|---|
| nimi | string | The name of the record. |
|---|
| kuvaus | string | The description of the record. |
|---|
| huom | string | Any additional remarks or comments regarding the record. |
|---|
| digipvm | string | The digital date associated with the record. |
|---|
| pvm_editoi | string | The date when the record was edited. |
|---|
| pinta_ala | int | The area of the record in square units. |
|---|
| kohdetekst | string | The text associated with the record. |
|---|
| metadata | string | Any additional metadata related to the record. |
|---|
| geom_geojson | string | The geometry of the record in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the record in geotext format. |
|---|
| geom_type | string | The type of the geometry. |
|---|
| geom_centroid | string | The centroid of the geometry of the record. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry. |
|---|
| geom | binary | The full geometry of the record. |
|---|
