00:01So this is your conference, and in the spirit of more and more user sessions...
00:07...we thought it was time to actually bring one of you up on stage with us and share the experiences of building a real system.
00:16When you build these systems, you know, you use what you have.
00:20You use what you have from us, you use what you have internally in your organizations.
00:24You have to understand the problem you're going to solve, collect your requirements, do the design, implement it...
00:29...roll it out, test it, and you still got bugs. Just kidding.
00:33But so I want to bring Gady Pitaru from Sky Harbor Airport, the aviation department, up here.
00:41He's a program analyst, and he's going to talk about what he's built for Sky Harbor. So, Gady? Feeling okay?
00:48Feeling alright. Thanks, Jim. Alright, take it away, Gady.
00:52Alright, thank you, Jim. So a little bit more about GIS at the aviation department...
01:00...we have a GIS staff of roughly eight people plus a handful of developers, including myself...
01:07...and over the past few years, we've been really amassing a large amount of data, like an arsenal of data.
01:14And now we're at the point where we're starting to build some really cool applications around this data...
01:20...for both our internal and external customers. And I'm going to talk to you about a couple of those today.
01:26So the first one is called Find a Spot.
01:28Find a Spot, basically the problem that we were trying to address with this...
01:34...is that Phoenix Sky Harbor International Airport, it has - it's owned and operated by the City of Phoenix.
01:41It has eight parking facilities, over 21,000 parking spots...
01:45....and we have a parking operations field staff that literally go out there every two hours and they walk every parking facility...
01:54...and they write down how many open spaces there are on a piece of paper.
01:58Why they can't use the tickets, it's a long story.
02:01But basically, they're writing this information down, and you know, it's hot in Phoenix in the summer.
02:07Couple weeks ago, we had like a crazy hailstorm.
02:10It's nice about five days out of the year, and I'm usually at the DevSummit at that time.
02:15But these guys, the point I'm getting at is that these guys work hard.
02:19They do rigorous data collection; we want to see that data go further than it does.
02:23Unfortunately, this is as far as that data goes. Okay?
02:27They literally are flipping a switch on the entrance signs of these parking facilities that basically tells a traveler...
02:34...Hey, you've hit a dead end. You've got to go somewhere else.
02:38So what we have here is really, you know, a classic case of what I call dead-end data.
02:43Okay, so how did we solve this?
02:46The way that we solved this problem, first thing that we did is actually we made a Microsoft SharePoint list.
02:53Okay, the aviation department has a rather large implementation of Microsoft SharePoint.
02:58All of our employees are familiar with using it, so we created a SharePoint list that our parking operations field staff...
03:07...instead of just throwing away this piece of paper when they're done with it...
03:11...they actually now enter in into SharePoint the amount of open spaces for each of these parking facilities.
03:18Okay, that's great, 'cause now it's in an electronic format; it's a database on the back end.
03:22We can reuse it in multiple systems. Perfect.
03:26On the other side of this, we have the parking facility geometry stored in Oracle, with ArcSDE running on top of it...
03:34...our GIS staff maintains this in ArcGIS Desktop...
03:38...so the next thing that we did is publish out that data in a map service in ArcGIS Server.
03:43We were running 9.3.1 at the time.
03:45So now we have good geometry, we have up-to-date, you know, real-time attribute - dynamic attribute data in SharePoint...
03:55...so we wrote a custom .NET web service to merge these two things together.
04:00It's just a fairly simple REST-ful web service, spits back some JSON.
04:05You know, this solution, it's a little bit of a Frankenstein that we had to put together here...
04:10...but at the time it was the best we can do running 9.3.1 and when we were coming up with this.
04:16So this web service, this data, this JSON data, is now accessible on skyharbor.com, which is great...
04:23...'cause what that means is we can start building some really cool applications around this.
04:27And the first application that we built is called Find a Spot.
04:31And this application runs on skyharbor.com, and basically it was built with Esri's Flex API...
04:39...and you can see you can get, you know, pictures of the entrances to the parking lots.
04:43It displays here in the middle exactly how many spaces are available...
04:48...and of course, I can click on one of these and get a map of the whole area.
04:54Everything's nice and color-coded.
04:56So this is a really simple, focused application that we built for our customers, 'cause keep in mind who our customers are.
05:02They're travelers, right? And you've seen them at the airport and they're carrying three car seats.
05:07They just paid a hundred dollars in baggage fees, you know.
05:11So we didn't want to add to their stress; we wanted to make something very simple for them.
05:23...using responsive web design principles.
05:26Our PR group really likes to Tweet this, and people who aren't running Flash, unfortunately, they're not going to see it.
05:33So this is Find a Spot. It really served as a proof of concept for what we can do internally with GIS.
05:41So now I'm going to switch over to my mobile device here and show you another application that we built.
05:47This is a - so Find a Spot was released about a year and a half ago.
05:51Sky Harbor mobile, Sky Harbor Airport's mobile website, was released this last November...
05:59...and what's cool about it is that we kind of took it all to the next level.
06:03So if I click on Parking here, you'll see it's pulling in the exact same parking information that comes from that web service.
06:11It's using the exact same web service; we're pulling that information in.
06:15Okay, what's even cooler about Sky Harbor mobile is that we baked GIS really into the core of this thing.
06:22So if I go to something like Food and Shops, right, and I drill down, let's just say, okay, terminal 4...
06:29...all of these food and shops listings, they're all being driven by an ArcGIS Server map service.
06:35So all we did in there in the code is just say Return Geometry = False.
06:40We don't need the geometry; just give me the data.
06:42It's just JSON at the end of the day. We can build a nice interface around it.
06:47Okay, so if I drill down into one of these guys now - let's say Blue Burrito, my favorite burrito place at the airport there -
07:00And again, very simple map. You know, we call it a cartoon map.
07:05Because again, this is for travelers; we had to build something that was really simple, easy to use...
07:11...and in the end, we actually surveyed a couple of travelers as we were building this just with some design questions.
07:17But it's an interactive map, runs really nicely.
07:21I think it's like the first, like, indoor airport amenities map on any airport's mobile website, but don't quote me on that.
07:29And if you find me later and prove me wrong, that's fine.
07:33But so this is Sky Harbor, you know, Sky Harbor mobile's website, so now we have two applications running...
07:42...that are using the same web service.
07:43We're utilizing GIS in a lot of different ways, these multiple clients.
07:49So I'm just going to switch back over to my slides here.
07:54Okay, so now that we have these two applications running, I wouldn't be a good developer if I didn't look back and say...
08:00...Oh, maybe we could have done some things better.
08:03So, you know, one of the things is now we're at ArcGIS Server 10; maybe we can use a feature service to edit...
08:09...to have our field staff edit that data directly against GIS instead of having to go through SharePoint.
08:16Why not take that even a step further and maybe build a native application for them, right, to do that...
08:22...where they're out there in the field with a mobile device and they're doing everything there.
08:27Why not even take that idea a step further and have a native application for our travelers to route them to like open spots?
08:34Wouldn't that be cool?
08:35And even a step further there and have, like, Use indoor location at the airport to route them...
08:40...to maybe the nearest Burger King or something like that.
08:43And then even just beyond that - this is really my wish list for the DevSummit - what about leveraging SharePoint some more?
08:50You know, I know Esri has a lot of SharePoint offerings. What else can we do with that?
08:55So, you know, this is really the enhancements and wish lists that I have in my mind...
08:59...and that's really why I come to the DevSummit is really to take what I've already done, make it better...
09:06...and then also get some ideas for some new things that we can do.
09:09So with that, I look forward to seeing you all in the rooms this week, and thanks again, Jim.
09:13Alright. Thanks, Gady. Cool.
09:20You know, so I think what Gady talked about this morning is representative of many of you.
09:24You know, you've got a problem for your organization or you've got a project, and you've got to deliver. You have to get it done.
09:34And he used what he had and his team used what they had at their disposal, merging things.
09:40As technology moves, you know, we've got new opportunities.
09:44And all of your wish list, everything that you wanted to accomplish, we're going to be talking about all those things...
09:50...and many more things this week.
09:52You know, so thank you again. Thank you.
09:55Take a seat, and hopefully you'll see something useful that you're going to be able to use for your system.
09:58Again, thanks, Gady. Thanks, Jim.
ArcGIS for SkyHarbor
Gady Pitaru of the City of Phoenix, Arizona aviation department discusses how GIS is used to optimize airport parking in real-time.
- Recorded: Mar 26th, 2012
- Runtime: 10:06
- Views: 824
- Published: Apr 19th, 2012
- Night Mode (Off)Automatically dim the web site while the video is playing. A few seconds after you start watching the video and stop moving your mouse, your screen will dim. You can auto save this option if you login.
- HTML5 Video (Off) Play videos using HTML5 Video instead of flash. A modern web browser is required to view videos using HTML5.