Hi Giuseppe. About the EXPRESSION in CLASS element problem I just try several alternatives. I give you the ones that actually works ;)<br><br><ul><li>EXPRESSION (([ID_specie_att] = 1) or ([ID_specie_att] = 2))</li></ul>you can make more complex combinations of conditions using logical connectors (and, or, not) and parenthesis
<br><br><ul><li>EXPRESSION ([ID_specie_att] in "2,3,5,8")</li></ul>in this case you must enumerate the values of ID_specie_att that must be included in the CLASS. If the ID_specie_att is numeric then this is the way to use this expression... however if ID_specie_att is a string you must use EXPRESSION ('[ID_specie_att]' in "String 1,another string").
<br><br><ul><li>EXPRESSION (([ID_specie_att] > 20) and ([ID_specie_att] < 80))</li></ul>if you have a range of posible values and want to make it simpler you can use something like that. Actually this is not much different than the first example but I put it here anyway.
<br><br>About the problem with the overlapped points you can force the label to be displayed in map using the FORCE TRUE expression in LABEL element. However the two labels will overlap and maybe you'll not be able to read anything. I have made some tests but could not be able to get the labels not overlaped. Sorry about that.
<br><br>Rodrigo.<br><br><div><span class="gmail_quote">On 6/14/07, <b class="gmail_sendername">Giuseppe Molinario</b> <<a href="mailto:g.molinario@gmail.com">g.molinario@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Erensto thanks for the reply, <br><br>I am using postgresql <a href="http://8.2.3.1" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">8.2.3.1</a>, and Postgis <a href="http://1.2.1.1" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
1.2.1.1</a><br><br>whereas my app was working fine before, i needed to try and see how mapserver would deal with two "identical" points in the database.... well it pretty much stops working when that layer is on now.
<br><br>about the classes. <br><br>i simply need a postgis layer to have two classes, these need to contain more that one expression value - not dynamically. example <br><br>layer x<br><br>class 1<br>EXPRESSION ([ID_specie_att]=2) and also EXPRESSION ([ID_specie_att]=3) and EXPRESSION ([ID_specie_att]=4)
<br><br>class 2 <br>EXPRESSION ([ID_specie_att]=5)EXPRESSION ([ID_specie_att]=6)EXPRESSION ([ID_specie_att]=7)<br><br>i cant seem to get my head around a syntax to tell the EXPRESSION that it is actually a list of values.
<br><br><br>Thanks for the help, <br><span class="sg"><br>Giuseppe</span><div><span class="e" id="q_1132b537a2fbe6ca_2"><br><br><div><span class="gmail_quote">On 6/14/07, <b class="gmail_sendername">Ernesto Vega</b> <
<a href="mailto:ernesvega@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">ernesvega@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Giuseppe :<br><br>I´ve never been into the situation of having 2 points overlapped.<br><br>
For a better idea is useful to send which versions of postgresql and
<br>postgis your are using.<br><br>For the class question:<br><br>Are you planning to dynamically change your parameter ?<br><br>If so, you must read the chapter dedicated on how to use parameters on<br>mapserver site, otherwise you may have no choice because of what you
<br>want to alter within a class<br><br>hope this helps.<br><br>Ernesto Vega<br><br>On 6/14/07, Giuseppe Molinario <<a href="mailto:g.molinario@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
g.molinario@gmail.com</a>> wrote:<br>> Hi everyone,<br>>
<br>> I am working with a postgis point table that needs to be displayed in a<br>> mapserver application (pmapper).<br>><br>> my problems:<br>><br>> 1. what happens when two points are in the same exact location? ( the rows
<br>> in my table can sometimes have the identical lat long coordinates and<br>> therefore geometry column.)<br>><br>> how can i set the mapfile to show me both points and labels? is this ever<br>> possible? I realize this is a bit of werid question, but i am not asking
<br>> about topology...just nuts and bolt postgis/mapfile....<br>> the query tool does not respond anymore. seems like having two identical<br>> points prevents the query tool from working<br>> this all worked prior to me having "overlapping" points2. different
<br>> question. Layer>class in mapfile: I have an EXPRESSION object that goes like<br>> this EXPRESSION ([ID_specie_att]=2) now how do i get the SAME class to<br>> display both points that have value 2,3,4,5,6? Do i really have to make 5
<br>> different classes? I would rather not because i don't want them in my<br>> legend.<br>><br>><br>> thanks very much for any help.<br>><br>> Giuseppe<br></blockquote></div><br>
</span></div></blockquote></div><br>