[postgis-users] TIGER/Line Shapefiles released

Stephen Woodbridge woodbri at swoodbridge.com
Thu Apr 3 22:05:53 PDT 2008


OK, Now I'm feeling kind of dumb.

./process_tiger.sh -n
Internal error!
./process_tiger.sh -n \*
Internal error!
./process_tiger.sh -n ''
Internal error!

woodbri at carto:~/work/new-tiger$ sh -x process_tiger.sh -d -n
+ BASE=TIGER2007FE
+ SETBASE=fe_2007
+ PREFIX=tiger
+ SKIP00=y
++ mktemp -d -p .
+ TMPDIR=./tmp.ZKN9vx
+ SRID=4269
+ USER=postgres
+ HOST=carto
+ DB=tiger2007fe
+ ENCODING=LATIN1
+ NATIONAL=false
+ STATELVL=false
+ STATES=
+ COUNTYLVL=false
+ COUNTIES=
+ DROP=false
++ getopt -o n::ls::bc::ed -n process_tiger.sh -- -d -n
+ TEMP= -d -n '' --
+ '[' 0 '!=' 0 ']'
+ eval set -- ' -d -n '\'''\'' --'
++ set -- -d -n '' --
+ true
+ DROP=true
+ shift
+ true
+ NATIONAL=true
+ shift
+ true
+ echo 'Internal error!'
Internal error!
+ exit 1

What did I miss here.

-Steve

Stephen Frost wrote:
> Stephen,
> 
> * Stephen Woodbridge (woodbri at swoodbridge.com) wrote:
>> I added to process_tiger.sh:
>>
>> # User to connect to database with or use USER=$LOGNAME
>> USER="postgres"
> 
> Ah, sure, makes sense.  We user Kerberos for our authentication, so I
> tend to forget about user/pw authentication issues.
> 
>> and in vi did:
>>
>> %s/\<psql\>/psql -U $USER/g
>>
>> to update the script.
> 
> All of the options passed to psql really should be done as options to
> the script.  I'll look at adding that (and -U support) sometime
> tomorrow.
> 
>> Question on the README.txt
>>
>> -n     Load national-level data
>> -b     Load state-level data
>> -c     Load county-level data
>>
>> Do the above options load all the data at the given level or do I also  
>> need to run it for each state and county with the options below?
> 
> Yes, by default it'll load all data at that level.
> 
>> -s <2-digit state code>  Individual state code to load
>> -c <3-digit or 5-digit county code>  Individual county code to load
> 
> These are used if you, for example, have to reload a specific state
> and/or county.  I had the luxury of doing this when someone decided to
> restart the database in the middle of my data load.. :)
> 
>> Does:
>>
>> cd /u/srcdata/tiger2007fe
>> ./process_tiger.sh -n -b -c
>>
>> load all the data? Assuming that that directory is a mirror of the  
>> Census download directory.
> 
> Yes, it should, though it expects to be run one level up from
> 'TIGER2007FE', unless you adjust the "BASE" environment variable at the
> top of the script.
> 
> 	Thanks,
> 
> 		Stephen
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users




More information about the postgis-users mailing list