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

[Aren Cambre]

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