TheSwamp

CAD Forums => Vertically Challenged => Land Lubber / Geographically Positioned => Topic started by: CHulse on April 19, 2012, 08:18:58 AM

Title: Import COGO pooints from ESRI shp?
Post by: CHulse 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
Title: Re: Import COGO pooints from ESRI shp?
Post by: mjfarrell 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
Title: Re: Import COGO pooints from ESRI shp?
Post by: CHulse 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
Title: Re: Import COGO pooints from ESRI shp?
Post by: Mark on April 19, 2012, 08:50:03 AM
can we see the shape file?
Title: Re: Import COGO pooints from ESRI shp?
Post by: CHulse 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
Title: Re: Import COGO pooints from ESRI shp?
Post by: Mark 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.
Title: Re: Import COGO pooints from ESRI shp?
Post by: mjfarrell 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!
Title: Re: Import COGO pooints from ESRI shp?
Post by: Mark 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?

Title: Re: Import COGO pooints from ESRI shp?
Post by: mjfarrell 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.
Title: Re: Import COGO pooints from ESRI shp?
Post by: mjfarrell 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!
Title: Re: Import COGO pooints from ESRI shp?
Post by: Mark on April 19, 2012, 11:11:55 AM
Thanks Michael. I'll have a look at it in a bit.
Title: Re: Import COGO pooints from ESRI shp?
Post by: mjfarrell 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....? ? ?
Title: Re: Import COGO pooints from ESRI shp?
Post by: Mark 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.
Title: Re: Import COGO pooints from ESRI shp?
Post by: mjfarrell 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.
Title: Re: Import COGO pooints from ESRI shp?
Post by: Mark 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.
Title: Re: Import COGO pooints from ESRI shp?
Post by: Mark on April 19, 2012, 01:41:55 PM
Quote
Being sure to pass that file through Excel to scrub the NON ascii code from the file
*SIGH* Why do they do that!
Title: Re: Import COGO pooints from ESRI shp?
Post by: mjfarrell on April 19, 2012, 01:56:30 PM
Quote
Being sure to pass that file through Excel to scrub the NON ascii code from the file
*SIGH* Why do they do that!
I've only been complaining about this and some other crap for over 6 years now.   :evil:

An most want to paint me as the bad guy, because I vetch about it, and autodesk won't even admit that it is a problem.
Title: Re: Import COGO pooints from ESRI shp?
Post by: CHulse on April 19, 2012, 05:52:32 PM
Thanks for the tutorial on this. I'll need to play through the process a few times and get more comfy with it.
Thanks for the help