Go Back  Bike Forums > Bike Forums > General Cycling Discussion
Reload this Page >

bicycle geometry database

Search
Notices
General Cycling Discussion Have a cycling related question or comment that doesn't fit in one of the other specialty forums? Drop on in and post in here! When possible, please select the forum above that most fits your post!

bicycle geometry database

Thread Tools
 
Search this Thread
 
Old 05-12-08 | 10:08 PM
  #1  
totoroben's Avatar
Thread Starter
Ben
 
Joined: Aug 2006
Posts: 150
Likes: 0
From: Cleveland. Shaker Heights

Bikes: Rans V-Rex, Schwinn Traveler, Panasonic Sport

bicycle geometry database

okay so tell me if this is a stupid idea or not. I was thinking of starting an online bicycle geometry database in which people can add frame geometry of their production bicycles and it could be searched. It would be a wiki of sorts. Since many manufacturers do not give out full specs on their bicycles this could fill the gap. This could also show bicycle geometry of older bicycles as well. The site will include instructions on how to make the measurements. The website will also be able to switch between in and cm measurements.
totoroben is offline  
Reply
Old 05-13-08 | 06:25 AM
  #2  
RonH's Avatar
Life is good
Titanium Club Membership
20 Anniversary
 
Joined: Jan 2001
Posts: 18,208
Likes: 14
From: Not far from the Withlacoochee Trail. 🚴🏻

Bikes: 2018 Lynskey Helix Pro

Sorry, most manufacturers do give full specs on their websites.
__________________
The Lord is merciful and gracious, slow to anger and abounding in steadfast love. - Psalm 103:8

I am a cyclist. I am not the fastest or the fittest. But I will get to where I'm going with a smile on my face.
RonH is offline  
Reply
Old 05-13-08 | 07:10 AM
  #3  
envane's Avatar
Senior Member
 
Joined: Apr 2008
Posts: 828
Likes: 0
From: Chicago
I think one aspect of geometry that is really important that most companies totally ingnore is allowable tire clearances (w/ and w/o fenders). That gets asked a lot on bikeforums.

You would need to use a real database type setup, wiki is crap for databases.

Sorry, most manufacturers do give full specs on their websites.
not really (see above) and its nice to have it all avaible on one pages, especially for cross-comapny comparisons.
envane is offline  
Reply
Old 05-13-08 | 07:13 AM
  #4  
Senior Member
 
Joined: Aug 2007
Posts: 166
Likes: 0
From: Delaware, OH

Bikes: Giant OCR2, Puegeot Altitude 21 MTB

Originally Posted by totoroben
okay so tell me if this is a stupid idea or not. I was thinking of starting an online bicycle geometry database in which people can add frame geometry of their production bicycles and it could be searched. It would be a wiki of sorts. Since many manufacturers do not give out full specs on their bicycles this could fill the gap. This could also show bicycle geometry of older bicycles as well. The site will include instructions on how to make the measurements. The website will also be able to switch between in and cm measurements.
I believe this would be a good idea. Some manufacturers will only list the specs of the newer model years on their sites, finding geometry for older models can be a challenge. (Giant is one Manufacturer that comes to mind.) This could be a good resource when buying a used bike off of Ebay or Criag's list.

One other thought would be to include parts information about the bike (brakes, seats, seatposts, Front/Rear Derailleurs, Wheels, etc.) for each particular model year.
ebrady is offline  
Reply
Old 05-13-08 | 07:22 AM
  #5  
envane's Avatar
Senior Member
 
Joined: Apr 2008
Posts: 828
Likes: 0
From: Chicago
Oh yeah, and list braze-ons, bosses, eyelets, etc. The important stuff.
envane is offline  
Reply
Old 05-13-08 | 07:23 AM
  #6  
supcom's Avatar
You need a new bike
20 Anniversary
 
Joined: Aug 2002
Posts: 5,433
Likes: 4
https://home.comcast.net/~pinnah/dirt...y-project.html
supcom is offline  
Reply
Old 05-13-08 | 07:38 AM
  #7  
BarracksSi's Avatar
Bike ≠ Car ≠ Ped.
15 Anniversary
 
Joined: Jul 2007
Posts: 13,863
Likes: 6
From: Washington, DC

Bikes: Some bikes. Hell, they're all the same, ain't they?

