Label | Explanation | Data Type |
Input Table
| The table containing the x- and y-coordinates or addresses that define the locations of the records. | Table View |
Target Features
| The point feature class or feature layer to be updated. | Feature Layer |
Location Type
| Specifies whether features will be created using x,y-coordinates or addresses.
| String |
X Field
(Optional) | The field in the input table that contains the x-coordinates (or longitude). This parameter is only enabled when the Location Type parameter is set to Coordinates. | Field |
Y Field
(Optional) | The field in the input table that contains the y-coordinates (or latitude). This parameter is only enabled when the Location Type parameter is set to Coordinates. | Field |
Coordinate System
(Optional) | The coordinate system of the x- and y-coordinates. This parameter is only enabled when the Location Type parameter is set to Coordinates. | Coordinate System |
Address Locator
(Optional) | The address locator to use to geocode the table of addresses. When this parameter is set to use ArcGIS World Geocoding Service, this operation may consume credits. Note:When using a local address locator, adding the .loc extension after the locator name at the end of the locator path is optional. This parameter is only enabled when the Location Type parameter is set to Addresses. | Address Locator |
Address Type
(Optional) | Specifies how address fields used by the address locator will be mapped to fields in the input table of addresses.
| String |
Address Fields
(Optional) | The input table fields that correspond to the locator address fields of the address locator. Some locators support multiple input address fields, such as Address, Address2, and Address3. In this case, the address component can be separated into multiple fields, and the address fields will be concatenated at the time of geocoding. For example, 100, Main st, and Apt 140 across three fields, or 100 Main st and Apt 140 across two fields, both become 100 Main st Apt 140 when geocoding. If you choose not to map an optional input address field used by the address locator to a field in the input table of addresses, specify that there is no mapping by leaving the field name blank. This parameter is only active when the Location Type parameter is set to Addresses. | Value Table |
Invalid Records Table
(Optional) | The output table containing a list of invalid records and associated invalidation codes. | Table |
Expression
(Optional) |
The SQL expression used to select a subset of the input datasets' records. If multiple input datasets are specified, they will all be evaluated using the expression. If no records match the expression for an input dataset, no records from that dataset will be appended to the target. For more information about SQL syntax, see SQL reference for query expressions used in ArcGIS. | SQL Expression |
Update Existing Target Features
(Optional) |
Specifies whether existing records will be updated in the Target Features parameter.
| Boolean |
Match Fields
(Optional) | The ID field or fields that will be used to determine matches between the Input Table values and the Target Features values. This parameter is only enabled when the Update Existing Target Features parameter is checked. | Value Table |
Input Table Last Modified Date Field
(Optional) | The last modified date of the Input Features records. Date and string field types are supported. This parameter is only enabled when the Update Existing Target Features parameter is checked. | Field |
Target Features Last Modified Date Field
(Optional) |
The field containing the last modified date of the Target Features records. This field must be a date field type. This parameter is only enabled when the Update Existing Target Features parameter is checked. | Field |
Update Only Matching Features
(Optional) | Specifies whether only existing records will be updated or existing records will be updated and new records will be added.
This parameter is only active when the Update Existing Target Features parameter is checked. | Boolean |
Update Geometry for Existing Features
(Optional) | Specifies whether the geometry of existing features will be updated.
This parameter is only enabled when the Update Existing Target Features parameter is checked. | Boolean |
Field Matching Type
(Optional) | Specifies whether the fields of the input table must match the fields of the target features for data to be appended.
| String |
Field Map
(Optional) | Controls how the attribute fields from the input table will be transferred or mapped to the target features. This parameter is only active if the Field Matching Type parameter is set to Use the field map to reconcile field differences. Because the input table values are appended to an existing target feature that has predefined fields, you cannot add, remove, or change the type of the fields in the field map. You can, however, set merge rules for each output field. Merge rules allow you to specify how values from two or more input fields are merged or combined into a single output value. There are several merge rules you can use to determine how the output field will be populated with values.
| Field Mappings |
Time Format
|
The format of the input field containing the time values. The type can be short, long, float, double, text, or date. You can either choose a standard time format from the drop-down list or enter a custom format. Note:The format strings are case sensitive.
Learn more about custom dates and time formats This parameter is only active when the Input Table Last Modified Date parameter value is a text field and the Target Features Last Modified Date Field parameter value is a date field, or the Field Map parameter input value is a text field and the output value is a date field. | String |
Derived Output
Label | Explanation | Data Type |
Updated Target Features | The updated target features. | Feature Layer |