{"id":2625572,"date":"2024-12-17T07:05:45","date_gmt":"2024-12-17T15:05:45","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=2625572"},"modified":"2025-07-10T15:39:52","modified_gmt":"2025-07-10T22:39:52","slug":"summary-statistics-dbms-arcgis-pro","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro","title":{"rendered":"Unwrap ArcGIS Pro Summary Statistics Enhancements this Holiday Season (Dec 2024)"},"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],"tags":[776862,773052,555642,765582],"industry":[],"product":[36561],"class_list":["post-2625572","blog","type-blog","status-publish","format-standard","hentry","category-analytics","category-announcements","tag-arcgis-pro-3-4","tag-geoprocessing-tools","tag-schedule","tag-scheduling","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.4, the Summary Statistics tool has more statistic options and faster performance for data from remote databases. \r\n6 MIN READ","flexible_content":[{"acf_fc_layout":"content","content":"

Approximate Reading time: <\/strong>6 minutes<\/p>\n

ArcGIS Pro Release: <\/strong>3.4<\/p>\n

One of the most commonly used tools in ArcGIS Pro is Summary Statistics<\/strong><\/a><\/span>. It calculates the statistics (sum, mean, etc.) of attribute fields from an input dataset, and creates an output table with the summarized values. And you can group those statistics based on unique values from a specified Case Field<\/strong>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2625672,"id":2625672,"title":"sum_stats_too_illustration","filename":"sum_stats_too_illustration.png","filesize":18668,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/sum_stats_too_illustration.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\/sum_stats_too_illustration","alt":"Tool illustration","author":"314022","description":"","caption":"The Summary Statistics tool illustration","name":"sum_stats_too_illustration","status":"inherit","uploaded_to":2625572,"date":"2024-12-13 22:46:08","modified":"2024-12-13 22:46: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":735,"height":293,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/sum_stats_too_illustration-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/sum_stats_too_illustration.png","medium-width":464,"medium-height":185,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/sum_stats_too_illustration.png","medium_large-width":735,"medium_large-height":293,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/sum_stats_too_illustration.png","large-width":735,"large-height":293,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/sum_stats_too_illustration.png","1536x1536-width":735,"1536x1536-height":293,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/sum_stats_too_illustration.png","2048x2048-width":735,"2048x2048-height":293,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/sum_stats_too_illustration.png","card_image-width":735,"card_image-height":293,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/sum_stats_too_illustration.png","wide_image-width":735,"wide_image-height":293}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Summary Statistics Updates in Pro 3.4<\/h1>\n

