First of all you'll have to have the PostGIS extension on your PostgreSQL database (this will allow you to store geometry in the database).
Now, stuff like annotation and symbology from the original DWG is stored in several attributes (autocad_color and autocad_linestyle for example) which can indeed be written to your PostGIS database. You'll need to set up a workflow that retains those attributes.
To get the data back into AutoCAD you would either need to connect to the PostGIS database directly (I don't know enough about AutoCAD to tell you whether that's possible) or create a second workflow that takes a small section of the data in the database and write it back out to a DWG, using the colors and styles that you've stored.
There's a couple of tutorials on AutoCAD handling on the Knowledge Base to get you started.
First of all you'll have to have the PostGIS extension on your PostgreSQL database (this will allow you to store geometry in the database).
Now, stuff like annotation and symbology from the original DWG is stored in several attributes (autocad_color and autocad_linestyle for example) which can indeed be written to your PostGIS database. You'll need to set up a workflow that retains those attributes.
To get the data back into AutoCAD you would either need to connect to the PostGIS database directly (I don't know enough about AutoCAD to tell you whether that's possible) or create a second workflow that takes a small section of the data in the database and write it back out to a DWG, using the colors and styles that you've stored.
There's a couple of tutorials on AutoCAD handling on the Knowledge Base to get you started.
@redgeographics Thank you. I am positive that the PostGIS extension is already present. I am already performing a similar workflow for all of our GIS submission data. Just to be clear, you are suggesting that the DWG Layers be written to an ArcSDE Feature Class, that retains the attributes you mentioned, in the PostGIS DB, correct?
Hi @dane_stephenson,
To expand a little on the answer by @redgeographics, you can pack all of the AutoCAD symbology into a single clob or text field using the AttributeJSONPacker for more efficient storage in PostGIS (or any other spatial database). When writing back to AutoCAD, use the corresponding AttributeJSONUnpacker to restore the autocad symbology attributes.
To store all the AutoCAD symbology attributes, use the prefix 'autocad_' in the AttributeJSONPacker.
