[postgis-users] ST_AsJpeg

[Pierre Racine]

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-Minimalist-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
> 
>