<DIV>Hi everybody,</DIV>
<DIV> </DIV>
<DIV>this issue is very intreresting for me, beacause I need to create thematic maps based on queries issued to a database, so let's say that my thematic map should be based on views (which in the end can become temporary tables if needed..)</DIV>
<DIV> </DIV>
<DIV>The only thing is my database engine is MySQL... </DIV>
<DIV> </DIV>
<DIV>So my question is: Is there a similar way to connect to a MySQL table so that I can use a field of this table as a classitem for the layer?</DIV>
<DIV> </DIV>
<DIV>Thanks in advance for your support..</DIV>
<DIV> </DIV>
<DIV>JP<BR><BR><B><I>Bart van den Eijnden <bartvde@XS4ALL.NL></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Hi Emil,<BR><BR>the problem with the OGR shapefile connector is (or was) that it does not<BR>use the spatial index (qix) files, so it isn't very fast ...<BR><BR>Question for Frank:<BR>Or did this change as well with the current version :) ? I know you were<BR>planning on doing this ...<BR><BR>Best regards,<BR>Bart<BR><BR>On Tue, 16 Nov 2004 08:21:20 +0100, Emil Zegers<BR><EZS@SYNCERA-ITSOLUTIONS.NL>wrote:<BR><BR>> Hello Michael,<BR>><BR>> I have a question for you about this approach: when using this kind of<BR>> join were you able to classify data based on the joined attributes and<BR>> display this in the map image?<BR>><BR>> I'm asking this because with normal join operation it is not possible to<BR>> create thematic maps based on the joined attributes.<BR>><BR>> If classifcation works based on this approach the enhancement request I<BR>> put in
bugzilla (http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=674)<BR>> can be closed.<BR>><BR>> I would be very happy if classifying on joined attributes works this way<BR>> (had no time to test this approach yet).<BR>><BR>> Regards,<BR>><BR>> Emil Zegers<BR>><BR>><BR>> Hi Frank,<BR>><BR>> thanks for your answer. It is working perfectly now.<BR>><BR>> For the moment it is only one table i want to join to the geometry of<BR>> the shp-file, so at first<BR>> sight performance is good, but i will play with the indexes a little.<BR>><BR>> For all who have to use a similar approach here's a mapfile snipplet:<BR>><BR>> LAYER<BR>> ...<BR>> CONNECTIONTYPE OGR<BR>> CONNECTION "c:\mstest\data\fnpf.shp" # shapefile holding only<BR>> geometry and PID in .dbf<BR>> DATA "SELECT * FROM fnpf LEFT JOIN 'ODBC:fnp'.fnp ON<BR>> fnpf.PID=fnp.PID"<BR>> # join to systemDSN fnp (here msaccess-db "fnp.mdb" with table<BR>>
fnp) on attribute PID,<BR>> # now all fields of the db are also accessible for mapserver, e.g.<BR>> "AZJAHR"<BR>> LABELITEM "AZJAHR"<BR>> ...<BR>> END<BR>><BR>> Thanks, Michael<BR>><BR>><BR><BR><BR><BR>--<BR>Using Opera's revolutionary e-mail client: http://www.opera.com/m2/<BR></BLOCKQUOTE><p>
<hr size=1> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="http://uk.rd.yahoo.com/mail/taglines/default/messenger/*http://uk.messenger.yahoo.com"><strong><font face="Arial, Helvetica, sans-serif">ALL-NEW
Yahoo! Messenger</font></strong></a><font face="Arial, Helvetica, sans-serif"><strong>
- all new features - even more fun!</strong></font><strong><font color="#FF9900">
</font></strong></font>