0

Explanation:
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

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

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.