Extending the Reach of GIS with the Cloud and ArcGIS Online

Bern Szukalski of Esri and John Thomas and Frank Pisani of the Utah Department of Transportation (UDOT) demonstrate how UDOT uses ArcGIS Online in their organization.

Jul 23rd, 2012

Start From:
Player Color:

Right-click on these links to download and save this video.


00:01I've talked a lot about this sort of feature function additions to ArcGIS at 10.1.

00:06I want to shift the conversation now to this other side, which is 10.1 providing transformational...

00:13...opportunities; in other words, getting at the issue of geography as a platform.

00:22ArcGIS is at a major turning point; it's becoming a system for your entire organization.

00:32Well, maybe I should say, it's been engineered to be a system for your entire organization.

00:40This means integration of cloud platform technologies in the form of ArcGIS Online supporting the GIS...

00:48...professionals, but also a whole myriad of tools and apps that support access and use by everybody in the organization.

01:00This is the theme of this conference, and you'll see it again and again showing up on the stage...

01:05...this morning and this afternoon.

01:08Here one of our partners has been the US Department of [the] Interior who had early insight into what this...

01:15...might mean for that agency, and we'll see some examples of it in a few minutes.

01:23This cloud capability is now a fundamental part of ArcGIS.

01:28It's one of the big themes I want you to sort of get.

01:31You don't have to use it, you don't have to apply it, but you should.

01:43Why? Well, it provides a kind of content management for users, how they organize and they share their information.

01:54It supports intuitive mapping for everybody in the organization, the knowledge workers, the executives.

02:02It supports the concept of sharing and collaboration, working together around maps.

02:08It supports the notion of free web apps, and mobile apps that people can interact with your data on.

02:15It also supports the notion of out-of-the-box integration with many other enterprise IT systems, and it's also open.

02:24You can put any kind of data into it and access it from different apps through APIs.

02:31This also has the unique characteristic of integrating ArcGIS with a whole cloud computing revolution...

02:40...which means the scalability, low cost; manage what, only pay for what you're using in the way of...

02:47...computer infrastructure resources.

02:50This is exciting stuff.

02:52ArcGIS Online has been something that we've been telling you about, showing you aspects of, for some time.

02:59At this stage, 10.1, it's different; it actually integrates with the entire suite of tools, and well...

03:08...it will make things like integration of your own servers and your own desktops easy to do...

03:14...and cataloging of your information, and backup hosting so if you don't have a server you can use the cloud server.

03:21And then it supports open access from any client, these apps that I've been talking about.

03:27And then it's easily configured for your organization.

03:31That aspect is very appealing to people.

03:35Of course, there's ArcGIS Online.

03:37We have our own home page, and our own gallery, and our own groups, and our own little maps.

03:42But EPA, Malcolm's organization, has taken that platform and deployed it on premise with his own home page...

03:53...and his own gallery and his own groups and his own web maps.

03:57And so has Utah and so have actually hundreds of cities and states and organizations like Stone Environmental...

04:03...a private consulting company, just to get their information organized and shared.

04:10The medium of this is web maps; I've said web maps now seven times this morning.

04:16What are web maps? Web maps are a new medium for ArcGIS.

04:21They integrate services; they're kind of like mashups.

04:26I can bring this service, this service, this service together and persist them in a web map, and I can share that...

04:32...I can e-mail it, I can look at it from any device.

04:35And I can integrate into my desktop work; I can put it in my website, et cetera.

04:42And they support visualization, but they also support pop-ups, queries, and analytics. And also I can edit them.

04:52Of course, I'm not editing the web map; I'm editing back to the original server of data that's coming...

04:59...and making the web map.

05:01This little device that has been invented here is going to make geographic information useful everywhere...

05:11...in any app, and any environment.

05:15ArcGIS now also, as of last Friday, works within Microsoft Office.

05:23This is supposed to be a big announcement, by the way; it's cool.


05:31I think by last record there's like 850 million Office users; I'm thinking this is a good way...

05:37...this is a good way to get our web maps out.

05:41Well it's not exactly that simple.

