[postgis-users] PostGIS on ArcGIS AND AutoCAD Civil 3D 2013

[Basques, Bob (CI-StPaul)]

Mark,

I've have been at this problem for a number of years.  Early on I was more interested in making All AutoCAD versions work the same which was my primary focus on things, but over time we made the data stores available to other clients like the internet and ARC users.

The solution I went with was to write my own exporter for AutoCAD vs trying to maintain the connection stuff between versions of things.  The data was abstracted out into simple features, and then reassembled after transport in the client(s).  Again we focused on the AUTOCAD side of things.  The system hasn't needed to change between multiple versions of AutoCAD coming  out either and we've had the data in Oracle 8 - 11 as well as postgres/postgis.

Basically the solution was to write my own version of a SDO connector (capabilities wise) and I send all the data to AutoCAD as a AutoLISP construct, which is simply ran as a script on the client.  The data is reconstructed as AutoCAD features upon request and everyone is (has been) happy with it for a number of years now.

While this approach isn't a turn key solution, the basic components needed are fairly easy to come up to speed on, and if you know DB design and a bit of programming you can easily pop the data out of a database as a working script for AutoCAD.

Our uses are fairly concise as well, all access is read only, nothing goes back into the database except by the layers owner, so most access is readonly and through a middleware script, very close to a web model actually.

Let me know if you want to discuss this in any more detail.

Bobb



>>  -----Original Message-----
>>  From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-
>>  users-bounces at lists.osgeo.org] On Behalf Of Mark Volz
>>  Sent: Monday, January 07, 2013 12:08 PM
>>  To: postgis-users at lists.osgeo.org
>>  Subject: [postgis-users] PostGIS on ArcGIS AND AutoCAD Civil 3D
>>  2013
>>  
>>  Hello,
>>  
>>  I installed PostgreSQL 9.1 64 bit and PostGIS 2.0.1 to host
>>  spatial data for our ArcGIS, which can be done via the ArcGIS
>>  "Add query layer" option.  Now that I got that working I have had
>>  a couple people ask if I can get our AutoCad Civil 3D 2013 users
>>  connected to PostGIS as well.   I noticed right off hand that
>>  AutoCAD connects to the postgresql, however even with the spatial
>>  reference system loaded the data does not appear to load
>>  properly.  I found a note that Civil 3D may not work with
>>  Postgresql 9.1 and PostGIS 2.0.  Is this correct?
>>  
>>  Has anyone found a combination of PostgreSQL and PostGIS that
>>  will serve data to both ArcGIS and AutoCAD clients?
>>  
>>  Thank You
>>  
>>  P.S.  This data is not "SDE" It is strictly postgreSQL and
>>  postgis.
>>  
>>  Mark Volz
>>  GIS Specialist
>>  _______________________________________________
>>  postgis-users mailing list
>>  postgis-users at lists.osgeo.org
>>  http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users