0
votes
2answers
28 views

Dealing with custom projections (from prj file) in PostGIS (also GeoServer and OpenLayers)

Basically I want to perform spatial queries like distance calculations in PostGIS using data from shapefiles with different projections, some of which have no SRID code that I can find and also which ...
0
votes
1answer
23 views

Issues ST_MakePoint in PostGIS with Geoserver

I am trying to setup a GIS system to use PostGIS and Geoserver. I have loaded all of the data into a table. The data that is received has long/lat coordinates in Degrees, Minutes, Seconds, Direction, ...
0
votes
0answers
37 views

Editing PostGIS data in ArcGIS Desktop?

Quick question regarding editing PostGIS data in ArcMap 10.0. Far as I can tell, this can only be accomplished through third-party plugins like GISSquirrel or ST-Links. Does anyone know of an ...
0
votes
1answer
34 views

geoserver and overlapping multipolygons from postgis

What does geoserver do when you get a result set from a postgis layer that contains multiple Geoshaps (of type multipolygon) that overlaps the same area? Does geoserver add the two overlapping values ...
0
votes
1answer
24 views

SLD function/transformation based on table values

I'm trying to accomplish an apparently simple task, to display some lines from a postgis table, but I don't know how to do it. The table has, say, 3 fields, one for the geometry and the other two have ...
0
votes
0answers
50 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: ...
2
votes
1answer
29 views

OpenGeo/Geoserver: can I have a store that access more than one PostGIS schema?

I have an existing PostGIS database that I use with QGIS. I am now looking at options for getting some of this data up on the web. Hence OpenGeo. I have Geoserver installed and running and have ...
1
vote
1answer
43 views

PostGIS views vs WFS Filtering operations on PostGIS table

In what use cases should I prefer writing PostGIS views for filtering datasets versus filtering with WFS filter encoding operators and vice versa? In both cases I would be serving the data via ...
-3
votes
1answer
69 views

Is it possible to access geoserver wfs layer from localhost:8080 in to web application? [closed]

I want to add a WFS layer. I am trying to get WFS layer from localhost:8080 geoserver. but I am getting eoserver DateLineWrap in Openlayers.js file...
0
votes
0answers
20 views

Installing PostGis / GeoServer in Mac OSX

On a Mac Server I am working to setup the ports. My understanding is that there is a system instance of PostgreSQL running and then a geoserver instance. Version is 10.7.5. I need help approaching ...
1
vote
1answer
59 views

Geoserver OSM data Imported via osm2pgsql - most efficient tables to use to style roads

The Osm2pgsql importer for OSM data to Postgres results in two tables for ways, one called planet_osm_roads and a second one called planet_osm_lines The Osm2pgsql documentation states that the ...
0
votes
0answers
26 views

How to register geometries using OpenLayers and GeoServer in PostGIS?

