[Mapserver-users] join/thematic map with rdbms

Bertrand Pau bertrand.pau at bva.fr
Fri Apr 16 05:18:59 EDT 2004


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C42393.D996F450
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

hi all,
=20
i've got few questions :
- i need to shade polygons in a shapefile with values stored in rdbms
(mysql, sqlserver or access). I tried to make joins but it seems not =
working
correctly. Is it possible to do that? how? my shapefile is very big =
(140mo)
so i can't copy it in a tmp file to change or calculate a new field =
with the
external values... have you got another ideas ?=20
- is it possible to set the "join" properties (from, to, table)  with
mapscript ?=20
- about the mysql connection: is it really working ?=20
=20
i'm using mapserver 4 with mapscript and php 4.3.2 on a windows 2000
platform
=20
many thanks for your help
=20
=20
=20
______________________________

Bertrand PAU

 <mailto:bertrand.pau at geosignal.fr> bertrand.pau at geosignal.fr

GEOSIGNAL
groupe BVA

191 av du g=E9n=E9ral Leclerc
BP59 - 78222 Viroflay Cedex
tel : + 33 1 30 84 88 00
fax : + 33 1 30 84 88 01

 <http://www.geosignal.fr/> www.geosignal.fr
______________________________=20

=20

------_=_NextPart_001_01C42393.D996F450
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=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">


<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D300510409-16042004>hi=20
all,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D300510409-16042004></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D300510409-16042004>i've =
got&nbsp;few=20
questions :</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D300510409-16042004>- i =
need to shade=20
polygons in a shapefile with values&nbsp;stored in rdbms (mysql, =
sqlserver or=20
access). I tried to make joins but it seems not working correctly. Is =
it=20
possible&nbsp;to do that? how? my shapefile is very big (140mo) so i =
can't copy=20
it in a tmp file to change or calculate a new field&nbsp;with the =
external=20
values... </SPAN></FONT><FONT face=3DArial size=3D2><SPAN=20
class=3D300510409-16042004>have you got another ideas =
?&nbsp;</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D300510409-16042004><SPAN =

class=3D300510409-16042004>-&nbsp;is it possible to set the "join" =
properties=20
(from, to, table)&nbsp; with mapscript&nbsp;? =
</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D300510409-16042004>- =
about=20
the&nbsp;mysql connection: is&nbsp;it really working ? =
</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D300510409-16042004></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D300510409-16042004>i'm =
using mapserver=20
4 with mapscript and php 4.3.2 on a windows 2000 =
platform</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D300510409-16042004></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D300510409-16042004>many =
thanks for your=20
help</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D300510409-16042004></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D300510409-16042004></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D300510409-16042004></SPAN></FONT>&nbsp;</DIV><FONT =
face=3D"Courier New"=20
size=3D2><FONT size=3D2><FONT face=3DVerdana>
<P dir=3Dltr align=3Dcenter><FONT face=3DVerdana><FONT=20
size=3D2>______________________________<BR><BR><STRONG>Bertrand=20
PAU</STRONG><BR><BR></FONT><A =
href=3D"mailto:bertrand.pau at geosignal.fr"><FONT=20
color=3D#000000 =
size=3D2>bertrand.pau at geosignal.fr</FONT></A><BR><BR><FONT=20
size=3D2><STRONG>GEOSIGNAL</STRONG><BR>groupe =
BVA<BR></FONT></FONT><FONT=20
face=3DVerdana><BR><FONT size=3D2>191 av du g=E9n=E9ral Leclerc<BR>BP59 =
- 78222 Viroflay=20
Cedex</FONT></FONT><FONT face=3DVerdana><BR><FONT size=3D2>tel : + 33 1 =
30 84 88=20
00<BR></FONT></FONT><FONT face=3DVerdana><FONT size=3D2>fax : + 33 1 30 =
84 88=20
01<BR><BR></FONT><A href=3D"http://www.geosignal.fr/"><FONT =
color=3D#000000=20
size=3D2>www.geosignal.fr</FONT></A><BR><FONT=20
size=3D2>______________________________ =
</FONT></FONT></P></FONT></FONT><FONT=20
size=3D2></FONT></FONT>
<DIV>&nbsp;</DIV></BODY></HTML>

------_=_NextPart_001_01C42393.D996F450--



More information about the mapserver-users mailing list