Tagged Questions
0
votes
1answer
38 views
Schema for offline map editing and pass to production environment
I'm working with QuantumGIs and PostgreSQL/Postgis. So when I edit the layers, the changes are reflected on the DB.
The thing is I want to do some "offline" editing before committing the changes to ...
1
vote
0answers
36 views
Determining the SRID of a dataset in PostGIS [duplicate]
Sometimes the dataset provides some information about its projection. For example, it can mention Horizontal_Datum_Name: North American Datum of 1983, Ellipsoid_Name: GRS1980, ...
2
votes
1answer
55 views
point of intersection issues
I have a table containing a set of points of intersections.
Most of the roads intersects whith just one road BUT i have some roads which intersects with two, therefore three different point of ...
4
votes
2answers
145 views
PostGIS stored procedures
I am wondering if there are open source applications that make extensive uses of the special functions (the ST_* stored procedures) provided by PostGIS? I found many apps that support storing map data ...
1
vote
2answers
108 views
mulitlinestring to linestring
I am using postgres with postgis and I have a set of points which I would like to interpolate with a set of lines.
Now my problem is that the set of lines are of type multilinestring.
Is there a ...
2
votes
1answer
125 views
Update query does not affect any rows, privileges are set to public and allow all actions
I've been trying to update a column of integers called level_dept in a table called adminboundaries within the sql query tool on pgadmin3 and the query runs and finishes with a lot of lag, but 0 rows ...
-2
votes
1answer
67 views
How do I set the protocolVersion using the jdbc postgres driver? [closed]
I attempted to concatenate a string to the url parameter of the below in order to set the protocolVersion, but I'm not sure how to keep the string in the url without altering the name of the database, ...
8
votes
2answers
395 views
Postgres/Postgis spatial index - no speed up
I have a spatial table in a postgres/postgis database. Every row in it represents a Polygon. It is of following form:
+----+--------+
|gid | way |
+----+--------+
|241 | 01030..|
The geometric ...
1
vote
0answers
116 views
How do I find the pgAdmin connection parameters?
I need to create a connection from arcmap to pgadmin using a python module because of an arcpy script, but I am unsure of how to get the pgadmin connection parameters. I think it may be some kind of ...
2
votes
1answer
95 views
Finding the Geometry within which a Point falls
I have the following query, which takes on average about 4 seconds. How might one improve the query such that the same response comes back faster?
SELECT * FROM geometries g
ORDER BY
...
2
votes
1answer
285 views
Error creating a spatial database. ERROR : could not load library “/usr/pgsql-9.1/lib/rtpostgis-2.0.so”
I am running PostgreSQL 9.1 with Postgis 2.0 on Fedora 15.
When trying to install the raster support,
psql -d mydb -f rtpostgis.sql -v ON_ERROR_STOP=1
I get the following error
...
5
votes
1answer
2k views
How to create a tables from existing tables (applying new schemas) in postgis DB?
I have a table that is geospatially enabled; that contain world borders. I want to break it down to different schemas (global, europe etc..) . My thought is to use use something that looks like this:
...
7
votes
2answers
7k views
How to insert a point into postgis?
I have created one table in my Postgis. But I can not insert point. I do not know what's wrong with my query?
CREATE TABLE app (
p_id INTEGER PRIMARY KEY
);
SELECT ...
0
votes
0answers
83 views
How to pass in a database created on the fly in code to Quick_Export in arcpy?
So I am trying to programmatically use quick_export through the arcpy package in an arcmap tool, and so I referenced the quick_export tool's dialog box that comes up when it is executing for the ...
11
votes
2answers
705 views
Mixing geometry types in one PostGIS table
I've faced with the following problem. I have to migrate from Oracle database to PostgreSQL+PostGIS. Currently all geometries of all types are stored in one table and each record contains "lid" field ...
