[postgis-users] TIGER geocoder with Census 2009 shapefiles

[Richard Greenwood]

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