topic Re: ArcGIS Srv 10.3 advanced query in ArcGIS Enterprise Questions

ArcGIS Srv 10.3 advanced query

FlorianCADOZ — Tue, 30 Jun 2015 15:45:17 GMT

Hello everyone !

I would like to do an advanced query by the Rest API which look like something like this :

SELECT CAST(AVG(nbr_trip) AS integer)

FROM (

SELECT id_people, count(id_trip) AS nbr_trip

FROM base.trip

GROUP BY id_people

ORDER BY id_people

) AS tmp_query

My goal is to return back only a number which is the average of a count but the REST UI doesn't seem to allow me to do that...

Someone could help me please ?

Thx by advance !

RebeccaStrauch__GISP — Tue, 30 Jun 2015 20:28:14 GMT

Florian, you may want to "share" this question with ArcGIS REST API too (you can share without re-asking ...or add tags)

That group might have more insight.

FlorianCADOZ — Wed, 01 Jul 2015 12:50:40 GMT

Thx for the guidance Rebecca, I didn't saw there was this topic !

FlorianCADOZ — Fri, 03 Jul 2015 08:26:08 GMT

Allo ? No-One knows nor can help me ?