topic Re: Script for dissolve/ Roll up data with ArcGIS PRO in Python Questions

Script for dissolve/ Roll up data with ArcGIS PRO

Akchademir — Sun, 31 Jan 2021 09:55:39 GMT

I need to make a scripts tools that will consolidate attributes from many rows into to one across a number of columns.

And the opposite of dissolve date (like drilling into data attributes) .

I have the Following data attribute:

Thanks for any helps!

Re: Script for dissolve/ Roll up data with ArcGIS PRO

DanPatterson — Sun, 31 Jan 2021 10:32:42 GMT

What do you want it to look like?

You obviously don't want a concatenation of the values.

Much of the data in the columns is redundant

Even if you summarize by state by county you can only display 1 variable.

Do you want a 3D table effectively?

What is your end goal since that will affect the reversal process at a minimum

Re: Script for dissolve/ Roll up data with ArcGIS PRO

Akchademir — Sun, 31 Jan 2021 10:47:44 GMT

Yes, for Example i have united states and sub-states:

i want to roll up into states like this :

Re: Script for dissolve/ Roll up data with ArcGIS PRO

DanPatterson — Sun, 31 Jan 2021 11:14:17 GMT

That is a dissolve

How Dissolve (Data Management) works—ArcGIS Pro | Documentation

You aggregate space based on an attribute or a combination of attributes.

Code examples are at the bottom of the link.

Re: Script for dissolve/ Roll up data with ArcGIS PRO

Akchademir — Sun, 31 Jan 2021 11:42:42 GMT

Yes thanks i know dissolve tool, and for the attributes table? did the table change?

Re: Script for dissolve/ Roll up data with ArcGIS PRO

DanPatterson — Sun, 31 Jan 2021 14:37:41 GMT

Open the table. What parameters did you specify for dealing with the tables during the dissolve?

They are limited.

If you expect to keep the whole row's contents for each polygon that was dissolved, then you will be disappointed, because you would have to "relate" the undissolved table back to the dissolved geometry's table

Re: Script for dissolve/ Roll up data with ArcGIS PRO

Akchademir — Sun, 31 Jan 2021 14:51:30 GMT

Is there no other option ?

Re: Script for dissolve/ Roll up data with ArcGIS PRO

DanPatterson — Sun, 31 Jan 2021 16:42:44 GMT

You haven't said what you want to keep and what you want to do with it.

Also, sometimes having multiple maps with different expressions of the underlying data is the best option.

There is no "tool does everything"

Re: Script for dissolve/ Roll up data with ArcGIS PRO

Akchademir — Mon, 01 Feb 2021 07:49:44 GMT

For example, the three hierarchy levels are country, state and district. These fields are geographic fields and I am able to plot them on three separate maps.

The requirement is to create a top-down analysis such that when the user clicks on the country, the top-down analysis should take the user to the states and show all the states. Then when the user clicks on a state, the drilldown should bring the user to see the districts and show all the sub-districts.

Re: Script for dissolve/ Roll up data with ArcGIS PRO

Anonymous User — Mon, 01 Feb 2021 13:49:46 GMT

Will they be accessing this layer in arcmap, or through a webmap? I think you are limited to what Dan described with relating aggregated data back to the counties if it is arcmap. I don't think there is the top-down functionality (without creating your own application) in arcmap to be country, state, county based on mouse clicks. However, If it is going to be used in a webmap, then you can use Arcade to perform the aggregation of field values for what the user clicks on.

Re: Script for dissolve/ Roll up data with ArcGIS PRO

Akchademir — Mon, 01 Feb 2021 13:59:22 GMT

Yes i must use Arcmap, thanks for your response.