20190117 17080200 1.0 TRUE 20190805 105840 Merge 20190117 Combines multiple input datasets into a single, new output dataset. This tool can combine point, line, or polygon feature classes or tables. Use the Append tool to combine input datasets with an existing dataset. 005 Add Aggregate Append Attach Combine Concatenate Dataset Fuse Join Map New Union Unite ArcToolbox Tool 20190410 Environmental Systems Research Institute, Inc. (Esri) 380 New York Street Redlands California 92373-8100 info@esri.com United States 909-793-2853 909-793-5953 http://www.esri.com 007

<DIV STYLE="text-align:Left;"><DIV><P><SPAN>Combina múltiplas entradas em único dado de saída.</SPAN></P></DIV></DIV>

Merge_management The input datasets that will be merged into a new output dataset. Input datasets can be point, line, or polygon feature classes or tables. Input feature classes must all be of the same geometry type. Tables and feature classes can be combined in a single output dataset. The output type is determined by the first input. If the first input is a feature class, the output will be a feature class; if the first input is a table, the output will be a table. If a table is merged into a feature class, the rows from the input table will have null geometry. <DIV STYLE="text-align:Left;"><DIV><P><SPAN>Dados de entrada podem ser ponto, linha, polígono ou tabela.</SPAN></P></DIV></DIV> The output dataset that will contain all combined input datasets. <DIV STYLE="text-align:Left;"><DIV><P><SPAN>Conjunto de dados que irá conter os dados de entrada combinados.</SPAN></P></DIV></DIV> Controls how the attribute fields from the input datasets are mapped and transferred to the output dataset. You can add, rename, or delete output fields as well as set properties, such as data type and merge rule. 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 that determine how the output field is populated with values. First—Use the input fields' first value. Last—Use the input fields' last value. Join—Concatenate (join) the input fields' values. Sum—Calculate the total of the input fields' values. Mean—Calculate the mean (average) of the input fields' values. Median—Calculate the median (middle) of the input fields' values. Mode—Use the value with the highest frequency. Min—Use the minimum value of all input fields' values. Max—Use the maximum value of all input fields' values. Standard deviation—Use the standard deviation classification method on all input fields' values. Count—Find the number of records included in the calculation. You can use the ArcPy FieldMappings class to define this parameter. <DIV STYLE="text-align:Left;"><DIV><P><SPAN>Controls how the attribute fields from the input datasets are mapped and transferred to the output dataset.You can add, rename, or delete output fields as well as set properties, such as data type and merge rule.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 that determine how the output field is populated with values.First—Use the input fields' first value.Last—Use the input fields' last value.Join—Concatenate (join) the input fields' values.Sum—Calculate the total of the input fields' values.Mean—Calculate the mean (average) of the input fields' values.Median—Calculate the median (middle) of the input fields' values.Mode—Use the value with the highest frequency.Min—Use the minimum value of all input fields' values.Max—Use the maximum value of all input fields' values.Standard deviation—Use the standard deviation classification method on all input fields' values.Count—Find the number of records included in the calculation.</SPAN></P></DIV></DIV> Specifies whether source information will be added to the output dataset in a new text field, MERGE_SRC. The values in the MERGE_SRC field will indicate the input dataset path or layer name that is the source of each record in the output. NO_SOURCE_INFO— Source information will not be added to the output dataset in a MERGE_SRC field. This is the default. ADD_SOURCE_INFO—Source information will be added to the output dataset in a MERGE_SRC field. <DIV STYLE="text-align:Left;"><DIV><P><SPAN>Specifies whether source information will be added to the output dataset in a new text field, MERGE_SRC. The values in the MERGE_SRC field will indicate the input dataset path or layer name that is the source of each record in the output. Unchecked—Source information will not be added to the output dataset in a MERGE_SRC field. This is the default.Checked—Source information will be added to the output dataset in a MERGE_SRC field.</SPAN></P></DIV></DIV> <DIV STYLE="text-align:Left;"><DIV><P><SPAN>The name of the optional feature service to create on the federated server containing the result of this tool. If no name is specified an output feature service will not be created.</SPAN></P></DIV></DIV> Use this tool to combine datasets from multiple sources into a new, single output dataset. All input feature classes must be of the same geometry type. For example, several point feature classes can be merged, but a line feature class cannot be merged with a polygon feature class. Tables and feature classes can be combined in a single output dataset. The output type is determined by the first input. If the first input is a feature class, the output will be a feature class,; if the first input is a table, the output will be a table. If a table is merged into a feature class, the rows from the input table will have null geometry. All fields in the output dataset and the contents of those fields can be controlled using the Field map. This tool will not split or alter the geometries from the input datasets. All features from the input datasets will remain intact in the output dataset, even if the features overlap. To combine, or planarize, feature geometries, use the Union tool. If feature classes are being merged, the output dataset will be in the coordinate system of the first feature class in the Input Datasets list, unless the Output Coordinate System geoprocessing environment is set. This tool does not support annotation feature classes. Use the Append Annotation Feature Classes tool to combine annotation feature classes. This tool does not support raster datasets. Use the Mosaic To New Raster tool to combine multiple rasters into a new output raster. The following Python window script demonstrates how to use the Merge tool. import arcpy arcpy.env.workspace = "C:/data" arcpy.Merge_management(["majorrds.shp", "Habitat_Analysis.gdb/futrds"], "C:/output/Output.gdb/allroads", "", "ADD_SOURCE_INFO") Use the Merge tool to move features from two street feature classes into a single dataset. # Name: Merge.py # Description: Use Merge tool to move features from two street # feature classes into a single dataset with field mapping # import system modules import arcpy # Set environment settings arcpy.env.workspace = "C:/data" # Street feature classes to be merged oldStreets = "majorrds.shp" newStreets = "Habitat_Analysis.gdb/futrds" addSourceInfo = "ADD_SOURCE_INFO" # Create FieldMappings object to manage merge output fields fieldMappings = arcpy.FieldMappings() # Add all fields from both oldStreets and newStreets fieldMappings.addTable(oldStreets) fieldMappings.addTable(newStreets) # Add input fields "STREET_NAM" & "NM" into new output field fldMap_streetName = arcpy.FieldMap() fldMap_streetName.addInputField(oldStreets, "STREET_NAM") fldMap_streetName.addInputField(newStreets, "NM") # Set name of new output field "Street_Name" streetName = fldMap_streetName.outputField streetName.name = "Street_Name" fldMap_streetName.outputField = streetName # Add output field to field mappings object fieldMappings.addFieldMap(fldMap_streetName) # Add input fields "CLASS" & "IFC" into new output field fldMap_streetClass = arcpy.FieldMap() fldMap_streetClass.addInputField(oldStreets, "CLASS") fldMap_streetClass.addInputField(newStreets, "IFC") # Set name of new output field "Street_Class" streetClass = fldMap_streetClass.outputField streetClass.name = "Street_Class" fldMap_streetClass.outputField = streetClass # Add output field to field mappings object fieldMappings.addFieldMap(fldMap_streetClass) # Remove all output fields from the field mappings, except fields # "Street_Class", "Street_Name", & "Distance" for field in fieldMappings.fields: if field.name not in ["Street_Class", "Street_Name", "Distance"]: fieldMappings.removeFieldMap(fieldMappings.findFieldMapIndex(field.name)) # Since both oldStreets and newStreets have field "Distance", no field mapping # is required # Use Merge tool to move features into single dataset uptodateStreets = "C:/output/Output.gdb/allroads" arcpy.Merge_management([oldStreets, newStreets], uptodateStreets, fieldMappings, addSourceInfo) ArcGIS geoprocessing tool that combines multiple input datasets into a single, new output dataset. withheld