05:44Office users who use things like spreadsheets now have a little toolbar inside of them that allows them...

05:51...to take the spreadsheet and make a map of it.

05:55That's cool all by itself.

05:57But then, we can take that map and send it over to the cloud, ArcGIS Online, and turn it into a service; that's very cool.

06:04Then I can use that map service to integrate with other services, or I can read those maps back...

06:10...into other Office environments.

06:14One of them is PowerPoint, because I can take my maps now, web maps, or the Office generated maps...

06:21...and simply put them into my PowerPoint.

06:24So you're saying, well Jack, let's see that.

06:26So let's suppose one of these maps were a live map; it isn't, but I just would like for you to think that.

06:35In my PowerPoint display, I could click the map and it immediately is a web map that's live and dynamic...

06:42...and linked back to the original data; that's a very cool notion.

06:46So inside of Office, inside of PowerPoint, inside of e-mail systems, and also integrated into SharePoint.

06:55Well, pretty interesting ways to begin to extend the power of your work into these other medium...

07:04...environments across the organization.

07:07I'm going to pause for a couple of minutes and let my colleague Bernie Szukalski come up here and...

07:12...show you some of this, because it's okay to look at it in PowerPoint, but it's much better to hear from Bernie.

07:19Bernie, take it away.

07:21Thank you, Jack.

07:24Thank you.

07:28ArcGIS Online has evolved a lot since we introduced it here about four years ago.

07:34It's evolved from a simple framework for sharing data, into a deeply integrated cloud component of the ArcGIS system.

07:43Now, a few weeks ago, we completed a beta program that introduced new capabilities for GIS organizations.

07:51And we've invited one of those participants to join us here today; that's the Utah Department of Transportation.

07:59Now, I've learned a lot from this organization and the gentleman that I'm about to introduce.

08:03What I've learned is that the power of ArcGIS Online is not so much the features and the functions that it delivers...

08:12...but rather it's the way that it can transform the way that we think about and the way that we use GIS.

08:18It's my privilege now to introduce to you UDOT's director of planning, Mr. John Thomas.

08:30Thank you Bernie.

08:32As the planning director at the Utah Department of Transportation, I need quick and convenient access...

08:38...to a wide range of information that helps me do my job better, to help understand how our...

08:43...transportation systems are performing, and to help inform the decision-making process.

08:48Now, initially at UDOT and as well we began to learn with every other agency we started to work with...

08:54...all this information is independently managed by groups, and all these spreadsheets and Word documents...

09:00...PDFs, custom applications, it's a highly fragmented and siloed environment.

09:07And because of that, it makes it really hard to take all these different silos, try to find a way to bring them together...

09:14...crosscut it, and see if perhaps we might learn some new insights and understanding about all this information.

09:20And that's what UPlan does.

09:22In fact, this is UPlan.

09:27And what you see on the screen is UPlan built into ArcGIS Online technology.

09:33And let's look at this enterprise map and explore a few layers.

09:39We'll open up the contents.

09:42And this is all of UDOT's projects across the state.

09:46Initially, this information was in a very inaccessible custom application, very hard to get at.

09:53Today, it's not only in a live map, it's updated automatically every night.

10:03This is our long-range plan.

10:06We used to labor endlessly to create this wonderful, beautiful document that absolutely nobody read.

10:13It was irrelevant.

10:15Today, here it is in a live map, but really the most important thing is it gave us the opportunity to engage...

10:22...our other planning partners in a way that we could collaborate and share their maps in the same environment.

10:33This is our Safety Division's map.

10:36Again, this is another example of one of these custom applications, highly inaccessible.

10:42Now you see it in a live map.

10:46And, while I just showed you three maps, there are literally hundreds if not thousands of maps coming up...

10:52...through our organization and into UPlan.

10:59And for me, these little successes are really quite remarkable.

11:05It wasn't long ago that I used to walk around with one of these and I would spend a lot of time...

11:10...going and finding information.

11:12What if we needed traffic data?

11:14I'd have to take this flash drive, walk over to our traffic guy, ask him--well, actually, beg him...

11:20...to download the data, so I could then take that data, walk over to our GIS analyst...

