[gdal-dev] drawing line using OGR and mysql in mapserver
Chaitanya kumar CH
chaitanya.ch at gmail.com
Mon Feb 27 11:39:52 EST 2012
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.
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
> 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.
> NAME sfault1
> CONNECTIONTYPE OGR
> CONNECTION '<OGRVRTDataSource>
> <OGRVRTLayer name="lineview">
> <GeometryField encoding="WKT" field="geom"/>
> DATA sfault1
> STATUS on
> TYPE line
> NAME "Source Fault"
> SYMBOL "cline"
> SIZE 3
> COLOR 0 0 255
> 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
> 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....
> 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
Chaitanya kumar CH.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the gdal-dev