[postgis-users] TIGER geocoder with Census 2009 shapefiles

[Paragon Corporation]

Steve,

As mentioned, not quite completely inclusive as we forgot to include the
original sh loader scripts.

We being lazy windows bums, we just used TortoiseGit to download the files.
But other Git download tools are listed here
http://git-scm.com/tools 

We apologize for the confusion in the writing in the chapter summary.
Originally we had planned to just have the enhancements we added for
download and have people download the rest from GIT themselves, but then
after writing a page or two about how to get it from GIT, we decided it was
too distracting.  So we cut that all out and included the original in the
download.

We were also thinking eventually it will be folded back into the PostGIS
source code repository, so all the GIT instructions would be obsolete by the
time the book was out anyway.

Thanks,
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 Stephen
Woodbridge
Sent: Tuesday, March 02, 2010 10:41 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] TIGER geocoder with Census 2009 shapefiles

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

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users