X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/f863040b38a6c7586c06623715f1010c268b1f37..c5fe2ac2067c7154370c3abd6ccca45b0d657547:/sql/functions/utils.sql diff --git a/sql/functions/utils.sql b/sql/functions/utils.sql index 80eb12c5..6371e9ad 100644 --- a/sql/functions/utils.sql +++ b/sql/functions/utils.sql @@ -248,7 +248,6 @@ LANGUAGE plpgsql STABLE; -- \param centroid Location of the address. -- -- \return Place ID of the parent if one was found, NULL otherwise. --- The returned parent is always a street (rank 26/27 and a way). CREATE OR REPLACE FUNCTION find_parent_for_address(street TEXT, place TEXT, partition SMALLINT, centroid GEOMETRY) @@ -263,9 +262,7 @@ BEGIN -- Note that addr:street links can only be indexed, once the street itself is indexed word_ids := word_ids_from_name(street); IF word_ids is not null THEN - SELECT place_id - FROM getNearestNamedRoadFeature(partition, centroid, word_ids) - INTO parent_place_id; + parent_place_id := getNearestNamedRoadPlaceId(partition, centroid, word_ids); IF parent_place_id is not null THEN --DEBUG: RAISE WARNING 'Get parent form addr:street: %', parent.place_id; RETURN parent_place_id; @@ -277,9 +274,7 @@ BEGIN IF place is not null THEN word_ids := word_ids_from_name(place); IF word_ids is not null THEN - SELECT place_id - FROM getNearestNamedPlaceFeature(partition, centroid, word_ids) - INTO parent_place_id; + parent_place_id := getNearestNamedPlacePlaceId(partition, centroid, word_ids); IF parent_place_id is not null THEN --DEBUG: RAISE WARNING 'Get parent form addr:place: %', parent.place_id; RETURN parent_place_id;