Historical Version of the Swedish-language Coastal Area Nomenclature Dataset on the Open Data District Map - Helsingin kaupunkiympariston toimiala (Finland)

This table contains the version history of the rows in the 'avoindataseutukartta_nimisto_merialue_ruotsi__seutukartta_nimisto_merialue_ruotsipoint' base table. The rows in this table represent different versions of the data extracted from the data source provided by 'Helsinki City Environment Department' in the country Finland (ISO country code: fi). The '_start_date' column indicates the date when the row was extracted, while the '_end_date' column shows the date when a new version of the row was extracted. If the value of the '_end_date' column is null, it means that the row represents the most recent version of the data. The table contains additional columns such as '_row_number', 'nimi_r', 'ikoord', 'pkoord', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom', and 'tietopalve', which can be utilized for various data analytics purposes. For instance, these columns can be used to analyze the geographical distribution of 'nimi_r' values, perform spatial queries based on the geographic coordinates ('ikoord' and 'pkoord'), or explore the geometric properties of the features represented by 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. The 'tietopalve' column may provide additional information related to the data source.