Export points with object layer attribute

Export points with object layer attribute

danFZTT2
Observer Observer
3,262 Views
12 Replies
Message 1 of 13

Export points with object layer attribute

danFZTT2
Observer
Observer

My ultimate goal is to export points to format P,N,E,Z,D,Layer and I cannot seem to find a way to accomplish this, where the layer value is dynamically set based on the cogo point object property.

 

C3D allows you to modify the PNEZD format to include a user defined column (setup through the User-Defined Property classifications in Toolspace settings).

 

a) is there a way to automatically populate the layer using something like <[Layer]> as the contents of a user defined property that will auto populate upon export?

or

b) Is there a totally different way to go about achieving this?

 

Thanks,

Dan

0 Likes
3,263 Views
12 Replies
Replies (12)
Message 2 of 13

rl_jackson
Mentor
Mentor
Welcome to the fourms Dan
To answer you question in essence no there is no way to attach the layer that a point resides on within the point file format.

Now you can control the layer that points go to by useing description keys which read the raw description of the imported data and places the object in the drawing based on the values you establish for the particular point.

I guess a little more information on what your trying to achieve would be helpful to giving you a reasonable solution

Rick Jackson
Survey CAD Technician VI

Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature

0 Likes
Message 3 of 13

danFZTT2
Observer
Observer
What I am doing is exporting design points for layout by a surveyor. The survey controllers run Magnet field software which has the capability of easily toggling point visibility on or off based on layer only. (ie when all sets of design points are on unique layers [sanitary, storm, watermain] irrelevant layers can be toggled off to avoid clutter on the screen).
In CAD the design layout points are always meticulously placed on layers 'SAN' 'STORM' etc and exported either individually or as a group. This is where appending the layer onto the point export would be extremely helpful in order to differentiate point sets.
0 Likes
Message 4 of 13

Neilw_05
Mentor
Mentor

I don't know if you can achieve your goal with COGO point objects. However you can with blocks. The workflow would be to convert the COGO points to blocks using the utility. The resulting blocks will have the point data as attributes (ptno, elev, desc). Once you have them as blocks you can generate a delimited text file using several tools that are available. I suggest using a Map Report Query. The report query will generate a CSV file with all the properties you choose, including coordinates, block attributes, layer properties, etc.

Neil Wilson (a.k.a. neilw)
AEC Collection/C3D 2024, LDT 2004, Power Civil v8i SS1
WIN 10 64 PRO

http://www.sec-landmgt.com
0 Likes
Message 5 of 13

Neilw_05
Mentor
Mentor

By the way, the Data Extraction tool will generate a text file as well so that would be the recommended tool.

Neil Wilson (a.k.a. neilw)
AEC Collection/C3D 2024, LDT 2004, Power Civil v8i SS1
WIN 10 64 PRO

http://www.sec-landmgt.com
0 Likes
Message 6 of 13

rl_jackson
Mentor
Mentor
Does magnet allow you the ability to use the drawing itself or maybe xml would be a better solution

Rick Jackson
Survey CAD Technician VI

Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature

0 Likes
Message 7 of 13

ChicagoLooper
Mentor
Mentor

As rl_jackson mentioned you simply can't give a cogo a layer based on a value contained in a cogo's PENZD. What you'll need to do is create point groups so you can control the appearance of your cogo points. If the current cogo point groups do not provide a term (e.g. small, med, or large trees), then you must re-create your point groups or create point groups when none exist in the first place. When your point groups are re-created or created, you can categorize them: either 'include' or 'exclude' based on point numbers, elevation, raw description or full description. For example, all trees descriptions=sml, another for med, and another for large. Or all point numbers from 1 to 24, another from 25 to 49, and so forth. This will get tedious very fast. On top of that , you'll need to pay special attention to point styles and special attention to label styles if you are labeling them. Furthermore, styles, whether point styles or label styles, can crossover from one group to another, which may, or may not, make it messy for the All Points group, or the master group.

 

If it was me, I would take the cogo 'data' by click 'all points' in toolspace, then highlighting the PENZD from the panorama-thingy at the bottom.

Highlight selected cells or 'All' cells using shift+mouse, then paste to a spreadsheet.Highlight selected cells or 'All' cells using shift+mouse, then paste to a spreadsheet.

If you need to select all rows, click just one then ctrl-A which will select all. When they're all highlighted, right click and copy to clip board, then paste it to a spreadsheet. Edit the columns and rows in Excel so you'll get a nice, organized PENZD. You can do a lot from this PENZD, like dividing it up into 4 separate CSV's then using each one individually to insert cogo points.

 

If you are an advanced user and know your way around shapefiles, you can even go beyond the standard 5-columns of PENZD and make additional columns 6, 7, 8, etc., etc. Then create a shapefile from the spreadsheet with all your columns, where all the spreadsheet columns are used to generate the dbf, or the shapefile's attribute data. Then, use MAPIMPORT on the shapefile to bring it back into C3D. With know-how, this command will bring in and insert your own blocks using one of the tabular data columns to conveniently populate one of your block's attributes and act as the block's label. The remaining tabular data that wasn't used as a label will simply be 'object data' and give your blocks the impression they're on steroids.

 

Chicagolooper

EESignature

0 Likes
Message 8 of 13

danFZTT2
Observer
Observer

Importing the entire CAD file gives less control over what is being imported but I will try the xml and see if that works.

0 Likes
Message 9 of 13

ChicagoLooper
Mentor
Mentor

FYI, the procedure DATAEXTRACT doesn't work on cogo points. Even though that command lets you run through the entire wizard up until and including FINISH, it won't produce a file with data. It's a total fake-out.

1-The DATAEXTRACT wizard lets you select cogo points so you can extract 'data.'1-The DATAEXTRACT wizard lets you select cogo points so you can extract 'data.'

2-Cogo points have lots of data. Notice the slider on the right, more data than you can see.2-Cogo points have lots of data. Notice the slider on the right, more data than you can see.

3-The end result. What a scam! What a fake-out!3-The end result. What a scam! What a fake-out!

 

Chicagolooper

EESignature

0 Likes
Message 10 of 13

Neilw_05
Mentor
Mentor

My recommendation to use the Data Extract tool was in conjunction with converting the COGO points to blocks. Sorry if that wasn't understood.

Neil Wilson (a.k.a. neilw)
AEC Collection/C3D 2024, LDT 2004, Power Civil v8i SS1
WIN 10 64 PRO

http://www.sec-landmgt.com
0 Likes
Message 11 of 13

Anonymous
Not applicable

My (kinda) quick fix would be make a point group for each "layer" you want.  For example you might want all points coded EP or TP as pavement "layer" or all FL points to be a "flowline" layer.  then export each point group to a csv file and add the layer column in excel then paste them all together.

 

 

0 Likes
Message 12 of 13

danFZTT2
Observer
Observer

This is what I currently do and it works, only problem being when I want to export all of my STORM, SAN, WM, ROAD, CURB etc. into one file it can become a bit cumbersome. I'm starting to think the way I currently do it is the fastest/most efficient way...


Thanks,

0 Likes
Message 13 of 13

Neilw_05
Mentor
Mentor

Keep in mind, converting the points to blocks does not have to be permanent. In other words you don't have to save your work. Just convert, export and then close without saving. Should be quick and easy. You can even save the DATA Extract parameters for other jobs.

Neil Wilson (a.k.a. neilw)
AEC Collection/C3D 2024, LDT 2004, Power Civil v8i SS1
WIN 10 64 PRO

http://www.sec-landmgt.com
0 Likes