MACADAMIA Sloan Digital Sky Survey Asteroid Photometry, Measurements, and Images

This dataset contains data from the Multi-Archive Catalog of Asteroid Detections And Measurements for Interactive Access (MACADAMIA), specifically of numbered asteroids observed serendipitously by the Sloan Digital Sky Survey (SDSS).

photometry_archive_20201027.db is a SQLite database containing data corresponding to a search of the SDSS image archive conducted on 2020 May 1 of all numbered asteroids known at the time, which yielded 2.84 million search results, 1.98 million detections that were determined to actually be within the field of view of the identified image, and 993,777 successfully measured detections.  Preview images of all detections and non-detections where the object was determined to be within the field of view of an identified image are collected in the detection_previews_*tar.gz files in this dataset, indexed by detection_id in the photometry database and listed under preview_image_file in the detection_data table.

photometry_archive_20210927.db contains an update to the SDSS search, containing data corresponding to a search of the SDSS image archive conducted on 2021 July 2 of all numbered asteroids known at the time, which yielded 2.96 million search results, 2.06 million detections that were determined to actually be within the field of view of the identified image, and 1.02 million successfully measured detections.  Previews of additional detections identified in this updated search may not be available due to data loss in a system failure in August 2023.