11:25...have him download it, and then upload it into a map.

11:30UPlan is changing the discussion.

11:33Now, I'd like to introduce somebody to you who's been very key to the development and deployment of UPlan.

11:39He's UDOT's GIS manager, and we all like to call him UPlan's hero.

11:45Help me welcome Frank Pisani.

11:53Thanks, John.

11:56As GIS manager, I am essentially a service provider to my organization.

12:01It is my job to make sure our spatial data is available and authoritative.

12:07ArcGIS Online is changing the way I'm able to support my department.

12:11The ability to rapidly publish web content has extended the value and capability of my GIS section.

12:19It's also changing the way people are thinking about maps.

12:25No longer at UDOT are we satisfying map requests with just static PDFs.

12:29Our users are beginning to expect a link to a live, dynamic web map in their in-box.

12:36Now, I'd like to show you a few more examples of how we're using ArcGIS Online.

12:40First of all, this home screen has become a great gathering place for our users.

12:45The ability to focus content has been a valuable way for us to engage our casual users in these environments.

12:55This is a sample of our group structure.

12:58Our groups mirror the way we operate at UDOT.

13:01This top group is a group focused on a specific planning study on Interstate 15.

13:08This group was created to support an interagency coordination effort around emergency management.

13:17And this group is for a specific management unit at UDOT, our Region 3.

13:22Now, groups are great, because historically I had to be the gatekeeper to all web publishing.

13:29Now with ArcGIS Online, I can empower my users to manage and deliver their own content in an organized way.

13:37We've also used groups as a venue with which we share sensitive content around UDOT and also have promoted...

13:43...content throughout the UPlan community with groups.

13:49I'm opening a web application that's a visualization of another effort under UPlan, and that's our planning...

13:55...and environmental linkage effort, or PEL.

13:59This PEL effort is to evaluate the environmental impacts of a project early on in a project life cycle.

14:06And you're seeing in this web application two maps.

14:09The map on the left is of sensitive environmental resources from various state agencies in Utah.

14:16And the map on the right is our 20-year long-range transportation plan projects that John showed earlier in the enterprise map.

14:23What's important about this is it's helping us share our data in context with other agencies' data.

14:29And that's the whole goal of UPlan, that collaboration.

14:33What's also great about this is, this is highly detailed data.

14:37There's a lot of data in this map, and previously, John had to look over my shoulder as I operated...

14:42...ArcGIS Desktop to get to this information.

14:46Now, with this simple web application template, I'm taking that end-user functionality of GIS and putting it...

14:52...in the hands of the nonuser, and it's highly accessible.

14:56Everyone has access to this information.

15:02This is a PEL report.

15:04This takes our environmental screening one step further.

15:07This is a dense report of a variety of data from many different state agencies.

15:13This report was created at the Desktop level using geoprocessing and Python and then attached...

15:19...to each individual project geometry.

15:23What's great about this is that this report is now highly available.

15:27It's easily accessible in the spatial environment that our users have become fond of.

15:34In closing, as GIS manager, I found at UDOT that our employees were already starting to use ArcGIS Online on their own.

15:42So, with our UPlan organization, it's allowed me to focus the platform and make it a more valuable tool for UDOT.

15:52Bottom line, ArcGIS Online is changing my workflow.

15:56It's changing the workflow of the planning process, and it's changing the way we collaborate in Utah.

16:01Thanks, John.

16:02Thank you, Frank.

16:11Recently, senior leaders at UDOT came to Frank and asked for a very important map with very specific...

16:18...information about projects all around the state to be built.

16:22And of course, they needed it right away.

16:25So Frank and his team got busy, made this wonderful map, turned it around faster than anybody had expected.

16:33And the neat thing happened when our senior leaders, by themselves, used that map, this is a live map...

16:40...and gave information to our transportation commission.

16:45A few days later, those same senior leaders, again with this live map, presented to members of our state legislature.

16:53And that's what UPlan is really all about.

16:55It's a place where we can start to bring information together so that we can all begin to collaborate...

17:02...with a wide range of users, GIS users and nonusers.

