# Postgres Table Design

Today I worked with Dan Halperin and Brandon Holt on Postgres table design for our KBMOD project. We are using the PostGIS package to provide support for spatial overlap queries (on the celestial sphere instead of the terrestrial one). The big challenge is how to optimally store (and to query) information on 1e6 images that contain a total of 1e12 pixels. The ultimate goal is to intersect these data with proposed orbits of Solar System objects to understand if there is evidence for them in the time series of images.