Re: [Geoserver-users] App-Schema: Inheritance question

2013-10-09 Thread Rini.Angreani
Hi, Ben is quite right. The id ordering is used to handle multivalued properties. If idExpression is missing, it will order by primary key. If you don't want it to select "v_super_class"."sub_id", then perhaps you can set idExpression to map to another column. http://docs.geoserver.org/latest/en

Re: [Geoserver-users] App-Schema: Inheritance question

2013-10-09 Thread Ben Caradoc-Davies
Please keep discussions on list. I am not sure; I speculate that this is used for multivalued properties or denormalised tables (in the absence of joining). Perhaps Rini can explain? Kind regards, Ben. On 10/10/13 11:59, snuffy wrote: > Hello Ben, > > Was hoping you could explain why app-schem

Re: [Geoserver-users] Point Data in X,Y Fields in RDBMS

2013-10-09 Thread Ben Caradoc-Davies
Jerry, here are some instructions describing how a colleague used workarounds and CLR extensions to enable the delivery of spatial information with GeoServer and SQL Server 2005: https://www.seegrid.csiro.au/wiki/Infosrvices/GeoserverMsSqlServer2005Connectivity This worked well with WFS for sim

Re: [Geoserver-users] Point Data in X,Y Fields in RDBMS

2013-10-09 Thread osullivj
Andrea Many thanks for the reply. It looks like we might be going to upgrade to SQL Server in the near future so we can use that source directly. However we need an interim solution to get the web mapping app running in the short term (6 months) What do you think of having a scheduled task to ru

Re: [Geoserver-users] Getting geoserver tiles to render faster

2013-10-09 Thread Rodrigo Nascimento Hernandez
Hello Ravyn, Im fairly new to geoserver and openlayers, anyway: Pink tiles are primarly a indication your script cant access the remote (WMS) resource and load its stuff. It can be some error on your code (client side); permission issues on geoserver side or (I guess), missconfigured layers. I

Re: [Geoserver-users] Geoserver: Layer group: "single" in "named tree"

2013-10-09 Thread Jonathan Moules
Hi Frederik, Ah ok, sorry I missed that. I have nested layer groups but haven't needed to do that, but now that I think about it I've not seen such either. Thus I'm not sure if it is possible. Probably a fairly simple feature request if you have some funds to put towards it. Alternately, what ab

Re: [Geoserver-users] Geoserver: Layer group: "single" in "named tree"

2013-10-09 Thread Jonathan Moules
Hi Frederik, Well, I'm not certain based on your reading, but this could potentially resolve it, or at least allow you to group those things entirely separately. Basically you create a new Workspace and put the Layer Groups you want to share into them. Then the URL you use to access them changes

Re: [Geoserver-users] Geoserver: Layer group: "single" in "named tree"

2013-10-09 Thread Frederik Haefker
Hi Jonathan, thanks again for your help. Sadly I don't understand you suggestion ^^ Maybe it helps if I explain the situation in more detail: I have a line layer with precipitation contour lines and another point layers for controlling labels. Both should be seen as one layer for the user. So I

Re: [Geoserver-users] Geoserver: Layer group: "single" in "named tree"

2013-10-09 Thread Frederik Haefker
Hi Jonathan, thanks for your reply. Your solution works for layers. However I am speaking of hiding single layer groups after including it into named tree layer groups. As fare as I know there is no "Advertised" check box in the option menu of single layer groups - or am I missing something?

Re: [Geoserver-users] Geoserver: Layer group: "single" in "named tree"

2013-10-09 Thread Jonathan Moules
Hi Frederik, I can't say as to whether a layer should be listed when a member of a layer group (Andrea?), but the simple solution is to turn off the "Advertised" checkbox (Publishing tab for a layer). That way the layer is still enabled but never listed in response to a GetCapabilities request. Reg

Re: [Geoserver-users] Getting geoserver tiles to render faster

2013-10-09 Thread Jonathan Moules
You might want to try using TMS/WMTS for tile layers. Ideally you could pre-seed them as well; even if not all levels then at least many of them which will improve things. I'm noticing that my own tile rendering is rather slow, but I have a fairly complicated SLD which is probably impeding things.

[Geoserver-users] Geoserver: Layer group: "single" in "named tree"

