[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.

-Steve



More information about the postgis-users mailing list