Calculating field values in batch

获得 Production Mapping 许可后可用。

When you are editing data, the Advanced SQL Calculator tool allows you to calculate the values of a common field across multiple tables in your schema in the current edit workspace.

1. 启动 ArcMap。
2. 如有必要，可在地图中加载数据。
3. 在主菜单上，单击自定义 > 工具条 > 生产编辑。
4. 单击生产编辑工具条上的启动生产编辑按钮 。

   注：

   使用启动生产编辑工具开始编辑会话时，系统将自动显示管理要素和创建属性、更新属性或元数据属性窗口。

   提示：

   如果开始编辑会话时未显示创建属性、更新属性或元数据属性窗口，请单击管理要素窗口上的显示/隐藏属性按钮 。

5. Add the Advanced SQL Calculator tool by doing the following:
   1. Click Customize > Customize Mode on the main menu.

      The Customize dialog box appears.

   2. Click the Commands tab.
   3. In the Categories list, click Production Editing.
   4. Click and drag the Advanced SQL Calculator button to a toolbar.
   5. Click Close.
6. Click the Advanced SQL Calculator button .

   The Advanced SQL Calculator dialog box appears.

   

7. Build a query to select features.
8. Right-click any column header in the Advanced SQL Calculator Results window and click Field Calculator to batch calculate the fields in that column.

   提示：

   To limit the records that will be processed by the field calculator, select the records in the Advanced SQL Calculator Results window by clicking them and choosing Selected.

   The Field Calculator dialog box appears.

9. Type the new value in the text box or choose a value from the drop-down list for fields that use a coded value domain.

   提示：

   To calculate a field to <Null>, type null or none in the text box.

10. 单击确定。