My second BVAD3 project with Esri ArcGIS Mapping

Mashiane

Expert
Licensed User
Longtime User
Entering the rabbit hole...

I don't know much about Esri GIS Mapping as yet, but surely I will get there. The first project I dealt with was about manipulating service states (start /stop/ restart all / stop all) on demand via a nice BVAD3 UI, it was awesome. Client was happy.

This one is more about extracting data from Feature Layers and updating them.

Thanks to a very special mentor from the Forum here, who is always there when needed. This is a field I want to journey into big time!

I learned something today when performing queries via the AGOL REST API, a limit of 1K records at a time if your query include your own defined "outFields".

arcGisOnlineFeautureLayerDataExtraction.png


The Feature Layer has 3236 records and I need to first extract the records and then will edit one to update all others. Thing is without some magic it seems, the "select field1, field2, field3 from xyz" (not real SQL statement expected) is limited to 1K records at a time.

To get all records one has to create a paging loop, e.g. select the first 1K, then the next 1K etc etc, until all records are selected and you can save these in a List.

The next step is to just update any of the Maintenance Costs amounts, fire a confirmation, then all records are updated, then submit the MVP.

Wish me success!

PS: This is possible due to B4X + BANano.
 
Top