The plot thickens further. I used QGIS to view the <b>tiger_data.tx_edges</b> table. I had it label everything using the <b>fullname</b> column. I found the intersection:<div><img src="cid:ii_13459b810603d549" alt="intersection.png" title="intersection.png"></div>
<div><br></div><div>So clearly, N Denton Tap Rd and State Hwy 121 intersect. However, both of these queries produce no results (delta is highlighted):</div><div><b><font face="'courier new', monospace">SELECT * FROM geocode_intersection('State Hwy 121', 'N Denton Tap Rd', 'TX', <span style="background-color:rgb(255,255,0)">'Coppell'</span>);</font></b></div>
<div><b><font face="'courier new', monospace">SELECT * FROM geocode_intersection('State Hwy 121', 'N Denton Tap Rd', 'TX');</font></b></div><div><br></div><div>Certainly I'm hitting against a bug?</div>
<div><br></div><div>Aren<br><br><div class="gmail_quote">On Mon, Dec 19, 2011 at 9:19 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">
<div>Getting closer.</div><div><br></div><div>I checked the <b>tiger_data.tx_featnames</b> table's <b>fullname</b> column and am finding many references to <b>State Hwy 121</b>, matched using <b>like %121%</b>.</div>
<div>
<br></div><div>To match Denton Tap Rd., I have to use <b>like %Denton Tap%</b> in my <b>select</b>. Lower case (<b>%denton tap%</b>) produces no results--but not sure if that's relevant to the <b>geocode_intersection</b> issue here.</div>
<div><br></div><div>OK, so I run this query:</div><div><b><font face="'courier new', monospace">SELECT * FROM geocode_intersection('State Hwy 121', 'Denton Tap', 'TX', 'Coppell');</font></b></div>
<div>...and get no results!</div><div><br></div><div>I also tried these:</div><div><ul><li><b>Denton Tap Rd</b></li><li><b>N Denton Tap Rd</b></li><li><b>S Denton Tap Rd</b></li></ul><div>Not clear what's the deal here. One of these ought to match, especially since there are two TX 121s meeting with Denton Tap.</div>
</div><div><br></div><div>I also tried omitting the city and still get nothing:</div><div><font face="'courier new', monospace"><b>SELECT * FROM geocode_intersection('State Hwy 121', 'Denton Tap', 'TX');</b></font></div>
<div><br></div><div>Argh.</div><span class="HOEnZb"><font color="#888888"><div><br></div><div>Aren</div></font></span><div class="HOEnZb"><div class="h5"><div><br><div class="gmail_quote">On Mon, Dec 19, 2011 at 8:54 PM, Aren Cambre <span dir="ltr"><<a href="mailto:aren@arencambre.com" target="_blank">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">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<div><div><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" target="_blank">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><font color="#888888"><div><br></div>
<div>Aren</div>
</font></span></blockquote></div><br></div></div></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>