Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

The Kepler Extra-Galactic Survey (KEGS) is a program using the Kepler telescope to search for supernovae, active galactic nuclei, and other transients in galaxies. We have to identify galaxies in a suitable redshift range (z<=0.12) a priori, which will be monitored by K2. Here is an example to get galaxies for Campaign 14. We only select objects with r<=19.5, and we make a cut on (rmeanpsfmag - rmeankronmag)>=0.5 in order to remove stars. We only want to use objects for which the majority of pixels were not masked, thus the cut on QFperfect>=0.95. We also obtain the petrosian radii in order to be able to select galaxies by size. This query gives us an initial list of galaxies which then gets vetted more, e.g. with cuts on qualityFlag and objInfoFlag and information from external catalogs.

Query

Code Block

language	sql

SELECT  o.objID,
ot.raStack, ot.decStack, ot.raMean, ot.decMean, 
ot.ng,  o.gMeanPSFMag,o.gMeanPSFMagErr,o.gMeanKronMag,o.gMeanKronMagErr,
ot.nr,  o.rMeanPSFMag,o.rMeanPSFMagErr,o.rMeanKronMag,o.rMeanKronMagErr,
ot.ni,  o.iMeanPSFMag,o.iMeanPSFMagErr,o.iMeanKronMag,o.iMeanKronMagErr,
ot.nz,  o.zMeanPSFMag,o.zMeanPSFMagErr,o.zMeanKronMag,o.zMeanKronMagErr,
ot.ny,  o.yMeanPSFMag,o.yMeanPSFMagErr,o.yMeanKronMag,o.yMeanKronMagErr,
o.gQfPerfect,o.rQfPerfect,o.iQfPerfect,o.zQfPerfect,o.yQfPerfect,
ot.qualityFlag,ot.objInfoFlag,
sp.gpetRadius,sp.rpetRadius,sp.ipetRadius,sp.zpetRadius,sp.ypetRadius,
sp.gpetR50,sp.rpetR50,sp.ipetR50,sp.zpetR50,sp.ypetR50
       INTO mydb.[K2C14pv3_v3K2C14] FROM MeanObject AS o
       JOIN fgetNearbyObjEq(160.68333, 6.85167 , 8.5) cone ON cone.objid = o.objID 
       JOIN ObjectThin AS ot ON ot.objID = o.objID
       JOIN StackPetrosian AS sp ON sp.objID = o.objID
     WHERE ot.ni >= 3
     AND ot.ng >= 3
     AND ot.nr >= 3
     AND (o.rMeanKronMag > 0 AND o.rMeanKronMag <= 19.5 )
     AND (o.gQfPerfect >= 0.95)
     AND (o.rQfPerfect >= 0.95)
     AND (o.iQfPerfect >= 0.95)
     AND (o.zQfPerfect >= 0.95)
     AND (o.rmeanpsfmag - o.rmeankronmag > 0.5)

...

First 10 Rows on MyDB Table K2C14pv3_v3K2C14


