Re: [Geoserver-users] SDO_TUNE.EXTENT_OF - Oracle

2013-01-09 Thread cmaul
Hello,

I think I found the problem Oracle 10.2.0.3.0 /Oracle 11.2.0.3.3

SELECT SDO_TUNE.EXTENT_OF('VMPROP.POINT', 'SHAPE') FROM DUAL;

DB features  time
Oracle10 19Mio >30mins and no result
Oracle11 19Mio 0.375 seconds

and guess what? Suddenly Geoserver has no problems finding a bounding box.

Cheers

Christian



-


Dr Christian Maul
Project Manager

Information Services Branch
Department of Sustainability and Environment
Level13, Marland House, 570 Bourke Street
Melbourne 3000

PO Box 500, East Melbourne Vic 3002


Telephone:+61-3-8636 2325
Telefax:  +61-3-8636 2813
--
View this message in context: 
http://osgeo-org.1560.n6.nabble.com/SDO-TUNE-EXTENT-OF-Oracle-tp5025640p5026521.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122712
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] Monitoring WPS on server side

2013-01-09 Thread Martin Davis
The first thing to try is to bump up the logging level, as described here:

http://docs.geoserver.org/stable/en/user/webadmin/server/globalsettings.html#logging-profile

Try VERBOSE_LOGGING for maximum information.

This will let you see the WPS Execute request, the data query(s) made for
it, and the call to the actual process.

On Wed, Jan 9, 2013 at 12:58 PM, Tyler Mitchell
wrote:

> Hi guys,
>
> I'm new to watching tomcat logs, but here goes.  :)
>
> Is there a way to track the WPS processes that GeoServer is receiving from
> my clients and what it does with them?
> My requests are getting stuck somehow.  I'm running the QGIS WPS client
> and will investigate from the client side too, but thought I'd ask
> generally about ability to debug from server side.
>
> Any tips?
> Tyler
>
>
>
> --
> Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
> and much more. Keep your Java skills current with LearnJavaNow -
> 200+ hours of step-by-step video tutorials by Java experts.
> SALE $49.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122612
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>



-- 
Martin Davis
OpenGeo - http://opengeo.org
Expert service straight from the developers.
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 ___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


[Geoserver-users] Monitoring WPS on server side

2013-01-09 Thread Tyler Mitchell
Hi guys, 

I'm new to watching tomcat logs, but here goes.  :)  

Is there a way to track the WPS processes that GeoServer is receiving from my 
clients and what it does with them?  
My requests are getting stuck somehow.  I'm running the QGIS WPS client and 
will investigate from the client side too, but thought I'd ask generally about 
ability to debug from server side.

Any tips?
Tyler


--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] SVG Fill with an ExternalGraphic

2013-01-09 Thread Jonathan Moules
Following my other thread with CSSParameter and SVGParameter and the
revelation there's a SVG 1.0 and 1.1, I've discovered this issue is caused
because the stylesheet is 1.1.0, and apparently GeoServer can't handle
external SVG fills with that version yet.

I converted it to 1.0.0 and it now mostly works, but there's one problem:
One of the key elements I was using was "", which allows you
to offset a fill by a specified number of pixels, but this doesn't appear
to be in 1.0.0. Is there any way around this or is it simply a case of
waiting for that aspect of SLD 1.1 to be implemented into GeoServer?

Thanks,
Jonathan


On 7 January 2013 12:17, Jonathan Moules  wrote:

