topic Re: How to create a unigue IDs to Near_Dist values in Geoprocessing Questions

How to create a unigue IDs to Near_Dist values

ABDALLAMOHAMED — Tue, 24 Jan 2012 16:55:34 GMT

Hello all...I need to derive connectivity between polygons, That is, to show connectivity between polygons of similar near distances.For example polygons with IDs 1, 3,6, 8 have the same near distance, and I can give all of them one unique ID, say 1, and then go to the next polygons with same near distances and do the same, and so on and so forth. Any help..appreciated..
Thanks!
ABDALLA

Re: How to create a unigue IDs to Near_Dist values

DanLee — Tue, 24 Jan 2012 17:06:51 GMT

To classify or group the features based on the NEAR_DIST values. You can try the following approaches:

Approach 1 �?? using Dissolve to group features:
1.        Run Dissolve tool with the NEAR_DIST as the Dissolve Field and the �??Create multipart features�?� box checked. This should make all features with the same NEAR_DIST value into one multipart feature. The resulting FIDs would be the unique IDs you need.
2.        Then run Multipart To Singlepart tool to break the multipart features into singlepart, each carries the dissolved FID from above. I hope that polygons with holes won�??t be an issue (I am not sure if the inner hole will come out a filled polygon; please test).

Approach 2 �?? using Frequency to group features:
1.        Run Add Field tool to add a field, e.g. ConID (for connectivity IDs), for storing the unique IDs you will get later.
2.        Run Frequency tool with the NEAR_DIST as the Frequency Field. The resulting table contains ObjectID, Frequency (count), and NEAR_DIST fields. The ObjectIDs of this table would be the unique IDs you need.
3.        Then run Add Join (or go to the input layer and add a join) to join the input table with the Frequency table via the NEAR_DIST as the join field. Now you should see the ObjectIDs from the frequency table above.
4.        Run Calculate Field tool to calculate the ConID by the frequency ObjectID.

Note: I am not sure if any of the above approaches will end up the unique IDs in the same ascending order as the near distance. Hope that doesn�??t matter to your analysis.

Hope that works for you.

Re: How to create a unigue IDs to Near_Dist values

ABDALLAMOHAMED — Tue, 24 Jan 2012 17:31:12 GMT

Dan..Thanks for your response.. Here is the ouput on sample data using approach-2 (Frequency):
FID Shape Id NEAR_FID NEAR_DIST ConID Rowid FID FREQUENCY NEAR_DIST *
0 Polygon 0 2 1716.566324 1 4 0 1            1716.566324
1 Polygon 0 4 1656.804153 1 3 0 1            1656.804153
2 Polygon 0 4 551.543298 2 1 0 2             551.543298
3 Polygon 0 4 602.992525 1 2 0 1              602.992525
4 Polygon 0 2 551.543298 2 1 0 2               551.543298

I will post the out put from approach-1 in a second.Any comments on the above output??
Thanks!\
ABDALLA

Re: How to create a unigue IDs to Near_Dist values

ABDALLAMOHAMED — Tue, 24 Jan 2012 17:35:01 GMT

Here is the output using the Dissolve tool to group features:
FID Shape * NEAR_DIST ORIG_FID
0 Polygon 551.543298 0
1 Polygon 551.543298 0
2 Polygon 602.992525 1
3 Polygon 1656.804153 2
4 Polygon 1716.566324 3

Re: How to create a unigue IDs to Near_Dist values

DanLee — Tue, 24 Jan 2012 17:42:45 GMT

Dan..Thanks for your response.. Here is the ouput on sample data using approach-2 (Frequency):
FID Shape Id NEAR_FID NEAR_DIST ConID Rowid FID FREQUENCY NEAR_DIST *
0 Polygon 0 2 1716.566324 1 4 0 1            1716.566324
1 Polygon 0 4 1656.804153 1 3 0 1            1656.804153
2 Polygon 0 4 551.543298 2 1 0 2             551.543298
3 Polygon 0 4 602.992525 1 2 0 1              602.992525
4 Polygon 0 2 551.543298 2 1 0 2               551.543298

I will post the out put from approach-1 in a second.Any comments on the above output??
Thanks!\
ABDALLA

It seems the ConID should be calculated by the Rowid (from the Frequency result table), not by the FREQUENCY (which is a count).

Re: How to create a unigue IDs to Near_Dist values

DanLee — Tue, 24 Jan 2012 17:44:04 GMT

Here is the output using the Dissolve tool to group features:
FID Shape * NEAR_DIST ORIG_FID
0 Polygon 551.543298 0
1 Polygon 551.543298 0
2 Polygon 602.992525 1
3 Polygon 1656.804153 2
4 Polygon 1716.566324 3

