 So all right All right, so I did this. So yes, I'm from Portland, Oregon. I've been climbing for about Six or seven years and five years in the open-source space About a year ago. I looked into open-street map and I want I wanted to make a map of in all the climbs in the USA but to my surprise they're Very little data in open-street map when it comes to rock climbing. I Went over to Europe and voila there a lot of data so But then I wanted to as a you know technical person I can log in and edit It's it's do a learning curve to edit to contribute to open-street map Let alone my rock climbing friends, you know, telling them to log in use the adi editor would be Very difficult task So in this talk, I will talk about the app that I'm working on hoping to make it easier for my friends and all the rock climbers to add data into open-street map and Yeah, I just want to say that it's super informal if you feel free to interrupt me if you have questions and Yeah, and also I see that there are a lot of There are two other open-street map related talk Optimize I won't go into too much detail the on the technical side So this is what I've done last year I query Open-street map I Want to get all the objects that Are attacked with that sport equals climbing tag and as you can see there a lot of them in Europe and Like USA we have about 200 probably So that's so I want to set out a personal mission to change that Well, thankfully, I'm not working out of a vacuum because there are several Websites and forums where I can look up all the information about the climbs So they are very fragmented one web website This is really good. It's called mountain project You can look at the website you can browse the site, but you cannot both download You know as a as a computer person, I wanted to write an API I want to make my own maps and it's not possible the license is kind of unclear what I can I cannot do with the data so Yeah, so it's it's a it's a journey so the The app that I'm working on The first I guess goal that I wanted to do is to aggregate the climbing data from A couple websites into one and then put them into OpenStreetMap and Then add some sort of search Capabilities so you can search, you know like when you if you use Airbnb You go to Brussels. You want to narrow your search to a radius filter by Price range. I like to do something like that for a climbing app and Yes, another thing I want to mention is by having this app it hopefully it will simplify how people would input data into OpenStreetMap and most importantly I would like to Give people the ability to download the data You can go directly to OpenStreetMap If you know how to use their REST API the overpass or if you want a climbing Pacific API that's where my project hopefully will make it easier and So just a summary I'm going to talk about one technical challenge that I'm Have to deal with when working on this project and then one non-technical challenge, which is how to convince the community to You know contribute So just a quick high-level overview The web app is Liftlet and React.js and back in I have a REST API in Flask SQL Alchemy usual suspect and Post-GIS database Moab in in progress So as you can see you have OpenStreetMap over there and you have my database over here You know why having two so and I envision the database is going to be Like a staging area where people can input and edit and then once it passes You know community validation we can push them into OpenStreetMap I'm debating should I do that in OpenStreetMap? I don't know. We'll find out I mean I follow the mailing list and the pros and cons and of that approach So before I go on further, let me Define what climbing data is so if you climb your rock climb you probably have heard which people talk about beta so beta is Yeah, if rock climbing rows are get repulse beta would be the read-me file so first and very important piece of data is Of course the location. Where is the climb? Where is it and you know what are all the climbs next to it and then another piece of pieces of information are You know the difficulty how hard is the climb Where are the holds are? What kind of equipment you need to bring with you? Is this dangerous or loose rock you need to watch out for? How long is it climb? Yeah, it's very subjective. It's Some people refuse to read this they just want to go on and climb and Kind of enjoy the adventure themselves and some people love to read it Like like engineer or sometimes we read manuals and then we just go straight to using it so my app I would oh Sleep and the third piece of data is like personal Anecdote story. I have climbed it before I didn't like it or I love it and Then discussion about that climb So I would like to focus on the first part Which is where the climb is are? Because there are many websites that are dealing with the second and the third point Yeah, everyone good so how do I model the climbing routes and wall and then Moldable walls and open street map. I would like to show you some photo This is a climbing area in my near my hometown Smith Rock As you can see climbs are next to one another and then if you look at it on the map They are just one long cliff From a map or point of view it's just a cliff but from a climber point of view There are two separate section, you know the red section The blue section they name differently. They organize differently So that's something I need to keep in mind and Then if you zoom out the whole area of The climbing area you can see that there are Multiple sectors and then within a sector you can have another sector So they can have multiple nested level and the the outermost Area is what I would call a climbing destination. So I would I say I go to Catalonia Spain that's like the climbing destination and then in Spain. I would have multiple sub areas So let's get back to open street map So I need to define climb wall and then the sector So the climb start explanatory. It's I use the are you open street map note object, which is a single point Couldn't mind some there's some proposal in open street map where People suggesting that I mark the start of the climb and the end of the climb It can be a challenge when the climb is very vertical So you would have the start and the end on top of another so I would save that for The future for now. It's just a single point and then to represent a climbing wall I use Ways which is a series of ordered a list of note. All right, and then how do I? Model a like a groups of walls or sector group of climbs One way is to use a closed way But I found out pretty soon that it's not intuitive to use an open street map You can't not just simply draw a polygon and Save it There's a lot of issue with that. Let's say there's a there's a path that go this way I can't to draw a polygon over it I have to connect my polygon to the path and then continue So imagine there's a map of the park. There would be many paths and object. I cannot to draw my polygon on top so I Choose to go with relation So relation to the now that Data element in open street map That allows you to model to group to logically group Notes or ways or all the relation together. So So relation it is So this is a photo of my friend many he's hanging on the rope and look like he's smoking the cigarette, but no he just Drilling a hole in the rock and then he has to blow out the dust in the rock before he can put the Bolt in so it's a lot. It's a labor intensive work and it's a labor of love He put a lot of time and effort into this so what happened after this he would Find out the location of the climb and he would share that with someone in his local community and That person might go on the mountain project website and submit it and then all the people can view it but as Gis, you know enthusiast I cannot just go and both download all of the work that people have put in due to you know, unclear license So yeah, what the point want to make is You know the technical challenge can be overcome. You know, there's stock overflow at internet and it's not too bad, but to Convince the community that to open up all your data put them in open-street map is It's uphill battle So I just put the chicken and egg There the classic problem my app is brand new. I have little data How do people go into Contribute and then But if I have more data people might contribute so I Go again. I like to simplify the data entry so that they can go into open-street map And Secondly, I want to see open-street map with correct data By that I mean I actually hoping to scrape okay terrible, I'm gonna scrape the mountain project website and Negotiate with them Convince them to open up their data So I have people have data to work with and then they can continue to improve it Six minutes Yeah, so yeah, I really changes won't happen overnight and Keep sharing and listening to the communities community feedback and there's one example Many of the things you can do with open data in rock climbing for example, I scraped the data from that mountain project website and built a heat map of all the climbing walls in the eastern part of sorry the western part of the USA You can for example you can Correlate this data with hey where I'm a rock climber. Where should I move to obviously people would love to go to Denver or Boulder all the climbs are or California where your cemetery is Or you can do cool things like all you know the craft beer consumption on top of this or On a more serious note, you know the outdoor retailer industry can map how people spend money in Proximity with the climbing area So this the and I have stickers you want stickers The projects on github. I would love to hear your ideas Full request I'll just say hi I have you have I have time for cute any questions Yes, I just yes, so your question was what I wanted to map absolute and relative location I'm bringing that up to explain what beta It's a it's a lingo and rock climbing to tap when you look for a climb you want to know where it is or what's around it But to map the climbing route. I would just map the climb itself and then just to show them in relation to all the climbs and You have a question Yes, yes Yeah Yeah Yeah, so please yeah, please send me an email. I would love to talk to you more about it. Yeah Yeah, excellent. Thank you one or more Yes, I heard of it. Yeah. Yeah. Yeah. Good point Okay Right Yeah, right so should I keep that in my data set or defer that to the other website like Yeah, okay, like store our should I keep the store hours in my data set or okay, I'll think about that Okay closure True true. Yeah in my area. There's some ego nesting so we forbidden to climb You know like half of the year for the ego to nest so Oh Right Exactly Yeah, something more like a wave app, you know when you see traffic jam you can hit traffic jam So it's just like a foundation where people hopefully people can be on top of Yeah, yeah, I've seen that yeah Yeah, some true I'm hoping to focus in the US and once get that going I can see I can negotiate with them and you know scrap the data or Might ask them nicely Download Thank you