GEOG 583
Geospatial System Analysis and Design

Video Demonstration

Video Demonstration

An offshoot of the more traditional white paper is the video demonstration. Video demos (alternatively called webinars, webcasts, podcasts, etc...) are becoming much more popular now that recording and streaming video feeds from presentations is fairly simple and efficient. They're also very effective ways to show dynamic content. This is good since so much GIS now is highly interactive, web-based, and visually enabled.

I'd like you to take a look at two video demonstrations focused on similar content. First, I've picked a video from Esri on its Insights platform for ArcGIS. This is a detailed video (56:07) that goes over how to actually do things with their tools. No, you do not need to watch the whole thing... :) 

As you view the videos, think about differences in presentation style, topics emphasized, the general visions of the future for GIS/mapping, overall similarities and differences in the videos, and/or any connections you see with other material from class, with things you have read/seen about changing technology, or with your own work.

These demonstrations are showcasing new geospatial features that may be relevant to your project. You may also want to explore additional video demonstrations of features that are relevant to your project and include those as resources in your proposal. 

Video: ArcGIS Insights - An Introduction (56:07)

Click for a transcript of ArcGIS Insights: An Introduction.

SCOTT BALL: So you are here today to see ArcGIS Maps for Office-- An Introduction. That's what we're going to be talking about today. If you're looking for a different session, you may want to leave now. But we've got some content for you. We're going to tell you a little bit about what this ArcGIS Maps for Office thing is. My name is Scott Ball. I'm going to be helped out by DJ Berry.

DJ BERRY: Hello.

SCOTT BALL: Yep, and so let's go ahead and get into this thing. Today, we're going to be talking about what is Maps for Office, going to give you a high level overview of what the thing is. It is an app that works with ArcGIS. And so we're going to start at the high level, give you a platform overview of what ArcGIS is, what Apps for the Office are, because Maps for Office is an App for the Office. So we're going to tell you what that is.

And then we're going to run through some of the Maps for Office features, what you can do with it, and give you some demos. At the end, we'll give you some additional resources and some ways that you can get involved and help us out with testing and help us out with figuring out exactly how the product should work because we're always doing testing. And so this is a great way for you to get involved and help us out by testing some of our designs and get a sneak peek at some of the stuff that's coming down the road.

So that being said, Maps for Office is included with ArcGIS Online and ArcGIS Enterprise subscriptions. So if you have a name user, you can just download Maps for Office. It plugs into Excel and PowerPoint. And once you sign in with your name user credentials, you can start using the Excel features and the PowerPoint features that we add into those pieces of software. It's all centered around the ArcGIS cloud.

So it's about using the services on ArcGIS to geocode addresses that might be in your spreadsheets or share things up to ArcGIS so other people in your organization can use those things. And then you can also pull things down, pull map services and map layers down into PowerPoint so that you can present dynamic and interactive maps. So that's kind of the overview of what Maps for Office is and what we can do for your organization. So the first thing, I want to take a look at this. So I'm going to switch over to DJ. And he's going to show you how this thing works.

DJ BERRY: All right. So let's just say I've been working in my spreadsheet, just got the new sales figures in. And now, I want to put it on a map. So I come up here to the Excel ribbon. Click Add Map. And it starts to load the program, gets us started here. And then it immediately brings me to the Add Data from Worksheet window. And what is going on right now is it's very quickly looking over my data and picking out what it thinks I'll want to show on the map. So it already recognized what table I was working in. It saw that I have a Zip Codes.

But in this case, I really want addresses. And I can really quickly change that. And it saw that I had a column called Total Sales. Probably wouldn't want to show that on the map. And it picked a render for me already, which is exactly what I wanted. I come down here. Click Add Data. And now it's going through and geocoding my points and very, very quickly adds into the map. If I want to, I can adjust my styling some. In this case, I actually like the way it looks. It shows what I want it to. And I've got a pretty effective map right there.

SCOTT BALL: Cool. So that was a very quick look at what you can do with Maps for Office. As you can see, it doesn't take much time or much skill to be able to get your spreadsheet data on a map very quickly. We tried to bake in smarts so that you don't really have to think about what you need to do. If you have the information that we're looking for that can help you make a really nice map, we just make the map for you, just tell it OK.

So now that we've kind of seen what it is and what it can do, I want to give you some context about how it's doing it and what you need in place to be able to do it. And starting to do that, I need to start with the platform overview. So much like man has evolved over time, so have GISystems. And so in that same way if you look on the left, you'll see the old school GIS.

Old school GIS was a desktop system working with files on that desktop. Over time it progressed into a server-based architecture where a lot of people are today. But we actually have moved past that server-based architecture into web GIS. And that's what ArcGIS Online and ArcGIS Enterprise is, and that's really what you need to use ArcGIS Maps for Office. Because that Web GISystem helps you tie information coming from your desktop, from your web, from devices, brings it all up into your ArcGISystem. You can also use it with server. And you can also use it with online content and services. So it really is kind of this thing that allows you to access all of your GIS resources wherever you are.

One of the things that you can use with this web GIS platform are apps. And so I want to talk a little bit about how we think about apps and how they fit into the ArcGIS platform. So the main things that you want to think about are apps are key products from ArcGIS. And these tend to be very focused on a specific workflow or a specific way of interacting with ArcGIS.

