Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I'm trying to understand what goes wrong with a QGIS python plugin. Basically I'm trying to render a series of POINT.

The query works fine, at least giving it by hand from inside PostGIS DB:

"SELECT  gid, CAST (gid as text)|| '_' || (ST_DumpPoints(the_geom)).path[2] as key,  (ST_DumpPoints(the_geom)).geom as points FROM ways"

I concat gid and path[2] because after splitting the_geom (MULTILINE) field into several POINT, gid are duplicated and I think they are no longer usable as key (with this trick key should be unique, but it seems not solve my problem).

I tried to create the layer this way:

def createPointLayer(self):
    uri = self.db.getURI()
    query = "SELECT  gid, CAST (gid as text)|| '_' || (ST_DumpPoints(the_geom)).path[2] as key,  (ST_DumpPoints(the_geom)).geom as points FROM ways"

    uri.setDataSource("", "(" + query + ")", "points","","key")
    layerName = "NodeLayer"
    aLayer = self.iface.addVectorLayer(uri.uri(), layerName, self.db.getProviderName())

I think the query works fine (QGIS takes a long time before display the error. I guess something goes wrong after the query has been executed).

When the plugins run QGIS output the following error:

Layer is not valid:

The layer dbname='pgrouting' user='user' password='user' key='gid' table="(SELECT gid, CAST (gid as text)|| '_' || (ST_DumpPoints(the_geom)).path[2] as key, (ST_DumpPoints(the_geom)).geom as points FROM ways)" (points) sql= is not a valid layer and can not be added to the map

I already had to struggle against the Layer is not valid error, but I don't know how to debug it. So I have 2 questions:

  1. Could anyone tell me what's my mistake in this specific case?
  2. How can I debug 'Layer not valid error'? How can I get more information on which is the problem?

EDIT:

QGIS log console display the following message:

No key field for query given

share|improve this question
    
It seems you're still using non-unique gid in the layer datasource definition. –  underdark Nov 23 '12 at 16:50
    
@underdark: sorry, I pasted the wrong code. I edit it. Consider data source set this way: uri.setDataSource("", "(" + query + ")", "points","","key"). And I've just checked that key column has no duplicated value. –  Heisenbug Nov 23 '12 at 17:02
    
@underdark: btw..thanks for pgRoutingLayer plugin. I'm learning a lot reading your code. –  Heisenbug Nov 23 '12 at 17:08
    
Are you wrapping some of the API in your own code? I cannot find a reference to addVectorLayer in PyQGIS. It seems addVectorLayer is found in the QGIS API for C++ –  RomaH Nov 23 '12 at 17:24
    
@RomaH: iface is a reference to QGIS interface: qgis.org/pyqgis-cookbook/plugins.html#writing-a-plugin . Btw that method works as is. I didn't wrap anything. In other point of my code works fine. –  Heisenbug Nov 23 '12 at 17:27

1 Answer 1

I had the same problem: "The layer ... is not a valid layer and can not be added to the map". It was just because my "id" was not unique (by default, the plugin used the first column as id (called "edge_id", so it took me a bit to figure out) which was not unique, instead of the "id" column, which was unique.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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