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

[Chaitanya kumar CH]

Murat,

Since it is MySQL it doesn't matter much how you store it. If you are going
to edit the end points later, storing them as points is preferable,
otherwise store them as wkt linestring geometries.

For your mapfile, first check if the extents are correct. Then check if the
mapfile works with a shapefile created from the geometries in MySQL.

On Tuesday, February 28, 2012, Murat BEYHAN wrote:

> 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
> > <beyhan at deprem.gov.tr <javascript:;>> 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 at lists.osgeo.org <javascript:;>
> > > 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.
>
>

-- 
Best regards,
Chaitanya kumar CH.

+91-9494447584
17.2416N 80.1426E
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20120228/570b4633/attachment-0001.html