[postgis-devel] [PostGIS] #1113: "Old" Road name not found

[PostGIS]

#1113: "Old" Road name not found
-----------------------------+----------------------------------------------
  Reporter:  mikepease       |       Owner:  robe         
      Type:  defect          |      Status:  closed       
  Priority:  medium          |   Milestone:  PostGIS 2.0.0
 Component:  tiger geocoder  |     Version:  1.5.X        
Resolution:  fixed           |    Keywords:               
-----------------------------+----------------------------------------------
Changes (by robe):

  * status:  new => closed
  * resolution:  => fixed


Comment:

 fixed at r7634


 {{{
 SELECT '#1113e' As ticket, pprint_addy((g).addy) As address, target,
 ST_AsText(ST_SnapToGrid((g).geomout, 0.00001)) As pt, (g).rating FROM
 (SELECT geocode(target,2) As g, target
 FROM (SELECT '198 OLD CONSTANCE BLVD, ANDOVER, MN 55304'::text As target)
 As f) As foo;
 }}}

 yields:

 {{{
 #1113e|198 Old Constance Blvd NW, Andover, MN 55304|198 OLD CONSTANCE
 BLVD, ANDOVER, MN 55304|POINT(-93.27027 45.26203)|4
 }}}


 And

 {{{
 SELECT '#1113f' As ticket, pprint_addy((g).addy) As address, target,
 ST_AsText(ST_SnapToGrid((g).geomout, 0.00001)) As pt, (g).rating FROM
 (SELECT geocode(target,2) As g, target
 FROM (SELECT '198 CONSTANCE BLVD, ANDOVER, MN 55304'::text As target) As
 f) As foo;

 }}}

 Yields:


 {{{
 #1113f|198 Constance Blvd NW, Andover, MN 55304|198 CONSTANCE BLVD,
 ANDOVER, MN 55304|POINT(-93.26839 45.26229)|4
 #1113f|198 Constance Blvd NE, Ham Lake, MN 55304|198 CONSTANCE BLVD,
 ANDOVER, MN 55304|POINT(-93.26114 45.2657)|11
 }}}

 I'm still playing around with trigram, fulltext, and btree varops for more
 fuzzy stuff.  Sadly these haven't proved to be as fast or as efficient as
 I had hoped, but haven't given up hope on them yet.

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