X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/9d103503f71eef5dc6c5f85f5b84b11410f52cdb..00959fac57d6c1b35d009e68ad857989ae71de6c:/lib-sql/functions/utils.sql?ds=sidebyside diff --git a/lib-sql/functions/utils.sql b/lib-sql/functions/utils.sql index 4868b828..c308d025 100644 --- a/lib-sql/functions/utils.sql +++ b/lib-sql/functions/utils.sql @@ -221,37 +221,30 @@ LANGUAGE plpgsql STABLE; -- \param centroid Location of the address. -- -- \return Place ID of the parent if one was found, NULL otherwise. -CREATE OR REPLACE FUNCTION find_parent_for_address(street TEXT, place TEXT, +CREATE OR REPLACE FUNCTION find_parent_for_address(street INTEGER[], place INTEGER[], partition SMALLINT, centroid GEOMETRY) RETURNS BIGINT AS $$ DECLARE parent_place_id BIGINT; - word_ids INTEGER[]; BEGIN IF street is not null THEN -- Check for addr:street attributes -- 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 - parent_place_id := getNearestNamedRoadPlaceId(partition, centroid, word_ids); - IF parent_place_id is not null THEN - {% if debug %}RAISE WARNING 'Get parent form addr:street: %', parent_place_id;{% endif %} - RETURN parent_place_id; - END IF; + parent_place_id := getNearestNamedRoadPlaceId(partition, centroid, street); + IF parent_place_id is not null THEN + {% if debug %}RAISE WARNING 'Get parent form addr:street: %', parent_place_id;{% endif %} + RETURN parent_place_id; END IF; END IF; -- Check for addr:place attributes. IF place is not null THEN - word_ids := word_ids_from_name(place); - IF word_ids is not null THEN - parent_place_id := getNearestNamedPlacePlaceId(partition, centroid, word_ids); - IF parent_place_id is not null THEN - {% if debug %}RAISE WARNING 'Get parent form addr:place: %', parent_place_id;{% endif %} - RETURN parent_place_id; - END IF; + parent_place_id := getNearestNamedPlacePlaceId(partition, centroid, place); + IF parent_place_id is not null THEN + {% if debug %}RAISE WARNING 'Get parent form addr:place: %', parent_place_id;{% endif %} + RETURN parent_place_id; END IF; END IF;