<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Spatial types: What type constructors auto-validate geometries? in Geodatabase Questions</title>
    <link>https://community.esri.com/t5/geodatabase-questions/spatial-types-what-type-constructors-auto-validate/m-p/1180918#M7688</link>
    <description>&lt;P&gt;Regarding the various spatial types that are supported by ArcGIS:&lt;/P&gt;&lt;P&gt;What types auto-validate geometries? And what types don't auto-validate?&lt;/P&gt;&lt;P&gt;For example, if I were to create a polygon geometry from this &lt;U&gt;&lt;EM&gt;incorrect&lt;/EM&gt;&lt;/U&gt; WKT (the last vertex is slightly different from the first vertex, which is wrong), what would happen? Would the incorrect geometry be accepted, or would it throw an error?&lt;/P&gt;&lt;PRE&gt;--Example: SDE.ST_GEOMETRY&lt;BR /&gt;select
    sde.st_geometry ('polygon ((6768&lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;32&lt;/STRONG&gt;&lt;/FONT&gt;.320 48575&lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;78&lt;/STRONG&gt;&lt;/FONT&gt;.086, 665287.423 4857578.086, 665277.423 4878109.585, 
                                676832.320 4878119.585, 6768&lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;42&lt;/STRONG&gt;&lt;/FONT&gt;.320 48575&lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;88&lt;/STRONG&gt;&lt;/FONT&gt;.086))', 26917)
from
    dual&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;ORA-20004: &amp;#3;&lt;BR /&gt;ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 12&lt;BR /&gt;ORA-06512: at "SDE.ST_GEOMETRY", line 55&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;SDE.ST_GEOMETRY in Oracle:&lt;BR /&gt;&lt;STRONG&gt;Auto-validates&lt;/STRONG&gt; — would throw an error.&lt;/LI&gt;&lt;LI&gt;SDO_GEOMETRY (Oracle):&lt;BR /&gt;&lt;STRONG&gt;Doesn't&lt;/STRONG&gt; auto-validate — doesn't throw an error, unless we explicitly perform a validation via a validation function(?).&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Others?&lt;BR /&gt;Have I understood that correctly?&lt;/P&gt;</description>
    <pubDate>Wed, 08 Jun 2022 07:29:37 GMT</pubDate>
    <dc:creator>Bud</dc:creator>
    <dc:date>2022-06-08T07:29:37Z</dc:date>
    <item>
      <title>Spatial types: What type constructors auto-validate geometries?</title>
      <link>https://community.esri.com/t5/geodatabase-questions/spatial-types-what-type-constructors-auto-validate/m-p/1180918#M7688</link>
      <description>&lt;P&gt;Regarding the various spatial types that are supported by ArcGIS:&lt;/P&gt;&lt;P&gt;What types auto-validate geometries? And what types don't auto-validate?&lt;/P&gt;&lt;P&gt;For example, if I were to create a polygon geometry from this &lt;U&gt;&lt;EM&gt;incorrect&lt;/EM&gt;&lt;/U&gt; WKT (the last vertex is slightly different from the first vertex, which is wrong), what would happen? Would the incorrect geometry be accepted, or would it throw an error?&lt;/P&gt;&lt;PRE&gt;--Example: SDE.ST_GEOMETRY&lt;BR /&gt;select
    sde.st_geometry ('polygon ((6768&lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;32&lt;/STRONG&gt;&lt;/FONT&gt;.320 48575&lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;78&lt;/STRONG&gt;&lt;/FONT&gt;.086, 665287.423 4857578.086, 665277.423 4878109.585, 
                                676832.320 4878119.585, 6768&lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;42&lt;/STRONG&gt;&lt;/FONT&gt;.320 48575&lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;88&lt;/STRONG&gt;&lt;/FONT&gt;.086))', 26917)
from
    dual&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;ORA-20004: &amp;#3;&lt;BR /&gt;ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 12&lt;BR /&gt;ORA-06512: at "SDE.ST_GEOMETRY", line 55&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;SDE.ST_GEOMETRY in Oracle:&lt;BR /&gt;&lt;STRONG&gt;Auto-validates&lt;/STRONG&gt; — would throw an error.&lt;/LI&gt;&lt;LI&gt;SDO_GEOMETRY (Oracle):&lt;BR /&gt;&lt;STRONG&gt;Doesn't&lt;/STRONG&gt; auto-validate — doesn't throw an error, unless we explicitly perform a validation via a validation function(?).&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Others?&lt;BR /&gt;Have I understood that correctly?&lt;/P&gt;</description>
      <pubDate>Wed, 08 Jun 2022 07:29:37 GMT</pubDate>
      <guid>https://community.esri.com/t5/geodatabase-questions/spatial-types-what-type-constructors-auto-validate/m-p/1180918#M7688</guid>
      <dc:creator>Bud</dc:creator>
      <dc:date>2022-06-08T07:29:37Z</dc:date>
    </item>
  </channel>
</rss>

