[postgis-devel] [PostGIS] #1457: Tiger Geocoder poorly handles business route abbreviations

[PostGIS]

#1457: Tiger Geocoder poorly handles business route abbreviations
------------------------+---------------------------------------------------
 Reporter:  arencambre  |       Owner:  pramsey      
     Type:  defect      |      Status:  new          
 Priority:  medium      |   Milestone:  PostGIS 2.0.0
Component:  postgis     |     Version:  trunk        
 Keywords:              |  
------------------------+---------------------------------------------------
 Roads may have "business routes". See
 http://en.wikipedia.org/wiki/Business_route for more details.

 In the Tiger dataset for Texas, there is '''State Highway 121''', and this
 highway has a few business routes.

 One SH 121 business route in Coppell is called '''State Highway 121H
 Bus''' in the Tiger dataset.

 Note that The H is just an internal Texas DOT designation and virtually
 never appears on road signs. It separates different business routes of a
 highway. There could also be SH 121A Bus, SH 121B Bus, etc.

 Anyway, if I try this, I get no results:

 {{{
 SELECT ST_AsEWKT(geomout) FROM geocode_intersection('State Highway 121',
 'Business 121', 'TX', 'Coppell') ORDER BY rating ASC LIMIT 1;
 SELECT ST_AsEWKT(geomout) FROM geocode_intersection('State Highway 121',
 'Bus. 121', 'TX', 'Coppell') ORDER BY rating ASC LIMIT 1;
 }}}

 '''Business 121''' is a common way of referring to the road, and
 '''Bus.''' is an abbreviation of 121.

 There's only one SH 121 Business in Coppell, TX, so seems like these
 should have matched.

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