topic Re: Merge fields with the same Property Number in ArcGIS Pro Questions

Merge fields with the same Property Number

EMM03 — Tue, 05 Mar 2024 18:40:04 GMT

Hi everyone,

I have a corporate land use layer which shows what a property is currently being used for (forestry, agriculture, residential, etc.). However, some properties have multiple uses, like this one.

In the attribute table, it shows the same PID but each row has a different land use.

Is there a way I can combine the land uses for each PID into one row? For example, for PID 675264, I would like the "LandUse" column would say "For, Wet". I have approximately 3,400 properties and with the multiple land uses, it's approximately 28,000 rows. So I would just like to reduce this to the 3,400 properties (rows), if possible.

Thanks in advance!

Re: Merge fields with the same Property Number

BobBooth1 — Tue, 05 Mar 2024 21:27:43 GMT

You might look at Dissolve, dissolving on PID, with the statistics fields using the CONCATENATE option.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/dissolve.htm

Re: Merge fields with the same Property Number

Bud — Tue, 05 Mar 2024 22:27:50 GMT

Some people reading this post might be interested in Oracle’s LISTAGG aggregate function. It could be used in a SQL query in a database view or query layer. It’s likely not practical for this use case, but still might be of interest.