<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<STYLE type=text/css>DIV {
MARGIN: 0px
}
</STYLE>
<META content="MSHTML 6.00.2900.3243" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><SPAN class=924382811-15042008><FONT
color=#0000ff>Hans Castorp wrote:</FONT></SPAN></SPAN></DIV>
<DIV dir=ltr align=left><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><SPAN class=924382811-15042008><FONT
color=#0000ff></FONT></SPAN></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><SPAN class=924382811-15042008><FONT
color=#0000ff> > </FONT></SPAN></SPAN><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><SPAN
class=924382811-15042008> </SPAN>I have some sql queries over a Postgis
table (points). How can I draw the results of these queries over the
map?<O:P></O:P></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=924382811-15042008> </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=924382811-15042008>Have a
look at for example these documents first:</SPAN></FONT><FONT face=Arial
color=#0000ff size=2><SPAN class=924382811-15042008></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=924382811-15042008><A
href="http://mapserver.gis.umn.edu/docs/reference/vector_data/postgis">http://mapserver.gis.umn.edu/docs/reference/vector_data/postgis</A> </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=924382811-15042008><A
href="http://postgis.refractions.net/docs/ch04.html#id2624379">http://postgis.refractions.net/docs/ch04.html#id2624379</A></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=924382811-15042008></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=924382811-15042008>Depending on your case you can</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=924382811-15042008>-
insert your query directly inside the DATA sentence</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=924382811-15042008>-
create a PostGIS view with your query</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=924382811-15042008>- in
you want to get something more dynamic, use run-time substitution inside
DATA</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=924382811-15042008><A
href="http://mapserver.gis.umn.edu/docs/howto/runsub">http://mapserver.gis.umn.edu/docs/howto/runsub</A> gives
some hints about run-time substitution.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=924382811-15042008></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=924382811-15042008>-Jukka
Rahkonen-</SPAN></FONT></DIV></BODY></HTML>