SQL-Use SQL for the fastest performance with calculations that can be performed with standardized SQL (SQL-92) expressions on nonspatial attributes.Additionally, if an error occurs while calculating a particular row, you can stop and troubleshoot the problem, and start the calculation again after you correct the problem. ArcGIS Arcade- Arcade is ideal for calculations that require more functionality than SQL, as Arcade provides access to attribute values and feature geometry, allowing you to create expressions that include spatial operations.
You have two options when writing calculation expressions on fields in layers in a hosted feature layer: To populate the estimated_property_taxes field, define a calculation expression for the field that takes the values in the sale_price field and multiplies them by the tax_rate values. Considerations when calculating field valuesįield calculations allow the hosted feature layer owner or organization administrator to alter the values of every row for a single field in the attribute table of a layer.įor example, if you have a hosted feature layer that stores information on property sales-including the sale price and tax rate for the property location-you could add a field to the layer to store estimated property taxes.