id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc
1456,Tiger Geocoder can't handle SH for state highway,arencambre,robe,"Tiger Geocoder gives no results for either of these queries:

{{{
SELECT ST_AsEWKT(geomout) FROM geocode_intersection('SH 121', 'Denton Tap', 'TX', 'Coppell') ORDER BY rating ASC LIMIT 1;
SELECT ST_AsEWKT(geomout) FROM geocode_intersection('SH121', 'Denton Tap', 'TX', 'Coppell') ORDER BY rating ASC LIMIT 1;
}}}

I can get it to work by converting to this:

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

The problem is, in the Tiger database, the highway is known as '''State Highway 121''', but the geocoder doesn't understand that '''SH''' is a common abbreviation for '''State Highway'''. See http://trac.osgeo.org/postgis/attachment/ticket/1392/intersection.png.",defect,new,medium,PostGIS 2.1.0,pagc_address_parser,trunk,,,aren@… woodbri