[Geomoose-users] MySQL

[Jay Kapalczynski]

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/556abbdd/attachment.html