<HTML>
<HEAD>
<META content="text/html; charset=iso-8859-9" http-equiv=Content-Type>
<META content="OPENWEBMAIL" name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<font size="2">
<br /> <font size="2"><b>Dear friends;
<br />
<br /> Finally I have solved to read point data form mysql database than
draw map by
using
<br /> those
data.
<br /> I have created Peak Ground Acceleration (PGA) map for the specified earthquake which
data
are
<br /> stored in MySql. But I would like to display map for all earthquake
which
are
<br /> described in the Mysql table as eq-id
column.
I mean PGA data are stored in mysql database.table for several earthquakes
<br />and one of the column is called EQ_ID which use for the seperate PGA data from other earthquake like
<br />EQ_ID Lon Lat PGA
<br />200006060242 30.40 32.45 2.5
<br /></b></font></font><font size="2"><font size="2"><b>200006060242</b></font></font><font size="2"><font size="2"><b> 30.41 32.46 2.6
<br /></b></font></font><font size="2"><font size="2"><b>200006060242</b></font></font><font size="2"><font size="2"><b> 30.42 32.47 2.7
<br />...
<br />200606071708 38.45 40.98 5.6
<br /></b></font></font><font size="2"><font size="2"><b>200606071708</b></font></font><font size="2"><font size="2"><b> 38.46 40.99 5.7
<br /></b></font></font><font size="2"><font size="2"><b>200606071708</b></font></font><font size="2"><font size="2"><b> 38.47 41.00 5.7
<br /></b></font></font><font size="2"><font size="2"><b>200606071708</b></font></font><font size="2"><font size="2"><b> 38.48 41.01 5.8
<br />
</b></font></font>.
<br />.
<br />.
<br /><font size="2"><font size="2"><b> I have querid mysql database by using ovf file as following
<br />
<br /> <OGRVRTDataSource>
<br /> <OGRVRTLayer
name="acceleration">
<br />
<br /> <SrcDataSource>MYSQL:database,user=user,password=pass_wd,host=100.00.00.21,port=3306,tables=d_pgadata1</SrcDataSource>
<br /> <SrcSQL>SELECT eq_id,latitude,longitude,acceleration
from
d_pgadata1
<br /> where eq_id like '%200006060242%'
</SrcSQL>
<br /> <GeometryType>wkbPoint</GeometryType>
<br /> <GeometryField encoding="PointFromColumns"
x="longitude"
y="latitude"/>
<br /> </OGRVRTLayer>
<br /> </OGRVRTDataSource>
<br />
<br /> As you see when I create map by layer OGR this will just the
eq_id
like
<br /> '%200006060242%'.
<br /> But I would like to change this eq_id by interactively for example
who
will
<br /> like to see </b></font></font><font size="2"><font size="2"><b>200606071708</b></font></font><font size="2"><font size="2"><b> earthquake PGA map he/she can change sql
statement
in
<br /> ovf file by using php or html commands
from web...
<br />
<br /> Do you have any idea is it possible or
not.
<br />
<br /> Please I wellcome any kind of information about
it..
<br /> Thank you
<br /> Murat
<br /></b></font>
<br /></font>
</BODY>
<br />--
<br />This message has been scanned for viruses and
<br />dangerous content by
<a href="http://www.mailscanner.info/"><b>MailScanner</b></a>, and is
<br />believed to be clean.
</HTML>