Label | Explanation | Data Type |
Input Table
| The nonspatial table or table containing the x- and y-coordinates or addresses that define the locations of the records. | Table View |
Target Features
| The point feature class, point feature layer, or table that will be updated. | Feature Layer; Table View |
Location Type
(Optional) | Specifies whether features will be created using x,y-coordinates or addresses. This parameter is only active when the Target Features parameter value is a feature class or layer.
| String |
X Field
(Optional) | The field in the input table that contains the x-coordinates (or longitude). This parameter is only active when the Location Type parameter is set to Coordinates and the Target Features parameter value is a feature class or layer. | Field |
Y Field
(Optional) | The field in the input table that contains the y-coordinates (or latitude). This parameter is only active when the Location Type parameter is set to Coordinates and the Target Features parameter value is a feature class or layer. | Field |
Coordinate System
(Optional) | The coordinate system of the x- and y-coordinates. This parameter is only active when the Location Type parameter is set to Coordinates and the Target Features parameter value is a feature class or layer. | Coordinate System |
Address Locator
(Optional) | The address locator that will be used 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 active when the Location Type parameter is set to Addresses and the Target Features parameter value is a feature class or layer. | 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. Select Single Field if the complete address is stored in one field in the input table, for example, 303 Peachtree St NE, Atlanta, GA 30308. Select Multiple Fields if the input addresses are divided into multiple fields such as Address, City, State, and ZIP for a general United States address. This parameter is only active when the Location Type parameter is set to Addresses and the Target Features parameter value is a feature class or layer.
| 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 do not 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 that will be 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 value.
| 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 active when the Update Existing Target Features parameter is checked. | Value Table |
Input Table Last Modified Date Field
(Optional) | The field containing the last modified date of the Input Features records. Date and string field types are supported. This parameter is only active 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 active 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 active when the Update Existing Target Features parameter is checked and the Target Features parameter value is a feature class or layer. | 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. The field map can also be used to combine values from two or more input fields into a single output field. | 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 provide 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 dataset. | Feature Layer; Table View |