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

[Aren Cambre]

I guess this was an odd question, so I opened a ticket at
http://trac.osgeo.org/postgis/ticket/1392 so it's not forgotten.

Aren

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

> 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/20111220/e7e95579/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/20111220/e7e95579/attachment.png>