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

Murat Beyhan beyhan at deprem.gov.tr
Tue May 3 09:57:10 EDT 2011

Hi friends,

I would like to convert shp file into kml file by following
but I couldn't achieved. Please let me know How I can convert shape file
which I created by using gen2shp.

ogr2ogr -f KML simgmt.kml simgmt.shp -dsco NameField=RegionName
this can create a file but strangely data collected at one point. but
each points have its' own id, latitude and longitude. 

or by using MYSQl database  

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"

Unable to open datasource `MySQL' with the following drivers.
  -> ESRI Shapefile
  -> MapInfo File
  -> UK .NTF
  -> SDTS
  -> TIGER
  -> S57
  -> DGN
  -> VRT
  -> REC
  -> Memory
  -> BNA
  -> CSV
  -> GML
  -> GPX
  -> KML
  -> GeoJSON
  -> Interlis 1
  -> Interlis 2
  -> GMT
  -> SQLite
  -> ODBC
  -> PGeo
  -> OGDI
  -> MySQL
  -> XPlane
  -> AVCBin
  -> AVCE00
  -> DXF
  -> Geoconcept
  -> GeoRSS
  -> GPSTrackMaker
  -> VFK

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