It would be cool to go beyond that site and have the specs for as many sizes as possible. Ken's page is great for seeing which models have which tendencies (sorting by chainstay length is particularly telling, as it puts race bikes at one end and touring bikes at the other), but it's not as good for shopping around for frames that would fit a person's particular size.
BarracksSi is offline  
Reply
Old 05-13-08 | 11:48 AM
  #8  
HiYoSilver's Avatar
Rides again
 
Joined: Oct 2004
Posts: 3,282
Likes: 1
From: SW. Sacramento Region, aka, down river

Bikes: Giant OCR T, Trek SC

Go over to slowtwitch and read their tech articles on fitting and frame design. Without stack and reach measurements, don't see value in this project.
HiYoSilver is offline  
Reply
Old 05-13-08 | 02:38 PM
  #9  
Senior Member
15 Anniversary
 
Joined: Jan 2006
Posts: 1,128
Likes: 15
From: Columbus, Ohio

Bikes: Rivendell A.Homer Hilsen, Paramount P13, (4) Falcon bicycles, Mondia Special, Rodriguez Tandem

I think this site is exactly what the OP was asking for. It will have more sizes if more people contribute measurements. This project was designed and is maintained by David Mann.
MKahrl is offline  
Reply
Old 05-13-08 | 05:24 PM
  #10  
BarracksSi's Avatar
Bike ≠ Car ≠ Ped.
15 Anniversary
 
Joined: Jul 2007
Posts: 13,863
Likes: 6
From: Washington, DC

Bikes: Some bikes. Hell, they're all the same, ain't they?

Originally Posted by MKahrl
I think this site is exactly what the OP was asking for. It will have more sizes if more people contribute measurements. This project was designed and is maintained by David Mann.
If he wants more sizes, he'll have to change the wording on the page -- it's still asking for around 56-58 cm as the manufacturer's published "size".

But, picture this, though -- input a range for the effective top tube length, a range for the chainstay, and a range for seat tube angle, and it'll spit out the frames & models that fit within those parameters.

I think that's the goal that the OP is looking for.
BarracksSi is offline  
Reply
Old 05-14-08 | 09:06 AM
  #11  
totoroben's Avatar
Thread Starter
Ben
 
Joined: Aug 2006
Posts: 150
Likes: 0
From: Cleveland. Shaker Heights

Bikes: Rans V-Rex, Schwinn Traveler, Panasonic Sport

Originally Posted by envane
You would need to use a real database type setup, wiki is crap for databases.
I meant that it would be a wiki in the sense that it could be added to by anyone. An open database.
Originally Posted by BarracksSi
But, picture this, though -- input a range for the effective top tube length, a range for the chainstay, and a range for seat tube angle, and it'll spit out the frames & models that fit within those parameters.
you pretty much hit the nail on the head.
Originally Posted by HiYoSilver
Without stack and reach measurements, don't see value in this project.
your such a killjoy.
totoroben is offline  
Reply
Old 05-14-08 | 09:12 AM
  #12  
totoroben's Avatar
Thread Starter
Ben
 
Joined: Aug 2006
Posts: 150
Likes: 0
From: Cleveland. Shaker Heights

Bikes: Rans V-Rex, Schwinn Traveler, Panasonic Sport

Originally Posted by envane
I think one aspect of geometry that is really important that most companies totally ingnore is allowable tire clearances (w/ and w/o fenders). That gets asked a lot on bikeforums.
That is pretty important and would be a good addition. Maybe someone could just take the bike geometry project and make a searchable database as a spinoff that includes more information.
totoroben is offline  
Reply
Old 05-14-08 | 06:51 PM
  #13  
BarracksSi's Avatar
Bike ≠ Car ≠ Ped.
15 Anniversary
 
Joined: Jul 2007
Posts: 13,863
Likes: 6
From: Washington, DC

Bikes: Some bikes. Hell, they're all the same, ain't they?

Originally Posted by totoroben
you pretty much hit the nail on the head.
Ok, good...

What would make it really useful would be loads of data from older frames, especially those that are no longer published on manufacturers' websites. That would take a lot of the guesswork out of choosing whether to buy a particular used bike.
BarracksSi is offline  
Reply
Old 05-15-08 | 09:39 AM
  #14  
totoroben's Avatar
Thread Starter
Ben
 
Joined: Aug 2006
Posts: 150
Likes: 0
From: Cleveland. Shaker Heights

