Opened 8 years ago

Closed 8 years ago

#1392 closed defect (fixed)

Can't geocode an intersection that should work

Reported by: arencambre Owned by: robe
Priority: medium Milestone: PostGIS 2.0.0
Component: tiger geocoder Version: master
Keywords: Cc: aren@…

Description

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.

Attachments (1)

intersection.png (50.1 KB) - added by arencambre 8 years ago.

Download all attachments as: .zip

Change History (9)

Changed 8 years ago by arencambre

Attachment: intersection.png added

comment:1 Changed 8 years ago by arencambre

Version: 1.5.Xtrunk

comment:2 Changed 8 years ago by robe

Status: newassigned

comment:3 Changed 8 years ago by robe

Resolution: fixed
Status: assignedclosed

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.

comment:4 Changed 8 years ago by arencambre

Resolution: fixed
Status: closedreopened

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
  2. tar -xvzf postgis-2.0.0SVN.tar.gz
  3. cd postgis-2.0.0SVN/
  4. ./configure --with-pgconfig=/usr/bin/pg_config
  5. make
  6. sudo make install
  7. 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.

comment:5 Changed 8 years ago by 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.

comment:6 Changed 8 years ago by 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

comment:7 Changed 8 years ago by robe

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

comment:8 Changed 8 years ago by arencambre

Resolution: fixed
Status: reopenedclosed

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

Note: See TracTickets for help on using tickets.