PostgreSQL is an open source object-relational database system.
4
votes
2answers
61 views
What are the benefits of using ArcGIS with Postgresql over simply ArcSDE?
I understand that in order to benefit from ArcGIS spatial datatypes (ST_GEOMETRY, versioned geodatabases etc.) ArcSDE needs to be installed - and with the 10.1 client it is automatically installed ...
1
vote
1answer
43 views
Geometry has incorrect latitude-longitudes
SELECT ST_SRID(geom) AS s FROM zones GROUP BY s;
returns a single record: 4326
SELECT Find_SRID('public', 'zones', 'geom');
returns 4326
SELECT AsText(geom) FROM zones
returns geometry like:
...
2
votes
1answer
354 views
PostGIS ERROR: could not load library “/usr/lib/postgresql91/lib64/postgis-2.0.so”
OS is openSUSE 12.1, PostgreSQL - 9.1, PostGIS - 2.0. Postgre/PostGIS are installed from Application:Geo repository.
After recent updates when I try to connect to my database I get the following ...
0
votes
1answer
33 views
PostGIS error reads “Geometry has Z dimension but column does not” [duplicate]
I try to store a polygon in GeoJSON format into my PostGIS table. Both are using the CRS EPSG:3857. This is how the polygon is defined. Note that I put in some whitespace to make it more readable.
{
...
2
votes
1answer
126 views
generate height data from DTED maps
I have 16 DTED maps of (1 degree x 1 degree). I have to generate combined height matrix of maximum 4 (1 degree x 1 degree) DTED maps in my C++ application.
Can someone suggest to me which open source ...
0
votes
1answer
17 views
How to store multiple records output of a function in another function?
Normally if we get 1 output from a function then we keep it as
select function name() into r;
where r is the variable where we need to store the function output, if the output is 1 record.
How to ...
2
votes
1answer
58 views
How can I make a Postgres/PostGIS ST_Distance_sphere query more efficient?
Within Postgres/PostGIS I have written an SQL query to get the closest distance for each element within a point coordinate table from a polyline table. The query comes back and works correctly, but ...
3
votes
1answer
107 views
Shapefile postgis database to be queried by GeoDjango
I would like to create a Postgres database (postgreslq-9.1 and postgis-2.0.2) storing several shapefiles but I am uncertain on how to implement it so I'm searching for some advices.
I have already ...
-1
votes
0answers
12 views
how to find intersection of a fixed polygon with the variable polygons in the table
I have created a function to find the intersection coordinates of the user polygon with the tables polygon coordinates..here i need to fix the user polygon coordinates and to check the table polygon ...
2
votes
0answers
19 views
Clustering table on geohash index and geohash ordered table
I wonder if there could be a performance gain to re organize the rows in a table by Geohash and then CLUSTER this table on the Geohash index of the geometries.
CREATE TEMPORARY TABLE tmptbl AS
SELECT ...
1
vote
1answer
31 views
PgAdmin cannot load postgis for a database
Postgis works fine on my other postgresql databases, but I can't load postgis and postgis_topology extensions on a new database. I get following error message:
ERROR: could not load library (path to ...
1
vote
2answers
43 views
Geoserver SQL view parameterizing
I've got a postgresql table that has the following attributes:
name String
begintime String
endtime String
the_geom Point
Now I'd like to create an sql view in geoserver (2.2 ...
0
votes
0answers
15 views
How to find all possible paths by Postgis / Pgrout [duplicate]
There are functions available to find the shortest paths in Postgis / Pgrouting extension. But is it possible to find all the possible paths between two points/nodes ?
Is there any such function ...
4
votes
4answers
193 views
Unable to connect Postgis from QGIS 1.8.0
I have installed PostgreSQL and PostGIS on my laptop (Win 7 64 bit OS). I am running QGIS 1.8.0 on my machine .
When I am trying to connect Postgis I am getting connection failed error then I tried ...
1
vote
1answer
108 views
Stuck in loading raster to PostGIS
I am running running Mac OS X (10.7.5), PostgreSQL (9.2) and PostGIS (2.0.2) (installed via Postgres.app).
The PostGIS extension seems to work perfectly with vector and raster layers. Once I enable ...
2
votes
1answer
46 views
Convert OpenStreetMap schemas to ArcSDE in PostgreSQL database
I am trying to find a way to store OSM Extracts (or possibly the planetfile) in a PostgreSQL database, keep it up to date with diff files and then process the data further with ArcGIS (e.g. Geocoding, ...
1
vote
1answer
28 views
Are database client files platform specific?
I'm just looking for some clarification on a question that came up with me this morning. Are the DLL client files (libeay32.dll, libiconv-2.dll, libintl-8.dll, libpq.dll, and ssleay32.dll) platform ...
0
votes
1answer
32 views
PostgreSQL: transform spatial column from PG_GEOMETRY to ST_GEOMETRY
I have spatial Data stored in my PostgreSQL database as PostGIS Geometry (PG_GEOMETRY). It looks for example like this: 010100002031BF0D0000000000F989264152B81E057E6D5841
Now I would like to move ...
2
votes
1answer
26 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 ...
1
vote
0answers
18 views
error in loading raster tiles on postgreSQL
I am trying to import raster data from PostGIS to GeoServer.
I follow the instructions given on this link.
...
11
votes
4answers
6k views
Why does PostGIS installation not create a template_postgis
I went this route for installation of PostgreSQL and PostGIS:
PostgreSQL using the standalone KyngChaos,
PostGIS install from KyngChaos as well...
pgAdmin3 from PostgreSQL Tools
Now when I launch ...
3
votes
2answers
83 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
0answers
15 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
55 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 ...
5
votes
5answers
339 views
Improve performances on distance coverage routing - PostgreSQL
I have to create layers of land coverage from one point to anywhere around on a given street network for a given distance (ex: FROM house, DISTANCE 30000m)
An important factor to understand; I need ...
0
votes
2answers
49 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
36 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 ...
0
votes
1answer
42 views
Shp2pgsql - exec() not allowed on external server
Me and my collegue are using the shp2pgsql and psql commands in php code (a Drupal module to be precise).
We put these commands in a php variable and use the exec() command to execute them. This ...
1
vote
1answer
70 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
47 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
121 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
1answer
29 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 ...
0
votes
0answers
13 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 ...
3
votes
1answer
391 views
How to use the pgRouting TSP function?
For more than two days I'm trying to make the TSP algorithm work in PostgreSQL/PostGIS. My problem seems to occur when I'm trying to take into account the road network for TSP algorithm. I know that ...
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
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
39 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
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 ...
0
votes
0answers
12 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 ...
-1
votes
1answer
36 views
Getting error in replace() of postgresql [closed]
I am trying to use the replace() function to replace a character in a String column. My query is :
update table_name set name1 = replace(name1,'-',' ');
I am getting the following error :
...
1
vote
1answer
65 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
122 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 ...
1
vote
1answer
101 views
How to link pgrouting edges with street names to rout user based in street names?
I have installed postgreSql + postGis + pgrouting and I have loaded OSM data into my database using osm2po and shp2pgsql. How can I search for points in the map using the street names and then route ...
2
votes
1answer
33 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
49 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
69 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 ...
2
votes
0answers
224 views
How to solve postgreSQL error when using QGIS Cloud plugin?
I created a qgis cloud account and installed the plugin. When I attempted to Upload Data using the plugin, I got the following error:
postgreSQL exception:
ERROR: "MD5" authentication with pgpool ...
2
votes
3answers
67 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 ...
0
votes
1answer
48 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
...
0
votes
1answer
32 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 ...
