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

[Pedro Doria Meunier]

My two-cents:

I currently work with sets > 10,000 elements and postgis is steady as a
rock... even with on-the-fly reprojections.

If these are considered as 'bigger' sets... :D

I guess it's a matter of cpu/ram availability.

If this helps the ws where I usually work is a double-dual core with 4Gb of
ram and, err..., window$ ... (yeah go ahead and trash me! :D )

Also when doing re-projections a neat trick is already having a GiST of the
projection you target when comparing stuff (like degrees to meters).

Cheers,

Pedro Doria Meunier
(351) 91 302 49 72 - (351) 96 247 99 12
MSN - pdoriam at hotmail.com
ICQ - 308-182-126
Skype: pdoriam

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Dylan
Beaudette
Sent: terça-feira, 10 de Outubro de 2006 21:17
To: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] Newbie question #2 -- visualizing large
datasets?

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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users