0
votes
0answers
10 views

Working with different source WMS data

I have a geoserver and WMS services on it. For example my water valve layer is point data and published from geoserver. (I am using postgis to saving data.) An external WMS service publishes polygon ...
2
votes
0answers
46 views

Rotation by attribute in Geoserver SLD style

I have a table with field calculated by function: NEW."rotationAngle" := degrees( ST_Azimuth( ST_StartPoint(NEW.the_geom) ...
1
vote
1answer
28 views

Geoserver Postgres Configuration

My imported postgres database size for plane.osm is more than 300GB under slim mode. It added four tables for Tiles Creation. planet_osm_line, planet_osm_road, planet_osm_polygon, planet_osm_point ...
-4
votes
1answer
59 views

What are some use cases for GeoServer? [closed]

I am new to GIS area and am having trouble understanding what GeoServer is. Even after reading their site and the wiki page I am struggling to understand its usage. What does it mean by -- "allows ...
0
votes
1answer
31 views

How to query a PostGIS database through Geoserver and OpenLayers

I've built a web application using OpenLayers, which is connected to my PostGIS database through Geoserver. Now that I'm able to successfully display all of the layers, I'd like to add ...
2
votes
0answers
20 views

GeoServer ImageMosaic PostGIS index update

I use GeoServer where I created an ImageMosaic storage following this manual. When I create new datastore, all *.tif files are indexed into DB (PostgreSQL with PostGIS). How can I create new index in ...
1
vote
1answer
41 views

Do large vertex counts in PostGIS cause performance issues in WMS?

I am wondering if large geometry (geometry with large vertex count) in PostGIS might cause performance issues for GeoServer (or other product) in serving the WMS (not WFS)? This question also ask ...
2
votes
2answers
106 views

Recommended opensource solution for storing, publishing and querying GIS data

Our company has millions of feature classes currently stored through ArcSDE on SQL Server 2008 R2. We are kind of slowly making our way to opensource software. What we want to achieve is to be able ...
0
votes
2answers
46 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
29 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
49 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
38 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
26 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
70 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
30 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
52 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
73 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
26 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
83 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
34 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
108 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
52 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
138 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
67 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
135 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
49 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
168 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 ...
3
votes
2answers
200 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
75 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
115 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
51 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
60 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
1answer
84 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
49 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
441 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
169 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
42 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
91 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
149 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
81 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
154 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
604 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
106 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
565 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
134 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
148 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
45 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
46 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
262 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 ...