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

Stephen Woodbridge woodbri at swoodbridge.com
Thu Oct 20 16:52:12 PDT 2011

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.


More information about the postgis-users mailing list