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

[Jonio, Dennis (Aviation)]

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: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of mighty_duck
Sent: Friday, December 10, 2010 8:20 AM
To: fdo-users at lists.osgeo.org
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]> 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> 
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> 
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> . 

 

________________________________

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> 
Sent from the FDO Users mailing list archive <http://osgeo-org.1803224.n2.nabble.com/FDO-Users-f2048584.html>  at Nabble.com.

________________________________

Email Scan by McAfee 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20101210/57a5039c/attachment.html