Reporting from Stakes

[AndrewRC]

I am a boundary surveyor and spend my time trying to sort out peoples problems with the location of their boundary lines. I align my surveys to the (UK) OS National Grid and if we submit the findings to the Land Registry I need to know the Eastings and Northings for each change in direction the boundary line takes. No Z coordinate, only X and Y.

Using the Stake tool makes marking these changes in direction really easy, what I would like to do is create a report for each Stake instance with a number and the two coordinates in. Nothing fancy, just three columns.

Try as I might I cannot find a way of doing this, is anyone out there able to help, or to suggest another way I can gather this information?

VW2020 SP6 on Windows10

Andrew.

[Pat Stanford]

Not tested in VW2020, but very easy in 2021 and I think the same in 2020.

 

Create a worksheet.

In the worksheet right click on a row header (I usually start with Row 3 as this leaves room to add labels above) and choose Create Report. You will get a dialog box that looks similar to the one in the picture below.

 

Set the Basic Criteria to Object With a Record and the Record you are looking for a Stake.

In the Columns Section, choose Records:Stake and then in the left hand window scroll down until you Find ID then hit the Add>> button.

Change the Select From to Functions. Scroll down to find XCoordinate and YCoordinate and Add>>

Click the OK button. 

You should now have a database of all of the stakes in the drawing with their X and Y positions.

 

Ask again if you need more help.

 

 

[AndrewRC]

Works like a treat, and I have learned a lot, but ... unfortunately the latitude and longitude values are not accessible (they are different to the inserted X and Y position). I think they must be calculated as part of the Stake function itself and inserted as a text string rather than stored as a retrievable value. Shame.

Presumably if I can discover the conversion factors I can create a custom function/calculation.

Persistence is key!

Andrew

[Pat Stanford]

It looks like Lat and Long are in the stake object but hidden. You can type an equals followed by the following text in any database header row Call(ie. 3, not 3.1, 3.2 etc).

 

='Stake Object'.'Latitude'

='Stake Object'.'Longitude'

='Stake Object'.'Latitude WGS84'

='Stake Object'.'Longitude WGS84'

='Stake Object'.'Easting'

='Stake Object'.'Northing'

 

You can enter this in place of the XCoordinate/YCoordinate formulas.

[Tom W.]

Hi Pat I was really impressed that you found these hidden fields but then when I try them I get '#NAME?' in the database rows...?

 

[Pat Stanford]

I just reread my message. I think I told you to put double equals signs. Just copy/paste one line from my earlier message into the database header row. Nothing before and nothing after.

 

[Tom W.]

No haven't used double equals I think the formulas are correctly entered they just aren't returning anything...?

If I use one of the available fields it's fine:

[AndrewRC]

Yes, I get the same as Tom 😞

[Pat Stanford]

I am in VW2021, so it is probable that this is something that was added in 2021 that neither of you have in 2020.  :-(

 

At least Latitude and Easting work for me. I have not tested the others.

 

But try typing it in instead of copy/paste. Perhaps there are hidden characters from the forum that we can't see that are making VW think it is something different.

 

Sorry.

[AndrewRC]

Thanks for all your efforts and patience Pat, very much appreciated - and I have learned something else along the way as well.

Andrew

[Pat Stanford]

Thinking back on it, I think I submitted a request on Stakes back a couple of years ago to get the Lat/Long fields accessible. I guess VW does listen to users after all. It seems to be a reasonable implementation.

[mmiranda]

Hi all, 

 

I managed to do a worksheet with easting and northing from a stake object with the help of this conversation. 

 

But I got numbers with three zeros more, before the come, than the ones from the topo survey, do you know what might be happening or how we can change the precision for these?! 

My point are the ones with ID number and the worksheet. And the point 1 in the worksheet is also referenced in the document with black numbers horizontal and vertical by the topographer. 

 

Many thanks 

 

[Pat Stanford]

Sounds like a Units problem.  Are your dimension being reported in milimeters versus the topo being reported in meters?

[mmiranda]

I'm in meters, can I change the units of the stake objects?! 

 

[Pat Stanford]

Image from VW2025. Yours may looks slighlty different depending on VW Version and how you have the stake object set.

 

[mmiranda]

sorry I can't find it , I'm using 2023. see attached image 

[mmiranda]

.

 

[Tom W.]

Do you need to change 'Label Reference' to something that uses units i.e. not 'ID'?

[mmiranda]

Hi Tom, 

No, that's not the case. Label reference is what I want to see in the drawing which is this case is the stakes ID. 

I can change it to coordinates and it show coordinates but I can't control the scale. 

[mmiranda]

and in this case I wanted to change the units of what is seen in the worksheet.

 

[Tom W.]

Ok sorry I didn't read the whole thread, just the bit about the 'Coordinate Units' parameter not displaying in the OIP.

 

I have checked + I'm finding that Stakes are returning their Easting + Northing values in mm regardless of the Units settings for the document or the Coordinates Units parameter. So unless I'm missing something it looks like your only option is to do some maths in the database header row to convert the mm to m or km. It does feel that something fishy is going on with this. When I format the cells to use dimension format I am getting strange results.

[mmiranda]

Thanks Tom, 

That might be a solution, I am not used to the formulas, could you help me? 

I wrote this copied from this forum: ='Stake Object'.'Easting'

if I now right ='Stake Object'.'Easting'/1000 would it give me the values in meters, is '/' the right sign to use? do I need any '' ?

[Tom W.]

7 minutes ago, mmiranda said:

if I now right ='Stake Object'.'Easting'/1000 would it give me the values in meters

 

Correct!