6.9E-7, 6.789E-7, 6.682E-7, 6.58E-7, 6.482E-7, 6.388E-7, 6.298E-7, 6.212E-7, 6.129E-7, 6.049E-7, 5.972E-7, 5.897E-7, 5.826E-7, 5.757E-7, 5.69E-7, 5.626E-7, 5.564E-7, 5.503E-7, 5.445E-7, 5.389E-7, 5.334E-7, 5.281E-7, 5.23E-7, 5.18E-7, 5.132E-7, 5.085E-7, 5.039E-7, 4.995E-7, 4.952E-7, 4.91E-7, 4.869E-7, 4.829E-7, 4.791E-7, 4.753E-7, 4.717E-7, 4.681E-7, 4.646E-7, 4.612E-7, 4.579E-7, 4.547E-7, 4.515E-7, 4.484E-7, 4.454E-7, 4.425E-7, 4.396E-7, 4.368E-7, 4.34E-7, 4.314E-7, 4.287E-7, 4.262E-7, 4.236E-7, 4.212E-7, 4.188E-7, 4.164E-7, 4.141E-7, 4.118E-7, 4.096E-7, 4.074E-7, 4.053E-7, 4.032E-7, 4.011E-7, 3.991E-7, 3.972E-7, 3.952E-7, 3.933E-7, 3.915E-7, 3.896E-7, 3.878E-7, 3.86E-7, 3.843E-7, 3.826E-7, 3.809E-7, 3.793E-7, 3.777E-7, 3.761E-7, 3.745E-7, 3.73E-7, 3.714E-7, 3.7E-7, 3.685E-7, 3.671E-7, 3.656E-7, 3.642E-7, 3.629E-7, 3.615E-7, 3.602E-7, 3.589E-7, 3.576E-7, 3.563E-7, 3.551E-7, 3.538E-7, 3.526E-7, 3.514E-7, 3.502E-7, 3.491E-7, 3.479E-7, 3.468E-7, 3.457E-7, 3.446E-7, 3.435E-7, 3.424E-7, 3.414E-7, 3.403E-7, 3.393E-7, 3.383E-7, 3.373E-7, 3.363E-7, 3.354E-7, 3.344E-7, 3.335E-7, 3.325E-7, 3.316E-7, 3.307E-7, 3.298E-7, 3.289E-7, 3.28E-7, 3.272E-7, 3.263E-7, 3.255E-7, 3.247E-7, 3.238E-7, 3.23E-7, 3.222E-7, 3.214E-7, 3.206E-7, 3.199E-7, 3.191E-7, 3.184E-7, 3.176E-7, 3.169E-7, 3.161E-7, 3.154E-7, 3.147E-7, 3.14E-7, 3.133E-7, 3.126E-7 Digitized First Byurakan Survey (DFBS) Extracted Spectra The First Byurakan Survey (FBS) is the largest and the first systematic objective prism survey of the extragalactic sky. It covers 17,000 sq.deg. in the Northern sky together with a high galactic latitudes region in the Southern sky. The FBS has been carried out by B.E. Markarian, V.A. Lipovetski and J.A. Stepanian in 1965-1980 with the Byurakan Observatory 102/132/213 cm (40"/52"/84") Schmidt telescope using 1.5 deg. prism. Each FBS plate contains low-dispersion spectra of some 15,000-20,000 objects; the whole survey consists of about 20,000,000 objects. 30 and sp_class='OK' Since the table needs to be sequentially scanned for this, it will take a minute or so. Combine with an object selection (see below) or other criteria if possible. Get Average Spectra ------------------- You cannot currently use the ADQL aggregate function AVG with arrays (which should be fixed at some time in the future). Meanwhile, you can work around this with a clumsy construction like this (this query will give you average spectra by magnitude bin; don't run it just for fun, it'll take a while):: select round(magb) as bin, avg(flux[1]) as col1, avg(flux[2]) as col2, avg(flux[3]) as col3, avg(flux[4]) as col4, avg(flux[5]) as col5, avg(flux[6]) as col6, avg(flux[7]) as col7, avg(flux[8]) as col8, avg(flux[9]) as col9, avg(flux[10]) as col10, avg(flux[11]) as col11, avg(flux[12]) as col12, avg(flux[13]) as col13, avg(flux[14]) as col14, avg(flux[15]) as col15, avg(flux[16]) as col16, avg(flux[17]) as col17, avg(flux[18]) as col18, avg(flux[19]) as col19, avg(flux[20]) as col20, avg(flux[21]) as col21, avg(flux[22]) as col22, avg(flux[23]) as col23, avg(flux[24]) as col24, avg(flux[25]) as col25, avg(flux[26]) as col26, avg(flux[27]) as col27, avg(flux[28]) as col28, avg(flux[29]) as col29, avg(flux[30]) as col30, avg(flux[31]) as col31, avg(flux[32]) as col32, avg(flux[33]) as col33, avg(flux[34]) as col34, avg(flux[35]) as col35, avg(flux[36]) as col36, avg(flux[37]) as col37, avg(flux[38]) as col38, avg(flux[39]) as col39, avg(flux[40]) as col40, avg(flux[41]) as col41, avg(flux[42]) as col42, avg(flux[43]) as col43, avg(flux[44]) as col44, avg(flux[45]) as col45, avg(flux[46]) as col46, avg(flux[47]) as col47, avg(flux[48]) as col48, avg(flux[49]) as col49, avg(flux[50]) as col50, avg(flux[51]) as col51, avg(flux[52]) as col52, avg(flux[53]) as col53, avg(flux[54]) as col54, avg(flux[55]) as col55, avg(flux[56]) as col56, avg(flux[57]) as col57, avg(flux[58]) as col58, avg(flux[59]) as col59 from dfbsspec.spectra where sp_class='OK' group by bin To map ``col`` to wavelenghts, see the contents of (any) ``spectral`` column. Build Templates --------------- To compute an average spectrum for a class of objects, we suggest to pull positions of such objects from SIMBAD and then fetch the associate spectra from this database. Since the response function of the photographic plates had a strong magnitude dependence, restrict the objects to a small magnitude range, for instance:: select otype, ra, dec, flux from basic join flux on (oid=oidref) where otype='HS*' and dec>-15 and filter='G' and flux between 12.5 and 13.5 (to be executed on SIMBAD's TAP service, see also `SIMBAD object types`_). .. _SIMBAD object types: http://simbad.u-strasbg.fr/simbad/sim-display?data=otypes With the resulting table, go do this service and execute a query like:: SELECT specid, spectral, flux FROM dfbsspec.spectra AS db JOIN TAP_UPLOAD.t1 AS tc ON DISTANCE(tc.ra, tc.dec, db.ra, db.dec)<5./3600. WHERE sp_class='OK' (adjust t1 according to your client's rules; in TOPCAT, that's t plus the table number from the control window). History of this Data Collection =============================== The original aim of the First Byurakan Survey was to search for galaxies with UV excess (:bibcode:`1986ApJS...62..751M`, Markarian et al. 1989,1997- catalogue No. VII/172 at CDS). Successively, the amount of spectral information contained in the plates allowed the development of several other projects concerning the spectral classification of Seyfert Galaxies (Weedman and Kachikian 1971), the first definition of starburst galaxies (Weedman 1977 ), the discovery and investigation of blue stellar objects (Abrahamian and Mickaelian, 1996, Mickaelian et al 2001, 2002, CDS catalogue No II/223) and a survey for late-type stars (Gigoyan et al. 2002). All these results were obtained by eye inspection of the plates performed with the aid of a microscope at the Byurakan Observatory. The number and classes of new objects discovered FBS made clear the need of open access to FBS for the entire astronomical community. ]]> 2017-11-28T10:50:00Z objective prism spectroscopy Markarian, B.E.; N.N. Byurakan 1m Schmidt Byurakan Astrophysical Observatory BAO 2007A&A...464.1177M Research Archive Optical //products#table//scs#q3cindex Raw metadata for the spectra, to be combined with image metadata like date_obs and friends for a complete spectrum descriptions. This also contains spectral and flux points in array-valued columns. specid make_ssa_view make_tap_view # The spectra are in one table per source plate, and # the dump has the values of one such plate in one line. # So, I look for such lines and then parse from there with gzip.open(self.sourceToken) as f: for line in f: if line.startswith("INSERT INTO `fbs"): for row in parseSpectraFromDump(line): yield row "\schema.spectra" "\rdId/%s-%s"%(@plate, @objectid[5:]) makeAbsoluteURL( "\rdId/sdl/dlget?ID="+urllib.quote("\rdId/%s-%s"%( @plate, @objectid[5:]))) "application/x-votable+xml" "image/png" makeAbsoluteURL("\rdId/preview/qp/%s-%s"%( @plate, @objectid[5:])) 20000 [float(item or 'nan') for item in @fluxes.split("#")[int(@redBord)+1:]] float(@ra)/24.*360 float(@dec) @plate+"-"+@objectid[5:] [\spectralBins] try: @lam_min = bins[len(@flux)-1] except IndexError: @lam_min = bins[-1] A view providing standard SSA metadata for DBFS metadata in \schema.spectra//ssap#mixc//ssap#simpleCoverage//obscore#publishSSAPMIXCsdlssa_pubDID CREATE VIEW \curtable AS ( SELECT \colNames FROM ( SELECT accref, owner, embargo, mime, accsize, objectid || ' spectrum from ' || plate AS ssa_dstitle, NULL::TEXT AS ssa_creatorDID, pub_did AS ssa_pubDID, NULL::TEXT AS ssa_cdate, '2018-09-01'::TIMESTAMP AS ssa_pdate, emulsion AS ssa_bandpass, '1.0'::TEXT AS ssa_cversion, NULL::TEXT AS ssa_targname, NULL::TEXT AS ssa_targclass, NULL::REAL AS ssa_redshift, NULL::spoint AS ssa_targetpos, snr AS ssa_snr, pos AS ssa_location, 2/3600.::REAL AS ssa_aperture, epoch AS ssa_dateObs, exptime AS ssa_timeExt, (lam_min+690e-9)/2. AS ssa_specmid, 690e-9-lam_min AS ssa_specext, lam_min AS ssa_specstart, 690e-9 AS ssa_specend, px_length::INTEGER AS ssa_length, 'spectrum'::TEXT AS ssa_dstype, 'BAO'::TEXT AS ssa_publisher, 'Markarian et al'::TEXT AS ssa_creator, 'DFBS spectra'::TEXT AS ssa_collection, 'Byurakan 1m Schmidt'::TEXT AS ssa_instrument, 'survey'::TEXT AS ssa_datasource, 'archival'::TEXT AS ssa_creationtype, '2007A&A...464.1177M'::TEXT AS ssa_reference, NULL::REAL AS ssa_fluxStatError, NULL::REAL AS ssa_fluxSysError, 'UNCALIBRATED'::TEXT AS ssa_fluxcalib, 50e-10::REAL AS ssa_binSize, NULL::REAL AS ssa_spectStatError, NULL::REAL AS ssa_spectSysError, 'ABSOLUTE'::TEXT AS ssa_speccalib, 50e-10::REAL AS ssa_specres, NULL::spoly AS ssa_region, magb, magr, plate FROM \schema.raw_spectra LEFT OUTER JOIN \schema.platemeta ON (plateid=plate) ) AS q ) 2/0,2,8,19-20,33-36,40,47,74,77,79,102,106-107,109 3/36-38,40-42,64,66,69,71,73-75,84-86,88-90,96-97,99-100,102,105,117,119,121-123,125-127,129-131,148-150,152-154,164-166,168-170,181-183,185-187,211-213,269-271,273-277,279-281,285-287,289-290,292-293,295,305-307,313-315,341,353-355,358,361-364,399,403-404,413-415,419-421,432-434,440-442,444-445,490-491,507-508,510-511,573-575,639,703,765,767 4/26-27,48,50,56,58-59,61-63,98-99,104-106,156,172,176,192,215,221-223,244-245,255,260-262,268,270-273,275,281-283,289-291,348,364,368,383,393,395,404-405,407,412,419,425,427-428,432-434,447-448,463,467,472-474,483,496,498-499,512-513,515,604,620,624,639,668,684,688,703-704,719,723,739,768,773,775,784,786-787,789,836-837,839,843,856-858,868-869,936,938-939,959,1055,1071,1075,1091,1112-1114,1128-1130,1132-1133,1135-1136,1138-1139,1155,1164-1166,1177,1202-1204,1206-1210,1212-1213,1215-1216,1218-1219,1249-1251,1411,1426,1436,1438-1441,1443,1460,1464,1589-1591,1593-1595,1605-1607,1609-1611,1626-1628,1630-1631,1649-1651,1669-1671,1673-1675,1688,1690,1692-1693,1695,1740-1741,1743,1772,1774,1785,1787,1789-1791,1876-1877,1929-1930,1934,1952,1954-1955,1958,1978-1980,1982-1983,2021-2023,2025-2027,2036,2038,2271,2287,2291,2549-2551,2553,2555,2805-2807,2809-2811,3039,3059,3064-3065,3067 5/64-66,72,74-75,96-98,120,122,196-198,204,206-207,223,228,230-231,242-243,410,428,432,434,503,509,511,628-630,632-634,692-694,696-698,708-710,712-714,772,774,776-778,853-855,857,859,877,879,881-883,985,987-988,1013-1015,1052-1054,1076,1078-1079,1096-1097,1099,1121-1123,1152-1153,1155,1396-1398,1400-1402,1460-1462,1464-1466,1476-1478,1480-1482,1527,1531,1568-1569,1571,1577,1624-1625,1652-1654,1656-1658,1668-1669,1671,1675,1705,1716-1718,1720-1722,1740,1783,1787,1796-1798,1800-1802,1847,1851,1863,1867,1900-1901,1903,1927,1931,1990-1991,2057,2059,2420-2422,2424-2426,2484-2486,2488-2490,2500-2502,2504-2506,2551,2555,2676-2678,2680-2682,2740-2742,2744-2746,2756-2758,2760-2762,2807,2811,2820-2822,2824-2826,2871,2875,2887,2891,2951,2955,3076-3078,3080-3082,3089,3097-3099,3113,3116,3118-3121,3124-3125,3140,3142-3143,3154-3155,3160-3161,3164,3168-3170,3328-3329,3332-3334,3353-3355,3365-3367,3369-3371,3436-3438,3440-3442,3445,3457,3460-3461,3463,3469,3480-3482,3484,3520-3522,3722,3734,3737-3740,3749-3751,3760-3762,3768-3770,3835,4008,4031,4074-4075,4078-4079,4090-4091,4093-4095,4213-4215,4217-4219,4277-4279,4281-4283,4293-4295,4297-4299,4357-4359,4361-4363,4460-4461,4463,4524,4537,4539,4550-4551,4613-4615,4617-4619,4668,4670,4704-4705,4717,4801-4803,4806-4807,4820,4822-4823,4844-4846,4856-4857,4859,4870-4871,4995,5305-5307,5310,5444-5445,5447,5453-5455,5477,5492-5493,5495,5499,5502,5585,5588-5589,5599,5620-5621,5623,5629-5631,5637-5639,5641-5643,5698,5709-5711,5722,5750,5769,5844,5848,5860,5864,5866-5867,5973,5981,5983,6271,6335,6351,6355,6371,6415,6419,6435,6480,6484-6485,6487,6490,6496,6498-6499,6501,6503,6518-6519,6671,6675,6691,6756-6758,6764,6766-6767,6777,6779,6969,7092-7094,7100,7102-7103,7136-7137,7139,7145-7147,7153-7155,7492-7493,7495,7512-7513,7516-7517,7715,7724-7726,7730,7814,7826,7836,7838-7839,7898-7899,7904,7906-7907,7909-7911,7924,7926-7927,7999,8046,8078-8079,8083,8099,8156,8158-8159,8702,9041,9044-9046,9077-9079,9081-9083,9141-9143,9145-9147,9157-9159,9161-9163,10111,10183,10191-10192,10194-10195,10211,10216-10217,10219,11135,11199,11215,11219,11235,12149-12151,12153-12155,12213,12215,12229-12231,12233-12235,12264-12265,12267 6/268-270,272,274,292,294-295,312,314,396,398-400,410,413-415,456,458-459,484,486-487,492,796,798,822,832,885-887,889-891,916,918-919,965-967,1397,1399,1405,1407,1493,1495,1546-1547,1550,1563,1566,1634-1635,1646,1716-1718,1720-1722,1732-1734,1740,1760,2005-2007,2009,2011,2033,2035,2041,2043,2524-2526,2540-2542,2544-2546,2780-2782,2796-2798,2800-2802,2844-2846,2860-2862,2864-2866,2880-2882,2944-2946,3094,3100,3102,3116-3118,3120-3122,3200-3202,3407,3409-3411,3487,3523,3861,3863,3869,3936-3937,3939,3956-3957,3959-3960,3965,3967,4047,4051,4220-4222,4308,4310-4311,4392-4393,4395,4616-4617,4619,5596-5598,5612-5614,5616-5618,5852-5854,5868-5869,5872,5874,5916,5918,5932-5934,5936-5937,5952-5954,6016-6018,6101-6103,6105-6107,6117-6119,6121-6123,6280-6281,6283,6305,6307,6316-6317,6319,6504,6506-6507,6509,6620-6622,6636-6638,6640-6642,6661,6681,6683,6695,6789,6797-6799,6817,6819,6825,6828-6829,6876-6878,6892-6894,6896-6898,6964-6966,6968-6970,6976-6978,6984,6986,7040-7042,7125-7127,7129-7131,7141-7143,7145-7147,7196,7198,7212-7214,7216-7218,7232-7234,7296-7298,7381-7383,7385-7387,7397-7399,7401-7403,7445-7447,7449-7451,7461-7463,7465-7467,7608-7610,7701-7703,7705-7707,7717-7719,7721-7723,7954-7955,7957-7959,8224-8225,8233-8235,9692-9694,9708-9710,9712-9714,9948-9950,9964-9966,9968-9970,10012-10014,10028-10030,10032-10034,10048-10050,10112-10114,10199,10202-10203,10213-10215,10217-10219,10716-10718,10732,10734,10736-10738,10972-10974,10988-10989,10992,10994,11036,11038,11052-11054,11056-11057,11072-11074,11136-11138,11221-11223,11225-11227,11237-11239,11241-11243,11292-11294,11308-11310,11312-11314,11328,11330,11392-11394,11477-11479,11481-11483,11493-11495,11497-11499,11541-11543,11545-11547,11557-11559,11561-11563,11797-11799,11801-11803,11813-11815,11817-11819,12316,12332,12336,12351-12353,12355,12364-12365,12367,12387,12416,12429,12431,12436-12437,12439-12440,12442-12443,12461,12468,12470-12471,12488-12489,12491-12494,12508-12509,12511,12564,12566-12567,12613-12615,12648-12650,12653,12660,12664,12684,12688-12689,12692-12693,12704,12797,12799,12817,12820,13320,13324-13325,13327,13340-13341,13360-13361,13373-13375,13409-13411,13453-13455,13457-13459,13473-13475,13756,13772,13776,13788-13790,13792,13824-13825,13827,13836,13849,13885,13933,13935,13940-13942,13944-13946,14017,14019-14020,14022,14092,14096,14882,14894-14895,14909-14911,14925-14927,14942-14943,14947,14964-14966,14968,14970,14992,14994-14995,15052,15054-15056,15066-15067,15084-15086,15088-15090,15114,15322-15323,15333-15335,15338-15339,16040,16042-16043,16046-16047,16058-16059,16062-16063,16106-16107,16110-16111,16121-16123,16370-16371,16767,16831,16847,16851,16867,17023,17087,17103,17107,17123,17167,17171,17187,17423,17427,17443,17848-17849,18100,18104,18145,18153-18155,18192,18194-18195,18197-18199,18447,18451,18467,18676-18678,18686,18824-18826,18828-18829,18831,18859,18862-18865,18867,18876-18877,18879,19201-19203,19216,19218-19219,19221-19223,19284-19286,19388-19390,19433,19472,19474-19475,19477-19479,19972-19973,19975,19978,21183,21219,21234,21246,21765,21767,21784-21785,21787,21809,21811,21905,21917,21952-21954,21956-21957,21959,21977,21990-21991,21993-21995,22002,22005,22013-22015,22336-22337,22339,22348-22349,22351,22360-22362,22391,22395,22488-22489,22491,22515,22543,22547,22563,22786,22798,22811,22814-22815,22833-22835,22880,22882-22883,22892,22894-22895,22992,22994-22995,23004,23006-23007,23072-23073,23082,23085-23087,23380-23381,23384-23386,23396-23398,23400-23402,23444-23445,23448-23450,23460-23462,23482,23712,23714-23715,23720,23722,23888-23889,23891,23901-23903,23921-23923,23929,24021,24023,25079,25083,25335,25339,25399,25403,25415,25419,25479,25483,25655,25659,25671,25675,25735,25739,25924-25926,25928-25930,25944-25945,25947,25952,25954-25955,25964,25966-25967,25972-25973,25988,25990,26001,26010-26011,26064,26066-26067,26069-26071,26368-26370,26372-26373,26375-26376,26378-26379,26679,26683,26695,26699,26759,26763,27036-27038,27062,27105,27113-27115,27872-27874,27882,27885,27887,28380-28382,28404,28406-28407,28552-28553,28555,28577-28579,28609-28610,29956-29957,29959,29976-29977,29979,30004-30005,30007,30056-30057,30059-30062,30076-30077,30079,30779,30782,30855,30859,30908-30909,30911,30914,30926,30962,30968,31248,31250-31251,31260,31262-31263,31296-31297,31299-31300,31302,31310-31311,31350,31530,31587,31590,31610,31622,31633-31635,31702,31990,31993-31995,32170,32173-32175,32190,32233-32236,32238-32239,32309-32311,32325-32327,32329-32331,32389-32391,32393-32395,32592,32594-32595,32600,32602-32603,32628,32630-32631,34797-34799,34814,36161,36163,36172-36173,36175,36188-36190,36208-36209,36223,36287,36303,36307,36323,36479,36543,36559,36563,36579,36623,36627,36643,40426-40427,40439,40443,40725-40727,40757,40759,40763,40772,40774-40775,40839,40843,40872-40873,44535,44539,44791,44795,44855,44859,44871,44875,44935,44939,48511,48575,48591,48595,48611,48767,48851,48857,48859,48884-48885,48887,48911,48915,48931,49064-49065,49067 39165 44374 2.879e-19 6.355e-19 Metadata for the plates making up the Byurakan spectral surveys, obtained from the WFPDB. make_ssa_view make_tap_view from urllib import urlencode from gavo import votable from gavo.stc import jYearToDateTime, dateTimeToMJD f = utils.urlopenRemote(self.sourceToken, data=urlencode({ "LANG": "ADQL", "QUERY": "select object as plateid, epoch, exptime, emulsion," " raj2000, dej2000" " from wfpdb.main" " where object is not null and object!=''" " and instr_id='BYU102A'" " and method='objective prism'"})) data, metadata = votable.load(f) for row in metadata.iterDicts(data): # HACK: duplicates in WFPDB. See README if row["plateid"]=="NPS": continue if row["plateid"]=="FBS 0966" and int(row["epoch"])==1974: row["plateid"] = "FBS 0966a" if row["plateid"]=="FBS 0326" and row["epoch"]>1971.05: row["plateid"] = "FBS 0326a" if row["plateid"]=="FBS 0449" and row["epoch"]>1971.38: row["plateid"] = "FBS 0449a" row["epoch"] = dateTimeToMJD(jYearToDateTime(row["epoch"])) row["plateid"] = row["plateid"].replace("FBS ", "fbs") row["ra_center"] = row["raj2000"] row["dec_center"] = row["dej2000"] yield row This table contains basic metadata as well as the spectra from the Digital First Byurakan Survey (DFBS). CREATE VIEW \curtable AS ( SELECT \colNames FROM ( SELECT a.*, b.*, '{\spectralBins}'::float[] AS spectral, '\getConfig{web}{serverURL}/dfbsspec/q/cutout/qp/' || specid as cutout_link FROM \schema.raw_spectra as a JOIN \schema.platemeta as b ON (plate=plateid)) AS t) //ssap#sdm-instance with base.getTableConn() as conn: res = list(conn.query( "select spectral, flux from dfbsspec.spectra" " where accref=%(accref)s", {"accref": self.sourceToken["accref"]}))[0] for lam, flx in zip(*res): yield {"spectral": lam, "flux": flx} DFBS Datalink Service data "\rdId#ssa" "\rdId#build_sdm_data" Digitized First Byurakan Survey Browser Interface DFBS SSAP DFBS Spectra Query Service pointed MAXREC=1 archival query DFBS spectra preview maker" specid from gavo.helpers.processing import SpectralPreviewMaker from gavo import svcs with base.getTableConn() as conn: res = list(conn.query("SELECT spectral, flux" " FROM \schema.spectra" " WHERE specid=%(specid)s", inputTable.args)) if not res: raise svcs.UnknownURI("No such spectrum known here") return ("image/png", SpectralPreviewMaker.get2DPlot( zip(res[0][0], res[0][1]), linear=True)) DFBS spectra plate cutout service specid from gavo import svcs with base.getTableConn() as conn: res = list(conn.query( "SELECT plate, pos, px_length, pos_ang" " FROM \schema.raw_spectra" " WHERE specid=%(specid)s", inputTable.args)) if not res: raise svcs.UnknownURI("No such spectrum known here") plate, pos, px_length, pos_ang = res[0] x, y = pos.x/utils.DEG, pos.y/utils.DEG, pos_ang = pos_ang*utils.DEG w = 0.01 # degrees h = 0.05 # degrees h0 = 0.01 # degrees raise svcs.Found( "dfbs/q/dl/dlget?ID=plate/%s" "&POLYGON=%s%%20%s%%20%s%%20%s%%20%s%%20%s%%20%s%%20%s"%( plate, x-h0*math.cos(pos_ang)-w*math.sin(pos_ang), y+h0*math.sin(pos_ang)-w*math.cos(pos_ang), x-h0*math.cos(pos_ang)+w*math.sin(pos_ang), y+h0*math.sin(pos_ang)+w*math.cos(pos_ang), x+h*math.cos(pos_ang)-w*math.sin(pos_ang), y-h*math.sin(pos_ang)-w*math.cos(pos_ang), x+h*math.cos(pos_ang)+w*math.sin(pos_ang), y-h*math.sin(pos_ang)+w*math.cos(pos_ang))) getssa/ssap.xml row = self.getFirstVOTableRow() self.assertEqual(row['ssa_location'].asSODA(), '211.0680249982 44.899394444') self.assertEqual(row["ssa_dstitle"], 'DFBSJ140416.32+445357.8 spectrum from fbs0017') self.assertEqual(row["ssa_bandpass"], "IIAF bkd") self.assertEqual(row["ssa_length"], 112) self.assertAlmostEqual(row["ssa_specstart"], 3.316E-7) self.assertAlmostEqual(row["ssa_dateObs"], 40407, places=5) /getproduct/dfbsspec/q/fbs0017-141024.11+445238.4?preview=True self.assertHasStrings("PNG", "IDATx") sdl/dlget self.assertHasStrings('utype="spec:Spectrum"', 'name="citation"', 'value="UNCALIBRATED"') rows = self.getVOTableRows() self.assertAlmostEqual(rows[-1]["spectral"], 3.316e-07) self.assertAlmostEqual(rows[-1]["flux"], -5.02) /tap/sync rows = self.getVOTableRows() self.assertEqual(len(rows), 1) row = rows[0] self.assertAlmostEqual(row["lam_min"], 3.2060000e-07) self.assertAlmostEqual(row["dec"], 45.606705555556) self.assertEqual(row["emulsion"], "IIAF bkd") self.assertAlmostEqual(row["flux"][2], 16.26, 5) self.assertAlmostEqual(row["spectral"][2], 6.682e-7) cutout/qp/fbs0017-140416.32+445357.8 self.assertHasStrings("DATEORIG= '1969-07-05'", "NAXIS2 = 70", "\\x06\\xd5\\x06\\x49\\x06\\x49")