Is the curves support issue only w.r.to the Oracle data store or is it
across all data store formats?
What is the workaround suggested in general in GeoServer?
-Praveen
> Message: 2
> Date: Wed, 27 Nov 2013 09:45:11 +0000
> From: Rahkonen Jukka <jukka.rahko...@mmmtike.fi>
> Subject: Re: [Geoserver-users] Fwd: Missing line segments from Oracle
> data
> To: "'geoserver-users@lists.sourceforge.net'"
> <geoserver-users@lists.sourceforge.net>
> Message-ID:
> <84446def76453c439e9e97e438e13a631f0a0...@suutari.haapa.mmm.fi>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi,
>
> Have a look at SDO_ELEM_INFO of the dropped lines. I guess that the
> features are some sort of curves or compound line strings
> http://docs.oracle.com/cd/B19306_01/appdev.102/b14255/sdo_objrelschema.htm.
> I fear Geoserver does not support those.
>
> -Jukka Rahkonen-
>
> Praveen Rajendra Babu
>
> Hi Jukka,
> Thanks for the detailed response. I will look into your
> suggestions, esp. tracking down the SQL queries. I was trying to find out
> is there any sort of limitation of geoserver in rendering some sort of
> curved lines represented as SDO_GEOMETRY 2002(lines), which is what I could
> see missing.
>
> Regards,
> Praveen
>
> On Wed, Nov 27, 2013 at 6:41 PM, Rahkonen Jukka <jukka.rahko...@mmmtike.fi
> <mailto:jukka.rahko...@mmmtike.fi>> wrote:
> Hi,
>
> It is impossible to say what happens by this information. I would begin
> by capturing the SQL select that is used for reading data from Oracle and
> studying that. You should be able to find it from Geoserver logs if you set
> the logging level to "geotools developer". Or then the Oracle admin can
> gather and send log data for you. When you have the SQL in your hands,
> send it with SQL developer, SQL Plus or whatever tools you are using and
> check if all the linestrings get selected. If yes, you can consider that
> the data side is OK. If some lines are not selected, select the geometries
> by a handwritten SQL and try to find what is special in those. Check at
> least if the geometry type and SRID are the same as for other geometries.
>
> If SQL selects all that you want to render then there can be something in
> the rendering rules that makes that some features are not painted even they
> are selected.
>
> There are often some oddities in real world data. I would suggest to
> import first some simple demo datasets into your Oracle and play first with
> them. Once you can render them nicely you will trust that Geoserver works
> and you will be generally on a much better mood for facing the possible
> troubles with your own data.
> When importing the demo data try to keep things simple:
> - Have a primary key in a column of type NUMBER
> - Don't forget to insert a valid row into USER_SDO_GEOM_METADATA
> - Create a spatial index
>
> -Jukka Rahkonen-
>
> Praveen Rajendra Babu wrote:
>
> Hi,
> Absolutely new to GeoServer, but finding it very interesting by
> comparing to other map servers.
> I am trying to serve line geometry from Oracle database. Some lines are
> rendered and some don't.
> Attaching a screen-shot of how it looks. What is the reason for this
> happening with GeoServer?
> The SDO_GEOMETRY type is 2002 for both the rendered and unrendered lines.
>
> Trying to use any other map servers (like MapGuide) the rendering is fine.
>
> Appreciate some suggestions to try out.
>
> Warm Regards,
> Praveen
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
>
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
