Tagged Questions
-1
votes
0answers
45 views
How to assign a SQL query to a table attribute? [closed]
I have created a plugin with "plugin builder." Now I seek to connect my plugin to postgres. I have a shapefile and I try to find a script in Python that can assign a SQL query to my table attribute. ...
0
votes
2answers
51 views
How to select polygons in polygon and export to CSV?
I have two polygon layrers, each layer a table in PostgreSQL:
One layer with polygons areas in a city.
Another layer with buildings (polygons) that are within areas.
How can I to do to know what ...
0
votes
1answer
42 views
Cant Instal psycopg2 on mac 10.8.2
I know there Have been a lot of similar questions asked but none address this issue as I far as I can tell. When I am trying to install the sextante plugin, or run PostGIS Manager in QGIS I receive ...
2
votes
0answers
48 views
Installing knn on PostgreSQL for windows
I am trying to install the extension KNN for clustering as an extension on my PostgreSQL database.
I have downloaded the file
http://www.pgxn.org/tag/analysis
I found instructions on how to ...
5
votes
1answer
128 views
How to implement Spatial Autocorrelation using QGIS or PostgreSQL (or any free application)?
I am a total newbie on the GIS scene so I hope this is not a stupid question.
I have two layers in a PostgreSQL database.
The first layer contains points where events happened in Europe.
The second ...
0
votes
0answers
30 views
Is QGIS OGR plug-in data provider (based on Postgres) limited to 500 features in layer?
I developed a plug-in based on OGR. It works fine but when I want to add a vector data (using my plug-in) I get 1449 features (with 76 columns) in my layer. Then I select this layer and load it.
...
0
votes
0answers
23 views
How to use for loop to make driving_distance more efficiently？
I use driving_distance function in pgRouting to work with my river network. There are 159 nodes in my river network, and I want to get the distance between all of the nodes. This is my code so far：
...
0
votes
0answers
61 views
QGIS SPIT errors loading shapefile into PostGIS
With QGIS 1.8 on Windows 7, I just installed PostgreSQL / PostGIS and tried to load my first data into it, a shapefile using SPIT, but failed:
ERROR: Geometry type (Polygon) does not match column ...
3
votes
1answer
116 views
How to import QGIS Raster into PostGIS
I have created a IDW heatmap using QGIS 1.8.0 and need to import the raster into PostGIS 2.0.1. QGIS saves the raster layer as a .asc file.
How do you import the raster into PostGIS as a Raster? What ...
1
vote
0answers
54 views
Creating polygons for a choropleth map using PostGIS
I have a grid of points, each with a value to it as shown in the image below. The data was retrieved from PostGIS and rendered in Quantum GIS. The final result should be a polygons of a choropleth map ...
5
votes
3answers
97 views
What is the easiest one click install method for PostGIS and it's entire dependencies?
For someone new to database servers and their dependencies, what is the easiest assured way of installing PostGIS on a machine with no other software beyond what comes with its operating system? I'd ...
2
votes
3answers
71 views
Connnect to PostGIS db using QGIS - when not on localhost
I"m just getting started with PostgreSQL/PostGIS db (v9.2) and I'm wanting to connect to db while not on the localhost using QGIS. I've been able to connect successfully on localhost, however I'm not ...
1
vote
0answers
65 views
I can't connect QGIS with postgresql
I can create a connection to the database in qgis and the test connection is successful. However when I actually connect to the database to export shape files I get the following error:
the ...
3
votes
2answers
89 views
Problem loading PostGIS (Postgres) View layer in QGIS
Why is Postgres user XX via command „Add PostGIS Layers“ in QGIS enabled upload only View tables which owns?
Or how to achieve it to the user XX via PostGIS can load View table which owns the user YY?
...
0
votes
1answer
65 views
In QGIS can I show just the lines in a Postgis query? How can I do that?
I have three tables in Postgresql, each table with one layer of lines.
I want to show the path of an initial line to another final. Is it possible executing a SQL query?
Thanks
My three tables are ...
