nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it automatic

JohnPavek

Put it here in case it got clipped...I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it automatically changes the calced, combined field with the new info. I have access to ArcGIS 10.5 thru 10.7 products...the DB is currently 10.2.2 but we will upgrade that soon. Any ideas? I know this may not be the perfect publish location but I don't know where else to post it

Encontre mais publicações marcadas com

Accepted answers

All comments

JohnPavek

I'm not seeing much action on this. Do I have it in the right area? If not can somebody recommend where it should go?

JoeBorgione

First off: how or when is this calculation being performed? You seem to imply your third field needs to be dynamic as the other fields apparently are. This might be a case for Introduction to attribute rules—Geodatabases | Documentation but without a little more insight, that may or may not be the route to take.

Asrujit_SenGupta

Multiple things come to mind:

Is using a View a possibility, as that will be dynamic?
What about a Trigger, whenever any of the two fields are updated...the third field should be updated automatically.
How many records are involved and frequency of change? Is it possible to run the calculate everyday (whatever suits your need) and then use the updated data? Probably can be done from the Database end too...

Have you already tried something and observed any issues?

On a side note: The question in the thread, need not be the entire question in itself. It should a small synopsis probably to give an idea. A lot of people ignore questions\threads, which are not formatted properly.

JohnPavek

Well it is not a view and we are dealing with daily change on 81,354 features. Because the symbology is built using Z whatever change is done in X & Y have to be reflected in Z. I haven't used triggers in a long time maybe that is what we need. I can explore that.

Ok about your side note...but how am I going to really give info enough to make sure people have what they need to answer? I guess they can just ask questions. I just wanted to minimize the back and forth as we all are busy.

JohnPavek

Thanks for the replies to Joe and Asrujit!

JoeBorgione

As Asrujit SenGupta‌ suggests: try to keep your thread titles to a minimum. Yes, we are all busy, but for me, I'd rather get a teaser of a title and open the thread than get bored reading a lengthy one and move on before finishing it...

JohnPavek

I just put another thread out for a coding issue. I will try from here on to be better about this 🙂

JoeBorgione

my suggestion for that title would be:

Python: Need help converting Tifs into a Mosaic or

Need help converting Tifs into a Mosaic with Python

and then fill us in with the details in the body of the thread.

Also, personally I never open a .zip file from anyone I don't know, no offense, just business. If you want to post code, use the syntax highlighter described here: https://community.esri.com/message/903148-re-arcmap-105-python-script-error?commentID=903148#comment-903148

JohnPavek

After thinking about it...I haven't used triggers in a while. But I have a couple questions:

- I assume you are referring to a database trigger or are you thinking something within ArcCatalog or ArcMap?

- Could you provide an example of a trigger?

Thanks for everything!

JohnPavek

Hi all.

I got some good info from Joe and Asrujit. But unfortunately it isn't enough for me to get going. I've tried a bunch of google searches but can't find anything definitive. Does anybody know of a ESRI doc or something that shows how to do action with triggers esp to do a calc when something changes in a field to calc another field? I keep getting ESRI stuff relative to Tracking Analyst which we don't have.

JoeBorgione

Use the geonet search function for 'sql trigger'; you'll find a ton of results. However, I'm not sure that ESRI supports triggers (don't quote me) so another alternative might be attribute rules....

JohnPavek

I'm dealing in anywhere from 10.5 to 10.7.1. I think attribute rules are an ArcGIS Pro thing. I'm starting to think this has to be an ESRI Tech Support call in. I may be trying to do something not possible with the version I have.

Thank Joe for the info you can give

JoeBorgione

Sorry- I'm only thinking Pro these days; I don't even have ArcMap/ArcCatalog installed. At any rate, you might also take a look at Attribute Assistant | ArcGIS Solutions ; I used it for a project a couple of years ago; it's more or less the predecessor to attribute rules.

MikeVolz

Do you have the ability to work in Pro?

If so, can you have the data updated at night via python/modelbuilder for the next business day and use Arcade for the concatenated field symbology (Not sure Arcade can be tied to symbology but Arcade is pretty powerful so it could be an area to research)?

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.