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; } } }

Updating feature class from view on daily using python

vijaybadugu

We have created a view to get the data from multiple tables. I tried publishing same view with sync enabled feature service, However, it did not work due to limitation on view. So, I created same feature class with same fields, published with sync (archiving) enabled. I need to update this feature class on daily basis to see the latest data in field maps.

I have already python script (job) to update this feature class on daily. which deletes entire data from the feature class and copies from view.

Is there a way to do this process ESRI best practices?

Encontre mais publicações marcadas com

Enterprise geodatabase

Archiving

Accepted answers

RobertKrisher

Instead of deleting all the features every day, push inserts/updates/deletes to the layer. If you're only ever adding/updating values you can use the Append tool to do upserts by specifying a match key. If you need to handle deletes you can run the append then delete any rows that are no longer present in the source data.

Remember that when you edit a table that has archiving enabled that every edit is tracked in your database. This means that if you delete the contents and reinsert them every day, your database is recording all those edits. If your table is large, you should consider periodically trimming the table.

All comments

RobertKrisher

vijaybadugu

Thanks Robert.

vijaybadugu

How to preserve Globalids and objectids during this execution ?

RobertKrisher

If you're just updating rows in the table every night global ids and object ids will be preserved because you're not deleting features every night.

vijaybadugu

I checked append tool. it did not update existing report based on matching field and always inserts new record. I am using arcgis pro 3.3

RobertKrisher

Double-check that the data type and formats of the input/target match fields are identical. As an example, if the field is a long in one database but a double in another this could cause an issue (this can happen with object id fields if you create them using views).

vijaybadugu

I have assigned GlobalID for input dataset and target dataset as a matching field in Update option,

The results are duplicated .

RobertKrisher

Field names for the screenshot would be appreciated, so I'm going to have to make some assumptions. I'm going to call your first column a GUID, your second column and Object ID, and the third column a Global ID.

Global IDs are a special, unique identifier for a table, so your input dataset (the one with changes you want to push) needs to reference the Global ID of each row in the target dataset (the one being updated). So your input dataset should have a foreign key column the values from the Global ID (third column) of the target table. This will allow the append tool to know how to link the values from the two tables.

In your screenshot it looks like both tables have their own unique Global IDs, which means they'll never be able to match, which is why your rows are being appended and not updated..

vijaybadugu

In this below logs, 737 records were inserted and 737 were updated. How it is possible two DML operations at the same time using APPEND

RobertKrisher

The tool updated the rows it found matches for, then inserted the rows it couldn't find matches for. Doing both an insert and an update is what the append tool does when you select the Matching fields options. This is why this is often referred to as doing an "Upsert" because the tool will first "Update" rows it matches, then "Insert" the rows it doesn't.

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.