[postgis-users] Tiger Geocoder: SELECT loader_generate_script( -- all states -- , 'sh') ??

Paragon Corporation lr at pcorp.us
Thu Oct 20 17:05:30 PDT 2011


As mentioned in other note.  We already do. If René is seeing something
else, then something is wrong with his install. 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Stephen
Sent: Thursday, October 20, 2011 7:52 PM
To: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] Tiger Geocoder: SELECT loader_generate_script(
-- all states -- , 'sh') ??

On 10/20/2011 6:22 PM, René Fournier wrote:
> This:
> SELECT loader_generate_script(ARRAY['DC','RI'], 'windows');
returns a shell script that will wget the Tiger data for the states 
> of DC and Rhode Island. And, aside from a couple small bugs, works 
> very well. I was wondering if there were a shorthand for generating a 
> shell script that will fetch ALL STATES?
> On a related note: These scripts appear to consolidate all the states 
> into the same tables -- I was wondering if splitting them up into 
> separate state-specific tables would improve performance? Anyone try 
> it?

It might be interesting to use inherited tables where each state is in it's
own table then use table constraints to select which tables need to be used
or excluded.

postgis-users mailing list
postgis-users at postgis.refractions.net

More information about the postgis-users mailing list