[postgis-users] Newbie question #2 -- visualizing large datasets?

[Dylan Beaudette]

Hi Jonathan, others:

I normally use QGIS to visualize a subset of the massive geometries that i 
maintain in postgis. I would recommend a couple ways of working with a 
subset:

using limit: SELECT ... FROM ... LIMIT 1000;
creating a view based on the intersection of your geometries, and some 
bounding box:

a rather complex example of this can be found here:
http://casoilresource.lawr.ucdavis.edu/drupal/node/265

Cheers,

Dylan

On Tuesday 10 October 2006 11:25, Craig Miller wrote:
> Try using "generalize" in your PostGIS query to limit the number of
> vertices that are returned when zoomed way out.
>
> --Craig
>
>
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> Jonathan Greenberg
> Sent: Tuesday, October 10, 2006 11:17 AM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Newbie question #2 -- visualizing large datasets?
>
> Is there a way to visualize massive databases of points or polygons?  I'm
> talking data much larger than I've been able to display in arc or grass
> environments using their basic vector coverage formats.  Thanks!
>
> --j
>
> --
> Jonathan A. Greenberg, PhD
> NRC Research Associate
> NASA Ames Research Center
> MS 242-4
> Moffett Field, CA 94035-1000
> Office: 650-604-5896
> Cell: 415-794-5043
> AIM: jgrn307
> MSN: jgrn307 at hotmail.com
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
Dylan Beaudette
Soils and Biogeochemistry Graduate Group
University of California at Davis
530.754.7341