[gdal-dev] drawing line using OGR and mysql in mapserver
beyhan at deprem.gov.tr
Mon Feb 27 15:52:47 EST 2012
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...
On Mon, 27 Feb 2012 22:09:52 +0530, Chaitanya kumar CH wrote
> First check if your database is accessible using ogrinfo.
> 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
> You probably have gdal executables if you are running mapserver.
> : http://www.gdal.org/ogrinfo.html
> On Mon, Feb 27, 2012 at 12:48 PM, Murat Beyhan
> <beyhan at 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">
> > <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
> > http://lists.osgeo.org/mailman/listinfo/gdal-dev
> Best regards,
> Chaitanya kumar CH.
> 17.2416N 80.1426E
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
Jeofizik Yük. Müh.
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.
More information about the gdal-dev