Water Subaquatic Contamination - Water Subaquatic Contamination Point - Version History

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.