X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/0f1752948651a4939e1a808f2a44face6abc305a..8a8e23ef3cb3e7ffb937c75ab1bdeee9ef5b3bf0:/sql/functions/utils.sql?ds=inline diff --git a/sql/functions/utils.sql b/sql/functions/utils.sql index 2b3db04a..6697ff97 100644 --- a/sql/functions/utils.sql +++ b/sql/functions/utils.sql @@ -237,7 +237,7 @@ BEGIN IF word_ids is not null THEN 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; + --DEBUG: RAISE WARNING 'Get parent form addr:street: %', parent_place_id; RETURN parent_place_id; END IF; END IF; @@ -249,7 +249,7 @@ BEGIN IF word_ids is not null THEN 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; + --DEBUG: RAISE WARNING 'Get parent form addr:place: %', parent_place_id; RETURN parent_place_id; END IF; END IF; @@ -322,7 +322,7 @@ BEGIN ELSEIF ST_GeometryType(geometry) = 'ST_Point' THEN radius := near_feature_rank_distance(rank_search); - --DEBUG: RAISE WARNING 'adding % diameter %', place_id, diameter; + --DEBUG: RAISE WARNING 'adding % radius %', place_id, radius; -- Create a bounding box with an extent computed from the radius (in meters). secgeo := ST_Envelope(ST_Collect( @@ -429,7 +429,7 @@ DECLARE geo RECORD; BEGIN -- 10000000000 is ~~ 1x1 degree - FOR geo IN select quad_split_geometry(geometry, 0.25, 20) as geom LOOP + FOR geo IN select quad_split_geometry(geometry, 0.01, 20) as geom LOOP RETURN NEXT geo.geom; END LOOP; RETURN; @@ -467,7 +467,7 @@ DECLARE placegeom GEOMETRY; geom GEOMETRY; diameter FLOAT; - rank INTEGER; + rank SMALLINT; BEGIN UPDATE placex SET indexed_status = 2 WHERE place_id = placeid; SELECT geometry, rank_search FROM placex WHERE place_id = placeid INTO placegeom, rank;