topic Re: Import a shapefile to an SDE using ArcGIS Desktop in Python Questions

Import a shapefile to an SDE using ArcGIS Desktop

PedroGIS92 — Sun, 19 Dec 2021 10:50:42 GMT

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.

Re: Import a shapefile to an SDE using ArcGIS Desktop

DanPatterson — Sun, 19 Dec 2021 10:55:46 GMT

Does it have to be a model?

Have you look at the related posts to the right of your question?

For example

Solved: Copy Shapefiles to Enterprise Geodatabase Feature ... - Esri Community

Re: Import a shapefile to an SDE using ArcGIS Desktop

PedroGIS92 — Sun, 19 Dec 2021 11:16:28 GMT

Thank you Dan
Not necessarily a model !

In the python script made by LanceCole in Solved: Copy Shapefiles to Enterprise Geodatabase Feature ... - Esri Community, how can it checks if my shapefile's fileds (name and type) match the targeted ones located in the sde geodatabase ?

Re: Import a shapefile to an SDE using ArcGIS Desktop

DanPatterson — Sun, 19 Dec 2021 12:03:51 GMT

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.

Re: Import a shapefile to an SDE using ArcGIS Desktop

MichaelVolz — Sun, 19 Dec 2021 15:55:38 GMT

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?

Re: Import a shapefile to an SDE using ArcGIS Desktop

PedroGIS92 — Sun, 19 Dec 2021 17:01:10 GMT

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