In the case of Maps for Office, we try to make it very easy so that you don't really have to be a GIS expert to be able to make maps, publish maps, and share them with people in your organization. They help people solve problems. Most people, when you think of the word "apps," you think of mobile apps. You think of things that you put on your phone. In Esri land, we think about apps a couple different ways. We think in addition to mobile apps. We also think about desktop apps. We have things like Explorer for ArcGIS. We have a number of different things we consider desktop apps. We also have web apps. Things like ops dashboard or story maps. We have a number of different kinds of apps. So when we talk about apps, we think about all of these things.

And why should you pay attention to apps? If you're a manager in your organization, how many managers do you have in the audience? Pretty good amount. The reason that you should care about apps is because they allow you to leverage the full potential of your GIS investment. You've spent a lot of money, most likely, on this GISystem, on this ArcGIS platform. And apps will help you make the most of that investment. It allows you to get more people in your organization involved with your GIS data. It allows you to deploy this web GIS pattern to all different organizations within your organization. And have everybody work with the same authoritative data that, probably, your GIS shop is authoring.

For a GIS analyst, why should you care about this thing or apps in general? It really helps you share your work to other parts of the organization. Again, it gets back to that story of enabling other departments to leverage your geospatial assets that you're creating. It takes your sphere of influence outside of your GIS shop and it puts it across the entire organization. And it allows you to be that curator of authoritative data sets.

So getting back into kind of what type of apps we have, we have them based around four main themes. The first one, and the one that we're going to talk about today, are apps for the office. We also have apps for the field that help your people that are out in the field collect data or pass it back to the office or track the people that are out in the field. We also have community-based apps that allow people, such as constituents in neighborhoods, to access an online GISystem and submit things like complaints about potholes or noise complaints, things like that. Crowd-based GIS are the other category of apps. We also have app builders that allow you and your department and people in your organization to go out there and build your own custom apps that leverage your ArcGIS platform.

So what we're talking about today are apps for the office and there are a number of them, not just Maps for Office. We also have integrations into SharePoint. We have integrations into Power BI. And then we have all these other ones listed here, ArcGIS Earth, City Engine, all tools that will help you accomplish some kind of specific function within your organization. We have a ton of them and the way to learn more is to go to And we have little highlights on each one of them. You can click on them and find out how it might help you kind of deploy this Web GIS pattern into your organization.

That being said, today we're talking about Maps for Office. They really help you visualize, analyze, share, and present information coming from either your spreadsheets or taking information from your ArcGIS online organization and bringing it into PowerPoint so that you can have these dynamic interactive maps that you can show to your stakeholders. So I like to include this one because traditionally, GIS has lived in a few small places within the organization.

It gets back to that theme I was talking about earlier, where with web GIS and with Excel, because everybody's desktop throughout the organization has Excel, if you plug in ArcGIS Maps for Office into that, then you can get your GIS content outside of those two little boxes that traditional GIS hold across the entire organization. So you can have managers and executives and whoever viewing your maps and reports showing real-time status updates of whatever is going on in your organization.

This is one of my favorite slides. Because it kind of shows that relationship between a GIS professional in an organization and somebody else in your organization that wants to make a map. Your GIS professional is really thinking about complex things like crigging. Or they might be thinking about coordinate systems. Or they might be thinking about the best way to deploy GIS data to the organization. But then you have a scientist or an analyst or a salesperson that says, hey I have this spreadsheet and I want to make a map with it. Can you help me. I don't know how to do that.

I think this is-- it cracked me up, not 30 minutes ago I was down at the island and a guy came up and started telling me this story. And I said I have a session in 30 minutes. If you just go upstairs, I have a slide that talks exactly to what you're talking about. Because it usually is such a pain in the butt. Because these people come and take up my time while I'm trying to do this, and they're just wanting these simple maps and it becomes this iterative process where I'll make the map and then they want something changed and I'll make the change and that makes them see something else that they want changed. And it's just this big time suck of going back and forth. Where if you plug in Maps for Office into their Excel spreadsheet and let them do the basics themselves, it really gives you some better return on investment by allowing your GIS professional to focus on GIS stuff. It allows your salesperson or scientist or analyst to focus on what they're trying to do. So that's one of the benefits of Maps for Office.

So I've talked a lot about stuff that isn't Maps for Office itself, but now I want to get in to talking about what can Maps for Office do, the actual features the actual functions that it can do for your organization. It can help you quickly make better decisions and communicate them out. As you saw with DJ's demo earlier, what we have internally, we call Quick Maps. And so what Quick Maps does is that first box on the left. And it looks at your spreadsheet. It tries to figure out what kind of data you're working with, what fields are there, what data types are there. And then as DJ mentioned, we try to pick the best renderer for you, so that you don't have to be a cartographic expert to get a really nice-looking map.

And so as DJ showed, it picked the one that made the most sense for the data he was working with. It picked that one by default. And then all you have to do is hit add data. If you want something different, you can do something different. And it gives you little thumbnail views of what those different types of maps you could select are. But you don't have to select something different. You can just go with a recommendation and say add data and go forward.

In the middle I've shown a very miniature view of what our styling options look like. Based on the renderer that you choose in that first step, you'll have different styling options on how you want your map to look. We don't necessarily expect that a lot of non-GIS people are going to spend a lot of time here. But if you really do want to tweak how your map looks, the color, the size of the circles, the outline width, the colors of the fill and the outline, all of that twiddly stuff, you can do that here as well. And I always include the density map or heat map visualization because most people that are non-GIS people, that's the first map that they look for. And so I want to make sure that you know that you can make these density maps if you want to.

