https://community.esri.com/t5/geodatabase-questions/create-empty-wkb-geometry-using-sql/m-p/1351973#M8687 <P><EM>Oracle 18c; 10.7.1 EGDB; SDE.ST_GEOMETRY</EM></P><P>Is there a way to create an empty,&nbsp;<EM>well-known binary (WKB)</EM> geometry using SQL?</P><P>Similar to well-known text (WKT):&nbsp;</P><PRE>SDE.ST_PolyFromText('POLYGON <FONT color="#0000FF"><STRONG>EMPTY</STRONG></FONT>',4326)&nbsp;</PRE><P>but for WKB.</P><P>Related:&nbsp;<A href="https://community.esri.com/t5/geodatabase-questions/create-nil-zero-vertex-geometry/m-p/1343487/highlight/true#M8658" target="_self">Create NIL (zero vertex) geometry</A></P> Tue, 21 Nov 2023 14:51:49 GMT Bud 2023-11-21T14:51:49Z https://community.esri.com/t5/geodatabase-questions/create-empty-wkb-geometry-using-sql/m-p/1351973#M8687 <P><EM>Oracle 18c; 10.7.1 EGDB; SDE.ST_GEOMETRY</EM></P><P>Is there a way to create an empty,&nbsp;<EM>well-known binary (WKB)</EM> geometry using SQL?</P><P>Similar to well-known text (WKT):&nbsp;</P><PRE>SDE.ST_PolyFromText('POLYGON <FONT color="#0000FF"><STRONG>EMPTY</STRONG></FONT>',4326)&nbsp;</PRE><P>but for WKB.</P><P>Related:&nbsp;<A href="https://community.esri.com/t5/geodatabase-questions/create-nil-zero-vertex-geometry/m-p/1343487/highlight/true#M8658" target="_self">Create NIL (zero vertex) geometry</A></P> Tue, 21 Nov 2023 14:51:49 GMT https://community.esri.com/t5/geodatabase-questions/create-empty-wkb-geometry-using-sql/m-p/1351973#M8687 Bud 2023-11-21T14:51:49Z