[postgis-tickets] [PostGIS] #1604: normalize_address() confused by internal component

PostGIS trac at osgeo.org
Tue Apr 2 11:08:14 PDT 2013


#1604: normalize_address() confused by internal component
----------------------------------+-----------------------------------------
  Reporter:  mikepease            |       Owner:  robe         
      Type:  defect               |      Status:  closed       
  Priority:  medium               |   Milestone:  PostGIS 2.1.0
 Component:  pagc_address_parser  |     Version:  trunk        
Resolution:  fixed                |    Keywords:               
----------------------------------+-----------------------------------------
Changes (by robe):

  * status:  new => closed
  * version:  1.5.X => trunk
  * resolution:  => fixed


Comment:

 Seems to work well:

 {{{
 SELECT  pprint_addy(a), a.internal
    FROM pagc_normalize_address('901 Mainstreet Fl 1 Hopkins MN 55343') As
 a;
 }}}

 Yields:

 {{{
                  pprint_addy                  | internal
 ----------------------------------------------+-----------
  901 MAINSTREET, # FLOOR 1, HOPKINS, MN 55343 | # FLOOR 1
 }}}

 -- this one might have been caused by my over abbreviating --

 {{{
 SELECT pprint_addy(a), a.streetname, a.location, a.stateabbrev
   FROM pagc_normalize_address('2301 BEACH FRONT LN SW, Rochester, MN
 55902') AS a;
 -- but still acceptable --
                 pprint_addy                | streetname | location  |
 stateabbrev
 -------------------------------------------+------------+-----------+-------------
  2301 BCH FRONT Ln SW, ROCHESTER, MN 55902 | BCH FRONT  | ROCHESTER | MN

 SELECT pprint_addy(a), a.streetname, a.location, a.stateabbrev,
 a.predirabbrev, a.postdirabbrev
   FROM pagc_normalize_address('2301 BEACH FRONT LN Southwest, Rochester,
 MN 55902') AS a;

                 pprint_addy                | streetname | location  |
 stateabbre
 v | predirabbrev | postdirabbrev
 -------------------------------------------+------------+-----------+-----------
 --+--------------+---------------
  2301 BCH FRONT Ln SW, ROCHESTER, MN 55902 | BCH FRONT  | ROCHESTER | MN
   |              | SW

 }}}

 Anyrate will consider it a non-issue now.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1604#comment:11>
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-tickets mailing list