Opened 10 years ago

Closed 10 years ago

#2899 closed defect (fixed)

geocode limit 1 not returning best answer

Reported by: robe Owned by: robe
Priority: high Milestone: PostGIS 2.1.4
Component: tiger geocoder Version: 2.1.x
Keywords: history Cc:

Description

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)

Change History (1)

comment:1 by robe, 10 years ago

Keywords: history added
Resolution: fixed
Status: newclosed

fixed for 2.1 at (r12912, r12913) fixed for trunk 2.2 at r12914

Note: See TracTickets for help on using tickets.