[postgis-users] st_band with out-db raster data

Bborie Park dustymugs at gmail.com
Fri Nov 1 08:46:37 PDT 2013


Correct. ST_Band creates a new raster comprised of the bands extracted from
the existing raster.

If you're looking looking to convert an out-db into in-db, I think the
following will work...

SELECT (ST_AsBinary(rast, TRUE))::raster

-bborie


On Fri, Nov 1, 2013 at 8:10 AM, Dilley, Andrew-P57500 <
Andrew.Dilley at gdc4s.com> wrote:

> From that thread,
>
> "We need to do away with the entire in-db and out-db notion and just
> return the pixel values."
>
> I guess this is what I mean.  Should st_band be doing this?  (I'm
> admittedly very new to postgis so maybe this a stupid question).
>
> andy
>
> -----Original Message-----
> From: postgis-users-bounces at lists.osgeo.org [mailto:
> postgis-users-bounces at lists.osgeo.org] On Behalf Of Mateusz Loskot
> Sent: Friday, November 01, 2013 10:44 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] st_band with out-db raster data
>
> On 1 November 2013 14:18, Dilley, Andrew-P57500 <Andrew.Dilley at gdc4s.com>
> wrote:
> > When using out-db raster data, st_band appears to return path data for
> > the raster file rather than a raster.  Is that intentional?
>
> You may want to check the "[raster] Paths local to server" thread here
>
> http://lists.osgeo.org/pipermail/postgis-devel/2013-February/023252.html
>
> and related ticket  http://trac.osgeo.org/postgis/ticket/2217
>
> It should clarify the semantic of out-db raster.
>
> Best regards,
> --
> Mateusz  Loskot, http://mateusz.loskot.net_______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131101/9f7a76fe/attachment.html>


More information about the postgis-users mailing list