0
votes
0answers
49 views

Problem inserting feature into GeoServer empty layer via WFS-T

I'm facing a strange issue with GeoServer (2.4) (on PostgreSQL 9.4/PostGIS 2.1). The problem is I am not able to insert a feature via WFS-T if the layer is empty; it returns me the following error: ...
0
votes
1answer
56 views

pg_escape_string() equivalent?

A client is hosting one of my maps on a server that does NOT have a postgres module installed, and will not install it (nor anything else... ) . We have been told also by the site owner that we can't ...
-1
votes
1answer
27 views

The command for find the object

I got error message that shows "Object has more than 1 line in polyline". What is the command to find the object that has more than one line (such as error on number 100) Thank you
0
votes
1answer
446 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
868 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
707 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
2answers
142 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
485 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
196 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
134 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 ...
1
vote
0answers
2k 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
740 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
159 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, ...