Ticket #1457 (new defect)
Tiger Geocoder poorly handles business route abbreviations
|Reported by:||arencambre||Owned by:||robe|
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.