<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16443"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=289235318-23052012><FONT color=#0000ff
size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=289235318-23052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=289235318-23052012><FONT color=#0000ff
size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=289235318-23052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=289235318-23052012><FONT color=#0000ff
size=2 face=Arial>Thanks for testing,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=289235318-23052012><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=289235318-23052012><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=289235318-23052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=289235318-23052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><FONT color=#0000ff size=2
face=Arial></FONT><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Jeff Rossi<BR><B>Sent:</B> Wednesday, May 23, 2012 8:38 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> Re: [postgis-users]
tiger_geocoder import error<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>psql --version</DIV>
<DIV>psql (PostgreSQL) 9.1.3</DIV>
<DIV><BR></DIV>
<DIV>postgis-1.5 from ubuntu repo</DIV>
<DIV><BR></DIV>
<DIV>I have the 2010 tiger data, and added the tiger geocoder from the 2.0
download.</DIV>
<DIV><BR></DIV>
<DIV>Perhaps my issue is due to the errors with the import.</DIV>
<DIV><BR></DIV>
<DIV>Thanks,</DIV>
<DIV><BR></DIV>
<DIV>Jeff</DIV><BR>
<DIV class=gmail_quote>On Tue, May 22, 2012 at 10:20 PM, Paragon Corporation-2
[via PostGIS] <SPAN dir=ltr><<A
href="/user/SendEmail.jtp?type=node&node=4997699&i=0" rel=nofollow
target=_top link="external">[hidden email]</A>></SPAN> wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV class=im>Jeff, <BR>Which point for example are you trying to reverse
geocode? Mine seems to be <BR>working fine but I just have MA data loaded.
<BR><BR>Also are you using the tiger_2010 or tiger_2011. ��In the 2.1 trunk
I have <BR>tiger_2011 and even if you are on 2.0 probably the best to use
since its <BR>designed for the newer tiger data and the newer tiger data has
many data <BR>quality improvements I am told. ��They also changed the fields
quite a bit <BR>between tiger_2010 and tiger_2011 releases and no longer
offer the state by <BR>state folders http structure so I had to change the
loader quite a bit to <BR>handle that they have all the states now in a
single folder. <BR><BR>Can you also let me know what version of PostGIS and
PostgreSQL you are <BR>using? <BR><BR>Thanks, <BR>Regina <BR><A
href="http://www.postgis.us" rel=nofollow target=_blank
link="external">http://www.postgis.us</A><BR><BR><BR></DIV></BLOCKQUOTE></DIV><BR>
<HR align=left width=300>
View this message in context: <A
href="http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997699.html">Re:
tiger_geocoder import error</A><BR>Sent from the <A
href="http://postgis.17.n6.nabble.com/PostGIS-User-f3516033.html">PostGIS -
User mailing list archive</A> at Nabble.com.<BR></BLOCKQUOTE></BODY></HTML>