3

I have a spatial table called 'places' in MySQL, with a spatial column 'pt' (point). I tried to import it in QGIS and no points appear. I created a view 'places_as_text' which reproduces the table but shows the points as WKT (used astext(pt) in the definition of the view). Still nothing appears in QGIS.

Any help appreciated

2

1 Answer 1

4

I'm using MySQL spatial tables everyday with QGIS in r&w mode using

Add Vector > Database > Type: MySQL

and defining a new connection, just like described in http://getspatial.com/gisblog/qgis-vector-data-connection. I can connect both to local and remote server. I'm not using the original geometry definition and not converting it to WKT. Do you have any connection problem (what is the result of test connection)?

Check also your table structure: field type MUST be GEOMETRY otherwise QGIS will load the table as attribute table and will not show any vector!

2
  • Thanks for the hint, I will try and update, but the data is not that easy to access at the moment
    – Vladtn
    Apr 2, 2012 at 12:55
  • 2
    It seems that this has been removed in QGIS 2.0 ... Sep 25, 2013 at 9:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.