Re: [Geoserver-users] Parametric view (Oracle) layeris very slow even though the query is fast

2012-05-16 Thread Andrea Aime
On Tue, May 15, 2012 at 9:05 PM, cheesybiscuits thomaschrist...@gmail.com wrote: I have a layer defined in GeoServer which uses a parametric view to Oracle (11.2.0.1, with Locator capabilities). The query I use to define the view is not particularly complex and when I run it directly against

[Geoserver-users] Weblogic 12c + ArcSde + JNDI

2012-05-16 Thread GeoUser
I tried the combination (Weblogic 12c + ArcSde + JNDI) and it's not working, giving the exception: *Error creating data store, check the parameters. Error message: Unknown JNDI resource on path jdbc/geoserverSdeDS. Expected one of [org.geotools.arcsde.session.ArcSDEConnectionConfig,

Re: [Geoserver-users] WFS 1.1.0 getFeature request not working

2012-05-16 Thread Ian Turton
On 16 May 2012 02:55, Ben Caradoc-Davies ben.caradoc-dav...@csiro.au wrote: Ian, that is GML 2 (gml:outerBoundaryIs). The original example (with gml:exterior) appears to be GMl 3.1. I *knew* I should have gone and looked it up instead of guessing. :-) Ian

[Geoserver-users] From the trenches - MSSQL spatial and ArcSDE

2012-05-16 Thread Ragnvald Larsen
We are keeping around 75.000 spatial objects in a MSSQL Spatial database. Simple features - just squares in a grid system. Our geoserver defined layers combine the spatial data through joins from rather big tables (2.500.000 and 2.100.000) through various parameters. We connect to the Microsoft

Re: [Geoserver-users] From the trenches - MSSQL spatial and ArcSDE

2012-05-16 Thread Andrea Aime
On Wed, May 16, 2012 at 10:49 AM, Ragnvald Larsen ragnvald.lar...@dirnat.no wrote: We expect a fair number of users on our system and are now doing some capacity testing. Currently it looks like one wms-request takes around 6 seconds to process for the whole area. The SQL operation for the join

[Geoserver-users] GetFeature Request extremly slow

2012-05-16 Thread markusin
Hello I am trying to run a WFS request of a layer with type point geometry. The request I invoke within Openlayers using Control.GetFeature. The layer is stored in Oracle Spatial (or PostGIS). Spatial index is set. The request that shows me firebug is: It is very strange that this request takes

Re: [Geoserver-users] WFS 1.1.0 getFeature request not working

2012-05-16 Thread Muir, Christopher
Ian Thanks for your response. I have amended the request to use gml:outerBoundaryIs rather than gml:exterior, and now the response from GeoServer is: ?xml version=1.0 encoding=UTF-8? wfs:FeatureCollection numberOfFeatures=0 timeStamp=2012-05-15T16:03:52.352Z

[Geoserver-users] Problems in wms request by openlayers

2012-05-16 Thread Carlo Pelliconi
Hi all, I'm new with Geoserver. I've installed it, on Debian, and inserted a new layer (call it cat_layer_layername), from shapefile, insiede a new workspace (call it Various_shp). When I enter admin panel, I can correctly see Openlayers preview of cat_layer_layername. BUT when I

[Geoserver-users] Problems with ImageMosaik plugin

