Bug: query_plate_mjd_fiber error in Chapter 1 #275
Comments
|
By changing the line "PUBLIC_URL = 'http://cas.sdss.org/public/en/tools/search/x_sql.aspx'" to "PUBLIC_URL = 'http://cas.sdss.org/dr7/en/tools/search/x_sql.asp'" in sql_query.py I can make it work for dr7. But how can I make it work for dr18? |
Hello, have you resolved the issue? |
Not yet. Can anyone help? |
As I run the following
from astroML.datasets import tools
target = tools.TARGET_GALAXY # main galaxy sample
plt, mjd, fib = tools.query_plate_mjd_fiber(5, primtarget=target)
following the content in page 20 of the textbook, I got a 404 error. I found that the web in PUBLIC_URL = 'http://cas.sdss.org/public/en/tools/search/x_sql.aspx' in conde sql_query.py does not exist so I change it to PUBLIC_URL = 'http://cas.sdss.org/dr18/SearchTools/sql' The page can then be connected but it output the following error messages (part of the message is cut off since it is too long):
ValueError Traceback (most recent call last)
File ~/opt/anaconda3/envs/astroml/lib/python3.10/site-packages/astroML/datasets/tools/cas_query.py:77, in query_plate_mjd_fiber(n_spectra, primtarget, zmin, zmax)
76 try:
---> 77 res[i] = line.decode().strip().split(',')
78 except BaseException:
ValueError: invalid literal for int() with base 10: ''
During handling of the above exception, another exception occurred:
ValueError Traceback (most recent call last)
Cell In[1], line 3
1 from astroML.datasets import tools
2 target = tools.TARGET_GALAXY # main galaxy sample
----> 3 plt, mjd, fib = tools.query_plate_mjd_fiber(5, primtarget=target)
File ~/opt/anaconda3/envs/astroml/lib/python3.10/site-packages/astroML/datasets/tools/cas_query.py:79, in query_plate_mjd_fiber(n_spectra, primtarget, zmin, zmax)
77 res[i] = line.decode().strip().split(',')
78 except BaseException:
---> 79 raise ValueError(b'\n'.join(output))
81 ntot = i + 1
83 return res[:ntot].T
ValueError: b'\r\n\n<!doctype html>\r\n\n\r\n\n\r\n\n \r\n\n \r\n\n \r\n\n \r\n\n \r\n\n <title>SQL Search - SkyserverSDSS</title>\r\n\n\r\n\n \r\n\n \r\n\n\r\n\n \r\n\n \r\n\n \r\n\n \r\n\n\r\n\n \r\n\n \r\n\n \r\n\n \r\n\n \r\n\n <script src="https://code.jquery.com/jquery-3.4.1.min.js" integrity="sha256-CSXorXvZcTkaix6Yvo6HppcZGetbYMGWSFlBw8HfCJo=" crossorigin="anonymous"></script>\r\n\n <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>\r\n\n <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>\r\n\n \r\n\n <script src="/dr18/js/skyserver.js"></script>\r\n\n \r\n\n \r\n\n \r\n\n <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>\r\n\n <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/ace/1.4.3/ace.js"></script>\r\n\n <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/ace/1.4.1/ext-language_tools.js"></script>\r\n\n <script src="/dr18/js/sqlsearch.js"></script>\r\n\n\r\n\n\r\n\n\r\n\n<style>\r\n\n #supportDropdown {\r\n\n min-width: 400px;\r\n\n }\r\n\n</style>\r\n\n
\r\n\n \r\n\n \r\n\n \r\n\n\r\n\n- Home
\r\n\n\r\n\n - \r\n\n \r\n\n Visual Tools\r\n\n \r\n\n
\r\n\n - \r\n\n \r\n\n Search Tools\r\n\n \r\n\n
\r\n\n - \r\n\n \r\n\n CrossMatch Tools\r\n\n \r\n\n
\r\n\n - \r\n\n \r\n\n More Tools\r\n\n \r\n\n
\r\n\n - \r\n\n \r\n\n Support\r\n\n \r\n\n
\r\n\n \r\n\n - CasJobs
\r\n\n
\r\n\n\r\n\n- Overview
\r\n\n - Navigate
\r\n\n - Explore
\r\n\n - Finding Chart
\r\n\n - Quick Look
\r\n\n - Image List
\r\n\n
\r\n\n\r\n\n- Overview
\r\n\n - SQL Search
\r\n\n \r\n\n - Rectangular Search
\r\n\n - Radial Search
\r\n\n - Imaging Search
\r\n\n - Spectroscopic Search
\r\n\n - IR Spectroscopic Search
\r\n\n
\r\n\n\r\n\n- Overview
\r\n\n - CrossMatch ID
\r\n\n \r\n\n
\r\n\n\r\n\n- Overview
\r\n\n - My History
\r\n\n - Schema Browser
\r\n\n - Scrolling Sky
\r\n\n - Get Fields
\r\n\n - Get Spectra
\r\n\n - Get Plates
\r\n\n
\r\n\n\r\n\n- Overview
\r\n\n - About the Data
\r\n\n - Schema Browser
\r\n\n\r\n\n - Sample Queries
\r\n\n - SQL in SkyServer
\r\n\n - Query Advice
\r\n\n - APIs
\r\n\n - SQL Tutorial (DR16)
\r\n\n \r\n\n - Contact
\r\n\n \r\n\n \r\n\n \r\n\n\r\n\n
\r\n\n\r\n\n- Overview
\r\n\n - SQL Search
\r\n\n \r\n\n <li ----------------------------------------------------------------------------------------------------------------- -->\r\n\n \r\n\n \r\n\n MaStar\r\n\n \r\n\n \r\n\n \r\n\n MaStar Selecting G-stars\r\n\n -- Selecting G-stars from mastar_goodstars_params\r\n\n-- This query returns the stellar parameters for the first 100 G-stars in the mastar_goodstars table.\r\n\n-- G-stars are selected using a temperature criterion.\r\n\n\r\n\nSELECT \r\n\n TOP 100 mangaid, teff_med, logg_med, feh_med, alpha_med\r\n\nFROM mastar_goodstars_params\r\n\nWHERE teff_med BETWEEN 5000 AND 6000 \r\n\n \r\n\n \r\n\n MaStar Stars near cluster center\r\n\n -- Selecting stars near cluster center\r\n\n-- This query returns the coordinates and parameters for stars within 0.5 degrees of\r\n\n-- the open cluster M67 (central coordinates 132.83, 11.82) in the mastar_goodstars_params\r\n\n-- the mastar_goodstars_params table that have been observed more than once (nvisits).\r\n\n\r\n\nSELECT \r\n\n mangaid, nvisits, ra, dec, teff_med, logg_med, feh_med, alpha_med\r\n\nFROM \r\n\n mastar_goodstars_params\r\n\nWHERE\r\n\n POWER(ra - 132.83, 2) + POWER(dec - 11.82, 2) < POWER(0.5, 2)\r\n\n AND nvisits >= 2 \r\n\n \r\n\n \r\n\n MaStar High-velocity stars\r\n\n -- Selecting High Velocity Stars in mastar_goodvisits\r\n\n-- This query returns radial velocities, uncertainties, and Gaia photometry\r\n\n-- for stars with velocities > 300 km/s. It restricts to stars with good velocity\r\n\n-- measurements through the v_errcode selection criteria.\r\n\n\r\n\nSELECT\r\n\n TOP 100 v.mangaid, v.plate, v.ifudesign, v.mjd, v.ra, v.dec, v.heliov, v.verr, g.m_g, g.bprpc\r\n\nFROM mastar_goodvisits AS v\r\n\n JOIN mastar_goodstars_xmatch_gaiaedr3 AS g ON g.mangaid = v.mangaid\r\n\nWHERE v.heliov > 300 AND v_errcode=0 \r\n\n \r\n\n \r\n\n MaStar K-type dwarfs using colors\r\n\n -- Search for K-type dwarfs using color criteria\r\n\n-- This query searches for K-type dwarfs using color cuts from SEGUE.\r\n\n-- Returns the gri magnitudes, plate ID and fiber bundle.\r\n\n-- Uses the mngtarg2 flag to select stars from the same photometry\r\n\n-- source catalog. Bit 8 is set for stars from the APASS system.\r\n\n--- Bit 11 is set for stars from the SDSS system. Both APASS and SDSS\r\n\n--- uses the SDSS filter bands.\r\n\n\r\n\nSELECT\r\n\n TOP 100 mangaid, psfmag_2, psfmag_3, psfmag_4, plate, ifudesign, mjd, photocat\r\n\nFROM mastar_goodvisits\r\n\nWHERE\r\n\n ( (mngtarg2 & POWER(2, 8)) <> 0 OR (mngtarg2 & POWER(2,11)) <>0 )\r\n\n AND psfmag_3 BETWEEN 14.5 AND 19.0\r\n\n AND (psfmag_2 - psfmag_3) BETWEEN 0.55 AND 0.75 \r\n\n \r\n\n \r\n\n MaStar and Gaia info from stars near cluster ctr\r\n\n -- Retrieve MaStar parameters and Gaia photomery for stars near cluster center\r\n\n-- This query joins the mastar_goodvisits_params and mastar_goodstars_xmatch_gaiaedr3 tables\r\n\n-- to retrieve the parameters, Gaia photometry (G-band magnitude and BP-RP color), \r\n\n-- and reddening estimates from a 3D dust map\r\n\n-- for stars within 0.5 degrees of the open cluster M67 (central coordinates 132.833, 11.82)\r\n\n\r\n\nSELECT\r\n\n v.mangaid, v.plate, v.ifudesign, v.mjd, v.teff_med, v.logg_med, v.feh_med, v.alpha_med,\r\n\n g.m_g, g.bp_rp, g.ebv, g.bprpc\r\n\nFROM mastar_goodvisits_params AS v\r\n\n JOIN mastar_goodstars_xmatch_gaiaedr3 AS g ON g.mangaid = v.mangaid\r\n\nWHERE\r\n\n POWER(v.ra - 132.83, 2) + POWER(v.dec - 11.82, 2) < POWER(0.5, 2) \r\n\n \r\n\n \r\n\n \r\n\n
\r\n\n- Sponsored by:
\r\n\n - Alfred P. Sloan Foundation
\r\n\n - The National Science Foundation
\r\n\n - ARC
\r\n\n
\r\n\n\r\n\n- Policies:
\r\n\n - Privacy Policy
\r\n\n - Website Traffic
\r\n\n \r\n\n \r\n\n
\r\n\n\r\n\n- Contact:
\r\n\n - email: helpdesk@sdss.org
\r\n\n
\r\n\nAny help will be greatly appreciated!
The version of my astroML is 1.0.2.post1
Regards,
Li-Xin
The text was updated successfully, but these errors were encountered: