[postgis-devel] [PostGIS] #1614: More normalizer tricks

[PostGIS]

#1614: More normalizer tricks
----------------------------+-----------------------------------------------
 Reporter:  mikepease       |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  1.5.X        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 --------------------------------------------------------
 --Specifying St. Paul but not MN misinterprets state
 select * from normalize_address('933 Vandalia Ave, St Paul');
 --Output PALAU (PW)??
 --933  ""  "Vandalia"  ""  ""  ""  "St"  "PW"  ""  t

 select  * from normalize_address('933 Vandalia, St. Paul, 55304') ;
 --Still goes to Palau

 select  * from normalize_address('933 Vandalia, St. Paul, MN')
 --Works properly

 --------------------------------------------------------
 -Why is the syntax so sensitive here?
 --none of these work right
 select  * from normalize_address('901 Mainstreet, Fl 2, Hopkins MN 55343')
 select  * from normalize_address('901 Mainstreet Fl 2, Hopkins, MN 55343')
 select  * from normalize_address('901 Mainstreet Fl 2 Hopkins, MN 55343')
 select  * from normalize_address('901 Mainstreet Fl 2 Hopkins, MN 55343')
 select  * from normalize_address('901 Mainstreet, Fl 2 Hopkins, MN 55343')
 select  * from normalize_address('901 Mainstreet St, Fl 2 Hopkins, MN
 55343')
 --this one does
 select  * from normalize_address('901 Mainstreet St Fl 2, Hopkins, MN
 55343')

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1614>
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.