{"id":84942,"date":"2019-02-06T13:37:54","date_gmt":"2019-02-06T21:37:54","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcuser&p=84942"},"modified":"2024-05-10T16:34:03","modified_gmt":"2024-05-10T23:34:03","slug":"going-with-the-flow-to-map-routes","status":"publish","type":"arcuser","link":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/going-with-the-flow-to-map-routes","title":{"rendered":"Going with the Flow to Map Routes"},"author":1432,"featured_media":0,"menu_order":0,"template":"","format":"standard","meta":{"_acf_changed":false,"sync_status":"","episode_type":"","audio_file":"","podmotor_file_id":"","podmotor_episode_id":"","castos_file_data":"","cover_image":"","cover_image_id":"","duration":"","filesize":"","filesize_raw":"","date_recorded":"","explicit":"","block":"","itunes_episode_number":"","itunes_title":"","itunes_season_number":"","itunes_episode_type":"","_links_to":"","_links_to_target":""},"categories":[10402,171,25022],"tags":[20382,311,281,271],"arcuser_issues":[63142],"class_list":["post-84942","arcuser","type-arcuser","status-publish","format-standard","hentry","category-arcgis-desktop","category-education","category-hands-on","tag-cartography","tag-data-driven","tag-location-intelligence","tag-mapping","arcuser_issues-fall-2017"],"acf":{"short_description":"Who hasn\u2019t found themselves engrossed in the route maps at the back of flight magazines and asked themselves, \u201cHow do they make those maps?\u201d","pdf":{"host_remotely":false,"file":"","file_url":""},"flexible_content":[{"acf_fc_layout":"content","content":"Who hasn\u2019t found themselves engrossed in the route maps at the back of flight magazines and asked themselves, \u201cHow do they make those maps?\u201d Readers who have a few years of GIS experience can read through this article to find out how. This article will be most relevant to readers wanting to know how GIS can illustrate movement from one location to another when those origins or destinations are shared, such as flights arriving to and departing from an airline hub.<\/em>"},{"acf_fc_layout":"image","image":84952,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"One splendid spring day in Lawrence, Kansas, GIS specialist Rhonda Houser was working as a colleague (her boss) was busy planning a big conference. For conference attendees, Houser had created a map of favorite local destinations. This was a straightforward process in ArcGIS Online that had a satisfactory result. Her colleague also asked if Houser could make a map showing where attendees had traveled from to attend the conference.\r\n\r\nHouser found a helpful post on the\u00a0ArcGIS Blog<\/em>\u00a0from September 6, 2011, \u201cCreating radial flow maps with ArcGIS<\/a>,\u201d by Mamata Akella. It described how radial flow maps can show the movement of goods or people, using lines to depict transportation and communication routes and relationships. A radial flow map can show multiple origins converging on a single destination (or vice versa). Best of all, she learned that ArcGIS has a tool that generates radial flow data from geographic coordinates.\r\n\r\nHer colleague had provided a spreadsheet of attendee data that included the country, state (if the attendee resided in the United States), city, and ZIP code. Registrants were also coming from more than 100 places in Africa, Japan, Australia, and the Philippines.\r\n\r\nHouser used Microsoft Excel to clean and format the data. She didn\u2019t touch the ZIP code data because mapping this geography is tricky. She summarized all records for each city into a single row and added a column for the number of attendees per city. She structured the data this way so the tool would create a line for each city instead of each attendee. She also added the four columns required to hold the geographic coordinates for origins and destinations."},{"acf_fc_layout":"image","image":84962,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"GeoNames<\/a> seemed like a comprehensive and authoritative source for latitude and longitude (x,y) data for the cities. [GeoNames is an online geographic database that provides place names for all countries. Available under a creative commons attribution license, place-name data can be downloaded at no charge.]<\/em>\r\n\r\nCleaning data is naturally messy. GeoNames data is available based on city population, so the coordinates Houser needed were scattered throughout a few large, delimited text files.\r\n\r\nDealing with duplicate city names was another challenge. Guess how many Springfields there are in the United States? GeoNames city data seemed to include unique identifiers, though the attendee data did not. Preparing the data for a giant join was going to be a lot of work. Instead, Houser found an easier method. She entered coordinates for each city, using Google Maps to fill in a few gaps.\r\n\r\nFor local attendees, she assigned coordinates roughly equivalent to the city center. Although discernible only at a very large scale, this line intensified the overall density of the lines leading to the University of Kansas campus at other scales. A few x,y values that stubbornly refused to be formatted as decimal numbers conformed after some prodding.\r\n\r\nSuccess in GIS requires outlandish displays of problem solving, driven by an array of tactics and a relentless determination to solve, fix, or finish. Creativity is often the result rather than the intent when resources are scarce or ideal resources are not present. What seems creative is also a reflection of the particular combination of tools, expertise, and time available in each unique environment."},{"acf_fc_layout":"image","image":84972,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"Houser used the XY To Line tool in ArcGIS Desktop 10.5 to generate a line dataset from the spreadsheet data.\u00a0[The XY To Line tool uses origin and destination values as inputs from a table and creates a new linear feature class that represents the path connecting these two points.]<\/em>\u00a0The output shapefile included default vector data fields and starting and ending coordinates but not the rest of the spreadsheet data. To join that data, she needed a field containing unique identifying values. She joined the rest of the spreadsheet data based on the starting longitude value field\u2014and it worked.\r\n\r\nHouser wanted graceful, arched lines that appeared to leap off the map into the air and rocket down to their destination. The XY To Line tool options for line type have fun names like rhumb line, geodesic, great circle, and normal section. After reading their definitions, the names seemed less whimsical but were still interesting. Except for the rhumb line type, which produced straight lines, the other line type options produced similar results.\r\n\r\nThe geodesic line type, the default choice, is the most accurate for representing the shortest distance between two points on the earth\u2019s surface, and the lines are visually appealing. As the objective was a map balancing a clean and appealing appearance with geographic accuracy, the geodesic line type was the winner."},{"acf_fc_layout":"image","image":84982,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"The\u00a0ArcGIS Blog<\/em>\u00a0post described how to center the data by setting the prime meridian of the map projection to match the local longitude. If the default coordinate system of World Geodetic System 1984 (GCS WGS84) with a custom central meridian was used, the flowlines seemed to crawl off the map. Instead of lines flowing from the map edge inward to Kansas at the center, the data resembled a spider crouched on one side of the map with its legs broken off on the other side.\r\n\r\nTo make radial flow data draw with the destination at the center of the map, the map\u2019s spatial reference needs to be set to a projected coordinate system with a custom central meridian.\r\n\r\nNow for a moment of geospatial gratitude for the utility of the ArcGIS Geoprocessing Results window, since most people don\u2019t take copious notes on every step and setting during geoprocessing operations, Houser used the log saved in the map project, along with her notes, to determine which tool settings generated optimal radial datasets.\r\n\r\nHouser experimented with spatial references for the data and map, shown in Table 1. The only combination that correctly centered the data in ArcGIS Desktop or ArcGIS Online was the data in GCS WGS84, with the map in a projected coordinate system with a custom central meridian.\r\n\r\nThe file was too large to upload to ArcGIS Online, so Houser divided the data into attendees within the United States and attendees from outside the United States. This worked conceptually and geographically and provided more map viewing options.\r\n\r\nWorking with her colleague, Houser chose a contrasting basemap and data symbolization combination that highlighted attendee data at all scales. Mapping line thickness by number of attendees was somewhat effective at a global scale and improved with each successive zoom. This worked reasonably well with the US data alone (at national or larger scale) and worked better when showing attendees from outside the United States (at any scale). To highlight the attendees\u2019 places of origin, Houser created a point shapefile of cities. She symbolized them in a way that differentiated them from cities shown on the basemap."},{"acf_fc_layout":"image","image":84992,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"Houser spent a solid four to five hours building this map. This was a relatively small map project that used a tiny dataset, but a new project has already arisen that could use these techniques to illustrate immigration stories.\r\n\r\nWhen applying these methods to similar data, keep in mind that generating a simple map is often a complex process that involves formatting data, troubleshooting, streamlining methods, and clarifying messages. This process takes time, skill, and persistence. It can take hours to prepare even a small dataset so it can be turned into dots or lines on a map. However, it\u2019s usually worth it\u2014especially if someone thanks you or publicly recognizes the hard work and expertise that is essential for creating that simple map.\r\n\r\nFor more information, contact Rhonda Houser, GIS and mapping specialist at the University of Kansas Libraries, at rhouser@ku.edu or 785-864-1238."},{"acf_fc_layout":"pdf","file":85002}],"references":null},"yoast_head":"\nGoing with the Flow to Map Routes | Fall 2017 | ArcUser<\/title>\n<meta name=\"description\" content=\"Who hasn\u2019t found themselves engrossed in the route maps at the back of flight magazines and asked themselves, \u201cHow do they make those maps?\u201d\" \/>\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\/about\/newsroom\/arcuser\/going-with-the-flow-to-map-routes\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Going with the Flow to Map Routes\" \/>\n<meta property=\"og:description\" content=\"Who hasn\u2019t found themselves engrossed in the route maps at the back of flight magazines and asked themselves, \u201cHow do they make those maps?\u201d\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/going-with-the-flow-to-map-routes\" \/>\n<meta property=\"og:site_name\" content=\"Esri\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-10T23:34:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2019\/09\/topography-dark-grey-card.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@Esri\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t \"@context\": \"https:\/\/schema.org\",\n\t \"@graph\": [\n\t {\n\t \"@type\": \"WebPage\",\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/going-with-the-flow-to-map-routes\",\n\t \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/going-with-the-flow-to-map-routes\",\n\t \"name\": \"Going with the Flow to Map Routes | Fall 2017 | ArcUser\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t },\n\t \"datePublished\": \"2019-02-06T21:37:54+00:00\",\n\t \"dateModified\": \"2024-05-10T23:34:03+00:00\",\n\t \"description\": \"Who hasn\u2019t found themselves engrossed in the route maps at the back of flight magazines and asked themselves, \u201cHow do they make those maps?\u201d\",\n\t \"breadcrumb\": {\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/going-with-the-flow-to-map-routes#breadcrumb\"\n\t },\n\t \"inLanguage\": \"en-US\",\n\t \"potentialAction\": [\n\t {\n\t \"@type\": \"ReadAction\",\n\t \"target\": [\n\t \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/going-with-the-flow-to-map-routes\"\n\t ]\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"BreadcrumbList\",\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/going-with-the-flow-to-map-routes#breadcrumb\",\n\t \"itemListElement\": [\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 1,\n\t \"name\": \"Home\",\n\t \"item\": \"https:\/\/www.esri.com\/about\/newsroom\"\n\t },\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 2,\n\t \"name\": \"Going with the Flow to Map Routes\"\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"WebSite\",\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\",\n\t \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/\",\n\t \"name\": \"Esri\",\n\t \"description\": \"Esri Newsroom\",\n\t \"potentialAction\": [\n\t {\n\t \"@type\": \"SearchAction\",\n\t \"target\": {\n\t \"@type\": \"EntryPoint\",\n\t \"urlTemplate\": \"https:\/\/www.esri.com\/about\/newsroom\/?s={search_term_string}\"\n\t },\n\t \"query-input\": {\n\t \"@type\": \"PropertyValueSpecification\",\n\t \"valueRequired\": true,\n\t \"valueName\": \"search_term_string\"\n\t }\n\t }\n\t ],\n\t \"inLanguage\": \"en-US\"\n\t },\n\t {\n\t \"@type\": \"Person\",\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/b7332d419608ac1a0291ec30de119efb\",\n\t \"name\": \"April Mann\",\n\t \"image\": {\n\t \"@type\": \"ImageObject\",\n\t \"inLanguage\": \"en-US\",\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/\",\n\t \"url\": \"https:\/\/secure.gravatar.com\/avatar\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g\",\n\t \"contentUrl\": \"https:\/\/secure.gravatar.com\/avatar\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g\",\n\t \"caption\": \"April Mann\"\n\t },\n\t \"url\": \"\"\n\t }\n\t ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Going with the Flow to Map Routes | Fall 2017 | ArcUser","description":"Who hasn\u2019t found themselves engrossed in the route maps at the back of flight magazines and asked themselves, \u201cHow do they make those maps?\u201d","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\/about\/newsroom\/arcuser\/going-with-the-flow-to-map-routes","og_locale":"en_US","og_type":"article","og_title":"Going with the Flow to Map Routes","og_description":"Who hasn\u2019t found themselves engrossed in the route maps at the back of flight magazines and asked themselves, \u201cHow do they make those maps?\u201d","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/going-with-the-flow-to-map-routes","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2024-05-10T23:34:03+00:00","og_image":[{"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2019\/09\/topography-dark-grey-card.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@Esri","twitter_misc":{"Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/going-with-the-flow-to-map-routes","url":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/going-with-the-flow-to-map-routes","name":"Going with the Flow to Map Routes | Fall 2017 | ArcUser","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2019-02-06T21:37:54+00:00","dateModified":"2024-05-10T23:34:03+00:00","description":"Who hasn\u2019t found themselves engrossed in the route maps at the back of flight magazines and asked themselves, \u201cHow do they make those maps?\u201d","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/going-with-the-flow-to-map-routes#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcuser\/going-with-the-flow-to-map-routes"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/going-with-the-flow-to-map-routes#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/about\/newsroom"},{"@type":"ListItem","position":2,"name":"Going with the Flow to Map Routes"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/about\/newsroom\/#website","url":"https:\/\/www.esri.com\/about\/newsroom\/","name":"Esri","description":"Esri Newsroom","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/about\/newsroom\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/b7332d419608ac1a0291ec30de119efb","name":"April Mann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g","caption":"April Mann"},"url":""}]}},"sort_order":"0","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser\/84942","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser"}],"about":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/types\/arcuser"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/users\/1432"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser\/84942\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=84942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=84942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=84942"},{"taxonomy":"arcuser_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser_issues?post=84942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}