Changes between Initial Version and Version 1 of Ticket #2981, comment 3


Ignore:
Timestamp:
Sep 8, 2015, 4:05:09 PM (9 years ago)
Author:
robe

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #2981, comment 3

    initial v1  
    11Fixed at r14054
     2
     3
     4
     5{{{
     6SELECT * FROM  standardize_address('us_lex','us_gaz','us_rules', '1566 NEW STATE HWY, RAYNHAM, MA') ;
     7
     8SELECT * FROM standardize_address('us_lex','us_gaz','us_rules', '1566 STATE HWY, RAYNHAM, MA') ;
     9}}}
     10
     11now yields:
     12
     13
     14{{{
     15 building | house_num | predir | qual | pretype |       name        | suftype | sufdir | ruralroute | extra |  city   |     state     | country | postcode | box | unit
     16----------+-----------+--------+------+---------+-------------------+---------+--------+------------+-------+---------+---------------+---------+----------+-----+------
     17          | 1566      |        |      |         | NEW STATE HIGHWAY |         |        |            |       | RAYNHAM | MASSACHUSETTS | USA     |          |     |
     18(1 row)
     19
     20
     21building | house_num | predir | qual | pretype |     name      | suftype | sufdir | ruralroute | extra |  city   |     state     | country | postcode | box | unit
     22---------+-----------+--------+------+---------+---------------+---------+--------+------------+-------+---------+---------------+---------+----------+-----+------
     23         | 1566      |        |      |         | STATE HIGHWAY |         |        |            |       | RAYNHAM | MASSACHUSETTS | USA     |          |     |
     24}}}
     25
     26
     27and tiger packaged one now yields:
     28
     29
     30{{{
     31SELECT * FROM  standardize_address('tiger.pagc_lex','tiger.pagc_gaz','tiger.pagc_rules', '1566 NEW STATE HWY, RAYNHAM, MA') ;
     32
     33 building | house_num | predir | qual | pretype |     name      | suftype | sufdir | ruralroute | extra |  city   | state | country | postcode | box | unit
     34----------+-----------+--------+------+---------+---------------+---------+--------+------------+-------+---------+-------+---------+----------+-----+------
     35          | 1566      |        |      |         | NEW STATE HWY |         |        |            |       | RAYNHAM | MA    | USA     |          |     |
     36(1 row)
     37
     38
     39}}}
     40
     41Though I stumbled across another issue that the tiger one gives no answer for the w/out NEW.  That has existed for awhile and think I'm just missing some rules.
     42