Tagged Questions
0
votes
1answer
31 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.
{
...
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 ...
1
vote
1answer
133 views
Quantum GIS returns “Invalid Layer” message when trying to add Postgis view
I'm new to Postgis and Quantum GIS. I created a view defined as
CREATE OR REPLACE VIEW pupr.vstudentmuni AS
SELECT m.id AS munid, m.name AS muname, m.geom, s.code,
(s.name::text || ' '::text) ...
2
votes
0answers
64 views
Problem with SPIT (error while importing layers to POSTGIS)
I was attempting to import a polyline roads layer into postgis, using both SPIT in QGIS 1.7 and postGIS GUI for this purpose. I have received errors through both processes as described here:
SPIT
...
2
votes
1answer
158 views
Getting points within a range from a postgres database?
ok so this is query i'm making which returns no result:
SELECT
building.gid
FROM
building
WHERE
ST_Dwithin(building.geom, ST_GeomFromText('POINT(long lat)',4326), 400)
If I run this ...
0
votes
1answer
122 views
Why is the database connection lost on every query?
Every time I started a query the connection with the database is lost. Anyone familiar with this problem?
This problem occurs with various query, for instance:
CREATE TABLE table
SELECT a.*, ...
0
votes
2answers
106 views
dijkstra_sp runs without error in postgres query terminal, but triggers an error in Java
I am running this simple query
select id,gid from dijkstra_sp('roads',22,33)
This works perfectly fine and returns results in postgres query terminal. However running exactly the same query in java ...
0
votes
0answers
725 views
Error when importing shapefile to Postgis database
I was trying to import shp to postgis database and i get the following error:
Importing with configuration: adresy92, public, geom, C:\Users\tomek\Desktop\adresy92, mode=c, dump=1, simple=0, ...
2
votes
1answer
517 views
Why does my PostGIS query fail with “current transaction is aborted”
I'm trying to create a vector layer in a QGIS project using a PostGIS query. QGIS is returning the following error:
Query failed
1 cursor states lost. SQL: CLOSE qgisf1
Result: 7 (ERROR: ...
6
votes
1answer
129 views
PostGIS ERROR: BOOM! Could not generate outside point!
This may be a continuation of a closed thread.
I want to sum the areas of polygons over categories in a large data set (avian species ranges), like this:
select sciname,
...
