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- > > [EMAIL PROTECTED] Murat BEYHAN Verzonden: woensdag 4 > > oktober 2006 13:22 Aan: [email protected] 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.
