[gdal-dev] create kml file using MySQL database or shape file

Murat Beyhan beyhan at deprem.gov.tr
Wed May 4 03:17:49 EDT 2011

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
So How can I fix it...


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


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

Geophysical Engineer, M.Sc.
Prime Ministry
Disaster and Emergency Management Presidency
Earthquake Department
Address: Eskisehir Yolu 12. Km.
Tel: 312 2872680-1556
email:beyhan at deprem.gov.tr

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

More information about the gdal-dev mailing list