沈阳沈阳建设工程信息网站,买卖域名挣几十万,免费下载的app,连云港优化推广Step1:在sloan的casjob里http://casjobs.sdss.org/CasJobs/#xff0c;密码用户 jiangbin 123456 查询满足条件的光谱对象#xff0c;得到光谱对象的plate,MJD,fiber#xff0c;或者赤经赤纬#xff0c;将其存为.csv文件。Csv文件可由excel直接编辑#xff0c;注意要调整… Step1:在sloan的casjob里http://casjobs.sdss.org/CasJobs/密码用户 jiangbin 123456 查询满足条件的光谱对象得到光谱对象的plate,MJD,fiber或者赤经赤纬将其存为.csv文件。Csv文件可由excel直接编辑注意要调整顺序为plate,MJD,fiberid,excel文件第一行要保留这几个关键字。点击quick不要点击sumbit按钮 Step2:在sloan的http://das.sdss.org/www/html/post_fibers.html提交.csv文件此处也可以是txt文件见cvs文件夹下txt Step3:点击this form链接出现Download selection选择要下载的文件类型此处选择spSpec。再选中wget提交。 Step4提交后会出现一个URL列表另存为.txt文件,比如为D:\url.txt此处可以手工修改。 Step5:开始运行cmd,进入dos窗口输入wget -i D:\url.txtwget -i G:\DATA\sdss-wget-awrOed.lis回车。 之后就开始批量下载了下载到dos窗口的当前目录下。 选取5000条star select top 5000 plate,MJD,fiberID from specobjall where classstar and waveMin 4000 and waveMax 9000 选取后5000条数据 select top 10000 plate,MJD,fiberID from specobjall where classstar and waveMin 4000 and waveMax 9000 except select top 5000 plate,MJD,fiberID from specobjall where classstar and waveMin 4000 and waveMax 9000 类别 Qso Galaxy select plate,MJD,fiberID from specobjall where subClass like M[0-9] and snMedian_g15 1. 采用信噪比15的G M K A F类恒星数据进行实验获取数据格式select plate,MJD,fiberID from specobjall where subClass like M[0-9] and snMedian_g152. 获取激变变星搜寻群目前只有DR7是开放的不要从DR15里搜select plate,mjd,fiberID from SpecPhotoAll into mydb.patrickwhere psfMag_u-psfMag_g0.45 and psfMag_g-psfMag_r0.7 and psfMag_r-psfMag_i0.3 and psfMag_i-psfMag_z0.4select top 8000 plate,mjd,fiberID from patrickdelete top(8000) from patrick3. Casjob网站http://casjobs.sdss.org/CasJobs/4. Sloan提交csv网站http://das.sdss.org/www/html/post_fibers.html5. 下载数据方法wget -i txt文件的路径6. DR7类别http://cas.sdss.org/dr7/de/help/browser/enum.asp?nSpecClass7. DR7帮助https://classic.sdss.org/dr7/glossary/index.html8. 按类别搜索DR7中的反例select top 8000 plate,mjd,fiberID from specobjall where specClass1 order by newid() /*specClass1: STAR*/select top 4000 plate,mjd,fiberID from specobjall where specClass2 order by newid() /*specClass2: GALAXY*/select top 4000 plate,mjd,fiberID from specobjall where specClass3 order by newid() /*specClass3: QSO*/select top 4000 plate,mjd,fiberID from specobjall where specClass4 or specClass5 or specClass6 or specClass0 order by newid() /*specClass0,4,5,6: OTHER*/ 转载于:https://www.cnblogs.com/invisible2/p/11451118.html
