[postgis-users] How to look up state highways with geocoder?

[Aren Cambre]

I am trying to find an intersection that includes a state highway. It's TX
121 and Denton Tap Rd. in Coppell, TX. This corresponds to
here<http://maps.google.com/maps?q=state+highway+121+%26+denton+tap,+coppell,+tx&hl=en&ll=33.001068,-96.99373&spn=0.011067,0.015686&sll=32.969416,-96.993595&sspn=0.011071,0.015686&vpsrc=6&t=w&hnear=Texas+121+Business+%26+Denton+Tap+Rd,+Lewisville,+Denton,+Texas+75067&z=16>or
here<http://maps.google.com/maps?q=state+highway+121+%26+denton+tap,+coppell,+tx&hl=en&ll=32.986562,-96.993257&spn=0.011069,0.015686&sll=32.969416,-96.993595&sspn=0.011071,0.015686&vpsrc=6&t=w&hnear=Texas+121+Business+%26+Denton+Tap+Rd,+Lewisville,+Denton,+Texas+75067&z=16>(one
is TX 121 main route and the other is TX 121 Business).

I cannot figure out how to represent a state highway in the TIGER geocoder.
I've used all sorts of variants, like:

   - SH 121
   - state highway 121
   - TX 121
   - Texas state highway 121

etc.

How are state highways represented in the DB? How can I check road name
representations for myself in the future?

Aren
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111219/8107f97c/attachment.html>