2D topo survey to 3D

[Anonymous]

Morning, 

I'm sure I've seen this done before.

I'm aware that you can move text to elevation, but can I set the elevation of the nearest point to the elevation of the test also? 

Cheers,

John 

[neilyj666]

I'd suggest you revert back to the supplier of the 2D survey and get them to supply it in 3D - what use did they think a 2D survey would be to anyone...!?!?!?!?!?

Using the elevations as text assumes that the insertion point of the text is at the actual survey point which isn't always the case and may or may not matter for any particular situation.

Attached is a dll that I use for these (all too familiar) situations which works reasonably well but you may need to edit the locations of the text as the dll flags up  "confusable" points

[neilyj666]

Can't attach or rename the dll so try this https://1drv.ms/u/s!ArDb0HZEyQjlsggXlvcVkVabzDQP?e=DrPdqH

[Pointdump]

John,
"...can I set the elevation of the nearest point to the elevation of the test also?"
I don't understand. Nearest point of what? More details please. Posting a DWG or ScreenShot would help.
Dave

[TerryDotson]

Does every flat polyline have a text object?  In that case a tool could find the polyline crossing the label box and set it's elevation to the text value.  Why not post a drawing of the polylines?

[Anonymous]

Essentially, after moving text to elevation, is there a way to assign that elevation to the nearest point (OBS_marker or Level point) to give a more accurate surface? 

[TerryDotson]

Almost anything can be accomplished, but NOT from a screen capture.

[neilyj666]

This is exactly what the dll I linked to earlier will do but if the "+" and text are too close then "confusable" points occur where the routine doesn't know which "+" to assign the level to.

[Anonymous]

Cheers, Terry. That's great. 

[AllenJessup]

It looks like the text is a standard offset from the point marker. Either copy the drawing or copy the text (to preserve the original). Then select all the text and move it so that the insertion point of the text is at the marker. Then move the text to elevation. To get polylines at elevation. Create a Surface from the text at elevation, then create featurelines from the polylines and have them assume the elevation from the surface. If you need them to be polylines not featurelines. Explode the featurelines.

[neilyj666]

---

@AllenJessup wrote:

It looks like the text is a standard offset from the point marker. 

---

@Anonymous  If this is the case throughout then it becomes significantly easier and it is as @AllenJessup described

[Anonymous]

Unfortunately it's only a small amount of text near the points as shown in the screen grab. The remainder are at different offsets and orientations. Thanks though!

[AllenJessup]

What are the point markers? Can you post a drawing with a couple of examples? Are all points along polylines or just some?

[neilyj666]

@Anonymous  Did you try the dll I posted?

[ChicagoLooper]

If you can select all the text and move the text as a group, all at once, to where they need to go, then this can be done easily without using 3rd party software. If you can't move them all at once, then would it be possible to move them in a few groups, say around four groups, moving only one group-at-a-time? The goal is to move all text to their 'target' location, because once they're in the right spot, then you're home free.

Assuming you have already moved all the text, you can use DATAEXTRACTION command. This command is capable of collecting the Easting, Northing, and the elevation value and put them neatly into xls format. Once in xls, you can easily edit them to PENZD (or some other acceptable form) then save as a csv file. Since the Dataextraction command collected the x-and y-coordinates as well as collected the text's CONTENT, which in this case was the elevation, you can create a formatted list of points and save the list as a csv file, e.g. PENZD with csv extension, which as you already know, can be used to insert cogo points.

The DataExtraction process is highlighted in images 1, 2 and 3 (Pages 4, 5 and 6 of the Dataextraction command). Image 4 shows the resulting xls file you get from Dataextraction. Image 5 shows an edited version of the xls.

Image 1.

Image 2.

Image 3.

Image 4.

Image 5..

If you want to insert the actual MTEXT instead, then that can be done too, by combining QUERY and ALTER PROPERTIES functions. The former will find, gather and insert your text while the latter function will move, or elevate your mtext to its proper elevation or z-value.

[Anonymous]

Hi Allen,

I've attached  the drawing for you to have a better feel of what I'm describing. 

[AllenJessup]

I'll take a look when I can. Things are busy this morning.

[ChicagoLooper]

Your text is not really mtext, it's a block. You can still move the text to its appropriate elevation by using Express Tools, specifically the TXT2MTXT command then pasting the text into a spreadsheet. I'm sure there are various ways to do this and this quick, down-N-dirty way, is one of them. You'll have to explode the block in order to access the individual text entities, but once the text is formatted and pasted in a spreadsheet, you're good to go.

1. Explode the block. You may have to do this more than once to get down to the individual text level. Since you have 10 rows + the header and 4 columns, you'll end up with 44 individual text entities. Image-1.
2. Use TXT2MTXT command or go to Express Tools=>Text Panel=>Convert to Mtext Icon then select all 44 individual text entities. Image-2.
3. The TXT2MTXT command will convert the 44 individual pieces of text into a single mtext. With less than 3 minutes of formatting in the mtext editor, e.g. tab, delete, spacebar, enter, whatever, whatever, your new mtext will look like this. Image-3.  
4. Copy and Paste this new mtext into a spreadsheet. With a additional formatting, you can customize the columns in your spreadsheet so they'll be 'recognized' as an appropriate input in C3D. The format PENZD works well. Image-4.
5.  Finally, save the spreadsheet as a csv file. Use the correct template, either metric or imperial, and use this csv as your input for cogo points. Be sure to check the box named Do elevation adjustment if possible. Image-5.
6. Down-N-dirty, the points in modelspace. Image-6.

Image-1.

Image-2.

Image-3.

Image-4.

Image-5.

Image-6.

[TerryDotson]

I believe the action is up around coordinates of X=2231400.00 Y=550500.00.

See the image in post #6.

[neilyj666]

@Anonymous I see the Survey Draft.dwg originated from LSS so going to my first post (Message 2) can you revert to the original survey supplier and get them to export the LSS Survey as a 3D survey and include the DTM triangles? 

It's a long shot but have you checked that the DTM triangles are not on a frozen/hidden layer?

The text block in the Survey Draft dwg is the standard LSS export to DXF for the control stations that exist in the LSS Survey and as such are not much use for anything else.

My experience of LSS exports is that the level text can be in all sorts of weird locations relative to the actual survey point (rotated/offset in any direction etc) so even the SurveyFix dll I posted has some difficulty in resolving which text is attributed to which point