17:07And it helps to make us all more relevant, more efficient, and more agile.

17:12Thank you very much.

17:22Thanks, John and Frank; that was awesome.

17:24I think we can all be inspired by what they've accomplished and how they've changed the discussion.

17:29Thank you very much.

17:36Now, John and Frank have been kind enough to invite myself and a few of my colleagues into their UPlan organization.

17:43In this next section, what we'd like to do is highlight some other capabilities of ArcGIS Online...

17:49...as well as showcase some new features.

17:52Now, one of the challenges that we face as GIS professionals is making our information more available.

17:59ArcGIS Online makes that easy.

18:02To show us how that works, please welcome Jeremiah Lindemann.

18:11Thanks, Bernie.

18:13Frank mentioned previously how he oftentimes had to play the role of gatekeeper to web publishing.

18:18And I think many of us can relate to being on one side or the other of that fence.

18:22If you administer servers, you're usually worried about space or simply don't have time to grant...

18:26...permissions to publish everyone's content.

18:29Those of us as GIS analysts would agree, we're usually lucky if we do get our content published.

18:34To make things even more complicated, if my boss comes to me in the morning and asks me for...

18:38...a map by the end of the day, and my server administrator leaves early, my map is probably...

18:42...never going to make its way to the web.

18:45So let me take you through a real problem that UDOT was faced with.

18:50Last October there was a massive landslide that took out a large portion of Highway 14.

18:56As we can see from the photos, the destruction is really overwhelming, and this is a priority project.

19:02What we're looking at now is a map of the planned construction area, and in the middle is where the landslide occurred.

19:09Now often as GIS analysts we're asked to make maps very quickly.

19:13I'm going to make a map of at-risk areas where rocks still may fall during construction.

19:19I have data to support this analysis; for instance, areas of expansive soils where rocks may fall.

19:27We also know that topography is very rugged in this area.

19:30This is a slope map so we can see where those high slopes are.

19:35This data can be extracted and analyzed via model to derive the results.

19:41Now I'm not going to run the whole model but just the last part.

19:47What I now see in orange are my at-risk areas where rocks may be prone to fall during construction.

19:54Now traditionally this is where sharing my map would start to slow down.

19:58And I'd probably resort to making a PDF that could be printed to give them to construction crews.

20:04But now, all I have to do is sign in to ArcGIS Online.

20:09Note I'm signing in to UPlan, the same ArcGIS Online organization Frank and John were accessing via a web browser.

20:18I'm only interested in sharing the at-risk areas where the construction is and the landslide.

20:26Once signed in, I can share my map as an online hosted service.

20:34Now I've many options to choose from for how I want my service to be configured.

20:38For instance, at what levels of detail do I want caching to be enabled to deliver my map quicker?

20:44I've documented my map really well; all this information will also get carried along with the service.

20:53I also get to choose who has access to the map--securely, to those members inside my organization...

20:58...the general public; or specific working groups.

21:03I'm publishing the map service to the Landslide Hazards working group.

21:06So any person that's a member of that group will be able to automatically find my service and not have to search for it.

21:13So what's occurring right here is all the content for my map is being extracted into a service definition.

21:20It's really nice because I don't have to worry about whether the data's in SDE servers or file-based data on my machine.

21:24Everything is going to the cloud automatically for me.

21:28It's also going to start the process of building tiles in the cloud as well.

21:33Service has been created, so let's go access it.

21:38When published, I published it to the Landslide Hazards working group.

21:45Any person that's a member of this group automatically sees the map that I just created today.

21:50We can take a look at the details.

21:52All my map documentation gets carried along with the service, including any links to metadata I may have included.

22:00Now it says it's in the process of building tiles right now which I can still access.

22:04And for this small geographic area, this will probably only take another minute or two, but let me back up...

22:09...to one that I've already created.

22:14Now the content that I'm responsible for can be in the hands of anyone.

22:19When this becomes really powerful, though, is when you can add additional content to your map.

22:25Remember, my map is a map of at-risk areas where rocks may fall.

22:29I know that my organization has also published Landslide Potential.

