[postgis-users] ST_AsJpeg

[Paragon Corporation]

We have this documented in the docs.

http://www.postgis.org/documentation/manual-svn/using_raster.xml.html#RT_Ras
ter_Applications

There is an example for doing it with PHP, .NET, Java, and PLPython

Sorry don't have one for psql only.  Haven't tried using psql for outputting
files.

Regina
http://www.postgis.us



 

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Pierre Racine
> Sent: Tuesday, February 14, 2012 11:05 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] ST_AsJpeg
> 
> So you might have to write a script connecting to PostgreSQL 
> and writing the file for you. See an example in:
> 
> http://www.bostongis.com/blog/index.php?/archives/175-Minimali
> st-Web-based-PHP-PostGIS-2.0-Spatial-GeometryRaster-Viewer.html
> 
> Pierre
> 
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net 
> > [mailto:postgis-users- bounces at postgis.refractions.net] On 
> Behalf Of 
> > Joan
> > Sent: Tuesday, February 14, 2012 10:10 AM
> > To: PostGIS Users Discussion
> > Subject: Re: [postgis-users] ST_AsJpeg
> > 
> > Yes, I want to create a jpeg/tiff file. I am new to 
> cursors, how would 
> > that work in a query.
> > 
> > 
> > On 14 February 2012 15:39, Pierre Racine 
> <Pierre.Racine at sbf.ulaval.ca> wrote:
> > 
> > 
> > 	Thanks,
> > 
> > 	Do you see any way to make the file directly readable 
> (without having 
> > to edit it)?
> > 
> > 
> > 	Pierre
> > 
> > 	> -----Original Message-----
> > 	> From: postgis-users-bounces at postgis.refractions.net 
> > [mailto:postgis-
> > users-
> > 
> > 	> bounces at postgis.refractions.net] On Behalf Of Sandro Santilli
> > 	> Sent: Tuesday, February 14, 2012 9:28 AM
> > 	> To: PostGIS Users Discussion
> > 
> > 	> Subject: Re: [postgis-users] ST_AsJpeg
> > 	>
> > 	> On Tue, Feb 14, 2012 at 09:22:21AM -0500, Pierre Racine wrote:
> > 	> > Yes. You want to write the file directly to the filesystem? 
> > Sandro wrote
> > 	> something in the list about this recently but I can't 
> find it. Sandro?
> > Robe?
> > 	> >
> > 	>
> > 	> I ended up binary-editing the result afterwards.
> > 	>
> > 	> Anyway, first step is declaring a binary cursor, 
> redirecting output 
> > to a file and
> > 	> calling the function.
> > 	>
> > 	> For the binary editing, I looked at another file with 
> my expected 
> > format to tell
> > 	> where it started (human eye pattern matching).
> > 	>
> > 	> > You can also use gdal_translate...
> > 	>
> > 	> Much better, when it works (it wasn't working for me).
> > 	>
> > 	> --strk;
> > 	>
> > 	>   ,------o-.
> > 	>   |   __/  |    Delivering high quality PostGIS 2.0 !
> > 	>   |  / 2.0 |    http://strk.keybit.net
> > 	>   `-o------'
> > 	>
> > 	> _______________________________________________
> > 	> 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
> > 
> > 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>