[Mapserver-users] Mapserver and POSTGIS and RASTER layer

Wed Apr 23 14:52:06 EDT 2003

This is a multi-part message in MIME format.

------=_NextPart_000_0007_01C309B0.4AC19300
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,

I'd like to use mapserver with posgis for manipulate raster data
and I'd like to know if is possible to do this:
- pass a variable to a MAP FILE (in execution time) into a SQL SELECT
- mosaic some blobs resultant of an SQL SELECT

Something like this:=20

 LAYER #Raster
   CONNECTIONTYPE postgis
   NAME "sp_images"
   CONNECTION "user=3Dpostgresql password=3D"" dbname=3Dgisdb =
host=3Dlocalhost"
=3D>>>   DATA " SELECT data from sp_image where sp_image.the_geom && =
EXTEND "
   STATUS DEFAULT
   TYPE RASTER
        OFFSITE 0
  END

" SELECT data from sp_image where sp_image.the_geom && EXTEND "

data is of blob type and the select probably result a number of
blobs registers. I'd like to mosaic this blobs and form an raster layer
on execution time. The EXTEND is a variable passed in execution time
with MapServer extend box request.

Is it possible??=20

Thanks in advance,

Rosangela.
------=_NextPart_000_0007_01C309B0.4AC19300
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1141" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I'd like to use mapserver with posgis =
for=20
manipulate raster data</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>and I'd like to know if is possible to =
do=20
this:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- pass a variable to a MAP FILE (in =
execution time)=20
into a SQL SELECT</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- mosaic some blobs resultant of an SQL =

SELECT</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Something like this: </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;LAYER #Raster<BR>&nbsp; =
&nbsp;CONNECTIONTYPE=20
postgis<BR>&nbsp; &nbsp;NAME "sp_images"<BR>&nbsp;&nbsp;&nbsp;CONNECTION =

"user=3Dpostgresql password=3D"" dbname=3Dgisdb =
host=3Dlocalhost"<BR>=3D&gt;&gt;&gt;&nbsp;=20
&nbsp;DATA " SELECT data from sp_image where sp_image.the_geom =
&amp;&amp; EXTEND=20
"<BR>&nbsp; &nbsp;STATUS DEFAULT<BR>&nbsp; &nbsp;TYPE=20
RASTER<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OFFSITE 0<BR>&nbsp; =

END</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>" SELECT data from sp_image where =
sp_image.the_geom=20
&amp;&amp; EXTEND "</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>data is of blob type and the select =
probably result=20
a number of<BR>blobs registers. I'd like to mosaic this blobs and form =
an raster=20
layer<BR>on execution time. The EXTEND is a variable passed in execution =

time<BR>with MapServer extend box request.<BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Is it possible?? </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Rosangela.</DIV></FONT></BODY></HTML>

------=_NextPart_000_0007_01C309B0.4AC19300--