See all the values in the statistics field when dissolved

3132
13
Jump to solution
06-16-2015 04:24 AM
SalmanAhmed
New Contributor III

Hi,

I am doing a simple dissolve on my data. I want to use a text field as statistics field and get all the values from that field and not just FIRST or LAST. Any possible way to do this?

Thanks.

0 Kudos
1 Solution

Accepted Solutions
WesMiller
Regular Contributor III

Salman do you have an Advanced license could you run feature to point on your small polygons and select the optional inside radio button. You should have points inside the polygons with the associated data you could then rerun the spatial join using the match option intersects and don't forget to set up your join field.

View solution in original post

0 Kudos
13 Replies
WesMiller
Regular Contributor III

Use join and set your separator I usually use a comma ","

0 Kudos
SalmanAhmed
New Contributor III

I'm sorry I didn't understand. Use join table to join the two ? How do I use this separator?

0 Kudos
WesMiller
Regular Contributor III

I'm sorry join is a property of the Spatial Join tool

  1. Run Dissolve
  2. Then run Spatial Join with your dissolved set(target) an your original data(join features
  3. set the Output field properties Merge rule to join with a comma deliminter
SalmanAhmed
New Contributor III

Thank you. That was very helpful. I did it but one little problem with one row. You can see in the picture. There are clearly two polygons (Monschau and Simmerath) joined inside the selected polygon. But the table just lists Monschau alone. I don't understand why. In dissolve I selected CONTAINS as the join type.Untitled.png

0 Kudos
WesMiller
Regular Contributor III

Salman could you change your spatial Match Option to HAVE_THEIR_CENTER_IN an get the desired result?

0 Kudos
SalmanAhmed
New Contributor III

No doing this now gives me a very different and incorrect result.Untitled2.png

0 Kudos
WesMiller
Regular Contributor III

Did rerun step 2 with the original data just changing the match option? That should have produced near the same results.

0 Kudos
SalmanAhmed
New Contributor III

Yes I did exactly what I did before except changing the match option to have their center in. I think the above results are correct for that match option. Only the little polygons inside which the larger polygons' centers lie are listed.

0 Kudos
WesMiller
Regular Contributor III

Salman are you willing to post another screen shot with the little polygons on the bottom with a grey outline and the big polygons on top with no fill and a thick red outline?

0 Kudos