Bikes: Rans V-Rex, Schwinn Traveler, Panasonic Sport

I was thinking of the domain bicycleprofile.com. How does this sound to you guys? Who can code a database? I would also like the ability to add pictures of the bicycles. I would like the database to include as many diamond frame bicycles as possible.
totoroben is offline  
Reply
Old 05-15-08 | 10:41 AM
  #15  
Road Fan's Avatar
Senior Member
20 Anniversary
 
Joined: Apr 2005
Posts: 17,196
Likes: 761
From: Ann Arbor, MI

Bikes: 1980 Masi, 1984 Mondonico, 1984 Trek 610, 1980 Woodrup Giro, 2005 Mondonico Futura Leggera ELOS, 1967 PX10E, 1971 Peugeot UO-8

Originally Posted by totoroben
I was thinking of the domain bicycleprofile.com. How does this sound to you guys? Who can code a database? I would also like the ability to add pictures of the bicycles. I would like the database to include as many diamond frame bicycles as possible.
Why not ask Pinnah, the owner of the Bicycle Geometry Project, about doing this as an extension to his, or at least permitting his Excel file to be used as a data core and starting point? He's on BikeForums. His list of frames is Excel, but I think it could be ported to SQL, then expanded into what the OP and some of the rest here might like to see.

BTW, Ken on the Project site only contributed some of his frame data and the frame measuring essay. I think he's planning an update using digital levels.

Road Fan

Last edited by Road Fan; 05-15-08 at 10:45 AM.
Road Fan is offline  
Reply
Old 05-15-08 | 10:46 AM
  #16  
Road Fan's Avatar
Senior Member
20 Anniversary
 
Joined: Apr 2005
Posts: 17,196
Likes: 761
From: Ann Arbor, MI

Bikes: 1980 Masi, 1984 Mondonico, 1984 Trek 610, 1980 Woodrup Giro, 2005 Mondonico Futura Leggera ELOS, 1967 PX10E, 1971 Peugeot UO-8

Originally Posted by totoroben
That is pretty important and would be a good addition. Maybe someone could just take the bike geometry project and make a searchable database as a spinoff that includes more information.
With this kind of detail the frame characterization becomes close to what a custom framebuilder might need. Could there be some software over at the Framebuilder Forum that is useful as a hosting environment?
Road Fan is offline  
Reply
Old 05-15-08 | 03:37 PM
  #17  
BarracksSi's Avatar
Bike ≠ Car ≠ Ped.
15 Anniversary
 
Joined: Jul 2007
Posts: 13,863
Likes: 6
From: Washington, DC

Bikes: Some bikes. Hell, they're all the same, ain't they?

<-- doesn't know jack squat about coding, database creation, web page creation, Wiki-type searching, etc. Just thinking like an end user; in other words, it should be easy enough for a doofus like me.
BarracksSi is offline  
Reply
Old 05-15-08 | 06:48 PM
  #18  
HiYoSilver's Avatar
Rides again
 
Joined: Oct 2004
Posts: 3,282
Likes: 1
From: SW. Sacramento Region, aka, down river

Bikes: Giant OCR T, Trek SC

Originally Posted by totoroben
your such a killjoy.
Did you read any of those articles? Without stack and reach it doesn't help much, there are simply too many variables when all that matters are:

1. height of saddle above bb
2. horizontal offset of saddle to bb
3. reach to handlebars
4. vertical offset to handlebars

You can have all sorts of variety of seat tube angles, top tube lengths,
etc and yet have all 4 of those the same.
HiYoSilver is offline  
Reply
Old 05-15-08 | 07:04 PM
  #19  
BarracksSi's Avatar
Bike ≠ Car ≠ Ped.
15 Anniversary
 
Joined: Jul 2007
Posts: 13,863
Likes: 6
From: Washington, DC

Bikes: Some bikes. Hell, they're all the same, ain't they?

Originally Posted by HiYoSilver
You can have all sorts of variety of seat tube angles, top tube lengths,
etc and yet have all 4 of those the same.
Right, but then again, using a ridiculously long or short stem, or a whole lot of saddle setback, or both, changes the characteristics of the bike so that it no longer behaves as the manufacturer intended.
BarracksSi is offline  
Reply
Old 05-15-08 | 08:26 PM
  #20  
DCCommuter's Avatar
52-week commuter
 
