diff --git a/sql/create_objectfulloverlap.sql b/sql/create_objectfulloverlap.sql new file mode 100644 index 0000000000000000000000000000000000000000..a2e6e6a48cc449458cd706ed3c2414f11aee3387 --- /dev/null +++ b/sql/create_objectfulloverlap.sql @@ -0,0 +1,239 @@ +CREATE TABLE %(tabname)s + (deepSourceId BIGINT NOT NULL + ,ra double NOT NULL + ,decl double NOT NULL + ,raVar double DEFAULT NULL + ,declVar double DEFAULT NULL + ,radeclCov double DEFAULT NULL + ,chunkId INT NOT NULL + ,subChunkId INT NOT NULL + ,u_psfFlux double DEFAULT NULL + ,u_psfFluxSigma double DEFAULT NULL + ,u_apFlux double DEFAULT NULL + ,u_apFluxSigma double DEFAULT NULL + ,u_modelFlux double DEFAULT NULL + ,u_modelFluxSigma double DEFAULT NULL + ,u_instFlux double DEFAULT NULL + ,u_instFluxSigma double DEFAULT NULL + ,u_apCorrection double DEFAULT NULL + ,u_apCorrectionSigma double DEFAULT NULL + ,u_shapeIx double DEFAULT NULL + ,u_shapeIy double DEFAULT NULL + ,u_shapeIxVar double DEFAULT NULL + ,u_shapeIyVar double DEFAULT NULL + ,u_shapeIxIyCov double DEFAULT NULL + ,u_shapeIxx double DEFAULT NULL + ,u_shapeIyy double DEFAULT NULL + ,u_shapeIxy double DEFAULT NULL + ,u_shapeIxxVar double DEFAULT NULL + ,u_shapeIyyVar double DEFAULT NULL + ,u_shapeIxyVar double DEFAULT NULL + ,u_shapeIxxIyyCov double DEFAULT NULL + ,u_shapeIxxIxyCov double DEFAULT NULL + ,u_shapeIyyIxyCov double DEFAULT NULL + ,u_extendedness double DEFAULT NULL + ,u_flagNegative BOOLEAN DEFAULT NULL + ,u_flagBadMeasCentroid BOOLEAN DEFAULT NULL + ,u_flagPixEdge BOOLEAN DEFAULT NULL + ,u_flagPixInterpAny BOOLEAN DEFAULT NULL + ,u_flagPixInterpCen BOOLEAN DEFAULT NULL + ,u_flagPixSaturAny BOOLEAN DEFAULT NULL + ,u_flagPixSaturCen BOOLEAN DEFAULT NULL + ,u_flagBadPsfFlux BOOLEAN DEFAULT NULL + ,u_flagBadApFlux BOOLEAN DEFAULT NULL + ,u_flagBadModelFlux BOOLEAN DEFAULT NULL + ,u_flagBadInstFlux BOOLEAN DEFAULT NULL + ,u_flagBadCentroid BOOLEAN DEFAULT NULL + ,u_flagBadShape BOOLEAN DEFAULT NULL + ,g_psfFlux double DEFAULT NULL + ,g_psfFluxSigma double DEFAULT NULL + ,g_apFlux double DEFAULT NULL + ,g_apFluxSigma double DEFAULT NULL + ,g_modelFlux double DEFAULT NULL + ,g_modelFluxSigma double DEFAULT NULL + ,g_instFlux double DEFAULT NULL + ,g_instFluxSigma double DEFAULT NULL + ,g_apCorrection double DEFAULT NULL + ,g_apCorrectionSigma double DEFAULT NULL + ,g_shapeIx double DEFAULT NULL + ,g_shapeIy double DEFAULT NULL + ,g_shapeIxVar double DEFAULT NULL + ,g_shapeIyVar double DEFAULT NULL + ,g_shapeIxIyCov double DEFAULT NULL + ,g_shapeIxx double DEFAULT NULL + ,g_shapeIyy double DEFAULT NULL + ,g_shapeIxy double DEFAULT NULL + ,g_shapeIxxVar double DEFAULT NULL + ,g_shapeIyyVar double DEFAULT NULL + ,g_shapeIxyVar double DEFAULT NULL + ,g_shapeIxxIyyCov double DEFAULT NULL + ,g_shapeIxxIxyCov double DEFAULT NULL + ,g_shapeIyyIxyCov double DEFAULT NULL + ,g_extendedness double DEFAULT NULL + ,g_flagNegative BOOLEAN DEFAULT NULL + ,g_flagBadMeasCentroid BOOLEAN DEFAULT NULL + ,g_flagPixEdge BOOLEAN DEFAULT NULL + ,g_flagPixInterpAny BOOLEAN DEFAULT NULL + ,g_flagPixInterpCen BOOLEAN DEFAULT NULL + ,g_flagPixSaturAny BOOLEAN DEFAULT NULL + ,g_flagPixSaturCen BOOLEAN DEFAULT NULL + ,g_flagBadPsfFlux BOOLEAN DEFAULT NULL + ,g_flagBadApFlux BOOLEAN DEFAULT NULL + ,g_flagBadModelFlux BOOLEAN DEFAULT NULL + ,g_flagBadInstFlux BOOLEAN DEFAULT NULL + ,g_flagBadCentroid BOOLEAN DEFAULT NULL + ,g_flagBadShape BOOLEAN DEFAULT NULL + ,r_psfFlux double DEFAULT NULL + ,r_psfFluxSigma double DEFAULT NULL + ,r_apFlux double DEFAULT NULL + ,r_apFluxSigma double DEFAULT NULL + ,r_modelFlux double DEFAULT NULL + ,r_modelFluxSigma double DEFAULT NULL + ,r_instFlux double DEFAULT NULL + ,r_instFluxSigma double DEFAULT NULL + ,r_apCorrection double DEFAULT NULL + ,r_apCorrectionSigma double DEFAULT NULL + ,r_shapeIx double DEFAULT NULL + ,r_shapeIy double DEFAULT NULL + ,r_shapeIxVar double DEFAULT NULL + ,r_shapeIyVar double DEFAULT NULL + ,r_shapeIxIyCov double DEFAULT NULL + ,r_shapeIxx double DEFAULT NULL + ,r_shapeIyy double DEFAULT NULL + ,r_shapeIxy double DEFAULT NULL + ,r_shapeIxxVar double DEFAULT NULL + ,r_shapeIyyVar double DEFAULT NULL + ,r_shapeIxyVar double DEFAULT NULL + ,r_shapeIxxIyyCov double DEFAULT NULL + ,r_shapeIxxIxyCov double DEFAULT NULL + ,r_shapeIyyIxyCov double DEFAULT NULL + ,r_extendedness double DEFAULT NULL + ,r_flagNegative BOOLEAN DEFAULT NULL + ,r_flagBadMeasCentroid BOOLEAN DEFAULT NULL + ,r_flagPixEdge BOOLEAN DEFAULT NULL + ,r_flagPixInterpAny BOOLEAN DEFAULT NULL + ,r_flagPixInterpCen BOOLEAN DEFAULT NULL + ,r_flagPixSaturAny BOOLEAN DEFAULT NULL + ,r_flagPixSaturCen BOOLEAN DEFAULT NULL + ,r_flagBadPsfFlux BOOLEAN DEFAULT NULL + ,r_flagBadApFlux BOOLEAN DEFAULT NULL + ,r_flagBadModelFlux BOOLEAN DEFAULT NULL + ,r_flagBadInstFlux BOOLEAN DEFAULT NULL + ,r_flagBadCentroid BOOLEAN DEFAULT NULL + ,r_flagBadShape BOOLEAN DEFAULT NULL + ,i_psfFlux double DEFAULT NULL + ,i_psfFluxSigma double DEFAULT NULL + ,i_apFlux double DEFAULT NULL + ,i_apFluxSigma double DEFAULT NULL + ,i_modelFlux double DEFAULT NULL + ,i_modelFluxSigma double DEFAULT NULL + ,i_instFlux double DEFAULT NULL + ,i_instFluxSigma double DEFAULT NULL + ,i_apCorrection double DEFAULT NULL + ,i_apCorrectionSigma double DEFAULT NULL + ,i_shapeIx double DEFAULT NULL + ,i_shapeIy double DEFAULT NULL + ,i_shapeIxVar double DEFAULT NULL + ,i_shapeIyVar double DEFAULT NULL + ,i_shapeIxIyCov double DEFAULT NULL + ,i_shapeIxx double DEFAULT NULL + ,i_shapeIyy double DEFAULT NULL + ,i_shapeIxy double DEFAULT NULL + ,i_shapeIxxVar double DEFAULT NULL + ,i_shapeIyyVar double DEFAULT NULL + ,i_shapeIxyVar double DEFAULT NULL + ,i_shapeIxxIyyCov double DEFAULT NULL + ,i_shapeIxxIxyCov double DEFAULT NULL + ,i_shapeIyyIxyCov double DEFAULT NULL + ,i_extendedness double DEFAULT NULL + ,i_flagNegative BOOLEAN DEFAULT NULL + ,i_flagBadMeasCentroid BOOLEAN DEFAULT NULL + ,i_flagPixEdge BOOLEAN DEFAULT NULL + ,i_flagPixInterpAny BOOLEAN DEFAULT NULL + ,i_flagPixInterpCen BOOLEAN DEFAULT NULL + ,i_flagPixSaturAny BOOLEAN DEFAULT NULL + ,i_flagPixSaturCen BOOLEAN DEFAULT NULL + ,i_flagBadPsfFlux BOOLEAN DEFAULT NULL + ,i_flagBadApFlux BOOLEAN DEFAULT NULL + ,i_flagBadModelFlux BOOLEAN DEFAULT NULL + ,i_flagBadInstFlux BOOLEAN DEFAULT NULL + ,i_flagBadCentroid BOOLEAN DEFAULT NULL + ,i_flagBadShape BOOLEAN DEFAULT NULL + ,z_psfFlux double DEFAULT NULL + ,z_psfFluxSigma double DEFAULT NULL + ,z_apFlux double DEFAULT NULL + ,z_apFluxSigma double DEFAULT NULL + ,z_modelFlux double DEFAULT NULL + ,z_modelFluxSigma double DEFAULT NULL + ,z_instFlux double DEFAULT NULL + ,z_instFluxSigma double DEFAULT NULL + ,z_apCorrection double DEFAULT NULL + ,z_apCorrectionSigma double DEFAULT NULL + ,z_shapeIx double DEFAULT NULL + ,z_shapeIy double DEFAULT NULL + ,z_shapeIxVar double DEFAULT NULL + ,z_shapeIyVar double DEFAULT NULL + ,z_shapeIxIyCov double DEFAULT NULL + ,z_shapeIxx double DEFAULT NULL + ,z_shapeIyy double DEFAULT NULL + ,z_shapeIxy double DEFAULT NULL + ,z_shapeIxxVar double DEFAULT NULL + ,z_shapeIyyVar double DEFAULT NULL + ,z_shapeIxyVar double DEFAULT NULL + ,z_shapeIxxIyyCov double DEFAULT NULL + ,z_shapeIxxIxyCov double DEFAULT NULL + ,z_shapeIyyIxyCov double DEFAULT NULL + ,z_extendedness double DEFAULT NULL + ,z_flagNegative BOOLEAN DEFAULT NULL + ,z_flagBadMeasCentroid BOOLEAN DEFAULT NULL + ,z_flagPixEdge BOOLEAN DEFAULT NULL + ,z_flagPixInterpAny BOOLEAN DEFAULT NULL + ,z_flagPixInterpCen BOOLEAN DEFAULT NULL + ,z_flagPixSaturAny BOOLEAN DEFAULT NULL + ,z_flagPixSaturCen BOOLEAN DEFAULT NULL + ,z_flagBadPsfFlux BOOLEAN DEFAULT NULL + ,z_flagBadApFlux BOOLEAN DEFAULT NULL + ,z_flagBadModelFlux BOOLEAN DEFAULT NULL + ,z_flagBadInstFlux BOOLEAN DEFAULT NULL + ,z_flagBadCentroid BOOLEAN DEFAULT NULL + ,z_flagBadShape BOOLEAN DEFAULT NULL + ,y_psfFlux double DEFAULT NULL + ,y_psfFluxSigma double DEFAULT NULL + ,y_apFlux double DEFAULT NULL + ,y_apFluxSigma double DEFAULT NULL + ,y_modelFlux double DEFAULT NULL + ,y_modelFluxSigma double DEFAULT NULL + ,y_instFlux double DEFAULT NULL + ,y_instFluxSigma double DEFAULT NULL + ,y_apCorrection double DEFAULT NULL + ,y_apCorrectionSigma double DEFAULT NULL + ,y_shapeIx double DEFAULT NULL + ,y_shapeIy double DEFAULT NULL + ,y_shapeIxVar double DEFAULT NULL + ,y_shapeIyVar double DEFAULT NULL + ,y_shapeIxIyCov double DEFAULT NULL + ,y_shapeIxx double DEFAULT NULL + ,y_shapeIyy double DEFAULT NULL + ,y_shapeIxy double DEFAULT NULL + ,y_shapeIxxVar double DEFAULT NULL + ,y_shapeIyyVar double DEFAULT NULL + ,y_shapeIxyVar double DEFAULT NULL + ,y_shapeIxxIyyCov double DEFAULT NULL + ,y_shapeIxxIxyCov double DEFAULT NULL + ,y_shapeIyyIxyCov double DEFAULT NULL + ,y_extendedness double DEFAULT NULL + ,y_flagNegative BOOLEAN DEFAULT NULL + ,y_flagBadMeasCentroid BOOLEAN DEFAULT NULL + ,y_flagPixEdge BOOLEAN DEFAULT NULL + ,y_flagPixInterpAny BOOLEAN DEFAULT NULL + ,y_flagPixInterpCen BOOLEAN DEFAULT NULL + ,y_flagPixSaturAny BOOLEAN DEFAULT NULL + ,y_flagPixSaturCen BOOLEAN DEFAULT NULL + ,y_flagBadPsfFlux BOOLEAN DEFAULT NULL + ,y_flagBadApFlux BOOLEAN DEFAULT NULL + ,y_flagBadModelFlux BOOLEAN DEFAULT NULL + ,y_flagBadInstFlux BOOLEAN DEFAULT NULL + ,y_flagBadCentroid BOOLEAN DEFAULT NULL + ,y_flagBadShape BOOLEAN DEFAULT NULL + ) +;