{"id":558482,"date":"2019-07-04T17:31:57","date_gmt":"2019-07-05T00:31:57","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=558482"},"modified":"2021-11-07T22:25:26","modified_gmt":"2021-11-08T06:25:26","slug":"dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis","title":{"rendered":"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis"},"author":5971,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[22941],"tags":[30021,86432,35491,419502,145432],"industry":[],"product":[36561],"class_list":["post-558482","blog","type-blog","status-publish","format-standard","hentry","category-mapping","tag-aggregation","tag-crime-analysis","tag-crime-mapping","tag-dynamic","tag-query-layer","product-arcgis-pro"],"acf":{"short_description":"Explore data patterns by aggregating points to geographic or political boundaries for better decision making.","flexible_content":[{"acf_fc_layout":"content","content":"<p>Starting ArcGIS Pro 2.8, authoring this kind of layers is made very easy using Make Aggregation Query Layer. Please read about this in the following blog and ArcGIS Pro help:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/announcements\/make-aggregation-query-layer-a-new-geoprocessing-tool-to-compute-and-view-dynamic-summary-statistics-from-related-records\/\">Make Aggregation Query Layer &#8211; a new geoprocessing tool to compute and view dynamic summary statistics from related records<\/a><\/li>\n<li><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/make-aggregation-query-layer.htm\">https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/make-aggregation-query-layer.htm<\/a><\/li>\n<\/ul>\n<hr \/>\n"},{"acf_fc_layout":"content","content":"<p>Let&#8217;s say you have some point data representing crime data, 311 calls, tornadoes across the nation, sales, or earthquakes around the world, and you want to explore data concentration, patterns, or trends\u2014maybe over time or maybe using different criteria as you&#8217;d do in an exploratory analysis. Simply drawing these points on a map might not help reveal any meaningful information, since most of them will overlap and obscure each other. One approach we could use to reveal meaningful information is to aggregate points within known geometry boundaries such as districts, cities, and counties etc.<\/p>\n<p>We could use some geoprocessing tools to get to the same results, but they are static. If data changes or we want to use different criteria for analysis, we\u2019d need to run those tools again. This makes sharing your geoprocessing results hard too via web.<\/p>\n<p>With the approach described in this blog, we need to setup once and then start interacting with the layer or map properties to make necessary changes and view the results right away on the map.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":558632,"id":558632,"title":"Points2Polygons 826x465","filename":"Points2Polygons-826x465.png","filesize":134444,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/Points2Polygons-826x465.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\/points2polygons-826x465","alt":"Map on the right shows crimes total for each districts by aggregating crime locations shown on the left","author":"5971","description":"","caption":"Map on the right shows crimes total for each districts by aggregating crime locations shown on the left","name":"points2polygons-826x465","status":"inherit","uploaded_to":558482,"date":"2019-07-04 23:04:22","modified":"2019-07-04 23:04:54","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":826,"height":465,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/Points2Polygons-826x465-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/Points2Polygons-826x465.png","medium-width":464,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/Points2Polygons-826x465.png","medium_large-width":768,"medium_large-height":432,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/Points2Polygons-826x465.png","large-width":826,"large-height":465,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/Points2Polygons-826x465.png","1536x1536-width":826,"1536x1536-height":465,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/Points2Polygons-826x465.png","2048x2048-width":826,"2048x2048-height":465,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/Points2Polygons-826x465.png","card_image-width":826,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/Points2Polygons-826x465.png","wide_image-width":826,"wide_image-height":465}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>In this blog, we will work with crime locations and learn how to aggregate them within police district boundaries to help us explore the following:<\/p>\n<ul>\n<li>Spatial patterns<\/li>\n<\/ul>\n<p>We will also learn how to setup the layer to explore pattern based on the following:<\/p>\n<ul>\n<li>Month<\/li>\n<li>Day of the week<\/li>\n<li>Time of the day<\/li>\n<li>Crime type<\/li>\n<\/ul>\n"},{"acf_fc_layout":"content","content":"<h1>Prepare the Data<\/h1>\n<p>Let&#8217;s get started:<\/p>\n<ul>\n<li>Download an <a href=\"https:\/\/arcg.is\/1KXzqq\">ArcGIS Pro package<\/a> to get started with sample data.<\/li>\n<li>Double-click the package file that you downloaded to open in ArcGIS Pro.<\/li>\n<li>The <strong>Crimes<\/strong> map contains (1) a point layer representing crime locations and (2) a polygon layer for police districts.\n<ul>\n<li>The Crime layer has a field, PDDistrict, that will be used to join crime locations to police districts.<\/li>\n<\/ul>\n<\/li>\n<li>Create <a href=\"http:\/\/esriurl.com\/15540\">a new database connection<\/a> to your enterprise database such as SQL Server, Oracle, PostgreSQL or other database supported in ArcGIS Pro.<\/li>\n<li>Go to the Catalog pane and navigate to <strong>Databases\\Crime.gdb<\/strong>.<\/li>\n<li>Copy both feature classes from the file geodatabase to your enterprise database.<\/li>\n<\/ul>\n"},{"acf_fc_layout":"content","content":"<h1>Transform Crime Locations into District Polygons<\/h1>\n<p>You are a geographic information system (GIS) analyst and you are tasked to produce a map for the police chief, showing districts with crime totals. You have a point feature class showing locations of all crimes occurred in the city and a polygon feature class for police districts. We will follow the steps below to create <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/help\/data\/query-layers\/what-is-a-query-layer-.htm\">a query layer<\/a> to produce such map in this section. In the following section, we will add few additional parameters to make the layer produce different results based on different inputs.<\/p>\n<p>Follow the steps below to create the layer:<\/p>\n<ul>\n<li>Click the <strong>Query Layer<\/strong> option from the <strong>Add Data<\/strong> command on the Map tab.<\/li>\n<li>Select your database connection.<\/li>\n<li>Give it a name such as <strong>Crime by Districts<\/strong>.<\/li>\n<li>Copy the following query and paste it in the <strong>Query<\/strong> text box:<br \/>\n<code>SELECT d.*, c.*<br \/>\nFROM POLICEDISTRICTS d<br \/>\nINNER JOIN (<br \/>\nSELECT PdDistrict, COUNT(*) AS total_crime<br \/>\nFROM CRIMES<br \/>\nGROUP BY CRIMES.PdDistrict<br \/>\n) c<br \/>\nON d.district = c.PdDistrict<\/code><\/li>\n<li>Symbolize the layer appropriately. Optionally, you may label district boundaries with the total_crime attribute.<br \/>\nYou will see a map looking something like the one shown above.<\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline\">Note<\/span>: <em>Values in this field get computed dynamically every time you refresh the map. Therefore, when new data are added, results showing on the map gets updated in the next map refresh. You don\u2019t need to modify or recreate the layer.<\/em><\/p>\n"},{"acf_fc_layout":"content","content":"<h1>Find Out if Crimes Happen on Weekends<\/h1>\n<p>The above map made the police chief happy and even district commissioners found the map very helpful. Now the person in charge of crime analysis came in and asked you to help them find out whether there are correlations between crimes that occur on weekdays and those that happen on weekends. Since you chose to create a query layer in the section above, meeting the crime analyst\u2019s needs will be easy. Let\u2019s follow the steps below to create a crime map for different days of week:<\/p>\n<ul>\n<li>Open the <strong>Layer Property<\/strong> page of the query layer created earlier and click its <strong>Source<\/strong><\/li>\n<\/ul>\n<p>Click the blue pencil icon to open the <strong>Edit Query Layer<\/strong> dialog box.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":558682,"id":558682,"title":"SourceTab_CrimesByDistricts","filename":"SourceTab_CrimesByDistricts.png","filesize":14656,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SourceTab_CrimesByDistricts.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\/sourcetab_crimesbydistricts","alt":"","author":"5971","description":"","caption":"Query layer's Source tab showing SQL query","name":"sourcetab_crimesbydistricts","status":"inherit","uploaded_to":558482,"date":"2019-07-04 23:24:25","modified":"2019-07-04 23:24: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":802,"height":521,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SourceTab_CrimesByDistricts-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SourceTab_CrimesByDistricts.png","medium-width":402,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SourceTab_CrimesByDistricts.png","medium_large-width":768,"medium_large-height":499,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SourceTab_CrimesByDistricts.png","large-width":802,"large-height":521,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SourceTab_CrimesByDistricts.png","1536x1536-width":802,"1536x1536-height":521,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SourceTab_CrimesByDistricts.png","2048x2048-width":802,"2048x2048-height":521,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SourceTab_CrimesByDistricts-716x465.png","card_image-width":716,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SourceTab_CrimesByDistricts.png","wide_image-width":802,"wide_image-height":521}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Insert the following WHERE clause with a <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/help\/data\/query-layers\/define-parameters-in-a-query-layer.htm#GUID-CDEF0CD3-6B41-4F8E-B053-E6045D153EDC\">range parameter<\/a> right after the table name CRIMES:<br \/>\nWHERE <strong>::r:DayOfWeekRange<\/strong><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":558692,"id":558692,"title":"SQL_dwRangeParam","filename":"SQL_dwRangeParam.png","filesize":7512,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\/sql_dwrangeparam","alt":"SQL query with a range parameter of integer type","author":"5971","description":"","caption":"SQL query with a range parameter of integer type","name":"sql_dwrangeparam","status":"inherit","uploaded_to":558482,"date":"2019-07-04 23:25:22","modified":"2019-07-04 23:25:47","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":409,"height":220,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam.png","medium-width":409,"medium-height":220,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam.png","medium_large-width":409,"medium_large-height":220,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam.png","large-width":409,"large-height":220,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam.png","1536x1536-width":409,"1536x1536-height":220,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam.png","2048x2048-width":409,"2048x2048-height":220,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam.png","card_image-width":409,"card_image-height":220,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam.png","wide_image-width":409,"wide_image-height":220}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ul>\n<li>Click the pencil icon to bring up an inline editor to define the parameter.<\/li>\n<li>Fill in all the necessary information as shown in the following screenshot.<\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":558702,"id":558702,"title":"SQL_dwRangeParam_inlineEditor","filename":"SQL_dwRangeParam_inlineEditor.png","filesize":14548,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam_inlineEditor.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\/sql_dwrangeparam_inlineeditor","alt":"Defining DayOfWeekRange parameter","author":"5971","description":"","caption":"Defining DayOfWeekRange parameter","name":"sql_dwrangeparam_inlineeditor","status":"inherit","uploaded_to":558482,"date":"2019-07-04 23:26:10","modified":"2019-07-04 23:26:46","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":637,"height":278,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam_inlineEditor-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam_inlineEditor.png","medium-width":464,"medium-height":202,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam_inlineEditor.png","medium_large-width":637,"medium_large-height":278,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam_inlineEditor.png","large-width":637,"large-height":278,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam_inlineEditor.png","1536x1536-width":637,"1536x1536-height":278,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam_inlineEditor.png","2048x2048-width":637,"2048x2048-height":278,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam_inlineEditor.png","card_image-width":637,"card_image-height":278,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_dwRangeParam_inlineEditor.png","wide_image-width":637,"wide_image-height":278}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol>\n<li>Field or Expression\u2014Type &#8220;datepart(dw, datetime_)&#8221;.<br \/>\n<u>Note<\/u>: <em>DatePart() is a SQL Server function that extracts the day of the week from a date value. Other databases have similar functionalities, but their names and syntax may differ. If you want to find crime pattern by hour of the day, use \u201cdatepart(hh, datetime_)\u201d<\/em><\/li>\n<li>Data Type\u2014Choose <strong>Integer<\/strong>.<\/li>\n<li>Default value\u2014Uncheck the check box.<\/li>\n<li>Name of the table the field belongs to\u2014Type &#8220;Crimes&#8221;.<\/li>\n<\/ol>\n<ul>\n<li>Click <strong>Done<\/strong>.<\/li>\n<li>Validate the SQL query layer.<\/li>\n<li>Click <strong>Next<\/strong>.<\/li>\n<li>Click <strong>Finish<\/strong>.<\/li>\n<\/ul>\n<p>If you click the <strong>Range<\/strong> tab on the Layer Properties page now, you will see that the range settings got automatically defined. When you define a range parameter of the integer or double data type, the layer is automatically made range aware and will start honoring the map&#8217;s range slider&#8217;s settings.<\/p>\n<ul>\n<li>Click OK.<\/li>\n<\/ul>\n<p>The range slider appears on the right side of the map.<\/p>\n<ul>\n<li>Enable the range slider from the <strong>Range<\/strong><\/li>\n<\/ul>\n<p>Have <strong>Single Value<\/strong> checked, and <strong>Step Interval<\/strong> set to 1.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":558712,"id":558712,"title":"rangeTab","filename":"rangeTab.png","filesize":14592,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/rangeTab.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\/rangetab","alt":"Settings on the Range tab","author":"5971","description":"","caption":"Settings on the Range tab","name":"rangetab","status":"inherit","uploaded_to":558482,"date":"2019-07-04 23:27:15","modified":"2019-07-04 23:27:32","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":1080,"height":150,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/rangeTab-213x150.png","thumbnail-width":213,"thumbnail-height":150,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/rangeTab.png","medium-width":464,"medium-height":64,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/rangeTab.png","medium_large-width":768,"medium_large-height":107,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/rangeTab.png","large-width":1080,"large-height":150,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/rangeTab.png","1536x1536-width":1080,"1536x1536-height":150,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/rangeTab.png","2048x2048-width":1080,"2048x2048-height":150,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/rangeTab-826x115.png","card_image-width":826,"card_image-height":115,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/rangeTab.png","wide_image-width":1080,"wide_image-height":150}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>On the range slider, you can navigate between different days of the week (where 1 = Sunday and 7 = Saturday). <u>Note<\/u>: <em>This may vary based on database flavor and locale settings, etc<\/em>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":558722,"id":558722,"title":"WeekendCrimes_Animation","filename":"WeekendCrimes_Animation.gif","filesize":52290,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/WeekendCrimes_Animation.gif","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\/weekendcrimes_animation","alt":"Map showing weekend crimes","author":"5971","description":"","caption":"Map showing weekend crimes","name":"weekendcrimes_animation","status":"inherit","uploaded_to":558482,"date":"2019-07-04 23:27:49","modified":"2019-07-04 23:28:03","menu_order":0,"mime_type":"image\/gif","type":"image","subtype":"gif","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":880,"height":584,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/WeekendCrimes_Animation-213x200.gif","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/WeekendCrimes_Animation.gif","medium-width":393,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/WeekendCrimes_Animation.gif","medium_large-width":768,"medium_large-height":510,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/WeekendCrimes_Animation.gif","large-width":880,"large-height":584,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/WeekendCrimes_Animation.gif","1536x1536-width":880,"1536x1536-height":584,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/WeekendCrimes_Animation.gif","2048x2048-width":880,"2048x2048-height":584,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/WeekendCrimes_Animation-701x465.gif","card_image-width":701,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/WeekendCrimes_Animation.gif","wide_image-width":880,"wide_image-height":584}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h1>Visualize Patterns for Specific Crime Types<\/h1>\n<p>The map above made the crime analyst\u2019s job more efficient. They realized the importance of dynamic nature of this map and layer, and came back with a new requirement \u2013 produce the same map but for specific crime type instead of all crimes. Query layers are flexible enough for that too.<\/p>\n<ul>\n<li>Open the <strong>Layer Property<\/strong> page of the query layer again and click its <strong>Source<\/strong><\/li>\n<li>Click the blue pencil icon to open <strong>Edit Query Layer<\/strong> dialog box.<\/li>\n<li>Insert the following <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/help\/data\/query-layers\/define-parameters-in-a-query-layer.htm#ESRI_SECTION1_DA513455E19946BBBC3053C6263054F3\">discrete parameter<\/a> in the WHERE clause:<br \/>\nWHERE <strong>::r:DayOfWeekRange <\/strong>AND (CATEGORY IN <strong>::CategoryVar <\/strong>)<\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":558752,"id":558752,"title":"SQL_discreateParam","filename":"SQL_discreateParam.png","filesize":6717,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreateParam.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\/sql_discreateparam","alt":"Insert a discrete parameter named CategoryVar in the SQL query","author":"5971","description":"","caption":"Insert a discrete parameter named CategoryVar in the SQL query","name":"sql_discreateparam","status":"inherit","uploaded_to":558482,"date":"2019-07-04 23:37:34","modified":"2019-07-04 23:38:07","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":389,"height":164,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreateParam-213x164.png","thumbnail-width":213,"thumbnail-height":164,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreateParam.png","medium-width":389,"medium-height":164,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreateParam.png","medium_large-width":389,"medium_large-height":164,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreateParam.png","large-width":389,"large-height":164,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreateParam.png","1536x1536-width":389,"1536x1536-height":164,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreateParam.png","2048x2048-width":389,"2048x2048-height":164,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreateParam.png","card_image-width":389,"card_image-height":164,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreateParam.png","wide_image-width":389,"wide_image-height":164}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><u>Note<\/u>: <em>Please make sure to have a space between &#8220;::CategoryVar&#8221; and the closing parenthesis, otherwise you will run into a bug<\/em>.<\/p>\n<ul>\n<li>Click the pencil icon to bring up an inline editor to define the parameter.<\/li>\n<li>Fill in all the necessary information as seen in the following screenshot:<\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":558732,"id":558732,"title":"SQL_discreteVar_inlineEditor","filename":"SQL_discreteVar_inlineEditor.png","filesize":15121,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreteVar_inlineEditor.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\/sql_discretevar_inlineeditor","alt":"Defining CategoryVar discrete parameter","author":"5971","description":"","caption":"Defining CategoryVar discrete parameter","name":"sql_discretevar_inlineeditor","status":"inherit","uploaded_to":558482,"date":"2019-07-04 23:28:27","modified":"2019-07-04 23:28:48","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":633,"height":268,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreteVar_inlineEditor-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreteVar_inlineEditor.png","medium-width":464,"medium-height":196,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreteVar_inlineEditor.png","medium_large-width":633,"medium_large-height":268,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreteVar_inlineEditor.png","large-width":633,"large-height":268,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreteVar_inlineEditor.png","1536x1536-width":633,"1536x1536-height":268,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreteVar_inlineEditor.png","2048x2048-width":633,"2048x2048-height":268,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreteVar_inlineEditor.png","card_image-width":633,"card_image-height":268,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_discreteVar_inlineEditor.png","wide_image-width":633,"wide_image-height":268}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ul>\n<li style=\"list-style-type: none\">\n<ol>\n<li>Allow multiple values\u2014Check the check box.<\/li>\n<li>Data Type\u2014Choose <strong>String<\/strong>.<\/li>\n<li>Default value\u2014 copy-paste the following text as it-is in the text box.<br \/>\nDRUG\/NARCOTIC, BRIBERY\/EXTORTION, BURGLARY\/THEFT, WEAPON LAWS, NON-CRIMINAL, FAMILY OFFENSES, DUI\/DRUNKENNESS, SUICIDE, ARSON, VEHICLE THEFT, VANDALISM, DISORDERLY CONDUCT, ASSAULT, GAMBLING, MISSING PERSON\/RUNAWAY, OTHER OFFENSES, FORGERY\/FRAUD, KIDNAPPING, SEX OFFENSES, SEX OFFENSES, FORCIBLE, WARRANTS<\/li>\n<\/ol>\n<\/li>\n<li>Click <strong>Done<\/strong>.<\/li>\n<li>Validate the SQL query layer.<\/li>\n<li>Click <strong>Next<\/strong>.<\/li>\n<li>Click <strong>Finish<\/strong>.<\/li>\n<\/ul>\n<p>Choose <strong>Query Parameters<\/strong> on the <strong>Layer Properties<\/strong> page.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":558762,"id":558762,"title":"QueryParametersTab","filename":"QueryParametersTab.png","filesize":14130,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/QueryParametersTab.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\/queryparameterstab","alt":"Select a crime type from Query Parameters tab","author":"5971","description":"","caption":"Select a crime type from Query Parameters tab","name":"queryparameterstab","status":"inherit","uploaded_to":558482,"date":"2019-07-04 23:38:50","modified":"2019-07-04 23:39: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":802,"height":521,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/QueryParametersTab-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/QueryParametersTab.png","medium-width":402,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/QueryParametersTab.png","medium_large-width":768,"medium_large-height":499,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/QueryParametersTab.png","large-width":802,"large-height":521,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/QueryParametersTab.png","1536x1536-width":802,"1536x1536-height":521,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/QueryParametersTab.png","2048x2048-width":802,"2048x2048-height":521,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/QueryParametersTab-716x465.png","card_image-width":716,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/QueryParametersTab.png","wide_image-width":802,"wide_image-height":521}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ul>\n<li>Check the BURGLARY\/THEFT check box.<\/li>\n<li>Click <strong>OK<\/strong>.<\/li>\n<li>The map will show the burglary\/theft total for each district.<\/li>\n<li>Notice that the range slider is still active and that the layer is actually showing burglary\/theft totals for that specified day of week, selected on the range slider, for each district.<br \/>\nYou can disable the range slider to view results for all days not just for a single day.<\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":558742,"id":558742,"title":"CrimesForOneCrimeTypeForAgivenDayofWeek","filename":"CrimesForOneCrimeTypeForAgivenDayofWeek.png","filesize":42218,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/CrimesForOneCrimeTypeForAgivenDayofWeek.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\/crimesforonecrimetypeforagivendayofweek","alt":"Map showing crime totals for burglary\/theft","author":"5971","description":"","caption":"Map showing crime totals for burglary\/theft","name":"crimesforonecrimetypeforagivendayofweek","status":"inherit","uploaded_to":558482,"date":"2019-07-04 23:30:35","modified":"2019-07-04 23:34: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":902,"height":582,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/CrimesForOneCrimeTypeForAgivenDayofWeek-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/CrimesForOneCrimeTypeForAgivenDayofWeek.png","medium-width":405,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/CrimesForOneCrimeTypeForAgivenDayofWeek.png","medium_large-width":768,"medium_large-height":496,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/CrimesForOneCrimeTypeForAgivenDayofWeek.png","large-width":902,"large-height":582,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/CrimesForOneCrimeTypeForAgivenDayofWeek.png","1536x1536-width":902,"1536x1536-height":582,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/CrimesForOneCrimeTypeForAgivenDayofWeek.png","2048x2048-width":902,"2048x2048-height":582,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/CrimesForOneCrimeTypeForAgivenDayofWeek-721x465.png","card_image-width":721,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/CrimesForOneCrimeTypeForAgivenDayofWeek.png","wide_image-width":902,"wide_image-height":582}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><u>Note<\/u>: <em>since you are using aggregated results for crime of specific type rather than all, the value ranges have changed. You may need to use <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/help\/mapping\/layer-properties\/graduated-colors.htm#ESRI_SECTION1_B0F695C18D904E61905C1C2A1C244B11\">Refresh Values<\/a> on the Symbology pane<\/em>.<\/p>\n"},{"acf_fc_layout":"content","content":"<h1>Use the Time Slider<\/h1>\n<p>Months or may be years went by since you made crime analysis dynamic. It made the police and analysts more efficient and they think crime rate might have been decreasing. Now, you need to make a map to show the total number of crimes by month or year or weeks.<\/p>\n<ul>\n<li>Go back to the layer&#8217;s <strong>Source<\/strong> tab, then click the blue pencil icon to open the <strong>Edit Query<\/strong> dialog box.<\/li>\n<li>Add a new <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/help\/data\/query-layers\/define-parameters-in-a-query-layer.htm#GUID-CDEF0CD3-6B41-4F8E-B053-E6045D153EDC\">range parameter<\/a> of <strong>Date<\/strong> data type as seen in the following screenshot and follow the same steps provided earlier.\n<ol>\n<li>Field or Expression\u2014Type &#8220;DateTime_&#8221;.<\/li>\n<li>Data Type\u2014Choose <strong>Date<\/strong>.<\/li>\n<li>Default value\u2014Uncheck the check box.<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<p>Name of the table the field belongs to\u2014Type &#8220;Crimes&#8221;.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":558792,"id":558792,"title":"SQL_timeRangeParam_inlineEditor","filename":"SQL_timeRangeParam_inlineEditor.png","filesize":15483,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_timeRangeParam_inlineEditor.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\/sql_timerangeparam_inlineeditor","alt":"Defining a range parameter of date type","author":"5971","description":"","caption":"Defining a range parameter of date type","name":"sql_timerangeparam_inlineeditor","status":"inherit","uploaded_to":558482,"date":"2019-07-04 23:47:55","modified":"2019-07-04 23:48:19","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":651,"height":331,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_timeRangeParam_inlineEditor-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_timeRangeParam_inlineEditor.png","medium-width":464,"medium-height":236,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_timeRangeParam_inlineEditor.png","medium_large-width":651,"medium_large-height":331,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_timeRangeParam_inlineEditor.png","large-width":651,"large-height":331,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_timeRangeParam_inlineEditor.png","1536x1536-width":651,"1536x1536-height":331,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_timeRangeParam_inlineEditor.png","2048x2048-width":651,"2048x2048-height":331,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_timeRangeParam_inlineEditor.png","card_image-width":651,"card_image-height":331,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/SQL_timeRangeParam_inlineEditor.png","wide_image-width":651,"wide_image-height":331}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ul>\n<li>This will bring up the <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/help\/mapping\/time\/visualize-temporal-data-using-the-time-slider.htm\">time slider<\/a> on the map view.<\/li>\n<li>If you can choose a month or year or week as the <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/help\/mapping\/time\/configure-time-slider-settings.htm\">Time Span<\/a><\/li>\n<li>Step through the time on the time slider to view districts with dynamically computed result for that time period.<\/li>\n<\/ul>\n<p>You can combine all criteria such as time span, day of week, crime type or use any combination of them to analyze and produce crime map very easily and interactively. And of course, the results are always up-to-dated with the latest crime data.<\/p>\n"},{"acf_fc_layout":"content","content":"<h1>Share Your Result in Web Maps<\/h1>\n<p>You can <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/help\/sharing\/overview\/map-image-layer.htm\">share<\/a> the map as a map image layer (or <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/help\/sharing\/overview\/publish-a-map-service.htm\">map service<\/a>) with some limitations:<\/p>\n<ul>\n<li>When you consume such map services on a web application such as ArcGIS Online or a portal map viewer or a Web AppBuilder for ArcGIS application, you can only use the time slider to make use of date data type range parameters.<\/li>\n<li>To use <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/help\/data\/query-layers\/define-parameters-in-a-query-layer.htm#GUID-CDEF0CD3-6B41-4F8E-B053-E6045D153EDC\">range parameters<\/a> of integer or double data type, or <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/help\/data\/query-layers\/define-parameters-in-a-query-layer.htm#ESRI_SECTION1_DA513455E19946BBBC3053C6263054F3\">discrete parameters<\/a>, you need to develop a custom ArcGIS API for JavaScript application.<\/li>\n<\/ul>\n"}],"authors":[{"ID":5971,"user_firstname":"Tanu","user_lastname":"Hoque","nickname":"Tanu Hoque","user_nicename":"mahoque","display_name":"Tanu Hoque","user_email":"ahoque@esri.com","user_url":"","user_registered":"2018-03-02 00:17:50","user_description":"Tanu is a product engineer on Esri Mapping Team focusing on map service, print service, and ArcGIS Pro. He also works on spatio-temporal analysis, spatial aggregation and real-time data. Tanu\u2019s background includes a masters in Urban Planning from University of Akron, Ohio, USA and a bachelor degree from Khulna University, Bangladesh, and worked as GIS Coordinator in City of West Springfield, and GIS Specialist in a hydrology modeling center in Bangladesh before joining Esri.","user_avatar":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/12\/tanu-hoque2-e1609364913822-213x200.jpeg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"}],"related_articles":[{"ID":556392,"post_author":"5971","post_date":"2019-07-03 00:40:53","post_date_gmt":"2019-07-03 07:40:53","post_content":"","post_title":"Transform Dynamically Aggregated Time Series Results into Polygons in ArcGIS","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"transform-aggregated-time-series-results-into-polygons-in-arcgis","to_ping":"","pinged":"","post_modified":"2020-03-02 15:20:56","post_modified_gmt":"2020-03-02 23:20:56","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=556392","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"2","filter":"raw"},{"ID":554902,"post_author":"5971","post_date":"2019-07-02 00:40:03","post_date_gmt":"2019-07-02 07:40:03","post_content":"","post_title":"Dynamic Spatiotemporal Exploratory Analysis with Aggregated Results Using Time Series Data in ArcGIS","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"dynamic-spatiotemporal-exploratory-analysis-with-aggregated-results-using-time-series-data-in-arcgis","to_ping":"","pinged":"","post_modified":"2021-11-07 22:30:28","post_modified_gmt":"2021-11-08 06:30:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=554902","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"}],"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/Points2Polygons-826x465.png","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/Points2Polygons-1920x1080.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>Dynamic Aggregate Points within Polygon Features for Exploratory Analysis<\/title>\n<meta name=\"description\" content=\"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis\" \/>\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\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis\" \/>\n<meta property=\"og:description\" content=\"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\" \/>\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=\"2021-11-08T06:25:26+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\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\"},\"author\":{\"name\":\"Tanu Hoque\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/9932dde4f8a6dae58fd1b485d1ddf017\"},\"headline\":\"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis\",\"datePublished\":\"2019-07-05T00:31:57+00:00\",\"dateModified\":\"2021-11-08T06:25:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\"},\"wordCount\":9,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"Aggregation\",\"crime analysis\",\"crime mapping\",\"dynamic\",\"query layer\"],\"articleSection\":[\"Mapping\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\",\"name\":\"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2019-07-05T00:31:57+00:00\",\"dateModified\":\"2021-11-08T06:25:26+00:00\",\"description\":\"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis\"}]},{\"@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\/9932dde4f8a6dae58fd1b485d1ddf017\",\"name\":\"Tanu Hoque\",\"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\/2020\/12\/tanu-hoque2-e1609364913822-213x200.jpeg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/12\/tanu-hoque2-e1609364913822-213x200.jpeg\",\"caption\":\"Tanu Hoque\"},\"description\":\"Tanu is a product engineer on Esri Mapping Team focusing on map service, print service, and ArcGIS Pro. He also works on spatio-temporal analysis, spatial aggregation and real-time data. Tanu\u2019s background includes a masters in Urban Planning from University of Akron, Ohio, USA and a bachelor degree from Khulna University, Bangladesh, and worked as GIS Coordinator in City of West Springfield, and GIS Specialist in a hydrology modeling center in Bangladesh before joining Esri.\",\"sameAs\":[\"https:\/\/x.com\/ArcGISPro\"],\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/mahoque\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis","description":"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis","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\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis","og_locale":"en_US","og_type":"article","og_title":"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis","og_description":"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2021-11-08T06:25:26+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\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis"},"author":{"name":"Tanu Hoque","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/9932dde4f8a6dae58fd1b485d1ddf017"},"headline":"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis","datePublished":"2019-07-05T00:31:57+00:00","dateModified":"2021-11-08T06:25:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis"},"wordCount":9,"commentCount":0,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["Aggregation","crime analysis","crime mapping","dynamic","query layer"],"articleSection":["Mapping"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis","name":"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2019-07-05T00:31:57+00:00","dateModified":"2021-11-08T06:25:26+00:00","description":"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Dynamic Aggregate Points within Polygon Features for Exploratory Analysis"}]},{"@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\/9932dde4f8a6dae58fd1b485d1ddf017","name":"Tanu Hoque","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\/2020\/12\/tanu-hoque2-e1609364913822-213x200.jpeg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/12\/tanu-hoque2-e1609364913822-213x200.jpeg","caption":"Tanu Hoque"},"description":"Tanu is a product engineer on Esri Mapping Team focusing on map service, print service, and ArcGIS Pro. He also works on spatio-temporal analysis, spatial aggregation and real-time data. Tanu\u2019s background includes a masters in Urban Planning from University of Akron, Ohio, USA and a bachelor degree from Khulna University, Bangladesh, and worked as GIS Coordinator in City of West Springfield, and GIS Specialist in a hydrology modeling center in Bangladesh before joining Esri.","sameAs":["https:\/\/x.com\/ArcGISPro"],"url":"https:\/\/www.esri.com\/arcgis-blog\/author\/mahoque"}]}},"text_date":"July 4, 2019","author_name":"Tanu Hoque","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/mahoque","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/07\/Points2Polygons-1920x1080.png","primary_product":"ArcGIS Pro","tag_data":[{"term_id":30021,"name":"Aggregation","slug":"aggregation","term_group":0,"term_taxonomy_id":30021,"taxonomy":"post_tag","description":"","parent":0,"count":14,"filter":"raw"},{"term_id":86432,"name":"crime analysis","slug":"crime-analysis","term_group":0,"term_taxonomy_id":86432,"taxonomy":"post_tag","description":"","parent":0,"count":8,"filter":"raw"},{"term_id":35491,"name":"crime mapping","slug":"crime-mapping","term_group":0,"term_taxonomy_id":35491,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"},{"term_id":419502,"name":"dynamic","slug":"dynamic","term_group":0,"term_taxonomy_id":419502,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"},{"term_id":145432,"name":"query layer","slug":"query-layer","term_group":0,"term_taxonomy_id":145432,"taxonomy":"post_tag","description":"","parent":0,"count":6,"filter":"raw"}],"category_data":[{"term_id":22941,"name":"Mapping","slug":"mapping","term_group":0,"term_taxonomy_id":22941,"taxonomy":"category","description":"","parent":0,"count":2690,"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":2036,"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\/558482","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\/5971"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=558482"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/558482\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=558482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=558482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=558482"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=558482"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=558482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}