> Further,
> I've now tried:
>  xlink:href="D:\Geoserver_data\styles\svgs\boulderGeometry.svg"/>
>
> Which fails with:
>
> Parsing failed for href: java.net.URISyntaxException: Illegal character in
> opaque part at index 2: D:\Geoserver_data\styles\svgs\boulderGeometry.svg
>
> -
>
> So I tried with the slashes the other ("wrong") way:
>  xlink:href="D:/Geoserver_data/styles/svgs/boulderGeometry.svg"/>
>
> which fails validation with:
> "Parsing failed for ExternalGraphic: java.net.MalformedURLException:
> unknown protocol: d"
>
> 
> When trying to render the legend on the layers->Publishing page, they both
> fail with the same console error.
>
>
> So I think I've tried every single possible combination and GeoServer
> fails them all. What am I missing?
> Cheers,
> Jonathan
>
>
>
> On 7 January 2013 11:58, Jonathan Moules <
> jonathanmou...@warwickshire.gov.uk> wrote:
>
>> Hi List,
>> I have some polygons I want to be filled with a SVG style. The
>> documentation makes it clear GeoServer supports this:
>> http://docs.geoserver.org/stable/en/user/styling/sld-reference/pointsymbolizer.html#externalgraphic
>>
>> However I'm having issues getting it to work.
>> - I've tried placing the SVG files onto a local web-server and accessing
>> them like that, but all I get in the legend is grey boxes.
>> - Then I placed them into /geoserver_data/styles/svgs - this resulted in
>> a GeoServer console error.
>> - Then I placed them in the styles directory itself, but I still get the
>> GeoServer console error.
>>
>> This page (
>> http://docs.geoserver.org/stable/en/user/styling/sld-extensions/pointsymbols.html#external-graphics)
>> makes it clear that my links are correct (well, maybe not the ./svgs/ one,
>> but it follows convention).
>>
>>
>>
>> My GeoServer error seems to imply it can't find the files:
>>
>> 07 Jan 11:22:41 ERROR [org.geoserver.ows] -
>> org.geoserver.platform.ServiceException: java.io.IOException
>> at
>> org.geoserver.wms.legendgraphic.GetLegendGraphicKvpReader.read(GetLegendGraphicKvpReader.java:163)
>> at
>> org.geoserver.wms.legendgraphic.GetLegendGraphicKvpReader.read(GetLegendGraphicKvpReader.java:54)
>> at
>> org.geoserver.ows.Dispatcher.parseRequestKVP(Dispatcher.java:1405)
>> ...
>>
>> And example of the applicable part of my SLD:
>>
>>   
>> 
>>   
>> 
>>   
>> http://wppgeog3/geoserver/OSMM_SVG_symbols/boulderGeometry.svg"/>
>> image/svg+xml
>>   
>>   3
>>   
>> 3
>> 4
>>   
>> 
>>   
>> 
>> 10,10
>>   
>>
>> This one gives me grey boxes in my legend.
>>
>> --
>>
>> Other URL lines include:
>> > xlink:href="./svgs/boulderGeometry.svg"/>
>>
>> > xlink:href="/svgs/boulderGeometry.svg"/>
>>
>> > xlink:href="boulderGeometry.svg"/>
>>
>> Those three give me the GeoServer error.
>> They also fail GeoServer validation:
>> "Parsing failed for ExternalGraphic: java.lang.IllegalArgumentException:
>> URI is not absolute"
>>
>> But the documentation example includes a clearly relative URI.
>>
>> > xlink:href="%GEOSERVER_DATA_DIR%/styles/svgs/rockFillSymbol.svg"/>
>>
>> Fails validation with:
>> "Parsing failed for href: java.net.URISyntaxException: Malformed escape
>> pair at index 0: %GEOSERVER_DATA_DIR%/styles/svgs/boulderGeometry.svg"
>>
>>  --
>>
>> TL;DR: How do I make SVG Fill work with an ExternalGraphic?
>>
>> Thanks,
>> Jonathan
>>
>
>


This transmission is intended for the named addressee(s) only and may contain 
sensitive or protectively marked material up to RESTRICTED and should be 
handled accordingly. Unless you are the named addressee (or authorised to 
receive it for the addressee) you may not copy or use it, or disclose it to 
anyone else. If you have received this transmission in error please notify the 
sender immediately. All email traffic sent to or from us,  including without 
limitation all GCSX traffic, may be subject to recording and/or monitoring in 
accordance with relevant legislation.
-

Re: [Geoserver-users] SvgParameter versus CSSParameter

2013-01-09 Thread Jonathan Moules
Hi Both,
Thanks for the replies.
  Yup, the spec in question is 1.1.0, as is the SLD.


Martin:
"I'm puzzled by your comment that  fails validation - when
running a trunk version of GeoServer I see the opposite behaviour
(CssParameter validates, but SvgParameter doesn't)."

At least for SLD 1.1.0, on GeoServer 2.2.3, CSSParameter definitely fails,
and SvgParameter passes, so this part of the spec has been implemented.

Cheers,
Jonathan


This transmission is intended for the named addressee(s) only and may contain 
sensitive or protectively marked material up to RESTRICTED and should be 
handled accordingly. Unless you are the named addressee (or authorised to 
receive it for the addressee) you may not copy or use it, or disclose it to 
anyone else. If you have received this transmission in error please notify the 
sender immediately. All email traffic sent to or from us,  including without 
limitation all GCSX traffic, may be subject to recording and/or monitoring in 
accordance with relevant legislation.
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 ___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] SvgParameter versus CSSParameter

2013-01-09 Thread Martin Davis
CssParameter is the element used by the SLD 1.0 spec to supply certain
styling parameters.  In the Symbology Encoding spec (which is basically SLD
1.1.0) this element name was changed to SvgParameter.

(Thanks very much, OGC.  I expect that with the rise in popularity of
CSS, this will be changed back in the next version)

GeoServer mostly implements SLD 1.0, with a smattering of SE 1.1.0.

I'm puzzled by your comment that  fails validation - when
running a trunk version of GeoServer I see the opposite behaviour
(CssParameter validates, but SvgParameter doesn't).


On Wed, Jan 9, 2013 at 9:35 AM, Jonathan Moules <
jonathanmou...@warwickshire.gov.uk> wrote:

> Hi List,
> Going through the SVG stuff, I came across this page:
>
> http://docs.geoserver.org/stable/en/user/styling/sld-reference/textsymbolizer.html?highlight=label#example
>
> which makes it clear that font's require a "" for
> determining font and stuff.
>
> However, this fails in the validator which says it wants SVGParameter,
> which is also what the specification says.
>
> Is there a reason the documentation says "cssparameter"? It does appear to
> work anyway, despite failing the validator and not being in the spec.
>
> Jonathan
>
>
> This transmission is intended for the named addressee(s) only and may
> contain sensitive or protectively marked material up to RESTRICTED and
> should be handled accordingly. Unless you are the named addressee (or
> authorised to receive it for the addressee) you may not copy or use it, or
> disclose it to anyone else. If you have received this transmission in error
> please notify the sender immediately. All email traffic sent to or from us,
> including without limitation all GCSX traffic, may be subject to recording
> and/or monitoring in accordance with relevant legislation.
>
>
> --
> Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
> and much more. Keep your Java skills current with LearnJavaNow -
> 200+ hours of step-by-step video tutorials by Java experts.
> SALE $49.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122612
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>


-- 
Martin Davis
OpenGeo - http://opengeo.org
Expert service straight from the developers.
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 ___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] SvgParameter versus CSSParameter

2013-01-09 Thread Andrea Aime
On Wed, Jan 9, 2013 at 6:35 PM, Jonathan Moules <
jonathanmou...@warwickshire.gov.uk> wrote:

> Hi List,
> Going through the SVG stuff, I came across this page:
>
> http://docs.geoserver.org/stable/en/user/styling/sld-reference/textsymbolizer.html?highlight=label#example
>
> which makes it clear that font's require a "" for
> determining font and stuff.
>
> However, this fails in the validator which says it wants SVGParameter,
> which is also what the specification says.
>
> Is there a reason the documentation says "cssparameter"? It does appear to
> work anyway, despite failing the validator and not being in the spec.
>

The documentation refers to SLD 1.0, which uses cssparameter.
Your SLD is probably using version 1.1 instead, which uses svgparameter for
the same task.
GeoServer supports SLD 1.0 quite well, SLD/SE 1.1 not as well (various
parts are not supported).

Cheers
Andrea


-- 
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 ___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


[Geoserver-users] SvgParameter versus CSSParameter

2013-01-09 Thread Jonathan Moules
Hi List,
Going through the SVG stuff, I came across this page:
http://docs.geoserver.org/stable/en/user/styling/sld-reference/textsymbolizer.html?highlight=label#example

which makes it clear that font's require a "" for determining
font and stuff.

However, this fails in the validator which says it wants SVGParameter,
which is also what the specification says.

Is there a reason the documentation says "cssparameter"? It does appear to
work anyway, despite failing the validator and not being in the spec.

Jonathan


This transmission is intended for the named addressee(s) only and may contain 
sensitive or protectively marked material up to RESTRICTED and should be 
handled accordingly. Unless you are the named addressee (or authorised to 
receive it for the addressee) you may not copy or use it, or disclose it to 
anyone else. If you have received this transmission in error please notify the 
sender immediately. All email traffic sent to or from us,  including without 
limitation all GCSX traffic, may be subject to recording and/or monitoring in 
accordance with relevant legislation.
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 ___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] Timestamp Format

