MySql Spatial Database

[Murat BEYHAN]

Dear Bart,
thank you for your advice.
I have tried the followings

ogr2ogr -f MySQL MySQL:testogr,user=root,password=passmysql cities.shb -nln
iller -update -overwrite -lco GEOMETRY_NAME=SHAPE2


This is creates 3 tables in mysql tables in testogr database.
the names of the tables are 
geometry_columns, 
cities, 
spatial_ref_sys

then I have doubt I have cities shape files the tail of the files are
shp shx sbn sbx these are esri files.  I don't know Which one should be use
for this?
And How can I connect and read data by using ogr connection from map file.
I have an experiment if the data stored regularly as lat and lon in the table
I can read those for draw point. But My problem if I have polygone or line
data in mySql How can I read those data to create a layer on my map file by
using OGR. So I'm trying to use spatial database.

This is I think possible to do with Mapserver but There is not enough
application to do this on the internet.
Thank you for your help
I appreciated any comment form all...
Regards
Murat


On Wed, 4 Oct 2006 13:26:03 +0200, Eijnden, Bart van den (AGI) wrote
> 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.
> ************************************************************************
> 
> -- 
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.


--
Open WebMail Project (http://openwebmail.org)


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