Greetings, I'm trying to write a disjoint query to get an indication of which features are outside of the mapView's extent. I've structured the query but it appears that the spatial relationship "disjoint" produces the same results as using "intersect". var deleteQuery = fl . createQuery ( ) ; deleteQuery . geometry = webMercatorUtils . webMercatorToGeographic ( mapExtent ) ; deleteQuery . spatialRelationship = "disjoint" ; // this is the default deleteQuery . returnGeometry = false ; deleteQuery . outFields = [ "OBJECTID" ] ; fl . queryFeatures ( ) . then ( function ( disjointResults ) { fl . applyEdits ( { deleteFeatures : disjointResults . features } ) . then ( function ( delResults ) { fl . queryFeatureCount ( ) . then ( function ( count ) { console . log ( 'AFTER delete fl feature Count: ' + count ) } ) } ) } ) Not sure what I am doing wrong. Does anyone see any glaring mistakes? I logged my query to JSON and thought the '"where":"1=1"' part looked odd since I didn't specify a where property. {"geometry":{"spatialReference":{"wkid":4326},"xmin":-78.78690645507774,"ymin":35.78811526137758,"xmax":-78.77317354491959,"ymax":35.79110471050848},"outFields":["OBJECTID"],"returnGeometry":false,"spatialRel":"disjoint","where":"1=1"} Any ideas will be greatly appreciated. Thanks, Tyler

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Disjoint Query

Anonymous User

Greetings,

I'm trying to write a disjoint query to get an indication of which features are outside of the mapView's extent. I've structured the query but it appears that the spatial relationship "disjoint" produces the same results as using "intersect".

