<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content=text/html;charset=ISO-8859-1>
<META content="MSHTML 6.00.6000.16608" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi Oliver,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>We managed to get the geostats demo working with
the PostGres database. Basically there are two options:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>- Modify the DBF file with the result from the
query and let the shapefile be shown using the information of the
DBF</FONT></DIV>
<DIV><FONT face=Arial size=2>- Use the Postgres information obtained without
using the DBF file.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The solution we did includes modifications in the
Datasource formular to show one more option. We are planing to develop a HowTo
to publish it in the Wiki of Cartoweb within the next
days.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2>Albert</FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=oliver.christen@camptocamp.com
href="mailto:oliver.christen@camptocamp.com">Oliver Christen</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=casanovas@k2sistemas.com.br
href="mailto:casanovas@k2sistemas.com.br">Albert Casanovas</A> ; <A
title=cartoweb-users@lists.maptools.org
href="mailto:cartoweb-users@lists.maptools.org">cartoweb-users@lists.maptools.org</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, June 02, 2008 6:27 AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Cartoweb-users]
Geostatistics with Postgres</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>Hi</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>im by far not a specialist with the geostats plugin so
consider my answer here as indicative only</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>using a postgis layer as data source may effectively make
things easier, though, if you want to use multiple table in your database, you
will need to use a complex sql query in the DATA parameter.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>if SELECT .. WHERE id=x is the query in the DATA parameter,
you need to make a new plugin to modify the DATA value.</FONT></DIV>
<DIV><FONT size=2>This can be done either by using the objects provided by the
mapOverlay plugin or by using mapscript directly.</FONT></DIV>
<DIV><FONT size=2>Usage of mapOverlay has been explained already several time
in the mailing list and there should be several example
available.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>regards</FONT></DIV>
<DIV><FONT size=2>Oliver</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=casanovas@k2sistemas.com.br
href="mailto:casanovas@k2sistemas.com.br">Albert Casanovas</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=damien.corpataux@camptocamp.com
href="mailto:damien.corpataux@camptocamp.com">Damien Corpataux</A> ; <A
title=cartoweb-users@lists.maptools.org
href="mailto:cartoweb-users@lists.maptools.org">cartoweb-users@lists.maptools.org</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, May 28, 2008 4:25
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Cartoweb-users]
Geostatistics with Postgres</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Hi ,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Two questions:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>1. Do you think that to adapt the plugin
geostat to get the DATA from a SQL connection instead of a DBF file is
only necessary to edit the map file?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>2. How can pass a variable from the
ServerGeostat.php to the Map file for a SELECT .. WHERE id=x ?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks a lot,</FONT></DIV>
<DIV><FONT face=Arial size=2>Albert</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=damien.corpataux@camptocamp.com
href="mailto:damien.corpataux@camptocamp.com">Damien Corpataux</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=casanovas@k2sistemas.com.br
href="mailto:casanovas@k2sistemas.com.br">Albert Casanovas</A> ; <A
title=cartoweb-users@lists.maptools.org
href="mailto:cartoweb-users@lists.maptools.org >> carto web">cartoweb-users@lists.maptools.org
>> carto web</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, May 28, 2008 5:44
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Cartoweb-users]
Geostatistics with Postgres</DIV>
<DIV><BR></DIV>Hi Albert,<BR><BR>So far, the whichShapes() method belongs
to the LayerObj (<A class=moz-txt-link-freetext
href="http://mapserver.gis.umn.edu/docs/reference/phpmapscript-class/classes/layerobj">http://mapserver.gis.umn.edu/docs/reference/phpmapscript-class/classes/layerobj</A>).<BR><BR>Regards,<BR>Damien<BR><BR><BR>Albert
Casanovas wrote:
<BLOCKQUOTE cite=mid:006201c8c030$60003a50$1d04000a@k2sistemas.com.br
type="cite">
<META content="MSHTML 6.00.6000.16608" name=GENERATOR>
<STYLE></STYLE>
<DIV><FONT face=Arial size=2>Thanks Oliver,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I am working in the adaptation of
the geostat plugin to get the information from through SQL queries.
According to what I have analyzed, the modifications needed to be
done are:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>- Configuration file geostat.ini with the
information of the database for the connection.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>- Parsing of the geostat.ini file in the
method getConfLayers() of the server/ServerGeostat.php
file</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>- Distribution for the requested layer and
attribute in the method getDistribFromSpatialData($layer, $attrib) of
the server/ServerGeostat.php file</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>At the moment I am in this third step and I
would like to ask about the whichShapes method in this line</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial
size=2>$msLayer->whichShapes($rect);</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I cannot find where is this is any method
implemented in any library of the mapObject.</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Do you have any suggestion about doing this
implementation?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Best Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2>Albert</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(0,0,0) 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal">-----
Original Message ----- </DIV>
<DIV
style="BACKGROUND: rgb(228,228,228) 0% 50%; FONT: 10pt arial; font-size-adjust: none; font-stretch: normal; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial"><B>From:</B>
<A title=oliver.christen@camptocamp.com
href="mailto:oliver.christen@camptocamp.com"
moz-do-not-send="true">Oliver Christen</A> </DIV>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal"><B>To:</B>
<A title=casanovas@k2sistemas.com.br
href="mailto:casanovas@k2sistemas.com.br"
moz-do-not-send="true">Albert Casanovas</A> ; <A
title=cartoweb-users@lists.maptools.org
href="mailto:cartoweb-users@lists.maptools.org"
moz-do-not-send="true">cartoweb-users@lists.maptools.org</A> </DIV>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal"><B>Sent:</B>
Friday, May 23, 2008 5:45 AM</DIV>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal"><B>Subject:</B>
Re: [Cartoweb-users] Geostatistics with Postgres</DIV>
<DIV><BR></DIV>
<DIV>
<DIV><FONT size=2>Hi</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>im sorry but this is not implemented
yet.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>regards</FONT></DIV>
<DIV><FONT size=2>Oliver</FONT></DIV></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(0,0,0) 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal">-----
Original Message ----- </DIV>
<DIV
style="BACKGROUND: rgb(228,228,228) 0% 50%; FONT: 10pt arial; font-size-adjust: none; font-stretch: normal; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial"><B>From:</B>
<A title=casanovas@k2sistemas.com.br
href="mailto:casanovas@k2sistemas.com.br"
moz-do-not-send="true">Albert Casanovas</A> </DIV>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal"><B>To:</B>
<A title=cartoweb-users@lists.maptools.org
href="mailto:cartoweb-users@lists.maptools.org"
moz-do-not-send="true">cartoweb-users@lists.maptools.org</A> </DIV>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal"><B>Sent:</B>
Tuesday, May 20, 2008 6:14 PM</DIV>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal"><B>Subject:</B>
[Cartoweb-users] Geostatistics with Postgres</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I would to know if there is posible to
get the values from a database instead a .dbf file in the
demoGeostat demo like is doing in the example:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=a><FONT color=#008000><A
href="http://www.cartoweb.org/demos/demoGeostat.php"
moz-do-not-send="true">www.cartoweb.org/demos/<B>demoGeostat</B>.php</A></FONT></SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Which modifications should I do to the
pluguin in order to allow it to take the values
from a database?</FONT></DIV>
<DIV><FONT face=Arial size=2>Can I have the map in a shapefile and
its information in the database?</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Thanks a lot,</FONT></DIV>
<DIV><FONT face=Arial size=2>Albert Casanovas</FONT> </DIV>
<P></P>
<HR>
_______________________________________________<BR>Cartoweb-users
mailing list<BR><A class=moz-txt-link-abbreviated
href="mailto:Cartoweb-users@lists.maptools.org">Cartoweb-users@lists.maptools.org</A><BR><A
class=moz-txt-link-freetext
href="http://lists.maptools.org/mailman/listinfo/cartoweb-users">http://lists.maptools.org/mailman/listinfo/cartoweb-users</A><BR></BLOCKQUOTE></BLOCKQUOTE><PRE wrap=""><HR width="90%" SIZE=4>
_______________________________________________
Cartoweb-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:Cartoweb-users@lists.maptools.org">Cartoweb-users@lists.maptools.org</A>
<A class=moz-txt-link-freetext href="http://lists.maptools.org/mailman/listinfo/cartoweb-users">http://lists.maptools.org/mailman/listinfo/cartoweb-users</A>
</PRE></BLOCKQUOTE><BR><BR>
<DIV class=moz-signature>-- <BR>
<STYLE>
<!--
.signature {
font-family:verdana,helvetica,sans-serif;
font-size:0.8em;
line-height: 1.25em;
color: #9999BB;
width: 27em;
}
.signature div {
padding: 0.22em;
margin-bottom: 0.5em;
margin-top: 0.5em;
border-bottom: 1px dotted lightgray;
background-color: #FCFCFF;
}
.signature .attention {
background-color: #FFFAFA;
color: #FFBBBB;
font-size: 0.8em;
font-weight: bold;
}
.header {
}
-->
</STYLE>
<DIV class=signature>
<DIV><SPAN style="FONT-WEIGHT: bold">Camptocamp SA</SPAN><BR>Damien
Corpataux<BR>PSE A<BR>CH-1015 Lausanne<BR></DIV>
<DIV>+41 21 619 10 22 <SPAN class=header>(Direct)</SPAN><BR>+41 21 619 10
10 <SPAN class=header>(Centrale)</SPAN><BR>+41 21 619 10 00 <SPAN
class=header>(Fax)</SPAN><BR></DIV>
<DIV style="COLOR: rgb(102,204,102)"><SPAN
style="FONT-SIZE: 24pt; FONT-FAMILY: Webdings; POSITION: relative; TOP: -3px">P</SPAN>
<SPAN>Please consider the environment <BR>Do you really need to print this
email?</SPAN> </DIV></DIV></DIV></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>Cartoweb-users
mailing
list<BR>Cartoweb-users@lists.maptools.org<BR>http://lists.maptools.org/mailman/listinfo/cartoweb-users<BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>