Water Subaquatic Contamination - Water Subaquatic Contamination Point - Version History
Click here for a data sample
This table contains the version history of rows from the ltj_avoinvesi_vedenalainen_roskaantuminen__vesi_vedenalainen_roskaantuminenpoint base table. The rows in this table represent different versions of the data extracted from the web site of Helsingin kaupunkiympariston toimiala, which is the environmental sector of the city of Helsinki in Finland. Each row in the table has a start date (_start_date) indicating when the particular version of the row was extracted, and an end date (_end_date) indicating the date when a new version of the row was extracted. If a row has a null value in the _end_date column, it means that it is the most recent version of the row. The table contains several columns storing information about the data, including unique identifiers (id), codes (tunnus, luokkatunn), names (luokan_nim, nimi), descriptions (kuvaus), notes (huom), dates (digipvm, pvm_editoi), measurements (pinta_ala), texts (kohdetekst), metadata, and spatial information (geom_geojson, geom_geotext, geom_type, geom_centroid, geom_center_x, geom_center_y, geom). The data stored in this table can be utilized in various data analytics tasks, such as tracking changes in the underwater pollution levels over time, analyzing different types of pollution based on their characteristics, assessing the impact of pollution on specific areas or locations, and visualizing the spatial distribution of pollution in order to identify patterns and trends.
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The start date of the validity period for the row version. |
_end_date | date | The end date of the validity period for the row version. |
_row_number | long | The row number of the version in the table. |
id | int | The unique identifier for each row version. |
tunnus | int | The unique identifier for the row in the base table. |
luokkatunn | string | The identifier for the class of the row. |
luokan_nim | string | The name of the class of the row. |
nimi | string | The name of the row. |
kuvaus | string | The description of the row. |
huom | string | Additional notes or comments about the row. |
digipvm | string | The digital date of the row. |
pvm_editoi | string | The date when the row was edited. |
pinta_ala | int | The surface area of the row. |
kohdetekst | string | The target text of the row. |
metadata | string | Metadata related to the row. |
geom_geojson | string | The geometry of the row in GeoJSON format. |
geom_geotext | string | The geometry of the row in Geotext format. |
geom_type | string | The type of geometry for the row. |
geom_centroid | string | The centroid of the geometry of the row. |
geom_center_x | double | The x-coordinate of the center of the geometry of the row. |
geom_center_y | double | The y-coordinate of the center of the geometry of the row. |
geom | binary | The geometry of the row. |