2013-10-09 Thread Frederik Haefker
Hello everyone, we are using Geoserver 2.4.0 with layer groups. There are some single layer groups (to combine layers which sould not be requested seperately) which are included into named tree layer groups. The layers are displayed via geoext in a GeoExt.tree.LayerContainer via WMSCapabilitie

[Geoserver-users] Character encoding

2013-10-09 Thread Uggla Henrik
I have Geoserver 2.4.0 (war on Tomcat7) installed on Ubuntu 12.04. I've tried to set character encoding to UTF-8 but åäö is still shown wrong when i save the Contact information form. Please help. in WEB-INF/web.xml I have: Set Character Encoding org.vfny.geoserver.filters.SetCharac

[Geoserver-users] Getting geoserver tiles to render faster

2013-10-09 Thread Ravyn
Hi I wandering if anyone can help me with a problem I'm having. I need to get the tiles that geoserver renders to render faster than what it does at the moment. The data that is being used is from a postgresql database on all the layers. There is the main base layer which has 14 tables in it, th

Re: [Geoserver-users] Point Data in X,Y Fields in RDBMS

2013-10-09 Thread Andrea Aime
On Wed, Oct 9, 2013 at 1:19 PM, Jerry O'Sullivan < jeremiahosulli...@gmail.com> wrote: > Stefano > > Thanks..the sql server db is 2005 so I don't have geometry support > available in the db > > The only options I can see are > 1) Install postgres to pull the data from sql server every hour but th

Re: [Geoserver-users] Point Data in X,Y Fields in RDBMS

2013-10-09 Thread Jerry O'Sullivan
Stefano Thanks..the sql server db is 2005 so I don't have geometry support available in the db The only options I can see are 1) Install postgres to pull the data from sql server every hour but th is seems a bit messy but might be the best option if I use geoserver 2) investigate if there is an o

Re: [Geoserver-users] Impact of activating WPS extension

2013-10-09 Thread Andrea Aime
On Tue, Oct 8, 2013 at 9:24 PM, Tom Saul wrote: > I would like to implement a system using the PointStacker functionality, > which requires activating the WPS service. In doing a quick scan I am > not finding a lot of discussion of the security and performance impacts > of adding this to a publi

[Geoserver-users] Impact of activating WPS extension

2013-10-09 Thread Tom Saul
I would like to implement a system using the PointStacker functionality, which requires activating the WPS service. In doing a quick scan I am not finding a lot of discussion of the security and performance impacts of adding this to a public facing system. Can anyone comment on this, or point

Re: [Geoserver-users] Point Data in X,Y Fields in RDBMS

2013-10-09 Thread Stefano Iacovella
Hi Jerry, In Oracle or PostGIS I would create a spatial view converting your textual values to a geometry field. You should use a similar function in SQL Server and then publish the view on GeoServer. Kind Regards, Stefano --- 41.95581N 12.52854E

[Geoserver-users] Point Data in X,Y Fields in RDBMS

2013-10-09 Thread osullivj
Hi I have a SQL Server DB with point data stored in 2 Columns (X,Y) Can these be mapped directly using GeoServer Thanks, Jerry -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Point-Data-in-X-Y-Fields-in-RDBMS-tp5082553.html Sent from the GeoServer - User mailing list arc

Re: [Geoserver-users] WMS GetCapabilities CRS error

2013-10-09 Thread Andrea Aime
On Wed, Oct 9, 2013 at 9:49 AM, Gabriel Vatin < gabriel.va...@mines-paristech.fr> wrote: > Finally, I found why I had such issues with the WMS GetCapabilities, > even with 2.4.0 : the problem comes from the Time Dimension, that is > enabled on 6 layers, 3 being archives on several months of data.

Re: [Geoserver-users] WMS GetCapabilities CRS error

2013-10-09 Thread Gabriel Vatin
Finally, I found why I had such issues with the WMS GetCapabilities, even with 2.4.0 : the problem comes from the Time Dimension, that is enabled on 6 layers, 3 being archives on several months of data. It creates a huge list of time values that are queryable. So actually the GetCapabilities DO

Re: [Geoserver-users] Help on tutorial from Geoserver pages

2013-10-09 Thread Mauro Bartolomeoli
2013/10/8 Rodrigo Nascimento Hernandez > Hello, > > Using a fresh Geoserver 2.4.0 installation: > > Im trying to test the 'J2EE Authentication' following the page > http://docs.geoserver.org/latest/en/user/security/tutorials/j2ee/index.html > but im stuck in the step n. 7 > At this point the page