You can also put your data in context with the world. And what I mean by that is Maps for Office leverages geoenrichment services. How many people are familiar with geoenrichment services? Do you know what those are? Not a person. So that's a good time for me to step back and talk about geoenrichment services.

So GE services are things that allow-- it's a service provided by Esri. We have tons of demographic information about places all over the world. And so we categorize that demographic spending and consumer spending data into different categories. And that's kind of what I'm showing you right here. And so what we allow you to do within Maps for Office is take advantage of that demographic information in a number of different ways so that you can augment your spreadsheet data. So you're not just mapping your spreadsheet data, you can also bring in all this information that Esri has in our geoenrichment services to add more information to your spreadsheets.

So this is a pretty powerful thing. It's sometimes an overlooked thing that people that use Maps for Office, they just use it for that simple mapping stuff. This is a really powerful tool, just so you know, it's called, what? Data enrichment? Yeah. Enriched data is one of the ways to do it. And that's what you're looking at here on the screen. And so you can pick your data collection, such as key facts or wealth or policy. And that will drill you into more variables. That will allow you to pick the exact variables that you may want to add into your spreadsheet.

So it will actually, once you've mapped your points, each point is essentially a row in your spreadsheet, it can add information. So it can add another column to your spreadsheet with the demographic information for the area around that point. So it's a really powerful thing. You can get entirely new information and add it into your spreadsheet and then map based on that. It's pretty cool. I think we have a demo coming up to show you a little bit more about it.

Another way to use that geoenrichment service that we have in the back end is by using simple popups. So in the popups that you might normally be familiar with on our GIS, you click it, it'll show you all of your attribute information in the popup. Well within Maps for Office we also have another little tab that allows you to show tapestry segmentation. Or some other kind of infographics that we expose within Maps for Office. But this is really cool. Have you guys seen tapestry segmentation before?

This is a really cool thing as well. Because it tells you what kind of people live near the area that you're looking at. So if you click on a point and then you switch over to the infographics tab you'll get this tapestry segmentation information. And what we've done is we've grouped all of the people, definitely in the US, we might have a global tapestry as well, I'm not sure. But definitely within the US, we've kind of classified people into 60, 65 different kinds of communities. And so what we'll do when we show you this tapestry segmentation is we'll show you the kind of community or the kind of people that live in the area that you're looking at. And so we'll show you the top three tapestry segmentations and the percentage of people that fall within that. So just by clicking on the point, clicking on infographics you'll see the kind of people that live in that area. It's pretty neat stuff.

We also expose geoenrichment services through standard reporting. And so you can create these reports if you wanted to compare apples to apples about two different sites. Let's say you have-- you're trying to find a lease for a retail store or something. And you want to compare all the demographics around two different areas. You can create a report for Site A, you can create a report for Site B, and then just compare apples to apples to see what those communities look like and see what those areas look like using these reports. That's also accessible through the popup for each one of your little points.

So that being said, I know that just talking through it is a little bit confusing. So let's take a look at it and see how it actually works with a demo.

DJ BERRY: Mm-hmm. Yeah this next demo is pretty cool because it was actually sent to us by a user. Basically, we're going to be able to see what you can actually use our geoenrichment services for. And it's a very, very quick way to do some visual analysis and figure out where there may be some underperforming areas. So in this case, they were a company that specializes in home appliances. And this map here shows all of the retailers that sold those home appliances and the amount of sales they were generating at each retail location. And the company wanted to figure out, OK which of these retailers could use a little help, maybe a little extra motivation. Are they underperforming?

So what they did was they created this map showing retailer sales of their appliances. And at that point they needed some data on the local spending habits. So they came in here to enrich data. And they could come in here and look at all these different variables. In this case they knew exactly what they wanted, which was major appliances. And you can see here you get a whole bunch of different variables under major appliances. We're going to keep it simple here, just 2017 major appliances average.

And then I can come in here and say, OK, you know maybe I want a two-mile circle around each location. It gives me an idea of, OK, how many credits it might cost. And because I'm using a table here, I'm going to enrich my data and it's going to add a new column in my spreadsheet with this data. So that's actually exactly what I want to do. I click add data to system. And right now it's reaching out to Esri services, sending them the location information and returning demographic info on the people around each retail location. And right now it's adding it to the spreadsheet. And there you go. You can see here, we've got a brand new column with demographic data in it. That's not quite enough, though. I wanted to be able to get some actionable data here. So what I'm going to do is, I'm going to create another layer. Well, copy this layer as soon as it lets me. Here we go. And I'm going to choose that new demographic information. And I'm going to style it here very, very quickly using some of those styling tools we talked about earlier. I'll go with red, and I'm really not feeling an outline at the moment, so no outline. OK, and then I can send this to the back.

And just like that, you can pan and zoom and see anywhere where you see red, is a place where consumer spending is arguably, you know, a little bit higher than what you'd expect to our major appliance sales are. And it's very, very quick. It's not the most scientific approach, but it gives you some very quick actionable information. And then you can come through here and say, oh you know I'd really like to do a little more analysis, too. So I can arrange my maps and use some of these filtering tools to say, OK I just want to see this particular retailer. And it'll actually filter the map to just those retailers as well.

So there you go. You can bring more data into your spreadsheet that gives you information on local demographics and spending habits. You can very quickly create a new layer and maybe even create a new map based on that data to get some actionable information. And then perform some basic analysis with it.

