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

Write a point into a SDE database

ChristofLink

Hello everybody,

I'm looking for a solution with which it is possible to add a point (x,y) into a SDE database.

I want to write a skript or add-in for it, so i prefer python (arcpy).

At first a need a way to connect to the database. Any ideas ?

I allready tried the insert cursor but this only works for a geodatabase not a SDE database.

I'm thankful for any help. Thanks.

Encontre mais publicações marcadas com

Accepted answers

All comments

ChristofLink

Ok I try a little bit.

I have a shape file which contains points and I have to copie all of these into a given table of the sde database.

At this point in time I'm able to get alle points out of the shape file and now I try to get these in the database.

NeilAyres

Once you are in and have the correct permissions you can do anything. So be careful!

I normally do this in the Python ILDE, try -

arcpy.ListTables() or arcpy.ListFeatureClasses() for example.

There is plenty of code snippets in the help or on this site to get going with.

What are you trying to do?

ChristofLink

Thanks for your fast answer.

I set up the databaseconnection using ArcCatalog and found the connection file.

So this works thanks.

But how can I access to different tables to add or read some data?

NeilAyres

Set up the connection file using the usual tools in ArcCatalog.

Then set a pointer to this in your python script.

like :

ConnectFile = "Path & name of my connection file.sde"

arcpy.env.workspace = ConnectFile

Then you are in....

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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