0
votes
2answers
141 views

Adding Oracle Spatial View as Layer in QGIS?

Is it possible to add an Oracle Spatial View on QGIS MAP? My view is registered on MDSYS metadata but, when I connect with Oracle DB, it is disabled on the list. QGIS Desktop 2.2.0 Oracle Database ...
2
votes
0answers
69 views

How to set posgis default sequential value in a QGIS “editable” view?

Introduction In a QGIS project I have a VIEW, that I want to became editable (I'm trying to replicate the versioning system used DB Manager with some tweeks). Therefore I created a few rules to ...
1
vote
0answers
132 views

How to create a spatial view when allowing multiple selection in qgis’s edit widget “value relation”?

I've a point layer in qgis and serveral non spatial tables in a spatialite database. In qgis the fields were filled using the edit widget "value relation" (multiple selection allowed for some fields). ...
0
votes
0answers
63 views

Is there a limitation in quantity of joined tables using spatialite views?

I've one point layer in qgis and several non spatial tables in a spatialite database. Now I want to create a view as you can see in the following: CREATE VIEW testansicht10 AS SELECT ...
2
votes
1answer
475 views

How to load a postgres view using pyQgis?

Under Qgis 1.8 on Windows 7 I have this problem with my pyArchInit plugin: I need to load on the map canvas my geometries from a postgis layer. Till the 1.7.4 version I use the method explained on the ...
25
votes
3answers
8k views

How to make a spatial view in PostGIS and add it as a layer in QGIS?

In PostGIS 2.0, what is the most efficient way to create a spatially enabled view that is viewable in QGIS? I followed the context of Part 2 of @Mike Toews answer to this question, and the view ...