[fdo-users] Re: Storing MultiCurvePolygon King Oracle Provider

[Orest Halustchak]

Oracle doesn't support curves in a lat/long coordinate system. SRID 4326 is WGS 84. Maybe that's your problem here?

Thanks,
Orest.

From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Brad Nesom
Sent: Tuesday, December 07, 2010 11:26 PM
To: FDO Users Mail List
Subject: Re: [fdo-users] Re: Storing MultiCurvePolygon King Oracle Provider

I would think that Bryan Hall could help on the OTN spatial forum. Sorry to direct to another list but...

http://forums.oracle.com/forums/forum.jspa?forumID=76
On Tue, Dec 7, 2010 at 9:05 PM, Zac Spitzer <zac.spitzer at gmail.com<mailto:zac.spitzer at gmail.com>> wrote:
are the GEOMS 2d or 3d? Simons example is 2d

aside: the -180 -90 stuff is a bit quirky... folklore is that some of
the oracle spatial guru's
recommend always putting those default value in place, while many spatial apps
assume those are the default extents.. but I think it might dates back
to the older
quad tree indexing(?) days

z

On Wed, Dec 8, 2010 at 1:15 PM, Brad Nesom <kidsmake6 at msn.com<mailto:kidsmake6 at msn.com>> wrote:
> I am wondering if you poly is too large. I seem to remember some threads on
> oracle spatial discussing trying to contain an entire globe dataset
> incompassed by the 4326 wkid. I am way out of my element here but your -180,
> -90 made me think of that.
> Brad
>
> On Tue, Dec 7, 2010 at 4:17 AM, Simon Pelicon <simon at sl-king.com<mailto:simon at sl-king.com>> wrote:
>>
>> Hi!
>> I have no problems saving MultiCurvePolygons into Oracle using AutoCadMap
>> 2010 (or 2011).
>> I am using KingOracle provider version 0.8.23.
>> My SQL for the SDO_GEOM_METADATA_TABLE value is:
>> INSERT INTO MDSYS.SDO_GEOM_METADATA_TABLE VALUES ('SIMON','VDITCH',
>> 'GEOMETRY',MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',
>> -180,180,0.005),MDSYS.SDO_DIM_ELEMENT('Y', -90,90, 0.005)),4326);
>>
>> simon
>>
>> On Mon, Dec 6, 2010 at 9:41 AM, GISkit_Paul <paul at giskit.nl<mailto:paul at giskit.nl>> wrote:
>>>
>>> Hello,
>>>
>>> Although Simon's suggestion seems logical, it doesn't solve the problem.
>>> Using the same Oracle table, AutoCadMap 2010 (or 2011), connecting via
>>> the
>>> standard Oracle Connection, I can add hand-drawn MultiCurvePolygons.
>>> Using AutoCadMap 2010, connecting via the King Oracle provider and
>>> manually
>>> adding MultiCurvePolygons causes the same error. Is the problem perhaps
>>> caused by the King Oracle Provider?
>>>
>>> Regards,
>>> Paul
>>> --
>>> View this message in context:
>>> http://osgeo-org.1803224.n2.nabble.com/Storing-MultiCurvePolygon-King-Oracle-Provider-tp5773817p5807022.html
>>> Sent from the FDO Users mailing list archive at Nabble.com.
>>> _______________________________________________
>>> fdo-users mailing list
>>> fdo-users at lists.osgeo.org<mailto:fdo-users at lists.osgeo.org>
>>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>>
>>
>> _______________________________________________
>> fdo-users mailing list
>> fdo-users at lists.osgeo.org<mailto:fdo-users at lists.osgeo.org>
>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>>
>
>
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org<mailto:fdo-users at lists.osgeo.org>
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>
>


--
Zac Spitzer
Solution Architect / Director
Ennoble Consultancy Australia
http://www.ennoble.com.au<http://www.ennoble.com.au/>
http://zacster.blogspot.com<http://zacster.blogspot.com/>
+61 405 847 168
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org<mailto:fdo-users at lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/fdo-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20101208/cede93f0/attachment-0001.html