[maplab-users] MapLab and MySQL.

[bartvde at xs4all.nl]

Hi Chris, Gilles,

connectiontype MySQL refers to the Mapserver "MyGIS" solution which stores
the geometry in a WKB type of column. Your spatial data should be loaded
then through the MyGIS utilities. See:

http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?MySQL

MySQL also supports (in alpha) native OGC-based geometry types, but
Mapserver (nor Maplab which uses php_mapscript to access data) has support
for this. Also this support is not widely used at all.

If your spatial data is points-only and present in X Y columns you could
use the Virtual Spatial Data option from OGR:

http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?VirtualSpatialData

But anyway, it is a Mapserver question and not really a Maplab question ...

Best regards,
Bart

> Gilles,
>
> This question you are asking is actually specific to
> PHP_Mapscript_42.dll? If php mapscript 42 has the Layer-> Connection
> type MySQL than yes MapLab will be able to render your layers in your
> mapfile to be styled.
>
> http://mapserver.gis.umn.edu/doc42/mapfile-reference.html#layer
>
> In this document it shows that the CONNECTIONTYPES that are available are:
>
> [local|sde|ogr|postgis|oraclespatial|wms]
>
>  From this description I am not sure it suggests that it is MySQL able.
> I think but someone will have to correct me that I think it is possible.
>
> I would ask the MapServer Mailing list.
> http://mapserver.gis.umn.edu/support.html
>
> Chris
>
> Gilles BERETA wrote:
>
>> Hi,
>>
>> MySQL 4.1.3b in beta state implements some OpenGIS specifications.
>> It is possible, for the moment, to use MySQL with MapLab ?
>> Will it be possible, in the futur, to use MySQL with MapLab ?
>>
>> Best regards.
>>
>>
>> Gilles B.
>> _______________________________________________
>> Maplab-users mailing list
>> Maplab-users at lists.maptools.org
>> http://lists.maptools.org/mailman/listinfo/maplab-users
>>
>
>
> --
> ---------------------
> Christopher R. Thorne
> GIS Product Specialist,
> DM Solutions Group Inc.
>
> http://www.dmsolutions.ca
> Email: cthorne at dmsolutions.ca
> Phone: (613) 565-5056 ext.22
> Fax :  (613) 565-0925
>
>
> _______________________________________________
> Maplab-users mailing list
> Maplab-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/maplab-users
>