<SPAN class="keyword token">var</SPAN> deleteQuery <SPAN class="operator token">=</SPAN> fl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">createQuery</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
deleteQuery<SPAN class="punctuation token">.</SPAN>geometry <SPAN class="operator token">=</SPAN> webMercatorUtils<SPAN class="punctuation token">.</SPAN><SPAN class="token function">webMercatorToGeographic</SPAN><SPAN class="punctuation token">(</SPAN>mapExtent<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                
deleteQuery<SPAN class="punctuation token">.</SPAN>spatialRelationship <SPAN class="operator token">=</SPAN> <SPAN class="string token">"disjoint"</SPAN><SPAN class="punctuation token">;</SPAN>  <SPAN class="comment token">// this is the default</SPAN>
deleteQuery<SPAN class="punctuation token">.</SPAN>returnGeometry <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">false</SPAN><SPAN class="punctuation token">;</SPAN>
deleteQuery<SPAN class="punctuation token">.</SPAN>outFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">"OBJECTID"</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
fl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">queryFeatures</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">then</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">function</SPAN><SPAN class="punctuation token">(</SPAN>disjointResults<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
  fl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">applyEdits</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">{</SPAN>deleteFeatures<SPAN class="punctuation token">:</SPAN>disjointResults<SPAN class="punctuation token">.</SPAN>features<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="punctuation token">.</SPAN><SPAN class="token function">then</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">function</SPAN><SPAN class="punctuation token">(</SPAN>delResults<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
      fl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">queryFeatureCount</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">then</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">function</SPAN><SPAN class="punctuation token">(</SPAN>count<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
        console<SPAN class="punctuation token">.</SPAN><SPAN class="token function">log</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'AFTER delete fl feature Count: '</SPAN> <SPAN class="operator token">+</SPAN> count<SPAN class="punctuation token">)</SPAN>
      <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>  
  <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>  
<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Not sure what I am doing wrong. Does anyone see any glaring mistakes?

I logged my query to JSON and thought the '"where":"1=1"' part looked odd since I didn't specify a where property.

{"geometry":{"spatialReference":{"wkid":4326},"xmin":-78.78690645507774,"ymin":35.78811526137758,"xmax":-78.77317354491959,"ymax":35.79110471050848},"outFields":["OBJECTID"],"returnGeometry":false,"spatialRel":"disjoint","where":"1=1"}

Any ideas will be greatly appreciated.

Thanks, Tyler

Trouver plus de publications taguées avec

Accepted answers

rscheitlin

No it is more likely that disjoint in not supported on local FeatureLayers. What you can do is do a query for ObectIds of the features that intersect and then when you get that array of OIDs then use a Query.where = "NOT OBJECTID IN (" + your array of OIDS +")";

All comments

Anonymous User

I made the suggested changes but it appears that 'disjoint' is still performing an intersect.

<SPAN class="keyword token">var</SPAN> deleteQuery <SPAN class="operator token">=</SPAN> fl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">createQuery</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
deleteQuery<SPAN class="punctuation token">.</SPAN>geometry <SPAN class="operator token">=</SPAN> webMercatorUtils<SPAN class="punctuation token">.</SPAN><SPAN class="token function">webMercatorToGeographic</SPAN><SPAN class="punctuation token">(</SPAN>mapExtent<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>  
deleteQuery<SPAN class="punctuation token">.</SPAN>spatialRelationship <SPAN class="operator token">=</SPAN> <SPAN class="string token">"disjoint"</SPAN><SPAN class="punctuation token">;</SPAN>  <SPAN class="comment token">// this is the default</SPAN>
deleteQuery<SPAN class="punctuation token">.</SPAN>returnGeometry <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">true</SPAN><SPAN class="punctuation token">;</SPAN>
deleteQuery<SPAN class="punctuation token">.</SPAN>outFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">"*"</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
deleteQuery <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">null</SPAN>
fl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">queryFeatures</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">then</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">function</SPAN><SPAN class="punctuation token">(</SPAN>disjointResults<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
  fl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">applyEdits</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">{</SPAN>deleteFeatures<SPAN class="punctuation token">:</SPAN>disjointResults<SPAN class="punctuation token">.</SPAN>features<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>
  <SPAN class="punctuation token">.</SPAN><SPAN class="token function">then</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">function</SPAN><SPAN class="punctuation token">(</SPAN>delResults<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    fl<SPAN class="punctuation token">.</SPAN><SPAN class="token function">queryFeatureCount</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">then</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">function</SPAN><SPAN class="punctuation token">(</SPAN>count<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
      console<SPAN class="punctuation token">.</SPAN><SPAN class="token function">log</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'AFTER delete fl feature Count: '</SPAN> <SPAN class="operator token">+</SPAN> count<SPAN class="punctuation token">)</SPAN>
    <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>  
  <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>  
<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Are there any other means you can think of to delete features outside of the map extent?

The need for this is that I am querying a map service for some json based on the mapView extent. I'm then querying our Salesforce instance to get additional attribute information. Once I have the map service and Salesforce data I perform a join and add the features to a client side featureLayer. Each time the map extent changes I query our feature service and Salesforce instance again. For speed and to housekeep the feature layer, I want to only add features that are not currently in the feature layer and delete features that are no longer in the map extent.

I suppose I could just delete all the features before I add them and be done with it. However, if there are multiple layers with complex geometries I want to be as efficient as possible.

Thanks, Tyler

rscheitlin

Tyler,

I am not real sure what the issue is. But this is what I would try.

do return the geometry.
return all fields
set the query.where to null

Anonymous User

The WKID of my feature layer is also 4326 . The feature layer is a client side feature layer rather than one created with a URL.

Also, the map spatialReference is {"latestWkid":3857,"wkid":102100} .

Do all of the spatial references need to match for the disjoint to work?

Is the default '"where 1=1"' a problem? Is there a better way to create the query rather than fl.createQuery?

Thanks, Tyler

rscheitlin

Tyler,

What is the spatial reference of the layer you are querying? You are getting a where 1=1 because you are using

<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit; font-size: 14px;">var</SPAN> deleteQuery <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit; font-size: 14px;">=</SPAN> fl<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">.</SPAN><SPAN class="" style="color: #d74444; border: 0px; font-weight: inherit; font-size: 14px;">createQuery</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">(</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">;
</SPAN>

and the default is where 1=1.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.