22:37What we now see is a multihazard map of where rocks may fall and potential for landslides.

22:44This area right here looks really suspicious because it's both in the hazard area for landslides...

22:49...falling rocks, and right next to where that massive landslide occurred last October.

22:54I want to make sure construction crews are aware of this.

22:59So let's make a markup on the map.

23:12While in the field we want them to watch for future erosion, and that will appear in a pop-up.

23:20So this all occurred really quickly.

23:21So let's think about what just happened.

23:24Without ArcGIS Online, this project with a quick turnaround time probably never would have made its way to the web.

23:30My data and analysis went from my desktop to the cloud in less than a few minutes.

23:35Quicker than I could have sent my map to the printer.

23:38Back to you, Bernie.

23:47Jeremiah has shown us something very powerful.

23:50He's used ArcGIS Desktop, the same software that most of us use every day, and he's authored...

23:57...and published a map directly to the cloud.

24:01He has taken data from his workstation and turned that into a highly usable web map.

24:07And earlier Jack talked about web maps and their importance.

24:11Web maps, ArcGIS Online web maps, are more than just a map and a browser.

24:17To the Esri development teams, they're a specification that enables their use in many different applications...

24:25...on many different platforms, and on many different devices.

24:28To us, they're information building blocks that we can assemble and configure so that others...

24:35...can also work with these maps.

24:37So let's build upon the map that Jeremiah just created and do more with it.

24:42Back to you, Jeremiah.

24:45Thanks, Bernie.

24:48What I'm now doing is saving a web map.

24:52Saving a web map will allow me to share it in more meaningful ways.

25:00Once I've saved my web map, I can choose who has access to it.

25:03I can share a simple map to the link that we have been looking at, share via social media, and also make web applications.

25:10Let's take a look at the first template we provide.

25:15Now, these are configurable templates, meaning you get to choose what tools appear on the interface...

25:21...and the overall look and feel of the application.

25:24More importantly, these applications can be hosted in the cloud, meaning I don't have to download a bunch of code...

25:30...and then go find a web server to place it on.

25:32Everything's in the cloud for me.

25:35Now recently, we've added several additional templates.

25:39Many of them will help you tell a story of what you want to convey.

25:43I've already configured one of these.

25:46Oftentimes when someone asks you for a map, they're not asking just for a map.

25:51They're asking for a way to convey answers to certain questions.

25:55So now what we're doing is we're providing a map, but we're also unfolding the story of the landslide that happened...

26:02...hazards and that risk in the area, and important work that UDOT is doing to repair the road.

26:11So I've been accessing the web map in a couple of different templates we provide.

26:15But the web map is not just for web browsers.

26:17It can be accessed anywhere, as Jack described.

26:20So now I'd like to take the same web map and access it on my mobile device.

26:27I'm going to use the ArcGIS app on my iPhone, and note I can access the UPlan ArcGIS Online...

26:33...organization we've been utilizing all morning.

26:36I can say Favorite Maps, and now the same content that was on my desktop a few minutes ago...

26:43...is readily available at my fingertips.

26:45Construction crews can use a GPS on their device to examine those at-risk areas.

27:07The example of Highway 14 and the landslides is just one of many construction projects that UDOT is working on.

27:14In reality, each construction project has a story, whether it's expanding lanes due to high traffic...

27:20...or repaving deteriorating roads.

27:23I can take a series of maps now and, with the new capabilities of ArcGIS Online, share them all at once.

27:30I can take all these maps, make a centralized gallery application, one central location where all my maps can be found.

27:40Again, this application is hosted in the cloud for me.

27:47Likewise, if I have an existing website, I can take those same maps, choose how I want them to appear...

27:53...in the website, copy this code to give to my web developer, and the result is this--a much more...

28:02...transparent view as to how UDOT is spending its money.

28:06When someone comes to this website, they get more of an immediate sense as to how each project may impact them.

28:14So in summary, as GIS professionals we've always had a challenge in sharing our work with our...

28:20...colleagues or the general public.

28:23With ArcGIS Online, finally I can contribute my content quickly to anyone.

