AW: [Mapserver-users] How to label points with attributes from My sql-DB

[Geo-IT-GmbH]

Hi Michael,

thanks for Your answer.
My shapefile still has an associated dbf-file, so the keyfield is taken from
the dbf.
I have at least 1000 points to be labeled, so the performance will be a
problem.
It would be great, if one of the next releases will extend Mapservers MySQL
capabilities as mentioned here:

http://mapserver.gis.umn.edu/data2/wilma/mapserver-users/0301/msg00547.html

Meanwhile I will try to hold the spatial data and the keyfield in a
PostGis-DB and to create an additional field, which is filled from the
MySQL-DB dynamically, but it also will be time-consuming.

Greetings,
Daniel

> -----Ursprüngliche Nachricht-----
> Von:	Michael Schulz [SMTP:mschulz at webgis.de]
> Gesendet am:	Freitag, 14. Februar 2003 10:32
> An:	Geo-IT-GmbH
> Cc:	'mapserver-users at lists.gis.umn.edu'
> Betreff:	Re: [Mapserver-users] How to label points with attributes
> from Mysql-DB
> 
> 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
> 
>