[postgis-users] optimal database design question

strk strk at keybit.net
Tue Jun 15 06:01:23 PDT 2004


On Tue, Jun 15, 2004 at 05:48:14AM -0700, Matthew Perry wrote:
> Hey,
>   So I've got 6 shapfiles (representing counties, streams, roads, towns, places and USGS Quad boundaries)  that I'm trying to bring into PostGIS. The user will specify one of the polygon features. My goal is to perform a spatial query selecting ALL other features that fall within the specified polygon. 
>  
> My question is: Should I put the features from all 6 shapfiles into a single table, mixing points, lines and polys into one huge table with a relatively simple SQL query. OR would it be more efficient to have 6 tables and write a more complex query (or multiple queries?) Has anyone evaluated these two methods based on execution speed and/or ease of data import?
>  
> Thanks,
> Matt Perry
> Humboldt State University

If the described operation is the only one needed it would be
faster to stuff everything in a single table, thus using a single
index.  

--strk;

PS: let us know how did it go :)


> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users




More information about the postgis-users mailing list