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,803702th measurement: X=94439,5, Y=435795,0 and Z=-0,805003th measurement: X=94439,5, Y=435795,0 and Z=-0,806004th measurement: X=94439,5, Y=435795,0 and Z= missing here so no projectionand so further onIn the end I want to have a geodatabase.Many thanks for you reply!Alan

Solved

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

5 years ago
August 5, 2019
2 replies
15 views

cyrusa
Contributor
4 replies

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

Best answer by virtualcitymatt

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.

View original

Did this help you find an answer to your question?

+35

virtualcitymatt
Celebrity
1844 replies
Best Answer
5 years ago
August 5, 2019

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
Author
Contributor
4 replies
5 years ago
August 5, 2019

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

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

Cookie settings

We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.

Basic
Functional

Normal
Functional + analytics

Complete
Functional + analytics + social media + embedded videos + marketing

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