[Geomoose-users] [Geomoose-developers] MySQL

[Nelson Soto]

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/1b3e3fa2/attachment.html