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: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: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: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: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: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: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.
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: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.
44:04Thank you, John.
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: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.