[postgis-users] Tiger Geocoder: SELECT loader_generate_script( -- all states -- , 'sh') ??
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.
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:
> 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 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
postgis-users mailing list
postgis-users at postgis.refractions.net
More information about the postgis-users