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

[Michael Schulz]

Hi Daniel,

i made an app, that does the same thing. You can only do it with mapscript if
you don't want to skip your database.
What is your common field? I think the problem with shp-files is, the only
unique field is the shape-index. I added a field in the mysql-table with the
corresponding shape-index values. This means you have to draw the points from
your shapefile one after the other and before you draw one point get its
shape-index and therewith query your mysql-table, set the labeltext to the
result of your query and draw. Well, i think it may not be really performant,
but since joins between shapefiles and mysql-tables are not possible...

HTH, Michael


Geo-IT-GmbH schrieb:

> Hi list,
>
> I have a point shapefile (weather stations) and a Mysql-database with lots
> of attributes for every point (weather-data, updated every 30 minutes).
> Shapefile and database have a common field.
> I want to label the points with attributes from the Mysql-DB.
>
> Can somebody give me a hint, how this can be done ?
>
> Thanks in advance,
>
> Daniel
>
> ***************************************************
> Geo-IT GmbH   -   Geoinformatik, IT-Services
> Guggenberg 3, D-82380 Peissenberg
> Tel: 08803-498372, Fax: 08803-498373
> eMail: info at geo-it.com  -  Homepage: http://www.geo-it.com
> ***************************************************
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users

--
-----------------------------------------------------------
Michael Schulz                                in medias res
Dipl.-Geologe                              Gesellschaft für
                                Informationstechnologie mbH
                             Sautierstr. 38, 79104 Freiburg
                                     0761 55695-95 (Fax 96)
mschulz at webgis.de                             www.webgis.de