Database Change Log for 2001

This log reflects changes performed by the curator. Other data additions are done on an on-going basis by the catalogers.

content
Year Currently Showing Year of 2001
2024 2023 2022 2021 2020
2019 2018 2017 2016 2015
2014 2013 2012 2011 2010
2009 2008 2007 2006 2005
2004 2003 2002 2001 2000
1999 1998 1997 1996
  1. December 27, 2001: Changed the FRAME field size from 7 to 9 in all the database tables that have a FRAME field. This change should be transparent to the general user but was needed in order to be able to import EarthKam records.
  2. December 14, 2001: Changed the clickable map query so that the user has the option of selecting whether or not to return records that have no available image in the database. Also changed it so that the results are sorted in reverse date order with a suborder of photo ID. Since the results are sorted by date, the DAY field was made a default field for showing up in the query results.
  3. December 7, 2001: The clickable map query was changed from using 5 degree blocks of search resolution to using 2.5 degree blocks.
  4. December 6, 2001: Finished adding ISS001 ISD CD 35mm images.
  5. December 5, 2001: The Mission-Roll-Frame query was modified to accept wild cards for IDs listed in the multi-line box where photo IDs are typed.
  6. December 4, 2001: Reconfigured the clickable map query so that it no longer uses the 5 degree block (hash) files. So rather than using precompiled lists of photos for each block, the search now does a straight coordinate search in the database. This causes the set of records returned by the clickable map query to always be current with what is in the database file.
  7. November 21, 2001: Finished adding STS106 ISD PhotoCD 35mm images. Started adding ISS001 ISD CD 35mm images.
  8. November 19, 2001: Finished adding STS104 ISD PhotoCD 70mm images. Started adding STS106 ISD PhotoCD 35mm images.
  9. November 15, 2001: Rebuilt all the clickable map search 5 degree block files to include all currently-cataloged photos.
  10. October 30, 2001: Installed a new database interface program for all database query CGI's the provides feedback from the database on connection errors.
  11. October 10, 2001: Finished adding STS098 ISD CD (35mm) images that were missing.
  12. October 4, 2001: Started adding STS106 ISD PhotoCD (70mm) images.
  13. October 2, 2001: Started adding STS098 ISD CD (35mm) images that were missing due to late film delivery.
  14. October 1, 2001: Finished adding STS102 ISD PhotoCD images (70mm) except for 7 photos that had wrong images on the CD.
  15. September 25, 2001: Added STS102 ISD Web Gallery CD 35mm images. Started adding STS104 ISD PhotoCD (70mm) images. Added STS073 ESC images.
  16. September 24, 2001: Finished adding ISD CD images (35mm) for STS098. Added ISS002 35mm images from ISD Web Gallery CD.
  17. September 20, 2001: Started adding ISD PhotoCD images (70mm) for STS102 and ISD CD images (35mm) for STS098.
  18. September 17, 2001: Indexes were created for the LAT (latitude) and LON (longitude) fields. This means that queries by latitude/longitude will run faster.
  19. September 14, 2001: Rebuilt all the clickable map search 5 degree block files to include all currently-cataloged photos. Also fixed the clickable maps search so that it sorts the results by mission-roll-frame.
  20. September 14, 2001: Finished adding STS092 ISD CD images (35mm).
  21. September 13, 2001: Finished converting 35mm ISD CDs TIF images into JPEG.
  22. August, 2001: Finished STS100 ISD PhotoCDs (70mm).
  23. August, 2001: Started adding images from ISD CDs for STS092 35mm.
  24. July 23, 2001: Started adding images from STS100 ISD PhotoCDs (70mm).
  25. July 20, 2001: Finished adding images from ISS002 ISD PhotoCDs (70mm).
  26. July 18, 2001: Finished adding images from ISS001 ISD PhotoCDs (70mm).
  27. July 11, 2001: Started adding images from ISS002 ISD PhotoCDs.
  28. July, 2001: Finished adding images from STS097 ISD PhotoCDs (70mm).
  29. July, 2001: Finished adding STS098 ISD PhotoCDs (70mm).
  30. June 25, 2001: Finished adding STS092 images from ISD PhotoCDs (70mm).
  31. June 19, 2001: Started adding images from STS098 ISD PhotoCDs (70mm).
  32. June 18, 2001: Finished adding 35mm images from ISD CDROMs for STS097.
  33. June 13, 2001: Started adding 35mm images from ISD CDROMs for STS097.
  34. May, 2001: Started adding images from STS097 ISD PhotoCDs.
  35. April 24, 2001: Started reading ISD PhotoCDs to add STS092 images.
  36. March 8, 2001: Removed the NORTH field from the FRAMES table. Added dates or partial dates for STS099 records that were missing dates.
  37. January 31, 2001: Completed adding missing dates and replacing malformed dates for NM21, NM22, NM23 and NASA6. Also added missing months for those that had only the year for these missions plus NASA5 and NASA7.
  38. January 26, 2001: Started adding missing dates and replacing malformed dates for NM21, NM22, NM23 and NASA6 (NASA5 and NASA7 don't have dates missing).
  39. January 18, 2001: Added STS092 camera and film information.
  40. January 12, 2001: Replaced the cities search page with a version contains more features.