28:28As a result, I'm instrumental in not just sharing my work but representing my whole organization.

28:34Back to you, Bernie.

28:43Jeremiah has shown us the power of a web map and how easily we can do some very interesting things...

28:48...with it through configurable applications.

28:51A web map is also the geographic platform that can empower others.

28:56It can empower other people in our organization--not just the GIS department, but others in our organization...

29:03...can build upon our work to accomplish their own work.

29:08This is all about self-service mapping, and to show us how all this comes together, please welcome Tom Murray.

29:16Thank you, Bernie.

29:17Thank you.

29:20So, when I got back to the office, I had a note from my boss that said, "Tom, I need you to create a map...

29:26"...that shows our projected construction and maintenance costs for all of our airports for the next 20 years.

29:33"And I need this information on our public website as soon as possible."


29:39Well, it sounds like there was a big directors' meeting or some event this morning that triggered it.

29:42But I hadn't planned on creating this map, let alone a web application, today.

29:47But let's see how quickly we can knock it out.

29:49Now, I know that UPlan is a great place to start, and we have an existing map that's focused...

29:54...on the current pavement conditions.

29:56So I'll use this as my starting point.

29:58I'll just turn this off for a second.

30:01And now, let's take a look at the data my boss sent me.



30:08Well, that's kind of a mess.

30:11I don't even really want to deal with that, so I'm just going to take this file and drag and drop it on my map.

30:17Yeah, that's better.

30:21So my points are there and so are the attributes.

30:25And now I can just work on changing the symbols and configuring the pop-ups.

30:30So, changing the symbols is easy and we have plenty of airplanes to choose from.

30:35But I also want to size them proportionally, based upon a field in my table, such as total cost.

30:43And let's just go and choose like the airplane that I like to use.

30:49There we are.

30:50And I'll set the starting size.

30:55Okay, that's better.

30:57So we can tell from our map that we'll have a lot of construction money being spent up in the greater...

31:01...Salt Lake/Provo/Ogden area.

31:04We also have a big project down by St. George where they're building a new airport.

31:08And that's good.

31:10So, with the symbols taken care of, I can work on configuring the pop-up.

31:15Now, through the pop-up dialog, we can add rich content, such as images and hyperlinks and other media.

31:23And I can also choose to display just the attributes that help tell my story.

31:28So I have the name, kind of aircraft activity, total cost, and I do want to get my links.

31:35Now, we can also add additional content, such as media, such as like simple charts and graphs.

31:42So I want to create a pie chart that's focused on another set of attributes from my data.

31:48And once I get the title and details taken care of, I'm going to select the 1-to-5-year, 6-to-10, and 11-to-20-year costs.

31:58And again, I want to normalize this by the total cost.


32:04So we'll save the pop-up, and we'll zoom back in to the Provo Airport and take a look at the results.

32:12So now, instead of just a list of attributes, my pop-up contains an image, some descriptive information...

32:18...as well as a nice chart that helps explain how this airport is going to spend nearly $20 million...

32:23...over the next 20 years, which is great.

32:27So, I'll add my pavement condition layer back on just to make the map feel a little better, and I'm going to save it...

32:37...and I'll share it back, share it to my group; I can share it to my whole organization.

32:43But remember, since my boss wants this map to be on our public website, I need to make sure that I share it with everyone.

32:49Oh, that reminds me.

32:50The final part of my task is to click on the embedded website and add the functionality that I like.

32:58And now I can just copy and send this code to our web team to have it included in our public page.

33:05So let's take a look at the final result.

33:07Here's our public website and here's our embedded map.

33:12Now, if I just zoom back in to the Provo area, you'll see that this map behaves just the same way...

33:22...as it did in ArcGIS Online in my embedded map.

33:36So in summary, what I've done is create a simple, intelligent web map.

33:43I've embedded it in our organization and made it available to the public.

33:48What used to take me hours I finished in less than five minutes, and now I'm ready to continue on with my day.

33:55Thank you.

34:03So Tom has shown us the power of self-service mapping, how others in our organization can be empowered...

34:09...through ArcGIS Online to accomplish their own work.

