X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/e0a7b94e49cb4c47d0a42f0d8108f826e9de59f3..baf1b955fb27e9b4e4c7c1146b87627e13be6ac1:/lib-sql/functions/place_triggers.sql?ds=sidebyside diff --git a/lib-sql/functions/place_triggers.sql b/lib-sql/functions/place_triggers.sql index a472d26d..0bbd775e 100644 --- a/lib-sql/functions/place_triggers.sql +++ b/lib-sql/functions/place_triggers.sql @@ -156,6 +156,7 @@ BEGIN SELECT DISTINCT osm_id, address, geometry FROM place, planet_osm_ways w WHERE NEW.geometry && place.geometry and place.osm_type = 'W' + and place.address ? 'interpolation' and exists (SELECT * FROM location_property_osmline WHERE osm_id = place.osm_id and indexed_status in (0, 2))