Jump to content

Looking for an app which I can use to show me the gradient of my land....


Recommended Posts

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

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

 

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
Link to comment
Share on other sites

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 

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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....  

 

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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...