jcolwell.ca © 2006 J.L. Colwell

<home>

 

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

 

Last update: 2006-09-24

 

<home>

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.