Can't geocode an intersection that should work

[arencambre]

The attached image is a sample from the tiger_data.tx_edges table as viewed in Quantum GIS.

You can clearly see that N Denton Tap Rd intersects State Hwy 121. However, these queries produce no results:

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');

This geocoder was constructed using the instructions at  http://www.letseehere.com/postgis-geocoder-using-tiger-2010-data but only using Texas data. This intersection is in Coppell, Dallas County, TX.

[robe]

should be fixed at r8713. It was my assumption that everything should have an addr record and the addr record should have a zip which is often not the case for highways.

[arencambre]

I just downloaded and installed r8715, and I still get no results.

I used these steps, in case it matters. I am running Ubuntu 11.10 Desktop 32-bit.

1. wget  http://postgis.refractions.net/download/postgis-2.0.0SVN.tar.gz 1. tar -xvzf postgis-2.0.0SVN.tar.gz 1. cd postgis-2.0.0SVN/ 1. ./configure --with-pgconfig=/usr/bin/pg_config 1. make 1. sudo make install 1. sudo ldconfig

Then I did su postgres and ran: /usr/bin/psql -d geocoder -f /usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql

Then for good measure I did sudo /etc/init.d/postgresql restart

Still getting no results for the above queries.

[arencambre]

Crap, sorry for the mess in the prior comment. For some reason, this Trac doesn't let me edit my own comments (!), so I can't clean it up. I meant to have an ordered list in the middle.

[robe]

It's not part of the upgarde minor 2.0 script because its not always installed and also a lot of people on 1.5 are using it. Things in the extras folder are never installed as part of the core PostGIS.

Sorry I should clarify that better in the docs (probably in the install sectin where a lot of people are looking). You want to run the extras/tiger_geocoder/tiger_2010/upgrade_geocoder.sh or upgrade_geocoder.bat file

[robe]

For this you can get by by running the -- upgrade_geocode.sql from psql.

[arencambre]

Oops, that was it. Thanks! And I didn't realize you could use this tiger_2010 with PostGIS 1.5!