Thanks. Already did that a few minutes ago. See <a href="http://trac.osgeo.org/postgis/ticket/1392">http://trac.osgeo.org/postgis/ticket/1392</a><div><br></div><div>Aren<br><br><div class="gmail_quote">On Tue, Dec 20, 2011 at 2:56 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Aren,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Can you ticket this one for us attaching the nice
image you have.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://trac.osgeo.org/postgis/" target="_blank">http://trac.osgeo.org/postgis/</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">We agree it's most likely a bug and probably because of
how they break out the fields in highways and we're not using the fullname
-- just the parts. We had similar issues with the base geocoder which we
fixed. So probably just requires porting a bit of the same logic to
fix.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Thanks,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Leo and Regina</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div><br>
<div dir="ltr" lang="en-us" align="left">
<hr>
<font face="Tahoma"><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of </b>Aren
Cambre<br><b>Sent:</b> Monday, December 19, 2011 11:29 PM<br><b>To:</b> PostGIS
Users Discussion<br><b>Subject:</b> Re: [postgis-users] How to look up state
highways with geocoder?<br></font><br></div><div><div class="h5">
<div></div>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 title="intersection.png" alt="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" target="_blank">aren@arencambre.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">
<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><font color="#888888">
<div><br></div>
<div>Aren</div></font></span>
<div>
<div>
<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 style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">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 style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">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></div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div>