PostgreSQL is an open source object-relational database system.
0
votes
0answers
13 views
pg_dump from 9.2 to 8.4 [migrated]
I'm trying to restore a db dump from postgreSQL 9.2 to postgrSQL 8.4
(from seperate machines, both are running win 7)
I followed the instructions in this answer
...
0
votes
2answers
46 views
Cannot insert simple geometry data
I installed PostgreSQL 9.2.4 and PostGIS 2.0.3 on my Windows 8 machine. Then I created a table using phpPgAdmin and added a geometry column using the following statement.
SELECT ...
0
votes
2answers
45 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
28 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 ...
1
vote
1answer
47 views
PostGIS not converting GIS data into latitude/longitude values
I am running PostgreSQL and PostGIS. I am trying to do something mind-numbingly simple: determine the latitude and the longitude of a point.
Unfortunately, PostGIS stubbornly refuses to transform the ...
2
votes
0answers
45 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 ...
0
votes
1answer
25 views
ST_MakeEnvelope returning too many geos
I am using the following query in my db:
SELECT bg_id, ST_AsGeoJSON(the_geom)
FROM bg
WHERE bg.the_geom && ST_MakeEnvelope(xxx, xxx, xxx, xxx);
It seems to execute alright but when I draw ...
5
votes
1answer
95 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
10 views
Which all columns should I add in postgresql table so that it stores elevation values and displays them in Geoserver?
I am using geoserver and postgresql. I imported raster (.tif) file to postgresql using raster2pgsql. The file thus imported creates a new table in postgresql. But when that file is previewed in ...
0
votes
0answers
28 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.
...
1
vote
0answers
21 views
Preserving attributes of linejoin through concatenation
I've run into a bit of a problem, I'm working on a layer of connected lines which represent geological faults and contacts. These lines were broken into many small segments so to get rid unnecessary ...
0
votes
0answers
22 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
36 views
Shooting star algorithm in postgres 8.4 and postgis1.4 showing fatal error and remaining are working fine
When I try to run this shooting star algorithm, the postgis suddenly loosing connection to postgres and showing error no connection to server
SELECT * FROM shortest_path_shooting_star('
SELECT gid ...
0
votes
0answers
10 views
Can driving_distance return all sets of distance from different starting points at one time？
I'm now using the extension of pgRouting, driving_distance, to search for the distance along the river system：
In the figure, the starting point is 3, but I want to get the distance starting from ...
0
votes
0answers
17 views
driving_distance does not return all sets of distance
As title, I am working with pgRouting, trying to get the distance matrix along the river system.
I use driving_distance function and it seems like I am getting what I want：
But when I check the ...
