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

[Paragon Corporation]

thanks.  disregard our other message.

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Aren
Cambre
Sent: Tuesday, December 20, 2011 3:54 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] How to look up state highways with geocoder?


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: 
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.99359
5&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/a55d3c27/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/a55d3c27/attachment.png>