34:13He's also shown us how easy it is to take data and transform that into much more meaningful information.

34:21But there's more.

34:23ArcGIS Online enables us to put mapping into everybody's office, and that's done using a brand-new...

34:29...part of ArcGIS Online called Esri Maps for Office.

34:33Now this was just released a couple of days ago, and I'm sure when you see it, you'll understand...

34:39...how it can change the way that we work by extending the reach of GIS into other parts of our organization.

34:47To provide the grand tour of Esri Maps for Office, please welcome Nathan Bennett.

34:54Thanks, Bernie.

34:56Imagine I'm a spreadsheet user.

34:58Here's a spreadsheet of highway construction projects by funding.

35:02So, where are funds being spent?

35:05It's pretty hard to tell looking at all this information in rows and columns.

35:08Now, we know a map is a much better way to answer a question like this.

35:13So what are our options?

35:14Well, Tom just showed us how we can map a table in the browser.

35:17That's a good option.

35:19And there's always ArcGIS for Desktop.

35:21ArcMap, after all, is the best mapping tool out there for GIS users.

35:26But what about everyone else?

35:28There should be an easier way.

35:30In an ideal world, someone can map their spreadsheet right inside Excel.

35:38This is Esri Map for Office, a new ribbon group added to Excel full of tools to help you map your spreadsheets.

35:47Imagine if you could put a focused mapping tool like this in the hands of all your Excel users.

35:54Well, now you can, because this is part of ArcGIS Online.

35:59Let me show you just how easy it is to map your spreadsheets in Excel.

36:05Here's another view of highway projects.

36:07This time, by expense.

36:10Now in Excel, adding a map is as easy as adding a chart.

36:17Now most spreadsheets contain some sort of location information, and you can take advantage of the addresses...

36:24...the coordinates, and the places that already exist in your data.

36:31So here the projects have been added to the map and they're being represented with a technique called clustering...

36:36...which is a really smart way to work with dense data.

36:39Projects close together are snapped and represented by a single symbol.

36:44Heat maps are also great for dense data and can be added right from the ribbon.

36:49Now, it's really that easy to map your spreadsheets in Excel, but we can do more.

36:55Seeing the individual locations of projects is helpful for understanding where construction is happening...

37:01...but how does expense vary across the state?

37:04Well, because each project is tagged with its UDOT region we can use Excel to aggregate this information in a Pivot table.

37:13You can join your data to common geographies like country, state, and postal code, right out of the box...

37:21...but users can also add their own locations, their own custom geographies like, in this case, UDOT regions.

37:35And once the regions are added to the map, they can be symbolized with a single color or with a color ramp.

37:49So now that we have our regions added to the map, we can see that Region 3 in the center of the state...

37:54...has the highest level of expense.

38:05Now there's a lot of Utah data already shared on ArcGIS Online, and Excel users have access to all of it.

38:13So, for example, we could search in my organization for traffic cameras.

38:18Here's a traffic camera service and we can add it to our map.

38:23Now traffic cameras are really relevant to construction, because some of these cameras actually have a...

38:29...view of proposed, in progress, and completed construction projects.

38:41So in just a few moments we were able to create a really interesting map, and because Excel is now a client...

38:50...to the ArcGIS system, this map can also be shared as hosted web services on ArcGIS Online...

38:57...and shared with the rest of the organization.

39:03Now we can also share this map in PowerPoint.

39:11So here we have PowerPoint on the left and Excel on the right.

39:16Now like spreadsheets, most presentations can benefit from the perspective a map provides.

39:22And now in Excel, on the Esri Maps ribbon, there's a Create Slide button.

39:28With a single click, maps embedded in our existing presentations.

39:40Now PowerPoint also has its own Esri Maps ribbon, and that lets users create slides of any map shared on ArcGIS Online.

39:52So again, we can search in my organization for an expense map that's already been published...

40:00...and we can preview this map, we can configure the layers, we can quickly add a legend to provide...

40:06...some context for our audience, and create a map slide.

40:12So let's take a look at our finished presentation.

40:16This is a presentation about construction project expense.

