Opened 14 years ago

Closed 14 years ago

#1025 closed defect (fixed)

Geocoder Failing with "NORTH EAST" is street name

Reported by: egouge Owned by: robe
Priority: medium Milestone: PostGIS 2.0.0
Component: tiger geocoder Version: 1.5.X
Keywords: Cc:

Description

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.

Change History (1)

comment:1 by robe, 14 years ago

Priority: lowmedium
Resolution: fixed
Status: newclosed

fixed at r7426

Note: See TracTickets for help on using tickets.