1
2
3
4
5
6
7
8

select distinct c.commune, c.rue, l.name, levenshtein(l.name, c.rue) from planet_osm_line l, planet_osm_polygon g, road_names_cad c
where l.highway is not null
AND ST_Intersects(l.way,g.way)
AND g.name = 'Commune ' || c.commune 
AND NOT EXISTS (SELECT NULL WHERE g.name = 'Commune ' || c.commune AND c.rue = l.name)
AND levenshtein(l.name, c.rue) < 6
AND c.commune LIKE 'V%'
ORDER BY c.commune,levenshtein(l.name, c.rue);