topic Re: Distinct Dynamic text from attribute? in ArcGIS Pro Questions

Distinct Dynamic text from attribute?

Anonymous User — Fri, 27 Nov 2020 14:10:04 GMT

Is there a way to only get the unique values from a field in a feature class?

I have multiple AVL records and would like to use dynamic text to populate which vehicles are being displayed on the map in the layout view.

I've tried using a distinct SQL query within dynamic text and it keeps telling me my query is invalid. I've also explored Table Frames a bit but there doesn't seem to be a way to filter it down.

Thanks

Re: Distinct Dynamic text from attribute?

Robert_LeClair — Mon, 30 Nov 2020 15:20:32 GMT

Joel - are you attempting to get unique labels for the vehicles from an attribute table in the Map/Layout View and not showing duplicate labels? You mention filter down - would Label Classes work for this? If you would be able to provide more details, I'd appreciate it.

Re: Distinct Dynamic text from attribute?

Anonymous User — Mon, 30 Nov 2020 16:08:57 GMT

In the below image I am looking for an automated way to update the red highlighted section. I've had to redact a few sections of the image but the red outlined area is the only thing that can't be updated automatically.

Re: Distinct Dynamic text from attribute?

Robert_LeClair — Mon, 30 Nov 2020 18:49:28 GMT

Ah okay now I understand. Yes, you can do this. In the Layout, select Dynamic Text, then Table Attribute->Value. When the "Insert Table Attribute" pane opens, change the Query dropdown to "Map Series Rows" in the Source component, select your Field in the Appearance component and click OK. When you change the Map Series for each vehicle the dynamic text attribute updates with the name of each vehicle. See attached image.

Re: Distinct Dynamic text from attribute?

Anonymous User — Fri, 08 Jan 2021 15:53:33 GMT

Thank you for your reply robert, but I think it's still not quite what I'm looking for. I would need to do a map series based on vehicles in order for that to work, correct?

I am ok with multiple vehicles on the map at any one time but I only want to know which vehicles are there during the time frame I specified. I dont think what you suggest would work like that, would it?

If I could create a map series based on time intervals automatically that would also be useful. e.g. a map for every 1 hour increment over 7 days.