[gdal-dev] drawing line using OGR and mysql in mapserver

Murat Beyhan beyhan at deprem.gov.tr
Fri Mar 2 08:12:08 EST 2012


I have to say this is not view
this is a table created.

Because I could not declare type of geom field as a string than I create
geometry field column in spatial mysql database..


On Fri, 2012-03-02 at 18:39 +0530, Chaitanya kumar CH wrote:
> Murat,
> 
> Can you show a sample output of your view?
> SELECT * FROM geom;
> 
> On Fri, Mar 2, 2012 at 6:12 PM, Murat Beyhan <beyhan at deprem.gov.tr>
> wrote:
>         
>         
>         
>         
>         Dear Chaitanya,
>         
>         I see what you explain first I convert lat lon data to string
>         then I
>         concatenate them to string again. But I would like to ask
>         I have already add data to mysql table as follows is this also
>         correct
>         because when I browse table it seems it store data in geometry
>         field
>         but mapserver gives error
>         Unable to identify source field 'fault' for geometry.
>         any way
>         I will try to convert data first then I can return back you.
>         Regards...
>         
>         ps.
>         
>         ogrinfo
>         MYSQL:dynamic,user=root,password=mysql_123,host=localhost,port=3306,tables=geom
>         INFO: Open of
>         `MYSQL:dynamic,user=root,password=mysql_123,host=localhost,port=3306,tables=geom'
>              using driver `MySQL' successful.
>         1: geom (None)
>         
>         
>         
>         
>         it say none in geom
>         may be first I have to do what you say
>         thanks
>         Murat
>         
>         
> 
> -- 
> Best regards,
> Chaitanya kumar CH.
> 
> +91-9494447584
> 17.2416N 80.1426E
> 
> -- 
> This message has been scanned for viruses and 
> dangerous content by MailScanner, and is 
> believed to be clean.



Murat BEYHAN 

Jeofizik Y.Müh.
T.C. Başbakanlık
Afet ve Acil Durum Yönetimi Başkanlığı
Deprem Dairesi Başkanlığı
Eskişehir Yolu 12. Km.
Lodumlu/ANKARA
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