X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/e0b1e3b66d54c4fe9907edb1ff993f33e6739d46..00379183adaca10dbbae1c3819e8652269d49ad7:/sql/tiger_import_start.sql?ds=sidebyside diff --git a/sql/tiger_import_start.sql b/sql/tiger_import_start.sql index d9def2b4..9846f609 100644 --- a/sql/tiger_import_start.sql +++ b/sql/tiger_import_start.sql @@ -1,5 +1,5 @@ DROP TABLE IF EXISTS location_property_tiger_import; -CREATE TABLE location_property_tiger_import () INHERITS (location_property); +CREATE TABLE location_property_tiger_import () INHERITS (location_property) {ts:aux-data}; CREATE OR REPLACE FUNCTION tigger_create_interpolation(linegeo GEOMETRY, in_startnumber INTEGER, in_endnumber INTEGER, interpolationtype TEXT, @@ -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;