40:19Here are some regional statistics, and here is a view of some projects that are happening around Utah Lake...

40:25...and here's one more at a local scale.

40:28And finally, we have expense by region.

40:31Did you notice the Play button?

40:34Makes this map very special.

40:37When pressed, this map transforms into a live, interactive map.

40:52Now we can explore all the highway construction projects in Utah, right from our running PowerPoint presentation.

41:02This is Esri Maps for Office.


41:14It's remarkable, isn't it?

41:17When you think about this, in a typical organization, there's not many of us GIS professionals...

41:22...and there's many more Microsoft Office users.

41:26Now all of those people can be empowered with GIS and they can use it in familiar applications...

41:32...and also familiar workflows.

41:35And, more importantly, they can take the maps that they make and contribute back to the organization...

41:41...and be a part of the ArcGIS Online ecosystem.

41:45I think this is really amazing and will be really transformational for many of us.

41:50Now we've shown you lots of different ways to create and share maps, and all of what we've shown you...

41:55...has been accomplished using ready-to-use, out-of-the-box capabilities or by using easily configurable...

42:02...applications that don't require programming.

42:05But ArcGIS Online is also open and it has an API.

42:09And using that API, we can build custom applications that leverage native SDKs.

42:15Like this application I have here on my iPad.

42:20Now as I open this application, it connects to one of the UPlan groups.

42:26And see, it has this very interesting user interface where I can turn the pages.

42:32It's like a digital briefing book, and you'll recognize many of the same maps that we've used here today.

42:39In fact, here's the map that Tom just created a few moments ago.

42:45What's really interesting about this is that devices like the iPad and other tablets are the ways that executives...

42:53...stay in touch with the information that they need.

42:56This is how they stay in contact with what they need to know.

42:59And now using ArcGIS Online, and applications like you've just seen, we can deliver GIS to those that...

43:06...need it most--the executives and the managers that can be empowered through our work to make...

43:13...better and more informed decisions.

43:16So now I'd like to return control of the UPlan organization back to our good friends at UDOT...

43:22...and I'd like to welcome back to our stage John Thomas.

43:32We all remember these days--static maps, hard-to-get-at information, very little interaction.

43:40You all get this.

43:44And isn't it great to think about this bright future ahead of us, where all of us get to learn and understand...

43:51...where technologies like GIS Online can take us.

43:56Thank you.

44:04Thank you, John.

44:05Thank you.

44:06Pretty cool, huh?

44:07I should work for this guy.

44:09It's really good.

44:10What are you going to do next?

44:12Well, the next big thing for UPlan starts next month.

44:15We get to kick off a 10-state pilot project using ArcGIS Online as the platform and build a UPlan-type...

44:21...site for each of the 10 states.

44:24There's a tremendous amount of excitement around this.

44:26Started in Utah.

44:28Starting with ArcGIS Online!

44:31So you're going to do kind of like what Jackie did for the environmental data...


44:36...just start to share it around!

44:37Yes. Okay. Great.

44:38We didn't actually practice this so I'm a little nervous. I'm going to let you go.

44:43Thank you.

44:45It's great.

44:48You get kind of a sense of what's going on here, this notion that ArcGIS Online could actually open it up.

44:56It isn't something that invalidates all the good work that you have done.

45:00It doesn't disconnect all the work that you've done.

45:05All of the desktop- and server-based knowledge gets integrated through the online platform into these...

45:12...pervasive devices that make it a platform everywhere, for everyone.

45:17So let me just conclude all of that great presentation with this.

45:22ArcGIS is a platform for your entire organization.

45:28That takes a little getting used to.

45:31It took some time for me to get used to the notion.

45:33That means it integrates with everything, like ERP, all the business systems, CAD systems...

45:39...and also connects or involves everyone.

45:43That's pretty interesting, because it means it will amplify geography and let everybody play.

45:52And you, as professionals, will be the sort of center of this, making it come alive.

Copyright 2016 Esri
Auto Scroll (on)Enable or disable the automatic scrolling of the transcript text when the video is playing. You can save this option if you login


No comments. Be the first to write one below.

Comment on this Video