2013-01-09 Thread Rahkonen Jukka
Hi,

Based on own experience, if you do not want to waste your time just cast 
dates/datetimes/timestamps into strings and try to forget that it does not feel 
very elegant.

-Jukka Rahkonen-



Diego M. wrote:

In my app, I use GeoServer to serve my features and OpenLayers as a client.
My data contains dates info in this format: 'yyy-mm-dd hh-mm-ss' but when it
comes from GeoServer, it appears like: 2013-01-08T06:17:37+03:00 !!

How can I change its format?



--
View this message in context: 
http://osgeo-org.1560.n6.nabble.com/Timestamp-Format-tp5026455.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


[Geoserver-users] Timestamp Format

2013-01-09 Thread Diego M.
In my app, I use GeoServer to serve my features and OpenLayers as a client.
My data contains dates info in this format: 'yyy-mm-dd hh-mm-ss' but when it
comes from GeoServer, it appears like: 2013-01-08T06:17:37+03:00 !!

How can I change its format?



--
View this message in context: 
http://osgeo-org.1560.n6.nabble.com/Timestamp-Format-tp5026455.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] SDO_TUNE.EXTENT_OF - Oracle

2013-01-09 Thread Jonathan Moules
Hi

Andrea,
I was thinking that could be in the Oracle driver itself given its an
Oracle specific thing. But don't know how it'd interface with GeoServer
proper.
I'll add a Jira suggestion that the documentation for Oracle reflect it
with a nice big scary warning.
But something in the GeoServer itself seems necessary given it can
literally lock up GeoServer for hours for a sufficiently large dataset.


