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

Aren Cambre aren at arencambre.com
Tue Dec 20 13:16:31 PST 2011


Thanks. Already did that a few minutes ago. See
http://trac.osgeo.org/postgis/ticket/1392

Aren

On Tue, Dec 20, 2011 at 2:56 PM, Paragon Corporation <lr at pcorp.us> wrote:

> **
> Aren,
>
> Can you ticket this one for us  attaching the nice image you have.
>
> http://trac.osgeo.org/postgis/
>
> We agree it's most likely a bug and probably because of how they break out
> the fields in highways and we're not using the fullname -- just the parts.
> We had similar issues with the base geocoder which we fixed.  So probably
> just requires porting a bit of the same logic to fix.
>
> Thanks,
> Leo and Regina
> http://www.postgis.us
>
>
>  ------------------------------
> *From:* postgis-users-bounces at postgis.refractions.net [mailto:
> postgis-users-bounces at postgis.refractions.net] *On Behalf Of *Aren Cambre
> *Sent:* Monday, December 19, 2011 11:29 PM
> *To:* PostGIS Users Discussion
> *Subject:* Re: [postgis-users] How to look up state highways with
> geocoder?
>
> 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
>>>>
>>>
>>>
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111220/5077f79e/attachment.html>


More information about the postgis-users mailing list