 
     |
| 88 database guy (Page 37/75) |
|
Sundowner
|
JUL 01, 11:09 AM
|
|
What I'd like to do is create a very simple web app to get started. The app would primarily function to enable users to view data and add data. The "adds" would be moderated by a select few members to ensure the information is good.
These are the fields I think I would start with for the Fiero table.
VIN:
Year:
Type:
Exterior:
Wheels:
Interior:
Seats:
Options:
Engine:
Transmission:
Location:
Mileage:
Condition:
Status:
PFF Member:
|
|
|
|
Dburger
|
JUL 01, 01:16 PM
|
|
VIN: 1G2PE11R0JP222635
Year: 1988
Type: Coupe
Exterior: White
Wheels: Turbo aluminum
Interior: Gray
Seats: Two tone gray leather
Options: Power nothing, automatic transmission, added spoiler (too far forward), T-Tops, no decklid release
Engine: 2.5L
Transmission: Automatic
Location: Sacramento, CA
Mileage: 183,000
Condition: Wrecked in front
Status: Auctioned off as a salvage vehicle
PFF Member: None
http://www.autobidmaster.com/carfinder-online-auto-auctions/lot/13747784/COPART_1988_PONTIAC_FIERO_SALVAGE_CERTIFI CATE_SO_SACRAMENTO_CA/
I suppose we could include the roof type in options? I usually round the mileage down if the 4th digit in the odometer is under 5, or I round it up if it is.[This message has been edited by Dburger (edited 07-01-2014).]
|
|
|
|
Dburger
|
JUL 01, 01:41 PM
|
|
VIN: 1G2PE11R9JP209835
Year: 1988
Type: Coupe
Exterior: Red
Wheels: Turbo aluminum
Interior: Gray
Seats: Dark gray suede/velour
Options: Sport/Western package with spoiler and body colored lower rear bumper trim, power nothing, automatic transmission, T-Tops,
Engine: 2.5L
Transmission: Automatic
Location: Long Island, NY
Mileage: 206,000
Condition: Rough
Status: Auctioned off as a salvage vehicle on April 30, 2014
PFF Member: None
http://www.autobidmaster.co...IERO_LONG_ISLAND_NY/
|
|
|
|
Gall757
|
JUL 01, 01:58 PM
|
|
Sundowner; What would your app do?
Could I ask it questions like:
How many cars have been junked?
How many cars are GTs?
What percent of cars have been reported?
How many are now kit rebodys?
How many cars are 5 speeds?
Who would be the host?
|
|
|
|
Dburger
|
JUL 01, 02:06 PM
|
|
|
No real way to tell if the salvage vehicles have been junked. Adding to that, it would be cool if we could see how many of each body style are registered, and how many of each transmission type. I'm still willing to register other years as well. [This message has been edited by Dburger (edited 07-01-2014).]
|
|
|
|
Dburger
|
JUL 01, 02:43 PM
|
|
|
|
|
Dburger
|
JUL 01, 03:01 PM
|
|
VIN: 1G2PE11R7JP209106
Year: 1988
Type: Coupe
Exterior: Silver
Wheels: Turbo aluminum
Interior: Gray cloth
Options: Power nothing, big drag style tach with shift light, red 84 decklid, no trunk release
Engine: 2.5L
Transmission: Manual
Location: Hartford, CT
Mileage: 154,000
Condition: A little messed up in the front
Status: Auctioned off as a salvage vehicle on April 15, 2014
PFF Member: None
http://www.autobidmaster.co...IERO_ST_HARTFORD_CT/
|
|
|
|
Sundowner
|
JUL 01, 03:03 PM
|
|
Sure we could ask it those questions, but it would still depend on the number of vehicles that have been recorded into the database.
Some assumptions would have to be made in order to garner usable statistics.
For instance, if you want to know the number of Formulas that are registered and have their original 2.8 in them... You'd use the existing records as a sample of the whole.
If the database contains 650 Formulas and we assume this is a random sample of the 5484 Formulas that were originally built, and 200 (about 30%) are registered and of those 100 are motor swapped, then we can assume approx 15% of the 5484 Formulas that were built are registered and original for a total of about 822 cars. (These are just made up figures)
Of course you know what they say about assumptions...  It comes down to where you guys are getting most of the information from.
I think this would be a fun app to build guys... I wouldn't have the time to enter in all the data however so I'd be looking for help. In order to not waste anybody's time I'd say give me a little time to build the basic framework and then we can look into moving all the information over from here on the forums into the application database. Proof of concept before anything.
|
|
|
|
FIERO JOHN-WI
|
JUL 02, 11:17 AM
|
|
|
I have supported and helped John along the way in his efforts and in return he has help me with any little data he might get for my 1988 Fiero t top cars (that I have been collecting since 1991). I hope if you take on this project you continue to add the "ROOF TYPE" in this app it is very important for the history of the car and options out there on all 88 Fieros.
|
|
|
|
Sundowner
|
JUL 02, 01:08 PM
|
|
There's no need for a Roof Type field. Sunroof and T-tops would be selectable options that could be attributed to the record.
I think a really good feature of the app would be to hard code in a VIN decoder so that original car information could be displayed next to the most currently known configuration of the car.
Perhaps, also, the ability for site members to assume ownership of their car records and add additional details and notes.
|
|
|
|