Cogo Points With Object Data to be imported into ESRI

[Anonymous]

Hello all,

I have a couple thousand cogo points and lines that have object data (OD) associated with them. We are looking to get them out of the dwg and into a geodatabase with the object data preserved. 

I use the "MAPEXPORT" command to create a shape file. Then our GIS operator can bring these into the geodatabase. This works just fine for the lines but will not work for the cogo points as the "MAPEXPOERT" command doesn't even recognize cogo points as an object that can be exported. Doing a little reading it seems I have to convert my cogo points into just "points" or blocks in order to export them as a shape file. I cannot find a way to turn my cogo points into these other types and retain the OD on each.

I have done a lot searching but nothing seems to work. I have tried the following but the OD seems to get lost in the process (or maybe I messed something up along the way) :

• Exporting civil object to an SDF and then importing them back into the dwg (this turned the cogo points into just "points" but the OD was lost)
• Exploding the cogo points to blocks (this seemed to just delete all OD assigned)
• Converting the the cogo points to blocks (this also seemed to just delete all OD assigned)

Does anyone know a way to turn cogo points into "points" or block and retain their OD?

Thanks

[Udo_Huebner]

---

@Anonymous  schrieb:

...

Does anyone know a way to turn cogo points into "points" or block and retain their OD?

Should be an easy task with a customized lisp file. 

I posted already a Lisp Tool to convert Blocks to CoGOPoints and retain the OD.

https://forums.autodesk.com/t5/civil-3d-forum/convert-acad-point-to-cogo-point-with-object-data/td-p...

[Pointdump]

Hi Todd,
"...turn cogo points into "points" or block and retain their OD?"
What Object Data besides Raw Description is connected to your COGO Points?
Dave

[Anonymous]

Thanks I'll try that out.

[Anonymous]

Each point has 9 custom fields with hand entered information relating to manholes (depths, diameter, material, etc...). If it was only a few points I would just re-enter the OD on a block, but its thousands of points.

[Pointdump]

Todd,
I have an idea. Needs testing first. Can you post a drawing with a few of your points?
Dave

[Anonymous]

Here is it is.

[Pointdump]

Todd,
I don't see the custom fields. No UDP's or OD connected with the COGO Points. So basically you'd need to transfer the OD from the Polylines to the COGO Points and I don't know any programmatic way to do that.
Dave

[Anonymous]

Dave,

The OD data should be attached each point (the manholes that are displayed as an "S" in a circle). There may be few in there that haven't had the OD data attached. 

I have no problems with the ploylines, just the cogo points. The "MAPEXPORT" command isn't set up to export cogo points, so I'm looking to transfer this OD data onto blocks or regular points.

Going to try Udo's method when I figure out how to run the files he provided.

[Pointdump]

Todd,
OK, I see 'em now. I must have clicked on the only ones that didn't have any OD. My idea won't work. On to Udo's method.
Dave

[АлексЮстасу]

---

@Anonymous  написал (-а):

• Exporting civil object to an SDF and then importing them back into the dwg (this turned the cogo points into just "points" but the OD was lost)

---

When exporting to dwg from SDF (MAPTOACAD command!), you can save attribute data to XData.
You can convert data from XData to OD XD2OD.lsp from Autodesk.
But Udo_Huebner will make it clearly more convenient.
(I wrote in that topic that it would be good to immediately make such a lisp 😀).

[Udo_Huebner · Accepted solution]

OK, here is my LISP macro for placing blocks on CoGOPoints with transferring all ObjectData.

It is quick and dirty with minor error handling.

[Jeff_M]

@Anonymous the Sincpac-C3D add-on package currently has a tool to export cogo points to a SHP file. It creates the SHP file with all of the point data, including any UserDefinedProperties. It did not include OD, so I have just added that capability. Attached is a ZIP with the files created for one of the points in your sample dwg. If this is acceptable output I will create a new build that can be tested using a Trial activation for the Sincpac.

[АлексЮстасу]

Hi, Udo,

I have this now:

Command: UHBLOCKSONCOGOPOINTS
Blocks on CoGoPoints with copying OD by Udo_Huebner 2021 - Autodesk Forum.
Block <Map_Survey_Point> not defined yet.finished.

I do not have a block Map_Survey_Point until I import ASCII Point File. But this is long and not always successful.  🙂

[rl_jackson]

I've been following this conversation, only because of the OD stuff, and I'm a little bewildered as to why Map3D wouldn't be a better solution when transferring data. Wouldn't this not be just a matter of creating the data source considering the end use is GIS related?

[andrewofabley]

@Anonymous 

Somewhat-spatial guy here.

Attached is my take on an ESRI file geodatabase of your sample data.

I agree that it looks like lsp is the way to go here - unless you have access to other spatial tools (like I do).

Perhaps ask your spatial department?

Just note that because you have longer attribute field names, you may not want to use shape files for this (.shp).

Interested to see how you get on.

[samir_rezk]

Hi @Anonymous 

If your are using Civil 3D 2020.1 or later, there is an Export To FGDB command directly, along with the Publish to ArcGIS Online! The nice thing about these two commands is that any Civil 3D Property Set Definition automatically gets transmitted as GIS attributes in the GDB or Feature Layer (PSDs don't appear in the dialog to export, but they are automatically included!).

Attached is a Dynamo graph that will copy Object Data assigned to Cogo Points (in Dynamo Player simply specify is the OD Table Name, and the Point group to Copy!) and Dynamo will create the PSD and Property names matching what is available in the OD Table, then copy the values. once the data is copied to Property Set, you can export the Cogo Points using the Export to FGDB, and all the data will be included.

I have created a screencast to demonstrate (sorry no audio!); feel free to use the graph if you like!

Hope this helps,

[Udo_Huebner]

Hi @АлексЮстасу 

If you are looking for "map_survey_point" as Block, simply take it from my previously attached drawing.

You can use any block you like (if you modify the source code). Currently, the block only needs to have the attribute PTNUM.