[postgis-devel] [PostGIS] #1355: Normalizing internal addresses with non-numeric unit identifier strips unit identifier

PostGIS trac at osgeo.org
Wed Dec 7 13:03:37 PST 2011


#1355: Normalizing internal addresses with non-numeric unit identifier strips unit
identifier
----------------------------+-----------------------------------------------
 Reporter:  bpanulla        |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 Normalizing an address with an internal component that starts with a non-
 numeric character component strips out the internal component.

 '''STE A'''
 {{{
 SELECT (addy).*
 FROM normalize_address('100 E BROADWAY AVE STE A, TUCSON, AZ') AS addy;
 }}}

 ||Address||Pre-Dir||Street      ||Street Type||Post-
 Dir||Internal||Locality||State||Zip||parsed||
 ||100||E||BROADWAY||Ave||||STE||TUSCON||AZ||||t||

 '''BLDG C'''
 {{{
 SELECT (addy).*
 FROM normalize_address('100 E BROADWAY AVE BLDG C, TUCSON, AZ') AS addy;
 }}}

 ||Address||Pre-Dir||Street      ||Street Type||Post-
 Dir||Internal||Locality||State||Zip||parsed||
 ||100||E||BROADWAY||Ave||||BLDG||TUSCON||AZ||||t||

 This works: '''BLDG 3C'''
 {{{
 SELECT (addy).*
 FROM normalize_address('100 E BROADWAY AVE BLDG 3C, TUCSON, AZ') AS addy;
 }}}

 ||Address||Pre-Dir||Street      ||Street Type||Post-
 Dir||Internal||Locality||State||Zip||parsed||
 ||100||E||BROADWAY||Ave||||BLDG 3C||TUSCON||AZ||||t||

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