I put a Editing Toolbar on my page using Google Maps Api as base layer. I want to register lines and points in PostGIS. But I want to know how I can get the longitude and latitude of gemotria (line ...
1
vote
1answer
85 views

storing date range in PostgreSQL/PostGIS for time parameter in WMS/WFS

Using GeoServer I want to deliver some objects/features with WFS and WMS. The objects and their attributes have a date range during which they are valid. Say, we have street lamps and each street lamp ...
0
votes
0answers
48 views

Error adding Geoserver store from PostGIS

I cant get a connection up when creating a PostGIS-store. Geoserver is running fine on IP:80/geoserver. PostGIS is running and working fine with psql commands Created database/table 'mydb' and ...
4
votes
1answer
124 views

Configuring Geoserver to use a specific postgis geometry column as the default

I have a PostGIS table with two geometry columns, both multipolygon but one with SRID 4326, the other 3857. When publishing the table in Geoserver, I realize that Geoserver defaults to using the first ...
1
vote
0answers
60 views

Geoserver WFS Fails to Load in OpenLayers

I'm working with Postgis->Geoserver->openlayers on localhost. I followed a Geoserver tutorial to import some nyc sample data into my postgres/postgis database and link it to Geoserver. The layer ...
2
votes
1answer
125 views

System requirement specification for Big Data Postgesql, PostGIS, and GeoServer based service

I want to start a GIS portal for around 3000-5000 visitors per day. MY database will be of an approximate size of 10 Terrabytes. The maps and layers are moderately complex, satellite-map overlay is ...
0
votes
1answer
48 views

Increase Map Availability in Geoserver [duplicate]

I have an application which access same map from two geoserver using loadbalancing concept the map is accessed using WMS service. where the two geoserver connected to a single same POSTGIS database. ...
0
votes
2answers
151 views

GeoServer create layer from PostGIS (data type point)

(Several days ago a user on gis stackexchange suggest that I should use OpenGeo (I was using geojson before). I succeed at what I was doing at that time, but now I have a different problem.) I was ...
2
votes
2answers
177 views

Postgres Log Error

I am using Geoserver + GeoWebCache + Postgres for an application. On the application side there is no bugs but on postgres I am getting this log. Please explain and help me to solve this ...
0
votes
0answers
71 views

Create Image Mosaic JDBC datastore in command line

I would like to publish raster from PostGIS database, and I found this tutorial http://docs.geoserver.org/2.1.4/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html , everything works fine, ...
0
votes
0answers
97 views

ECW files to geoserver 2.4

I'm trying to add .ecw files (20 orthophotos) to geoserver 2.4. Geoserver is running on an ubuntu 12.4. Vserver. I'v already installed the GDAL plugin. Is this the right format for the ...
0
votes
1answer
40 views

Installing Cartaro using Acquia Dev Desktop and and link it with GeoServer and PostGIS

How do i configure GeoServer and PostGIS so that I dont get the following error when installing Cartaro using the Acquia Dev Desktop. I am just installing Cartaro locally for testing. Or how can ...
0
votes
0answers
52 views

error GT_PK_METADATA doesn't exist

I keep getting this error message in the Postgres error log. STATEMENT: SELECT * FROM public.GT_PK_METADATA WHERE 1 = 0 ERROR: relation "public.gt_pk_metadata" does not exist at character 15 I'm ...
0
votes
0answers
72 views

Admin Sample GXP Viewer

I have Geospatial application which is using GXP, GeoServer, GeoExt and PostgisSQL. We would like to enhance the application by adding a user friendly Admin system, similar to what GeoNode has. This ...
0
votes
1answer
45 views

How to add Routing Table Query-Result on pgrouting?

I've followed the pgrouting latest workshop http://workshop.pgrouting.org. I wanted to know how to add the routing table query-result into my webpage directly after the route showed up? regards
1
vote
1answer
357 views

Publishing OSM data in GeoServer that has been imported into PostGIS

I'm trying to publish data on GeoServer. I'm using Postgres/PostGIS and I've used osm2pgsql to load the data into the database. I've configured a store correctly (I can see the tables from the ...
0
votes
0answers
166 views

Populate feature grid with database query results Using JSON, JSP

I convert database query result into json format.But this json data not populate on feature grid, Not showing any errors.not able to understand the error.please tell me what is wrong with this code I ...
0
votes
0answers
41 views

Why CQL DWITHIN returns different result than PostGIS DWITHIN?

I have 2 tables in PostGIS that I publish to geoserver. both have same SRS (2039). When I do the following query in PostGIS , I get 69 results : SELECT a.gid,b.gid FROM Table_A a INNER JOIN ...
2
votes
1answer
78 views

pgRouting and Openlayers error when insert controls variable

I've got another problem here :( I'm following the foss4g_w12 tutorial for building a pgRouting WebApp using openlayers, everything goes well until I added the following statement to my code: ...
2
votes
0answers
135 views

Publish existing table from postgis to geoserver

I would like to know if there is any way for publishing existing table from postgis to geoserver using Geoserver REST API or geoserver-manager java implementation. The thing is that i'm actually ...
1
vote
1answer
75 views

Why ST_SRID cause Geoserver generated SQL query to run about 500x slower?

When investigating why Geoserver was so slow to render my WMS tiles from a POSTGIS database I found that the following Geoserver generated SQL query run almost 500x faster when remplacing the ...
2
votes
1answer
142 views

Geoserver configuration for large layers

I'm having problem with geoserver configuration. Currently I'm running geoserver 2.4 on CentOS and Tomcat 6 with 24 cores CPU and 48 GB RAM. I have uploaded 4 layers to PostGIS (PostgreSQL 9.3/PostGIS ...
0
votes
1answer
537 views

How to resolve Geoserver ERROR: Operation on two geometries with different SRIDs

I am working on Geoserver Version 2.4.2 . I have one layer 'beat' in postgresql database. I have publish layer in geoserver but its not opening OpenLayers layer preview link. It gives error as ...
0
votes
1answer
97 views

What can cause Geoserver to deliver a WMS tile so slowly?

I have a PostGIS database with a table containing about 300 000 simple polygons (table has spatial index). I have a Geoserver installed on the same server delivering this table with WMS. I have a ...
1
vote
1answer
482 views

Geoserver sql view using an external sql query?

I am trying to figure out a way of producing a view of a layer in GeoServer, using an external sql query. By external I mean, for instance, a user defined query in a php from where all the parameters ...
2
votes
1answer
119 views

Separate a polygon in different polygons depending of the distance to another polygon

I have a reference polygon "R", and others polygons (in grey). I want to separate each grey polygon in multiple polygons, depending on the distance to R with different Buffers : - The red line is R ...
1
vote
1answer
49 views

High number of unique user defined views

We're just at the stage of starting to developing a GIS application accessible through a web front end. We're thinking of using the boundless stack which includes GeoServer and PostGIS. One of our ...
1
vote
2answers
129 views

Editing vector data over the net: WFS or PostGIS?

I'm using QGis to update the attributes of a large vector dataset (~20,000 polygons) stored in PostGIS. I'm going to have to do that to other large datasets so the idea is to bring in more people, ...
0
votes
0answers
36 views

How do I convert MULTIPOLYS into LINESTRINGS in PostGIS

I have a table with a geom column as a geometry(MULTIPOLYGON) I would like to create an additional column of type geometry(LINESTRING) How can I do this using a PostGIS Query? I need to be able to ...
0
votes
0answers
38 views

Django application “GeoNode” gives message “DLL load failed” on windows

I'm trying to install GeoNode which is a Django application on windows through these simple steps on this page. I've reached a point where is the GeoNode is installed and I've created my postgres ...
0
votes
1answer
245 views

GeoServer not reading bounding box from PostGIS geometry correctly

We are using GeoServer (tried on version 2.2 and 2.4) to render WMS with a PostGIS (version 1.5) data store. We set up the geometry field with all the appropriate constraints and validated/cleaned ...
0
votes
0answers
69 views

import tile into PostGIS through java dll

i have used this command to import tiles from directory to postgis data base but it show error in command line please help me if any one know ?. thank advance to share knowledge C:>java -jar ...
0
votes
0answers
788 views

Postgresql Connection issue “unexpected EOF on client connection”

I'm using Tomcat, Apache (for Load Balencing),OpenLayers - 2.11,GeoServer 2.13, ExtJS 3.4, PostgreSQL 8.4,PostGIS 1.5 and Java for developing GIS based web applications. I have 2 Server. Server1 ...
1
vote
0answers
60 views

How to get from GeoServer a KML of the external boundary of several areas

I have a GeoServer with PostGis database. PostGis database has a table with small geographic areas (English LSOAs and output areas, to be precise), with codes and shapes. I want to submit to ...
1
vote
2answers
232 views

qgis, simplify parcels to share borders

Is there a QGIS plugin or other method that simplifies parcels to share a common line(border)? I'm pretty sure I read about this some time ago. Couldn't find anything here or elsewhere. I'd like to ...
0
votes
1answer
74 views

PostGIS select sites within buffer

I have a WMS query (GeoServer) that returns info from my layer into a popup in Leaflet.JS.However I was wondering how would do this outside of leaflet, i.e. on a standard html/php page. I assume I ...
4
votes
3answers
141 views

how to make web mapping project run (serve map) faster

I'm implementing a project with openlayers 2.12, Geoserver 2.1.3 and PostgreSQL 9.1/PostGIS 2.0 I also use HTML5 Geolocation API and MapQuest's Geocoding API. In the database I have data (osm_line, ...
2
votes
3answers
328 views

How to access qgis, postgis, etc in ubuntu through Amazon AWS

I'm new to programming; however i have been able to read and research the programs i need to set-up for a GIS system. I chose to use Geoserver (as WMS) Postgresql, postgis, Qgis and Openlayers. I am ...
2
votes
1answer
198 views

GeoWebCache seed task dies immediately after being submitted

The data comes from Geofabrik's Brazil slice: http://download.geofabrik.de/south-america/brazil.html Imported into a PostGIS DB with osm2pgsql. GeoServer is 2.4.0, running on latest Tomcat 7.0.x, on ...