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

2011-05-04 Thread Murat Beyhan
when creating KML layer. > > All the best > > Sig > > Messaggio originale > Da: bey...@deprem.gov.tr > Data: 04/05/2011 14.25 > A: "sigfr...@tiscali.it" > Cc: "gdal-dev@lists.osgeo.org" > Ogg: Re: R: Re: [gdal-dev] create kml file using

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

2011-05-04 Thread sigfr...@tiscali.it
quot;sigfr...@tiscali.it" Cc: "gdal-dev@lists.osgeo.org" Ogg: Re: R: Re: [gdal-dev] create kml file using MySQL database or shape file Dear Sigfrido As you told me I have added a geometry column to my database as g and I executed following sql statement This is the first ti

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

2011-05-04 Thread Murat Beyhan
Dear Sigfrido As you told me I have added a geometry column to my database as g and I executed following sql statement This is the first time for me to make spatial database table . So I think first of all I have to learn more about Spatial database concept in MySQL. any way UPDATE deneme2 S

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

2011-05-04 Thread sigfr...@tiscali.it
Hi Murat, I'm not so much into KML, but I think that maybe the problem is with your SQL: you are not including any geometry column in the select instruction. If you open the KML file with a text editor, you can see if the points are being exported and with which coordinates. Does the MySQL t