<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=320152812-23102006><FONT face=Arial
color=#0000ff size=2>Hi Haris,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=320152812-23102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=320152812-23102006><FONT face=Arial
color=#0000ff size=2>If you knew the EPSG code for the coordinate system, Oracle
10gr2 (if that's the version that you're using) provides an sdo_cs function
to map that to the SRID.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=320152812-23102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=320152812-23102006><FONT face=Arial
color=#0000ff size=2>Orest.</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Haris Kurtagic [mailto:haris@sl-king.com]
<BR><B>Sent:</B> Monday, October 23, 2006 8:10 AM<BR><B>To:</B>
dev@fdo.osgeo.org<BR><B>Subject:</B> RE: [fdo-dev]
FDOIApplySchema<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=671560112-23102006><FONT face=Arial
color=#0000ff size=2>Hi Orest,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=671560112-23102006><FONT face=Arial
color=#0000ff size=2>Thank you, I've imlemented it exactly like that
(keeping inside one session). Right now I don't how to convert from ogc wkt
soordinate system to Oracle coord sys.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=671560112-23102006><FONT face=Arial
color=#0000ff size=2>In application I am working on I left to user to find the
match from ogc to srid. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=671560112-23102006><FONT face=Arial
color=#0000ff size=2>Is there any way to do that ? Again not sure if this is
question for this list but I don't know better place to ask
:).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=671560112-23102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=671560112-23102006>Haris</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=671560112-23102006></SPAN><SPAN
class=671560112-23102006></SPAN></FONT></FONT></FONT> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Orest Halustchak
[mailto:orest.halustchak@autodesk.com] <BR><B>Sent:</B> Monday, October 23, 2006
2:01 PM<BR><B>To:</B> dev@fdo.osgeo.org<BR><B>Subject:</B> RE: [fdo-dev]
FDOIApplySchema<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=743405311-23102006><FONT face=Arial
color=#0000ff size=2>Hi Haris,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=743405311-23102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=743405311-23102006><FONT face=Arial
color=#0000ff size=2>Yes, you would have to create a spatial context first using
FdoICreateSpatialContext, unless you had existing spatial contexts that could be
used. The provider would have to save that information. Yes, if the provider is
not keeping metadata then it wouldn't be able to save that information past the
end of the session. Although if you create new class and geometry property
definitions that use that spatial context, you would have the coordinate system
information saved as Oracle metadata.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=743405311-23102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=743405311-23102006><FONT face=Arial
color=#0000ff size=2>Orest.</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Haris Kurtagic [mailto:haris@sl-king.com]
<BR><B>Sent:</B> Sunday, October 22, 2006 10:16 AM<BR><B>To:</B>
dev@fdo.osgeo.org<BR><B>Subject:</B> RE: [fdo-dev]
FDOIApplySchema<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=406000314-22102006><FONT face=Arial
color=#0000ff size=2>Hi,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406000314-22102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406000314-22102006><FONT face=Arial
color=#0000ff size=2>1. I suppose I wasn't thinking
enough on first question bellow. </FONT></SPAN><SPAN
class=406000314-22102006><FONT face=Arial color=#0000ff
size=2> </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406000314-22102006><FONT face=Arial
color=#0000ff size=2>I suspect that, it is supposed that client would first call
FDOICreateSpatialContext for all spatial context's prior to calling aplyschema
?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406000314-22102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406000314-22102006><FONT face=Arial
color=#0000ff size=2>Note:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406000314-22102006><FONT face=Arial
color=#0000ff size=2>I think, this can be a problem if provider is not
keeping metadata table's for spatial context.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406000314-22102006><FONT face=Arial
color=#0000ff size=2>For that case it would be fine to get spatial context's as
parameter in apply schema command.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406000314-22102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406000314-22102006><FONT face=Arial
color=#0000ff size=2>Haris</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Haris Kurtagic [mailto:haris@sl-king.com]
<BR><B>Sent:</B> Sunday, October 22, 2006 2:10 AM<BR><B>To:</B>
dev@fdo.osgeo.org<BR><B>Subject:</B> [fdo-dev]
FDOIApplySchema<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=953533923-21102006><FONT face=Arial
size=2>Hi,</FONT></SPAN></DIV>
<DIV><FONT face=Arial><SPAN class=953533923-21102006></SPAN><SPAN
class=953533923-21102006><FONT size=2>I have couple of
question:</FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=953533923-21102006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=953533923-21102006><FONT size=2>1.
</FONT></SPAN><SPAN class=953533923-21102006><FONT size=2>I am trying to
implement ApplySchema command in King.Oracle
provider.</FONT></SPAN></FONT></DIV>
<DIV><SPAN class=953533923-21102006><FONT face=Arial size=2>I have problem
because I need to have Spatial context of geometries when creating new schema
and classes.</FONT></SPAN></DIV>
<DIV><SPAN class=953533923-21102006><FONT face=Arial size=2>FDOIApplySchema
interface is designed with FeatureSchema as only parameter, no spatial
context.</FONT></SPAN></DIV>
<DIV><SPAN class=953533923-21102006><FONT face=Arial size=2>Geometry properties
have Spatial Context name property but no spatial context to read from in
apply schema command.</FONT></SPAN></DIV>
<DIV><SPAN class=953533923-21102006></SPAN><SPAN class=953533923-21102006><FONT
face=Arial size=2>There is command to create spatial context but it is another
command so it doesn't help me.</FONT></SPAN></DIV>
<DIV><SPAN class=953533923-21102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953533923-21102006><FONT face=Arial size=2>Am I missing
something here ? I would appreciate if someone can comment on
this.</FONT></SPAN></DIV>
<DIV><SPAN class=953533923-21102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><FONT face=Arial><SPAN class=953533923-21102006><FONT size=2>Note:
</FONT></SPAN><SPAN class=953533923-21102006><FONT size=2>I am trying to
recreate Oracle tables from fdo classes and I am not using fdo metadata
tables.</FONT></SPAN></FONT></DIV>
<DIV><SPAN class=953533923-21102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953533923-21102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><FONT face=Arial><SPAN class=953533923-21102006><FONT size=2>2. How can I
create clone of FdoFeatureClass ?</FONT></SPAN><SPAN
class=953533923-21102006><FONT size=2> </FONT></SPAN></FONT></DIV>
<DIV><SPAN class=953533923-21102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953533923-21102006><FONT face=Arial
size=2> I see that FDOFetaureSchemaCollection has a
way to ser/deser from XML, but I would like to do it just for
one class.</FONT></SPAN></DIV>
<DIV><FONT size=2><FONT face=Arial><SPAN class=953533923-21102006><FONT
size=+0> I am testing with Set (FdoClassDefinition *pClass,
FdoSchemaXmlContext *pContext)</FONT></SPAN><SPAN
class=953533923-21102006> , but I have filing that is not right way
?</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=953533923-21102006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=953533923-21102006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=953533923-21102006>Thank
you,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=953533923-21102006>Haris</SPAN></FONT></DIV></BODY></HTML>