jcolwell.ca © 2006 J.L. Colwell |
SPLOSdb: SMC
Pentax lenses and other stuff database
J.L. Colwell, Canada, 2004-02-29 (with price updates to
2004-09-31)
This is a
very old link. Please go to the new home page
ABSTRACT
The SMC Pentax lenses and other stuff database, SPLOSdb,
includes contemporary prices and information on SMC Pentax and selected
“third party” lenses for Pentax K-mount bodies, and other stuff including:
teleconverters; flash; macro accessories; special adapters; Pentax LX and
accessories; and, the *istD. The
prices are mostly for used equipment in excellent to mint condition, based on
over 2000 eBay sales during a three month period from to , and on list prices
at about 70 camera stores with online inventories. A total of 470 lenses and 100 other stuff
are itemized in SPLOSdb. Each item has
specific information on prices, dates the prices were observed, and the
number of sales on eBay over the three months. The database also includes a lens quality
rating system and a variety of physical properties such as minimum focus
distance, weight, size and other relevant properties. The database is distributed in .pdf format
for printing and viewing, and in ‘comma-delimited’ data files. This paper provides an overview of the
database, documents the categories and procedures used to define the
database, and discusses lens availability (i.e. common vs. rare), including
“Top-10” lists. |
The main files (version 0, 2004-02-29)
SPLOS.pdf ....................................... documentation;
a technical report formatted for printing (41 pages)
SPLOSdb.pdf .................................. the
database; a spreadsheet formatted for printing (24 pages)
Database Price Updates
SPLOSdb-2004-09-31.pdf
............ the database with
prices updated to 2004-09-31 ( pages)
SPLOSdb-2004-06-30.pdf ............ the database with prices
updated to 2004-06-30 (30 pages)
All files ((version 0, 2004-02-29)
SPLOSdb.zip (523,705 bytes) contains these 11 files
SPLOS.pdf .................................... documentation [251,331
bytes]
SPLOSdb.pdf ............................... database [388,099 bytes]
SPLOSdb1-Kp.csv ...................... SMC Pentax prime lenses [11,295 bytes]
SPLOSdb2-Kz.csv ....................... SMC Pentax zoom lenses [6,668 bytes]
SPLOSdb3-Tak.csv ..................... SMC Takumar lenses [4,213 bytes]
SPLOSdb4-big4.csv.................... Big Four: Sigma, Tokina, Tamron and
Vivitar [13,333 bytes]
SPLOSdb5-oLens.csv ................ other lenses [9,486
bytes]
SPLOSdb6-oStuff.csv ................. other stuff [4,045
bytes]
SPLOSdb7-LX.csv ....................... LX and accessories [4,067 bytes]
SPLOSdb8-istD.csv .................... *istD and a few accessories [1,677 bytes]
SPLOSdb9-notes.csv ................. notes cited in the
previous files [1,415 bytes]
Links
SPLOSdb links ............................... links to
web sites with information used in SPLOS
email
Please send SPLOSdb comments and suggestions
to SPLOSdb@jcolwell.ca
Copyright
Notice - SMC Pentax Lenses and Other
Stuff database (SPLOSdb) is Copyright © J.L. Colwell 2006. You may copy and freely distribute the
database to others, but you may not charge nor accept any fees, and you may
not modify the database. You may
incorporate any information from SPLOSdb in other publications (online and
otherwise), as long as you acknowledge the source. Trademarks
- Pentax, SMC, Ashai,
Takumar and related names are trademarks or registered trademarks of PENTAX
Corporation (www.pentax.com). eBay and
related names are trademarks or registered trademarks of eBay Incorporated (www.eBay.com). All other brands and product names are
trademarks or registered trademarks of their respective companies. Acknowledgements - I am grateful to the many people
who share photography information online. I want to say a special thanks to Bojidar
Dimitrov for his excellent KMP web site, kmp.BDimitrov.de. I attempt to acknowledge all sources I have
used, except not eBay auctions. I
apologize to any sources I have missed.
I also want to thank Bojidar Dimitrov and Harold Merklinger (www.trenholm.org/hmmerk/) for
reviewing the SPLOSdb draft documentation - their corrections, comments and
suggestions were much appreciated. Disclaimers - The assessment of SPLOSdb
reliability discussed in SPLOS.pdf suggests that the accuracy is high, but
there certainly are errors and omissions - use this information at your own
risk. Many of the prices in SPLOSdb are from “Other Suppliers”
which are camera shops with online inventories of used gear. These prices may not be the lowest
available, and the items may not be still available. I can’t guarantee that these Other
Suppliers are reliable, but I’ve personally had consistently good
results. I am not affiliated in any
way with eBay nor with any Other Suppliers cited in SPLOSdb. I am not
affiliated in any way with Pentax. |