Import a shapefile to an SDE using ArcGIS Desktop

Question

Hi community,

We are thousand of people using ArcGIS Desktop 10.6.1 and working in a SDE of a transportation system.

We basically create/delete/update (at the same time) the features of every layer of the table of contents (for example the bus stops). To create a point/bus-stop in the SDE, I do it manually and I have to retrieve the values of every field from my CSV/Excel file ! At the end, my bus-stop is created and a unique OBJECTID is generated and only then I can save the changes so they can be visible to the rest of users.

I need a way to import a shapefile (that content >100 points/rows), using the ModeldBuilder, to the SDE knowing that the bus-stops database has a spatial index and is represented by 10 fields/columns with different types.

Can you please show me how to do this ? This will literally saves me a hundred of hours !

Thanks, P92.

PedroGIS92 · Answer

Hi Michael,
It's the first option : I need to load data once into SDE and then me and the rest of the users can edit these data in that environnment

mvolz47 · Answer

Is your intent to load data once into SDE and then edit the data in that environment or will this be a frequent process at some interval as data editing is only occurring in the shapefiles?

danretired · Answer

Fields are objects and they have properties

Field—ArcGIS Pro | Documentation

Names and/or types can be compared directly

you can use ListFields if you need to get a field list first.