[Geomoose-users] [Geomoose-developers] MySQL

[Jay Kapalczynski]

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.100,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/bea7b83e/attachment.html