[Technical Task] Refactor the logic of fetching and updating toponyms data

[yaroslav-vasylyshyn]

Brief overview

The task aims to refactor the logic for fetching and updating toponyms data in WebPasingUtils.cs file. Currently, the system downloads a ZIP file from a predefined URL, extracts a CSV file (houses.csv), processes it, compares the results with a local data.csv, and then saves the toponyms into an MS SQL database. The new requirement is to eliminate local CSV file storage.

Expected result

• No local CSV files (houses.csv or data.csv) are stored.
• The downloading, extracting, and coordinate-fetching processes (using the OSM Nominatim API with retry and circuit breaker policies via Polly) remain unchanged.

Additional Information

For a detailed documentation, refer to Additional Documentation in Attachments and PoC solution

Attachments

https://github.com/yaroslav-vasylyshyn/PoC_Storing_Toponyms Additional Documentation.docx