X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/55b59ea1396741b5f152dba3ff4ade8266442fc1..6704f7bbb08127cdf2cb7e1e1fc28605b2273bfa:/sql/tiger_import_start.sql?ds=sidebyside diff --git a/sql/tiger_import_start.sql b/sql/tiger_import_start.sql index f40f544b..a6f417f2 100644 --- a/sql/tiger_import_start.sql +++ b/sql/tiger_import_start.sql @@ -53,12 +53,12 @@ BEGIN END IF; place_centroid := ST_Centroid(linegeo); - out_partition := get_partition(place_centroid, 'us'); + out_partition := get_partition('us'); out_parent_place_id := null; address_street_word_id := get_name_id(make_standard_name(in_street)); IF address_street_word_id IS NOT NULL THEN - FOR location IN SELECT * from getNearestNamedRoadFeature(out_partition, place_centroid, address_street_word_id) LOOP + FOR location IN SELECT * from getNearestNamedRoadFeature(out_partition, place_centroid, ARRAY[address_street_word_id]) LOOP out_parent_place_id := location.place_id; END LOOP; END IF; @@ -79,7 +79,7 @@ BEGIN FOR housenum IN startnumber..endnumber BY stepsize LOOP insert into location_property_tiger_import (place_id, partition, parent_place_id, housenumber, postcode, centroid) values (nextval('seq_place'), out_partition, out_parent_place_id, housenum, in_postcode, - ST_Line_Interpolate_Point(linegeo, (housenum::float-rangestartnumber::float)/numberrange::float)); + ST_LineInterpolatePoint(linegeo, (housenum::float-rangestartnumber::float)/numberrange::float)); newpoints := newpoints + 1; END LOOP;