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..... <br>
<br>It seems we cannot trust to this tools totally :)<br><br><span style="font-size: 11pt; color: rgb(31, 73, 125);">"So Oracle says it’s a point and evidently so does Autodesk Oracle
provider. They were generous with you. ;-)"</span> <br><br>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 ;)<br>
<br>Dennis, thanks a lot for this information, I was already started to be sceptic how to find solution for this, you saved my time.<br><br>All the best,<br><br>Minja<br><br><div class="gmail_quote">On Fri, Dec 10, 2010 at 4:17 PM, djonio [via OSGeo.org] <span dir="ltr"><<a href="/user/SendEmail.jtp?type=node&node=5823540&i=0" target="_top" rel="nofollow">[hidden email]</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">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. ;-)</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Yes, within 10.2g _<i>Oracle Spatial User’s Guide and Reference</i>_
read Chapter 2 “Oracle Spatial Data Types and Metadata”.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Focus on _<i>Values and Semantics in SDO_ELEM_INFO</i>_ basically
the triplet for a SDO_GTYPE: X005(MULTIPOINT) is sdo_etype = 1,
sdo_interpretation = number of points.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Keep in mind that in many cases and at a certain level the SDO_
GYTPE is really nothing more than a _<i>convenieince</i>_ value. Whenever the
ordinates and elem_info are _<i>unpacked</i>_ you will find that they will _<i>overrule_(lack
of better term) the SDO</i>_GTYPE. </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Yes, I know it is confusing but it is what it is …</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">r,</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">dennis </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;">
<a href="http://user/SendEmail.jtp?type=node&node=5823375&i=0" rel="nofollow" target="_blank" link="external">[hidden email]</a> [mailto:<a href="http://user/SendEmail.jtp?type=node&node=5823375&i=1" rel="nofollow" target="_blank" link="external">[hidden email]</a>] <b>On
Behalf Of </b>mighty_duck<br>
<b>Sent:</b> Friday, December 10, 2010 8:20 AM<br>
<b>To:</b> <a href="http://user/SendEmail.jtp?type=node&node=5823375&i=2" rel="nofollow" target="_blank" link="external">[hidden email]</a><br>
<b>Subject:</b> [fdo-users] Re: Autodesk FDO provider shows only first point
from multipoint geometry in Oracle!?</span></p>
</div><div class="im">
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal">Hi dennis,</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">yes it works now, thx. a lot :)..but Im little bit confused
now with format, so may you explain me now meaning of </p>
</div>
<div>
<p class="MsoNormal">MDSYS.SDO_ELEM_INFO_ARRAY(1,1,3)</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Example: I have 15 points will it be then only </p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<div>
<p class="MsoNormal">MDSYS.SDO_ELEM_INFO_ARRAY(1,1,15)</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">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...</p>
</div>
<div>
<p class="MsoNormal"><br>
Thanks</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Minja</p>
</div>
</div>
</div><div><div></div><div class="h5"><div>
<p class="MsoNormal">On Fri, Dec 10, 2010 at 1:30 PM, djonio [via OSGeo.org] <<a href="http://user/SendEmail.jtp?type=node&node=5823023&i=0&by-user=t" rel="nofollow" link="external" target="_blank">[hidden
email]</a>> wrote:</p>
<p class="MsoNormal">Yes, yours validates but .... I believe this one is
"technically <br>
correct" ... give it a try .... <br>
MDSYS.SDO_GEOMETRY(2005,4326,null,MDSYS.SDO_ELEM_INFO_ARRAY(1,1,3),MDSYS </p>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;">.SDO_ORDINATE_ARRAY(18.5272949231966,43.9245558053237,18.527391754093,43
<br>
.924240327095,18.5310243924313,43.9252225514267)) </p>
</div>
<p class="MsoNormal">r, <br>
dennis </p>
<div>
<div>
<p class="MsoNormal"><br>
<br>
<br>
-----Original Message----- <br>
From: <a href="http://user/SendEmail.jtp?type=node&node=5822896&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a> <br>
[mailto:<a href="http://user/SendEmail.jtp?type=node&node=5822896&i=1" rel="nofollow" link="external" target="_blank">[hidden email]</a>] On Behalf Of mighty_duck <br>
Sent: Friday, December 10, 2010 5:47 AM <br>
To: <a href="http://user/SendEmail.jtp?type=node&node=5822896&i=2" rel="nofollow" link="external" target="_blank">[hidden email]</a> <br>
Subject: [fdo-users] Autodesk FDO provider shows only first point from <br>
multipoint geometry in Oracle!? <br>
<br>
<br>
Hi all, <br>
<br>
I have strange problem, and I really hope there is something stupid in <br>
this <br>
that Im not able to note :) <br>
<br>
I have multipoint geometry in Oracle: <br>
<br>
MDSYS.SDO_GEOMETRY(2005,4326,null,MDSYS.SDO_ELEM_INFO_ARRAY(1,1,1,3,1,1, <br>
5,1,1),MDSYS.SDO_ORDINATE_ARRAY(18.5272949231966,43.9245558053237,18.527 <br>
391754093,43.924240327095,18.5310243924313,43.9252225514267)) <br>
<br>
I created layer in mapguide studio 2010 using autodesk fdo provider for <br>
Oracle and it should show me three points on the map, but I can only see <br>
the <br>
first one :(. <br>
<br>
Does anyone know what is the problem here, I hope this is not FDO bug, <br>
otherwise I will need to find another approach. <br>
<br>
Any remarks will be very important for me. If you know this issue as bug <br>
please let me know about that. <br>
<br>
NOTE: Im not able to switch to other FDO providers because my code <br>
design is <br>
fixed to autodesk fdo provider. <br>
<br>
Thanks in advance <br>
<br>
Minja <br>
<br>
<br>
-- <br>
View this message in context: <br>
<a href="http://osgeo-org.1803224.n2.nabble.com/Autodesk-FDO-provider-shows-only-?by-user=t&by-user=t&by-user=t&by-user=t" rel="nofollow" link="external" target="_blank">http://osgeo-org.1803224.n2.nabble.com/Autodesk-FDO-provider-shows-only-</a><br>
first-point-from-multipoint-geometry-in-Oracle-tp5822675p5822675.html <br>
Sent from the FDO Users mailing list archive at Nabble.com. <br>
_______________________________________________ <br>
fdo-users mailing list </p>
</div>
</div>
<p class="MsoNormal"><a href="http://user/SendEmail.jtp?type=node&node=5822896&i=3" rel="nofollow" link="external" target="_blank">[hidden email]</a> </p>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><a href="http://lists.osgeo.org/mailman/listinfo/fdo-users" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-users</a><br>
<br>
</p>
</div>
<p class="MsoNormal">Email Scan by McAfee <br>
_______________________________________________ <br>
fdo-users mailing list <br>
<a href="http://user/SendEmail.jtp?type=node&node=5822896&i=4" rel="nofollow" link="external" target="_blank">[hidden email]</a> </p>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><a href="http://lists.osgeo.org/mailman/listinfo/fdo-users" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-users</a><br>
<br>
</p>
</div>
<div class="MsoNormal" style="text-align: center;" align="center">
<hr style="color: rgb(204, 204, 204);" align="center" width="100%" noshade size="1">
</div>
<div>
<p class="MsoNormal"><span style="font-size: 8.5pt; color: rgb(102, 102, 102);">View message @ <a href="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&by-user=t" rel="nofollow" link="external" target="_blank">http://osgeo-org.1803224.n2.nabble.com/Autodesk-FDO-provider-shows-only-first-point-from-multipoint-geometry-in-Oracle-tp5822675p5822896.html</a><br>
To unsubscribe from Autodesk FDO provider shows only first point from
multipoint geometry in Oracle!?, <a href="http://osgeo-org.1803224.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5822675&code=bXNpbGplZ292aWNAZ21haWwuY29tfDU4MjI2NzV8MTAyMDg2MDkzNQ==&by-user=t&by-user=t&by-user=t" rel="nofollow" link="external" target="_blank">click here</a>. </span></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"> </p>
</div></div><div class="MsoNormal">
<hr style="width: 225pt;" align="left" width="300" size="2">
</div>
<p class="MsoNormal">View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/Autodesk-FDO-provider-shows-only-first-point-from-multipoint-geometry-in-Oracle-tp5822675p5823023.html?by-user=t&by-user=t" rel="nofollow" link="external" target="_blank">Re:
Autodesk FDO provider shows only first point from multipoint geometry in
Oracle!?</a></p><div class="im"><br>
Sent from the <a href="http://osgeo-org.1803224.n2.nabble.com/FDO-Users-f2048584.html?by-user=t&by-user=t" rel="nofollow" link="external" target="_blank">FDO Users
mailing list archive</a> at Nabble.com.</div>
<div>
<div class="MsoNormal" style="text-align: center;" align="center">
<hr align="center" width="100%" size="2">
</div>
<p class="MsoNormal">Email Scan by McAfee </p>
</div>
</div><div class="im">
<br>_______________________________________________
<br>fdo-users mailing list
<br><a href="http://user/SendEmail.jtp?type=node&node=5823375&i=3" rel="nofollow" target="_blank" link="external">[hidden email]</a>
<br><a href="http://lists.osgeo.org/mailman/listinfo/fdo-users" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-users</a><br>
<br>
<br>
<hr color="#cccccc" noshade size="1">
</div><div style="color: rgb(102, 102, 102); font: 11px tahoma,geneva,helvetica,arial,sans-serif;">
View message @ <a href="http://osgeo-org.1803224.n2.nabble.com/Autodesk-FDO-provider-shows-only-first-point-from-multipoint-geometry-in-Oracle-tp5822675p5823375.html?by-user=t" target="_blank" rel="nofollow" link="external">http://osgeo-org.1803224.n2.nabble.com/Autodesk-FDO-provider-shows-only-first-point-from-multipoint-geometry-in-Oracle-tp5822675p5823375.html</a><div class="im">
<br>
To unsubscribe from Autodesk FDO provider shows only first point from multipoint geometry in Oracle!?, <a href="http://osgeo-org.1803224.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5822675&code=bXNpbGplZ292aWNAZ21haWwuY29tfDU4MjI2NzV8MTAyMDg2MDkzNQ==&by-user=t" target="_blank" rel="nofollow" link="external">click here</a>.
</div></div></blockquote></div><br>
<br><hr align="left" width="300">
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/Autodesk-FDO-provider-shows-only-first-point-from-multipoint-geometry-in-Oracle-tp5822675p5823540.html">Re: Autodesk FDO provider shows only first point from multipoint geometry in Oracle!?</a><br>
Sent from the <a href="http://osgeo-org.1803224.n2.nabble.com/FDO-Users-f2048584.html">FDO Users mailing list archive</a> at Nabble.com.<br>