<!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=765393320-06112006><FONT face=Arial
color=#0000ff size=2>Hi Jason,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2>I think I made a mistake how I named it. it is not FDO
Metadata but it is Autodesk Metadata to describe data in RDBMS to be able to
serve it as FDO features.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2>FDO itself doesn't have any requirements to having
any metadata in RDBMS. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2>For instance King.Oracle provider is not using any
Metadata, It is just figuring out from RDBMS how features looks
like.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2>This Autodesk Metadata (used to call it FDO metadata and I
wrongly used that ) I suppose comes because sometimes it is hard to figure
out all relationships between features by just looking at data model in
RDBMS,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2>and also if you would like to apply that against file
system than you need it.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2>I am taking a word from Autodesk here, I hope I am not
making any mistake and if I am wrong please correct me.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2>When I was mentioning about Oracle Topology and Metadata, I
was creating Autodesk metadata tables in Oracle so that MAP
can query and display topology. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2>So I think at the end it comes what provider will need to
describe data and in which app this data is used.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2>When I was thinking about supporting full FDO Meatada, I
should say: I am thinking of supporting creation of Autodesk Metadata so this
data (exported with fdo2fdo) can be immediately used with Autodesk MAP ( as
standard not "foreign" schema)..</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006></SPAN><SPAN
class=765393320-06112006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2>Haris</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=765393320-06112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left>
<HR tabIndex=-1>
</DIV>
<DIV dir=ltr align=left><FONT face=Tahoma size=2><B>From:</B> Jason Birch
[mailto:Jason.Birch@nanaimo.ca] <BR><B>Sent:</B> Monday, November 06, 2006 8:02
PM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Cc:</B> users@fdo.osgeo.org;
Paul Ramsey; Frank Warmerdam; 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>