X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/6dac643d2c48c00065c68e575f7dbbc092175245..8c82f6ceb3b77ebadc0bfc08422652902fc437a8:/lib-sql/functions/partition-functions.sql diff --git a/lib-sql/functions/partition-functions.sql b/lib-sql/functions/partition-functions.sql index e5d356e1..20ec3da6 100644 --- a/lib-sql/functions/partition-functions.sql +++ b/lib-sql/functions/partition-functions.sql @@ -17,7 +17,7 @@ CREATE TYPE nearfeaturecentr AS ( centroid GEOMETRY ); --- feature intersects geoemtry +-- feature intersects geometry -- for areas and linestrings they must touch at least along a line CREATE OR REPLACE FUNCTION is_relevant_geometry(de9im TEXT, geom_type TEXT) RETURNS BOOLEAN @@ -96,7 +96,7 @@ BEGIN AND rank_address between from_rank and to_rank AND token_matches_address(token_info, key, keywords) GROUP BY place_id, keywords, rank_address, rank_search, isguess, postcode, centroid - ORDER BY bool_or(ST_Intersects(geometry, feature)), distance LIMIT 1; + ORDER BY bool_or(ST_Intersects(geometry, feature)) DESC, distance LIMIT 1; RETURN r; END IF; {% endfor %}