Inserting and modifying data in the ArcGIS SDE spatial table directly via SQL

+oracle 11g Environment test based on ArcGIS Server 10.1

ArcGIS SDE

?

12	INSERTINTOCAMERA_INFO(OBJECTID,ID,SHAPE)                         VALUES(sde.gdb_util.next_rowid(‘sde‘,‘CAMERA_INFO‘),M_ID,st_geometry(to_number(M_LONGITUDE),to_number(M_LATITUDE),null,null,300003));

Note:

1. Generate PRIMARY Key ID

?

1	sde.gdb_util.next_rowid(‘sde‘,‘CAMERA_INFO‘)

2. Build St_geometry Type

?

1	st_geometry(to_number(M_LONGITUDE),to_number(M_LATITUDE),null,null,300003)

300003 is the Srid value of the spatial library and needs to be modified according to the actual situation, you can find a table with data in the spatial library, and view the Shape.srid field value as the desired Srid value.

Inserting and modifying data in the ArcGIS SDE spatial table directly via SQL