Version History of Industrial Noise Areas in Helsinki - Helsingin kaupunkiympariston toimiala - Finland

This table contains the version history of the rows from the 'Helsingin kaupunkiympariston toimiala' data source, which originates from the country Finland (ISO country code 'fi'). The rows in this table represent different versions of the base table rows from the table 'helhki_teollisuus_melualueet_den__hki_teollisuus_melualueet_den'. Each row in this history table is associated with a start date ('_start_date') and an end date ('_end_date'), indicating the time period during which the particular version of the row was valid. If the end date is null, it means that the row is the most recent version. The table includes additional columns such as '_row_number' for identification purposes, 'objectid' for referencing the original objects, 'melu_db' for noise database information, 'geom_geojson' for geometric data in GeoJSON format, 'geom_geotext' for geometric data in textual format, 'geom_type' for the type of geometric shape, 'geom_centroid' for the centroid of the geometric shape, 'geom_center_x' and 'geom_center_y' for the X and Y coordinates of the center of the shape, and 'geom' which stores the geometric data. The data in this table can be utilized in various data analytics scenarios, such as trend analysis, change detection, or historical data comparisons, to understand the evolution of the noise areas in Helsinki over time.