[postgis-users] Tiger Geocoder 2010 setup issues

Wed Jun 29 03:40:32 PDT 2011

Thank you for all your help - I got it to work!

For posterity, the postgis-related fixes I made:
-unmarked the ALTER DATABASE line in create_geocode.sh
-changed pg_hba.conf to trust, trust, trust
-tweaked a file with a name like "postgis conf" to allow access on port
5432
-added the projections.sql file to my postgis-enabled db

I also had a bunch of silly problems related to my mediocre linux skills,
e.g.
-wget wasn't working because I didn't have permissions to create a directory
-I hadn't installed unzip

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!

On Wed, Jun 29, 2011 at 12:13 PM, Paragon Corporation <lr at pcorp.us> wrote:

> **
> Daniel,
>
> 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.
>
> 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.
>
> 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+.
>
>
> Did you verify you have a tiger schema in your database and that it does
> have tables -- addr,  county, edges, faces etc?
>
> From the addr fatal error you described we guessed 1 of 3 things was
> happening
>
> a) Your script was pointing at the wrong database and not the one you
> loaded tiger in
> 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
> 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.
>
> c) Your database just doesn't have the skeleton and lookup tables or is
> missing one of them
>
> 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.
>
> Regina and Leo,
> http://www.postgis.us
>
>
>  ------------------------------
>  *From:* postgis-users-bounces at postgis.refractions.net [mailto:
> postgis-users-bounces at postgis.refractions.net] *On Behalf Of *Daniel
> Weitzenfeld
> *Sent:* Tuesday, June 28, 2011 6:52 PM
> *To:* PostGIS Users Discussion
> *Subject:* Re: [postgis-users] Tiger Geocoder 2010 setup issues
>
> Thank you Regina and Leo. It sounds like I might have a version issue.
>
> I'm using PostGIS 1.5.3, as per the installation instructions here:
> http://postgis.refractions.net/docs/ch02.html
>
> When you suggested redownloading, did you mean all of PostGIS, or just the
> geocoder?
>
> Is the code here the up to date version?  here =
> http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/
> Because in tiger_loader.sql at that location, there's the line:
>
> E'STATEDIR="${staging_fold}/${website_root}/${state_fold}"
>
>
> Is that the fixed version?
>
> In the meantime, I'll work on my ident issues.
>
>
>
>
>
>
>
> On Tue, Jun 28, 2011 at 11:46 PM, Paragon Corporation <lr at pcorp.us> wrote:
>
>> Daniel,
>>
>> Haven't had a chance to recheck our script to confirm its not something
>> amiss.
>>
>> Which version of PostGIS  are you working with?
>>
>>  You can ignore the does not exist, skipping errors -- those are trying to
>> drop tables which wouldn't exist for new installs.
>>
>> The addr does not exist often happens if you don't have tiger in your
>> database search_path.  Make sure its in your search_path.  Also you can
>> verify the table exists
>> By making sure you have a tiger schema and it has tables like addr, edges
>> etc.
>>
>> Regarding your ident problem.
>>
>> PostgreSQL can listen on localhost or local port and depending on which
>> that
>> has to be registered in pg_hba.conf
>>
>> You can try taking out the PGHOST line since you may be running only on a
>> non-IP port and see if that helps or change your pg_hba.conf to allow.
>>
>> Regarding this issue:
>> STATEDIR="/gisdata/www2.census.gov/geo/pvs/tiger2010st/36_New_York"
>>
>> especially because an early command is
>>
>>  cd $STATEDIR
>>
>> I'm pretty sure we fixed that so I suspect your version is probably out of
>> data and you may want to just redownload from PostGIS site (either the SVN
>> tar ball or directly from svn)
>>
>> Regina and Leo
>> http://www.postgis.us
>>
>>
>> -----Original Message-----
>> From: postgis-users-bounces at postgis.refractions.net
>> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
>> Daniel
>> Weitzenfeld
>> Sent: Tuesday, June 28, 2011 6:51 AM
>> To: postgis-users at postgis.refractions.net
>> Subject: [postgis-users] Tiger Geocoder 2010 setup issues
>>
>> Hi,
>> I'm trying to setup the TIGER Geocoder, following the readme here:
>> http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/README
>> I'm setting it up on a centos 5.5 server.
>> My questions are below, organized by the step in the README.
>>
>> ------| Step 3.  Edit the tiger_loader.sql to the paths of your
>> executables server etc.
>> Is the UNZIPTOOL variable supposed to be changed, or left at its default?
>> UNZIPTOOL=unzip
>>
>> ------| Step 4.  Edit the create_geocode.bat or create_geocode.sh and
>> ------| run
>>
>> When I ran the file, I got a boatload of NOTICEs like the following,
>> interspersed throughout the output:
>>
>> psql:tables/lookup_tables_2010.sql:4: NOTICE:  table "direction_lookup"
>> does
>> not exist, skipping
>> psql:tables/lookup_tables_2010.sql:39: NOTICE:  table
>> "secondary_unit_lookup" does not exist, skipping
>>
>> Is this something I should be concerned about?  Did I skip something?
>>
>> Perhaps more alarmingly, the output finished with this:
>>
>> COMMIT
>> ERROR:  relation "addr" does not exist
>>
>> Again, what should I do?
>>
>> ------| 8. Run this command at psql or pgAdmin III query window to
>> generate the script.
>> The first line of the generated script doesn't look right:
>>
>> STATEDIR="/gisdata/www2.census.gov/geo/pvs/tiger2010st/36_New_York"
>>
>> especially because an early command is
>>
>>  cd $STATEDIR
>>
>> Also, when I try to run the generated script anyway, I get a boatload of
>> these:
>>
>> psql: FATAL:  Ident authentication failed for user "daniel"
>>
>> ...which is strange to me because I user I thought user daniel had rights
>> on
>> the PGDATABASE.  Indeed, user daniel can create/delete schemas on it.  Am
>> I
>> misunderstanding something about postgres permissions?
>>
>> Thanks in advance for any guidance you can provide.
>> Best,
>> -Daniel
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110629/0ad61608/attachment.html>