1
vote
0answers
13 views

QGIS DBmanager import file append not working [duplicate]

I am using QGIS and connecting to Postgresql database. I want to import shapefile data into database table via DBmanager tool. But Append data to table selection is inactive like following image. I ...
0
votes
0answers
25 views

Points generated using mmqgis are invalid

I used mmqgis plugin to geocode some addresses, he pointed to have found them all. But the screen shows only a point when there are more than 100, in the attribute table all appear. I loaded this ...
0
votes
0answers
14 views

Query from plugin that shows result on Map and in Attribute Table

I'd like to create a plugin that performs a static (no user input required) query that, based on a condition, selects all the features on the map and displays these in the attribute table. I have the ...
0
votes
0answers
61 views

QGIS - Loading data by SQL-window in the DB-Manager is not working?

I have problems to add a subset from a PostGIS-table to QGIS by using 'load as new layer' in the SQL-window of the DB-Manager (QGIS-Version 2.2.0-Valmiera). I defined both the 'column with integer ...
3
votes
1answer
118 views

how to snap two line vertex in two different layers used in QGIS

I want to snap between two poly-lines from 2 different layers (Layer1 in Brown and Layer 2(postGIS layer) in Pink color- ), but my snap option don't work. I have changed the tolerance to different ...
0
votes
0answers
52 views

setSubsetString with limit?

I have a layer with couple thousands objects in QGIS and I would like to create a filter of the layer where result would be only one object. I would like to do it in console or plugin. I am using ...
1
vote
0answers
265 views

Cannot add the PostGIS raster layer with QGIS

I've imported some raster data in PostGIS database with the following command: raster2pgsql -s 31468 -I -C -M -t 50x50 /home/stefan/Quantum\ GIS/Neumarkt/NM_NW.tif public.demelevation | psql -U ...
2
votes
1answer
108 views

Points to paths

I have a set of lat/long points which represent positions along a set of paths (the points are generated by satellite collars on several animals that we are tracking), and I want to link the points ...
8
votes
3answers
738 views

Howto setup and use a remote GIS workstation (QGIS,GRASS,PostGIS)?

I'm using QGIS (and sometimes GRASS and PostGIS) on my 2009 MacBookPro for my thesis project. I was wondering (during an endless batch generalizing in QGIS) if I can set up a server so I can work from ...
1
vote
0answers
116 views

Are there limitations with gdal virtual raster option?

I am new at Postgis and I'm groping... I pretend to rasterize some weighty vector layers in Postgis, do some map algebra and reclassification with them and visualize intermediate as well as final ...
0
votes
0answers
23 views

postgis: no module named psycopg2 [duplicate]

Possible Duplicate: psycopg2 error with QGIS 1.5 When I open DB Manager in QGIS I get what appears to be an error message at the bottom of the window:- postgis: no module named psycopg2 ...
2
votes
1answer
741 views

How can I fix QGIS PostGIS Manager error 'shp2pgsql' is not recognized?

I have QGIS 1.8.0 installed via OSGeo Installer and work on win 7. All I need is to upload the shapefile to the database via this plugin. Unfortunately I am receiving an error: Something's wrong: ...
2
votes
1answer
497 views

How to debug 'Layer is not valid error' from Python plugin?

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 ...
3
votes
1answer
231 views

Does QGIS DB Manager plugin lock PostGIS transactions?

I do most of my geospatial analyses in PostGIS 2.0 using PgAdmin III. I use QGIS 1.8 for visualizing my data but also for querying my database using the DB Manager plugin. Sometimes (quite often ...
2
votes
0answers
240 views

Postgresql Query Plugins Not Returning Results in QGIS

I'm using the Fishnet function as described here to create a grid. If I use the following SQL to call the function to position a grid where I want it (I'm using NZGD2000 SRID = 2193) the query ...
2
votes
1answer
446 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 ...
1
vote
2answers
175 views

Toggle editing option in plugins

I am working on python plugins for QGIS.I developed the plugins same as RT SQL LAYER plugins. When we draw the layers using query builder of "Add Postgis Layer" option,toggle editing option is ...