Dear Sigfrido, Thank you for your help, I corrected the script and it works but when I open it with google-earth points doesn't seem on the map I sent snapshot of the google-earth.I think problem is latitude and longitude could not read by the google-earth. So How can I fix it...
Regards. ogr2ogr -f KML sisint.kml MySQL:'afetler,host=localhost,user=root,password=mysql_123,port=3306,tables=sisint' -sql "SELECT koy, longitude, latitude , sisint from sisint" koy means village name. sisint menans seismic intensity value of the village Murat On Tue, 2011-05-03 at 17:33 +0200, Luca Sigfrido Percich wrote: > Hi Murat, > > Il giorno mar, 03/05/2011 alle 16.57 +0300, Murat Beyhan ha scritto: > > ogr2ogr -f KML simgmt.kml simgmt.shp -dsco NameField=RegionName > > this can create a file but strangely data collected at one point. > > Probably it is a Spatial Reference System related problem: you should > specify the source shapefile SRS. Have a look at the KML file and see if > the points have different coordinates, and see what SRS has been > declared for it. Have a look at the -a_srs, -t_srs and -s_srs options of > ogr2ogr. > > > > ogr2ogr -f KML sisint.kml MySQL :'host=localhost user=root > > password=mysql_pswd port=3306 dbname=afetler tables=sisint' -sql "SELECT > > latitude,longitude,sisint from sisint" > > Try with no space between MySQL and :, and specifying the database name > before any other option: > > ogr2ogr -f KML sisint.kml > MySQL:'afetler,host=localhost,user=root,password=mysql_pswd,port=3306,tables=sisint' > -sql "SELECT latitude,longitude,sisint from sisint" > > All the best > > Sig > -- Murat BEYHAN Geophysical Engineer, M.Sc. Prime Ministry Disaster and Emergency Management Presidency Earthquake Department Address: Eskisehir Yolu 12. Km. Lodumlu/ANKARA Tel: 312 2872680-1556 email:[email protected] -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
