Mountain Project Logo

Download all area names & GPS coordinates


Original Post
Ian Reed · · Manhattan Beach, CA · Joined Sep 2016 · Points: 0

Is it possible to download all area names and GPS coordinates for a particular region as a CSV file? This would allow mass export of a regions wall locations to other GPS devices once the CSV format is converted to GPX (a simple task).

i can't find the feature already built in to the site, so i'm more curious if someone in the MP community knows how to data-mine this information.

For example, this is the information (and format) i would want to pull from the joshua tree region:

null

T G · · Boulder, CO · Joined Jun 2015 · Points: 51
https://www.mountainproject.com/data

Look at the method getRoutesForLatLon. You'll need to apply for an API key. My guess is that you're not going to receive the lat/lon data for the routes matching your query, however.
Andrew Krajnik · · Plainfield, IL · Joined Jul 2016 · Points: 1,688

+1 This would be a cool feature. I use a Garmin handheld, and I also like to make custom printed topo maps using Caltopo. In both cases, I have to copy and paste coordinates for individual areas one at a time. The ability to batch them with GPX would be fanbtastic!

Jim Urbec · · sevierville, TN · Joined Jul 2015 · Points: 41
Andrew Krajnik wrote: +1 This would be a cool feature. I use a Garmin handheld, and I also like to make custom printed topo maps using Caltopo. In both cases, I have to copy and paste coordinates for individual areas one at a time. The ability to batch them with GPX would be fanbtastic!

+2


though I've also noticed depending on the area the GPS might get you to the very general area ( or maybe just a parking lot) and you then default to your own level of land nav skill.
Andrew Krajnik · · Plainfield, IL · Joined Jul 2016 · Points: 1,688
Jim Urbec wrote:

+2


though I've also noticed depending on the area the GPS might get you to the very general area ( or maybe just a parking lot) and you then default to your own level of land nav skill.

Yeah, that's a fair point. Not all areas have an exact GPS location in the database. It often defaults to the location of the next-higher area in the hierarchy.

Ian Reed · · Manhattan Beach, CA · Joined Sep 2016 · Points: 0

Thanks for the comments!

The API looks the most promising, i'll have to come up with a query that returns what i'm after.

I don't really care about the GPS coordinates for the individual routes (although that would be super awesome), i'm more interested in getting coordinates for the wall/area and then depending on the MP pictures or guide book pictures to figure out the route location.

Any idea on how to apply for an API key? the "data" page linked above isn't very clear. I code in SQL for work pretty often, so this all make sense to me, just need to figure out how to start the query.

Andrew Krajnik · · Plainfield, IL · Joined Jul 2016 · Points: 1,688

Doesn't everyone have a key? When I go to that link, I see my private key listed on the right, along with a warning about how to use it, and what type of activity might result in its deactivation...

T G · · Boulder, CO · Joined Jun 2015 · Points: 51
Andrew Krajnik wrote: Doesn't everyone have a key?
You're correct, and it looks like the API method getRoutesForLatLon will return lat/lon data for routes if it exists.


Ian Reed · · Manhattan Beach, CA · Joined Sep 2016 · Points: 0

Success!

The following API URL generates some JSON data which i converted to CSV (attached) using this website
https://www.mountainproject.com/data/get-routes-for-lat-lon?lat=34.00&lon=-116.05&maxDistance=50&maxResults=500&minDiff=5.6&maxDiff=5.9&key=?????

this URL returns 500 climbs within 50mi of the split rocks parking lot in jtree (lat=34.00&lon=-116.05) which are between 5.6 and 5.9 rating. I got 404 results from Jtree and then 96 results from other crags, so i think it snagged everything i would care about.

i think my question is solved! hopefully this is helpful to other people as well.

null

khoa · · Tacomarado · Joined Mar 2007 · Points: 52

you should redact your key :)

Ian Reed · · Manhattan Beach, CA · Joined Sep 2016 · Points: 0
khoa wrote: you should redact your key :)

woah good call! thanks for that, removed it

tom donnelly · · san diego · Joined Aug 2002 · Points: 257

why do some of those star values seem to be off?

Nick Wilder · · Boulder, CO · Joined Jan 2005 · Points: 3,441
tom donnelly wrote: why do some of those star values seem to be off?

When translated to numbers in the API, the value of 1 means "Bomb", the value of 2 means "1 star", the value of 3 means "2 stars" etc.  A value of 0 means we have no star submissions for that route.

Guideline #1: Don't be a jerk.

Discuss MountainProject.com
Post a Reply to "Download all area names & GPS coordinates"

Log In to Reply