topic Re: GisPro_calculate fields sqr in ArcGIS Pro Questions

GisPro_calculate fields sqr

YoonseoYang — Thu, 24 Sep 2020 01:06:53 GMT

Hi, everyone.

I'm using ArcGisPro, try to using 'calculate fields' tool.

I import following formula, "*.cal" file.

!P110003! / ((Sqr ( ( !x_coord! - !site1x!)^2 +( !y_coord! - !site1y!)^2 ))/5280)

Following error appears.

ERROR 000539: Traceback (most recent call last):
File "<expression>", line 1, in <module>
NameError: name 'Sqr' is not defined

*.cal file works well on ArcGis without an error.

How could I solve this problem?

Please help~! Thanks in advance.

HamedFarzin — Thu, 24 Sep 2020 11:37:20 GMT

Change "Sqr" to "math.sqrt" like below and try one more time.

!P110003! / ((math.sqrt ( ( !x_coord! - !site1x!)^2 +( !y_coord! - !site1y!)^2 ))/5280)

Cheers,

Hamed

YoonseoYang — Fri, 25 Sep 2020 01:15:16 GMT

Thanks for your comment.

When I change "sqr" to "math.sqrt" as following.

!P110003! / ((math.sqrt((!x_coord!-!site1x!)^2+(!y_coord!-!site1y!)^2)) / 5280)

Other error appears as following.

Please help~! Thanks in advance!

DanPatterson — Fri, 25 Sep 2020 02:06:37 GMT

^ should be **

!P110003! / ((math.sqrt((!x_coord!-!site1x!)**2 + (!y_coord!-!site1y!)**2)) / 5280)‍

YoonseoYang — Fri, 25 Sep 2020 02:08:45 GMT

It worked!!! Thank you Hamed Farzin and Dan Patterson!