[postgis-users] TIGER geocoder with Census 2009 shapefiles

Paragon Corporation lr at pcorp.us
Mon Mar 1 06:13:33 PST 2010


Richard,

To answer your question.  We kind of glossed over it in Step 4 when we say
run the create_geocoder.bat file.

As you can see we don't have a .sh equaivalent yet though writing one is
fairly trivial.

If you look at the file, you'll see the sequence of scripts you need to run
and the order you need to run them.

David,
Regarding your question about roads_local.sql, we don't believe that table
is used any more and got replaced with edges,addr and faces --
 if you look at the tables\lookup_tables_revised.sql  you'll see that we
remarked out sections of the original that we deemed to be obsolete and
added some new ones

Let us know if you have any other questions,
Leo and Regina

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 Richard
Greenwood
Sent: Monday, March 01, 2010 8:52 AM
To: PostGIS Users Discussion
Cc: PostGIS Development Discussion
Subject: Re: [postgis-users] TIGER geocoder with Census 2009 shapefiles

On Fri, Feb 26, 2010 at 9:52 PM, Paragon Corporation <lr at pcorp.us> wrote:
> David,
>
> As a matter of fact we've been working on that for chapter 10 of our 
> upcoming book and think we have it all working.  As a part of the 
> example generation process for our chapter 10, we had to come up with 
> a way to load the tables that works on both windows and Linux.  
> Unfortunately we haven't had a chance to test the Linux loading 
> approach, but is pretty much a parallel of the windows approach.

I am following this steps in the ReadMe.txt in
   http://www.postgis.us/downloads/tiger_geocoder_2009.zip
The ReadMe does not mention running tiger_loader.sql or create_geocode.sql
which I assume needs to take place.

When running tiger_loader.sql I get error:
ERROR:  relation "state_lookup" does not exist LINE 189: FROM state_lookup)
As s CROSS JOIN loader_platform As platfo...

When running create_geocode.sql I get error:
ERROR:  syntax error at or near "\"
LINE 21: \i utility/utmzone.sql

Thanks,
--
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users





More information about the postgis-users mailing list