[postgis-users] Tiger Geocoder: SELECT loader_generate_script( -- all states -- , 'sh') ??
woodbri at swoodbridge.com
Thu Oct 20 16:52:12 PDT 2011
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 or excluded.
More information about the postgis-users