Here's the query I'm using:<div><b><font face="'courier new', monospace">SELECT * FROM geocode_intersection('SH 121', 'Denton Tap', 'TX', 'Coppell');</font></b></div><div><br>

</div><div>Aren<br><br><div class="gmail_quote">On Mon, Dec 19, 2011 at 7:56 PM, Aren Cambre <span dir="ltr"><<a href="mailto:aren@arencambre.com">aren@arencambre.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

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 <a href="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" target="_blank">here</a> or <a href="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" target="_blank">here</a> (one is TX 121 main route and the other is TX 121 Business).<div>


<br></div><div>I cannot figure out how to represent a state highway in the TIGER geocoder. I've used all sorts of variants, like:</div><div><ul><li>SH 121</li><li>state highway 121</li><li>TX 121</li><li>Texas state highway 121</li>


</ul><div>etc.</div></div><div><br></div><div>How are state highways represented in the DB? How can I check road name representations for myself in the future?</div><span class="HOEnZb"><font color="#888888"><div><br></div>

<div>Aren</div>
</font></span></blockquote></div><br></div>