As an early gift from us to you, the Summary Statistics<\/strong> tool just got a little better and a lot faster with two enhancements:<\/p>\n

    \n
  1. Mode<\/strong>\u2013This new statistic can be selected to calculate the most common value in a field.
    \nNote:<\/strong> The     Unsplit Line<\/strong><\/a><\/span>, Dissolve<\/strong><\/a><\/span>, and Pairwise Dissolve<\/strong><\/a><\/span> tools were also updated with the mode statistic in Pro 3.4.<\/li>\n
  2. DBMS statistic types<\/strong>\u2013Use a DBMS statistic type for faster calculations when summarizing data from remote databases.<\/li>\n<\/ol>\n

    What is a DBMS Statistic?<\/h1>\n

    A Database Management System<\/strong>, or DBMS<\/strong>, in ArcGIS Pro is an umbrella term for the systems used to store, manage, and retrieve spatial and nonspatial data from a database.<\/p>\n

    Learn more about supported databases in ArcGIS Pro<\/a><\/span>.<\/p>\n

    Traditionally, when you run a geoprocessing tool with input data stored in an enterprise geodatabase or feature service, all the dataset records must be sent from the database to the computer running Pro. This is called client-side processing, and it can be time-consuming depending on the data’s size and the network speed.<\/p>\n

    In recent versions of Pro, several geoprocessing tools like Calculate Field<\/strong>, Select Layer By Attribute<\/strong>, and others were enhanced to use DBMS computations when the input is stored in a database. Now in Pro 3.4, the Summary Statistics<\/strong> tool has been similarly enhanced. By choosing a DBMS Statistic Type<\/strong> your summarizations will be processed directly in the database, saving you time since no data transfer is required.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2626162,"id":2626162,"title":"dbms_vs_client_side_02","filename":"dbms_vs_client_side_02.png","filesize":89024,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/dbms_vs_client_side_02.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\/dbms_vs_client_side_02","alt":"Client-Side vs DBMS Statistics","author":"314022","description":"","caption":"Client-Side vs DBMS Statistics","name":"dbms_vs_client_side_02","status":"inherit","uploaded_to":2625572,"date":"2024-12-14 01:15:40","modified":"2024-12-14 01:15:51","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":480,"height":355,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/dbms_vs_client_side_02-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/dbms_vs_client_side_02.png","medium-width":353,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/dbms_vs_client_side_02.png","medium_large-width":480,"medium_large-height":355,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/dbms_vs_client_side_02.png","large-width":480,"large-height":355,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/dbms_vs_client_side_02.png","1536x1536-width":480,"1536x1536-height":355,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/dbms_vs_client_side_02.png","2048x2048-width":480,"2048x2048-height":355,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/dbms_vs_client_side_02.png","card_image-width":480,"card_image-height":355,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/dbms_vs_client_side_02.png","wide_image-width":480,"wide_image-height":355}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

    Note<\/strong>: Because these new calculations are done using database queries, the results may be slightly different due to differences in the database provider.<\/p>\n

    Use DBMS Statistics for Faster Performance<\/h1>\n

    To compare the performance between the DBMS and the client-side statistics, let\u2019s find the maximum recorded earthquake magnitude since 1900.<\/p>\n

    The Earthquakes Archive<\/a><\/span> from the ArcGIS Living Atlas <\/strong>contains all earthquakes with a magnitude over 4.0 from 1900 to the present day. This dataset is updated once a day and has nearly half a million records (accessed Nov. 11, 2024).<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2625872,"id":2625872,"title":"earthquake_map","filename":"earthquake_map.png","filesize":477697,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/earthquake_map.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\/earthquake_map","alt":"Earthquake Archive","author":"314022","description":"","caption":"Earthquake Archive from the Living Atlas","name":"earthquake_map","status":"inherit","uploaded_to":2625572,"date":"2024-12-14 00:53:37","modified":"2024-12-14 00:53:55","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":750,"height":530,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/earthquake_map-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/earthquake_map.png","medium-width":369,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/earthquake_map.png","medium_large-width":750,"medium_large-height":530,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/earthquake_map.png","large-width":750,"large-height":530,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/earthquake_map.png","1536x1536-width":750,"1536x1536-height":530,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/earthquake_map.png","2048x2048-width":750,"2048x2048-height":530,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/earthquake_map-658x465.png","card_image-width":658,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/earthquake_map.png","wide_image-width":750,"wide_image-height":530}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

    On the Geoprocessing<\/strong> pane, open the Summary Statistics<\/strong><\/a><\/span> tool and set the following parameters:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2625902,"id":2625902,"title":"Sum_stats_tool_01","filename":"Sum_stats_tool_01.png","filesize":24017,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_01.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\/sum_stats_tool_01","alt":"The Summary Statistics tool with steps","author":"314022","description":"","caption":"The Summary Statistics tool with steps","name":"sum_stats_tool_01","status":"inherit","uploaded_to":2625572,"date":"2024-12-14 00:58:01","modified":"2024-12-14 00:58:11","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":372,"height":382,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_01-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_01.png","medium-width":254,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_01.png","medium_large-width":372,"medium_large-height":382,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_01.png","large-width":372,"large-height":382,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_01.png","1536x1536-width":372,"1536x1536-height":382,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_01.png","2048x2048-width":372,"2048x2048-height":382,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_01.png","card_image-width":372,"card_image-height":382,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_01.png","wide_image-width":372,"wide_image-height":382}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

      \n
    1. Input Table:<\/strong> https:\/\/services9.arcgis.com\/RHVPKKiFTONKtxq3\/arcgis\/rest\/services\/Historical_Quakes\/FeatureServer\/0<\/code><\/li>\n
    2. Output Table<\/strong>: specify a name and location<\/em><\/li>\n
    3. Statistics Field: <\/strong>Event Magnitude<\/code>; DBMS Maximum<\/code>
      \nNote<\/strong>: DBMS and client-side statistics cannot<\/em> be processed at the same time. Run the tool multiple times if you need both traditional and DMBS statistics calculated. You can join your results together using       Join Field<\/strong><\/a><\/span>.<\/li>\n
    4. Run<\/strong> the tool.<\/li>\n
    5. Change the Statistic Type<\/strong> to MAX<\/code> and the output table name. Then Run<\/strong> the tool again.<\/li>\n<\/ol>\n

       <\/p>\n

      Notice that the DBMS_MAX<\/code> is over 70 times faster than the client-side Max<\/code>!<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2627592,"id":2627592,"title":"client_vs_dbms","filename":"client_vs_dbms.png","filesize":58002,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/client_vs_dbms.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\/client_vs_dbms","alt":"DBMS_Max statistic (left) VS client-side Max statistic (right)","author":"314022","description":"","caption":"The elapsed time between the DBMS Max statistic (left) and client-side Max statistic (right)","name":"client_vs_dbms","status":"inherit","uploaded_to":2625572,"date":"2024-12-16 17:44:59","modified":"2024-12-16 17:45:34","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":662,"height":609,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/client_vs_dbms-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/client_vs_dbms.png","medium-width":284,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/client_vs_dbms.png","medium_large-width":662,"medium_large-height":609,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/client_vs_dbms.png","large-width":662,"large-height":609,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/client_vs_dbms.png","1536x1536-width":662,"1536x1536-height":609,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/client_vs_dbms.png","2048x2048-width":662,"2048x2048-height":609,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/client_vs_dbms-505x465.png","card_image-width":505,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/client_vs_dbms.png","wide_image-width":662,"wide_image-height":609}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

      Example: Summarize Weather Data using DBMS statistics<\/h1>\n

      As the holidays approach, temperatures drop, and vacations are planned, you may want to keep an eye on the weather reports. Whether you\u2019re hoping for snowfall or wondering if a winter storm will delay your travel plans, weather data is here to keep you in the know!<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2628022,"id":2628022,"title":"drivingthroughsnow_02","filename":"drivingthroughsnow_02.jpg","filesize":83344,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/drivingthroughsnow_02.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\/drivingthroughsnow_02","alt":"","author":"314022","description":"","caption":"Remember to check the weather and road conditions before diving!","name":"drivingthroughsnow_02","status":"inherit","uploaded_to":2625572,"date":"2024-12-16 19:14:27","modified":"2024-12-16 19:14:48","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":750,"height":350,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/drivingthroughsnow_02-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/drivingthroughsnow_02.jpg","medium-width":464,"medium-height":217,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/drivingthroughsnow_02.jpg","medium_large-width":750,"medium_large-height":350,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/drivingthroughsnow_02.jpg","large-width":750,"large-height":350,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/drivingthroughsnow_02.jpg","1536x1536-width":750,"1536x1536-height":350,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/drivingthroughsnow_02.jpg","2048x2048-width":750,"2048x2048-height":350,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/drivingthroughsnow_02.jpg","card_image-width":750,"card_image-height":350,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/drivingthroughsnow_02.jpg","wide_image-width":750,"wide_image-height":350}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

      The ArcGIS Living Atlas<\/strong> has a NOAA weather report dataset<\/a><\/span> with continuously updated storm reports for the past week. The dataset is updated every 15 minutes and is filtered<\/em><\/a><\/span> to display data from the past 24 hours.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2627502,"id":2627502,"title":"weeklyweathermap","filename":"weeklyweathermap.png","filesize":509177,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/weeklyweathermap.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\/weeklyweathermap","alt":"NOAA Weather Reports","author":"314022","description":"","caption":"NOAA Weather Report Map from the Living Atlas","name":"weeklyweathermap","status":"inherit","uploaded_to":2625572,"date":"2024-12-16 17:05:07","modified":"2024-12-16 18:13:55","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":750,"height":480,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/weeklyweathermap-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/weeklyweathermap.png","medium-width":408,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/weeklyweathermap.png","medium_large-width":750,"medium_large-height":480,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/weeklyweathermap.png","large-width":750,"large-height":480,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/weeklyweathermap.png","1536x1536-width":750,"1536x1536-height":480,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/weeklyweathermap.png","2048x2048-width":750,"2048x2048-height":480,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/weeklyweathermap-727x465.png","card_image-width":727,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/weeklyweathermap.png","wide_image-width":750,"wide_image-height":480}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

      Let\u2019s summarize the weather data to find out where<\/em> snow has been reported and get the average magnitude<\/em> of the snow events. And since this dataset is updated every 15 minutes, let\u2019s also schedule<\/a><\/span> the tool to get new results over time.<\/p>\n

      Schedule a geoprocessing tool<\/h2>\n

      In the Summary Statistics<\/strong><\/a><\/span> tool, set the following parameters:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2627392,"id":2627392,"title":"Sum_stats_tool_003","filename":"Sum_stats_tool_003.png","filesize":34063,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_003.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\/sum_stats_tool_003","alt":"The Summary Statistics tool with steps","author":"314022","description":"","caption":"The Summary Statistics tool with steps","name":"sum_stats_tool_003","status":"inherit","uploaded_to":2625572,"date":"2024-12-16 16:49:47","modified":"2024-12-16 16:49:59","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":372,"height":540,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_003-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_003.png","medium-width":180,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_003.png","medium_large-width":372,"medium_large-height":540,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_003.png","large-width":372,"large-height":540,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_003.png","1536x1536-width":372,"1536x1536-height":540,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_003.png","2048x2048-width":372,"2048x2048-height":540,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_003-320x465.png","card_image-width":320,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/Sum_stats_tool_003.png","wide_image-width":372,"wide_image-height":540}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

        \n
      1. Input Table<\/strong>: https:\/\/services9.arcgis.com\/RHVPKKiFTONKtxq3\/arcgis\/rest\/services\/NOAA_storm_reports_v1\/FeatureServer\/4<\/code>
        \nNote:<\/strong> Its recommended to use the full data path<\/em> instead of the layer<\/em> as an input for scheduled processes to ensure the tool runs regardless of the project availability. But this means the filter will not<\/em> be used in the input; so instead, the tool will calculate statistics for the entire week.<\/li>\n
      2. Output Table<\/strong>: Storm_Report_by_State_%t%<\/code>
        \nNote:<\/strong> The         time stamp variable<\/a><\/span>, %t%<\/code>, is added to the output name to create a new output each time the tool runs with the tool run time in the output name.<\/li>\n
      3. Statistic Fields: <\/strong>MAGNITUDE<\/code>; DBMS Mean<\/code><\/li>\n
      4. Case Field<\/strong>: STATE<\/code>; INCIDENT_TYPE<\/code><\/li>\n
      5. Open the Run<\/strong> button split menu and select the Schedule<\/strong> button \"schedule_icon\"\u00a0to open the Schedule<\/strong> dialog box.
        \nNote:<\/strong> You may see a warning<\/strong> \"warning_icon\" next to the schedule button reminding you to         save<\/a><\/span> the project. If you had used a layer<\/em> as an input to the tool, saving the project would be essential because the schedule is referencing the layer through the project file (.aprx). But by using the full data path as an input, we ensured that the schedule could access the dataset directly without relying on its layer connection in the project.<\/li>\n<\/ol>\n

        On the Schedule<\/strong> dialog box, set the following properties:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2627432,"id":2627432,"title":"scheduletooldialogbox","filename":"scheduletooldialogbox.png","filesize":22345,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduletooldialogbox.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\/scheduletooldialogbox","alt":"Schedule dialog box","author":"314022","description":"","caption":"Schedule dialog box","name":"scheduletooldialogbox","status":"inherit","uploaded_to":2625572,"date":"2024-12-16 16:56:54","modified":"2024-12-16 16:57:05","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":510,"height":360,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduletooldialogbox-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduletooldialogbox.png","medium-width":370,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduletooldialogbox.png","medium_large-width":510,"medium_large-height":360,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduletooldialogbox.png","large-width":510,"large-height":360,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduletooldialogbox.png","1536x1536-width":510,"1536x1536-height":360,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduletooldialogbox.png","2048x2048-width":510,"2048x2048-height":360,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduletooldialogbox.png","card_image-width":510,"card_image-height":360,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduletooldialogbox.png","wide_image-width":510,"wide_image-height":360}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

          \n
        1. Task Name<\/strong>: Storm_Report_Statistics<\/code><\/li>\n
        2. \u00a0Recurrence<\/strong>: Weekly<\/code><\/li>\n<\/ol>\n

          This results in a new output table each week with the average magnitude of the weather events that have occurred in each state.<\/p>\n

          The scheduled tool\u2019s output is available in the specified save location.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2627422,"id":2627422,"title":"scheduledtasks","filename":"scheduledtasks.png","filesize":5982,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduledtasks.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\/scheduledtasks","alt":"Output location","author":"314022","description":"","caption":"Scheduled tasks output location","name":"scheduledtasks","status":"inherit","uploaded_to":2625572,"date":"2024-12-16 16:54:17","modified":"2024-12-16 16:54:50","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":337,"height":198,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduledtasks-213x198.png","thumbnail-width":213,"thumbnail-height":198,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduledtasks.png","medium-width":337,"medium-height":198,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduledtasks.png","medium_large-width":337,"medium_large-height":198,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduledtasks.png","large-width":337,"large-height":198,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduledtasks.png","1536x1536-width":337,"1536x1536-height":198,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduledtasks.png","2048x2048-width":337,"2048x2048-height":198,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduledtasks.png","card_image-width":337,"card_image-height":198,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/scheduledtasks.png","wide_image-width":337,"wide_image-height":198}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

          Open the output attribute table to view the average magnitude of the weather events each week.<\/p>\n

          To view only<\/em> the snow events, click the Select by Attributes<\/strong> button \"selectbyattributeicon\" to and set the Expression<\/strong> to INCIDENT_TYPE = 'Snow'<\/code>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2627622,"id":2627622,"title":"attribute_tble_dbmsstat","filename":"attribute_tble_dbmsstat.png","filesize":51348,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/attribute_tble_dbmsstat.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\/attribute_tble_dbmsstat","alt":"Mean snow depth by state.","author":"314022","description":"","caption":"Average snow depth by state.","name":"attribute_tble_dbmsstat","status":"inherit","uploaded_to":2625572,"date":"2024-12-16 17:48:38","modified":"2024-12-16 17:49: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":450,"height":264,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/attribute_tble_dbmsstat-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/attribute_tble_dbmsstat.png","medium-width":445,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/attribute_tble_dbmsstat.png","medium_large-width":450,"medium_large-height":264,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/attribute_tble_dbmsstat.png","large-width":450,"large-height":264,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/attribute_tble_dbmsstat.png","1536x1536-width":450,"1536x1536-height":264,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/attribute_tble_dbmsstat.png","2048x2048-width":450,"2048x2048-height":264,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/attribute_tble_dbmsstat.png","card_image-width":450,"card_image-height":264,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/attribute_tble_dbmsstat.png","wide_image-width":450,"wide_image-height":264}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

          Summary<\/h1>\n

          In ArcGIS Pro 3.4<\/strong>, the Summary Statistics<\/strong><\/a><\/span> tool was updated with several new statistic types including Mode<\/strong> and DBMS<\/strong> statistics for making calculations from remote databases faster. This blog showed how to use DBMS statistics with dynamic data from the ArcGIS Living Atlas,<\/strong> and how to schedule the Summary Statistics<\/strong> tool to get updated results at recurring intervals.<\/p>\n

          To see what else is new in ArcGIS Pro 3.4<\/strong>, please visit the What\u2019s New documentation<\/a><\/span> and post your questions in the ArcGIS Pro board<\/a><\/span> in the Esri Community.<\/p>\n

          Have a happy holidays!!<\/strong><\/p>\n"}],"related_articles":[{"ID":2608682,"post_author":"314022","post_date":"2024-12-09 06:20:28","post_date_gmt":"2024-12-09 14:20:28","post_content":"","post_title":"Build Better Custom Geoprocessing tools (now with Enable Undo) in ArcGIS Pro!","post_excerpt":"","post_status":"publish","comment_status":"closed","ping_status":"closed","post_password":"","post_name":"build-custom-tools-in-arcgispro","to_ping":"","pinged":"","post_modified":"2026-01-12 13:50:15","post_modified_gmt":"2026-01-12 21:50:15","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=2608682","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"}],"show_article_image":false,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/12\/card_image_sumstats.jpg","wide_image":false},"yoast_head":"\nFaster Summary Statistics in ArcGIS Pro using DBMS | ArcGIS Blog<\/title>\n<meta name=\"description\" content=\"In ArcGIS Pro 3.4, the Summary Statistics tool includes DBMS Statistics for faster performance for data from remote databases.\" \/>\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\/summary-statistics-dbms-arcgis-pro\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Unwrap ArcGIS Pro Summary Statistics Enhancements this Holiday Season (Dec 2024)\" \/>\n<meta property=\"og:description\" content=\"In ArcGIS Pro 3.4, the Summary Statistics tool includes DBMS Statistics for faster performance for data from remote databases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\" \/>\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=\"2025-07-10T22:39:52+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ESRI\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"8 minutes\" \/>\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\/summary-statistics-dbms-arcgis-pro#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\"},\"author\":{\"name\":\"Margaret Crawford\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/6e92f41055bccb65bf59c3eaccebea25\"},\"headline\":\"Unwrap ArcGIS Pro Summary Statistics Enhancements this Holiday Season (Dec 2024)\",\"datePublished\":\"2024-12-17T15:05:45+00:00\",\"dateModified\":\"2025-07-10T22:39:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\"},\"wordCount\":10,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"ArcGIS Pro 3.4\",\"geoprocessing tools\",\"schedule\",\"Scheduling\"],\"articleSection\":[\"Analytics\",\"Announcements\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\",\"name\":\"Faster Summary Statistics in ArcGIS Pro using DBMS | ArcGIS Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2024-12-17T15:05:45+00:00\",\"dateModified\":\"2025-07-10T22:39:52+00:00\",\"description\":\"In ArcGIS Pro 3.4, the Summary Statistics tool includes DBMS Statistics for faster performance for data from remote databases.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Unwrap ArcGIS Pro Summary Statistics Enhancements this Holiday Season (Dec 2024)\"}]},{\"@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":"Faster Summary Statistics in ArcGIS Pro using DBMS | ArcGIS Blog","description":"In ArcGIS Pro 3.4, the Summary Statistics tool includes DBMS Statistics for faster performance for data from remote databases.","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\/summary-statistics-dbms-arcgis-pro","og_locale":"en_US","og_type":"article","og_title":"Unwrap ArcGIS Pro Summary Statistics Enhancements this Holiday Season (Dec 2024)","og_description":"In ArcGIS Pro 3.4, the Summary Statistics tool includes DBMS Statistics for faster performance for data from remote databases.","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2025-07-10T22:39:52+00:00","twitter_card":"summary_large_image","twitter_site":"@ESRI","twitter_misc":{"Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro"},"author":{"name":"Margaret Crawford","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/6e92f41055bccb65bf59c3eaccebea25"},"headline":"Unwrap ArcGIS Pro Summary Statistics Enhancements this Holiday Season (Dec 2024)","datePublished":"2024-12-17T15:05:45+00:00","dateModified":"2025-07-10T22:39:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro"},"wordCount":10,"commentCount":2,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["ArcGIS Pro 3.4","geoprocessing tools","schedule","Scheduling"],"articleSection":["Analytics","Announcements"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro","name":"Faster Summary Statistics in ArcGIS Pro using DBMS | ArcGIS Blog","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2024-12-17T15:05:45+00:00","dateModified":"2025-07-10T22:39:52+00:00","description":"In ArcGIS Pro 3.4, the Summary Statistics tool includes DBMS Statistics for faster performance for data from remote databases.","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/summary-statistics-dbms-arcgis-pro#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Unwrap ArcGIS Pro Summary Statistics Enhancements this Holiday Season (Dec 2024)"}]},{"@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 17, 2024","author_name":"Margaret Crawford","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/mcrawford","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/08\/Newsroom-Keyart-Wide-1920-x-1080.jpg","primary_product":"ArcGIS Pro","tag_data":[{"term_id":776862,"name":"ArcGIS Pro 3.4","slug":"arcgis-pro-3-4","term_group":0,"term_taxonomy_id":776862,"taxonomy":"post_tag","description":"","parent":0,"count":17,"filter":"raw"},{"term_id":773052,"name":"geoprocessing tools","slug":"geoprocessing-tools","term_group":0,"term_taxonomy_id":773052,"taxonomy":"post_tag","description":"","parent":0,"count":12,"filter":"raw"},{"term_id":555642,"name":"schedule","slug":"schedule","term_group":0,"term_taxonomy_id":555642,"taxonomy":"post_tag","description":"","parent":0,"count":3,"filter":"raw"},{"term_id":765582,"name":"Scheduling","slug":"scheduling","term_group":0,"term_taxonomy_id":765582,"taxonomy":"post_tag","description":"","parent":0,"count":4,"filter":"raw"}],"category_data":[{"term_id":23341,"name":"Analytics","slug":"analytics","term_group":0,"term_taxonomy_id":23341,"taxonomy":"category","description":"","parent":0,"count":1331,"filter":"raw"},{"term_id":37101,"name":"Announcements","slug":"announcements","term_group":0,"term_taxonomy_id":37101,"taxonomy":"category","description":"","parent":0,"count":1974,"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":2042,"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\/2625572","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=2625572"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2625572\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=2625572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=2625572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=2625572"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=2625572"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=2625572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}