From: Sarah Hoffmann <lonvia@denofr.de>
Date: Mon, 16 Apr 2018 18:25:19 +0000 (+0200)
Subject: remove special search for Tiger postcodes
X-Git-Tag: v3.2.0~79^2~4
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/ee194ab3697eb6ed2d55284d191783be98e8b7ad

remove special search for Tiger postcodes

Postcodes should no longer appear in the address search terms.
---

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