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

How to communicate two lists

PierreWeisse

Hello,

I'm having trouble with lists.

I work on two different workspaces

The first is a file geodatabase (a)

The second is an SDE geodatabase (b)

The aim is to remove the contents of feature classes contained in a list (b)

So far so good

Then copy the new records (a) in the entity classes of (b)

To delete the records I use arcpy.DeleteFeatures_management () function

To complete the feature classes with the new content I use the function

arcpy.CopyFeatures_management ()

Thank you for your help

タグ付けされた投稿をもっと見る

Accepted answers

DanPatterson_Retired

so...how is it going? Have you done this manually? Are you trying to produce a script from it? Examine the Results Window to see the script syntax if so. It will give you a starting point as to how to put this together. Alternately, construct a model from modelbuilder which can be used itself and/or converted to a script.

All comments

PierreWeisse

Hello Joshua and Dan,

These data are not versioned. These are data from one of our partners. They take care to versioning. Our organization recovers data via their FTP.

The data that we update, have a comparable table structure of an update to another. There may be new entities or additional information in the fields.

I use the functions:

arcpy.DeleteFeatures_management ()

To clear the table for these records

arcpy.CopyFeatures_management ()

To fill the table with records last days

Because the data can be used by other users when I wish performed the update. These same users are warned in advance that an update will take place. They are not surprised. A document is even sent them for their explained what those updates.

Thank you both

bixb0012

Are you working with versioned data? The code snippet you provide will delete all of the features in the feature classes, so it appears you are completely purging the table and repopulating it from scratch. If you are working with versioned data, this will make your add & delete tables grow substantially. Do you really need to replace all the records or are you trying to synchronize subsets of records between the two data sources? Deleting all the records in an SDE table when users are consuming data from the table seems like it would lead to some strange experiences for users.

PierreWeisse

I can not use the tool "Feature Class To Feature Class (Conversion)"

That's why I use the tool arcpy.DeleteFeatures_management (). I work in an organization with many users who use data during updates.

This tool allows the updates even when users are connected to the base.

Process:

arcpy.DeleteFeatures_management ()

To clear the table for these records

arcpy.CopyFeatures_management ()

To fill the table with records last days

Thank you

DanPatterson_Retired

same procedure using Feature Class to Feature Class syntax as shown in the help topic.

I would, however, suggest that you copy the features from the source location first, prior to deleting them. If the files are outside of a geodatabase, you can use pure python operating functions...but that is a different story.

PierreWeisse

Thank you very much for the quick reply.

Here is my script:

import arcpy, os

from arcpy import env

env.workspace ="M:\UTILISATEURS\Pierre\connexion SDE\srv-arcsde.recif.nc@sde_ore_adm.sde\SDE_ORE_ADM.TEST"

lst_destination = arcpy.ListFeatureClasses()

for fc in lst_destination:

arcpy.DeleteFeatures_management(fc)

print fc + " is delete"

So far, so good. This is the next step that I have a problem.

I can not seem to communicate this list with another list, to come to copy the new entities in the feature classes that have been deleted.

DanPatterson_Retired

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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