搜索DeepPro708000.mdb 深空天体数据库

1.安装Deepsky Astronomy Software
http://www.mikehotka.com/DAS/masterdownload.htm

2.搜索：

DeepSkyTable([‘NGC 3372’,‘Be 84’])

# 搜索mdb
def searchInmdb(id='',pf='',brave=True):
    lis = []
    # 连接mdb文件
    connStr = (
        r'Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Program Files (x86)/Deepsky Astronomy Software/DeepPro708000.mdb;'
        # r'Database=DeepskyTable;'
        )
    conn = mdb.win_connect_mdb(connStr)
    cur = conn.cursor()
    if id!='':
        oql = "SELECT * FROM DeepskyTable WHERE objectid = '%s' or otherid = '%s';"%(id,id)
        cur.execute(oql)
    elif pf!='':
        if brave:
            # oql = "SELECT * FROM DeepskyTable WHERE LEFT(objectid,%s) = '%s' or otherid like '%%%s%%';"%(len(pf),pf,pf)
            oql = "SELECT * FROM DeepskyTable WHERE LEFT(objectid,%s) = '%s' or LEFT(otherid,%s) = '%s';" % (len(pf), pf, len(pf), pf)
        else:
            # oql = "SELECT * FROM DeepskyTable WHERE LEFT(objectid,%s) = '%s' or LEFT(otherid,%s) = '%s';"%(len(pf),pf,len(pf),pf)
            oql = "SELECT * FROM DeepskyTable WHERE LEFT(objectid,%s) = '%s';"%(len(pf),pf)
        print(oql)
        cur.execute(oql)
    else:
        return
    tmplis=[]
    for col in cur.description:
        # 展示行描述
        tmplis.append(col[0])
    # print(tmplis)
    tlis = ['ID','ID2','RA2000','Dec2000','Mag','Size','Type','Const','Source']
    # lis.append(tlis)
    result = cur.fetchall()
    lis = []
    for row in result:
        # 展示个字段的值
        row = [str(x) for x in list(row)]
        lis.append([row[1],row[2],row[4]+'h'+row[5]+'m',(int(row[4])+float(row[5])/60)/12*pi,row[6]+'°'+row[7]+"'",(int(row[6])+float(row[7])/60)/180*pi,row[13],row[12],row[3],row[11],row[19]])
        # print(row[19]+': \t'+row[1]+'\t'+row[2]+'\t'+row[4]+'h'+row[5]+'m'+'\t'+row[6]+'°'+row[7]+"'"+' v:'+row[13])
        # print(row)
        lis.append(list(row))
    # print(len(lis))
    for ix in ['2000','SAC81','SAC75','SAC71']:
        for line in lis:
            if line[len(line) - 1]==ix:
                return line
    if lis == []:
        # return [id]
        return None
    return lis[0]
def DeepSkyTable(lis):
    tlis = [['ID','ID2','RA','RAd','Dec','Decd','Mag','Size','Type','Const','Source']]
    for line in lis:
        rsl = searchInmdb(line)
        if rsl == None:
            continue
        tlis.append(rsl)
    return tlis

深空数据库说明：

Name	Description
2000	NGC 2000 （http://cdsweb.u-strasbg.fr/viz-bin/Cat?VII/118）
SAC 8.1	Saguaro Astronomy Club Database version 8.1
Barnard’s Catalog of Dark Objects	Barnard’s Catalog of Dark Objects (Barnard 1927)
ChaSNR	Catalog of Galactic Supernova Remnants (Chandra)
MCSNR	Catalog of Magellanic Cloud Supernova Remnants
Alignment	Alignment Stars Catalog
vdB	Catalogue of Reflection Nebulae
VII 216	Catalogue of Southern Emission Nebulae
BSC	Yale Bright Star Catalog
I 209A	Catalog of 2900 double stars
I1237	Washington Visual Double Star Catalog
II 171	Parenago Catalog of Stars in Orion Nebula
I214	General Catalog Of Variable Stars
NSCVS	New Catalog of Suspected Variables
I214EG	Extragalactic Variable Stars
V84	ESO Catalog Of Planetary Nebula
VII 103	Galactic Globular Clusters
Bhe	Catalogue of Southern Stars embedded in nebulosity
VII 116	Southern Galaxy Catalog (SGC)
VII 136	Extra Galactic Database II
VII 140	Catalog of Galaxies Behind the Milky Way
VII 145	NBG - Nearby Galaxies Catalogue
VII 155	Third Reference Cat. of Bright Galaxies
VII 159	Catalog of galaxies towards the Coma SuperCluster
VII 24A	Starsbourg Catalog of Plan Neb
VII 51	Shapley-Ames Catalog of Bright Galaxies
VII 57	List of Globules
VII 68A	Dark Nebulae and Globules
VII 77	Isolated Pairs of Galaxies in the Northern Hem
VII 79A	Galaxies South of Dec -30, Obs Spectroscopically
VII 82A	Isolated Galaxies
VII 83	Isolated Triplets of galaxies
VII 84A	Groups of Galaxies. III. The CfA Survey
VII 89B	Compact Group of Compact Galaxies
VII 98A	Catalog of 2810 Nearby Galaxies
VII161	Nearby Galaxies
VII170	Catalog of Southern Peculiar Galaxies
VII188-1	Active Galaxies fainter than -23
VII188-2	Quasars Brighter Than absolute magnitude -23
VII191	Catalog of Southern Dark Clouds
VII20	Catalog of HII Regions
VII21	Catalog of Reflection Nebula
VII26D	Uppsala General Catalog of Galaxies
VII4A-1	Abell Cluster of Galaxies
VII4A-2	Zwicky Cluster of Galaxies
VII5A	Star Clusters and Associations
VII62A	Morphological Catalog of Galaxies
VII74A	Atlas of Peculiar Galaxies
VII7A	Catalog of Dark Nebula
VII85A	Hickson Catalog of Compact Galaxies
VII9	Lynds Catalog of Bright Nebula
VII92A	Open Cluster Data 5th Edition
VIII-4	Fourth Cambridge Radio Survey Catalog
VII-119	PGC - Catalog of Principal Galaxies
VII-142	Southern Redshifts Catalog
VII-173	Catalog of Seyfert Galaxies
VII-196	Shakhbazian Compact Groups of Galaxies
VII-211	Galactic Supernova Remnants