{"id":1855322,"date":"2023-02-27T07:15:32","date_gmt":"2023-02-27T15:15:32","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1855322"},"modified":"2023-03-09T14:29:27","modified_gmt":"2023-03-09T22:29:27","slug":"upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1","title":{"rendered":"Upsert your datasets using the Append tool in ArcGIS Pro 3.1"},"author":314022,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23341,37101,23851],"tags":[757971,24321,39401,173722],"industry":[],"product":[36561],"class_list":["post-1855322","blog","type-blog","status-publish","format-standard","hentry","category-analytics","category-announcements","category-data-management","tag-append","tag-geoprocessing","tag-geoprocessing-tool","tag-local-government","product-arcgis-pro"],"acf":{"authors":[{"ID":314022,"user_firstname":"Margaret","user_lastname":"Crawford","nickname":"Margaret Crawford","user_nicename":"mcrawford","display_name":"Margaret Crawford","user_email":"mcrawford@esri.com","user_url":"","user_registered":"2022-06-28 19:13:27","user_description":"Margaret is a Product Engineer on the Geoprocessing team. Her passion for GIS began with her interest in human-environmental relationships, and her graduate thesis studied the growing impact of flood-induced cascading disasters caused by sea level rise. Margaret leverages her foundation in research methodologies and spatial analysis techniques in her role at Esri, where she creates written content and demonstrations on features in ArcGIS Pro. She also contributes to refining and redesigning geoprocessing tools and functions. In her personal life, Margaret is a loving cat parent to three beautiful cats, and enjoys swimming and snowboarding.","user_avatar":""}],"short_description":"In ArcGIS Pro 3.1, you can use the Append tool to upsert (update and insert) a target dataset with data from a new or updated dataset. ","flexible_content":[{"acf_fc_layout":"content","content":"

Approximate Reading Time: <\/strong>6 Minutes<\/p>\n

In ArcGIS Pro 3.1<\/a>, you can use the Append<\/strong><\/a> tool to update the records of a target dataset with attributes and geometry from new or updated datasets. This enhancement extends Append <\/strong>from a tool that can load or insert new records into a dataset to one that can also update existing records. In database terminology, this is referred to as an upsert<\/strong>.<\/p>\n

What Is An Upsert Operation?<\/strong><\/h1>\n

Upsert<\/strong> is a combination of the words \u201cupdate\u201d and \u201cinsert,\u201d meaning you can upsert<\/strong> a dataset by updating<\/em> existing records and inserting<\/em> new rows of data.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1855392,"id":1855392,"title":"upsert","filename":"upsert.png","filesize":7251,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/upsert.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1\/upsert","alt":"Upsert illustration","author":"314022","description":"","caption":"Upsert illustration","name":"upsert","status":"inherit","uploaded_to":1855322,"date":"2023-02-24 20:08:55","modified":"2023-02-24 20:09:33","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":371,"height":197,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/upsert-213x197.png","thumbnail-width":213,"thumbnail-height":197,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/upsert.png","medium-width":371,"medium-height":197,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/upsert.png","medium_large-width":371,"medium_large-height":197,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/upsert.png","large-width":371,"large-height":197,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/upsert.png","1536x1536-width":371,"1536x1536-height":197,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/upsert.png","2048x2048-width":371,"2048x2048-height":197,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/upsert.png","card_image-width":371,"card_image-height":197,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/upsert.png","wide_image-width":371,"wide_image-height":197}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Previously, you could only use the Append<\/strong> tool to insert new records from an input dataset to a target dataset. With the new enhancements introduced in ArcGIS Pro 3.1, you can also use Append<\/strong> to update the existing records in your target dataset. This means the Append tool now has the ability to upsert<\/strong> your data.<\/p>\n

The following example shows how to use the Append<\/strong> tool to upsert<\/strong> zoning data by updating<\/em> existing areas with rezoning data and inserting<\/em> newly annexed areas into the zoning dataset.<\/p>\n

Example Scenario<\/strong><\/h1>\n

You are a GIS intern for the City of Charlotte<\/a>, NC, one of the fastest-growing cities in the United States. As the city faces rapid development and growth, your task is to update the city\u2019s zoning data for a forthcoming general plan update.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1857262,"id":1857262,"title":"Layout1forblog","filename":"Layout1forblog-e1677474700205.png","filesize":800462,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Layout1forblog-e1677474700205.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1\/layout1forblog","alt":"A current, simplified zoning map of Charlotte, North Carolina","author":"314022","description":"","caption":"A current, simplified zoning map of Charlotte, NC","name":"layout1forblog","status":"inherit","uploaded_to":1855322,"date":"2023-02-27 05:10:58","modified":"2023-02-27 05:11:45","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":768,"height":576,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Layout1forblog-e1677474700205-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Layout1forblog-e1677474700205-348x261.png","medium-width":348,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Layout1forblog-e1677474700205.png","medium_large-width":768,"medium_large-height":576,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Layout1forblog-e1677474700205.png","large-width":768,"large-height":576,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Layout1forblog-1536x1152.png","1536x1536-width":1536,"1536x1536-height":1152,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Layout1forblog-2048x1536.png","2048x2048-width":2048,"2048x2048-height":1536,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Layout1forblog-e1677474700205-620x465.png","card_image-width":620,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Layout1forblog-1440x1080.png","wide_image-width":1440,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Since the last update, the city has undergone significant changes. First, an existing industrial area has been rezoned to a mixed-use area. Second, the city plans to annex a previously unincorporated land area into its boundaries for single-family homes.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1857232,"id":1857232,"title":"map2forblog","filename":"map2forblog-e1677474452243.png","filesize":585538,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/map2forblog-e1677474452243.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1\/map2forblog","alt":"Example future rezoning and annexation plans","author":"314022","description":"","caption":"Future rezoning and annexation plans","name":"map2forblog","status":"inherit","uploaded_to":1855322,"date":"2023-02-27 05:03:58","modified":"2023-02-27 05:07:36","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":768,"height":576,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/map2forblog-e1677474452243-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/map2forblog-e1677474452243-348x261.png","medium-width":348,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/map2forblog-e1677474452243.png","medium_large-width":768,"medium_large-height":576,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/map2forblog-e1677474452243.png","large-width":768,"large-height":576,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/map2forblog-1536x1152.png","1536x1536-width":1536,"1536x1536-height":1152,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/map2forblog-2048x1536.png","2048x2048-width":2048,"2048x2048-height":1536,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/map2forblog-e1677474452243-620x465.png","card_image-width":620,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/map2forblog-1440x1080.png","wide_image-width":1440,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Your goal is to find a way to easily update the current zoning data and insert the new areas into the city\u2019s zoning map.<\/p>\n

Use Append To Upsert Your Dataset<\/strong><\/h1>\n

Using the Append<\/strong><\/a> geoprocessing tool, follow the steps below to upsert<\/strong> your zoning data.<\/p>\n

First, let\u2019s use the Append<\/strong> tool to insert the newly incorporated zone into the city:<\/p>\n

(1) Add the rezoning data into the Input Dataset<\/strong><\/p>\n

(2) Add the original zoning data to the Target Dataset<\/strong><\/p>\n

Caution:<\/em><\/strong> This tool does not create an output dataset<\/em><\/a>; it modifies the target dataset. <\/em>Take precautions<\/em><\/a>\u00a0if you are unsure you want to modify your target dataset.\u00a0 <\/em><\/p>\n

(3) Leave Field Matching Type<\/strong> at the default setting, \u201cInput fields must match target fields,\u201d if the input and target datasets have matching schema and you do not need to reconcile any field differences.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1857022,"id":1857022,"title":"Append_tool_parameters","filename":"Append_tool_parameters.png","filesize":32938,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Append_tool_parameters.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1\/append_tool_parameters","alt":"Append tool parameters with steps","author":"314022","description":"","caption":"Append tool parameters","name":"append_tool_parameters","status":"inherit","uploaded_to":1855322,"date":"2023-02-27 02:39:12","modified":"2023-02-27 02:39:46","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":348,"height":494,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Append_tool_parameters-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Append_tool_parameters.png","medium-width":184,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Append_tool_parameters.png","medium_large-width":348,"medium_large-height":494,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Append_tool_parameters.png","large-width":348,"large-height":494,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Append_tool_parameters.png","1536x1536-width":348,"1536x1536-height":494,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Append_tool_parameters.png","2048x2048-width":348,"2048x2048-height":494,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Append_tool_parameters-328x465.png","card_image-width":328,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/Append_tool_parameters.png","wide_image-width":348,"wide_image-height":494}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

In previous versions of ArcGIS Pro, you would run the Append<\/strong> tool from here, and the tool would insert the new area and duplicate the rezoned area to the target dataset. However, with the enhancements made in ArcGIS Pro 3.1, the tool now includes the option to update the existing features in your dataset.<\/p>\n

Expand the Update Options<\/strong> dropdown to reveal two new parameters to ensure that your attributes and geometry update when you run the tool.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1857572,"id":1857572,"title":"AppendTool_UpdateOptions2","filename":"AppendTool_UpdateOptions2.png","filesize":10615,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/AppendTool_UpdateOptions2.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1\/appendtool_updateoptions2","alt":"Append tool Update Options","author":"314022","description":"","caption":"Append tool Update Options","name":"appendtool_updateoptions2","status":"inherit","uploaded_to":1855322,"date":"2023-02-27 16:57:46","modified":"2023-02-27 16:58:04","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":348,"height":181,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/AppendTool_UpdateOptions2-213x181.png","thumbnail-width":213,"thumbnail-height":181,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/AppendTool_UpdateOptions2.png","medium-width":348,"medium-height":181,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/AppendTool_UpdateOptions2.png","medium_large-width":348,"medium_large-height":181,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/AppendTool_UpdateOptions2.png","large-width":348,"large-height":181,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/AppendTool_UpdateOptions2.png","1536x1536-width":348,"1536x1536-height":181,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/AppendTool_UpdateOptions2.png","2048x2048-width":348,"2048x2048-height":181,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/AppendTool_UpdateOptions2.png","card_image-width":348,"card_image-height":181,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/AppendTool_UpdateOptions2.png","wide_image-width":348,"wide_image-height":181}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

(4) Use the Matching Fields for Update<\/strong> parameter to update existing records in the target dataset based on matching records in the input dataset. In this example, each zoning polygon has a unique Zone_ID. Therefore, any records from the target with a Zone_ID that matches records in the input dataset will update with values from the input.
\nNote: You can also match based on multiple matching fields.<\/em><\/p>\n

(5) Check the Update Geometry<\/strong> parameter to update any changes made to the existing geometry.<\/p>\n

Run the Append<\/strong> tool.<\/p>\n

Result: The New Zoning Map<\/strong><\/h1>\n

After running the Append<\/strong><\/a> tool, the resulting map includes the updated existing zones and the newly incorporated area into the city.<\/p>\n

A quick swipe through the old and new zoning maps shows we have successfully used the Append<\/strong> tool to upsert<\/strong> the zoning dataset.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1857122,"id":1857122,"title":"append_gifforblog_2border","filename":"append_gifforblog_2border.gif","filesize":5392719,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/append_gifforblog_2border.gif","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1\/append_gifforblog_2border","alt":"Animated swipe through showing the new versus old zoning map.","author":"314022","description":"","caption":"The updated zones versus the original zoning map.","name":"append_gifforblog_2border","status":"inherit","uploaded_to":1855322,"date":"2023-02-27 04:10:43","modified":"2023-02-27 04:12:03","menu_order":0,"mime_type":"image\/gif","type":"image","subtype":"gif","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":768,"height":576,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/append_gifforblog_2border-213x200.gif","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/append_gifforblog_2border.gif","medium-width":348,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/append_gifforblog_2border.gif","medium_large-width":768,"medium_large-height":576,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/append_gifforblog_2border.gif","large-width":768,"large-height":576,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/append_gifforblog_2border.gif","1536x1536-width":768,"1536x1536-height":576,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/append_gifforblog_2border.gif","2048x2048-width":768,"2048x2048-height":576,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/append_gifforblog_2border-620x465.gif","card_image-width":620,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/append_gifforblog_2border.gif","wide_image-width":768,"wide_image-height":576}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

The features where the specified field value, Zone_ID, matched had their geometry and records updated. All other features were appended to the target dataset.<\/p>\n

Summary<\/strong><\/h1>\n

An upsert<\/strong> operation updates existing records and inserts new records from an input to a target dataset. The Append<\/strong><\/a> tool in ArcGIS Pro 3.1<\/a> now includes two new parameters you can use to update the attributes and geometry of a dataset. With these enhancements, you can use the Append tool to upsert<\/strong> your datasets.<\/p>\n"}],"related_articles":[{"ID":1095501,"post_author":"9412","post_date":"2021-01-04 01:00:56","post_date_gmt":"2021-01-04 09:00:56","post_content":"","post_title":"Keeping Layers Updated by Appending Features using the ArcGIS API for Python","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"keeping-layers-updated-by-appending-features-using-the-arcgis-api-for-python","to_ping":"","pinged":"","post_modified":"2024-04-12 04:08:55","post_modified_gmt":"2024-04-12 11:08:55","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1095501","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":1868792,"post_author":"314022","post_date":"2023-03-09 13:08:36","post_date_gmt":"2023-03-09 21:08:36","post_content":"","post_title":"In ArcGIS Pro 3.1, the Points To Line tool has more options for you!","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"arcgispro-3-1-points-to-line-tool-enhancements","to_ping":"","pinged":"","post_modified":"2023-03-29 10:56:00","post_modified_gmt":"2023-03-29 17:56:00","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1868792","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":80841,"post_author":"6981","post_date":"2017-12-11 05:26:44","post_date_gmt":"2017-12-11 05:26:44","post_content":"","post_title":"What\u2019s new with hosted feature layers: Getting to know Append Part 1 (December 2017)","post_excerpt":"","post_status":"publish","comment_status":"closed","ping_status":"closed","post_password":"","post_name":"whats-new-with-hosted-feature-layers-getting-to-know-append-part-1-december-2017","to_ping":"","pinged":"","post_modified":"2019-05-15 11:43:06","post_modified_gmt":"2019-05-15 18:43:06","post_content_filtered":"","post_parent":0,"guid":"http:\/\/www.esri.com\/arcgis-blog\/products\/product\/uncategorized\/whats-new-with-hosted-feature-layers-getting-to-know-append-part-1-december-2017\/","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":81041,"post_author":"6981","post_date":"2017-12-19 06:08:19","post_date_gmt":"2017-12-19 06:08:19","post_content":"","post_title":"What\u2019s new with hosted feature layers: Getting to know Append, Part 2","post_excerpt":"","post_status":"publish","comment_status":"closed","ping_status":"closed","post_password":"","post_name":"whats-new-with-hosted-feature-layers-getting-to-know-append-part-2","to_ping":"","pinged":"","post_modified":"2019-05-15 11:43:42","post_modified_gmt":"2019-05-15 18:43:42","post_content_filtered":"","post_parent":0,"guid":"http:\/\/www.esri.com\/arcgis-blog\/products\/product\/uncategorized\/whats-new-with-hosted-feature-layers-getting-to-know-append-part-2\/","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"}],"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/card_append.png","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/wide_append.png"},"yoast_head":"\nArcGIS Pro 3.1 | Upsert datasets using the Append tool | Blog<\/title>\n<meta name=\"description\" content=\"In ArcGIS Pro 3.1, you can use the Append tool to upsert (update and insert) a target dataset with data from a new or updated dataset.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upsert your datasets using the Append tool in ArcGIS Pro 3.1\" \/>\n<meta property=\"og:description\" content=\"In ArcGIS Pro 3.1, you can use the Append tool to upsert (update and insert) a target dataset with data from a new or updated dataset.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1\" \/>\n<meta property=\"og:site_name\" content=\"ArcGIS Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-09T22:29:27+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ESRI\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1\"},\"author\":{\"name\":\"Margaret Crawford\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/6e92f41055bccb65bf59c3eaccebea25\"},\"headline\":\"Upsert your datasets using the Append tool in ArcGIS Pro 3.1\",\"datePublished\":\"2023-02-27T15:15:32+00:00\",\"dateModified\":\"2023-03-09T22:29:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1\"},\"wordCount\":10,\"commentCount\":6,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"Append\",\"geoprocessing\",\"geoprocessing tool\",\"Local Government\"],\"articleSection\":[\"Analytics\",\"Announcements\",\"Data Management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1\",\"name\":\"ArcGIS Pro 3.1 | Upsert datasets using the Append tool | Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2023-02-27T15:15:32+00:00\",\"dateModified\":\"2023-03-09T22:29:27+00:00\",\"description\":\"In ArcGIS Pro 3.1, you can use the Append tool to upsert (update and insert) a target dataset with data from a new or updated dataset.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upsert your datasets using the Append tool in ArcGIS Pro 3.1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"name\":\"ArcGIS Blog\",\"description\":\"Get insider info from Esri product teams\",\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\",\"name\":\"Esri\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"width\":400,\"height\":400,\"caption\":\"Esri\"},\"image\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/esrigis\/\",\"https:\/\/x.com\/ESRI\",\"https:\/\/www.linkedin.com\/company\/5311\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/6e92f41055bccb65bf59c3eaccebea25\",\"name\":\"Margaret Crawford\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/03\/PXL_20230310_184124630.PORTRAIT234-465x465.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/03\/PXL_20230310_184124630.PORTRAIT234-465x465.jpg\",\"caption\":\"Margaret Crawford\"},\"description\":\"Margaret is a Product Engineer on the Geoprocessing team. Her passion for GIS began with her interest in human-environmental relationships, and her graduate thesis studied the growing impact of flood-induced cascading disasters caused by sea level rise. Margaret leverages her foundation in research methodologies and spatial analysis techniques in her role at Esri, where she creates written content and demonstrations on features in ArcGIS Pro. She also contributes to refining and redesigning geoprocessing tools and functions. In her personal life, Margaret is a loving cat parent to three beautiful cats, and enjoys swimming and snowboarding.\",\"knowsLanguage\":[\"English\"],\"jobTitle\":\"Product Engineer\",\"worksFor\":\"Esri\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/mcrawford\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ArcGIS Pro 3.1 | Upsert datasets using the Append tool | Blog","description":"In ArcGIS Pro 3.1, you can use the Append tool to upsert (update and insert) a target dataset with data from a new or updated dataset.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1","og_locale":"en_US","og_type":"article","og_title":"Upsert your datasets using the Append tool in ArcGIS Pro 3.1","og_description":"In ArcGIS Pro 3.1, you can use the Append tool to upsert (update and insert) a target dataset with data from a new or updated dataset.","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2023-03-09T22:29:27+00:00","twitter_card":"summary_large_image","twitter_site":"@ESRI","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1"},"author":{"name":"Margaret Crawford","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/6e92f41055bccb65bf59c3eaccebea25"},"headline":"Upsert your datasets using the Append tool in ArcGIS Pro 3.1","datePublished":"2023-02-27T15:15:32+00:00","dateModified":"2023-03-09T22:29:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1"},"wordCount":10,"commentCount":6,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["Append","geoprocessing","geoprocessing tool","Local Government"],"articleSection":["Analytics","Announcements","Data Management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1","name":"ArcGIS Pro 3.1 | Upsert datasets using the Append tool | Blog","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2023-02-27T15:15:32+00:00","dateModified":"2023-03-09T22:29:27+00:00","description":"In ArcGIS Pro 3.1, you can use the Append tool to upsert (update and insert) a target dataset with data from a new or updated dataset.","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/upsert-your-datasets-using-the-append-tool-in-arcgis-pro-3-1#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Upsert your datasets using the Append tool in ArcGIS Pro 3.1"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/arcgis-blog\/#website","url":"https:\/\/www.esri.com\/arcgis-blog\/","name":"ArcGIS Blog","description":"Get insider info from Esri product teams","publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization","name":"Esri","url":"https:\/\/www.esri.com\/arcgis-blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","width":400,"height":400,"caption":"Esri"},"image":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/esrigis\/","https:\/\/x.com\/ESRI","https:\/\/www.linkedin.com\/company\/5311\/"]},{"@type":"Person","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/6e92f41055bccb65bf59c3eaccebea25","name":"Margaret Crawford","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/03\/PXL_20230310_184124630.PORTRAIT234-465x465.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/03\/PXL_20230310_184124630.PORTRAIT234-465x465.jpg","caption":"Margaret Crawford"},"description":"Margaret is a Product Engineer on the Geoprocessing team. Her passion for GIS began with her interest in human-environmental relationships, and her graduate thesis studied the growing impact of flood-induced cascading disasters caused by sea level rise. Margaret leverages her foundation in research methodologies and spatial analysis techniques in her role at Esri, where she creates written content and demonstrations on features in ArcGIS Pro. She also contributes to refining and redesigning geoprocessing tools and functions. In her personal life, Margaret is a loving cat parent to three beautiful cats, and enjoys swimming and snowboarding.","knowsLanguage":["English"],"jobTitle":"Product Engineer","worksFor":"Esri","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/mcrawford"}]}},"text_date":"February 27, 2023","author_name":"Margaret Crawford","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/mcrawford","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/02\/wide_append.png","primary_product":"ArcGIS Pro","tag_data":[{"term_id":757971,"name":"Append","slug":"append","term_group":0,"term_taxonomy_id":757971,"taxonomy":"post_tag","description":"","parent":0,"count":7,"filter":"raw"},{"term_id":24321,"name":"geoprocessing","slug":"geoprocessing","term_group":0,"term_taxonomy_id":24321,"taxonomy":"post_tag","description":"","parent":0,"count":129,"filter":"raw"},{"term_id":39401,"name":"geoprocessing tool","slug":"geoprocessing-tool","term_group":0,"term_taxonomy_id":39401,"taxonomy":"post_tag","description":"","parent":0,"count":9,"filter":"raw"},{"term_id":173722,"name":"Local Government","slug":"local-government","term_group":0,"term_taxonomy_id":173722,"taxonomy":"post_tag","description":"","parent":0,"count":22,"filter":"raw"}],"category_data":[{"term_id":23341,"name":"Analytics","slug":"analytics","term_group":0,"term_taxonomy_id":23341,"taxonomy":"category","description":"","parent":0,"count":1325,"filter":"raw"},{"term_id":37101,"name":"Announcements","slug":"announcements","term_group":0,"term_taxonomy_id":37101,"taxonomy":"category","description":"","parent":0,"count":1957,"filter":"raw"},{"term_id":23851,"name":"Data Management","slug":"data-management","term_group":0,"term_taxonomy_id":23851,"taxonomy":"category","description":"","parent":0,"count":920,"filter":"raw"}],"product_data":[{"term_id":36561,"name":"ArcGIS Pro","slug":"arcgis-pro","term_group":0,"term_taxonomy_id":36561,"taxonomy":"product","description":"","parent":0,"count":2035,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=arcgis-pro","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1855322","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/users\/314022"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=1855322"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1855322\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=1855322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=1855322"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=1855322"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=1855322"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=1855322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}