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

[Aren Cambre]

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/16181b5a/attachment.html>