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 , 14 years ago
Priority: | low → medium |
---|---|
Resolution: | → fixed |
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
fixed at r7426