SCOTT BALL: Cool. Good work. Looks good DJ. So moving forward, what else can it do? Maps for Office can also help you analyze your spreadsheet Data it can help you do that spatially. It's not going to be a replacement for your hard-core GIS spatial analysis tools, but it can help you do some simple stuff, such as find nearby. So if you have a store in the middle and you have customers all around it and you want to say, show me all of the customers within a 15-minute drive time, you can absolutely do that. And that's what this is showing right here. You could then take those customers that you've made that selection of and either export that to a new spreadsheet or export it to a new workbook, whatever you want to do to further refine and work with that information.

We can also do hot and cold spot analysis. So we're using the hot and cold spot service from RGIS online. And we run your data coming from spreadsheets through that. And we'll return back your hot and cold spot analysis that you can then use for further analysis or share it back to RGIS online or whatever you may want to do.

So we've got another demo, we've got the location analysis demo. Ready for that one?

DJ BERRY: Just about.

All right, so the basic idea behind this one is, you know, Scott and I started a restaurant. And we're looking to start doing deliveries, I think. What kind of food do you want to deliver, Scott?

SCOTT BALL: Let's do Chinese.

DJ BERRY: Chinese, OK. I could go for some Chinese food. And so what you're looking at here is a spreadsheet with a list of leads. And we're interested in picking out those within about five minutes. Because we want to be doing deliveries--

SCOTT BALL: And I'm lazy--

DJ BERRY: We need more than five minutes. You're lazy, I'm unmotivated. It's a really great recipe. So to get an idea of what businesses are within about a five-minute drive time. First because I'm going to be doing some analysis, I want to do that arrange map function again. Then I can come in here and, see this blue dot? That's our actual restaurant location. And right here in the popup, you see this icon? That's the find nearby tool. You click on that. And it brings you to the find nearby pane. And you can choose, OK, whether you want to select features within, you know, a ring. Or in this case, a drive time. You can specify what you want, 10 minutes, 20 minutes. Like I said, we're lazy and unmotivated, five minutes.

We're going to save the search area as a layer. And we're going to search inside this local businesses layer. Click find. And right now, just like that, it's located 58 locations, possible companies we could sell to. Now that's still not quite actionable enough for us. So because we're lazy, I'm going to go ahead and say filter this spreadsheet. And what that does is it hides all of the rows that aren't selected. So as you can see, now we've got this list of businesses we can use. And if we wanted to, we could select the Excel rows and paste them into a Word document or into another spreadsheet and give them to somebody else to go and talk to these companies. We could send them out in an email, a bunch of other things. But just like that we were able to use the find nearby tool to locate features within a certain drive time and then filter our data based on that buffer.

SCOTT BALL: Thanks DJ. So this is pretty handy stuff, right? This is pretty neat spatial analysis stuff that you can give to people that aren't used to being able to use spatial analysis tools. Another thing that you can do with Maps for Office is collaborate with your peers. And so we have a number of different ways that you can share this cool stuff that you've been doing in Maps for Office with other people within your office.

So we have these tools within Maps for Office. The first one is the share map tool. That will take all the layers that you're working with in your table of contents and bundle them up and share them to ArcGIS online. If you just want to share one particular layer, like one particular analysis layer or something that is particularly important, you want to share with a specific person, you just select that and then click on share layer, which is the next button over.

Another thing that you can do is you can create slide. So if you click create slide, it's going to take a snapshot of what you're looking at on your map right now. It's going to open up PowerPoint, create a new slide, and drop that screenshot in. If you want to do your own screenshotting, you can just click on copy map. And that will copy the image of whatever you're looking at on your map right now and copy it to the clipboard. And you can put it wherever you want. For example, you can just paste it into an email and say, hey boss this is where we're seeing hot spots right now, for whatever area we're looking at.

And so this final column that I'm showing over here, this is the sharing dialog pane. So you're going to have to, whenever you share to ArcGIS, you're going to have to give your map or your layer a title. You're going to have to give us some tags. And really importantly down there, I know it's a little small, but you decide who you want to share with as well. And so that's a very important thing, especially in ArcGIS security model. You can share with just people in a specific group. You can share with all of the people in your organization, in your ArcGIS organization. Or, probably the most dangerous one there at the top, is everyone. So if you want everybody in the world to be able to see your information, you can check the everyone.

It can also be used very powerfully. In the past, we've worked with EPA, Environmental Protection Agency. And they use this functionality to map some specific projects that they're working on. And then, once they share that with everyone using that top checkbox, they actually embed that layer inside a little mini map on one of their web pages. So they can update their web page any time just by updating the spreadsheet and clicking update shared layer. It's a pretty cool workflow. It works really well for them. But it can also be something that you need to pay attention to. Because if you don't share with everyone, you don't want to check that box.

And I should also mention that we do integrate into PowerPoint. And so PowerPoint has the same model where you need to add interactive and dynamic maps. You'll need to sign in with your named user account. Once you sign in, you'll be able to browse all of the layers within your organization or all the layers within ArcGIS that you have access to. And build a dynamic map slide that you can then present with. And when somebody has a question as they always do, and the answer is just off to the side of the map that you're looking at within your presentation, you can actually say, hang on a second. And you can go into live mode and actually pan over there and zoom into the area that you're interested in.

DJ BERRY: Bring up popups, too.

SCOTT BALL: Bring up popups, show more information. So to show you that, DJ has another demo to show us sharing and collaboration. You ready for that one?

DJ BERRY: I am ready.

SCOTT BALL: All right, let's go.

