AnsweredAssumed Answered

Python alternative for sdelayer command

Question asked by anders.k.mark on Nov 10, 2016
Latest reply on Nov 10, 2016 by kreuzrsk

Hi!

 

We are using the ArcSDE command tool set at the moment but in time when we upgrade to ArcGIS 10.4 the command toolset will not be available and we need to figure out a way to solve certain tasks in Python instead. For example, today we do like this:

 

1. Create a table with column SHAPE using the SDE_ST_GEOMETRY type. 

  (In user schema uno)

 

CREATE TABLE TEST_SPACE
(
OID INTEGER NOT NULL ,
OwnerDID INTEGER NOT NULL ,
Label VARCHAR2(100) NULL ,
lastUpdate DATE NOT NULL ,
GeometryType VARCHAR2(20) DEFAULT 'SURFACE',
SHAPE SDE.ST_GEOMETRY NULL
);

 

2. Using SDE command tool sdelayer to "register" the table/column in SDE:

 

sdelayer -o add -l uno.TEST_SPACE,shape -e nac+ -R 1 -k DEFAULTS -E 220000,6000000,1000000,7700000 -t ST_GEOMETRY -C OID,USER -s server1 -i sde:oracle11g:VNUTVTD_SERVER1 -u uno -p uno

 

 

So far so good. But how should this be done with Python when sdelayer is gone? I have searched the internet for examples but can't find any solutions that solves the same problem.

 

I have tried to use arcpy.CreateFeatureclass_management but that creates the table, in my test from a template table which hade exactly the same appearence as TEST_SPACE. But then I ran into other problems like that the column OID was renamed to OBJECTID with data type "Object ID".

 

I would like to have a solution that replaces just the "sdelayer" command. 

 

Any suggestions? Tips of any kind would be of great value. 

 

Thanks!

Outcomes