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.
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
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 ?
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?
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
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.