Dear Frank, Thank you very much for your advice. Now I store various kind of data in mysql database than I connect to database and read data and draw layers on the map. It's really fantastic. Thank you to mapserver,too. Regards... Murat
On Wed, 4 Oct 2006 10:49:10 -0400, Frank Warmerdam wrote > 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? > > Murat, > > In the above commandline you show cities.shb as the input. This should > be cities.shp, perhaps this was just a typo if things worked? Generally > speaking OGR depends on the .shp, .shx and .dbf file. The .sbn and .sbx > spatial indexes are ignored. > > > And How can I connect and read data by using ogr connection from map file. > > You would use: > > CONNECTIONTYPE OGR > CONNECTION "MySQL:testogr,user=root,password=passmysql" > DATA "cities" > > for your layer. > > > 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. > > Note that a true spatial table in MySQL is handled very differently from > a table with lat and lon columns which is usually handled via ODBC > and OVF. > > Best regards, > -- > ---------------------------------------+-------------------------------------- > I set the clouds in motion - turn up | Frank Warmerdam, [EMAIL PROTECTED] > light and sound - activate the windows | http://pobox.com/~warmerdam > and watch the world go round - Rush | President OSGeo, http://osgeo.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.
