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:16We are currently moving this over from the Flex API to the JavaScript API with HTML5, CSS3...

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 -

06:54...I can view a map, and this map was built using Esri's JavaScript API.

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.