'RE: [mapguide-users] Re: Mapguide won't display all features fromKing'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mapguide-users
Subject:    RE: [mapguide-users] Re: Mapguide won't display all features fromKing
From:       "Jonio, Dennis \(Aviation\)" <DJonio () miami-airport ! com>
Date:       2010-10-27 11:56:18
Message-ID: 76213EE4451A2743A355F4F47BD9D1776866BF () s0632238 ! miami-airport ! com
[Download RAW message or body]

[Attachment #2 (unknown)]

Haris,
Apologies for my poor explanation. 
Yes, you did fix gtype=4. Works just fine, DB wise. _MapGuide_ does NOT render 4's. \
It does render the other multi-gtypes = 5,6 and 7.

Like I said, I have always constructed _circle_ objects as \
INFO_ARRY(1,1005,1,1,2,2)'s. I was skeptical from the beginning about Oracles \
_optimized point_ so I make those as INFO_ARRAY(1,1,1) and the Oracle _rectangle_ \
becomes a INFO_ARRAY(1,1003,1,1,2,1) w/all 5 ordinates.  A couple days ago I \
experimented w/Function:  OnCircleDigitized(Circle) {
            r = Circle.Radius;
            p1x = Circle.Center.X + r;
            p1y = Circle.Center.Y + r;

            p2x = Circle.Center.X - r;
            p2y = Circle.Center.Y + r;

            p3x = Circle.Center.X - r;
            p3y = Circle.Center.Y - r;

            p4x = Circle.Center.X + r;
            p4y = Circle.Center.Y - r;

            ords = p1x + "," + p1y + "," + p4x + "," + p4y + "," + p3x + "," + p3y + \
                "," + p2x + "," + p2y + "," + p1x + "," + p1y;
            //tmp = "MDSYS.SDO_GEOMETRY(2003, 2236, NULL, \
MDSYS.SDO_ELEM_INFO_ARRAY(1,1005,1,1,2,2), MDSYS.SDO_ORDINATE_ARRAY(" +  //        \
                ords + "))";
            tmp = "MDSYS.SDO_GEOMETRY(2003, 2236, NULL, \
                MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,4), MDSYS.SDO_ORDINATE_ARRAY("
                    + p1x + "," + p1y + "," + p2x + "," + p2y + "," + p3x + "," + p3y \
+   "))";
            var geometryInput = \
document.getElementById("currentscribblegeometryInput");  geometryInput.value = tmp;
            tmp_control = document.getElementById("sessionName");
            SESSION = tmp_control.value;
            tmp_control = document.getElementById("mapName");
            MAPNAME = tmp_control.value;
            tmp_control = document.getElementById("textForFeature");
            TEXT = tmp_control.value;
            tmp_control = document.getElementById("currentscribbleText");
            tmp_control.value = TEXT;

            MiMethodsMgr.InsertUserSessionFeature(SESSION, MAPNAME, TEXT, 0, \
                geometryInput.value,
                                OnCompleteUserSessionInsertMethod, OnError_Generic, \
OnTimeOut_Generic);  
        }
And found that my _ORACLE circles_ were _Oraclewise_ valid BUT I get the _failed to \
stylize-my bad_ error in the log and the layer does not render. As a side note FDO \
Toolkit fails to read a table w/a Oracle _circle_. (By the way, I do this insert via \
OracleConnection NOT MapGuide/FDO. I must do validity checking before the insert. So \
if there is/was an issue I would not have seen it here.)

I hope I have done a better job in explaining? I am very, very pleased w/KingOra. \
Oracle itself has done a poor job in explaining that Oracle Locator is all that is \
required to do the basics and it is totally FREE. With the sheer weight of Oracle's \
experience w/geometry objects I certainly believe you have hit the mark w/this \
provider! Kudoes to you!!! 

Haris, IMHO, there is absolutely NO advantage in storing INFO_ARRAY(1,1003,4)'s over \
INFO_ARRY(1,1005,1,1,2,2)'s.  r,
dennis

-----Original Message-----
From: mapguide-users-bounces@lists.osgeo.org \
                [mailto:mapguide-users-bounces@lists.osgeo.org] On Behalf Of Haris \
                Kurtagic
Sent: Tuesday, October 26, 2010 1:32 PM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] Re: Mapguide won't display all features fromKing Oracle \
connections

I forgot a bit, but haven't I fixed some gtype 4 after you send me
test geometries ?
If there are gtype 4 geometries you think King.Oracle can't read, send
them please, I will check it

Haris

On Tue, Oct 26, 2010 at 1:37 PM, djonio <DJonio@miami-airport.com> wrote:
> 
> Howdy,
> 
> MGOS 2.1
> KingOra 8.19
> 
> We use KingOracle a bunch and our only issue is and has been mixed
> multi-geometries(collections - sdo_gtype : 4) and circles (1,1003,4). We
> have no issues at all on the FDO/Mg input input side and it appears to me
> that it is an issue with MG rendering. Circles have been a real issue in
> that MG throws one of those "failed to stylize" errors and just gives up.
> The fix for me is to use (1,1005,1, 1,2,2)'s as a couple arcs instead of
> circles. The gtype 4's don't produce the failed to stylize error but they
> silently do not render.
> 
> Since the workaround for circles is relatively easy and the need for the
> collection type geometry is rare for me I have not persued the issue.
> However, if someone wishes to fix this I can produce some EPSG:2236(FL83-EF)
> geometries for test.
> r,
> dennis
> --
> View this message in context: \
> http://osgeo-org.1803224.n2.nabble.com/Mapguide-won-t-display-all-features-from-King-Oracle-connections-tp5657213p5674262.html
>  Sent from the MapGuide Users mailing list archive at Nabble.com.
> _______________________________________________
> mapguide-users mailing list
> mapguide-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

Scan by McAfee

_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[prev in list] [next in list] [prev in thread] [next in thread] 