[postgis-tickets] [PostGIS] #2899: geocode limit 1 not returning best answer

[PostGIS]

#2899: geocode limit 1 not returning best answer
----------------------------+-----------------------------------------------
 Reporter:  robe            |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  high            |   Milestone:  PostGIS 2.1.4
Component:  tiger geocoder  |     Version:  2.1.x        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 Just found a bug in my limit 1 logic for geocoding.

 {{{
 SELECT g.rating,
         pprint_addy(addy) As m_addr
         FROM geocode('22 Minnow Ln, Westbrook, CT 06498',1) As g;
 }}}

 Yields a stupid answer with rating 59 while:

 {{{
  rating |                  m_addr
 --------+------------------------------------------
      59 | 22 S Main St, Westbrook Center, CT 06498
 }}}

 While not using limit
 {{{
 SELECT g.rating,
         pprint_addy(addy) As m_addr
         FROM geocode('22 Minnow Ln, Westbrook, CT 06498') As g;
 }}}


 {{{
  rating |                  m_addr
 --------+------------------------------------------
       0 | 22 Minnow Ln, Westbrook Center, CT 06498
 (1 row)
 }}}

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