[Mapserver-users] Classes based on Postgis && function

Tue Feb 18 06:36:05 EST 2003

This is a multi-part message in MIME format.

------=_NextPart_000_0001_01C2D799.EF702EF0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi guys,

Does anyone know if its possible to have a layer with two classes, one
with a simple SQL expression and the other with a SQL statement that
uses a PostGIS spatial function. Something like the following logic:

class 1 = where table1.fieldX = 'x'
class 2 = where table1.fieldX = 'x' and table1.the_geom &&
table2.the_geom and table2.fieldY='Y' 

I can do it in two layers, but is it possible in one layer with two
classes?

Cheers,

Benjamin

------=_NextPart_000_0001_01C2D799.EF702EF0
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Message</TITLE>

<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D609475204-18022003><FONT face=3DArial size=3D2>Hi=20
guys,</FONT></SPAN></DIV>
<DIV><SPAN class=3D609475204-18022003><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D609475204-18022003><FONT face=3DArial size=3D2>Does =
anyone know if=20
its possible to have a layer with two classes, one with a simple SQL=20
expression&nbsp;and the other with a SQL statement that uses a PostGIS =
spatial=20
function. Something like the following logic:</FONT></SPAN></DIV>
<DIV><SPAN class=3D609475204-18022003><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D609475204-18022003><FONT face=3DArial size=3D2>class =
1 =3D where=20
table1.fieldX =3D 'x'</FONT></SPAN></DIV>
<DIV><SPAN class=3D609475204-18022003><FONT face=3DArial size=3D2>class =
2 =3D where=20
table1.fieldX =3D 'x'&nbsp;and table1.the_geom &amp;&amp; =
table2.the_geom and=20
table2.fieldY=3D'Y' </FONT></SPAN></DIV>
<DIV><SPAN class=3D609475204-18022003><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D609475204-18022003><FONT face=3DArial size=3D2>I can =
do it in two=20
layers, but is it possible in one layer with two =
classes?</FONT></SPAN></DIV>
<DIV><SPAN class=3D609475204-18022003><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D609475204-18022003><FONT face=3DArial=20
size=3D2>Cheers,</FONT></SPAN></DIV>
<DIV><SPAN class=3D609475204-18022003><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D609475204-18022003><FONT face=3DArial=20
size=3D2>Benjamin</FONT></SPAN></DIV></BODY></HTML>

------=_NextPart_000_0001_01C2D799.EF702EF0--