Can I create a query to count features with/without geometry?

Question

I currently have a total count like this:

query?f=json&9999=9999&returnCountOnly=true

But is it possible to count the features with or without geometry? One or the other as I have the total count.

jcarlson · Accepted Answer

Yes! There should be an internal field named "SHAPE_Area" or similar. Just set the where clause to "SHAPE_Area is null / not null".

Here's an example from on of our layers:

https://maps.co.kendall.il.us/server/rest/services/Hosted/Current_Cadastral_Features/FeatureServer/0/query?where=SHAPE__Area+is+null&returnCountOnly=true&f=json

Which returns

{"count":9}