[postgis-users] Advantages and disadvantages of storing raster in PostGIS raster

[Pierre Racine]

For ST_Union you can test my temporary solution:

http://geospatialelucubrations.blogspot.ca/2012/07/a-slow-yet-1000x-faster-alternative-to.html

Pierre

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Jakub Hettler
> Sent: Thursday, August 23, 2012 4:12 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Advantages and disadvantages of storing raster in
> PostGIS raster
> 
> That was one of my questions, how to make analasys on tiled rasters? Is that
> possible or not, I tried to make ST_Union on 200 tiles and I stopped it after a few
> minutes :)
> 
> I am testing raster automatic publication of OGC services through PostGIS raster
> and image mosaic JDBC plugin and Java a I am quiet satisfied, but I have only
> small rasters (max 30 Mb), I expected that it will be really slow (reading raster
> from database, merging together and visualize them), but I am quite surprised.
> 
> But I expect that the same rasters will be faster from file system.
> 
> 
> Thanks
> 
> Jakub
> 
> 
> 2012/8/23 Bborie Park <bkpark at ucdavis.edu>
> 
> 
> 	For my work, PostGIS raster provides a standardized method to store,
> 	manage and query various datasets, specifically longitudinal climate
> 	data and DEM for California.  This permits my end-users (researchers
> and
> 	various decision support software) to use the SQL knowledge they
> already
> 	know to get the data that they're looking for without needing additional
> 	software (ENVI, ERDAS Imagine, ArcGIS).
> 
> 	The biggest limitation to PostGIS raster in 2.0 (and trunk) is that
> 	there isn't advanced map algebra support (needed for fast unioning and
> 	model output).  I hope to start working developing that support in the
> 	next week or two... as I need it for my work.
> 
> 	-bborie
> 
> 
> 	On 08/23/2012 11:34 AM, Jakub Hettler wrote:
> 	> Hi,
> 	> just a simple question, I try to find some work on this issue, but
> nothing
> 	> found.
> 	>
> 	> Could somebody provide some information?
> 	>
> 	> Thanks a lot
> 	>
> 	> Jakub
> 	>
> 	>
> 	>
> 
> 	> _______________________________________________
> 	> postgis-users mailing list
> 	> postgis-users at postgis.refractions.net
> 	> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 	>
> 
> 	--
> 	Bborie Park
> 	Programmer
> 	Center for Vectorborne Diseases
> 	UC Davis
> 	530-752-8380
> 	bkpark at ucdavis.edu
> 	_______________________________________________
> 	postgis-users mailing list
> 	postgis-users at postgis.refractions.net
> 	http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
>