[fdo-users] Re: Autodesk FDO provider shows only first point from multipoint geometry in Oracle!?

Fri Dec 10 11:01:59 EST 2010

Well, I didnt know that fact. Actually never pay attention to it, since I
got data transformed with  Extract Transform Load tool from other members of
project team and when I was creating some procedures for handling multipoint
geometry I was looking in existing data thinking that is right format.....

It seems we cannot trust to this tools totally :)

"So Oracle says it’s a point and evidently so does Autodesk Oracle provider.
They were generous with you.  ;-)"

As programmer I would be more happy that FDO provider note my team at the
beggining that it is not correct format,  it wouldn't be now my task to
change that ;)

Dennis, thanks a lot for this information, I was already started to be
sceptic how to find solution for this, you saved my time.

All the best,

Minja

On Fri, Dec 10, 2010 at 4:17 PM, djonio [via OSGeo.org] <
ml-node+5823375-1203813311-217991 at n2.nabble.com<ml-node%2B5823375-1203813311-217991 at n2.nabble.com>
> wrote:

>  Well, to be frank and honest the SDO_GEOMETRY you provided does not come
> close to meeting the Oracle specification for a MILTIPOINT and IMHO should
> have not passed validation. I am sure it only passed because MULTIPOINT is a
> SUPERSET of POINT and your first elem_info triplet( 1,1,1) has the signature
> for a valid point. So Oracle says it’s a point and evidently so does
> Autodesk Oracle provider. They were generous with you.  ;-)
>
>
>
> Yes, within 10.2g _*Oracle Spatial User’s Guide and Reference*_ read
> Chapter 2 “Oracle Spatial Data Types and Metadata”.
>
> Focus on _*Values and Semantics in SDO_ELEM_INFO*_ basically the triplet
> for a SDO_GTYPE: X005(MULTIPOINT) is sdo_etype = 1, sdo_interpretation =
> number of points.
>
> Keep in mind that in many cases and at a certain level the SDO_ GYTPE is
> really nothing more than a _*convenieince*_ value. Whenever the ordinates
> and elem_info are  _*unpacked*_ you will find that they will _*overrule_(lack
> of better term) the SDO*_GTYPE.
>
> Yes, I know it is confusing but it is what it is …
>
>
>
> r,
>
> dennis
>
>
>
> *From:* [hidden email]<http://user/SendEmail.jtp?type=node&node=5823375&i=0>[mailto:[hidden
> email] <http://user/SendEmail.jtp?type=node&node=5823375&i=1>] *On Behalf
> Of *mighty_duck
> *Sent:* Friday, December 10, 2010 8:20 AM
> *To:* [hidden email]<http://user/SendEmail.jtp?type=node&node=5823375&i=2>
> *Subject:* [fdo-users] Re: Autodesk FDO provider shows only first point
> from multipoint geometry in Oracle!?
>
>
>
> Hi dennis,
>
>
>
> yes it works now, thx. a lot :)..but Im little bit confused now with
> format, so may you explain me now meaning of
>
> MDSYS.SDO_ELEM_INFO_ARRAY(1,1,3)
>
>
>
> Example: I have 15 points will it be then only
>
>
>
> MDSYS.SDO_ELEM_INFO_ARRAY(1,1,15)
>
>
>
> or there is some other rule. Honestly I have never seen this format for
> multipoint in Oracle and my potential problem now is that all current data
> in oracle has old format and it seems I will need to switch it...
>
>
> Thanks
>
>
>
> Minja
>
> On Fri, Dec 10, 2010 at 1:30 PM, djonio [via OSGeo.org] <[hidden email]<http://user/SendEmail.jtp?type=node&node=5823023&i=0&by-user=t>>
> wrote:
>
> Yes, yours validates but .... I believe this one is "technically
> correct" ... give it a try ....
> MDSYS.SDO_GEOMETRY(2005,4326,null,MDSYS.SDO_ELEM_INFO_ARRAY(1,1,3),MDSYS
>
> .SDO_ORDINATE_ARRAY(18.5272949231966,43.9245558053237,18.527391754093,43
> .924240327095,18.5310243924313,43.9252225514267))
>
> r,
> dennis
>
>
>
>
> -----Original Message-----
> From: [hidden email]<http://user/SendEmail.jtp?type=node&node=5822896&i=0>
> [mailto:[hidden email]<http://user/SendEmail.jtp?type=node&node=5822896&i=1>]
> On Behalf Of mighty_duck
> Sent: Friday, December 10, 2010 5:47 AM
> To: [hidden email] <http://user/SendEmail.jtp?type=node&node=5822896&i=2>
> Subject: [fdo-users] Autodesk FDO provider shows only first point from
> multipoint geometry in Oracle!?
>
>
> Hi all,
>
> I have strange problem, and I really hope there is something stupid in
> this
> that Im not able to note :)
>
> I have multipoint geometry in Oracle:
>
> MDSYS.SDO_GEOMETRY(2005,4326,null,MDSYS.SDO_ELEM_INFO_ARRAY(1,1,1,3,1,1,
> 5,1,1),MDSYS.SDO_ORDINATE_ARRAY(18.5272949231966,43.9245558053237,18.527
> 391754093,43.924240327095,18.5310243924313,43.9252225514267))
>
> I created layer in mapguide studio 2010 using autodesk fdo provider for
> Oracle and it should show me three points on the map, but I can only see
> the
> first one :(.
>
> Does anyone know what is the problem here, I hope this is not FDO bug,
> otherwise I will need to find another approach.
>
> Any remarks will be very important for me. If you know this issue as bug
> please let me know about that.
>
> NOTE: Im not able to switch to other FDO providers because my code
> design is
> fixed to autodesk fdo provider.
>
> Thanks in advance
>
> Minja
>
>
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/Autodesk-FDO-provider-shows-only-<http://osgeo-org.1803224.n2.nabble.com/Autodesk-FDO-provider-shows-only-?by-user=t&by-user=t&by-user=t>
> first-point-from-multipoint-geometry-in-Oracle-tp5822675p5822675.html
> Sent from the FDO Users mailing list archive at Nabble.com.
> _______________________________________________
> fdo-users mailing list
>
> [hidden email] <http://user/SendEmail.jtp?type=node&node=5822896&i=3>
>
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>
>  Email Scan by McAfee
> _______________________________________________
> fdo-users mailing list
> [hidden email] <http://user/SendEmail.jtp?type=node&node=5822896&i=4>
>
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>
>   ------------------------------
>
> View message @
> http://osgeo-org.1803224.n2.nabble.com/Autodesk-FDO-provider-shows-only-first-point-from-multipoint-geometry-in-Oracle-tp5822675p5822896.html<http://osgeo-org.1803224.n2.nabble.com/Autodesk-FDO-provider-shows-only-first-point-from-multipoint-geometry-in-Oracle-tp5822675p5822896.html?by-user=t&by-user=t>
> To unsubscribe from Autodesk FDO provider shows only first point from
> multipoint geometry in Oracle!?, click here<http://osgeo-org.1803224.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5822675&code=bXNpbGplZ292aWNAZ21haWwuY29tfDU4MjI2NzV8MTAyMDg2MDkzNQ==&by-user=t&by-user=t>.
>
>
>
>  ------------------------------
>
> View this message in context: Re: Autodesk FDO provider shows only first
> point from multipoint geometry in Oracle!?<http://osgeo-org.1803224.n2.nabble.com/Autodesk-FDO-provider-shows-only-first-point-from-multipoint-geometry-in-Oracle-tp5822675p5823023.html?by-user=t>
>
> Sent from the FDO Users mailing list archive<http://osgeo-org.1803224.n2.nabble.com/FDO-Users-f2048584.html?by-user=t>at Nabble.com.
>  ------------------------------
>
> Email Scan by McAfee
>
> _______________________________________________
> fdo-users mailing list
> [hidden email] <http://user/SendEmail.jtp?type=node&node=5823375&i=3>
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>
>
> ------------------------------
>  View message @
> http://osgeo-org.1803224.n2.nabble.com/Autodesk-FDO-provider-shows-only-first-point-from-multipoint-geometry-in-Oracle-tp5822675p5823375.html
>
> To unsubscribe from Autodesk FDO provider shows only first point from
> multipoint geometry in Oracle!?, click here<http://osgeo-org.1803224.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5822675&code=bXNpbGplZ292aWNAZ21haWwuY29tfDU4MjI2NzV8MTAyMDg2MDkzNQ==>.
>
>

-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Autodesk-FDO-provider-shows-only-first-point-from-multipoint-geometry-in-Oracle-tp5822675p5823540.html
Sent from the FDO Users mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20101210/d5d11414/attachment-0001.html