ST_AsKML(geometry) would be returning XML so suffers no binary issues.
-bborie
On 02/14/2012 02:53 PM, Pierre Racine wrote:
Curious that the question was never raised for ST_AsKML(geometry)...
-----Original Message-----
From: [email protected] [mailto:postgis-users-
[email protected]] On Behalf Of Paragon Corporation
Sent: Tuesday, February 14, 2012 5:43 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] ST_AsJpeg
Here it is in the docs now:
http://postgis.refractions.net/documentation/manual-
svn/using_raster.xml.html#RasterOutput_PSQL
________________________________
From: [email protected] [mailto:postgis-
[email protected]] On Behalf Of Joan
Sent: Tuesday, February 14, 2012 4:23 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] ST_AsJpeg
The last two solutions result in a black square, which I think is the
tile.
But it's a good start. I will have to look more into that.
Regina, I have tried using \g to out put to a file but the file is
corrupted.
I appreciate the help.
Joan
On 14 February 2012 21:27, Paragon Corporation<[email protected]> wrote:
We have this documented in the docs.
http://www.postgis.org/documentation/manual-
svn/using_raster.xml.html#RT_Raster_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: [email protected]
> [mailto:[email protected]] 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: [email protected]
> > [mailto:postgis-users- [email protected]] 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
> <[email protected]> wrote:
> >
> >
> > Thanks,
> >
> > Do you see any way to make the file directly readable
> (without having
> > to edit it)?
> >
> >
> > Pierre
> >
> > > -----Original Message-----
> > > From: [email protected]
> > [mailto:postgis-
> > users-
> >
> > > [email protected]] 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
> > > [email protected]
> > >
http://postgis.refractions.net/mailman/listinfo/postgis-
users
> > _______________________________________________
> > postgis-users mailing list
> > [email protected]
> >
http://postgis.refractions.net/mailman/listinfo/postgis-
users
> >
> >
>
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
[email protected]
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
