PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.
1
vote
0answers
22 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
37 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
25 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
34 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
51 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
17 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 ...
1
vote
1answer
67 views
postgis distance calculation between points with lat, long coordinates
Team,
I am new to postgis, but a postgres user for quite a while. I would like to compare
the geospatial capabilities between postgresql and mongodb.
I have the lat.lon, zip code of US locations;
...
0
votes
1answer
41 views
Does each road segment need to be digitized into a separate entry for a road network?
I am trying to understand this code in pgRouting for creating topology:
CREATE OR REPLACE VIEW road_ext AS
SELECT *, startpoint(the_geom), endpoint(the_geom)
FROM road;
CREATE TABLE node AS
...
0
votes
0answers
30 views
Identifying Intersections of Geology using PostGIS
I'm having problems identifying intersections on a layer of linework, the lines are representative of contacts and faults (geological rock formations). I am trying to select where there are connected ...
0
votes
0answers
24 views
What are the rules for digitizing roads for creating a road network?
I want to create shortest route tool using pgRouting. But I digitised roads in a random manner. Shall I need to give a separate row for each road segment?
0
votes
0answers
18 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
0answers
16 views
not able to view imported .tif file in geoserver
I am using geoserver. I have imported a .tif file using postgis, which has been saved in vector type layer in geoserver. Now, whenever, I preview it, the layer gets automatically downloaded as wms ...
2
votes
1answer
24 views
How can I check if a multipolygon can be represented as a simple polygon?
I have a large (30m+ records) spatial data set I have imported into a PostGIS database. I did not expect to find multipolygons in the data set, but it does have a few of them. I'd like to take a ...
0
votes
0answers
21 views
Add dynamic layer to geoext tree
I'm trying to add a dynamic OpenLayers Layer in a folder(children) of tree.
I've tryed the following code and it works, but I don't know how to associate the layer with a layer of OpenLayers() type:
...
0
votes
1answer
52 views
How can i select many rows from a table?
I want to create an action that select many rows from PostGIS table to show many lines in QGIS.
How can i select many rows from table with python to add these rows in a layer?
Thank you
