[Qgis-user] QGIS -> MySQL -> Mapserver ??

Chris Green chris.green at ibstv.co.uk
Tue Jul 26 23:45:09 PDT 2011


 

Hi QGIS users

 

I have a problem getting Mapserver to display vector line features which I
created with QGIS and saved as spatial objects in MySQL...I asked for some
advice on this from the Mapserver forum yesterday but had no responses,
perhaps someone in this forum has some experience to offer?

 

As explained in the question below, I can create line features in QGIS, save
them in a MySQL table, and recall and display them with QGIS without any
problem.  But the same features do not appear to be recognised by OGRInfo or
by Mapserver. The line features are saved as BLOB data in a MySQL  MyISAM
table in a column which is defined as type 'geometry'. MySQL can create a
spatial index of these features.

 

The table is accessed by QGIS as a database layer via the 'Add Vector Layer'
dialogue. I am using QGIS 1.7. 

 

It's not really a QGIS problem, but I spent all day wrestling with this
yesterday but have not solved it.  Any suggestions?

 

 

 

Chris

 

############################################################################
###     

 

 

I'm having some trouble with an OGR connection to a MySQL database. The data
I'm trying to access was created using QGIS as a line layer and saved in a
MySQL table as a BLOB in a geometry column. I can access and properly
display this line data using QGIS, but not so far via Mapserver - nothing is
drawn and I can't see any error.

 

I am using Mapserver 6.0 and my mapfile is very similar to the example in
theMapserver / MYSQL  documentation:

 

LAYER

       NAME "testLine" 

       TYPE   LINE

       STATUS  DEFAULT

       CONNECTIONTYPE  OGR

       CONNECTION  "mysql:testDB,user=admin,password=password,port=3306" 

       DATA "SELECT Geometry from testLine"

       CLASS

              STYLE        

                     COLOR  0 0 0

                     WIDTH  2      

              END # style

       END # class

END # layer

 

 

 

If I look at the MySQL table using OGRinfo I see the following:

 

Layer name: testLine

Geometry: Unknown (any)

Feature Count: 0

Layer SRS WKT: 

(unknown)

FID Coumn = id

Geometry Column = Geometry

 

 

The issue seems to be that OGRInfo and therefore MapServer does not
recognise any features in the table, but QGIS using access to the same table
finds and displays the features.

 

 

Anyone have any ideas what I am doing wrong?

 

 

Chris

 

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20110727/6f7d20a0/attachment.html>


More information about the Qgis-user mailing list