[Mapserver-users] Mapserver and POSTGIS and RASTER layer
Rosangela Silva
rosangela.silva at zenitpolar.com.br
Wed Apr 23 11:52:06 PDT 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> </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> </DIV>
<DIV><FONT face=3DArial size=3D2>Something like this: </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2> LAYER #Raster<BR> =
CONNECTIONTYPE=20
postgis<BR> NAME "sp_images"<BR> CONNECTION =
"user=3Dpostgresql password=3D"" dbname=3Dgisdb =
host=3Dlocalhost"<BR>=3D>>> =20
DATA " SELECT data from sp_image where sp_image.the_geom =
&& EXTEND=20
"<BR> STATUS DEFAULT<BR> TYPE=20
RASTER<BR> OFFSITE 0<BR> =
END</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>" SELECT data from sp_image where =
sp_image.the_geom=20
&& EXTEND "</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </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> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Rosangela.</DIV></FONT></BODY></HTML>
------=_NextPart_000_0007_01C309B0.4AC19300--
More information about the MapServer-users
mailing list