Author |
Barbican Wall route descriptions |
|
|
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.
|
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...
|
20-May-2010 7:46:04 PM
|
Andrew, chat with dan, implement it, I doubt he'd have any opposition.
|
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 :(
|
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!
|
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.
|
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
|