Now that I've got it working, a couple more questions:<br><br>"The higher the rating the less likely the geocode is right." Are there heuristics for ranges of ratings and how much to trust the result?<br><br>
Are there performance advantages to coding in batches?<br><br>Thanks again. <br><br><br><div class="gmail_quote">On Wed, Jun 29, 2011 at 8:40 PM, Daniel Weitzenfeld <span dir="ltr"><<a href="mailto:dweitzenfeld@gmail.com">dweitzenfeld@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Thank you for all your help - I got it to work! <br><br>For posterity, the postgis-related fixes I made:<br>-unmarked the ALTER DATABASE line in create_geocode.sh<br>
-changed <span><font color="#0000ff" face="Arial" size="2">pg_hba.conf to trust, trust, trust </font></span><br>
-tweaked a file with a name like "postgis conf" to allow access on port 5432 <br>-added the projections.sql file to my postgis-enabled db <br><br>I also had a bunch of silly problems related to my mediocre linux skills, e.g. <br>
-wget wasn't working because I didn't have permissions to create a directory<br>-I hadn't installed unzip<br><br>Basically I was in over my head but I surfaced. The precision from the geocodes I've run so far has been really amazing, good stuff Regina and Leo!<div>
<div></div><div class="h5"><br>
<br><br><br><div class="gmail_quote">On Wed, Jun 29, 2011 at 12:13 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Daniel,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Yap. what we had done is move the declaration up above
the CD call since we rna into same issue when testing in Linux. As I
recall I think when people complained about the issue, the CD call came before
the STATEDIR.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Regarding 1.5.3. You should be fine to run with
that. For our production work involving tiger geocoder, we are using
PostGIS 1.5 and I think most people are actually and just testing on
PostGIS 2.0. </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">However we did make changes that now require PostgreSQL 8.4 or
above. So you need to be running at least PostGIS 1.5 and PostgreSQL
8.4+.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Did you verify you have a tiger schema in your database and
that it does have tables -- addr, county, edges, faces
etc?</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">From the addr fatal error you described we guessed 1 of 3
things was happening</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">a) Your script was pointing at the wrong database and not the
one you loaded tiger in</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">b) The tiger schema wasn't in your search path --- If you look
at the create_geocode.sh (you'll see a remarked out line to alter db to add
tiger to your database search path), this is a common mistake people make not
having that line</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">which causes the error you described. We left it remarked out
since some people have custom search paths and we didn't want to overwrite
them.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">c) Your database just doesn't have the skeleton and lookup
tables or is missing one of them </font></span></div>
<div dir="ltr" align="left" lang="en-us"><span><font color="#0000ff" face="Arial" size="2"> </font></span></div>
<div dir="ltr" align="left" lang="en-us"><span><font color="#0000ff" face="Arial" size="2">Like I said your
next issue is your pg_hba.conf or you have another instance of PostgreSQL
running and you are pointing at the wrong instance.</font></span></div><div>
<div dir="ltr" align="left" lang="en-us"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left" lang="en-us"><span><font color="#0000ff" face="Arial" size="2">Regina and
Leo,</font></span></div>
<div dir="ltr" align="left" lang="en-us"><span><font color="#0000ff" face="Arial" size="2"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></font></span></div>
<div dir="ltr" align="left" lang="en-us"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left" lang="en-us"><span> </span></div>
</div><div dir="ltr" align="left" lang="en-us">
<hr>
</div>
<div dir="ltr" align="left" lang="en-us"><font face="Tahoma" size="2"><div><b>From:</b> <a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of
</b>Daniel Weitzenfeld<br></div><b>Sent:</b> Tuesday, June 28, 2011 6:52
PM<br><b>To:</b> PostGIS Users Discussion<br><b>Subject:</b> Re: [postgis-users]
Tiger Geocoder 2010 setup issues<br></font><br></div><div><div></div><div>
<div></div>Thank you Regina and Leo. It sounds like I might have a version
issue. <br><br>I'm using PostGIS 1.5.3, as per the installation instructions
here: <a href="http://postgis.refractions.net/docs/ch02.html" target="_blank">http://postgis.refractions.net/docs/ch02.html</a><br><br>When
you suggested redownloading, did you mean all of PostGIS, or just the
geocoder?<br><br>Is the code here the up to date version? here = <a href="http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/" target="_blank">http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/</a><br>
<font style="font-family:arial,helvetica,sans-serif" size="2">Because in
tiger_loader.sql at that location, there's the line:<br></font><pre><font style="font-family:arial,helvetica,sans-serif" size="2">E'STATEDIR="${staging_fold}/${website_root}/${state_fold}"<br>
<br>Is that the fixed version? <br><br>In the meantime, I'll work on my ident issues. <br></font></pre><br><br><br><br><br><br>
<div class="gmail_quote">On Tue, Jun 28, 2011 at 11:46 PM, Paragon Corporation
<span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span>
wrote:<br>
<blockquote style="border-left:#ccc 1px solid;margin:0px 0px 0px 0.8ex;padding-left:1ex" class="gmail_quote">Daniel,<br><br>Haven't had a chance to recheck our script to
confirm its not something<br>amiss.<br><br>Which version of PostGIS are
you working with?<br><br> You can ignore the does not exist, skipping
errors -- those are trying to<br>drop tables which wouldn't exist for new
installs.<br><br>The addr does not exist often happens if you don't have tiger
in your<br>database search_path. Make sure its in your search_path.
Also you can<br>verify the table exists<br>By making sure you have a
tiger schema and it has tables like addr, edges<br>etc.<br><br>Regarding your
ident problem.<br><br>PostgreSQL can listen on localhost or local port and
depending on which that<br>has to be registered in pg_hba.conf<br><br>You can
try taking out the PGHOST line since you may be running only on a<br>non-IP
port and see if that helps or change your pg_hba.conf to
allow.<br><br>Regarding this issue:<br>
<div>STATEDIR="/gisdata/<a href="http://www2.census.gov/geo/pvs/tiger2010st/36_New_York" target="_blank">www2.census.gov/geo/pvs/tiger2010st/36_New_York</a>"<br><br>especially
because an early command is<br><br> cd $STATEDIR<br><br></div>I'm pretty
sure we fixed that so I suspect your version is probably out of<br>data and
you may want to just redownload from PostGIS site (either the SVN<br>tar ball
or directly from svn)<br><br>Regina and Leo<br><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a><br><br><br>-----Original
Message-----<br>From: <a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a><br>[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>]
On Behalf Of Daniel<br>Weitzenfeld<br>Sent: Tuesday, June 28, 2011 6:51
AM<br>To: <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>Subject:
[postgis-users] Tiger Geocoder 2010 setup issues<br>
<div>
<div></div>
<div><br>Hi,<br>I'm trying to setup the TIGER Geocoder, following the
readme here:<br><a href="http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/README" target="_blank">http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/README</a><br>I'm
setting it up on a centos 5.5 server.<br>My questions are below, organized by
the step in the README.<br><br>------| Step 3. Edit the tiger_loader.sql
to the paths of your<br>executables server etc.<br>Is the UNZIPTOOL variable
supposed to be changed, or left at its
default?<br>UNZIPTOOL=unzip<br><br>------| Step 4. Edit the
create_geocode.bat or create_geocode.sh and<br>------| run<br><br>When I ran
the file, I got a boatload of NOTICEs like the following,<br>interspersed
throughout the output:<br><br>psql:tables/lookup_tables_2010.sql:4: NOTICE:
table "direction_lookup" does<br>not exist,
skipping<br>psql:tables/lookup_tables_2010.sql:39: NOTICE:
table<br>"secondary_unit_lookup" does not exist, skipping<br><br>Is this
something I should be concerned about? Did I skip
something?<br><br>Perhaps more alarmingly, the output finished with
this:<br><br>COMMIT<br>ERROR: relation "addr" does not
exist<br><br>Again, what should I do?<br><br>------| 8. Run this command at
psql or pgAdmin III query window to<br>generate the script.<br>The first line
of the generated script doesn't look right:<br><br>STATEDIR="/gisdata/<a href="http://www2.census.gov/geo/pvs/tiger2010st/36_New_York" target="_blank">www2.census.gov/geo/pvs/tiger2010st/36_New_York</a>"<br>
<br>especially
because an early command is<br><br> cd $STATEDIR<br><br>Also, when I try
to run the generated script anyway, I get a boatload of<br>these:<br><br>psql:
FATAL: Ident authentication failed for user "daniel"<br><br>...which is
strange to me because I user I thought user daniel had rights on<br>the
PGDATABASE. Indeed, user daniel can create/delete schemas on it.
Am I<br>misunderstanding something about postgres
permissions?<br><br>Thanks in advance for any guidance you can
provide.<br>Best,<br>-Daniel<br></div></div>_______________________________________________<br>postgis-users
mailing list<br><a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br><br>_______________________________________________<br>postgis-users
mailing list<br><a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br></div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br>
</div></div></blockquote></div><br>