Chaitanya, thanks for your repply, Actually I use ogr and mysql to draw point for example epicenter of earthquakes. But this is the first time to draw line which is stored in Mysql as a table. Actually there is no problem on drawing shape file of the line. But I would like to draw it using MySql and ogr functionality. So I have only start and end point of line and I store it on MySql database then I try to draw it considering id of the line by sql statement. Just I would lie to learn how to code it on Mapserver map file and how should I store line on database as a start and stop point of the line or as a geometry . Please help... thanks
On Mon, 27 Feb 2012 22:09:52 +0530, Chaitanya kumar CH wrote > Murat, > > First check if your database is accessible using ogrinfo[1]. > Then create a vrt file with the content you specified in the CONNECTION > field of the mapfile. Check if ogrinfo gives expected results with this > file. > > You probably have gdal executables if you are running mapserver. > > [1]: http://www.gdal.org/ogrinfo.html > > On Mon, Feb 27, 2012 at 12:48 PM, Murat Beyhan > <bey...@deprem.gov.tr> wrote: > > > Dear all, > > I have shared this mail on Mapserver list but could not solve my > > problem. > > 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,po rt=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 sfault which store > > > > id lat1 lon1 lat2 lon2 > > > > and another is lineview which is a 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 > > > > > > > > > > > > -- > > This message has been scanned for viruses and > > dangerous content by MailScanner, and is > > believed to be clean. > > > > _______________________________________________ > > gdal-dev mailing list > > gdal-dev@lists.osgeo.org > > http://lists.osgeo.org/mailman/listinfo/gdal-dev > > > > -- > 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ük. Müh. T.C. BAŞBAKANLIK Afet ve Acil Durum Yönetimi Başkanlığı Deprem Dairesi Başkanlığı Eskişehir Yolu 12. Km. Lodumlu/Ankara Tel:+90 (312) 2872680-1550 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
