[postgis-devel] [PostGIS] #1025: Geocoder Failing with "NORTH EAST" is street name
PostGIS
trac at osgeo.org
Wed Jun 15 15:19:57 PDT 2011
#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.
More information about the postgis-devel
mailing list