Historical Versions of Location Names and Coordinates in Finnish Coastal Areas on Open Data Spatial Map

This table contains the version history of rows extracted from the 'Helsingin kaupunkiympariston toimiala' website. The rows in this table represent various features found in marine areas in Finland. Each row has a unique identification number (_row_number) and includes information such as the name of the feature (nimi_s), geographical coordinates (ikoord and pkoord), geometrical data in both GeoJSON and Geotext formats (geom_geojson and geom_geotext), the type of geometry (geom_type), the centroid of the geometry (geom_centroid), the x and y coordinates of the center point (geom_center_x and geom_center_y), the full geometry (geom), and additional information provided by the 'tietopalve' service. The table includes two additional columns, '_start_date' and '_end_date', indicating the extraction dates of each row. The '_end_date' column is null for the most recent version of each row. This data can be utilized in data analytics to analyze and visualize marine features in Finland, study their distribution and patterns, analyze changes over time, and conduct spatial analysis.