topic Re: Calculate max value on feature layer in ArcGIS API for Python Questions

Calculate max value on feature layer

Jose_FranciscoSánchez_Díaz1 — Sat, 15 May 2021 11:12:49 GMT

Hello!

I'm tryng to get the max value on a feature layer using argis python api.

I need to check the max record on a numeric field.
I was able to get it loading the feature layer to a spatial dataframe, but it is slow and will become slower once the feature layer grow (I spect to reach near a million records).

I think it is possible with the fearurelayer metho, but I don know how to do it.

My actual code:

sdf = pd.DataFrame.spatial.from_layer(feature_layer_hosted_on_arcgis)
id = sdf["id"]
max_value = id.max()

Re: Calculate max value on feature layer

DavidPike — Sat, 15 May 2021 11:22:55 GMT

If you go to the FeatureLayer heading arcgis.features module — arcgis 1.8.5 documentation there is a query() method with an out_statistics parameter (min,max etc.). This may be faster.

Re: Calculate max value on feature layer

MingHome — Sat, 15 May 2021 12:07:36 GMT

Have you triedfeaturelayer.query with "out_statistics"?

Ming

Re: Calculate max value on feature layer

Jose_FranciscoSánchez_Díaz1 — Sun, 16 May 2021 21:45:25 GMT

Hello!
I was able to do it with out_statistics:

max_value = feature_layer.query(out_fields='id', out_statistics=[{"statisticType":"max", "onStatisticField": "id", "outStatisticFieldName": "maxid"}])
for record in max_value:
print(record.get_value("maxid"))

Wasn't sure how to do it beacause I'm still learning how to deal with the api, but It's done and it is faster than creating a spatialdataframe.
Thanks for your help!

Re: Calculate max value on feature layer

Anonymous User — Wed, 19 May 2021 02:07:34 GMT

Excellent, thanks!

Re: Calculate max value on feature layer

alex_friant — Mon, 18 Mar 2024 22:37:11 GMT

Thank you for posting the solution that worked for you - that's a big help!