DJ BERRY: All right, so you guys remember that analysis we did earlier? Yes, maybe? Hopefully. So we finished the analysis. We're ready to share it with people. So I can come over here to the share. And I'd say, I want to say share map. Did I click on it? Nope. You know what? Let's try this one more time. There we go.

So, you know, as Scott was saying, I can come in here and select who I want to share this with. I want to call this UC 2017 demo 1 exclamation point. I'm going to call this one UC 2017 for my tags. And, in this case, I'm just going to share it here to our little group. Everything looks good. I didn't share it with absolutely everybody, which is OK. Then I click share.

And what this is doing is, it's taking our layers and pushing it up to our ArcGIS online organization, where we can then do a lot of other really cool stuff. Things like, as Scott was saying, bring it into a PowerPoint slide to have an interactive map in PowerPoint. Perhaps creating an operations dashboard with it, which is really cool. Maybe creating a separate application for people to use kind of like what the EPA has done.

What we're going to be doing here is creating a story map with this. Let's see if the internet connection is going to be kind to us today. Aw.

SCOTT BALL: Did it fail?

DJ BERRY: It looks like it failed. Womp-womp waaa. Luckily, I shared it already. All right. So once you share it up, you can come over here to your story maps. You can say, create a rich multimedia narrative. In this case, we want a story map journal. You click build. And I can decide, OK, I want to go have a side panel here. I want to call this DJ'S Really Cool Story Map, type enter.

And now it's going to walk me through the steps to actually create a map. So in this case, I want to select one I already created earlier. So there we go. Location, we're going to do a custom configuration. You can do all this kinds of stuff. But in the end, you can create a story map that looks something like this. And I don't know about you guys, but I read Latin very, very well.

And you can do it so it'll actually pan and zoom the map. You can put in pictures and charts. You can click on different items and have popups appear. It's really cool. And this way, you can tell a story with the analysis you did in Excel. And you can share it out to your entire organization. So this isn't, you know, you can share your Excel workbook and have other people look at it this way. But you're much more empowered than just that, too. You can do a lot of other really cool stuff.

SCOTT BALL: So this is the power of the platform. This is everything working together. This is, you know, why you use apps and why you use ArcGIS. And how you can really bring all of it together and get that return on the investment that you've made. You can create cool story maps. You can share with the world. And start in Excel. Pretty cool stuff. That's it for the demo?

DJ BERRY: That's it for the demo.

SCOTT BALL: Cool. All right, so those are the major features of Maps for Office. It is a pretty simple tool. But it's pretty powerful to kind of enable the people that aren't necessarily GIS natives. This is a lot of text. I'm not going to read through it all. This is also on our documentation site. I just, it looks way more impressive and full if I just put all the text on there.

So those are the things that are new with our last release. I think it was March-ish or April-ish. And so we've added a lot of under the cover, under the hood stuff. Right now, we are working on kind of rebuilding the app from the ground up. And so we don't have any more releases in 2017. We're looking for probably an early to mid 2018 release. And so we're looking at things like the 4.0 version of the JavaScript API. Because, oh yeah, by the way, this entire app is built on the JavaScript API. So it's on the 3x version right now. We're moving up to the 4x version. And we're going to be adding a lot of cool stuff. So next release 2018-ish with a lot of cool new stuff. Oh yeah, do we have a what's new demo?

DJ BERRY: It is loading.


DJ BERRY: There we go.

SCOTT BALL: Yeah. So this is something we kind of threw in at the last minute. We thought, hey, we do have a lot of new stuff as of our last release. So let's take a look at some of those things. They're not necessarily, like, the functionality things that are, like, core to the app. These are things that we've added that we want to show you. Where are the cool new things we made?

DJ BERRY: So you've actually seen a couple of them already. You know the internet connection is still deciding that it doesn't like me, Scott. There we go. So, you've already seen a couple of them. So the add data dialogue was completely revamped, so it was a lot cleaner, a lot easier to use. You saw the styling side pane. It's actually kind of designed now. Before, we kind of just put things in there. Then we brought in our designer. And he had a heart attack. And once we revived him, he was able to add some new actual design to it so it makes sense.

This is not loading currently.

We've also added some really, really cool features. So in the past, functions wouldn't update the map. So if you had a column here and then it chained out to a variable or something somewhere else in your spreadsheet, and you updated that variable, your table would update and the map would stay the same. We got annoyed with that, too. And so we fixed it. So you come in here. And your map should update as soon as it finishes loading. I probably should start paying attention to loading bars.

SCOTT BALL: So that's actually a big ask. A lot of people were reporting the fact that they had indirect references within their spreadsheets and those indirect references were not updating the map. And so we went in and we fixed that.

DJ BERRY: We've also improved performance considerably. So right now this map is actually taking so long because I put 10,000 polygons on it. And so you can actually, now, right now, you've got 10,000 zip codes and you can actually pan and zoom the map. Before it would start to stutter and jitter and be very unhappy. And you guys have kind of seen my machine's not too happy at the moment, anyways. And I've got some internet connection problems. And I can still pan and zoom the map relatively easily.

SCOTT BALL: And so we-- the map used to be underpinned by IE. And we replaced IE with Chromium. And so that's what a lot of our speed and performance improvements, we just got naturally by switching over to Chromium. It's just a faster browser, handles tables and arrays better. And so the maps are faster.

DJ BERRY: Much, much faster. And, wow, I have really angered this. So I'm going to turn it over to you before my computer starts smoking.

