The reverse geocoder uses zcta table where as the geocoder does not. Verify that data is filled. There should be one for each state you load like fl_zcta. That load I added in 2.0.0 so it should be there (assuming you have the 2.0.0 tar ball) and be part of the loading, but not sure I tested it on Linux though so I might have an error somewhere there. You should see it in the loader_lookuptables. Thanks for testing, Regina http://www.postgis.us
_____ From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Jeff Rossi Sent: Wednesday, May 23, 2012 8:38 AM To: postgis-users@postgis.refractions.net Subject: Re: [postgis-users] tiger_geocoder import error psql --version psql (PostgreSQL) 9.1.3 postgis-1.5 from ubuntu repo I have the 2010 tiger data, and added the tiger geocoder from the 2.0 download. Perhaps my issue is due to the errors with the import. Thanks, Jeff On Tue, May 22, 2012 at 10:20 PM, Paragon Corporation-2 [via PostGIS] <[hidden email]> wrote: Jeff, Which point for example are you trying to reverse geocode? Mine seems to be working fine but I just have MA data loaded. Also are you using the tiger_2010 or tiger_2011. ��In the 2.1 trunk I have tiger_2011 and even if you are on 2.0 probably the best to use since its designed for the newer tiger data and the newer tiger data has many data quality improvements I am told. ��They also changed the fields quite a bit between tiger_2010 and tiger_2011 releases and no longer offer the state by state folders http structure so I had to change the loader quite a bit to handle that they have all the states now in a single folder. Can you also let me know what version of PostGIS and PostgreSQL you are using? Thanks, Regina http://www.postgis.us _____ View this message in context: Re: <http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997699.html> tiger_geocoder import error Sent from the PostGIS - <http://postgis.17.n6.nabble.com/PostGIS-User-f3516033.html> User mailing list archive at Nabble.com.
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users