Davide: Interesting. Nice to see Oracle are being as consistent as ever.
But at least they've kept the useful function.

Jonathan


On 9 January 2013 10:43, Andrea Aime  wrote:

> On Wed, Jan 9, 2013 at 11:28 AM, Jonathan Moules <
> jonathanmou...@warwickshire.gov.uk> wrote:
>
>>
>> Given all of this, would it be worth including a "select count(*) from
>> Table_name" when a user clicks "calculate bounds" on Oracle and warning the
>> user if the feature count is > 100,000 that they should figure their bounds
>> out another way? At least if its using AGGR_MBR. Otherwise courtesy of
>> not-thread-safe, GeoServer admin will be locked up for literally hours if
>> there are millions of features.
>>
>
> Eh, the code there has to be database independent (the code there does not
> really know what data source it is playing against),
> and for PostGIS getting the "estimated bbox" is instant on tables of any
> size, whilst count(*) can take a lot of time on
> large tables (tens of seconds), same goes for SDE, cascaded WFS, SQL
> Server, MySQL and so on.
>
> So the answer is... not going to happen :-)
>
> Cheers
> Andrea
>
> --
> ==
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
> information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054  Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39  339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> ---
>


This transmission is intended for the named addressee(s) only and may contain 
sensitive or protectively marked material up to RESTRICTED and should be 
handled accordingly. Unless you are the named addressee (or authorised to 
receive it for the addressee) you may not copy or use it, or disclose it to 
anyone else. If you have received this transmission in error please notify the 
sender immediately. All email traffic sent to or from us,  including without 
limitation all GCSX traffic, may be subject to recording and/or monitoring in 
accordance with relevant legislation.
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 ___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] hardcoded schemalocation in wfs response

