{"id":307652,"date":"2018-08-28T14:27:31","date_gmt":"2018-08-28T21:27:31","guid":{"rendered":"http:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=307652"},"modified":"2018-08-29T14:05:03","modified_gmt":"2018-08-29T21:05:03","slug":"how-to-join-your-data-and-create-relationships-in-insights-for-arcgis","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis","title":{"rendered":"How-to: Join your data and create relationships in 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,23851],"tags":[24311,216542,216552,216562,216532],"industry":[],"product":[36591,36801],"class_list":["post-307652","blog","type-blog","status-publish","format-standard","hentry","category-analytics","category-data-management","tag-analysis","tag-join","tag-productivity","tag-relationships","tag-sql","product-apps","product-insights"],"acf":{"short_description":"Learn how to join spatial and non-spatial data together, in just a few clicks with Insights for ArcGIS.","flexible_content":[{"acf_fc_layout":"content","content":"<p>In three clicks or less, Insights for ArcGIS empowers you to join layers and tables together to speed through research and not get blocked by time consuming data processing steps.<\/p>\n<p>Oftentimes there is enormous difference between how tables are saved in a database and tables that convey meaningful information.\u00a0 If you&#8217;ve ever had to spend lots of time cleaning and merging data together,\u00a0 you&#8217;ll be happy to know that Insights simplifies this process.\u00a0 Instead of having to do things like importing, exporting, SQL querying and publishing, the design of Insights shortcuts these steps allowing you to keep a rhythm on analysis.<\/p>\n<p>Let\u2019s examine.\u00a0 Below, I\u2019m looking at normalized datasets which I&#8217;d like to bring together.\u00a0 To get started, I click on the Create Relationship button which allows me to join one to many tables or layers together from a common source, such as a Relational Database or ArcGIS Hosting Server.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":309352,"id":309352,"title":"one_a","filename":"one_a.png","filesize":135399,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/one_a.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis\/one_a","alt":"Insights workbook","author":"6671","description":"","caption":"In the image above, I click the Create Relationships button to launch the interactive join experience.","name":"one_a","status":"inherit","uploaded_to":307652,"date":"2018-08-28 23:08:18","modified":"2018-08-28 23:08: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":1902,"height":976,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/one_a.png","thumbnail-width":213,"thumbnail-height":109,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/one_a.png","medium-width":464,"medium-height":238,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/one_a.png","medium_large-width":768,"medium_large-height":394,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/one_a.png","large-width":1902,"large-height":976,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/one_a.png","1536x1536-width":1536,"1536x1536-height":788,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/one_a.png","2048x2048-width":1902,"2048x2048-height":976,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/one_a.png","card_image-width":826,"card_image-height":424,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/one_a.png","wide_image-width":1902,"wide_image-height":976}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Here&#8217;s how that panel looks.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":307992,"id":307992,"title":"Click 2","filename":"two.png","filesize":10130,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/two.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis\/two","alt":"Create relationships","author":"6671","description":"","caption":"Drag and drop the datasets to join together.","name":"two","status":"inherit","uploaded_to":307652,"date":"2018-08-27 19:43:15","modified":"2018-08-27 21:04: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":1252,"height":413,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/two.png","thumbnail-width":213,"thumbnail-height":70,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/two.png","medium-width":464,"medium-height":153,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/two.png","medium_large-width":768,"medium_large-height":253,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/two.png","large-width":1252,"large-height":413,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/two.png","1536x1536-width":1252,"1536x1536-height":413,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/two.png","2048x2048-width":1252,"2048x2048-height":413,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/two.png","card_image-width":826,"card_image-height":272,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/two.png","wide_image-width":1252,"wide_image-height":413}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Above I&#8217;ve dragged out the datasets I want to join together, which are <em>regions<\/em> and <em>staff<\/em>.\u00a0 If I am happy with the smart defaults Insights chose for me, I can click finish and I will be done!\u00a0 Alternatively, I can use the pencil to define the relationship further.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":308012,"id":308012,"title":"Click 3","filename":"three.png","filesize":30110,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/three.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis\/three","alt":"","author":"6671","description":"","caption":"By using the pencil, I choose the type of join which best serves my purpose and I select what field(s) I would like to join on. ","name":"three","status":"inherit","uploaded_to":307652,"date":"2018-08-27 19:51:41","modified":"2018-08-27 20:36:37","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1251,"height":770,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/three.png","thumbnail-width":213,"thumbnail-height":131,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/three.png","medium-width":424,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/three.png","medium_large-width":768,"medium_large-height":473,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/three.png","large-width":1251,"large-height":770,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/three.png","1536x1536-width":1251,"1536x1536-height":770,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/three.png","2048x2048-width":1251,"2048x2048-height":770,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/three.png","card_image-width":755,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/three.png","wide_image-width":1251,"wide_image-height":770}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>In the last step, instead of accepting the smart defaults, I elect to do a <em>left join<\/em> and choose what fields I want to join on, having some understanding of the cardinality between the spatial tables.\u00a0 While this adds a few more clicks, it is worth it because I do not have to write any SQL.\u00a0 The significance is that SQL can grow quite complicated and large in size, especially if I chose to join all three datasets.\u00a0 By design, Insights supports all major join types and enables joins on multiple fields.<\/p>\n<p>Specifically, you will find support for these join types at the database level:<\/p>\n<ul>\n<li>Inner join, <em>aka intersect<\/em><\/li>\n<li>Full outer join<\/li>\n<li>Left join<\/li>\n<li>Right join<\/li>\n<\/ul>\n<p>Hopefully this blog post reveals something new for you to try.\u00a0 For me, creating relationships in Insights is significantly boosting my productivity.\u00a0 Please check back soon for more ways to make your data actionable and ready for analysis.<\/p>\n"},{"acf_fc_layout":"content","content":"<p>Want to read more? Visit our <a href=\"https:\/\/doc.arcgis.com\/en\/insights\/\" target=\"_blank\" rel=\"noopener\">documentation<\/a>.<\/p>\n<p>Give \u201cCreate Relationships\u201d a try with your data?\u00a0 Don\u2019t have access to Insights for ArcGIS, follow this link to <a href=\"http:\/\/bit.ly\/2Ll1v7C\" target=\"_blank\" rel=\"noopener\">get 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":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/08\/bio-pic-dougcarroll.jpeg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"}],"related_articles":"","card_image":false,"wide_image":false},"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>How-to: Join your data and create relationships in Insights for ArcGIS<\/title>\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\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How-to: Join your data and create relationships in Insights for ArcGIS\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-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=\"2018-08-29T21:05:03+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\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis\"},\"author\":{\"name\":\"Doug Carroll\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/7907d146346986221658912912f202eb\"},\"headline\":\"How-to: Join your data and create relationships in Insights for ArcGIS\",\"datePublished\":\"2018-08-28T21:27:31+00:00\",\"dateModified\":\"2018-08-29T21:05:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis\"},\"wordCount\":11,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"Analysis\",\"Join\",\"Productivity\",\"Relationships\",\"SQL\"],\"articleSection\":[\"Analytics\",\"Data Management\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis\",\"name\":\"How-to: Join your data and create relationships in Insights for ArcGIS\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2018-08-28T21:27:31+00:00\",\"dateModified\":\"2018-08-29T21:05:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How-to: Join your data and create relationships in 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":"How-to: Join your data and create relationships in Insights for ArcGIS","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\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis","og_locale":"en_US","og_type":"article","og_title":"How-to: Join your data and create relationships in Insights for ArcGIS","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2018-08-29T21:05:03+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\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis"},"author":{"name":"Doug Carroll","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/7907d146346986221658912912f202eb"},"headline":"How-to: Join your data and create relationships in Insights for ArcGIS","datePublished":"2018-08-28T21:27:31+00:00","dateModified":"2018-08-29T21:05:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis"},"wordCount":11,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["Analysis","Join","Productivity","Relationships","SQL"],"articleSection":["Analytics","Data Management"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis","name":"How-to: Join your data and create relationships in Insights for ArcGIS","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2018-08-28T21:27:31+00:00","dateModified":"2018-08-29T21:05:03+00:00","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/how-to-join-your-data-and-create-relationships-in-insights-for-arcgis#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"How-to: Join your data and create relationships in 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":"August 28, 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\/2025\/08\/Newsroom-Keyart-Wide-1920-x-1080.jpg","primary_product":"ArcGIS Insights","tag_data":[{"term_id":24311,"name":"Analysis","slug":"analysis","term_group":0,"term_taxonomy_id":24311,"taxonomy":"post_tag","description":"","parent":0,"count":96,"filter":"raw"},{"term_id":216542,"name":"Join","slug":"join","term_group":0,"term_taxonomy_id":216542,"taxonomy":"post_tag","description":"","parent":0,"count":3,"filter":"raw"},{"term_id":216552,"name":"Productivity","slug":"productivity","term_group":0,"term_taxonomy_id":216552,"taxonomy":"post_tag","description":"","parent":0,"count":10,"filter":"raw"},{"term_id":216562,"name":"Relationships","slug":"relationships","term_group":0,"term_taxonomy_id":216562,"taxonomy":"post_tag","description":"","parent":0,"count":3,"filter":"raw"},{"term_id":216532,"name":"SQL","slug":"sql","term_group":0,"term_taxonomy_id":216532,"taxonomy":"post_tag","description":"","parent":0,"count":6,"filter":"raw"}],"category_data":[{"term_id":23341,"name":"Analytics","slug":"analytics","term_group":0,"term_taxonomy_id":23341,"taxonomy":"category","description":"","parent":0,"count":1329,"filter":"raw"},{"term_id":23851,"name":"Data Management","slug":"data-management","term_group":0,"term_taxonomy_id":23851,"taxonomy":"category","description":"","parent":0,"count":920,"filter":"raw"}],"product_data":[{"term_id":36591,"name":"Apps","slug":"apps","term_group":0,"term_taxonomy_id":36591,"taxonomy":"product","description":"","parent":0,"count":649,"filter":"raw"},{"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\/307652","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=307652"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/307652\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=307652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=307652"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=307652"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=307652"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=307652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}