The postgis tag has no wiki summary.
0
votes
1answer
57 views
Select first row (grouping) + add aggregate function
First have a look at this question on StackOverflow.
I'm looking to accomplish the same task, except I also need to add an aggregate function (PostGIS's ST_Union) to my query.
How can I combine the ...
0
votes
1answer
150 views
Ubuntu 12, PostgreSQL 9.2, PostGIS 2.0
At the current moment, March 4th 2013, can PostGIS2.0 be install with PostgreSQL 9.2?
I checked their website and to my understanding it is not possible...
I hope that's not the case. Can anyone ...
1
vote
1answer
153 views
postgis problem with shortest distance calculation
while working with POSTGIS pgrouting, for calculateing the distance between two roads(lines) i got the shortest_path function.
But the logic is based on Start_point(Start_id) and end_point(end_id) ...
2
votes
1answer
58 views
PostgreSQL: Cannot change directory to /root
I am trying to copy a table planet_osm_polygon from one database osm to another test. I su postgres and performed the pg_dump.
Problem: However I'm getting the error could not change directory to ...
0
votes
2answers
76 views
Trying to create PostGIS database
I am trying to create a spatially enabled PostGIS database. I am following the PostGIS documentation, http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2648455.
In the short ...
0
votes
1answer
38 views
Set field values to newly imported rows in PostgreSQL table with existing data
I have a PostgreSQL table with existing data, and needs to import all the rows in a CSV file into that table. I am using pgadmin3's Import tool to do the import.
Question: For the newly imported ...
2
votes
1answer
74 views
Limiting number of results in a Partition using OVER(PARTITION BY)
In the following query, why is it that we have to limit the results returned from each Partition by using the clause WHERE foo.row_num < 3 outside of the subquery foo but not from within the ...
2
votes
2answers
110 views
QGIS PostGIS Authentication Failure with “trust” option
I'm trying to setup a PostGIS db using PostGreSQL 9.1 on Ubuntu 12.04. I've set up the database, created a user account "jay" with no password, added spatial functionality following section 2.5 here, ...
0
votes
0answers
57 views
Migrate PostGIS geometry data to SQL Server spatial data
I am trying to migrate PostGIS geometry to SQL Server Spatial data. Which ETL I have to use?
It's the first time I'll work with SQL Server spatial features.
Thanks for any help
4
votes
1answer
118 views
Troubleshooting Postgresql spatial query failure. Next steps?
We have a set of spatial queries that are failing and I'm struggling with troubleshooting them. I suspect that we're running into some bug, but I'd like to nail things down a bit better so as to be ...
4
votes
1answer
1k views
Install PostGIS v2 for PostgreSQL v9.2
I have installed the latest stable version of PostgreSQL v9.2 and I want to install the PostGIS v2 extension.
I've been searching for it for 3 days now, however can't find it.
I did however find ...
4
votes
2answers
334 views
Pros and Cons of virtualisation technology for database-server and datastorage
Yesterday we had a chat about performance and restorability and I realized how many good things a virtualisation environment can bring to me - but as I'm a little sceptic concerning performance I'm ...
