ADQL Query

Parameters

Result

Matched: 10

FieldHELP_IdRA
[deg]
Dec
[deg]
HP_IdxEBVRedshiftzSpeczSpec_qualzSpec_Association_Flagstellaritystellarity_originf_best_u
[uJy]
ferr_best_u
[uJy]
m_best_u
[mag]
merr_best_u
[mag]
flag_best_uf_best_g
[uJy]
ferr_best_g
[uJy]
m_best_g
[mag]
merr_best_g
[mag]
flag_best_gf_best_r
[uJy]
ferr_best_r
[uJy]
m_best_r
[mag]
merr_best_r
[mag]
flag_best_rf_best_i
[uJy]
ferr_best_i
[uJy]
m_best_i
[mag]
merr_best_i
[mag]
flag_best_if_best_z
[uJy]
ferr_best_z
[uJy]
m_best_z
[mag]
merr_best_z
[mag]
flag_best_zf_best_y
[uJy]
ferr_best_y
[uJy]
m_best_y
[mag]
merr_best_y
[mag]
flag_best_yf_best_j
[uJy]
ferr_best_j
[uJy]
m_best_j
[mag]
merr_best_j
[mag]
flag_best_jf_best_h
[uJy]
ferr_best_h
[uJy]
m_best_h
[mag]
merr_best_h
[mag]
flag_best_hf_best_k
[uJy]
ferr_best_k
[uJy]
m_best_k
[mag]
merr_best_k
[mag]
flag_best_kf_best_ks
[uJy]
ferr_best_ks
[uJy]
m_best_ks
[mag]
merr_best_ks
[mag]
flag_best_ksf_irac_i1
[uJy]
ferr_irac_i1
[uJy]
m_irac_i1
[mag]
merr_irac_i1
[mag]
flag_irac_i1f_irac_i2
[uJy]
ferr_irac_i2
[uJy]
m_irac_i2
[mag]
merr_irac_i2
[mag]
flag_irac_i2f_irac_i3
[uJy]
ferr_irac_i3
[uJy]
m_irac_i3
[mag]
merr_irac_i3
[mag]
flag_irac_i3f_irac_i4
[uJy]
ferr_irac_i4
[uJy]
m_irac_i4
[mag]
merr_irac_i4
[mag]
flag_irac_i4f_mips_24
[uJy]
ferr_mips_24
[uJy]
flag_mips_24f_pacs_green
[uJy]
ferr_pacs_green
[uJy]
flag_pacs_greenf_pacs_red
[uJy]
ferr_pacs_red
[uJy]
flag_pacs_redf_spire_250
[uJy]
ferr_spire_250
[uJy]
flag_spire_250f_spire_350
[uJy]
ferr_spire_350
[uJy]
flag_spire_350f_spire_500
[uJy]
ferr_spire_500
[uJy]
flag_spire_500CIGALE_SFR
[Msun/yr]
CIGALE_SFR_err
[Msun/yr]
CIGALE_Mstar
[Msun]
CIGALE_Mstar_err
[Msun]
CIGALE_DustLumin
[W]
CIGALE_DustLumin_err
[W]
CIGALE_DustLumin_IRonly
[W]
CIGALE_DustLumin_IRonly_err
[W]
cigale_chi2_optcigale_chi2_ircigale_chi2_redcigale_chi2_ironlyFlag_Gaia1Flag_CleanedFlag_MergedFlag_OptNIR_Obs2Flag_OptNIR_Det2
CDFS-SWIREHELP_J033133.806-271709.29752.8908569016-27.28591584135891262270.00773627918657N/AN/A-99False0.96swire_stellarity_iraN/AN/AN/AN/AFalse0.8930771484960.11986832608624.02277755740.145726919174False2.659824029810.14931045410322.83786773680.060948304832False5.384938219790.27683144649422.07204818730.055816039443False6.973419189450.31259033083921.79138565060.0486691817641False8.975422859190.29518988728521.51736259460.0357084386051False12.0642423630.40308707952521.19624900820.0362763144076False16.81257057190.67885220050820.83591461180.0438394844532FalseN/AN/AN/AN/AFalse23.61500358580.88207650184620.46702957150.0405548252165False25.3458846330.61953695645820.39023136560.0265389712592N/A18.0706438430.84884572758120.7575659340.051001090315N/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A110.74449.564728False13986.40917259.297True37539.3721848.75False5924.2281661.9951False6516.5232309.769False10936.9295493.6406FalseN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A0FalseFalse77
CDFS-SWIREHELP_J033138.781-271727.15352.91158721-27.2908757065891258850.007421027179730.6166N/A-99False0.98servs_stellarity_iraN/AN/AN/AN/AFalse2.317705698580.14289084860822.98735427860.0669376477599False7.466843595230.17834932595821.71715736390.0259333569556False15.3859666370.32787231019220.93218803410.0231368523091False19.31401062010.31423386931420.68531799320.0176646411419False26.95659255980.29627749323820.32333755490.0119332298636False37.15415191650.40531224012419.9749813080.0118442270905False57.26562881470.68148142099419.50526428220.0129206487909FalseN/AN/AN/AN/AFalse84.66842651370.88668483495719.0806961060.0113703049719False89.80596518990.54430831404519.0167370380.00658057893882N/A56.67600904110.70622983691519.51650184770.0135291689692N/A58.623.8619.47988546470.0714933768401N/A34.513.120.05513760180.0975306356056N/A178.8010410.467377False21412.71919969.719True18148.57618269.568True9992.2512762.4644False6955.5793461.4465False5390.05765778.3467True15.39962724340.76998136217254116321472.22705816073.616.51363791214e+373.31821347595e+367.82733002357e+372.15799633509e+375.624467419371.459072904184.627663373290.08533423487460FalseFalse77
CDFS-SWIREHELP_J033136.360-271659.02252.90149799-27.2830617565891262280.007510150617850.5471N/A-99False0.95servs_stellarity_iraN/AN/AN/AN/AFalse1.592252809730.15450489716823.39496994020.105354852974False8.721952325930.19341838085821.54846572880.0240773316473False17.28506635290.3608269642920.80582237240.0226648189127False23.32364654540.31490647792820.48050880430.0146591737866False30.83914566040.2967512905620.17724418640.010447553359False40.8188133240.40626159310319.87284851070.0108061181381False58.57098770140.68265008926419.48079299930.0126543520018FalseN/AN/AN/AN/AFalse77.48954772950.8886197805419.17689132690.0124507974833False61.84242778950.60894618166319.42178367340.0106909599091N/A45.28261960680.87354575690319.76017114270.0209449069647N/A21.12.4620.58929386180.126583462735N/A19.482.2120.67602761860.123176438014N/A42.654559.249252False22237.20521464.537True15000.86515211.689True4328.36431435.5923False5771.76031725.5708False12855.1964472.082False5.779541136730.28897705683634826940990.91741347049.542.25768706526e+371.12884353263e+363.27217583571e+378.88036563079e+3612.013307376516.742460292712.15825067914.458472562650FalseFalse77
CDFS-SWIREHELP_J033141.235-272051.27752.9218118913-27.34757703845891258280.00817609497625N/AN/A-99False0.89servs_stellarity_iraN/AN/AN/AN/AFalse2.772819504870.16343197482722.79269599910.0639940723777False5.812003493850.20554773440221.98918533330.0383982248604False10.11175428110.38034821602121.38793373110.0408393852413False12.4118165970.31459000706721.16541099550.0275190789253False14.95203399660.29655027389520.96324920650.0215338841081False18.75988197330.40572935342820.71692466740.0234817620367False25.1346778870.68219590187120.39931678770.0294686425477FalseN/AN/AN/AN/AFalse35.7965850830.8871952295320.01539611820.0269092731178False41.167907960.66874014458919.86360300520.0176369269787N/A28.85335947480.70937369555820.24950903370.02669334587N/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A250.665911.997787False53115.1925883.002False30371.84223712.479False11017.0372598.0527False4628.6882810.5923False2720.31423356.5798TrueN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A0FalseFalse77
CDFS-SWIREHELP_J033142.660-272048.95652.92775069-27.3469321565891257430.008091221757570.3433N/A-99False0.03servs_stellarity_iraN/AN/AN/AN/AFalse5.06127160390.19117197327422.13935089110.0410099178553False12.31500004390.24083545684421.17391395570.0212329495698False16.18121880290.44456403453520.87747192380.0298295989633False19.23251914980.31925499439220.68990898130.018022948876False21.51894187930.29961270093920.56794738770.0151169318706False23.78528976440.41185358166720.45922851560.0188000388443False27.83028411870.68974298238820.28870582580.0269087776542FalseN/AN/AN/AN/AFalse30.99407386780.8999719023720.17180252080.0315264165401False18.96473215040.58947065812120.70513321680.0337473595772N/A16.9733999310.77781754672920.82557788930.0497545968759N/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A101.35184510.290886False22509.46318623.033True20040.15817832.748True6488.5762155.664False2225.99411830.551True2344.00022794.4553TrueN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A0FalseFalse77
CDFS-SWIREHELP_J033144.394-272106.65252.93497416-27.3518478465891257410.00807770809160.595N/A-99False0.97servs_stellarity_iraN/AN/AN/AN/AFalse2.566244878810.14098818941822.87675476070.0596497952938False9.098329048750.17835436710921.50259590150.0212836656719False18.92066920610.32961496094520.70765876770.0189144946635False25.33646965030.31472957134220.39063453670.0134870121256False33.78101730350.29740107059520.07831764220.0095585975796False43.86840438840.40739417076119.79462051390.0100829424337False62.65436172490.68381142616319.40762138370.01184975449FalseN/AN/AN/AN/AFalse86.97328948970.8905913829819.05153465270.0111177498475False85.47961066480.55199090430219.07034366150.00701122179707N/A55.16137853240.81725138724519.54591222240.016085881882N/A42.274.819.83491938040.123291549156N/A18.892.6120.70942010520.150014372388N/A265.633811.047699False22094.17620691.168True41271.29322661.508False6762.89361789.1191False5244.30472099.895False2958.723164.9119True13.05085564140.65254278206876843191860.03842159593.05.91333915406e+372.95666957703e+365.51968307139e+371.55775301782e+374.53902330441.404036248273.609424321391.092574348860FalseFalse77
CDFS-SWIREHELP_J033144.530-272033.62052.93554033-27.3426722765891257540.007927575385940.6225N/A-99False0.85swire_stellarity_iraN/AN/AN/AN/AFalse2.753500129980.15548328617322.80028724670.0613088160753False10.30702649260.19419660622221.36716651920.0204565580934False24.92725747210.35944054607820.40831375120.0156558584422False34.07971572880.31644764542620.06875991820.0100816171616False46.9240303040.29734173417119.72151184080.00687994388863False61.72086334230.40732738375719.42391967770.00716532533988False87.09436035160.68456417322219.05002403260.00853391736746FalseN/AN/AN/AN/AFalse127.3203964230.89121174812318.63775444030.0075998888351False160.576595960.79857517281318.38579438220.00539955385255N/A106.839050180.98501679267718.8281749540.0100100889357N/A93.885.0818.96856729770.0587509578203N/A140.86.9618.5284933630.053669914667N/A998.087411.579895False32140.321539.484False55046.50422082.879False22186.1931402.4395False14956.4171718.3838False9970.8923400.2563False55.26454945623.182035852131.89886475142e+119494323757.092.75722683993e+381.37861341996e+371.69330607874e+384.52409326453e+371.107829391651.39765974241.127907164130.8947977772060FalseFalse77
CDFS-SWIREHELP_J033145.699-272037.48052.94041082-27.3437443865891257540.007884709658490.6253N/A-99False0.61swire_stellarity_iraN/AN/AN/AN/AFalse1.973233024210.16108228920223.16205406190.0886326506734False5.814464658160.20369909566521.98872566220.0380367748439False11.04090722890.37723428577221.29248809810.0370963104069False13.49969291690.31345415115421.07419013980.0252100937068False17.51073074340.29514673352220.79173851010.0183002930135False22.72719955440.40289667248720.50863456730.0192473996431False31.91763687130.67954260110920.13992309570.0231158714741FalseN/AN/AN/AN/AFalse43.0941658020.88161015510619.81395339970.0222117323428False43.80037269610.63573542966119.79630548520.0157587922235N/A29.20487232890.80629071431620.23636171990.029975101765N/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A81.75774410.116768False29866.25421384.105True12843.18815273.425True8894.8251523.6821False7793.93261938.1909False6440.2553500.3862False10.3540601960.517703009836302513749.41815125687.474.3661298101e+372.18306490505e+367.0491488082e+371.86012784909e+370.4780115846696.923324026081.928621257481.206961676090FalseFalse77
CDFS-SWIREHELP_J033145.872-272001.63652.94113301-27.3337877865891258410.007718023621520.4436N/A-99False0.95servs_stellarity_iraN/AN/AN/AN/AFalse2.902568248680.11332889610622.74304389950.0423918664455False4.077783782540.1421741771922.37393951420.0378547906876False6.082650524120.26285139535421.93976783750.0469182431698False6.768523216250.31022116541921.8237648010.0497624576092False6.762566089630.29351091384921.82472038270.0471234470606False9.599725723270.39963218569821.44435310360.0451987050474False9.330786705020.6750782728221.47520446780.0785525366664FalseN/AN/AN/AN/AFalse11.68402957920.8750520944621.23101806640.0813140496612False15.90728119250.67260428750520.89601010460.045907959857N/A9.912279873950.53470703790521.40956611030.0585688456516N/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A153.021649.653305False12272.79414364.892True11096.54714178.779True4469.12652079.3008False2402.30052055.5515True4643.28863950.6187TrueN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A0FalseFalse77
CDFS-SWIREHELP_J033146.739-272022.64752.94474726-27.3396241665891257550.007767163061040.3044N/A-99False0.41swire_stellarity_iraN/AN/AN/AN/AFalse21.1577069440.22828465212220.58632850650.0117147341371False39.51821618940.28716988359919.90800666810.00788979791105False44.64476155980.52426604755619.77557373050.0127498637885False55.9717864990.31985548138619.53007698060.00620453059673False55.4673767090.29789778590219.53990554810.00583114707842False60.14118194580.4085357487219.45207023620.0073753464967False63.35663604740.68887907266619.39551925660.0118052503094FalseN/AN/AN/AN/AFalse73.40795898440.89377564191819.23564147950.0132193379104False37.82759618070.78758060898419.95547813950.022605316427N/A34.90782682920.80352862202920.04269296790.0249921062335N/AN/AN/AN/AN/AN/A37.74.3719.95914662450.125853241772N/A66.392828.39513False18215.95519502.076True8037.404312160.27True4796.88041722.5967False3265.3211844.4504True1153.55791571.5583TrueN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A0FalseFalse77

