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

[Aren Cambre]

The plot thickens further. I used QGIS to view the
*tiger_data.tx_edges*table. I had it label everything using the
*fullname* column. I found the intersection:
[image: intersection.png]

So clearly, N Denton Tap Rd and State Hwy 121 intersect. However, both of
these queries produce no results (delta is highlighted):
*SELECT * FROM geocode_intersection('State Hwy 121', 'N Denton Tap Rd',
'TX', 'Coppell');*
*SELECT * FROM geocode_intersection('State Hwy 121', 'N Denton Tap Rd',
'TX');*

Certainly I'm hitting against a bug?

Aren

On Mon, Dec 19, 2011 at 9:19 PM, Aren Cambre <aren at arencambre.com> wrote:

> Getting closer.
>
> I checked the *tiger_data.tx_featnames* table's *fullname* column and am
> finding many references to *State Hwy 121*, matched using *like %121%*.
>
> To match Denton Tap Rd., I have to use *like %Denton Tap%* in my *select*.
> Lower case (*%denton tap%*) produces no results--but not sure if that's
> relevant to the *geocode_intersection* issue here.
>
> OK, so I run this query:
> *SELECT * FROM geocode_intersection('State Hwy 121', 'Denton Tap', 'TX',
> 'Coppell');*
> ...and get no results!
>
> I also tried these:
>
>    - *Denton Tap Rd*
>    - *N Denton Tap Rd*
>    - *S Denton Tap Rd*
>
> Not clear what's the deal here. One of these ought to match, especially
> since there are two TX 121s meeting with Denton Tap.
>
> I also tried omitting the city and still get nothing:
> *SELECT * FROM geocode_intersection('State Hwy 121', 'Denton Tap', 'TX');*
>
> Argh.
>
> Aren
>
> On Mon, Dec 19, 2011 at 8:54 PM, Aren Cambre <aren at arencambre.com> wrote:
>
>> Here's the query I'm using:
>> *SELECT * FROM geocode_intersection('SH 121', 'Denton Tap', 'TX',
>> 'Coppell');*
>>
>> Aren
>>
>>
>> On Mon, Dec 19, 2011 at 7:56 PM, Aren Cambre <aren at arencambre.com> wrote:
>>
>>> 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/82e8d9a4/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: intersection.png
Type: image/png
Size: 51323 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111219/82e8d9a4/attachment.png>