<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16440"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=745215720-20122011><FONT color=#0000ff
size=2 face=Arial>thanks. disregard our other
message.</FONT></SPAN></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Aren
Cambre<BR><B>Sent:</B> Tuesday, December 20, 2011 3:54 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>I guess this was an odd question, so I opened a ticket at <A
href="http://trac.osgeo.org/postgis/ticket/1392">http://trac.osgeo.org/postgis/ticket/1392</A> so
it's not forgotten.
<DIV><BR></DIV>
<DIV>Aren<BR><BR>
<DIV class=gmail_quote>On Mon, Dec 19, 2011 at 10:29 PM, Aren Cambre <SPAN
dir=ltr><<A
href="mailto:aren@arencambre.com">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>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
src="cid:745215720@20122011-3668"></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><SPAN class=HOEnZb><FONT
color=#888888>
<DIV><BR></DIV></FONT></SPAN>
<DIV><SPAN class=HOEnZb><FONT color=#888888>Aren</FONT></SPAN>
<DIV>
<DIV class=h5><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><B>N Denton Tap Rd</B>
<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>state highway 121
<LI>TX 121
<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></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>