[postgis-users] TIGER geocoder with Census 2009 shapefiles

[Stephen Woodbridge]

Ok, never mind, it looks like your zip file is all inclusive so I don't 
need the repository. That was not clear.

-Steve

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