jeudi 29 janvier 2015

Postgis: Conflation of two vector layers into a single layer


If I have table A that I consider to be definitive and table B that may have some elements missing from table B but also has geometries that are "close" to those in A that I want to ignore. How could I merge the two tables to get a conflated table C?


For reference this is Openstreetmap ways married with road data from another set.


Would I compare the start/middle and end points of the linestrings with table B to see if they were within X metres of any linestring in table A?





Aucun commentaire:

Enregistrer un commentaire