Editing In ArcGIS for AutoCAD?

I have planted a vegetable garden. I don’t expect it will save me much money on food, but I really enjoy the idea of it. The best places in my yard for growing things are either covered by structures, concrete or trees. To create some more space and to thwart the plans of bugs and weeds, I’ve decided to plant my garden in pots on a terraced rolling cart. It’s like the produce stand in the picture, accept it has bins of plants from which I hope to pick fruits and vegetables.

This may sound obvious, but one thing I’ve learned from past agricultural experiments is that it is best to plant things that I actually like to eat rather than things that are just easy to grow! And it is nice to get plants that can keep producing over time rather than all at once.

If I want to allow someone to use AutoCAD to edit data I have in ArcGIS I can give them an AutoCAD copy of a sub-set of the GIS data using the EXPORT TO CAD tool. Before I export the GIS data I can flag it with a unique code of my own creation. This transaction flag can be nothing more than an integer in a field I call “transaction” or a text field. I like to create a text field, and then use the now( ) expression with the ArcGIS CALCULATE tool to create a time stamp string as my transaction code. This is probably something I should automate using a geoprocessing model; select stuff, ADD FIELD, CALCULATE, etc… EXPORT TO CAD.

A feature class will be created in the AutoCAD drawing according to the mapping specification for drawings, along with the attribute schema for the data.

TIP: I want to make sure to only export a selected set of features to avoid pushing thousands of features back and forth that I have no intention of changing. If I want more data for geographic context, I can publish a map service of the same GIS data with ArcGIS Server. I then use ArcGIS for AutoCAD’s ability to use map services to see the full basemap.

Using the attribute editing tools of ArcGIS for AutoCAD and the AutoCAD graphics engine I make edits to my copy of the geometry and attributes of the exported GIS data. If I trust the edits made in AutoCAD and I am confident that ArcGIS can see the appropriate data in the AutoCAD feature class, I can use those changes to update my GIS data. I want any features that are added, modified or deleted to be updated in the geodatabase appropriately.

Now assume that I really really want the changes I made in the AutoCAD file to replace the existing data flagged by my transaction code and still unmodified in the geodatabase. I select my flagged features with my transaction code in the geodatabase, and DELETE them. I use the modified AutoCAD file to replace the data involved in the transaction with the APPEND tool. New features will be added, modified features will be replaced and deleted feature will not be replaced, and therefore deleted.

This rather crude form of editing should be thoroughly tested in each environment and then only performed on a copy of the production data that is then verified for quality control, before changes are accepted. In this workflow I must also accept the fact that the object identifiers will be changed on all of the features in the transaction including objects that didn’t change, since in this version of the workflow everything you exported was flagged as part of the transaction.

If someone else edits the same data that I intend to be editing in AutoCAD, their edits might be overwritten by mine, or if my transaction flags become out of sync or invalid the workflow could be compromised. It is up to me to manage how transactions like this are flagged and processed. I must clean up after myself and guard the state of the database during transactions. Additional consideration would need to be given for the effects of editing features involved topologies, or networks. The bottom line for this workflow is that I am responsible for everything that happens to the data, there are no built-in safeguards.

On my produce cart now are: blackberries, raspberries, cucumbers, eggplant, carrots, onions, squash and tomatoes, in the fall, strawberries, beans and spinach will be likely additions. I’m making frequent trips to my produce stand for tending, and watering. I will automate the watering with a drip system hooked up to my lawn sprinklers.

I look forward to the harvesting.