{"id":2178492,"date":"2023-12-04T07:46:26","date_gmt":"2023-12-04T15:46:26","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=2178492"},"modified":"2023-12-06T06:42:46","modified_gmt":"2023-12-06T14:42:46","slug":"join-enhancements-pro-3-2","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2","title":{"rendered":"Join Enhancements in ArcGIS Pro 3.2"},"author":314022,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23341,37101],"tags":[25891,24321,39401,26161,70121],"industry":[],"product":[36561],"class_list":["post-2178492","blog","type-blog","status-publish","format-standard","hentry","category-analytics","category-announcements","tag-arcgis","tag-geoprocessing","tag-geoprocessing-tool","tag-new-release","tag-spatial-join","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":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/03\/PXL_20230310_184124630.PORTRAIT234-465x465.jpg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"}],"short_description":"ArcGIS Pro 3.2 includes a number of enhancements to the Spatial Join, Add Spatial Join, Add Join, and Join Field tools.","flexible_content":[{"acf_fc_layout":"content","content":"<p><strong>Approximate Reading Time:<\/strong> 7 minutes<\/p>\n<p>The<a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/get-started\/whats-new-in-arcgis-pro.htm\"><strong> ArcGIS Pro 3.2<\/strong><\/a> release introduces new parameters and features to the <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/analysis\/spatial-join.htm\"><strong>Spatial Join<\/strong><\/a>, <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/add-spatial-join.htm\"><strong>Add Spatial Join<\/strong><\/a>, <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/add-join.htm\"><strong>Add Join<\/strong><\/a><strong>, <\/strong>and <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/join-field.htm\"><strong>Join Field<\/strong><\/a> tools.<\/p>\n<p>Let\u2019s explore these enhancements and how you might use them in more detail!<\/p>\n<h1><strong>Spatial Join and Add Spatial Join<\/strong><\/h1>\n<p>The <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/analysis\/spatial-join.htm\"><strong>Spatial Join<\/strong><\/a> and <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/add-spatial-join.htm\"><strong>Add Spatial Join<\/strong><\/a> tools have a new <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/analysis\/spatial-join.htm#:~:text=The%20Matching%20Attributes%20parameter%20filters,addition%20to%20their%20spatial%20relationship.\"><strong>Matching Attributes<\/strong><\/a> parameter that you can use to fine-tune your joins. Now, you can make matches between the target and join features based on spatial relationship <em>and<\/em> matching attributes.<\/p>\n<p>The <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/add-spatial-join.htm\"><strong>Add Spatial Join<\/strong><\/a> tool also has a new checkbox parameter that you can use to join fields to the target dataset permanently.\u00a0 Therefore, there are three ways you can join layers based on spatial relationships:<\/p>\n<ul>\n<li>Use <strong>Spatial Join<\/strong> to create a new output feature class, where the join fields are combined with target features.<\/li>\n<li>Use <strong>Add Spatial Join<\/strong> to create a temporary join to the target layer. This join can be removed.<\/li>\n<li>Use <strong>Add Spatial Join<\/strong> with the new <strong>Permanently Join Fields<\/strong> parameter to permanently transfer join fields to the target feature class.<\/li>\n<\/ul>\n<h2>Example: Join Motorcycle Crashes to Road Lines<\/h2>\n<p>Suppose you are a GIS analyst for your local <a href=\"https:\/\/connecticut-ctdot.opendata.arcgis.com\/search?collection=Dataset\">transportation department<\/a>. You are given two feature classes: the road centerlines and point locations of crashes involving a motorcycle.<\/p>\n<p>Your task is to find the number of motorcycle crashes that occurred on each street.<\/p>\n<p>You can do this by joining based spatial relationship using the <strong>Spatial Join<\/strong> or <strong>Add Spatial Join<\/strong> tools.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2179372,"id":2179372,"title":"motorcycle_crash_BEFORE","filename":"motorcycle_crash_BEFORE-1-e1701454248787.png","filesize":2312093,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_BEFORE-1-e1701454248787.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2\/motorcycle_crash_before-2","alt":"Motorcycle crashes and roads","author":"314022","description":"","caption":"Map of the point locations of motorcycle crashes and road lines.","name":"motorcycle_crash_before-2","status":"inherit","uploaded_to":2178492,"date":"2023-11-30 20:19:43","modified":"2023-11-30 20:20:53","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":700,"height":700,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_BEFORE-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_BEFORE-1-e1701454248787.png","medium-width":261,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_BEFORE-1-e1701454248787.png","medium_large-width":700,"medium_large-height":700,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_BEFORE-1-e1701454248787.png","large-width":700,"large-height":700,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_BEFORE-1-1536x1536.png","1536x1536-width":1536,"1536x1536-height":1536,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_BEFORE-1-2048x2048.png","2048x2048-width":2048,"2048x2048-height":2048,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_BEFORE-1-465x465.png","card_image-width":465,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_BEFORE-1-1080x1080.png","wide_image-width":1080,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h3>Use Add Spatial Join to update the existing dataset<\/h3>\n<p>Let\u2019s use the <strong>Add Spatial Join<\/strong> tool with the new, <strong>Permanently Join Fields<\/strong> parameter to update the existing <strong>Roads<\/strong> dataset with the crash count.<\/p>\n<p>(1)\u00a0 Right-click the <strong>Roads<\/strong> layer on the <strong>C<\/strong><strong>ontents<\/strong> pane&gt; click <strong>Joins and Relates<\/strong>&gt; then click\u00a0 <img decoding=\"async\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/TableSpatialJoin16.png\" alt=\"Add Spatial Join\" \/> \u00a0<strong>Add Spatial Join<\/strong>. This will set the <strong>Target Features<\/strong> to the <strong>Roads<\/strong> layer.<br \/>\nThe target feature will receive attributes from the join features.<\/p>\n<p>(2)\u00a0 Set the <strong>Join Features<\/strong> to the <strong>Motorcycle_Crashes<\/strong> layer.<br \/>\nThe join features are those that the attributes will transfer from<em>.<\/em><\/p>\n<p>(3)\u00a0 Set the <strong>Match Option<\/strong> to <strong>Within a distance<\/strong>.<em><br \/>\n<\/em>This determiens the spatial relationship between the target and join features.<\/p>\n<p>(4) New in <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/get-started\/whats-new-in-arcgis-pro.htm\"><strong>ArcGIS Pro 3.2<\/strong><\/a>, use the <strong>Permanently Join Fields<\/strong> checkbox to create a permanent join without needing to export to a new Feature class.<br \/>\n<strong>Note:<\/strong> By checking this parameter you will not be able to remove the join.<\/p>\n<p>(5)\u00a0 Set the <strong>Search Radius<\/strong> to <code>30<\/code> <strong>US Survey Feet<\/strong>.<br \/>\nThis will ensure the attributes from the crash points are mapped to all roads within 30 feet.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2178522,"id":2178522,"title":"addspatialjoin_steps1","filename":"addspatialjoin_steps1.png","filesize":27468,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoin_steps1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2\/addspatialjoin_steps1","alt":"Add Spatial Join","author":"314022","description":"","caption":"Add Spatial Join tool with steps","name":"addspatialjoin_steps1","status":"inherit","uploaded_to":2178492,"date":"2023-11-30 14:55:12","modified":"2023-11-30 14:55:35","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":358,"height":293,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoin_steps1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoin_steps1.png","medium-width":319,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoin_steps1.png","medium_large-width":358,"medium_large-height":293,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoin_steps1.png","large-width":358,"large-height":293,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoin_steps1.png","1536x1536-width":358,"1536x1536-height":293,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoin_steps1.png","2048x2048-width":358,"2048x2048-height":293,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoin_steps1.png","card_image-width":358,"card_image-height":293,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoin_steps1.png","wide_image-width":358,"wide_image-height":293}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>But what happens when a crash point is within 30 feet of more than one street? For example, at an intersection you may end up joining a crash point to multiple street lines within the search distance, resulting in double counting.<\/p>\n<h3>Use Matching Fields to join based on matching attributes<\/h3>\n<p>That\u2019s why, in <strong>ArcGIS Pro 3.2<\/strong>, the <strong>Spatial<\/strong> <strong>Join<\/strong> and <strong>Add<\/strong> <strong>Spatial<\/strong> <strong>Join<\/strong> tools include a new <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/analysis\/spatial-join.htm#:~:text=The%20Matching%20Attributes%20parameter%20filters,addition%20to%20their%20spatial%20relationship.\"><strong>Matching Attributes<\/strong><\/a> parameter to ensure that target features and join features are only joined when they have matching field values. Therefore, if a matching field value is not the same, those join features will be excluded from the spatial join.<\/p>\n<p>(6)\u00a0 Set the <strong>Matching Fields<\/strong> to the <em>Name of Road<\/em> and <em>Street Name<\/em> fields for the <strong>Join Fields<\/strong> and <strong>Target Fields<\/strong>.<br \/>\nHaving set this parameter, the join will be made only if the crash point is within 30 feet of the street <em>and<\/em> has a matching street name.<\/p>\n<p>(7)\u00a0 Click <strong>OK <\/strong>to run the tool.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2180982,"id":2180982,"title":"addspatialjoin_steps2_2","filename":"addspatialjoin_steps2_2.png","filesize":15746,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/addspatialjoin_steps2_2.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2\/addspatialjoin_steps2_2","alt":"New Matching Attributes parameter","author":"314022","description":"","caption":"New Matching Attributes parameter","name":"addspatialjoin_steps2_2","status":"inherit","uploaded_to":2178492,"date":"2023-12-01 18:28:54","modified":"2023-12-01 18:29:23","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":358,"height":196,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/addspatialjoin_steps2_2-213x196.png","thumbnail-width":213,"thumbnail-height":196,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/addspatialjoin_steps2_2.png","medium-width":358,"medium-height":196,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/addspatialjoin_steps2_2.png","medium_large-width":358,"medium_large-height":196,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/addspatialjoin_steps2_2.png","large-width":358,"large-height":196,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/addspatialjoin_steps2_2.png","1536x1536-width":358,"1536x1536-height":196,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/addspatialjoin_steps2_2.png","2048x2048-width":358,"2048x2048-height":196,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/addspatialjoin_steps2_2.png","card_image-width":358,"card_image-height":196,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/addspatialjoin_steps2_2.png","wide_image-width":358,"wide_image-height":196}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Open the attribute table of the modified <strong>Roads<\/strong> dataset.<\/p>\n<p>By comparing values in the <em>Street Name<\/em> and <em>Name of Road<\/em> fields (highlighted in the image below), we can verify each crash was joined to the correct street line.\u00a0A <em>Join_Count<\/em> greater than 0 indicates a road has experienced one or multiple motorcycle crashes. A <em>Join_Count<\/em> = 0 will have NULL values for the crash data, meaning there were no recorded crashes on those streets.<\/p>\n<p><strong>Note:<\/strong> the roads with more than one crash should have multiple <em>CrashID<\/em> and <em>CrashDate<\/em> values, but only one is listed because no action was set via the <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/help\/analysis\/geoprocessing\/basics\/field-map.htm\">field map<\/a>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2179472,"id":2179472,"title":"addspatialjoinAttributetable","filename":"addspatialjoinAttributetable-2-e1701454404955.png","filesize":62970,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoinAttributetable-2-e1701454404955.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2\/addspatialjoinattributetable-3","alt":"Updated attribute table","author":"314022","description":"","caption":"Updated attribute table","name":"addspatialjoinattributetable-3","status":"inherit","uploaded_to":2178492,"date":"2023-11-30 21:20:30","modified":"2023-11-30 21:20:57","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":700,"height":252,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoinAttributetable-2-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoinAttributetable-2-e1701454404955.png","medium-width":464,"medium-height":167,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoinAttributetable-2-e1701454404955.png","medium_large-width":700,"medium_large-height":252,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoinAttributetable-2-e1701454404955.png","large-width":700,"large-height":252,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoinAttributetable-2-e1701454404955.png","1536x1536-width":700,"1536x1536-height":252,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoinAttributetable-2-e1701454404955.png","2048x2048-width":700,"2048x2048-height":252,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoinAttributetable-2-e1701454404955.png","card_image-width":700,"card_image-height":252,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addspatialjoinAttributetable-2-e1701454404955.png","wide_image-width":700,"wide_image-height":252}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Using the <em>Join_Count<\/em> field, let\u2019s create a map of streets with the most motorcycle crashes.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2178662,"id":2178662,"title":"motorcycle_crash_2","filename":"motorcycle_crash_2-e1701454223625.png","filesize":1232835,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_2-e1701454223625.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2\/motorcycle_crash_2","alt":"Count of motorcycle crashes per road","author":"314022","description":"","caption":"Count of motorcycle crashes per road","name":"motorcycle_crash_2","status":"inherit","uploaded_to":2178492,"date":"2023-11-30 15:28:31","modified":"2023-11-30 15:28:56","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":700,"height":700,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_2-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_2-e1701454223625.png","medium-width":261,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_2-e1701454223625.png","medium_large-width":700,"medium_large-height":700,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_2-e1701454223625.png","large-width":700,"large-height":700,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_2-1536x1536.png","1536x1536-width":1536,"1536x1536-height":1536,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_2-2048x2048.png","2048x2048-width":2048,"2048x2048-height":2048,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_2-465x465.png","card_image-width":465,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/motorcycle_crash_2-1080x1080.png","wide_image-width":1080,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h1><strong>Add Join and Join Field<\/strong><\/h1>\n<p>The <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/add-join.htm\"><strong>Add Join<\/strong><\/a> and <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/join-field.htm\"><strong>Join Field<\/strong><\/a> tools have a new parameter for managing join field indexes. <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/3.0\/help\/data\/geodatabases\/overview\/attribute-indexes-in-the-geodatabase.htm\">Attribute indexes<\/a> are a way to increase performance when running operations like joins. You can use the new parameters to rebuild the join field indexes if you get unexpected join results (often due to corrupt or broken indexes).<\/p>\n<p>The <strong>Add Join<\/strong> tool also has new messaging that will let you know when you have a <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/help\/mapping\/layer-properties\/definition-query.htm\">definition query<\/a> on the <strong>Join Table<\/strong>, and that the definition query will transfer to the input layer after you make the join.<\/p>\n<h2>Example: Join a construction projects table to bridge points<\/h2>\n<p>Next, you are given a bridges feature class, and a table of all ongoing bridge construction projects with no geometry.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2179202,"id":2179202,"title":"bridges","filename":"bridges-e1701454314257.png","filesize":1233029,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/bridges-e1701454314257.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2\/bridges-2","alt":"Point Locations of Bridges","author":"314022","description":"","caption":"Point Locations of Bridges","name":"bridges-2","status":"inherit","uploaded_to":2178492,"date":"2023-11-30 19:23:18","modified":"2023-11-30 19:23:35","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":700,"height":700,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/bridges-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/bridges-e1701454314257.png","medium-width":261,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/bridges-e1701454314257.png","medium_large-width":700,"medium_large-height":700,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/bridges-e1701454314257.png","large-width":700,"large-height":700,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/bridges-1536x1536.png","1536x1536-width":1536,"1536x1536-height":1536,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/bridges-2048x2048.png","2048x2048-width":2048,"2048x2048-height":2048,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/bridges-465x465.png","card_image-width":465,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/bridges-1080x1080.png","wide_image-width":1080,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>The <strong>Bridge Construction Projects<\/strong> table includes fields for the <em>Bridge Number<\/em>, <em>Project Number<\/em>, <em>Project title<\/em> and <em>Current Project Phase. <\/em>There are 5 project phases: 01_Planning, 02_Pre-Design, 03_Final-Design, 04_Contract-Processing, and 05_Construction.<\/p>\n<div>\n<table style=\"width: 88%;margin-left: 6%;margin-right: 6%\">\n<tbody>\n<tr>\n<th style=\"background-color: #666666;color: #ffffff;text-align: center;padding: 3px 6px\">OBJECTID<\/th>\n<th style=\"background-color: #666666;color: #ffffff;text-align: center;padding: 1px 6px\">Bridge Number<\/th>\n<th style=\"background-color: #666666;color: #ffffff;text-align: center;padding: 1px 6px\">Project Number<\/th>\n<th style=\"background-color: #666666;color: #ffffff;text-align: center;padding: 3px 6px\">Project title<\/th>\n<th style=\"background-color: #666666;color: #ffffff;text-align: center;padding: 3px 6px\">Current Project Phase<\/th>\n<\/tr>\n<tr>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">1<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">00001<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">0056-0316<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">I-95 Pavement Rehabilitation<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">04_Contract-Processing<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">2<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">00001<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">0056-0317<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">Greenwich: Rehab BR #00001<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">01_Planning<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">3<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">00001<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">0170-5031<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">I-95 Bridges Concrete Sealing<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">05_Construction<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">4<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">00002<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">0056-0316<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">I-95 Pavement Rehabilitation<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">04_Contract-Processing<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">5<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">00002<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">0170-5031<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">I-95 Bridges Concrete Sealing<\/td>\n<td style=\"background-color: #eeeeee;text-align: left;padding: 6px 6px\">05_Construction<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: center\"><sub>Preview of the Bridge Construction Projects table<\/sub><\/p>\n<\/div>\n<p>Your task is to join the <strong>Bridge Construction Projects<\/strong> table to the <strong>Bridges<\/strong> layer to identify the projects that are currently in a design phase of development.<\/p>\n<h3>Create a Definition Query<\/h3>\n<p>Start with applying a <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/help\/mapping\/layer-properties\/definition-query.htm\">Definition Query<\/a> to the table view to find all values where the <strong>Current Project Phase<\/strong> <em>includes the values<\/em> 02_Pre-Design or 03_Final-Design<b>.<\/b><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2180942,"id":2180942,"title":"definition_query_join2","filename":"definition_query_join2.png","filesize":34889,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/definition_query_join2.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2\/definition_query_join2","alt":"Definition Query","author":"314022","description":"","caption":"Definition Query","name":"definition_query_join2","status":"inherit","uploaded_to":2178492,"date":"2023-12-01 18:17:35","modified":"2023-12-01 18:17:57","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":700,"height":395,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/definition_query_join2-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/definition_query_join2.png","medium-width":464,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/definition_query_join2.png","medium_large-width":700,"medium_large-height":395,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/definition_query_join2.png","large-width":700,"large-height":395,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/definition_query_join2.png","1536x1536-width":700,"1536x1536-height":395,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/definition_query_join2.png","2048x2048-width":700,"2048x2048-height":395,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/definition_query_join2.png","card_image-width":700,"card_image-height":395,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/definition_query_join2.png","wide_image-width":700,"wide_image-height":395}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h3>Use Add Join to join based on a common field<\/h3>\n<p>Use the <strong>Add Join<\/strong> tool to join the <strong>Road Resurfacing Projects <\/strong>table to the <strong>Bridges <\/strong>layer.<\/p>\n<p>(1) Right-click the <strong>Bridges<\/strong> feature layer on the\u00a0<strong>C<\/strong><strong>ontents<\/strong>\u00a0pane&gt;click <strong>Joins and Relates<\/strong>&gt; then click\u00a0 <img decoding=\"async\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/TableJoinsAdd16.png\" alt=\"Add Join\" \/>\u00a0 <strong>Add Join<\/strong>. The <strong>Bridges<\/strong> layer will automatically be set into the <strong>Input Table<\/strong> parameter.<\/p>\n<p>(2) Set the <strong>Input Field<\/strong> to the <em>BridgeNumber<\/em>.<\/p>\n<p>(3) Set the <strong>Join Table<\/strong> to the <strong>Bridge_Construction_Projects<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/star_newparameter.png\" alt=\"New\" width=\"32\" height=\"31\" \/><strong>Note:<\/strong> In <strong>ArcGIS Pro 3.2<\/strong>, the <strong>Add Join<\/strong> tool will display a tip to indicate when the specified <strong>Join Table<\/strong> has a definition query, and that the definition query will be applied to the <strong>Input Table<\/strong> (the <strong>Bridges<\/strong> feature layer) after the join is made.<\/p>\n<p><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/add-join.htm#ESRI_USAGE_8F6AC332B7B34A43AEF0206EBFB4639F\">Learn more about how Add Join works with definition queries.<\/a><\/p>\n<p>(4) Set the <strong>Join Field<\/strong> to the <em>BridgeNumber<\/em><\/p>\n<p><em>(5) Check<\/em> <strong>Index join fields<\/strong><\/p>\n<p><em>(6) Check<\/em> <strong>Rebuild joined field indexes<\/strong><\/p>\n<p><strong><strong>Note<\/strong>: <\/strong>this parameter is for extra assurance. Indexes can become out of sync or corrupt when a dataset is repeatedly updated or for other unknown reasons, which can cause unexpected join results. So, if you want to ensure that a join result is correct, use this option to rebuild the indexes.<\/p>\n<p>(7) Click <strong>OK<\/strong> to run the <strong>Add Join<\/strong> tool.<\/p>\n<p>&nbsp;<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2179562,"id":2179562,"title":"addjoin","filename":"addjoin-1.png","filesize":29912,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addjoin-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2\/addjoin-2","alt":"Add Join tool","author":"314022","description":"","caption":"Add Join tool with steps","name":"addjoin-2","status":"inherit","uploaded_to":2178492,"date":"2023-11-30 22:51:33","modified":"2023-11-30 22:52:01","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":356,"height":420,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addjoin-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addjoin-1.png","medium-width":221,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addjoin-1.png","medium_large-width":356,"medium_large-height":420,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addjoin-1.png","large-width":356,"large-height":420,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addjoin-1.png","1536x1536-width":356,"1536x1536-height":420,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addjoin-1.png","2048x2048-width":356,"2048x2048-height":420,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addjoin-1.png","card_image-width":356,"card_image-height":420,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/addjoin-1.png","wide_image-width":356,"wide_image-height":420}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>The construction projects table is now joined to the layer. Therefore, the map will only display bridges with ongoing projects in the design stage because the definition query was transferred from the <strong>Bridge Construction Projects<\/strong> table to the <strong>Bridges<\/strong> layer.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2179342,"id":2179342,"title":"final_join_image","filename":"final_join_image-e1701454344211.png","filesize":780617,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/final_join_image-e1701454344211.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2\/final_join_image","alt":"Updated Bridges layer with joined attributes and a definition query","author":"314022","description":"","caption":"Updated Bridges layer with joined attributes and a definition query","name":"final_join_image","status":"inherit","uploaded_to":2178492,"date":"2023-11-30 20:17:15","modified":"2023-11-30 20:17:37","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":700,"height":700,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/final_join_image-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/final_join_image-e1701454344211.png","medium-width":261,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/final_join_image-e1701454344211.png","medium_large-width":700,"medium_large-height":700,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/final_join_image-e1701454344211.png","large-width":700,"large-height":700,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/final_join_image-1536x1536.png","1536x1536-width":1536,"1536x1536-height":1536,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/final_join_image-2048x2048.png","2048x2048-width":2048,"2048x2048-height":2048,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/final_join_image-465x465.png","card_image-width":465,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/11\/final_join_image-1080x1080.png","wide_image-width":1080,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h1>Summary<\/h1>\n<p>These enhancements were made to the <strong>Add Join<\/strong>, <strong>Join Field<\/strong>, <strong>Spatial Join<\/strong>, and <strong>Add Spatial Join<\/strong> tools to simplify and improve your geoprocessing workflows, and eliminate the need for additional steps or tools. Additionally, several of these updates were made in response to <a href=\"https:\/\/community.esri.com\/t5\/arcgis-ideas-blog\/your-ideas-in-arcgis-pro-3-2\/ba-p\/1346155\">\u00a0feedback from you<\/a>, our <a href=\"https:\/\/community.esri.com\">Esri Community<\/a>!<\/p>\n<p>Have you ever wished that <strong>ArcGIS Pro<\/strong> had a new geoprocessing tool you could use to complete your analysis? Or an existing tool had more functionality to simplify your workflows? You can make enhancement requests for geoprocessing tools in <strong>ArcGIS Pro<\/strong> on the <a href=\"https:\/\/community.esri.com\/t5\/arcgis-pro-ideas\/idb-p\/arcgis-pro-ideas\/label-name\/geoprocessing\">ArcGIS Pro Ideas Community Page using the Geoprocessing label.<\/a><\/p>\n"}],"related_articles":[{"ID":2116652,"post_author":"308712","post_date":"2023-11-07 01:20:36","post_date_gmt":"2023-11-07 09:20:36","post_content":"","post_title":"What's New in ArcGIS Pro 3.2","post_excerpt":"","post_status":"publish","comment_status":"closed","ping_status":"closed","post_password":"","post_name":"whats-new-in-arcgis-pro-3-2","to_ping":"","pinged":"","post_modified":"2024-08-22 08:21:44","post_modified_gmt":"2024-08-22 15:21:44","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=2116652","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\/12\/join_card.png","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/wide_joins.png"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Join tool enhancements in ArcGIS Pro 3.2 | ArcGIS Blog<\/title>\n<meta name=\"description\" content=\"Check out this blog to learn how to use the new parameters in the Spatial Join, Add Spatial Join, Add Join, and Join Field tools in ArcGIS Pro\" \/>\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\/join-enhancements-pro-3-2\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Join Enhancements in ArcGIS Pro 3.2\" \/>\n<meta property=\"og:description\" content=\"Check out this blog to learn how to use the new parameters in the Spatial Join, Add Spatial Join, Add Join, and Join Field tools in ArcGIS Pro\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2\" \/>\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-12-06T14:42:46+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\/join-enhancements-pro-3-2#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2\"},\"author\":{\"name\":\"Margaret Crawford\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/6e92f41055bccb65bf59c3eaccebea25\"},\"headline\":\"Join Enhancements in ArcGIS Pro 3.2\",\"datePublished\":\"2023-12-04T15:46:26+00:00\",\"dateModified\":\"2023-12-06T14:42:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2\"},\"wordCount\":5,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"ArcGIS\",\"geoprocessing\",\"geoprocessing tool\",\"New Release\",\"spatial join\"],\"articleSection\":[\"Analytics\",\"Announcements\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2\",\"name\":\"Join tool enhancements in ArcGIS Pro 3.2 | ArcGIS Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2023-12-04T15:46:26+00:00\",\"dateModified\":\"2023-12-06T14:42:46+00:00\",\"description\":\"Check out this blog to learn how to use the new parameters in the Spatial Join, Add Spatial Join, Add Join, and Join Field tools in ArcGIS Pro\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Join Enhancements in ArcGIS Pro 3.2\"}]},{\"@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":"Join tool enhancements in ArcGIS Pro 3.2 | ArcGIS Blog","description":"Check out this blog to learn how to use the new parameters in the Spatial Join, Add Spatial Join, Add Join, and Join Field tools in ArcGIS Pro","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\/join-enhancements-pro-3-2","og_locale":"en_US","og_type":"article","og_title":"Join Enhancements in ArcGIS Pro 3.2","og_description":"Check out this blog to learn how to use the new parameters in the Spatial Join, Add Spatial Join, Add Join, and Join Field tools in ArcGIS Pro","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2023-12-06T14:42:46+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\/join-enhancements-pro-3-2#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2"},"author":{"name":"Margaret Crawford","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/6e92f41055bccb65bf59c3eaccebea25"},"headline":"Join Enhancements in ArcGIS Pro 3.2","datePublished":"2023-12-04T15:46:26+00:00","dateModified":"2023-12-06T14:42:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2"},"wordCount":5,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["ArcGIS","geoprocessing","geoprocessing tool","New Release","spatial join"],"articleSection":["Analytics","Announcements"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2","name":"Join tool enhancements in ArcGIS Pro 3.2 | ArcGIS Blog","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2023-12-04T15:46:26+00:00","dateModified":"2023-12-06T14:42:46+00:00","description":"Check out this blog to learn how to use the new parameters in the Spatial Join, Add Spatial Join, Add Join, and Join Field tools in ArcGIS Pro","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/join-enhancements-pro-3-2#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Join Enhancements in ArcGIS Pro 3.2"}]},{"@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":"December 4, 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\/12\/wide_joins.png","primary_product":"ArcGIS Pro","tag_data":[{"term_id":25891,"name":"ArcGIS","slug":"arcgis","term_group":0,"term_taxonomy_id":25891,"taxonomy":"post_tag","description":"","parent":0,"count":207,"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":26161,"name":"New Release","slug":"new-release","term_group":0,"term_taxonomy_id":26161,"taxonomy":"post_tag","description":"","parent":0,"count":21,"filter":"raw"},{"term_id":70121,"name":"spatial join","slug":"spatial-join","term_group":0,"term_taxonomy_id":70121,"taxonomy":"post_tag","description":"","parent":0,"count":5,"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"}],"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\/2178492","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=2178492"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2178492\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=2178492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=2178492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=2178492"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=2178492"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=2178492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}