[Mapserver-users] How to label points with attributes from Mysql-DB

[James Jefferson]

I wrote a program called mysql2shp that lets you do a MySQL query and generate 
a shapefile. I actually am using it for plotting weather with mapserver, too.

Here is an example:

mysql2shp -hlocalhost -uUSERNAME -pPASSWORD -dDATABASE /tmp/wind "SELECT 
lastposition.longitude,lastposition.latitude,0,lastweather.wind_speed AS 
wspeed,lastweather.wind_direction AS wdir,lastweather.source FROM 
lastweather,lastposition WHERE lastweather.wind_speed != '\n' AND 
lastweather.source=lastposition.source"

It can be downloaded from:

http://sourceforge.net/projects/aprsworld/

-Jim