objID	raStack	decStack	raMean	decMean	ng	gMeanPSFMag	gMeanPSFMagErr	gMeanKronMag	gMeanKronMagErr	nr	rMeanPSFMag	rMeanPSFMagErr	rMeanKronMag	rMeanKronMagErr	ni	iMeanPSFMag	iMeanPSFMagErr	iMeanKronMag	iMeanKronMagErr	nz	zMeanPSFMag	zMeanPSFMagErr	zMeanKronMag	zMeanKronMagErr	ny	yMeanPSFMag	yMeanPSFMagErr	yMeanKronMag	yMeanKronMagErr	gQfPerfect	rQfPerfect	iQfPerfect	zQfPerfect	yQfPerfect	qualityFlag	objInfoFlag	gpetRadius	rpetRadius	ipetRadius	zpetRadius	ypetRadius	gpetR50	rpetR50	ipetR50	zpetR50	ypetR50
123311549281210477	154.92812611	12.75831367	154.92811431	12.75832518	10	20.0835	0.024401	19.301	0.028161	16	19.0415	0.039718	18.209	0.009343	20	18.6326	0.023309	17.7053	0.011849	12	18.0135	0.029643	17.4283	0.009914	14	18.1077	0.042534	17.3281	0.023553	0.999812	0.99953	0.999408	0.999818	0.999398	61	512024576	7.65464	6.89781	5.74412	5.57977	4.21074	2.78133	2.36178	2.05482	2.0514	1.67238
123311556359837190	155.63595456	12.76391817	155.63594254	12.76393065	17	20.6317	0.029612	20.1322	0.030872	22	19.5872	0.035236	19.009	0.015546	24	19.2038	0.022632	18.5463	0.013514	13	18.7241	0.029605	18.2488	0.016407	15	18.7148	0.025143	18.1658	0.036589	0.999841	0.999667	0.999723	0.999696	0.999486	61	512024576	4.11764	3.19234	3.37176	3.55703	3.55401	1.64643	1.28659	1.30457	1.41352	1.64367
123311563608493897	156.36080172	12.76123503	156.36081918	12.76123267	12	19.6828	0.053324	17.5969	0.013996	10	19.6995	0.214609	17.2401	0.014849	14	19.6599	0.088526	17.1426	0.013593	6	19.2574	0.077356	17.3268	0.023463	5	19.4923	0.214712	17.9344	0.035796	0.999578	0.999805	0.999771	0.999548	0.998263	53	444915712	10.8759	11.199	11.1484	10.5347	9.50867	4.43794	4.40708	4.52688	4.21262	3.28768
123311564766811688	156.47673248	12.75933957	156.47676479	12.75933774	10	20.6036	0.038835	20.2254	0.028823	12	19.6161	0.029449	19.0641	0.026325	19	19.2917	0.021417	18.7812	0.016662	9	18.9118	0.021025	18.5409	0.035919	12	18.8295	0.024847	18.3664	0.05601	0.99962	0.999673	0.999685	0.999586	0.99939	53	444915712	4.00564	3.49143	4.64069	4.7902	-9.08956	1.3887	1.11921	1.25359	1.44259	-9.07378
123311565993385602	156.59931289	12.76262096	156.59931872	12.76262302	10	19.3503	0.026542	18.4721	0.022539	14	18.8037	0.032864	18.0029	0.020426	15	18.5567	0.012024	17.6336	0.012315	11	18.3297	0.061319	17.387	0.016721	17	18.2486	0.053074	17.2516	0.087225	0.999834	0.999308	0.999417	0.999812	0.999327	61	512024576	3.11429	2.81284	2.97854	3.117	8.68295	1.00833	0.980632	1.07104	0.984775	2.965
123311564444738006	156.44447917	12.76459414	156.44450277	12.76459045	9	19.9533	0.026005	19.4565	0.018023	14	18.9669	0.017971	18.2664	0.011821	14	18.555	0.01805	17.7932	0.00674	7	18.1525	0.048449	17.5099	0.01958	16	18.0324	0.054899	17.3798	0.021401	0.999658	0.999581	0.999657	0.999516	0.999339	61	512024576	4.85821	4.28138	4.09561	3.92565	4.57184	1.85211	1.5708	1.53056	1.5795	1.66867
123311566009794928	156.60102574	12.76200927	156.60102304	12.76201848	10	19.036	0.059096	18.0817	0.02248	14	17.9479	0.044041	17.1254	0.015734	14	17.6411	0.023534	16.7142	0.006589	9	17.2256	0.057247	16.4349	0.005736	16	17.0858	0.055096	16.1444	0.03247	0.999666	0.999091	0.999663	0.999464	0.998955	61	512024576	5.99277	5.45115	4.69198	5.3783	2.76549	2.43662	2.2388	1.8653	2.15231	1.06782
123311566048421351	156.60484481	12.75900132	156.60484546	12.7590098	8	19.2369	0.034491	18.727	0.024239	12	18.3925	0.01095	17.7554	0.010232	16	18.0391	0.028661	17.3429	0.005609	11	17.6664	0.024755	17.0823	0.010994	18	17.5588	0.034835	17.0271	0.011815	0.999664	0.999544	0.999602	0.999623	0.999433	61	512024576	4.16681	3.54043	3.21858	3.69755	26.1036	1.56839	1.36376	1.27506	1.37458	-999
123311569207978960	156.92076482	12.76540801	156.92076056	12.76544365	9	20.8824	0.063935	20.1254	0.038368	12	20.1992	0.028047	19.3953	0.02682	14	19.963	0.017104	19.1169	0.022385	11	19.3916	0.093169	18.8423	0.047232	14	19.3703	0.050302	18.6263	0.060436	0.999512	0.999706	0.999858	0.999353	0.999578	53	444915712	5.58858	4.86715	4.59496	5.16338	4.85984	2.10445	2.04828	1.82724	2.16979	2.12018
123311577928974093	157.79288195	12.76131325	157.79286038	12.76133682	10	19.8432	0.026994	19.4151	0.037358	14	19.0266	0.010783	18.5078	0.00961	20	18.6403	0.014359	18.1007	0.008081	15	18.302	0.028949	17.9015	0.016442	14	18.3422	0.025802	17.8278	0.00872	0.999293	0.999235	0.999065	0.999243	0.999374	61	512024576	13.2731	3.46466	3.09503	3.8395	2.8104	6.11566	1.3939	1.23334	1.3563	1.08618

...

Content

Space Tools

Versions Compared

Old Version 3

New Version 4

Key

Query