[postgis-devel] [PostGIS] #1354: Problems geocoding addresses containing "ST STE"

[PostGIS]

#1354: Problems geocoding addresses containing "ST STE"
----------------------------+-----------------------------------------------
 Reporter:  bpanulla        |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 The geocoder gets confused by addresses with a type of "ST" followed
 immediately by an internal address beginning with "STE", even though
 normalize_address() appears to handle this without issue.

 '''normalize_address()'''
 {{{
 SELECT addy.*
 FROM normalize_address('6226 E PIMA ST STE 999, TUCSON') AS addy;
 }}}

 ||Address||Pre-Dir||Street      ||Street Type||Post-
 Dir||Internal||Locality||State||Zip||parsed||
 ||6226||E||PIMA ST||St||||STE 999||TUSCON||AZ||||t||

 '''geocode() with bad string'''
 {{{
 SELECT g.rating, (addy).*
 FROM geocode('6226 E PIMA ST STE 999, TUCSON, AZ') AS g;
 }}}

 ||Rating||Address||Pre-Dir||Street||Street Type||Post-
 Dir||Internal||Locality||State||Zip||parsed||
 ||100||||||||||||||Tuscon||AZ||85641||t||

 '''geocode() with amended string'''

 If you replace "ST" with "STREET" the geocoder performs as desired.

 {{{
 SELECT g.rating, (addy).*
 FROM geocode('6226 E PIMA STREET STE 999, TUCSON, AZ') AS g;
 }}}

 ||Rating||Address||Pre-Dir||Street||Street Type||Post-
 Dir||Internal||Locality||State||Zip||parsed||
 ||1||6226||E||Pima||St||||STE 999||Tuscon||AZ||85712||t||

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