[postgis-tickets] [PostGIS] #3259: pagc_normalize_address (standardize_address), doesn't convert numbered street name right

[PostGIS]

#3259: pagc_normalize_address (standardize_address), doesn't convert numbered
street name right
----------------------------------+---------------------------
  Reporter:  robe                 |      Owner:  robe
      Type:  defect               |     Status:  new
  Priority:  medium               |  Milestone:  PostGIS 2.3.0
 Component:  pagc_address_parser  |    Version:  trunk
Resolution:                       |   Keywords:
----------------------------------+---------------------------

Comment (by robe):

 Fixed at r13991 and added some additional regress tests.  so now


 {{{
 SELECT *
 FROM standardize_address('pagc_lex'
        , 'pagc_gaz'
      , 'pagc_rules'
  ,'212 3rd Ave N Suite 560, Minneapolis, MN 55401'  ) ;

  building | house_num | predir | qual | pretype | name | suftype | sufdir
 | ruralroute | extra |    city     | state | country | postcode | box |
 unit
 ----------+-----------+--------+------+---------+------+---------+--------+------------+-------+-------------+-------+---------+----------+-----+-----------
           | 212       |        |      |         | 3RD  | AVE     | N
 |            |       | MINNEAPOLIS | MN    | USA     | 55401    |     |
 SUITE 560
 (1 row)

 and still handles word numbered street names:

  SELECT * FROM pagc_normalize_address('3937 Forty Third AVE S,
 MINNEAPOLIS, MN 55406');

 becomes:

  address | predirabbrev | streetname | streettypeabbrev | postdirabbrev |
 internal |  location   | stateabbrev |  zip  | parsed
 ---------+--------------+------------+------------------+---------------+----------+-------------+-------------+-------+--------
     3937 |              | 43RD       | AVE              | S             |
 | MINNEAPOLIS | MN          | 55406 | t
 (1 row)

 }}}

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3259#comment:1>
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.