I think you need to have a look at classitem and class definitions in the documentation. With PostGIS you would bring the attribute back with your points, make the attribute the classitem and match it in each of three classes, one with red colour, one with blue colour and one with green colour.

I anticipate that OGR can do the same thing?

cheers

Ben




On 01/06/2008, at 12:00 AM, [EMAIL PROTECTED] wrote:

From: fastturtle <[EMAIL PROTECTED]>
Date: 31 May 2008 11:33:43 AM
To: [email protected]
Subject: [MAPSERVER-USERS] Using OGR to plot x,y data from MySQL with Attribute Data



Hi!

I am new user to MapServer and I think I have a simple task.
I have a MySQL table called data1 with x,y (Lat, Long) data stored in two fields and attribute data stored in another field called SPECIFIC. The SPECIFIC field has three values that can be an option for a point (bad,
good, excellent).

I have successfully used OGR to plot my points using the following code,
however I cannot find an example of how to map the points based on the
attribute in the SPECIFIC fields. I really need to color
code the points by the attibute field.  For example, I would color all
points with a bad rating as red, good as blue and excellent as green. How
can I alter my code in the map file to accomplish this task?

<OGRVRTDataSource>
   <OGRVRTLayer name="data">

< SrcDataSource >MYSQL:test,user=user,password=password,port=3306,tables=data1</ SrcDataSource>
       <SrcSQL>SELECT * FROM data1</SrcSQL>
       <GeometryType>wkbPoint</GeometryType>
       <GeometryField encoding="PointFromColumns" x="Long" y="Lat"/>
   </OGRVRTLayer>
</OGRVRTDataSource>

#
 # Start of layer definitions
 #

 LAYER
   NAME "MyAqui"
   STATUS DEFAULT
   TYPE POINT
   CONNECTIONTYPE OGR
   CONNECTION "aquidata.ovf"
   DATA "data"
   CLASS
      NAME "MyClass"
          STYLE
              SYMBOL 'circle'
              SIZE 15
              COLOR 0 255 0
          END
   END
END


Thanks so much for any help in advance.

--

Ben Madin
REMOTE INFORMATION

t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome   WA   6725

[EMAIL PROTECTED]



                                                        Out here, it pays to 
know...


_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to