3
votes
1answer
45 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
35 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
80 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
35 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
0answers
63 views

How to add a Geoserver WFS layer with data imported from PostGIS to OpenLayers?

I know that there are very similar answers to my question but I just can't find how to solve this problem, so I am wondering if my case is different or if I am doing something wrong here. I am trying ...
0
votes
2answers
77 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
114 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
38 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
44 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
30 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
27 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
45 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
38 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
86 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
147 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
32 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 ...
1
vote
1answer
52 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
87 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
55 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
103 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
258 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
61 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
304 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
93 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
48 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
89 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
27 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
23 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
170 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
49 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
659 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
42 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
161 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
57 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
114 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
261 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
141 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 ...
3
votes
0answers
47 views

Why are date vaules displaying a trailing 'Z' when layers are published with Geoserver and a PostGIS data store?

I have published various layers using Geoserver 2.2.x with a PostGIS 2.0.1 (PostgreSQL 9.1.x) data store. Fields that only have date values and not time/timestamp related values are stored as date. ...
6
votes
1answer
66 views

Geoserver and PostGis output [closed]

I have a peculiar rendering of a small table in PostGis of polygones (imported from a shape file) from Geoserver (layer preview with OpenLayers) The object are just cloned ... Would you give me a ...
2
votes
0answers
26 views

Geoserver Feature Versioning Support

I am creating a map feature editor that supports versioning & rollback using Geoserver as the WFS. From what I've read online, it seems Geoserver supports feature versioning. My question is how ...
1
vote
1answer
38 views

GeoTools Omitting Quotes in its Queries?

I have a table in my PostgreSQL 8.4 with a column 'Shape' of type 'geometry'. When I start up Tomcat my GeoServer throws an exception: 24 Sep 16:20:25 WARN [geotools.jdbc] - Error occured determing ...
1
vote
0answers
54 views

Use bbox in geoserver sql view

I'm doing this sql query using geoservers sql views: SELECT kmeans, count(*), ST_BUFFER(ST_CENTROID(ST_Collect(geom)), qrt(count(*))*1000 ) AS geom FROM ( SELECT ...
2
votes
1answer
38 views

How to generate features to test different implementations of LinearRing?

I have some code that throws the following exception: Points of LinearRing do not form a closed linestring and I want to check if my code is calling this correctly by supplying some features that ...
0
votes
1answer
151 views

Full instruction for download OSM data in Ubuntu 12.04 LTC

Is there instruction for: 1) install software 2) download OSM data in Postgis database 3) set styles 4) generate tiles 5) initilaze MapProxy (all in OS Linux) 6) View map (generated tiles) ...
2
votes
0answers
40 views

Can't connect to WMS service? An Amazon-EC2 problem?

I'm running GeoServer 2.3.5 on a Windows instance in AWS for the first time. The data is on the server in PostGIS. The map layers have been published and I can see them locally without any problems. ...
3
votes
2answers
1k views

Where download sld styles for OpenStreetMap for GeoServer?

I display OpenStreetMap with some sld styles. This map is not the same OSM. I want that this map is equal OSM map. I use geoserver 2.3.5 Does anyone display OSM through MapServer, ArcGisServer ...
0
votes
0answers
63 views

Parameterizing SQL Views Timestamp Issue

Could Someone help me? I am having some difficulties creating KML views. I am trying this SQL: SELECT the_geom FROM lighting.history WHERE stroke_time BETWEEN %inicialtime% and %finaltime% and ...
0
votes
0answers
185 views

GRIB Files as Point Data or Raster in Postgres/PostGis Database and display with Geoserver

This is a conceptual question, trying to establish the best approach to the problem! I have read this post already! I want to be able to update weather data on a 2 or 3 times daily from Grib2 files ...
0
votes
0answers
9 views

Converting Grib Files to a format suitable for Geoserver [duplicate]

What is the best way to display Grib Files in Geoserver dynamically, preferably via Postgres/PostGis.
2
votes
2answers
315 views

finding the correct transformation (from EPSG:31300 to EPSG:4326) or how to store two srid in one table

I have a very specific problem. I have data crossing two coordinate-systems, more specifically: the Netherlands and Belgium. Previously the data was stored in one table in Oracle, using the RD ...