Oracle 18; 10.7.1 EGDB; SDE.ST_GEOMETRY
I can create empty features in a polygon FC using ST_GEOMETRY SQL functions:
--The first feature was created using editing tools in ArcGIS Pro. The feature has shape and geometry. It's a normal polygon; visible in the map.
--The second feature:
insert into infrastr.a_test_fc_2 (objectid, shape) values (
sde.gdb_util.next_rowid('INFRASTR', 'A_TEST_FC_2'),
sde.st_polyfromtext('POLYGON EMPTY',26917));
commit;
--The third feature:
insert into infrastr.a_test_fc_2 (objectid, shape) values (
sde.gdb_util.next_rowid('INFRASTR', 'A_TEST_FC_2'),
sde.st_geomfromtext('POLYGON EMPTY',26917));
commit;
--select objectid,shape from infrastr.a_test_fc_2 order by objectid;
The shapes that I created using SQL INSERTS are being shown differently in SQL Developer than a feature that was created in ArcGIS Pro using editing tools:
- ArcGIS Pro editing tools: [SDE.ST_GEOMETRY]
- sde.st_polyfromtext(): [SDE.ST_POLYFROMTEXT]
- sde.st_geomfromtext(): [SDE.ST_GEOMFROMTEXT]
Will storing shapes as [SDE.ST_POLYFROMTEXT] or [SDE.ST_GEOMFROMTEXT] cause any issues? Or should I somehow convert them to [SDE.ST_GEOMETRY] ?
Thanks.