I have 2 tables on PostgreSQL, one table named 'city' that have linestrings wich represents streets from a city (using QGIS I downloaded OpenStreetMaps data and imported to PostgreSQL using shp2pgsql). Linestrings from table 'city' loaded to QGIS

The second table named 'round' also contain linestring wich represent routes from some vehicles (Using a Google API they were drowed). Linestrings from table 'round' loaded to QGIS

Using QGIS I start visualazing how both tables look like: Comparing table city with table round

When I made zoom to compare both tables I realized that differed alot in different positions
Diference between linestrings
My question:
¿Is there anyway to automatically update the lines from table 'round' so they can perfectly match with the lines from table 'city'?
approximitation of what i need to solve

  • QGIS has the algorithm v.snap. Not sure if it will work, but probably worth trying. – csk Jan 18 '19 at 19:13
  • Try this PostGIS feature on copies of your data: postgis.net/docs/ST_Snap.html – Cyril Jan 18 '19 at 19:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.