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

Is there a good way to update an SDE with FGDB data?

PayneRingling

I have tried making an XML and using that as the upload but it just wants to give me additional copies of the same data. I have heard that I can do a truncate and append but is that only for table? Is it available for use on multiple feature classes?

I used to have a nice SDE connection to the County where it was easy to move the data over from their SQL to our but the connection was dropped a couple weeks ago and now I only have an FTP with a FGDB containing the majority of their data that I need to clip out for our City's needs.

Does anyone have any ideas?

Thanks-

Diane

City of Sarasota

Najděte více příspěvků označených jako

Accepted answers

All comments

JakeSkinner

Hi Diane,

Truncate/Append will work on feature classes. This method will work. One thing to note, if the feature class is registered as versioned and the truncate/append is performed often, be sure you are compressing your database on regular basis.

JoeBorgione

I'm a huge fan of the simple data loader.

AsrujitSengupta

How much data are you updating?
Is this a daily, weekly, monthly process?

The 'Truncate Table' tool will not work, if the Feature Class is Registered as Versioned. You will then have to use 'Delete Features' or 'Delete Rows' tool.

George_Thompson

Adding the Geodatabase group.

RandyKreuziger

I'm assuming the only data coming from the county is data they manage in the first place so that your copies in SDE aren't versioned is that correct?

I've sent up 3 scheduled python jobs to handle cases like this.

Script 1 download and unzips the file geodatabase.

Script 2 copies up to a staging SDE database all the feature classes that need to be loaded. You could do your clipping as part of this script.

Script 3 compares the schemas of the staged feature classes to the existing feature classes in our corporate SDE database. If the schemas match I do the truncate append, if they don't match I send out an email alert and move on to the next feature class.

You could easily combine scripts 1 and 2 to keep things simple.

PayneRingling

Yes, you are correct the data is all Countywide and it is not version but rather a 'copy' of the SDE that has been packaged up and place in their FTP location as a zip.

Would it be possible to get a copy of your scripts. They sound like exactly what I would like to do but I am a newbie at scripting but could modify one.

PayneRingling

Jake- There are a slew of feature classes though will I need to add them all one at a time?

JakeSkinner

You can run the truncate/append tool in batch mode by right-click on the tool in the Catalog/Toolbox window > Batch. Though, it will most likely be more beneficial to create a script/model to automate this process if the same feature classes are always updated.

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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