topic Re: Automated Batch updates to ArcSDE geodatabase in Data Management Questions

Automated Batch updates to ArcSDE geodatabase

Anonymous User — Thu, 13 May 2010 16:09:31 GMT

Original User: keeblerh

We need to automate and batch gis data updates into an arcsde geodatabae. The incoming data is in shapefiles and requires some ETL processing prior to loading them into the geodatabase. One would think that a geoprocessing model could be created and executed from a python script or something but I can find no evidence of this in any of the papers or discussions I 've found. It appears that most folks just write code to do it. Most of the examples I have found are for older versions of ArcGIS and I was wondering if someone could point me to the latest and greatest best practice for this. Thanks.

Re: Automated Batch updates to ArcSDE geodatabase

BrandonCales — Thu, 14 Oct 2010 19:44:11 GMT

Any luck - I have a similar issue - http://forums.arcgis.com/threads/14889-Unique-Geodatabase-Design-for-Parcels

Re: Automated Batch updates to ArcSDE geodatabase

Anonymous User — Thu, 14 Oct 2010 20:14:06 GMT

Original User: ldonahue

An option - aside from writing code:

use model builder(python) to prepare the shapefile

use shp2sde to load into the GDB (sde command line)

http://help.arcgis.com/en/geodatabase/10.0/admin_cmds/Support_files/datamgmt/shp2sde.htm

Re: Automated Batch updates to ArcSDE geodatabase

RussellBrennan — Fri, 15 Oct 2010 14:06:53 GMT

Holly,

What exactly are you trying to do with the shapefiles before loading them into the Geodatabase? There are a number of methods available through Python for loading data into the geodatabase but I would like to know more about your workflow before offering suggestions.

Also, what version of ArcGIS Desktop are you using?
What version of ArcSDE are you using?
What DBMS is ArcSDE running on?

Re: Automated Batch updates to ArcSDE geodatabase

Anonymous User — Fri, 29 Oct 2010 13:53:12 GMT

Original User: keeblerh

Russell, thanks for getting back.

We have basically written code to do all of this using C# and arcobjects. The shapefiles received need to have fields parsed (reformatted) and mapped to different fields in the SDE geodatabase. Our update process is a replace - delete what's there and reload. We are using the latest and greatest version 10 of everything. The DBMS is oracle 11g.
Thanks. We would still be interested in any suggestions.

Re: Automated Batch updates to ArcSDE geodatabase

RussellBrennan — Fri, 29 Oct 2010 14:22:49 GMT

Holly,

ArcObjects will give you a little bit more efficiency in the ability to copy data and map to new fields at the same time.

Without going into too much detail a possible geoprocessing workflow would be to use the feature class to feature class tool to set up your field mapping and copy to a new dataset, you could then use delete rows/delete features to 'clean up' the existing dataset, finally you could use copy features/copy rows to copy the data created from the feature class to feature class tool into the geodatabase.

Hope this helps.