Download all area names & GPS coordinates

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

+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!

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.

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.

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.

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...

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

you should redact your key :)

khoa wrote: you should redact your key :)

woah good call! thanks for that, removed it

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

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.

I don't know much about coding, but I have a feeling this is similar to what I would like to accomplish. Is there any way to take the CSV file of my to-do list and use that to get a GPX file of the location of all of the climbs within my to-do list? Or at least the wall location?

Leo Klotz wrote: I don't know much about coding, but I have a feeling this is similar to what I would like to accomplish. Is there any way to take the CSV file of my to-do list and use that to get a GPX file of the location of all of the climbs within my to-do list? Or at least the wall location?

You can export a csv of your to-do list, but it doesn't include the lat/lon coordinates for the climbs in the list. The tick-list csv export does include lat/lon, so I imagine it would be a pretty easy feature to add.

How do you find your own private key?

Justin Lofthouse wrote:

How do you find your own private key?

It appears to no longer exist.  :(

https://www.mountainproject.com/data

tom donnelly wrote: why do some of those star values seem to be off?

it's actually because it forgot to take into account the equation numstars = FFA stars minus 2.