[Geomoose-users] [Geomoose-developers] MySQL

[Nelson Soto]

It is placed in another file separate from the map file. Just make a new
text document and rename it to aqidata.ovf and put that information,
called xml, into the file.

 

________________________________

From: Jay Kapalczynski [mailto:jkapalczynski at ci.maple-grove.mn.us] 
Sent: Friday, November 07, 2008 11:39 AM
To: Nelson Soto; geomoose-developers at lists.sourceforge.net;
geomoose-users at lists.sourceforge.net
Subject: RE: [Geomoose-developers] [Geomoose-users] MySQL

 

Missed that...going to try that....thought it was just code that was
placed in another file...

 

From: Nelson Soto [mailto:NSoto at plotplans.com] 
Sent: Friday, November 07, 2008 10:08 AM
To: Jay Kapalczynski; geomoose-developers at lists.sourceforge.net;
geomoose-users at lists.sourceforge.net
Subject: RE: [Geomoose-developers] [Geomoose-users] MySQL

 

The ogrvrt code is supposed to go in the ovf file you are told to make
here: http://mapserver.gis.umn.edu/docs/howto/ogrmysql/?searchterm=ovf

 

It technically doesn't matter where you save from what I gather; Just
point to wherever you put it in your map file. So, probably in the same
folder as your map file if you want to try to be consistent. It's really
up to you..

 

________________________________

From: Jay Kapalczynski [mailto:jkapalczynski at ci.maple-grove.mn.us] 
Sent: Friday, November 07, 2008 10:48 AM
To: 'geomoose-developers at lists.sourceforge.net';
'geomoose-users at lists.sourceforge.net'
Subject: Re: [Geomoose-developers] [Geomoose-users] MySQL

 

If I am doing something like this where does the  OGRVRTDataSource  code
have to be?

 

 

 

 

<OGRVRTDataSource>
    <OGRVRTLayer name="aqidata">
 
<SrcDataSource>MYSQL:aqiTest,user=uuuuu,password=ppppp,host=192.170.1.10
0,port=3306,tables=testdata</SrcDataSource> 
        <SrcSQL>SELECT areaID, x, y, sampleValue FROM testdata</SrcSQL> 
        <GeometryType>wkbPoint</GeometryType>
        <GeometryField encoding="PointFromColumns" x="x" y="y"/> 
    </OGRVRTLayer>
</OGRVRTDataSource>

 

 

 

 

LAYER

    NAME "MyAqi"

    STATUS DEFAULT

    TYPE POINT

    CONNECTIONTYPE OGR  

    CONNECTION "aqidata.ovf"

    DATA "aqidata"

    CLASS 

       NAME "MyClass"

           STYLE

               SYMBOL 'circle'

               SIZE 15

               COLOR 0 255 0

           END

    END

END

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20081107/b4c12aab/attachment.html