Version History of Geographical Names in Finland (from Helsingin kaupunkiympariston toimiala)

This table contains the version history of rows from the 'avoindataseutukartta_nimisto_paikannimet_suomi__seutukartta_nimisto_paikannimet_suomipoint' base table. It has additional columns '_start_date' and '_end_date' that indicate the extraction dates of the rows. The data in this table is sourced from the website of Helsingin kaupunkiympariston toimiala, which originates from Finland (ISO country code 'fi'). The table stores various attributes related to place names, such as 'nimi_s' (name), 'ikoord' (internal coordinate), 'pkoord' (public coordinate), 'geom_geojson' (geometry in GeoJSON format), 'geom_geotext' (geometry in Geotext format), 'geom_type' (geometry type), 'geom_centroid' (centroid of the geometry), 'geom_center_x' (x-coordinate of the geometry center), 'geom_center_y' (y-coordinate of the geometry center), 'geom' (geometry), and 'tietopalve' (information service). The data in this table can be utilized in data analytics for various purposes such as analyzing patterns in place names, spatial analysis, geographical visualizations, or identifying information services related to specific locations.