Select to view content in your preferred language

Field calculate values from one layer to another

4422
4
Jump to solution
05-27-2021 11:00 PM
DeorajRamsaran4
Occasional Contributor

Hello everyone, I have 4 feature layers one being my main layer manholes or the target layer manholes. The others are 

District, communities, and Basin which are polygon layers. In the manhole layer I have fields for the Basin, District and communities. However their are hundreds of manholes in a community and thousands in the basin and even more in the district. So instead of trying to select and then do a calculate field to add the communities and the same for the the other layers. Does anyone think this task can be automated or at the very least be done with model builder? Since these fields have never been done for my city. We are talking some where around 70,000 manholes and there is several communities already coming up so just want some thoughts on maybe an easier what to do this. Any ideas would be greatly appreciated. I am intermediate with python, java and arcade. Just kind of stuck.

 

Thank you 

 

 

Deoraj Ramsaran
2 Solutions

Accepted Solutions
JayantaPoddar
MVP Alum

Spatial Join would be your best option. 

Join Operation: Join One to One

Match Option: Intersect

Keep only the desired fields from the Join Table (Field Mapping). All the fields in target table will be intact.



Think Location

View solution in original post

DeorajRamsaran4
Occasional Contributor

Jayanta all I have to say is 🤦🏾‍:male_sign: ,I can't believe it was that simple. I did think of doing this, but was told it would not be accurate, but It worked. Thank you so much.

Deoraj Ramsaran

View solution in original post

0 Kudos
4 Replies
JayantaPoddar
MVP Alum

Spatial Join would be your best option. 

Join Operation: Join One to One

Match Option: Intersect

Keep only the desired fields from the Join Table (Field Mapping). All the fields in target table will be intact.



Think Location
DeorajRamsaran4
Occasional Contributor

Jayanta all I have to say is 🤦🏾‍:male_sign: ,I can't believe it was that simple. I did think of doing this, but was told it would not be accurate, but It worked. Thank you so much.

Deoraj Ramsaran
0 Kudos
LydiaCarey
Occasional Contributor

I'm having the same problem but I don't want another layer created i want it to edit the attribute table i already have is there anyway

0 Kudos
AllenDailey1
Frequent Contributor

Starting with ArcGIS Pro version 3.2, there's the new option, "Add Spatial Join," rather than just "spatial join."  "Add Spatial Join" allows you to temporarily join (like how "join by attributes" is temporary).  You can remove the join after you're done with field calculations or whatever.  So it does not produce a new feature class.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-spatial-join.htm#

0 Kudos