Index: trunk/ippToPsps/jython/scratchdb.py
===================================================================
--- trunk/ippToPsps/jython/scratchdb.py	(revision 32590)
+++ trunk/ippToPsps/jython/scratchdb.py	(revision 33147)
@@ -26,4 +26,5 @@
             self.dvoDetectionTable = "dvoDetectionFull"
             self.dvoDoneTable = "dvoDone"
+            self.dvoSkyTable = "SkyTable_fits"
         else:
             self.dvoMetaTable = "dvoMeta"
@@ -302,3 +303,28 @@
 
 
-
+    '''
+    Gets a list of PSPS image IDs for this stack ID
+    '''
+    def getDvoFilesCoveringThisRegion(self, minRa, maxRa, minDec, maxDec):
+
+        self.logger.debug("Querying DVO SkyTable for FITS files in this region")
+
+        sql = "SELECT name FROM " + self.dvoSkyTable + " \
+               WHERE NOT ((" + str(maxRa) + " <= R_MIN) OR \
+                       (" + str(minRa) + " >= R_MAX) OR \
+                       (" + str(maxDec) + " <= D_MIN) OR \
+                       (" + str(minDec) + " >= D_MAX)) "
+
+        try:
+            rs = self.executeQuery(sql)
+        except:
+            self.logger.exception("Can't query for imageIDs")
+
+        files = []
+        while (rs.next()):
+            files.append(rs.getString(1))
+        rs.close()
+
+        return files
+
+