[postgis-devel] [PostGIS] #1456: Tiger Geocoder can't handle SH for state highway

[PostGIS]

#1456: Tiger Geocoder can't handle SH for state highway
----------------------------+-----------------------------------------------
 Reporter:  arencambre      |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 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.

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