Joined: Mar 2005
Posts: 1,929
Likes: 1
From: Washington, DC

Bikes: Redline Conquest, Cannonday, Specialized, RANS

Originally Posted by HiYoSilver
Did you read any of those articles? Without stack and reach it doesn't help much, there are simply too many variables when all that matters are:

1. height of saddle above bb
2. horizontal offset of saddle to bb
3. reach to handlebars
4. vertical offset to handlebars

You can have all sorts of variety of seat tube angles, top tube lengths,
etc and yet have all 4 of those the same.

There are two things you care about with a frame -- fit and handling. Since your body only touches the bike in three spots -- hands, feet and seat -- fit is entirely determined by the shape of the triangle between saddle, handlebars, and bottom bracket. So you're kind of right.

But handling is determined by everything else. That's why bikes come in so many shapes and sizes.

What I would like to see is a database where I put in the dimensions I want and it gives me examples. Even better would be one where I tell it my fit dimensions and my desired handling and it gives me suggestions.
__________________
The United States of America is the only democratic nation in the world to deny citizens living in the nation's capital representation in the national legislature. District residents have no vote in either the U.S. Senate or U.S. House of Representatives. www.dcvote.org
DCCommuter is offline  
Reply
Old 05-15-08 | 10:07 PM
  #21  
totoroben's Avatar
Thread Starter
Ben
 
Joined: Aug 2006
Posts: 150
Likes: 0
From: Cleveland. Shaker Heights

Bikes: Rans V-Rex, Schwinn Traveler, Panasonic Sport

Okay now say a person has a completely original Raleigh with all original parts. If all the components are original they could also be included in the bicycles profile such as crank length, brake type, deraillers etc. What do you guys think of that? Would it be of any value? Should we just stick with frames? I think it would be great to include as much info as possible on every bike model. The extra info cant hurt can it?
totoroben is offline  
Reply
Old 05-15-08 | 11:12 PM
  #22  
Senior Member
 
Joined: Oct 2007
Posts: 306
Likes: 0
This may help, If you have not already seen it

https://www.bikepedia.com/QuickBike/Default.aspx
bigtruck is offline  
Reply
Old 05-16-08 | 03:11 AM
  #23  
BarracksSi's Avatar
Bike ≠ Car ≠ Ped.
15 Anniversary
 
Joined: Jul 2007
Posts: 13,863
Likes: 6
From: Washington, DC

Bikes: Some bikes. Hell, they're all the same, ain't they?

Originally Posted by bigtruck
This may help, If you have not already seen it

https://www.bikepedia.com/QuickBike/Default.aspx
Pretty cool; it's got everything but geometries, but that's a huge resource.
BarracksSi is offline  
Reply
Old 05-16-08 | 09:48 AM
  #24  
totoroben's Avatar
Thread Starter
Ben
 
Joined: Aug 2006
Posts: 150
Likes: 0
From: Cleveland. Shaker Heights

Bikes: Rans V-Rex, Schwinn Traveler, Panasonic Sport

I agree, it needs geometries and pictures. It could also use bicycles before 1993.
totoroben is offline  
Reply
Old 05-17-08 | 07:00 AM
  #25  
Road Fan's Avatar
Senior Member
20 Anniversary
 
Joined: Apr 2005
Posts: 17,196
Likes: 761
From: Ann Arbor, MI

Bikes: 1980 Masi, 1984 Mondonico, 1984 Trek 610, 1980 Woodrup Giro, 2005 Mondonico Futura Leggera ELOS, 1967 PX10E, 1971 Peugeot UO-8

Originally Posted by HiYoSilver
Did you read any of those articles? Without stack and reach it doesn't help much, there are simply too many variables when all that matters are:

1. height of saddle above bb
2. horizontal offset of saddle to bb
3. reach to handlebars
4. vertical offset to handlebars

You can have all sorts of variety of seat tube angles, top tube lengths,
etc and yet have all 4 of those the same.
Hiyo, I think you're right for the full breadth of utility that Toto has in mind, a very full set of frame numbers is needed. But that poses a problem, of whether that info is available, or does it have to be measured? What should the site owner do with partial data submissions?

I would say design the site to handle the full breadth, including the items you asked for, but accept all the inputs you get, regardless of completeness. Hope that they'll become "finished" somehow later on.

Road Fan
Road Fan is offline  
Reply


Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.