topic Re: Count Number of Features in a feature service in ArcGIS Survey123 Questions

Count Number of Features in a feature service

RosemaryHatch — Fri, 14 Jan 2022 16:37:08 GMT

Hello -

I'm trying to generate a unique number for each survey submittal (e.g. 2022-001) and was going to try to use the count of features that were already in the service. My thought is that I would use a custom JS/pull data to query the feature service and count the number of records when the survey is started. Does anyone have an example of how that would look for someone who is very very rough at javascript? I'm attaching what I have right now, which I know is definitely not right.

Thank you!

Re: Count Number of Features in a feature service

IsmaelChivite — Fri, 04 Nov 2022 20:59:37 GMT

Hi, I posed a getCount custom JS function here: https://github.com/IsmaelInRedlands/Survey123-Tricks-of-the-Trade/tree/main

This is what it looks like:

For the feature layer parameter, pass the URL including the layer index. For example:

https://services2.arcgis.com/fJJEXNgxjn0dpNsi/ArcGIS/rest/services/Carriage_Trail/FeatureServer/0

If your layer is shared publicly, you do not need to pass the second parameter. To get the token from the user, use:

pulldata("@property","token")

Starting with the 3.16 release, you can also make use of the pulldata("@layer") function. Check:

Re: Count Number of Features in a feature service

RosemaryHatch — Tue, 18 Jan 2022 21:49:11 GMT

This is perfect, thank you!!

Re: Count Number of Features in a feature service

JerrySneary — Fri, 04 Nov 2022 20:55:01 GMT

Hi @IsmaelChivite,

I am able to return a count of all the records, can I return the count of a variable in the attribute table? Like Count how many records are "Apple" or "Orange"?

Jerry

Re: Count Number of Features in a feature service

IsmaelChivite — Fri, 04 Nov 2022 20:59:54 GMT

Replace the WHERE statement in the URL as shown below for fruit='apple'

var url = featureLayer + "/query?f=json&where=fruit='apple'&returnCountOnly=true";

Starting with the 3.16 release, you can also make use of the pulldata("@layer") function. Check:

Re: Count Number of Features in a feature service

JerrySneary — Fri, 31 May 2024 20:17:13 GMT

Hi @IsmaelChivite ,

Is it possible to use two fields to get a count? I'm using the syntax below but it only allows me to use one or the other not both at the same time.

var url = featureLayer + "/query?f=json&where=fruit='apple'&where=color='Red'&returnCountOnly=true";

Kind regards,

Jerry