Author Topic: Import COGO pooints from ESRI shp?  (Read 11210 times)

0 Members and 1 Guest are viewing this topic.

CHulse

  • Swamp Rat
  • Posts: 504
Import COGO pooints from ESRI shp?
« on: April 19, 2012, 08:18:58 AM »
Is it possible to import an ESRI point shape file as C3D points retaining attribute data as decriptions?

Thanks in advance
Cary Hulse
Urban Forestry Manager
Wetland Studies and Solutions

Civil 3D 2020 & 2023

mjfarrell

  • Seagull
  • Posts: 14444
  • Every Student their own Lesson
Re: Import COGO pooints from ESRI shp?
« Reply #1 on: April 19, 2012, 08:27:07 AM »
Yes it is...

However remember you will not SEE the attribute data
until you save the file
and attach it as a source
and then run a query against that source file

I think you can also now get it
from attaching to the source (SHP) file
on the display manager tab of the Map Worspace
and then performing a 'bulk copy' of the data from the SHP file into your Map session.
I would want to test to confirm the results
Be your Best


Michael Farrell
http://primeservicesglobal.com/

CHulse

  • Swamp Rat
  • Posts: 504
Re: Import COGO pooints from ESRI shp?
« Reply #2 on: April 19, 2012, 08:30:25 AM »
ok, noob to c3d here, so please speak slowly and use small words...

I know how to bring the data in (via map task pane). I would like to have them as COGO points so I can manipulate the dragged state of the descriptions (lots of points and I need leaders to display them)

thanks for the quick reply
Cary Hulse
Urban Forestry Manager
Wetland Studies and Solutions

Civil 3D 2020 & 2023

Mark

  • Custom Title
  • Seagull
  • Posts: 28762
Re: Import COGO pooints from ESRI shp?
« Reply #3 on: April 19, 2012, 08:50:03 AM »
can we see the shape file?
TheSwamp.org  (serving the CAD community since 2003)

CHulse

  • Swamp Rat
  • Posts: 504
Re: Import COGO pooints from ESRI shp?
« Reply #4 on: April 19, 2012, 09:03:55 AM »
Sure - it's attached. It's trees - what I want is the tree ID number and botanical name to be displayed as the description. Right now I have them in dynamic blocks with attribs, but I would like to have th ability to set up the dragged state with the automatic leaders...

thanks
Cary Hulse
Urban Forestry Manager
Wetland Studies and Solutions

Civil 3D 2020 & 2023

Mark

  • Custom Title
  • Seagull
  • Posts: 28762
Re: Import COGO pooints from ESRI shp?
« Reply #5 on: April 19, 2012, 09:46:29 AM »
Yes it is...

However remember you will not SEE the attribute data
until you save the file
and attach it as a source
and then run a query against that source file
I see no way to query that data. I've got 'points' with one field from the original shape file but it's object data, I think.
TheSwamp.org  (serving the CAD community since 2003)

mjfarrell

  • Seagull
  • Posts: 14444
  • Every Student their own Lesson
Re: Import COGO pooints from ESRI shp?
« Reply #6 on: April 19, 2012, 10:02:51 AM »
Yes you must
A) impost the SHAPE file
B) in the dialog box you MUST have it also create the OBJECT data
then you Save and close the file you just imposrted that SHP file into.
then you open a new file
attach the file you just saved above as a source
you then QUERY in the data
using the ALTER properties operation to add TEXT based on the Object data table you created during the shape file import operation above.
then you will have point objects, and text
or you perform the same query in a REPORT mode and export the X,Y and the object data value to a TXT file that you then import as a point file.
Being sure to pass that file through Excel to scrub the NON ascii code from the file that MAP writes to what should be an ascii text file but isn't; and do a save as to either CSV or TXT to to bring in the point data as point (cogo) data.

And have a nice day!
Be your Best


Michael Farrell
http://primeservicesglobal.com/

Mark

  • Custom Title
  • Seagull
  • Posts: 28762
Re: Import COGO pooints from ESRI shp?
« Reply #7 on: April 19, 2012, 10:46:26 AM »
Quote
using the ALTER properties operation to add TEXT based on the Object data table you created during the shape file import operation above. then you will have point objects, and text
Ok, got that but how do you get the text into a civil 3d point?

TheSwamp.org  (serving the CAD community since 2003)

mjfarrell

  • Seagull
  • Posts: 14444
  • Every Student their own Lesson
Re: Import COGO pooints from ESRI shp?
« Reply #8 on: April 19, 2012, 11:06:01 AM »
Quote
using the ALTER properties operation to add TEXT based on the Object data table you created during the shape file import operation above. then you will have point objects, and text
Ok, got that but how do you get the text into a civil 3d point?
you run the report query and extract data from the Object data table like I said
you may need to create a new point file format depending on how much data you want to bring in with your trees X and Y up to NINE fields.
Be your Best


Michael Farrell
http://primeservicesglobal.com/

mjfarrell

  • Seagull
  • Posts: 14444
  • Every Student their own Lesson
Re: Import COGO pooints from ESRI shp?
« Reply #9 on: April 19, 2012, 11:10:25 AM »
note there is a Tree Points. txt file included...

it has NOT been stripped of the extra code it should not have in it!
Be your Best


Michael Farrell
http://primeservicesglobal.com/

Mark

  • Custom Title
  • Seagull
  • Posts: 28762
Re: Import COGO pooints from ESRI shp?
« Reply #10 on: April 19, 2012, 11:11:55 AM »
Thanks Michael. I'll have a look at it in a bit.
TheSwamp.org  (serving the CAD community since 2003)

mjfarrell

  • Seagull
  • Posts: 14444
  • Every Student their own Lesson
Re: Import COGO pooints from ESRI shp?
« Reply #11 on: April 19, 2012, 11:16:36 AM »
Thanks Michael. I'll have a look at it in a bit.

I am so sure I've taken you through this process inn the past....? ? ?
Be your Best


Michael Farrell
http://primeservicesglobal.com/

Mark

  • Custom Title
  • Seagull
  • Posts: 28762
Re: Import COGO pooints from ESRI shp?
« Reply #12 on: April 19, 2012, 12:47:20 PM »
Thanks Michael. I'll have a look at it in a bit.
I am so sure I've taken you through this process inn the past....? ? ?
Don't think so. I never do reports from within Map.
TheSwamp.org  (serving the CAD community since 2003)

mjfarrell

  • Seagull
  • Posts: 14444
  • Every Student their own Lesson
Re: Import COGO pooints from ESRI shp?
« Reply #13 on: April 19, 2012, 12:54:38 PM »
Thanks Michael. I'll have a look at it in a bit.
I am so sure I've taken you through this process inn the past....? ? ?
Don't think so. I never do reports from within Map.
You say that to all the girls.
Be your Best


Michael Farrell
http://primeservicesglobal.com/

Mark

  • Custom Title
  • Seagull
  • Posts: 28762
Re: Import COGO pooints from ESRI shp?
« Reply #14 on: April 19, 2012, 01:14:10 PM »
OK, got it! Wow that is cool. Thanks again Michael. That is a pretty handy little trick.

For the record this is what my report dialog looks like.
TheSwamp.org  (serving the CAD community since 2003)