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

[PostGIS]

#1113: "Old" Road name not found
----------------------------+-----------------------------------------------
 Reporter:  mikepease       |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  1.5.X        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 There are several roads in Minnesota that were replaced by a newer road or
 highway.  The older road is still there, but the name was changed to "Old
 Yada Yada Road".

 The geocoder is not finding these "Old" roads.  But it finds them if you
 take out the word "Old" from the street name.  Some examples:


 --8040 OLD CEDAR AVE S, BLOOMINGTON, MN 55425
 --17405 Old Rockford Rd, Plymouth, MN 55446
 --198 OLD CONSTANCE BLVD, ANDOVER, MN 55304

 --fails with "Old"
 select abs(ST_X(geomout)::numeric(8,5)) || 'W, ' ||
 ST_Y(geomout)::numeric(8,5) || 'N' as lat_lon, *
 from geocode('8040 OLD CEDAR AVE S, BLOOMINGTON, MN 55425')

 --works without "Old"
 select abs(ST_X(geomout)::numeric(8,5)) || 'W, ' ||
 ST_Y(geomout)::numeric(8,5) || 'N' as lat_lon, *
 from geocode('8040 CEDAR AVE S, BLOOMINGTON, MN 55425')

 --fails with "Old"
 select abs(ST_X(geomout)::numeric(8,5)) || 'W, ' ||
 ST_Y(geomout)::numeric(8,5) || 'N' as lat_lon, *
 from geocode('17405 Old Rockford Rd, Plymouth, MN 55446')

 --works without "Old"
 select abs(ST_X(geomout)::numeric(8,5)) || 'W, ' ||
 ST_Y(geomout)::numeric(8,5) || 'N' as lat_lon, *
 from geocode('17405 Rockford Rd, Plymouth, MN 55446')

 --fails with "Old"
 select abs(ST_X(geomout)::numeric(8,5)) || 'W, ' ||
 ST_Y(geomout)::numeric(8,5) || 'N' as lat_lon, *
 from geocode('198 OLD CONSTANCE BLVD, ANDOVER, MN 55304')

 --works without "Old"
 select abs(ST_X(geomout)::numeric(8,5)) || 'W, ' ||
 ST_Y(geomout)::numeric(8,5) || 'N' as lat_lon, *
 from geocode('198 CONSTANCE BLVD, ANDOVER, MN 55304')

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