SCOTT BALL: Sounds good. So those are a handful of the things that we have been adding and changing. One thing that I want to mention is that we do have our designers on site here in San Diego. And we do usability studies to make sure that this thing works for people. And so if you're interested in participating in usability studies you can do so here in San Diego by going to this area circled in red. So at the bottom of this map, is the main hallway out in the front. So it's in then the back left corner. We have our usability group. If you go back there and tell them you attended this session and you want to help out with Maps for Office, they can either work you in on site here into some usability sessions. Or they can take down your information and you can participate later. That will allow you to see new designs that we're working on. We'll reach out to you, have you run through them, see how you react to them. And that's invaluable to us to make sure that the product that we're designing works for the people that we want it to work for. So please check out our usability area.

If you want to talk to the team that builds this thing, we have a couple of stations and a couple of team members posted at the-- what is it? The ArcGIS apps area of the expo. And so that's circled in red. It's on the back right side of the expo area. Come talk to us. Come tell us what's working, what's not working. Or if you just want to play with it yourself, we have a couple of workstations set up with Maps for Office on it. You can play with it yourself.

DJ BERRY: We've also got that spreadsheet with all the functions in it. So if you want to mess with that functionality, you can.

SCOTT BALL: This is a good slide to just take a picture of. It's where you can learn more about Maps for Office. You can get the documentation. Our doc lead is amazing. She does a really great job. And so head out to the doc site. Most of your questions will probably be answered there. You can follow our blogs. That's where we post a lot of our new stuff whenever we have a new release. It has an RSS feeds, so you can just subscribe to that and keep an eye on it.

We also have an idea site out there. And so if you have an idea that you want to see in the product, go to the idea site, pick Maps for Office and let us know what you want to see in the product. We pay attention to this. We prioritize our backlog based on the ideas coming from here. So please, go there and let us know what we can do better. You can also take our survey on the Esri events app. So if you think we did a great job, go there. If you think we did not do a great job, forget this slide ever existed.

And so we've got about 15 minutes left. I'm going to open it up for Q&A. And if you guys have questions about ArcGIS Maps for Office, we'll take those now. And if not, then we'll get out of here a little bit early. What do you guys think? I have a question over here.

AUDIENCE: What versions of Office are supported?

SCOTT BALL: The question is what version of Office-- or what versions of Office are supported. We support starting in 2010?

DJ BERRY: Mm-hm.

SCOTT BALL: 2010, 2013, 2016.




SCOTT BALL: Blue shirt, in the back.


SCOTT BALL: The question is does this eat up your credits for ArcGIS online. It does consume credits based on the service that you use. If you geocode points, those are going to consume credits because we're using the world geocoding service. If you do geoenrichment. Geoenrichment is another thing that will consume credits. If you map polygons, such as if you're mapping to state boundaries or county boundaries or one of those standard geography types that we also allow you to map to, those don't cost any credits. Only if you use the world geocoding service and return points.

Question in back in the blue.


SCOTT BALL: The question was can you use your own geolocator services. And, yes, you can. I think that's one of the what's new things. DJ BERRY: With the new thing, is that it will automatically use your organization's default geocoder. So in the past, we would automatically try to use Esri's world geocoder. But now once it connects to your org, it automatically tries to use whatever you've set as your default.


SCOTT BALL: The question was, you don't have to have business analysts to access the tapestry data. And no, you don't. Black shirt.


SCOTT BALL: The question is can you use custom vector base maps. And I think that's one of the what's new items.

DJ BERRY: Yep. It was in our March release. We support vector base maps now.

SCOTT BALL: That's a new thing. In the jacket.


SCOTT BALL: That's the question. Is Office 365 supported was the question. And no, it's not right now. To expand on that, we want to go there. It's something that we really want to do. The Microsoft APIs for Office 365 aren't as matured and robust as the APIs for the desktop version of Excel. And so there are some things that we need to do to be able to render the map quickly and performantly that we don't have access to right now.

DJ BERRY: We are currently looking into it again. And I think Tom, one of our developers, is currently looking into the API. Because they've made improvements.

SCOTT BALL: At the beginning of every dev cycle, after we put out a release and we start looking at things and new for the next cycle, we always go back and look and see where the progress is at. So at the time that we look and it's ready, we're going to go there. Yep.


SCOTT BALL: So the question was where do you go to download this. And that's a great question. If you go to, that'd be a great place to start. It'll give you kind of an overview of what things you can do. And then there will be a big green box that says Download Now. Right here in the front.

AUDIENCE: [INAUDIBLE] only to spreadsheets only [INAUDIBLE]

SCOTT BALL: So the question was, can you pin the map into the spreadsheet so that when you print the spreadsheet, the map prints too. Is that right? So yes and no. The map, by default, will be floating above your spreadsheet. And you can kind of drag it around, do whatever you want with it. There's also a way, there's a little arrow in the top left corner that you can pin it into the spreadsheet. So that as you move the spreadsheet the map will move too, which is helpful if you're building a little mini dashboard within your spreadsheet. The printing is iffy. Sometimes it works. Sometimes it's not great.

DJ BERRY: What might work best is to actually use the copy map function on the toolbar and when you click on that, it actually takes, I think, like either a JPEG or PNG of your map and then you can just paste it into your spreadsheet. And this way it'll print like it's embedded.

SCOTT BALL: Correct. We've got one back here.


SCOTT BALL: Is that a SharePoint question or is that an Office question? Well--


