Ticket #1025 (closed defect: fixed)
Geocoder Failing with "NORTH EAST" is street name
|Reported by:||egouge||Owned by:||robe|
The following addresses fail when geocoding:
1953 NORTH WEST 83RD STREET, Miami, FL, 33147 304 NORTH EAST 4TH AVE, Aledo, IL, 61321
They both fail with the following error message:
ERROR: query "SELECT substring(reducedStreet, '(?i)(^' || name || ')' || ws) FROM direction_lookup WHERE reducedStreet ILIKE '%' || name || '%' AND texticregexeq(reducedStreet, '(?i)(^' || name || ')' || ws) ORDER BY length(name) DESC" returned more than one row CONTEXT: PL/pgSQL function "normalize_address" line 280 at assignment PL/pgSQL function "geocode" line 10 at assignment
If NORTH WEST is changed to NORTHWEST or NW the geocoder works as expected.