Tagged Questions
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
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
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 ...
1
vote
1answer
56 views
Win7 Senior users_Which pgRouting and postGIS versions are stable with postgreSQL8.4?
I'm working on a postgreSQL ,postGIS and pgRouting project on Windows 7
I need to work on a stable version (no time for risks), and I can see that many people are asking the same question many ...
1
vote
5answers
83 views
Unable to install the PostGIS extension to PostgreSQL on Ubuntu 12.04 LTS
I just installed Linux Ubuntu 12.04 LTS (on a virtual machine). I then successfully installed the PostgreSQL 8.4 database management system. I am now trying to install PostGIS, which is an extension ...
2
votes
1answer
29 views
How to install multiple versions of postgres in same os windows 7 64-bit?
I have already installed PostGIS along with opengeosuite and it is the latest version. Now I want to run pgrouting but the latest stable version does not compatible to the latest postgres versions. ...
-3
votes
0answers
44 views
What versions of Postgres, PostGIS and pgRouting shall I use on a 64bit windows os? [closed]
Please give me the links and stepwise instructions briefly for installing all the three.
Condition : There shouldn't be any bug in shooting star algorthm. So the comaptable stable versions of the ...
1
vote
2answers
68 views
Public PostGIS Server available?
can anyone point me to a (if possible at all) list of public PostGIS Servers, where one can set up it's own database/tables ?
It's just that I would need a PostGIS 24h on, while dont having these ...
0
votes
1answer
24 views
How to install PostGIS 8.4 in windows 7 64 bit parallel to an existing PostGIS 9.2?
PostGIS 9.2 is installed along with OpenGeoSuite using one click setup. But 9.2 dont support pgRouting. So I need to install 8.4. I dont how to include binaries and all. So someone please tell me how ...
0
votes
0answers
39 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 ...
0
votes
1answer
38 views
raster2pgsql missing in Opengeo-suite installation
I installed opengeo-suite 3.0.2 on Ubuntu 12.04 and although the stack seems to be working fine, raster2pgsql is no where to be seen!
root@mywebsite:/usr/local/lib/postgresql/9.2# locate raster2pgsql
...
