<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=566474915-16072003><FONT face="Courier New" color=#0000ff
size=2>Hi Eric,</FONT></SPAN></DIV>
<DIV><SPAN class=566474915-16072003><FONT face="Courier New" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=566474915-16072003><FONT face="Courier New" color=#0000ff
size=2>Just a note of correction. FME does support reading of AutoCAD Map
Object Data through Autodesk's own API. The restriction upon this is that you
need to have AutoCAD Map installed adn the correct edition of FME as well.
</FONT></SPAN></DIV>
<DIV><SPAN class=566474915-16072003><FONT face="Courier New" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=566474915-16072003></SPAN><SPAN class=566474915-16072003><FONT
face="Courier New" color=#0000ff size=2>Additionally, support
for AutoCAD 2004 reading is now in progress.</FONT></SPAN></DIV>
<DIV><SPAN class=566474915-16072003></SPAN><SPAN class=566474915-16072003><FONT
face="Courier New" color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=566474915-16072003><FONT face="Courier New" color=#0000ff
size=2>Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=566474915-16072003><FONT face="Courier New" color=#0000ff
size=2>ryan</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Erik Brenn
[mailto:erik@fastmail.fm] <BR><B>Sent:</B> Friday, July 04, 2003
08:16<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Cc:</B>
mark@markrodrigo.com<BR><B>Subject:</B> Re: [postgis-users] How are you
editing data in PostGIS?<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hi Mark,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I earlier developed an AutoCAD Map VBA
application that can import data from AcadMap into PostGIS using
ODBC/ADO</FONT></DIV>
<DIV><FONT face=Arial size=2>The application reads a configuration file, which
can be customized via GUI. This lets you set up the mapping between AutoCAD
layers and most AutoCAD specific graphical attributes to PostgreSQL/PostGIS
tables/columns. You can also configure mapping of object data.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>As an FME user I figured I soon wont need this
anymore since FME now supports PostGIS, but FME doesn't yet support AutoCAD
Map Object Data, ufortunately.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If you're interested I can send you a snapshot of
the GUI and also the .bas files for you to try out. It was developed for
PostgreSQL 7.2.x, but shouldn't require much work, if any, to work with
7.3</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have also developed a check-in / check-out VBA
application in AutoCAD Map. I was planning to do this as a true/live editing
client to PostGIS, but the event handlers in AutoCAD Map were just too
unstable so I gave up. Instead my application can check out an user specified
area (either by box, or other means) and then store all identifiers of checked
out objects in a separate table. During check-in the data is compared to
that table, and any new objects, deleted objects, updated objects, are
detected. New and deleted objects were easy, but we had to compromise for the
updated objects, telling the operators to insert a code to indicate update in
an AutoCAD object data field.</FONT></DIV>
<DIV><FONT face=Arial size=2>This application is not that generic, and
it's based on the now obsolete RDO. But if people are interested I might spend
a day or two to shine it up and try to make it more reusable.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>regards,</FONT></DIV>
<DIV><FONT face=Arial size=2> erik brenn</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>