Hi ameinero,
thanks for your suggestion, but unfortunately there is ONE geometry column
in my table (should be written via WFS-T in a second step) with possible
different geometry types in it. All the different geometry types belong to
one business logic entity. Due to that filtering by different scales isn't
an option either.
Mit freundlichen Grüßen / Best regards
Thorsten Müller
Software Ingenieur / Software Engineer
Mettenmeier GmbH Utility Solutions
Von: Andrés Maneiro <[email protected]>
An: [email protected]
Datum: 16.06.2011 13:18
Betreff: Re: [Geoserver-users] Antwort: Re: Geoserver 2.1: SLD
Rendering with mixed geometry types on Oracle data
Hello Thorsten,
as a wild guess: do you have separate geometry columns in the same table?
If so, what I did -and it's working- is not using ogc:filter but
filtering by scale rendering. I mean, from 1:100000 to 1:25000 render
the point geometry and higher than that render the polygon geometry.
Your SLD should look like more or less like: http://pastebin.com/yVehjiGm
best,
amaneiro
On 16/06/11 12:22, [email protected] wrote:
> Hi Andrea,
>
> thanks for your quick answer but I don't get it. I already build a SLD
> based upon your recommended documentation. The question is: Why is a
> polygon geometry (from Oracle DB) rendered as a point AND as a
> linestring AND as a polygon at the same time, although sld rules are
> splitted with ogc:filter dealing with geometryType? My expected
> behaviour would be that if geometry is a polygon, rule with geometryType
> = Polygon is rendered only. Same if geometry is a linestring , rule with
> geometryType = LineString is rendered only and so on.
>
> Am I misunderstanding the whole Rule-Filter -Stuff?
>
> Mit freundlichen Grüßen / Best regards
>
> Thorsten Müller
> Software Ingenieur / Software Engineer
> Mettenmeier GmbH Utility Solutions
> Klingenderstr. 10-14, D-33100 Paderborn, Germany
> Tel. +49 (0)52 51 - 1 50- 3 85; Fax. +49 (0)52 51 - 1 50- 3 66
> mailto:[email protected]
> http://www.mettenmeier.de <http://www.mettenmeier.de/>
>
>
>
>
> Von: Andrea Aime <[email protected]>
> An: [email protected]
> Kopie: [email protected]
> Datum: 16.06.2011 11:58
> Betreff: Re: [Geoserver-users] Geoserver 2.1: SLD Rendering with mixed
> geometry types on Oracle data
> ------------------------------------------------------------------------
>
>
>
> On Thu, Jun 16, 2011 at 11:23 AM, <[email protected]_
> <mailto:[email protected]>> wrote:
> Dear list,
>
> I run into problems (see this Screenshot
> _http://www.filedropper.com/strangerenderinggeoserver_) while trying to
> display Oracle data with mixed geometry with following SLD. This SLD (
> see at bottom ) is based upon documentation at
>
_http://docs.geoserver.org/stable/en/user/styling/sld-tipstricks/mixed-geometries.html_.
>
> The geometries are bound with Oracle NG to Geoserver and are defined in
> Oracle DB as:
>
> Polygon:
>
MDSYS.SDO_GEOMETRY(2003,25833,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(398402.88570754,5821424.7206982,397309.27518698,5820578.0544888,398297.05243136,5820119.4436253,399531.77398683,5820754.4432824,398402.88570754,5821424.7206982))
>
> Linestring:
>
MDSYS.SDO_GEOMETRY(2002,25833,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1),MDSYS.SDO_ORDINATE_ARRAY(393569.83276183,5822871.1088061,394575.248885575,5823153.33087592,395086.776387131,5821848.05380299,393710.94379674,5821459.998457))
>
> point (i.e.):
>
MDSYS.SDO_GEOMETRY(2001,25833,MDSYS.SDO_POINT_TYPE(396603.72001242,5821742.2205268,NULL),NULL,NULL)
>
> As you can see at the screenshot it seems that i.e. a polygon geometry
> is rendered as a point, linestring AND polygon?
>
> Does someone know about some problems here? Is something wrong with my
> SLD or my definition of geometries?
>
> Any help, idea or mental support would be appreciated :-)
>
> Look no further than the documentation, this case is explained there:
>
_http://docs.geoserver.org/stable/en/user/styling/sld-tipstricks/mixed-geometries.html_
>
>
> Cheers
> Andrea
>
>
> --
> -------------------------------------------------------
> Ing. Andrea Aime
> GeoSolutions S.A.S.
> Tech lead
>
> Via Poggio alle Viti 1187
> 55054 Massarosa (LU)
> Italy
>
> phone: +39 0584 962313
> fax: +39 0584 962313
> _
> __http://www.geo-solutions.it_ <http://www.geo-solutions.it/>_
> __http://geo-solutions.blogspot.com/__
> __http://www.youtube.com/user/GeoSolutionsIT__
> __http://www.linkedin.com/in/andreaaime__
> __http://twitter.com/geowolf_
>
>
-------------------------------------------------------------------------------------------------------------------------------------
> EditLive Enterprise is the world's most technically advanced content
> authoring tool. Experience the power of Track Changes, Inline Image
> Editing and ensure content is compliant with Accessibility Checking.
>
http://p.sf.net/sfu/ephox-dev2dev_______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
> ------------------------------------------------------------------------
>
> Mettenmeier GmbH
> Sitz der Gesellschaft: 33100 Paderborn
> Geschaeftsfuehrung: Ulrich Mettenmeier, Klaus von der Mosel, Dr. Michael
> Fette
> Handelsregister: Amtsgericht Paderborn B 1114
> USt.-ID: DE 811 324 124
> Steuer-Nr.: 339/5873/3133
>
> ------------------------------------------------------------------------
>
>
>
>
------------------------------------------------------------------------------
> EditLive Enterprise is the world's most technically advanced content
> authoring tool. Experience the power of Track Changes, Inline Image
> Editing and ensure content is compliant with Accessibility Checking.
> http://p.sf.net/sfu/ephox-dev2dev
>
>
>
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
**********************************************************************************************
Mettenmeier GmbH
Sitz der Gesellschaft: 33100 Paderborn
Geschaeftsfuehrung: Ulrich Mettenmeier, Klaus von der Mosel, Dr. Michael Fette
Handelsregister: Amtsgericht Paderborn B 1114
USt.-ID: DE 811 324 124
Steuer-Nr.: 339/5873/3133
**********************************************************************************************
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
