[postgis-devel] [PostGIS] #1599: normalize_address() confused by coutry
PostGIS
trac at osgeo.org
Wed Feb 22 06:39:06 PST 2012
#1599: normalize_address() confused by coutry
----------------------------+-----------------------------------------------
Reporter: mikepease | Owner: robe
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 2.0.0
Component: tiger geocoder | Version: 1.5.X
Keywords: |
----------------------------+-----------------------------------------------
If you include a country at the end of an address, normalize_address()
incorrectly parses the state and zip.
212 n 3rd ave, Minneapolis, mn 55401, USA
(This is the format of the "formatted address" returned by Google's XML
webservice)
select * from normalize_address('212 n 3rd ave, Minneapolis, mn 55401,
USA')
Result:
stateabbrev
212;"N";"3rd";"Ave";"";"";"mn 55401";"";"";t
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1599>
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