MySql Spatial Database

[Eijnden, Bart van den (AGI)]

You can only access them using OGR in Mapserver.

See also:

http://www.gdal.org/ogr/drv_mysql.html

A better option would be PostGIS ofcourse. If you have the choice, go for that one.

Best regards,
Bart

-----Oorspronkelijk bericht-----
Van: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU]Namens Murat BEYHAN
Verzonden: woensdag 4 oktober 2006 13:22
Aan: MAPSERVER-USERS at LISTS.UMN.EDU
Onderwerp: [UMN_MAPSERVER-USERS] MySql Spatial Database


Dear Friends;
Is it possible to connect mysql spatial database by using Mapserver 4.8.4
if it is? 

I would like to make a spatial database on MySql and add my data into database.
I have polygon, line and pointdata.
So I have found the followings in MySQL database to create spatial database
table but I dont have any idea how can I insert polygon or line or point data
into the table.
If any idea to do this Please help.

mysql> CREATE TABLE spat (p POINT, g POLYGON, l LINESTRING, geo GEOMETRY );
mysql> INSERT INTO spat (p) VALUES (GeomFromText('POINT(1 2)'));
mysql> select X(p),Y(p) from spat;
regards
Murat
 


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


Disclaimer
************************************************************************
Aan dit bericht kunnen geen rechten worden ontleend. Dit bericht is
uitsluitend bestemd voor de geadresseerde. Als u dit bericht per abuis
hebt ontvangen, wordt u verzocht het te vernietigen en de afzender te 
informeren. Wij adviseren u om bij twijfel over de juistheid of de 
volledigheid van de mail contact met afzender op te nemen.

This message shall not constitute any rights or obligations.
This message is intended solely for the addressee.
If you have received this message in error, please delete it and
notify the sender immediately. When in doubt whether this message
is correct or complete, please contact the sender.
************************************************************************