[postgis-devel] [PostGIS] #1025: Geocoder Failing with "NORTH EAST" is street name

[PostGIS]

#1025: Geocoder Failing with "NORTH EAST" is street name
----------------------------+-----------------------------------------------
 Reporter:  egouge          |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  low             |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  1.5.X        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 The following addresses fail when geocoding:[[BR]]

 {{{
 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.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1025>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.