2013-01-09 Thread Andrea Aime
On Wed, Jan 9, 2013 at 11:50 AM, Florent Gravin <
florent.gra...@camptocamp.com> wrote:

> Hi,
>
> Well there is some code in
> https://github.com/geoserver/geoserver/blob/master/src/wfs/src/main/java/org/geoserver/wfs/xml/FeatureTypeSchemaBuilder.java#L369
> that add the wfs schema and put a jar url for wfs.xsd
>
> We made a hack for this but i think geoserver team should have a look
> about this issue.
>

Please open a bug report and attach your patch.

Also, remember that WFS 2.0 + app schema is not an officially supported
combination as far as I know,
in particular, app-schema does not work well with GML 3.2 I believe.
It may take some time to get confirmation, app-schema is developed in
Australia and it's vacation time
over there now.

Cheers
Andrea


-- 
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 ___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] SDO_TUNE.EXTENT_OF - Oracle

2013-01-09 Thread Davide
On Wed, Jan 9, 2013 at 11:28 AM, Jonathan Moules
 wrote:
> I did however discover this page:
> http://support.cs.nott.ac.uk/help/docs/databases/oracle/standard/appdev.101/b10826/sdo_objtune.htm#i857307
> - which states that EXTENT_OF is deprecated (and this is in Oracle 10.1):
>
> "This function is deprecated, and will not be supported in future versions
>
> Which given my statistics seems like a downgrade.

Hi,

In Oracle 11g documentation it's not deprecated anymore, so it seems
they've changed their mind...

http://docs.oracle.com/cd/B28359_01/appdev.111/b28400/sdo_objtune.htm

-- 
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for
more information.
==

Davide Savazzi
@svzdvd
Senior Software Engineer

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax:  +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] hardcoded schemalocation in wfs response

2013-01-09 Thread Florent Gravin
Hi,

Well there is some code in
https://github.com/geoserver/geoserver/blob/master/src/wfs/src/main/java/org/geoserver/wfs/xml/FeatureTypeSchemaBuilder.java#L369
that add the wfs schema and put a jar url for wfs.xsd

We made a hack for this but i think geoserver team should have a look about
this issue.

Cheers



On Wed, Jan 2, 2013 at 11:44 AM, Florent Gravin <
florent.gra...@camptocamp.com> wrote:

