[postgis-users] TIGER geocoder with Census 2009 shapefiles

[Stephen Woodbridge]

OK, this is a silly question, what is the git command to download 
Stephen Frost's repository?

$ git fetch http://www.snowman.net/git/
fatal: Not a git repository

$ git fetch git://www.snowman.net/git/
fatal: Not a git repository

I've never used git before so this is not obvious, to me. You might want 
to add 1-2 lines to chapter 10 to say how to do that so readers can 
focus on the geocoder and not on git.

-Steve

Paragon Corporation wrote:
> 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
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users