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-boun...@postgis.refractions.net [mailto:postgis-users-boun...@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 <l...@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.greenw...@gmail.com www.greenwoodmap.com _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
