https://community.esri.com/t5/arcgis-pro-questions/sql-definition-query-based-on-stwithin/m-p/1552410#M89508 <P>I'm create a SQL Definition Query for a layer based on the coordinates of a polygon. The code below is not being accepted, and I can't determine why.</P><P>&nbsp;</P><LI-CODE lang="sql">SHAPE.STWithin(geometry::STGeomFromText(POLYGON((139.6668830518439 35.46069824948353,139.6668830518439 35.515095998135905,139.73836302034738 35.515095998135905,139.73836302034738 35.46069824948353))',4326))</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Carto_Broc_0-1729873525506.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/118145i9AB9585900E489DC/image-size/medium?v=v2&amp;px=400" role="button" title="Carto_Broc_0-1729873525506.png" alt="Carto_Broc_0-1729873525506.png" /></span></P><P>&nbsp;</P> Fri, 25 Oct 2024 16:26:00 GMT Carto_Broc 2024-10-25T16:26:00Z https://community.esri.com/t5/arcgis-pro-questions/sql-definition-query-based-on-stwithin/m-p/1552410#M89508 <P>I'm create a SQL Definition Query for a layer based on the coordinates of a polygon. The code below is not being accepted, and I can't determine why.</P><P>&nbsp;</P><LI-CODE lang="sql">SHAPE.STWithin(geometry::STGeomFromText(POLYGON((139.6668830518439 35.46069824948353,139.6668830518439 35.515095998135905,139.73836302034738 35.515095998135905,139.73836302034738 35.46069824948353))',4326))</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Carto_Broc_0-1729873525506.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/118145i9AB9585900E489DC/image-size/medium?v=v2&amp;px=400" role="button" title="Carto_Broc_0-1729873525506.png" alt="Carto_Broc_0-1729873525506.png" /></span></P><P>&nbsp;</P> Fri, 25 Oct 2024 16:26:00 GMT https://community.esri.com/t5/arcgis-pro-questions/sql-definition-query-based-on-stwithin/m-p/1552410#M89508 Carto_Broc 2024-10-25T16:26:00Z https://community.esri.com/t5/arcgis-pro-questions/sql-definition-query-based-on-stwithin/m-p/1552458#M89513 <P>First thing to check is you have an unmatched apostrophe.</P> Fri, 25 Oct 2024 17:24:44 GMT https://community.esri.com/t5/arcgis-pro-questions/sql-definition-query-based-on-stwithin/m-p/1552458#M89513 AlfredBaldenweck 2024-10-25T17:24:44Z