Note 1

The Flag_Gaia is computed by cross-matching the catalogue with the Gaia catalogue:

Value Meaning
1 The object if possibly a Gaia object: the nearest Gaia source is between 1.5 arcsec and 2 arcsec.
2 The object if probably a Gaia object: the nearest Gaia source is between 0.6 arcsec and 1.5 arcsec.
3 The object is definitely a Gaia object: the nearest Gaia source is nearer than 0.6 arcsec.
0 Otherwise (the nearest Gaia source is farer than 2 arcsec).
Note 2

The Flag_OptNIR_Obs and Flag_OptNIR_Det are computed while cross-matching the optical and near/mid infrared catalogues and indicate if a source was observed (i.e. is on the coverage of surveys at the given regime) or detected (i.e. is present in the catalogue) in various wavelength regime. The detection is based on the detection wavelengths of the catalogues, and to be counted as detected, a source must be present in at least two catalogues.

The flag is a composed binary flag with these values:

Value Meaning
1 Observation/detection in optical wavelengths.
2 Observation/detection in near-infrared wavelengths.
4 Observation/detection in mid-infrared wavelengths.

Query Form

On this page, you can use ADQL to query some of our tables. This is mainly for dabbling; use TAP for larger jobs (e.g., using TAPHandle within your browser).

To learn what ADQL is or for further information on this implementation, see the service info.

A query in the Astronomical Data Query Language
Seconds until the query is aborted. If you find yourself having to raise this beyond 200 or so, please contact the site operators for hints on how to optimize your query

To protect your nerves, the server inserts a TOP 2000 phrase unless you give a limit yourself. Thus, if you hit the 2000 record limit and want to override it, you can specify your limit yourself (like SELECT TOP 20000...).

There is a fixed limit to 100000 rows on this service. If this bugs you, use TAP.