Solved

How can I write (smart) XYZ from table with multiple Z fields

  • 5 August 2019
  • 2 replies
  • 0 views
cyrusa
Rank
Badge

Hi all,

I have a table with (XYZ) coordinates measured in time. Each time the Z-value (field J and further) of the specific point changes. The XY-coordinates (field E and F) stay the same. Sometimes the Z-value is missing.

How can I project all of these point without manual adjustments to the table? So for the second row we have:

  • 1st measurement: X=94439,5, Y=435795,0 and Z=-0,80370
  • 2th measurement: X=94439,5, Y=435795,0 and Z=-0,80500
  • 3th measurement: X=94439,5, Y=435795,0 and Z=-0,80600
  • 4th measurement: X=94439,5, Y=435795,0 and Z= missing here so no projection
  • and so further on

In the end I want to have a geodatabase.

Many thanks for you reply!

Alan

icon

Best answer by virtualcitymatt 5 August 2019, 17:52

View original

2 replies

virtualcitymatt
Rank
Userlevel 4
Badge +26

Hi @cyrusa,

 

 

This is where lists can be of use. You can use the following as a guide to create x,y,z points where z values are present.

cyrusa
Rank
Badge

Hi @virtualcitymatt,

Thanks a lot for your quick reply and guide to the solution. I tried and it worked for me! Thanks.

I will try to get the field names also as an attribute to the table.

Cheers!

Reply


Community Stats

28,687
Posts
109,422
Replies
36,543
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.