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.