SCOTT BALL: Sure. So the question was ArcGIS maps for SharePoint does not work with 10.5 are we going to. And yes, we are going to at our next release. Which should be coming up later this month, by the way. Yeah.


SCOTT BALL: So the question was are there any-- is there any metadata coming back with your geolocation coding results to allow you to know what failed, or if it didn't do it quite as well. That's the heart of the question? We don't. If it fails, we'll tell you it failed and how many items within that layer failed. But we don't give any more granular information about it passed with a 70% success rate or a 30% success rate. If we make the match, we just make the match and we put it on there.


SCOTT BALL: This-- question in the back left.


SCOTT BALL: I missed the last part of that.


SCOTT BALL: OK, so the question was, if you have xy coordinates in your spreadsheet data, one, can they be used. And two, can they specify the coordinate system. And yes and yes. I think that if it detects the latitude and longitude is in your data, then it will switch and use that because it's not going to cost you any credits. So we want to be mindful of that. So it'll switch to those, use them, and then, yes, you can specify the coordinate system. It's a little bit buried because that's a little bit above the level of most people that are going to be using Maps for Office. But we did get a lot of people asking for that. So you can switch the coordinate system. You can also select the coordinate system.

DJ BERRY: You can also add xy coordinates to your spreadsheet. So in case you decide like, OK I'm going to give the spreadsheet to someone else and they can, I don't know, do something else with it. You can add xy data from Esri as well.

SCOTT BALL: Anything else? All right, well thank you everybody. You've been a wonderful, wonderful crowd. And thank you for coming to our session.

Credit: Esri Events. "ArcGIS Insights: An Introduction", Dara Burlow and Scott Sandusky, YouTube. April 22, 2020.

The second video I want you to check out is by Margaret Lee, General Manager of Data Services, Mapbox. It is a short presentation form GovSummit 19 focused on her/their vision of the critical role of data of many kinds in future mapping activities. The key demonstrations here focused on their Vision SDK that is a product to embed in phones and add augmented reality capabilities for navigation and on how they are changing their approach to mapping cities.  As you view the videos, think about differences in presentation style, topics emphasized, the general visions of the future for GIS/mapping, overall similarities and differences in the videos, and/or any connections you see with other material from class, with things you have read/seen about changing technology, or with your own work.

The Future of Mapping Data with Margaret Lee (GovSummit 19) (14:12) 

Click for a transcript of The Future of Mapping Data with Margaret Lee.

Good afternoon everyone. Thank you for spending the day with Mapbox, and especially thank you given this is, I believe, the last session of the day, and spending time with me. I understand that you've heard a lot of use cases, a lot of our customers and partners talking about Mapbox and mapping. For the next 15 minutes or so I'd like to switch the gears a little bit and think about technology and future of mapping.

Okay, so what is the future of mapping?

As we all have seen paper maps from the days where we're five years old and watching folks drive, and for some of us, remember buying the library of maps from Costco, right? Those days are beyond us. But what is the future of mapping?

So, when I think about a map today, I think about an iceberg, where you see above the line, is rendering of the map, the styling, the data and the information on top of the map. The ability to zoom in and zoom out. They're all very fantastic. But what really gets me going is what's below the watermark, the 90% related to mapping that is data-driven. Today, mapping is 90% data,

and when I say 90% I'm talking about the effort, the value, and what do we mean by data?

So, let's first take a look at a little bit of progression of mapping. Digitization of maps has happened decades ago, moved from Thompson maps to ones and zeros. After that there was image processing, the day that any satellite was launched, there is already imagery being downloaded, and there's processing of that. And the many vendors in the market have already conquered the problem of mapping it, lat/long matching, and layering. Those are what we've done so far. Looking ahead, what we're talking about the living map, we're talking about collecting live telemetry, and data processing in real time.

To make the ever-changing map that you know, the ever-changing world, reflecting on your maps. We're talking about daily, rapid updates on a global scale. We're talking about ground truth - 3D, right? What you see, be able to capture it, categorize it, and then ultimately enable autonomous driving. And we're talking about applying machine learning algorithms to the data that's collected, the data that you see. So that also means the kind of data we're working with is changing, from the days of sort of relational, Oracle Spatial days, of storing data in GIS databases.

We have also heavy data, that's what I call imagery data, of processing, digitizing that. But more and more we're talking about big data processing. We're talking about gigabytes, terabytes, petabytes of data that may come in from maps or may come from heavy imagery. We're talking about live data processing, collecting information on the ground, immediately send it back, and feed it back to the customer. And then more and more we're talking about visual, vision data on the ground. So if you look at these images, they look very familiar, right? We're in a mapping conference. So undoubtedly you look at styles, you look at the different findings, so the bottom one I believe is a mapping of suburbs. But if you think about it, that all three have the commonalities of looking from top down. The future of the mapping is not just top down,

but at the ground truth level. So keep that in mind for a second. In Mapbox, we're taking the data processing extremely seriously, because at the end of the day, we want to provide customers

with highly updated, living map.

So what is it that we do behind the scenes to provide that living map? We have a lot of sources,

from open source, or propriety data sources, that we conflate into multiple databases. We have automated and manual, mostly automated, 90-plus percent, of looking at errors and things we want to correct. And we enhance them by putting points of interest, addresses, important information, onto multiple layers. I'm sure you've heard a lot about that today already. And we tiling those maps to serve it through APIs to you all, okay? And what's remarkable is this process in ongoing every day. At the worst, our SLA is seven days of getting the changes into our mapping. In an emergency situation, we could easily do it within a day. So if you think about the world of annual updates to the paper map, or quarterly, even monthly updates to digital maps, when you're talking about daily changes as buildings get built, roads get created, street names get changed, points of interest come and go, restaurants, cafes, all of that gets updated on a daily basis, this is a major data pipeline. That means conflating variety of data sources, coming to a variety of data formats, and somehow at the end providing customers with beautiful laid out map.

