Query Shape.STLength/ Shape.STArea not working for the map/feature service

Question

Original User: dailixian

Hi, 
Anyone knows why we cannot query the Shape.STLength()/ Shape.STArea()  field in the map services. The data was stored in the ArcSDE. But we are able to select features by the query like Shape.STLength() < 10000 in the ArcMap with the sde data loaded. More details in the attachments. Thank you very much.

worksInArcMap.jpg

NotworksInMap&FeatureService.PNG

BruceRiesterer_0-1633643010668.png

AddAttachmentError.PNG

LixianDai1 · Answer

dailixian,
you are using 10.2 or later version. if so, this is a current limitation we have when StandardizedQueries  is enabled (which is the default setting though).

you may want to disable that if you have to use to those fields.

Thanks for your answer. So if we do not want to turn off the standardizedQueries for our server, we cannot use the query task or find task to query by where clause like Shape.STLength/ Shape.STArea < 10000? Except this solution, do we have any alternative way to make the query go through?

Thank you very much.

Anonymous User · Answer

Original User: mahoque

dailixian,
you are using 10.2 or later version. if so, this is a current limitation we have when StandardizedQueries  is enabled (which is the default setting though).

you may want to disable that if you have to use to those fields.