This looks good.

Isn't this what you wanted?

Re: How to create a unigue IDs to Near_Dist values

ABDALLAMOHAMED — Tue, 24 Jan 2012 18:05:31 GMT

Dan..When I calculated the ConID by the Rowid , I got the same value numbers as Rowid..Is that what you think is right? look at the output below:
FID Shape Id NEAR_FID NEAR_DIST ConID Rowid FID FREQUENCY NEAR_DIST *
0 Polygon 0 2 1716.566324 4 4 0 1 1716.566324
1 Polygon 0 4 1656.804153 3 3 0 1 1656.804153
2 Polygon 0 4 551.543298 1 1 0 2 551.543298
3 Polygon 0 4 602.992525 2 2 0 1 602.992525
4 Polygon 0 2 551.543298 1 1 0 2 551.543298

Do you think that would be a duplicate??
Thanks a lot..
ABDALLA

Re: How to create a unigue IDs to Near_Dist values

DanLee — Tue, 24 Jan 2012 19:33:26 GMT

Dan..When I calculated the ConID by the Rowid , I got the same value numbers as Rowid..Is that what you think is right? look at the output below:
FID Shape Id NEAR_FID NEAR_DIST ConID Rowid FID FREQUENCY NEAR_DIST *
0 Polygon 0 2 1716.566324 4 4 0 1 1716.566324
1 Polygon 0 4 1656.804153 3 3 0 1 1656.804153
2 Polygon 0 4 551.543298 1 1 0 2 551.543298
3 Polygon 0 4 602.992525 2 2 0 1 602.992525
4 Polygon 0 2 551.543298 1 1 0 2 551.543298

Do you think that would be a duplicate??
Thanks a lot..
ABDALLA

I should have included a step 5 at the end of the Frequency approach:
5. Run the Remove Join tool (or from the layer - Joins ... - Remove join) to remove the added join. All the joined fields will disappear; now you only have the ConID field, no more Rowid. The purpose of using Join is to temporarily get the Rowid field shown in the table so that you can transfer its values to ConID via Calculate Field.

Re: How to create a unigue IDs to Near_Dist values

ABDALLAMOHAMED — Tue, 24 Jan 2012 19:48:21 GMT

Dan..Both of the above approaches work great. Now I will appy them to my entire data and see the result of that..Hopefully the result will be consistent with the sample data..Because I have large data, the process is going to take at least two days to finish. I will let you know by then..

Thanks a lot.. Appreciated!
ABDALLA

Re: How to create a unigue IDs to Near_Dist values

DanLee — Tue, 24 Jan 2012 19:52:16 GMT

You are welcome. I am happy to hear that. Good luck with your project! 🙂

Re: How to create a unigue IDs to Near_Dist values

DanLee — Tue, 24 Jan 2012 21:24:48 GMT

Just want to add a note here:

Grouping features by numerical field, such as NEAR_DIST used in this scenario, is sensitive to the precision of the decimal numbers. You might want to round up the values to a number of decimal digits that is significant enough for the analysis to avoid getting too many unique groups or IDs.

Re: How to create a unigue IDs to Near_Dist values

DanLee — Thu, 26 Jan 2012 15:00:14 GMT

And another note:

If you have ArcGIS 10, you can use the ModelBuilder Iterator tool, Iterate Feature Selection or Iterate Row Selection, to loop through selections defined by the Group By Field, in the case above this would be NEAR_DIST. Then for each selection use Calculate Field with the expression: %n%+1 to assign the unique iteration value starting with 1 in the added field. It is pretty simple.

Re: How to create a unigue IDs to Near_Dist values

ABDALLAMOHAMED — Mon, 30 Jan 2012 15:16:46 GMT

Dan.. I have ArcGIS 10, but I couldn't find ModelBuilder Iterator tool. I would like to give it a try. Any hint on where to find such tool..Thanks a lot..
ABDALLA

Re: How to create a unigue IDs to Near_Dist values

DanLee — Mon, 30 Jan 2012 15:38:07 GMT

Sure. They are ModelBuilder-only tools, not in the toolboxes. You should be able to search the Help system by "iterators". Here I quote the description from the Help topic "Accessing iterators in ModelBuilder":

"There are two ways to access iterators in ModelBuilder: through the Insert menu or from the shortcut menu (right-click in open space in the model).

- Click Insert > Iterators and choose an iterator to add to the model.
- Right-click in open space in the model, click Iterators, then choose the iterator to add to the model."

Hope you find them helpful.

Re: How to create a unigue IDs to Near_Dist values

ABDALLAMOHAMED — Mon, 30 Jan 2012 16:01:03 GMT

Dan.. I found the Iterators..
Thanks a lot..
ABDALLA