From ee194ab3697eb6ed2d55284d191783be98e8b7ad Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Mon, 16 Apr 2018 20:25:19 +0200 Subject: [PATCH] remove special search for Tiger postcodes Postcodes should no longer appear in the address search terms. --- sql/functions.sql | 16 ---------------- 1 file changed, 16 deletions(-) diff --git a/sql/functions.sql b/sql/functions.sql index b39d59b7..91230b2d 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -1806,22 +1806,6 @@ RAISE WARNING 'Address found % -> %', addr_item.key, addr_item.value; END IF; nameaddress_vector := array_merge(nameaddress_vector, isin_tokens); - -- %NOTIGERDATA% IF 0 THEN - -- for the USA we have an additional address table. Merge in zip codes from there too - IF NEW.rank_search = 26 AND NEW.country_code = 'us' THEN - FOR location IN SELECT distinct postcode from location_property_tiger where parent_place_id = NEW.place_id LOOP - address_street_word_id := get_name_id(make_standard_name(location.postcode)); - nameaddress_vector := array_merge(nameaddress_vector, ARRAY[address_street_word_id]); - isin_tokens := isin_tokens || address_street_word_id; - - -- also merge in the single word version - address_street_word_id := get_word_id(make_standard_name(location.postcode)); - nameaddress_vector := array_merge(nameaddress_vector, ARRAY[address_street_word_id]); - END LOOP; - END IF; - --DEBUG: RAISE WARNING 'Tiger postcodes collected'; - -- %NOTIGERDATA% END IF; - -- RAISE WARNING 'ISIN: %', isin_tokens; -- Process area matches -- 2.39.5