[postgis-tickets] [PostGIS] #2380: Fix pagc lookup tables resolves BAY STATE incorrectly

[PostGIS]

#2380: Fix pagc lookup tables resolves  BAY STATE incorrectly
---------------------------------+------------------------------------------
 Reporter:  robe                 |       Owner:  robe         
     Type:  defect               |      Status:  new          
 Priority:  medium               |   Milestone:  PostGIS 2.1.0
Component:  pagc_address_parser  |     Version:  2.1.x        
 Keywords:                       |  
---------------------------------+------------------------------------------
 I managed to have over replaced in my building of pagc lex, rules, gaz.
 This I confirmed is a screwup in my lookup tables rather than anything
 wrong with pagc.

 Query:
 {{{

 SELECT (g.sa).*
 FROM (SELECT standardize_address('lex'
        , 'gaz'
        , 'rules', '140 BAY STATE RD, BOSTON, MA 02215') As sa) As g;

 -- Correctly Outputs --
  building | house_num | predir | qual | pretype |   name    | suftype |
 sufdir |
  ruralroute | extra |  city  |     state     | country | postcode | box |
 unit
 ----------+-----------+--------+------+---------+-----------+---------+--------+
 ------------+-------+--------+---------------+---------+----------+-----+------
           | 140       |        |      |         | BAY STATE | ROAD    |
 |
             |       | BOSTON | MASSACHUSETTS | USA     | 02215    |     |
 }}}
  but my revised tiger version:


 {{{
 SELECT (g.sa).*
 FROM (SELECT standardize_address('tiger.pagc_lex'
        , 'tiger.pagc_gaz'
        , 'tiger.pagc_rules', '140 BAY STATE RD, BOSTON, MA 02215') As sa)
 As g;

 }}}



 Just gives blank for everything.  I assume I over replaced somewhere or
 added some junk record I shouldn't have.

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