Jump to content

Recommended Posts

Posted

Hi all

 

I've been out in the garden today measuring the undulating lay of some of the land.  It all slopes gently downhill, but to varying degrees in different places.  I have measured at different points and now have a bunch of "at this distance, the ground is this height" figures.  

 

It would be really helpful to visualise this and I wondered if there is some kind of on line "app" or similar which will allow me to punch in these figures and produce a visual representation of them.  

 

Anyone have any ideas?

 

Many thanks

Posted

I would create an array and plot them as a surface in Matlab (excel would do at a push), but I know this marks me out as weird.

Posted

Thanks dnb...  I'll reserve judgement on the weird bit until I understand what you mean :)  

 

If you're able to explain that in a more dumbed down step by step I'd massively appreciate it.  I have excel.  In fact, I use it so often that I have been known as Maxcel in the past!  But a lot of its features I'm completely ignorant on.  

 

Cheers 

 

Max

(cel)

Posted

Would you mind sharing the data? I can knock up an example in a couple of minutes. It might not be exactly what you are looking for but there's not a lot to loose.

Posted (edited)

Something like this.

Just punch in the numbers, use conditional formatting to colour in the cells after they have been resized so that height and width are equal.

 

Heights.jpg

 

Or chart it.

 

 

heights 2.jpg

Edited by SteamyTea
Posted (edited)

 

Was thinking of a 3d chart based on data constructed as SteamyTea has done. There always used to be a 3d surface chart in Excel - just select the data grid and select the 3d chart option.

 

Here's an example from Matlab.

image.png.2ccbf56580daddabb6ed4d6c07ebe410.png

Edited by dnb
Posted

Here's an excel version. It is now called "surface plot". I was thinking about an older version of excel.

Capture.JPG

  • Like 1
Posted

I could create a surface mesh in AutoCAD with the data. This sort of thing. The survey ideally to be done with spot heights on a regular grid:

 

1701465432_Pointpatch.jpg.4dcceae2960f3a6ccd7f050ceca0e977.jpg

Posted

What can I say... WOW!  Many thanks :)  I'm well impressed.  I only wish I had the data to do any of the above justice!  I don't though unfortunately.  All I have is length and height, so I was thinking more of a 2D plot of the data....  I'm more than happy to share the figures if anyone can do anything with them.  I have to admit though that - having never done anything like this before - I really was just making it up as I went along.  In hindsight, I should have measured at regular intervals rather than the random intervals I chose.  But the reason was because the land is very unimproved grassland and so I avoided measuring height where there were big grassy clumps or other irregularities underfoot.  

 

So here are those figures:

 

Distance CM Height CM
140 15
330 30
510 39
750 45
1280 60
1520 60
1790 85
2020 97
2270 110
2530 125
2660 129
2820 132
2930 137
3130 137
3370 141
3650 137
3960 138
4000 145
4120 149
4290 147
4510

142

 

 

Huge thanks 

Posted
20 minutes ago, Oxbow16 said:

What can I say... WOW!  Many thanks :)  I'm well impressed.  I only wish I had the data to do any of the above justice!  I don't though unfortunately.  All I have is length and height, so I was thinking more of a 2D plot of the data....  I'm more than happy to share the figures if anyone can do anything with them.  I have to admit though that - having never done anything like this before - I really was just making it up as I went along.  In hindsight, I should have measured at regular intervals rather than the random intervals I chose.  But the reason was because the land is very unimproved grassland and so I avoided measuring height where there were big grassy clumps or other irregularities underfoot.  

 

So here are those figures:

 

Distance CM Height CM
140 15
330 30
510 39
750 45
1280 60
1520 60
1790 85
2020 97
2270 110
2530 125
2660 129
2820 132
2930 137
3130 137
3370 141
3650 137
3960 138
4000 145
4120 149
4290 147
4510

142

 

 

Huge thanks 

 

How wide's the plot?

Posted
18 minutes ago, SteamyTea said:

What like this

 

Yes!!!  Well, almost....  You'll have to forgive me if I gave the data wrong, or gave it in the wrong way  It's been a very long day and my mind's a bit frazzled!  

 

The land slopes downhill, so the graph is correct other than that it should start high and end low...  Is that possible?  

 

Sorry for all the confusion and thanks for the great help.

Posted (edited)
6 minutes ago, SteamyTea said:

You can reverse axis in Excel

Though I suspect this is not what you meant.

 

No, I'm afraid not. But I think I've got it...  Adding a minus to each height figure in the excel sheet does what I'm after...  Got there in the end thanks to you guys :) 

 

Edited by Oxbow16
Posted
5 minutes ago, Oxbow16 said:

It varies...  There are no straight lines here!

How are you measuring.

The easy way to do it is to stick in some stakes so that they are the same distance above the ground, they use a leveller to measure the height of each stake.

You need to do this on a grid as mentioned earlier. 

 

You can make your own leveller with a hosepipe, bit of clear pipe and a tape measure.

Start with the highest point and work downhill.

Posted

What I did was quite crude tbh, and not particularly accurate either I'm sure.  But close enough for now.  I used string and started it just above ground level then put in two stakes along the length of land.  I attached the string to them, keeping it as tight as possible.  I'm guessing there must have been a little bit of bow to the string, but none that I could see when looking down the line so nothing major.  I used a spirit level to level the string, and then a tape measure to measure then height at the various points....  

 

Posted

If you want more detailed terrain information your site may have freely available lidar data for it.

 

Below is some terrain maps I made for a members much larger site which has a quarry in it.

 

1496159052_groundcontours.thumb.jpg.62e467fc302fe0f6a17ad34f647fecf6.jpg3D.thumb.jpeg.fef3960e0998b2afc7ab806bd81a44ea.jpeg

 

You can put sections though the 3D map.603697597_profileline.jpg.957d4fbd7b2432ec6ccc136c1ac4cbee.jpg

profile.thumb.png.fbee1806f84be67d4247601d949aa8bd.png

For my own site I made a 3D surface of my existing site from the survey data. This has been really useful for working out areas and volumes of cut from the site.

Posted

My (indoor) laser was not good enough fir working out land levels over our site, so I did it at dusk (Nearly dark) which multiplied many times the distance it would cover!

Posted
1 minute ago, joe90 said:

My (indoor) laser was not good enough fir working out land levels over our site, so I did it at dusk (Nearly dark) which multiplied many times the distance it would cover!

You had the flattest site in the whole of the West Country.  The curvature of the Earth is almost greater.

  • Haha 1
Posted
43 minutes ago, SteamyTea said:

You had the flattest site in the whole of the West Country.  The curvature of the Earth is almost greater.


which is why it was so difficult to work out where the drainage would go, over 1 acre I had a drop of 500mm in one corner.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...