[postgis-users] Tiger Geocoder 2010 setup issues

Thu Jun 30 17:40:33 PDT 2011

Now that I've got it working, a couple more questions:

"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?

Are there performance advantages to coding in batches?

Thanks again.

On Wed, Jun 29, 2011 at 8:40 PM, Daniel Weitzenfeld
<dweitzenfeld at gmail.com>wrote:

> 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/20110701/adc109b9/attachment.html>