I have two tables with the same street network as geometry (but not a same id). What I wanna do is to join both Tables with all attributes to one for all geometries which overlap exactly. Unfortunately my query just gives me emtpy lines back. I am working with left join, but all other joins won't work as well.
أكثر...
DROP TABLE IF EXISTS test; CREATE TABLE test as SELECT * FROM table1 right join table2 on ST_Equals(table1.the:geom, table2.the_geom);
Anybody knows an answer for that?
أكثر...