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

fixed at r7426