MySql Spatial Database

[Murat BEYHAN]

I was made a mistake at the previous e mail,sorry. 
the command like this


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



On Wed, 4 Oct 2006 17:03:17 +0300, Murat BEYHAN wrote
> 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.


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


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