topic Statistics for data that is published from query layer and Materialized View in ArcGIS REST APIs and Services Questions https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/statistics-for-data-that-is-published-from-query/m-p/220965#M1091 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Was wondering, if there is a limitation on statistics feature under ArcGIS 10.7?</P><P></P><P>We made Materialized Views and publish them with query layer but come to see the below flag under Rest end point? Is statistic/calculations not supported for service publish this way?</P><P></P><P><STRONG style="color: #000000; background-color: #ffffff; font-size: 14.4px;">Supports Calculate:<SPAN>&nbsp;</SPAN></STRONG><SPAN style="color: #000000; background-color: #ffffff; font-size: 14.4px;">false</SPAN></P><P></P><P></P><P><SPAN style="color: #000000; background-color: #ffffff; font-size: 14.4px;">Thanks&nbsp;in advance,</SPAN></P><P><SPAN style="color: #000000; background-color: #ffffff; font-size: 14.4px;">Shay</SPAN></P></BODY></HTML> Thu, 15 Oct 2020 12:36:54 GMT shay-geo 2020-10-15T12:36:54Z Statistics for data that is published from query layer and Materialized View https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/statistics-for-data-that-is-published-from-query/m-p/220965#M1091 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Was wondering, if there is a limitation on statistics feature under ArcGIS 10.7?</P><P></P><P>We made Materialized Views and publish them with query layer but come to see the below flag under Rest end point? Is statistic/calculations not supported for service publish this way?</P><P></P><P><STRONG style="color: #000000; background-color: #ffffff; font-size: 14.4px;">Supports Calculate:<SPAN>&nbsp;</SPAN></STRONG><SPAN style="color: #000000; background-color: #ffffff; font-size: 14.4px;">false</SPAN></P><P></P><P></P><P><SPAN style="color: #000000; background-color: #ffffff; font-size: 14.4px;">Thanks&nbsp;in advance,</SPAN></P><P><SPAN style="color: #000000; background-color: #ffffff; font-size: 14.4px;">Shay</SPAN></P></BODY></HTML> Thu, 15 Oct 2020 12:36:54 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/statistics-for-data-that-is-published-from-query/m-p/220965#M1091 shay-geo 2020-10-15T12:36:54Z Re: Statistics for data that is published from query layer and Materialized View https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/statistics-for-data-that-is-published-from-query/m-p/220966#M1092 <HTML><HEAD></HEAD><BODY><P>Never Mind. Figured out what the issue was with this one. Make sure you provide a correct</P><PRE class="lia-code-sample line-numbers language-none">oid_fields fields to map to when you send it to below function.</PRE><PRE class="lia-code-sample line-numbers language-none">MakeQueryLayer(input_database, out_layer_name, query, {oid_fields}, {shape_type}, {srid}, {spatial_reference}, {spatial_properties}, {m_values}, {z_values}, {extent}) If you need to know more about Postgres ESRI Implementation. Please follow the discussion here <A href="https://community.esri.com/ideas/15921-support-for-postgresql-11" target="_blank">Support for PostgreSQL 11</A>&nbsp;by <A href="https://community.esri.com/migrated-users/11793" target="_blank">Marco Boeringa</A>‌. </PRE></BODY></HTML> Sat, 11 Dec 2021 10:46:20 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/statistics-for-data-that-is-published-from-query/m-p/220966#M1092 shay-geo 2021-12-11T10:46:20Z