Hi,
We have an analogue case, despite that we are using only WFS and not at all WMS
nor SLD.
- We split that Oracle table into three separate updatable views for poinst,
lines and polygons by doing selection according to Oracle GTYPE.
- We publish those three views with Geoserver as three separate WFS feature
types.
- Because the views are updateble WFS-T works also.
- Because there are three WFS-T feature types using only one physical Oracle
table it is necessary to configure the GEOSERVER_METADATA table so that all the
three feature types are taking the fid from the same Oracle sequence in case of
inserts.
I did not really believe it would work when building the system, but it does.
-Jukka Rahkonen-
________________________________
Lähettäjä: [email protected]
[mailto:[email protected]]
Lähetetty: 16. kesäkuuta 2011 18:48
Vastaanottaja: Andrés Maneiro
Kopio: [email protected]
Aihe: [Geoserver-users] Antwort: Re: Antwort: Re: Geoserver 2.1: SLD Rendering
with mixed geometry types on Oracle data
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/>
> <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