2012-05-16 Thread Michele Mastrogiovanni
Hi guys, I have geoserver 2.1.3 with three image mosaik layers mounted together in a layer group one over another with some transparente areas that does not work. Each layer is a satellite image at different resolution. zoom 200k - show layer 1 zoom = 200k - show layer 1 and 2 (2 is upper

Re: [Geoserver-users] GetFeature Request extremly slow

2012-05-16 Thread Andrea Aime
On Wed, May 16, 2012 at 11:00 AM, markusin markus.innereb...@inf.unibz.it wrote: Hello I am trying to run a WFS request of a layer with type point geometry. The request I invoke within Openlayers using Control.GetFeature. The layer is stored in Oracle Spatial (or PostGIS). Spatial index is set.

Re: [Geoserver-users] Problems in wms request by openlayers

2012-05-16 Thread Alessio Fabiani
I guess you are missing the definition of extents and resolutions of the map. I kindly suggest you to open the GeoServer preview page, take a look at the source HTML. You will be able ti find in there the correct setup of an OpenLayers client which you can customize further lately. Regards,

Re: [Geoserver-users] Problems with ImageMosaik plugin

2012-05-16 Thread Alessio Fabiani
Hello Michele, in your case for each mosaic you need to take into account two specific Coverage Parameters: InputTransparentColor and OutputTransparentColor. The first one allows you to avoid overlapping of non-transparent areas between the tiles of the same mosaic. The second one allows you to

Re: [Geoserver-users] JAI problem

2012-05-16 Thread Alessio Fabiani
You need to tweak a bit the configuration options of your Tomcat. Please refer to this blogpost for the full solution and explanation of the problem http://geo-solutions.blogspot.it/2010/05/fix-geotools-and-geoserver-not-able-to.html Regards, Alessio.

Re: [Geoserver-users] Point markers that straddle tiles

2012-05-16 Thread Edward Mac Gillavry
Tom, Not something related to GeoServer, but your tiling engine. Check out whether you can specify an extra gutter/buffer around the meta-tiles that you request from GeoServer. The exact parameter depends on your tiling engine. Also check out

Re: [Geoserver-users] Point markers that straddle tiles

2012-05-16 Thread David Winslow
GeoServer takes measures to automatically buffer WMS requests to avoid these sorts of issues but they don't always work depending on your style. Sometimes adding an explicit Size tag even when you want to use the image's native size helps. Additionally, if you can configure your client to

Re: [Geoserver-users] GetFeature Request extremly slow

2012-05-16 Thread Andrea Aime
On Wed, May 16, 2012 at 3:49 PM, Markus Innerebner markus.innereb...@gmail.com wrote: Hum. no, the thing is, the query plan generated by Oracle for prepared statements assumes often assumes using the spatial index is efficient, but in case you're asking for the whole dataset a sequential scan

Re: [Geoserver-users] Point markers that straddle tiles

2012-05-16 Thread Andrea Aime
On Wed, May 16, 2012 at 3:08 PM, David Winslow dwins...@opengeo.org wrote: GeoServer takes measures to automatically buffer WMS requests to avoid these sorts of issues but they don't always work depending on your style.  Sometimes adding an explicit Size tag even when you want to use the

Re: [Geoserver-users] GetFeature Request extremly slow

2012-05-16 Thread markusin
I realized that, Geoserver is logging this error message for every layer - and not only for the specified layer in the WFS request. I assume this is the reason why it takes so long time. I don't understand if geoserver is complaining about the the answer of the request, or about the request?

Re: [Geoserver-users] Import data using PostGIS connection

2012-05-16 Thread Smaran Harihar
Hi Alex, Ok so I created the Postgres user and password. Now I need to load the shapefiles into the newly created db. I have a script that creates the shapefiles and I wanted those shapefiles to be directly imported into the Geoserver. The best way I found after some amount googling was that I

Re: [Geoserver-users] From the trenches - MSSQL spatial and ArcSDE

2012-05-16 Thread Andrea Aime
On Wed, May 16, 2012 at 5:07 PM, Justin Deoliveira jdeol...@opengeo.org wrote: We have a client who is also benchmarking sql server and finding even with WKB things aren't ideal for them. Basically from what we can tell even though the driver now uses wkb that still involves an expensive

Re: [Geoserver-users] From the trenches - MSSQL spatial and ArcSDE

2012-05-16 Thread Ragnvald Larsen
From a user point of view we look at the performance issue in MSSQL spatial /geoserver as a challenge. Geoserver is good for us, but being able to use it with MSSQL spatial or evenAarcSDE is becoming important. A fair and good PostGIS/MSSQL shootout could be relevant towards developing our

Re: [Geoserver-users] JAI problem

2012-05-16 Thread Michael Smith
Alessio, Thank you for the response, but the solutions in the blogpost did not resolve the issue I was having. I ended up getting it to work by putting hardlinks in the GeoServer WEB-INF directory that pointed to the native JAI files installed in the JDK. The way I had read the documentation

Re: [Geoserver-users] From the trenches - MSSQL spatial and ArcSDE

2012-05-16 Thread Justin Deoliveira
On Wed, May 16, 2012 at 10:36 AM, Andrea Aime andrea.a...@geo-solutions.itwrote: On Wed, May 16, 2012 at 5:07 PM, Justin Deoliveira jdeol...@opengeo.org wrote: We have a client who is also benchmarking sql server and finding even with WKB things aren't ideal for them. Basically from what

Re: [Geoserver-users] PointSymbolizer anchor

2012-05-16 Thread Hailey Eckstrand
After reading the docs a bit more, I found that the tag Label must be used with TextSymbolizer, so I've added that into my SLD. However, I am still getting no points from this layer showing up on my map. I've included the latest SLD below.. any help would be really appreciated! Thanks, ?xml

Re: [Geoserver-users] Import data using PostGIS connection

2012-05-16 Thread Ben Caradoc-Davies
GDAL ogr2ogr can read a shapefile and write directly into a PostGIS database: http://www.gdal.org/ogr/drv_shapefile.html http://www.gdal.org/ogr/drv_pg.html shp2pgsql (distributed with postgis) converts a shapefile into SQL: http://www.postgis.org/documentation/manual-1.3/ch04.html#id2571948 It