[mapserver-users] draw line readinf from mysql

[Murat Beyhan]

Dear all,

Still could not achieve to draw line using start and stop point line
data stored in MySql database.

I have tried Mr. Robert's solution but I have faced an error message.


in map file 
I changed Geometrytype from wkbline to wkblinestring.

LAYER
NAME sfault1 
CONNECTIONTYPE OGR
CONNECTION '<OGRVRTDataSource>
<OGRVRTLayer name="lineview">
<SrcDataSource>MYSQL:dynamic,user=root,password=mysqlpasswd,host=localhost,port=3306,tables=lineview</SrcDataSource>     
<SrcLayer>lineview</SrcLayer>
<GeometryType>wkbLineString</GeometryType>
<GeometryField encoding="WKT" field="geom"/>
<LayerSRS>WGS84</LayerSRS>
<FID>eq_id</FID>
</OGRVRTLayer>
</OGRVRTDataSource>'
  DATA sfault1
  STATUS on
  TYPE line
  CLASS
  NAME "Source Fault"
  SYMBOL "cline"
   SIZE 3
  COLOR  0 0 255 
 END
END 

in database
I have two table 
one is store id lat1 lon1 lat2 lon2 
and another is view 
of this table created by following

create view lineview as select eq_id, "LINESTRING(" + lon1 + " " + lat1
+ "," + lon2 + " " + lat2 + ")" as geom from sfault


there is an another issue,
I have to draw line by considering id 
so in the map When I select one id, line should be belong to this id's
information
so I have to make a sql statement as follow instead of draw all line
stored in database I have to draw just one line considering id

something like this select eq_id, geom from lineview where id like '%id
%' 


please help about this subject....


Regards....



Murat



On Tue, 2012-02-21 at 09:15 +1300, Robert Sanson wrote:
> Hi Murat
> 
> Is it possible for you to create a view from the columns that presents the data as a WKT line feature:
> 
> create view lineview as select id, "LINESTRING(" + lon1 + " " + lat1 + "," + lon2 + " " + lat2 + ")" as geom from mytable
> 
> Then set up your OGR ovf file representing this view:
> 
> <OGRVRTDataSource>
>         <OGRVRTLayer name="fences">
>         <SrcDataSource>ODBC:user/passwd at DSN</SrcDataSource>
>         <SrcLayer>lineview</SrcLayer>
>         <GeometryType>wkbLine</GeometryType>
>         <LayerSRS>EPSG:2193</LayerSRS>
>         <GeometryField encoding="WKT" field="geom"/>
>         <FID>id</FID>
>         </OGRVRTLayer>
> </OGRVRTDataSource>
> 
> Best wishes,
> 
> Robert
> 
> >>> Murat Beyhan <beyhan at deprem.gov.tr> 21/02/2012 2:52 a.m. >>>
> Dear friend,
> 
> I'm trying to draw a line using MySql database
> the table in database as follows,
> 
>             id    lat1    lon1    lat2    lon2
> 20100308023229 40.1113 38.7901 40.0311 38.7428
> 
> actually using ogr connection I can draw point using ogr and mysql, but
> How can I draw line using such database table, please help me and give
> the idea...
> 
> Thanks 
> 
> Murat
> -- 
> 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:beyhan at deprem.gov.tr 
> 
> 
> 
> -- 
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org 
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> 
> 
> This email and any attachments are confidential and intended solely for the addressee(s). If you are not the intended recipient, please notify us immediately and then delete this email from your system.
> 
> This message has been scanned for Malware and Viruses by Websense Hosted Security.
> www.websense.com
> 



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.