topic Re: Getting values from two SHP in ArcMap Questions

Getting values from two SHP

StanislavaV — Sat, 28 Aug 2021 18:37:13 GMT

Hi guys,

first SHP "ALL" has attributes like this: Each ID has CODE, ALP and NUM

ID CODE ALP NUM

123 0303 AB 23

456 0303 BF 34

789 1234 AC 12

034 1234 FG 1 .............

Second one "INTERS" was created from intersection of polygons from first one (like in the picture)

ID1 ID2 SUM

123 456 45,65

789 034 20

My intention is to make SHP like this:

ID CODE ALP NUM SUM

123 0303 AB 23 45,65

456 0303 BF 34 45,65

789 1234 AC 12 20.......

Basically two polygons are intersecting and creating new shape with attributes which I wanna get together, bcs I dont have access to originally created intersected shape.

So I need to create shape where I get together ID with belonging CODE ALP and NUM but with identifying which SUM belongs to it from the second shape.

I am thinking about Union, but is there any better option?

Re: Getting values from two SHP

DavidPike — Sat, 28 Aug 2021 19:56:50 GMT

Just a table join, first on ID to ID1, then on ID to ID2? Then just clean it up at the end by creating a new field and field calculating the concatenation e.g. str(!ID1!) + str(!ID2)

Re: Getting values from two SHP

StanislavaV — Sun, 29 Aug 2021 09:00:00 GMT

but what if there are attributes like this:

for example ID 123 has more CODEs with ALP and NUM.

ID CODE ALP NUM

123 0303 AB 23

456 0303 BF 34

789 1234 AC 12

123 1203 GF 11

034 1203 AD 12

then ID 123 has more polygons in shp INTERS.

ID1 ID2 SUM

123 456 45,65

789 034 20

123 034 5

So final SHP:

ID CODE ALP NUM SUM

123 0303 AB 23 45,65

456 0303 BF 34 45,65

123 1203 GF 11 5

034 1203 AD 12 5

789 1234 AC 12 20