> Hi Ben, thanks for your reply.
>
> what GeoServer version are you using? Is this an app-schema type? If so,
>> what is your schemaUri?
>
>
> I'm using Geoserver master branch, and yes it is an app-schema type.
> My schema uri is
> http://inspire.ec.europa.eu/schemas/au/3.0/AdministrativeUnits.xsd(urn:x-inspire:specification:gmlas:AdministrativeUnits:3.0).
>
> Why would you want any sort of WFS import in a WFS DescribeFeatureType
>> response? The response should be a XSD document, and unless your feature
>> types are defined in terms of WFS (which I would find very strange), there
>> should be no use of the WFS schema in the payload information model.
>
>
> I don't really want to have this import, but it is there i haven't
> customized any thing to get this i guess.
> Maybe i could try to remove it but i don't know how to process.
>
> thanks for help
>
> On Mon, Dec 17, 2012 at 4:03 AM, Ben Caradoc-Davies <
> ben.caradoc-dav...@csiro.au> wrote:
>
>> Florent,
>>
>>
>>
>> Why would you want any sort of WFS import in a WFS DescribeFeatureType
>> response? The response should be a XSD document, and unless your feature
>> types are defined in terms of WFS (which I would find very strange), there
>> should be no use of the WFS schema in the payload information model.
>>
>> Clients should never see classpath JAR file references.
>>
>> Kind regards,
>> Ben.
>>
>>
>> On 14/12/12 22:16, Florent Gravin wrote:
>>
>>> Hi,
>>>
>>> If i make a DescribeFeatureType request, in the response, i will have
>>> hardcoded value for the schemaLocation of wfs 2.0
>>>
>>> http://**www.opengis.net/wfs/2.0
>>> "**schemaLocation="jar:file:/**home/fgravin/.m2/repository/**
>>> org/geotools/xsd/gt-xsd-wfs/9-**SNAPSHOT/gt-xsd-wfs-9-**
>>> SNAPSHOT.jar!/org/geotools/**wfs/v2_0/wfs.xsd"/>
>>>
>>>
>>> I would like it to be something like
>>> http://schemas.opengis.net/**wfs/2.0/wfs.xsd
>>>
>>> How could i proceed ?
>>>
>>>
>>> Thks
>>>
>>> --
>>> Florent Gravin
>>> Camptocamp - Chambéry
>>> 047992
>>>
>>>
>> --
>> Ben Caradoc-Davies 
>> Software Engineer
>> CSIRO Earth Science and Resource Engineering
>> Australian Resources Research Centre
>>
>
>
>
> --
> Florent Gravin
> Camptocamp - Chambéry
> 047992
>



-- 
Florent Gravin
Camptocamp - Chambéry
047992
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 ___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] SDO_TUNE.EXTENT_OF - Oracle

2013-01-09 Thread Andrea Aime
On Wed, Jan 9, 2013 at 11:28 AM, Jonathan Moules <
jonathanmou...@warwickshire.gov.uk> wrote:

>
> Given all of this, would it be worth including a "select count(*) from
> Table_name" when a user clicks "calculate bounds" on Oracle and warning the
> user if the feature count is > 100,000 that they should figure their bounds
> out another way? At least if its using AGGR_MBR. Otherwise courtesy of
> not-thread-safe, GeoServer admin will be locked up for literally hours if
> there are millions of features.
>

Eh, the code there has to be database independent (the code there does not
really know what data source it is playing against),
and for PostGIS getting the "estimated bbox" is instant on tables of any
size, whilst count(*) can take a lot of time on
large tables (tens of seconds), same goes for SDE, cascaded WFS, SQL
Server, MySQL and so on.

So the answer is... not going to happen :-)

Cheers
Andrea

-- 
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 ___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] SDO_TUNE.EXTENT_OF - Oracle

2013-01-09 Thread Jonathan Moules
Hi All,
  We should rename this the "Oracle lack of appreciate thread". I can
concur that its something of a pain but unfortunately its our "Corporate
solution" though I am pressing for PostGIS, but that'll be a long fight.

Following Christian, I've done my own testing (hence my delayed reply -
look at the numbers and you'll see why ;-) ).

https://docs.google.com/open?id=0B22cYd3gwE-6MkRfdlp6VFNOZjQ

My own EXTENT_OF speeds were *much* faster than yours Christian - in fact I
found the exact opposite linear progression (gets faster for larger
datasets). Even for ~20million features it only took ~60 seconds. I
honestly don't know why mine is so much faster.
Of course, my AGGR_MBR times were utterly dismal in comparison. You'll see
that features per second is fairly consistently slow with AGGR_MBR.
There's also the issue of load; when using AGR_MBR, it uses a fair amount
of CPU resources on the box (there's nothing else running on that box).

-

I tried to investigate what the difference was between EXTENT_OF and
SDO_AGGR_MBR but that doesn't seem to be documented anywhere I can find.
I did however discover this page:
http://support.cs.nott.ac.uk/help/docs/databases/oracle/standard/appdev.101/b10826/sdo_objtune.htm#i857307-
which states that EXTENT_OF is deprecated (and this is in Oracle
10.1):

*"This function is deprecated, and will not be supported in future versions
of Spatial. You are instead encouraged to use the SDO_AGGR_MBR function,
documented in Chapter 14, to return the MBR of geometries. The
SDO_TUNE.EXTENT_OF function is limited to two-dimensional geometries,
whereas the SDO_AGGR_MBR function is not."*


Which given my statistics seems like a downgrade.

Ourselves we don't really use any of the spatial functions of Oracle beyond
SDO_FILTER (which is the intersect) - all of that analysis is done client
side, so speed hasn't been an issue.

---

Given all of this, would it be worth including a "select count(*) from
Table_name" when a user clicks "calculate bounds" on Oracle and warning the
user if the feature count is > 100,000 that they should figure their bounds
out another way? At least if its using AGGR_MBR. Otherwise courtesy of
not-thread-safe, GeoServer admin will be locked up for literally hours if
there are millions of features.

Jonathan

On 8 January 2013 10:19, Paolo Crosato wrote:

> Il 08/01/2013 07:18, cmaul ha scritto:
> > Jonathan,
> >
> > I was never able to define large datasets in Oracle letting Geoserver
> find
> > the bounding box and thought it is a Geoserver problem but it is not.
> >
> > As you said and Andrea confirmed in the background on the oracle level it
> > must be one of these commands:
> >
> > SELECT SDO_TUNE.EXTENT_OF('TABLE_NAME', 'SPATIAL_COLUMN') FROM DUAL;
> > or
> > SELECT SDO_AGGR_MBR(SPATIAL_COLUMN) FROM TABLE_NAME;
> >
> > Running the SDO_TUNE.EXTENT_OF on a dataset with 3.3 million features I
> gave
> > up after 15 mins.
> > Trying the command with smaller datasets I get the following numbers.
> > secs  feature numbers
> > 1.6   935
> > 1.9   3700
> > 7.6   28000
> > 30.25 105000
> >
> > Sort of  linear increase and atrocious performance. The 'SDO_AGGR_MBR' is
> > even worse. So, I get the BBox from ArcSDE and hack it in by hand which
> > infuriates me, because I think a decent spatial database should work on
> its
> > own resources.
> > Geoserver is 2.1.3 and all the tables have spatial indices.
> > Anything I might do wrong with the DB or any solutions for that?
> >
> > Cheers
> >
> > Christian
>
> Hi,
>
> I made a short comparative study about usage of Oracle Spatial for a
> rather large dataset we are planning to use, about 100k features with .
> I tested the both bounding box, aggregate and intersection function over
> the whole dataset. It turned out performances on the db side were
> unacceptable, even on a fairly good workstation (2 quad core xeon procs,
> 32G ram and SAS hds).
> I had to skip Oracle in favour of PostGIS, the performances on my quad
> core development pc are order of magnitudes better.
> I can confirm it's not a Geoserver issue, the same Geoserver that was
> sluggish on Oracle Spatial became blazing fast when hooked to Postgres.
> I don't know if Oracle Spatial performances get better on big mainframes
> or racs, if you can afford them.
>
> Regards,
>
> Paolo
>
> --
> Paolo Crosato
>
>
>
>
> --
> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
> and more. Get SQL Server skills now (including 2012) with LearnDevNow -
> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only - learn more at:
> http://p.sf.net/sfu/learnmore_122512
> 
___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>


This transmission is intended for the named addresse