Reversing Elevations in Point File

[TerraSondLtd]

I'm needing to build a surface of the ocean floor and the point data I have has negative values for elevations above sea level and positive for below. I need to be able to reverse the elevations so that anything below sea level has a "-" and above in positive.
Can anybody help! Is there a way in Civil 3D to "invert" the surface?

[Anonymous]

I don't know of a way to handle it in C3D. If it were handed to me to do.
I'd take the points out to a spreadsheet and change the sine there.

If the surfaces are already built. Importing the points with the same point
numbers and overwriting the original points may be a magic bullet. But only
if the points were the only thing used to build the surface.

Allen

wrote in message news:5887664@discussion.autodesk.com...
I'm needing to build a surface of the ocean floor and the point data I have
has negative values for elevations above sea level and positive for below. I
need to be able to reverse the elevations so that anything below sea level
has a "-" and above in positive.
Can anybody help! Is there a way in Civil 3D to "invert" the surface?

[Anonymous]

Hi,

Without changing the points, you could build a second surface as a plane at
elevation zero and then create a volume surface which in effect would mirror
image the one you have about elevation zero.

--


Regards

Laurie Comerford
wrote in message news:5887664@discussion.autodesk.com...
I'm needing to build a surface of the ocean floor and the point data I have
has negative values for elevations above sea level and positive for below. I
need to be able to reverse the elevations so that anything below sea level
has a "-" and above in positive.
Can anybody help! Is there a way in Civil 3D to "invert" the surface?

[Matt.Anderson]

Edit Point Datum?

[Anonymous]

Nice easy solution... the benefit being that if any changes are made to the
points... edits, etc... then all that is needed is a rebuild of the
"mirror" surface.

"Laurie Comerford" wrote in message
news:5887726@discussion.autodesk.com...
Hi,

Without changing the points, you could build a second surface as a plane at
elevation zero and then create a volume surface which in effect would mirror
image the one you have about elevation zero.

--


Regards

Laurie Comerford
wrote in message news:5887664@discussion.autodesk.com...
I'm needing to build a surface of the ocean floor and the point data I have
has negative values for elevations above sea level and positive for below. I
need to be able to reverse the elevations so that anything below sea level
has a "-" and above in positive.
Can anybody help! Is there a way in Civil 3D to "invert" the surface?

[arnolds]

I used to do the exact same thing all the time. By all the time I mean millions of points a month. What I did was just write a VBA app that I ran from Civil 3D that opened the point file, read a line, subtracted the elevation from 0, then wrote the line to a new file. That way we kept the original point file and had an "inverted" file. On our machines it took about 40 seconds to invert a file of half a million points.

I may still have it kicking around somewhere if you're interested but it wouldn't be that hard to write.

[Anonymous]

TerraSondLtd wrote:

> Can anybody help! Is there a way in Civil 3D to "invert" the surface?

I'm adding an Invert button my Surface Manager today. If you want,
export your surface to XML and email it to me dotson [at] dotsoft [dot]
com and I'll send it back inverted.

Terry
--
Never start any job without the right tools!
AutoCAD Add-on Tools at http://www.dotsoft.com

[Anonymous]

that would be great! can you post it here?
--
Lisa Pohlmeyer
DC CADD - Austin, TX
Civil 3D 08 SP2
Intel Core 2 Duo,3Gb RAM
Nvidia Quadro Fx570M 512Mb

arnolds wrote:
> I used to do the exact same thing all the time. By all the time I mean millions of points a month. What I did was just write a VBA app that I ran from Civil 3D that opened the point file, read a line, subtracted the elevation from 0, then wrote the line to a new file. That way we kept the original point file and had an "inverted" file. On our machines it took about 40 seconds to invert a file of half a million points.
>
> I may still have it kicking around somewhere if you're interested but it wouldn't be that hard to write.

[arnolds]

OK, here it is, just keep a few things in mind.
- It was written as a quick and dirty process to work with the files we had and they should follow a certain format: XYZ or YXZ with a space or comma delimiter. The parsing routines could probably use some work
- It was written a few years ago but should still work
- it will take a text file with any extension and write out a .cor file when it is complete
- it doesn't have a lot of options (see the quick and dirty comment above)

It should at least get you started.

[Anonymous]

Thanks!

Hey Melissa @ Terrasond (if it's you) give this a go!
--
Lisa Pohlmeyer
DC CADD - Austin, TX
Civil 3D 08 SP2
Intel Core 2 Duo,3Gb RAM
Nvidia Quadro Fx570M 512Mb

arnolds wrote:
> OK, here it is, just keep a few things in mind.
> - It was written as a quick and dirty process to work with the files we had and they should follow a certain format: XYZ or YXZ with a space or comma delimiter. The parsing routines could probably use some work
> - It was written a few years ago but should still work
> - it will take a text file with any extension and write out a .cor file when it is complete
> - it doesn't have a lot of options (see the quick and dirty comment above)
>
> It should at
> least get you started.

[TerraSondLtd]

That would be great, if you still have it I would really appreciate it.
texassueg@yahoo.com

[arnolds]

See the post above.. download ChangeXYZ.zip

[TerraSondLtd]

It's not Melissa from Terrasond, it's Sue from the office in Alaska.

It worked great, thanks a lot.

Sue G

[Gangrangan]

Of course u could. I want to give u info, that may be useful.. I hope it's running well.

A. This session operate in Land Desktop
1. Go to “Point-Edit Point” and please select “All list point”
2. Right click on the column and select “Print point to file” (the extension of the file generally in “.TXT).e.g. D:\waterlevel.txt
3. Now please make file name and put your new file in your right folder


B. This session operate in Notepad and Excel spreadsheet.

1. Open the file on D:\waterlevel.txt with Notepad or WordPad
2. Select all file and then click copy.
3. Open Excel spreadsheet and Paste.

C. This the main of work. (Editing Water level in Excel)
1. Put your cursor in Elevation column.
2. Click Ascending or descending icon.
3. Select all of the plus level
4. Go to Format—cell—custom..
5. Choose this item #,##0
6. Under the Type row change this #,##0 with this -0
7. Click OK…
8. Select the Minus group that originally from Land desktop point to make the minus row not mixing with the plus row; generally I insert one row first.
9. After select the Minus row, go to Find. On the Find File Dialogue box Top Row type this “-‘
10. Click replace on the right side.
11. Pres space bar on Replace row.

Ok.. Everything looks like clear now… The last thing are…Delete the row that u already insert before and then save the file with the “Text (Tab Delimited) extension..

After all u can re-import the point chose replace on the dialogue box when AutoCAD Landesktop asking you to Renumber or Replacing the point number.

Il be happy if it is work correctly.

Muslih9391991@yahoo.com