So what I'd like to do is show you guys a video of what we're working on. This is our Vision SDK. This is SDK that we are embedding into our customer's phones, okay? As you can see, this SDK can allow first, assisted augmented driving to alert the driver. Secondly, it has ability to recognize and capture images. Those images could be street signs, speed limits, turn lanes, okay, and even particular stores. In that image, as you can see, the car is constantly capturing, and then

we have the ability at the edge, on the phone, to do the newer work of identifying and segmentation. And then those images get sent back to Mapbox and we do massive amount of image recognition, and massive amount of de-duping. Over, so a lot of processing, you can see that 25 miles an hour speed limit on the neighborhood road. Over the last few months we have done tons of image processing, and we have already identified over a million images across North America and the United States.

So you can see, right, one of the things that often times I tell my friends that they're surprised

is, what do you mean, there is no central database somewhere in the government that can query for speed limits? Right? I see 55 on I-95, that information's gotta be somewhere. Otherwise, how would they know what's number to put on the street? So surprisingly, there isn't. Maybe with the exception of interstate. Certainly the secondary, tertiary neighborhood roads. So if you are someone driving down and you would like to find out whether you are breaking the speed limit or not, or perhaps the insurance company to make sure a logistics company's population drivers drive safely, the speed limit information is very important to you. And because there's no centralized government database, to get all that the best alternative people are doing is ground truth capturing. Literally, drive down the street and capture the signs. But the issue is, that's very, very expensive, you rely on one company driving around, no matter how many thousands of letter cars, you're never gonna cover all of the neighborhoods. So this where a new approach is needed. Our Vision SDK, what I just showed, will be embedded in many, many, many people's apps and then it becomes a bit of a social gathering of images and Mapbox can take the centralizing, processing, de-duping role, ultimately giving everybody a map of all the streets

along with speed limits attached to them. So those are the kind of data processing work that we can do that can help move the maps to next stage. Second thing is the idea of mapping states,

and counties, and cities and ZIP codes sort of as a visualization layer, again, is something that many of you guys are doing today.

Not surprising. GIS has been out for a long time. But the question is what else can we do above and beyond that? So we have a product called Enterprise Boundaries. Today is very typical in terms of allowing business intelligence use cases, what we call it. Mapping yourselves, mapping your population, mapping your citizenry into ZIP codes and counties, well-defined. But the question is things like neighborhoods, right? It's amorphous idea. Do you live in neighborhood A or neighborhood B, and the neighborhoods change all the time. But that's also very useful, for a variety of purposes, to identify neighborhoods. Then how do you actually visualize that and that becomes sort of different shades and different level confidence level. So those are the kind of things we want to take above and beyond sort of mapping directly to ZIP codes into visualizing nebulous concepts like that. Then lastly on buildings. So there's actually quite a lot of open source buildings data out there, not just the address, but the height, the year it was built, etc. So we want to allow customers first, to visualize 3D buildings, and second, to provide much, much more interesting information. I think two speakers before me was a lady from Microsoft who talked about wireless broadband adoption. We are actually working with a telecommunications vendor who, with our help, can map Wi-Fi upload and download speed down to individual buildings, right? So then there can be very targeted understanding when the customer calls up to say, I paid for 50 Mbps download and, whatever, 25 Mbps upload. Why is it so much slower? And they can understand triaging, where is the bottleneck and what is the actual experience, by every single customer in every single building. So these use cases are really endless, once you have much better detailed understanding of your buildings and of your maps. Again, all of them is a data conflation, data processing exercise. Lastly, I talked about telemetry earlier, right?

So today, everybody, anywhere you drive, you put in the address and you expect a ETA, expected time of arrival. How is that calculated? How does, you know, whatever app you're using get that information? So the magic behind that is understanding traffic, and understanding the conditions on the road, whether congestion, road closures, incidents, and then getting information about how fast the traffic's moving, and how the map is working, sort of, is it flow traffic, or is there a lot of, in this case, New York, you can see the green is easy traffic and then red is blocked. But more interestingly is that if we are understanding where people are traveling,

the ability to discover undiscovered paths. So in this case we got probe data from people anonymously traveling through Santa Cruz Mountains, right, and that particular path, road, was not on the original map. And then with a lot of data we can process and provide expected time of arrival. So again that goes into a data collection data pipeline. So every day, Mapbox - I think Eric must have talked about over 500 million monthly active users - that are using Mapbox.

Other sort of data points that I'm very proud of is every day we collect billions of anonymized probes as people go about their lives. And then every day we can put that together, tracing that, all those probes together to close to 300 million miles of live traffic information. And all of that information goes through our data processing and data machine-learning algorithm pipeline, on a live basis.

Every five minutes, anywhere in the world, I can give you red, yellow, green, in terms of traffic situation and what's going on, on the map. And that is what I really call the living map, and this is where the future of mapping is headed.

So as a summary, back to the iceberg. I think to be a fully advanced provider of mapping in the future it needs to be some company that really understands data, processing collecting, anonymizing, and building machine learning algorithms on top of data.

That's all I had.

Thank you.