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.
