[postgis-tickets] [PostGIS] #2981: standardize address returns no answer for particular highway

[PostGIS]

#2981: standardize address returns no answer for particular highway
----------------------------------+---------------------------
  Reporter:  robe                 |      Owner:  robe
      Type:  defect               |     Status:  new
  Priority:  high                 |  Milestone:  PostGIS 2.2.0
 Component:  pagc_address_parser  |    Version:  trunk
Resolution:                       |   Keywords:
----------------------------------+---------------------------
Changes (by robe):

 * owner:  woobri => robe


Comment:

 Well confirmed parse_address at least does the right thing:


 {{{
 SELECT *
 FROM parse_address( '1566 NEW STATE HWY, RAYNHAM, MA') ;

  num  |    street     | street2 |      address1      |  city   | state |
 zip | zipplus | country
 ------+---------------+---------+--------------------+---------+-------+-----+---------+---------
  1566 | NEW STATE HWY |         | 1566 NEW STATE HWY | RAYNHAM | MA    |
 |         | US
 (1 row)
 }}}


 New query should be:


 {{{
 CREATE EXTENSION address_standardizer_data_us;

 SELECT standardize_address('us_lex','us_gaz','us_rules', '1566 NEW STATE
 HWY, RAYNHAM, MA') ;

 }}}
 The NEW seems to be what is tripping it up because this works:


 {{{
 SELECT standardize_address('us_lex','us_gaz','us_rules', '1566 STATE HWY,
 RAYNHAM, MA') ;

                      standardize_address
 -------------------------------------------------------------
  (,1566,,,,"STATE HIGHWAY",,,,,RAYNHAM,MASSACHUSETTS,USA,,,)
 }}}

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