I have two tables with the same street network as geometry (but not a same id). What I want to 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);
Does anybody know an answer for this?