<!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=817044419-06112006><FONT face=Arial
color=#0000ff size=2>Jason,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=817044419-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=817044419-06112006><FONT face=Arial
color=#0000ff size=2>If you mean that Map Schema Editor doesn't work fully with
foreign schema in Map, this is a limitation of the providers and not of
Map. FDO is the level of abstraction by which Autodesk tools work with FDO
data and schema. The provider is responsible for doing the mapping between
logical and physical representations. There is no need to have metadata in
the database if the provider create its own metadata on the fly and expose it
through FDO. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=817044419-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=817044419-06112006><FONT face=Arial
color=#0000ff size=2>And you guessed right: the metadata part is
a legacy that we have be living with. But metadata is not
necessary to access Oracle and MySQL data in native form. (SQL Server is
different since it has its own custom spatial support).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=817044419-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=817044419-06112006><FONT face=Arial
color=#0000ff size=2>RF</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> Jason Birch
[mailto:Jason.Birch@nanaimo.ca] <BR><B>Sent:</B> Monday, November 06, 2006 2:02
PM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Cc:</B> users@fdo.osgeo.org;
Paul Ramsey; Frank Warmerdam (External); Mateusz Loskot<BR><B>Subject:</B> RE:
[mapguide-users] Fdo2Fdo<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=368253318-06112006><FONT face=Arial
color=#0000ff size=2>FDO is open source. If there are non-open parts of
the specification, I'd be EXTREMELY disappointed. I'm not sure if
using all caps was enough to express the level to which I'd be
disappointed...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=368253318-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=368253318-06112006><FONT face=Arial
color=#0000ff size=2>It's frustrating that the default RDBMS providers
require that you keep the metadata in the database rather than mapping on the
fly. Given the limited budget and the desire to integrate with
the proprietary Autodesk products, the PostGIS provider has
been integrated with the core RDBMS providers. To me,
it seemed more important to be able to use PostGIS with Map 3D and spread the
adoption of PostGIS by Autodesk users than it was to enable access to existing
PostGIS schemas.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=368253318-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=368253318-06112006><FONT face=Arial
color=#0000ff size=2>It believe that what this means in the short
term is that it may be necessary to use Autodesk tools to populate it, and that
you can not just access existing data. Longer-term, I'm sure that
"foreign" schema support will be added to this provider, but I think that this
still requires that you keep the metadata in the same data source (possibly in a
different schema?). What I would really like to see is a third level of
function where all of the mappings are kept internally to FDO without affecting
the datasource. I hope that over time FDO will give priority to
"on-the-fly" access to my data without making the data store essentially
proprietary to FDO.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=368253318-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=368253318-06112006>
<DIV dir=ltr align=left><SPAN class=368253318-06112006><FONT face=Arial
color=#0000ff size=2>I guess a lot of this is probably stemming from FDO
starting out as a way of storing Autodesk data in multiple sources, rather than
as a generic data access mechanism. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=368253318-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=368253318-06112006><FONT face=Arial
color=#0000ff size=2>
<DIV dir=ltr align=left><SPAN class=368253318-06112006><FONT face=Arial
color=#0000ff size=2>If any of this is incorrect (Paul, Mateusz) I'd appreciate
correction.</FONT></SPAN></DIV></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=368253318-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=368253318-06112006><FONT face=Arial
color=#0000ff size=2>In the mean time, if you manage to extend fdo2fdo to
support this metadata, that would be a great interim
measure.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=368253318-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=368253318-06112006><FONT face=Arial
color=#0000ff size=2>Jason</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, November 06, 2006 10:28<BR><B>To:</B>
users@mapguide.osgeo.org<BR><B>Subject:</B> RE: [mapguide-users]
Fdo2Fdo<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=046372018-06112006><FONT face=Arial
color=#0000ff size=2>Hm, I wasn't thinking in that direction, but Map is still
needed if you wan't to have full FDO Meatada arround your
data.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=046372018-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=046372018-06112006><FONT face=Arial
color=#0000ff size=2>This tool will create plain tables in Oracle (indexes,
keys,..) and this data can be used in MapGuide or Map as foreign schemas or
using King.Oracle Provider.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=046372018-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=046372018-06112006><FONT face=Arial
color=#0000ff size=2>If you would like to have full FDO Metadata, MAP is still
needed.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=046372018-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=046372018-06112006><FONT face=Arial
color=#0000ff size=2>P.S.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=046372018-06112006><FONT face=Arial
color=#0000ff size=2>Not sure , if for non Autodesk tool
is correct ( i mean some licence restrictions) to create FDO metada
also ?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=046372018-06112006><FONT face=Arial
color=#0000ff size=2>I suppose it should be, but would be nice if someone from
Autodesk would confirm that.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=046372018-06112006><FONT face=Arial
color=#0000ff size=2>I was already doing that once for Oracle Topology,
puting FDO metadata arround it.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=046372018-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=046372018-06112006><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> Jason Birch
[mailto:Jason.Birch@nanaimo.ca] <BR><B>Sent:</B> Monday, November 06, 2006 7:19
PM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] Fdo2Fdo<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=187361118-06112006>This is pretty cool Haris.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=187361118-06112006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=187361118-06112006>This means that users that aren't able to purchase a
Map 3D license can load data into RDBMS data sources.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=187361118-06112006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=187361118-06112006>Jason</SPAN></FONT></DIV><FONT face=Arial color=#0000ff
size=2></FONT><FONT face=Arial color=#0000ff size=2></FONT><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Haris Kurtagic<BR><B>Sent:</B> Monday,
November 06, 2006 09:59<BR><B>To:</B>
users@mapguide.osgeo.org<BR><B>Subject:</B> [mapguide-users]
Fdo2Fdo<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=140583817-06112006><FONT face=Arial
size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=140583817-06112006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=140583817-06112006><FONT face=Arial size=2>Fdo2Fdo is
a tool I am using to work with, learn and test FDO and perhaps it can
help to someone else also.</FONT></SPAN></DIV>
<DIV><SPAN class=140583817-06112006><FONT face=Arial size=2>It is a FDO client
application for copying FDO Data Sources and manage FDO Data Sources with
additional tools to work with Oracle.</FONT></SPAN></DIV>
<DIV><SPAN class=140583817-06112006><FONT face=Arial size=2>It has two parts:
standard library as fdo client </FONT></SPAN><SPAN
class=140583817-06112006><FONT face=Arial size=2>and windows
application.</FONT></SPAN></DIV>
<DIV><SPAN class=140583817-06112006><FONT face=Arial size=2><SPAN
class=718123023-30102006><FONT face=Arial
size=2></FONT></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=140583817-06112006><SPAN class=718123023-30102006>
<DIV><SPAN class=718123023-30102006><FONT face=Arial><FONT size=2><SPAN
class=140583817-06112006>Some </SPAN>features:</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=718123023-30102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=718123023-30102006><FONT face=Arial><FONT size=2>1.
Copy <SPAN class=140583817-06112006>to/</SPAN>from <SPAN
class=140583817-06112006>SHP</SPAN>,<SPAN class=140583817-06112006>
SDF</SPAN>,<SPAN class=140583817-06112006> </SPAN>Oracle <SPAN
class=140583817-06112006>( didn't tested others but could
work) <A
href="http://www.sl-king.com/fdo2fdo/screenshots_copy.html">http://www.sl-king.com/fdo2fdo/screenshots_copy.html</A></SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=718123023-30102006><SPAN
class=140583817-06112006></SPAN></SPAN> </DIV>
<DIV><SPAN class=718123023-30102006><SPAN class=140583817-06112006><FONT
face=Arial size=2>2. Copy to Oracle and it will setup all stuff so you can view
it immediately in MapGuide (sdo metadata, spatial index, layer type, primary
key)</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=718123023-30102006><FONT face=Arial><FONT
size=2></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=718123023-30102006><FONT size=+0><FONT face=Arial><FONT
size=2><SPAN class=140583817-06112006>3</SPAN>. Fdo Toolbox: useful utilities
for testing fdo providers and schemas<SPAN class=140583817-06112006>
<A
href="http://www.sl-king.com/fdo2fdo/screenshots_fdo.html">http://www.sl-king.com/fdo2fdo/screenshots_fdo.html</A></SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=718123023-30102006><FONT face=Arial><FONT
size=2></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=718123023-30102006><FONT size=+0><FONT size=+0><FONT
face=Arial><FONT size=2><SPAN class=140583817-06112006>4</SPAN>. Oracle toolbox
- <SPAN class=140583817-06112006>manage sdo metadata, spatial index,
primary keys <A
href="http://www.sl-king.com/fdo2fdo/screenshots_ora.html">http://www.sl-king.com/fdo2fdo/screenshots_ora.html</A></SPAN></FONT></FONT></FONT></FONT></SPAN></DIV></SPAN></SPAN></DIV>
<DIV><SPAN class=140583817-06112006><FONT face=Arial size=2><SPAN
class=718123023-30102006></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=140583817-06112006><FONT face=Arial size=2><SPAN
class=718123023-30102006>5. API c, .net <A
href="http://www.sl-king.com/fdo2fdo/fdo2fdo_api.html">http://www.sl-king.com/fdo2fdo/fdo2fdo_api.html</A></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=140583817-06112006><FONT face=Arial size=2><SPAN
class=718123023-30102006></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=140583817-06112006><FONT face=Arial size=2><SPAN
class=718123023-30102006></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=140583817-06112006><FONT face=Arial size=2><SPAN
class=718123023-30102006>You can get it here: <A
href="http://www.sl-king.com/fdo2fdo">www.sl-king.com/fdo2fdo</A></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=140583817-06112006><FONT face=Arial size=2><SPAN
class=718123023-30102006></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=140583817-06112006><FONT face=Arial size=2><SPAN
class=718123023-30102006></SPAN></FONT></SPAN><SPAN
class=140583817-06112006><FONT face=Arial size=2><SPAN
class=718123023-30102006><FONT face=Arial
size=2></FONT></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=140583817-06112006><SPAN class=718123023-30102006><FONT
face=Arial size=2>It is a self contained application.</FONT></SPAN></DIV>
<DIV>
<DIV><SPAN class=718123023-30102006><FONT face=Arial size=2>It is 38 MB .zip
file which you unzip and ready to go. It contains: complete fdo, shp,sdf,<SPAN
class=140583817-06112006>king.</SPAN>oracle provider, oracle instant client and
need<SPAN class=140583817-06112006>ed</SPAN> microsoft
redistributables.</FONT></SPAN></DIV>
<DIV><SPAN class=718123023-30102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=718123023-30102006><FONT face=Arial size=2>I tested it around
sdf,shp and <SPAN class=140583817-06112006>o</SPAN>racle but it is general
fdo client so it could work with others also<SPAN class=140583817-06112006>, if
not let me know and I will try to fix it</SPAN>.</FONT></SPAN></DIV>
<DIV><SPAN class=718123023-30102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=718123023-30102006><FONT face=Arial size=2><SPAN
class=140583817-06112006>If some of this, is material for open source I am happy
to make it so.</SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=718123023-30102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=718123023-30102006><SPAN class=140583817-06112006><FONT
face=Arial size=2>Haris</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=718123023-30102006><FONT face=Arial
size=2></FONT></SPAN> </DIV></SPAN></DIV></BODY></HTML>