Dear Robert,
Thanks for your reply,
Actually I have tried your suggestion but I could not succeed.
as follows in .map file directly
and in MySQL database I created a lineview view as follows
create view lineview as select eq_id, "LINESTRING(" + lon1 + " " + lat1
+ "," + lon2 + " " + lat2 + ")" as geom from sfault
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>'
# <SrcDataSource>ODBC:user/passwd@DSN</SrcDataSource>
DATA sfault1
STATUS on
TYPE line
CLASS
name "Source Fault"
SYMBOL "cline"
SIZE 3
COLOR 0 0 255
END
END
There is an another issue I have to make a query in layer because I
select only one line from database so I have try to add SQL statement. I
'm not good at OGR GDAL so I need some advice and help.
Thank you for your interest
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@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 <[email protected]> 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:[email protected]
>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
> _______________________________________________
> mapserver-users mailing list
> [email protected]
> 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:[email protected]
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
