AndrewRC Posted March 25, 2021 Share Posted March 25, 2021 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. Quote Link to comment
Pat Stanford Posted March 25, 2021 Share Posted March 25, 2021 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. Quote Link to comment
AndrewRC Posted March 25, 2021 Author Share Posted March 25, 2021 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 Quote Link to comment
Pat Stanford Posted March 25, 2021 Share Posted March 25, 2021 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. 1 Quote Link to comment
Tom W. Posted March 25, 2021 Share Posted March 25, 2021 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...? Quote Link to comment
Pat Stanford Posted March 25, 2021 Share Posted March 25, 2021 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. Quote Link to comment
Tom W. Posted March 25, 2021 Share Posted March 25, 2021 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: Quote Link to comment
AndrewRC Posted March 25, 2021 Author Share Posted March 25, 2021 Yes, I get the same as Tom 😞 Quote Link to comment
Pat Stanford Posted March 25, 2021 Share Posted March 25, 2021 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. 1 Quote Link to comment
AndrewRC Posted March 25, 2021 Author Share Posted March 25, 2021 Thanks for all your efforts and patience Pat, very much appreciated - and I have learned something else along the way as well. Andrew Quote Link to comment
Pat Stanford Posted March 25, 2021 Share Posted March 25, 2021 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. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.