{"id":314572,"date":"2018-09-15T07:15:52","date_gmt":"2018-09-15T14:15:52","guid":{"rendered":"http:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=314572"},"modified":"2021-09-02T06:07:47","modified_gmt":"2021-09-02T13:07:47","slug":"perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis","title":{"rendered":"Perform Spatial Joins, Geo-Enablement, and Spatial Aggregation all with Insights for ArcGIS"},"author":6671,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23341,37171],"tags":[229452,229462,31371,222602,70121],"industry":[],"product":[36801],"class_list":["post-314572","blog","type-blog","status-publish","format-standard","hentry","category-analytics","category-business","tag-customer-address","tag-mapping-software","tag-retail","tag-spatial-aggregation","tag-spatial-join","product-insights"],"acf":{"short_description":"Spatial relationships surface fascinating discoveries. This article explores spatial join, geo-enablement and spatial aggregation in Insights. ","flexible_content":[{"acf_fc_layout":"content","content":"

A few weeks back I blogged about the types of data joins<\/a> you can do in Insights for ArcGIS. Now let\u2019s look at how you can find spatial trends through simple drag and drop steps using spatial joins, location enablement and spatial aggregation.<\/p>\n

Let\u2019s start by looking at online shopping trends.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":317982,"id":317982,"title":"44444444","filename":"44444444.png","filesize":825114,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/09\/44444444.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis\/attachment\/44444444","alt":"","author":"6671","description":"","caption":"","name":"44444444","status":"inherit","uploaded_to":314572,"date":"2018-09-13 22:37:36","modified":"2018-09-13 22:37:36","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":2760,"height":2630,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/09\/44444444.png","thumbnail-width":210,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/09\/44444444.png","medium-width":274,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/09\/44444444.png","medium_large-width":768,"medium_large-height":732,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/09\/44444444.png","large-width":1133,"large-height":1080,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/09\/44444444.png","1536x1536-width":1536,"1536x1536-height":1464,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/09\/44444444.png","2048x2048-width":2048,"2048x2048-height":1952,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/09\/44444444.png","card_image-width":488,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/09\/44444444.png","wide_image-width":1133,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

While this analysis shows retail activity, these features may apply to just about anything you can imagine.<\/p>\n

Take a moment to look at the distribution and amount of sales across America (above purple map with rings showing quantities).\u00a0 Look around the South and South \/ Central areas of the United States.\u00a0 Clearly something is going on in this area!<\/p>\n

Another trend appears to be who may be buying this online product.\u00a0 Through simple spatial aggregation, I can tell that orders are less common in major metropolitan areas and more common in family landscapes near mid-sized cities.\u00a0 So maybe it\u2019s time to hit pause on that pricy advertising project in New York City?<\/p>\n

Now let\u2019s dissect.<\/p>\n

Geo-Enablement<\/h2>\n

Oftentimes data sets will include location information, but lack a geometric dimension essential for spatial analysis<\/a>.\u00a0 \u00a0Insights handles this in a variety of ways through built-in Geo-Enablement capabilities.\u00a0 For any data set, Insights can transform a description of a place \u2014 such as a pair of coordinates, an address, or a name of a place \u2014 to easily create mappable locations for spatial analysis.\u00a0 This is perfect when the starting point may be an address, zip code or city name.<\/p>\n"},{"acf_fc_layout":"sidebar","content":"

Geo-Enablement equips organizations so they are ready to take on spatial analysis.\u00a0 Insights for ArcGIS includes a variety of ways for creating spatial dimensions from your data, so beautiful discoveries can be made with maps.<\/em><\/p>\n","image_reference":false,"layout":"standard","image_reference_figure":"","snippet":"","spotlight_name":"","section_title":"","position":"Right","spotlight_image":false},{"acf_fc_layout":"content","content":"

For this example, I enabled location by choosing the customer address included in my orders table.\u00a0 Alternatively, if my data has coordinates I can use these values or I can relate my data to a spatial layer by common field, such as how classic joining works.<\/p>\n

Spatial Join<\/h2>\n

What about when there is no common field to join on?\u00a0 In my last blog<\/a>, I talked about how to join many tables together using common fields.\u00a0 Now I am going to say there is another approach, you can join based on location!\u00a0 A spatial join is powerful.\u00a0 With Insights, you can join\u00a0points<\/em>, lines<\/em> and polygons\u00a0<\/em>together.\u00a0 If your data shares a geographic relationship with other spatial content, Insights can perform a spatial join to merge data sets.\u00a0 This means you can join information from well-known standard geographies to custom things like roads, railways, buildings or neighborhoods.<\/p>\n

In this example, I joined order locations to census blocks which are one of many curated spatial data sets included within Insights.<\/p>\n"},{"acf_fc_layout":"sidebar","content":"

Census blocks are small geographic boundaries, which the U.S. Census Bureau maintains and are enriched by Esri demographers\u00a0and included within Insights, along with other spatial data like zip codes.<\/em><\/p>\n","image_reference":false,"layout":"standard","image_reference_figure":"","snippet":"","spotlight_name":"","section_title":"","position":"Right","spotlight_image":false},{"acf_fc_layout":"content","content":"

The reason I choose to use spatial join was to unite categorical and demographic information into my orders, which are maintained at the census block level.\u00a0\u00a0 After doing this, interesting discoveries can be made about the communities buying this product.<\/p>\n

Spatial Aggregation<\/h2>\n

Spatial aggregation helps you understand quantities of\u00a0commodities in geographic areas.\u00a0 The process of summarizing data into counts and amounts from one geographic feature into another is spatial aggregation.\u00a0 This is perhaps my favorite Insights feature.\u00a0 Here’s why.\u00a0 The experience for doing aggregations makes you feel like a Miami vice crime scene investigator, even when you may just be crunching retail numbers.\u00a0 It’s simply drag and drop!<\/p>\n

In the map above, I aggregated the number of customer orders within each county using spatial aggregation.\u00a0 Instead of showing the total number of orders, I could have shown average sale amount or total sale amount within each county.\u00a0 Additionally, I could have symbolized my map using a variety of different colors and styles.<\/p>\n

Conclusion<\/strong><\/h3>\n

Hopefully this blog has inspired you to think about the hidden spatial trends that may be in your data.\u00a0 Together Spatial Join, Location Enablement, and Spatial Aggregation can create powerful and profound analytics for retail and\/or any discipline you can imagine.\u00a0 So give it a try!\u00a0 \u00a0Please check back for more ways to make your data actionable and ready for analysis.<\/p>\n

Want to read more? Visit our\u00a0documentation<\/a>.<\/p>\n

Give \u201cSpatial Join, Location Enablement and Spatial Aggregation\u201d a try with your data?\u00a0 Don\u2019t have access to Insights for ArcGIS<\/a>, follow this link to\u00a0get a free trial<\/a>!<\/p>\n"}],"authors":[{"ID":6671,"user_firstname":"Doug","user_lastname":"Carroll","nickname":"doogle_startups","user_nicename":"doogle_startups","display_name":"Doug Carroll","user_email":"DCarroll@esri.com","user_url":"","user_registered":"2018-03-02 00:18:39","user_description":"I am a developer on the Insights for ArcGIS team and have a passion for helping partners integrate GIS into their core business. When not working at Esri to make spatial insights actionable, my family and I run an online retail business which started in downtown Los Angeles. My degree is from the Department of Human Ecology at Rutgers University.","user_avatar":""}],"related_articles":"","card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/09\/banner_small_v8.png","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/09\/banner_big_v8.png"},"yoast_head":"\nPerform Spatial Joins, Geo-Enablement, and Spatial Aggregation all with Insights for ArcGIS<\/title>\n<meta name=\"description\" content=\"Spatial analysis and mapping is easy with Insights for ArcGIS software. Spatial join, spatial aggregation and geo-enablement help find trends and patterns.\" \/>\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\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Perform Spatial Joins, Geo-Enablement, and Spatial Aggregation all with Insights for ArcGIS\" \/>\n<meta property=\"og:description\" content=\"Spatial analysis and mapping is easy with Insights for ArcGIS software. Spatial join, spatial aggregation and geo-enablement help find trends and patterns.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis\" \/>\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-09-02T13:07:47+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\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis\"},\"author\":{\"name\":\"Doug Carroll\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/7907d146346986221658912912f202eb\"},\"headline\":\"Perform Spatial Joins, Geo-Enablement, and Spatial Aggregation all with Insights for ArcGIS\",\"datePublished\":\"2018-09-15T14:15:52+00:00\",\"dateModified\":\"2021-09-02T13:07:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis\"},\"wordCount\":12,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"customer address\",\"mapping software\",\"Retail\",\"spatial aggregation\",\"spatial join\"],\"articleSection\":[\"Analytics\",\"Business\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis\",\"name\":\"Perform Spatial Joins, Geo-Enablement, and Spatial Aggregation all with Insights for ArcGIS\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2018-09-15T14:15:52+00:00\",\"dateModified\":\"2021-09-02T13:07:47+00:00\",\"description\":\"Spatial analysis and mapping is easy with Insights for ArcGIS software. Spatial join, spatial aggregation and geo-enablement help find trends and patterns.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Perform Spatial Joins, Geo-Enablement, and Spatial Aggregation all with Insights for ArcGIS\"}]},{\"@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\/7907d146346986221658912912f202eb\",\"name\":\"Doug Carroll\",\"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\/2018\/08\/bio-pic-dougcarroll.jpeg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/bio-pic-dougcarroll.jpeg\",\"caption\":\"Doug Carroll\"},\"description\":\"I am a developer on the Insights for ArcGIS team and have a passion for helping partners integrate GIS into their core business. When not working at Esri to make spatial insights actionable, my family and I run an online retail business which started in downtown Los Angeles. My degree is from the Department of Human Ecology at Rutgers University.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/doug-carroll-07874148\/\",\"https:\/\/x.com\/globebeta\"],\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/doogle_startups\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Perform Spatial Joins, Geo-Enablement, and Spatial Aggregation all with Insights for ArcGIS","description":"Spatial analysis and mapping is easy with Insights for ArcGIS software. Spatial join, spatial aggregation and geo-enablement help find trends and patterns.","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\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis","og_locale":"en_US","og_type":"article","og_title":"Perform Spatial Joins, Geo-Enablement, and Spatial Aggregation all with Insights for ArcGIS","og_description":"Spatial analysis and mapping is easy with Insights for ArcGIS software. Spatial join, spatial aggregation and geo-enablement help find trends and patterns.","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2021-09-02T13:07:47+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\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis"},"author":{"name":"Doug Carroll","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/7907d146346986221658912912f202eb"},"headline":"Perform Spatial Joins, Geo-Enablement, and Spatial Aggregation all with Insights for ArcGIS","datePublished":"2018-09-15T14:15:52+00:00","dateModified":"2021-09-02T13:07:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis"},"wordCount":12,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["customer address","mapping software","Retail","spatial aggregation","spatial join"],"articleSection":["Analytics","Business"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis","name":"Perform Spatial Joins, Geo-Enablement, and Spatial Aggregation all with Insights for ArcGIS","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2018-09-15T14:15:52+00:00","dateModified":"2021-09-02T13:07:47+00:00","description":"Spatial analysis and mapping is easy with Insights for ArcGIS software. Spatial join, spatial aggregation and geo-enablement help find trends and patterns.","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/perform-spatial-joins-geo-enablement-classic-data-joins-and-spatial-aggregation-all-with-insights-for-arcgis#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Perform Spatial Joins, Geo-Enablement, and Spatial Aggregation all with Insights for ArcGIS"}]},{"@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\/7907d146346986221658912912f202eb","name":"Doug Carroll","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\/2018\/08\/bio-pic-dougcarroll.jpeg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/bio-pic-dougcarroll.jpeg","caption":"Doug Carroll"},"description":"I am a developer on the Insights for ArcGIS team and have a passion for helping partners integrate GIS into their core business. When not working at Esri to make spatial insights actionable, my family and I run an online retail business which started in downtown Los Angeles. My degree is from the Department of Human Ecology at Rutgers University.","sameAs":["https:\/\/www.linkedin.com\/in\/doug-carroll-07874148\/","https:\/\/x.com\/globebeta"],"url":"https:\/\/www.esri.com\/arcgis-blog\/author\/doogle_startups"}]}},"text_date":"September 15, 2018","author_name":"Doug Carroll","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/doogle_startups","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/09\/banner_big_v8.png","primary_product":"ArcGIS Insights","tag_data":[{"term_id":229452,"name":"customer address","slug":"customer-address","term_group":0,"term_taxonomy_id":229452,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":229462,"name":"mapping software","slug":"mapping-software","term_group":0,"term_taxonomy_id":229462,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"},{"term_id":31371,"name":"Retail","slug":"retail","term_group":0,"term_taxonomy_id":31371,"taxonomy":"post_tag","description":"","parent":0,"count":7,"filter":"raw"},{"term_id":222602,"name":"spatial aggregation","slug":"spatial-aggregation","term_group":0,"term_taxonomy_id":222602,"taxonomy":"post_tag","description":"","parent":0,"count":6,"filter":"raw"},{"term_id":70121,"name":"spatial join","slug":"spatial-join","term_group":0,"term_taxonomy_id":70121,"taxonomy":"post_tag","description":"","parent":0,"count":5,"filter":"raw"}],"category_data":[{"term_id":23341,"name":"Analytics","slug":"analytics","term_group":0,"term_taxonomy_id":23341,"taxonomy":"category","description":"","parent":0,"count":1325,"filter":"raw"},{"term_id":37171,"name":"Business","slug":"business","term_group":0,"term_taxonomy_id":37171,"taxonomy":"category","description":"","parent":0,"count":280,"filter":"raw"}],"product_data":[{"term_id":36801,"name":"ArcGIS Insights","slug":"insights","term_group":0,"term_taxonomy_id":36801,"taxonomy":"product","description":"","parent":36591,"count":119,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=insights","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/314572","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\/6671"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=314572"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/314572\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=314572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=314572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=314572"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=314572"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=314572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}