Goto Chockstone Home

  Guide
  Gallery
  Tech Tips
  Articles
  Reviews
  Dictionary
  Links
  Forum
  Search
  About

      Sponsored By
      ROCK
   HARDWARE

  Shop
Chockstone Photography
Australian Landscape Photography by Michael Boniwell
Australian Landscape Prints





Chockstone Forum - Crag & Route Beta

Crag & Route Beta

 Page 2 of 2. Messages 1 to 20 | 21 to 27
Area Location Sub Location Crag Links
VIC Grampians Southeast Barbican Wall (General) [ Grampians Guide | Images ] 

Author
Barbican Wall route descriptions

nmonteith
20-May-2010
5:47:20 PM
On 20/05/2010 ajfclark wrote:
>The thing I find most confusing about this separation is that from my
>(nerdy past life as a DBA) point of view, they are all instances of a more
>generic parent class as they all have the same properties but you can't
>search all of them at once for a phrase. This is particularly confusing
>with areas like dreamtime wall, which is a crag in the database not a wall.
>
>Also I can't seem to search for routes with grades between two values.
> If you look for everything under 20 you'll get a whole bunch of ungraded
>projects.

Yes, these are my two pet hates as well. There should just be a single search function for name - and it displays instances in order starting from highest to lowest in database hierarchy.

ajfclark
20-May-2010
6:28:43 PM
Wouldn't be hard:

SELECT [fields] FROM region WHERE name like '%test%' UNION
SELECT [fields] FROM area WHERE name like '%test%' UNION
etc
;

Should work as long as [fields] are consistent in all cases, as aliases might be needed to get it to work right. I'm guessing on the aliasing because I haven't actually seen the schema.

Other thing I notice occasionally is that there's no rewriting on urls so you have to remember a link with an ID to get to an area. It'd be nicer if you could link to http://routes.climb.org.au/vic/arapiles/blah/blah/route or whatever...
hotgemini
20-May-2010
7:46:04 PM
Andrew, chat with dan, implement it, I doubt he'd have any opposition.
kieranl
20-May-2010
10:27:54 PM
On 20/05/2010 nmonteith wrote:
>The main problem with that guide is that almost none of the crags featured
>are popular in modern times. It's missing - The Gallery, Muline, Eureka,
>Lost World, most of the good stuff at Red Rocks, Millennium, Crystal Palace
>and most of the good routes at Gilhams - the list goes on.
I've been revising a few things in the Vic range over last few weeks. Been doing the Emu's Foot area cliffs in last few days. Added routes to Red Sail, Eureka Towers, Lost World, Emu's Foot. Also an overview photo for Lost World. Graphics to my usual high standard :(

nmonteith
20-May-2010
11:07:29 PM
On 20/05/2010 kieranl wrote:
>I've been revising a few things in the Vic range over last few weeks.

Great work Kieran!
Wendy
21-May-2010
3:43:07 PM
I've always found thecrag to be abjectly useless for gaining information about climbs, let alone any substitute for a guidebook. It'd be better if people actually entered comments (useful comment rather than repeating "good" or talking about the style they did it in. Stuff that would be relevant for someone wanting to do it - is the grade fair, gear good, any obscure pieces needed, rock cruddy etc etc. But it seems to largely be used to record ticks and it is no comparison to the ACA database. rockclimbing.com is occasionally useful, not as a guide because they usually say diddly squat about the routes and no topos but because they do often provide a summary of a crag and other people may have uploaded photos, so you can get a feel for whether you want to check it out more, but that's about it. And you need to check the photos that come up are actually of the crag concerned - sometimes there doesn't seem to be a lot of connection going on. About the only other route database I've found that is of any use is camptocamp.org. Which is really best for Europe and the french database is far more extensive than the english one.
grangrump
21-May-2010
4:18:40 PM
On 21/05/2010 davidn wrote:
>Copy of ACT Granite... again, some topos, access descriptions etc are
>sweet. Some info is unhelpful, because the writers wanted to take a 'traditional'
>approach. Some things, notably bouldering, are almost completely ignored.
> There are better guides around for detail, I know.

Yep it's out of date (pre-2003 fires etc) and was written before bouldering really got popular. For canberra bouldering the best source at moment is:
http://www.canberraclimbing.org.au/bouldering-guides.aspx

 Page 2 of 2. Messages 1 to 20 | 21 to 27
There are 27 messages in this topic.

 

Home | Guide | Gallery | Tech Tips | Articles | Reviews | Dictionary | Forum | Links | About | Search
Chockstone Photography | Landscape Photography Australia | Australian Landscape Photography | Landscape Photos Australia

Please read the full disclaimer before using any information contained on these pages.



Australian Panoramic | Australian Coast | Australian Mountains | Australian Countryside | Australian Waterfalls | Australian Lakes | Australian Cities | Australian Macro | Australian Wildlife
Landscape Photo | Landscape Photography | Landscape Photography Australia | Fine Art Photography | Wilderness Photography | Nature Photo | Australian Landscape Photo | Stock Photography Australia | Landscape Photos | Panoramic Photos | Panoramic Photography Australia | Australian Landscape Photography | High Country Mountain Huts | Mothers Day Gifts | Gifts for Mothers Day | Mothers Day Gift Ideas | Ideas for Mothers Day | Wedding Gift Ideas | Christmas Gift Ideas | Fathers Day Gifts | Gifts for Fathers Day | Fathers Day Gift Ideas | Ideas for Fathers Day | Landscape Prints | Landscape Poster | Limited Edition Prints | Panoramic Photo | Buy Posters | Poster Prints