skip to main content
OSTI.GOV title logo U.S. Department of Energy
Office of Scientific and Technical Information

Title: easyaccess: Enhanced SQL command line interpreter for astronomical surveys

Abstract

easyaccess is an enhanced command line interpreter and Python package createdto facilitate access to astronomical catalogs stored in SQL Databases. Itprovides a custom interface with custom commands and was specifically designedto access data from the Dark Energy Survey Oracle database, includingautocompletion of tables, columns, users and commands, simple ways to uploadand download tables using csv, fits and HDF5 formats, iterators, search anddescription of tables among others. It can easily be extended to anothersurveys or SQL databases. The package was completely written in Python andsupport customized addition of commands and functionalities.

Authors:
 [1]; ORCiD logo [2];  [1];  [1]
  1. Illinois U., Urbana
  2. Fermilab
Publication Date:
Research Org.:
Fermi National Accelerator Lab. (FNAL), Batavia, IL (United States)
Sponsoring Org.:
USDOE Office of Science (SC), High Energy Physics (HEP) (SC-25)
OSTI Identifier:
1488601
Report Number(s):
FERMILAB-PUB-18-520-AE; arXiv:1810.02721
1699160
DOE Contract Number:  
AC02-07CH11359
Resource Type:
Journal Article
Journal Name:
J.Open Source Softw.
Additional Journal Information:
Journal Name: J.Open Source Softw.
Country of Publication:
United States
Language:
English
Subject:
79 ASTRONOMY AND ASTROPHYSICS; 46 INSTRUMENTATION RELATED TO NUCLEAR SCIENCE AND TECHNOLOGY

Citation Formats

Carrasco Kind, M., Drlica-Wagner, A., Koziol, A.M. G., and Petravick, D. easyaccess: Enhanced SQL command line interpreter for astronomical surveys. United States: N. p., 2018. Web.
Carrasco Kind, M., Drlica-Wagner, A., Koziol, A.M. G., & Petravick, D. easyaccess: Enhanced SQL command line interpreter for astronomical surveys. United States.
Carrasco Kind, M., Drlica-Wagner, A., Koziol, A.M. G., and Petravick, D. Fri . "easyaccess: Enhanced SQL command line interpreter for astronomical surveys". United States. https://www.osti.gov/servlets/purl/1488601.
@article{osti_1488601,
title = {easyaccess: Enhanced SQL command line interpreter for astronomical surveys},
author = {Carrasco Kind, M. and Drlica-Wagner, A. and Koziol, A.M. G. and Petravick, D.},
abstractNote = {easyaccess is an enhanced command line interpreter and Python package createdto facilitate access to astronomical catalogs stored in SQL Databases. Itprovides a custom interface with custom commands and was specifically designedto access data from the Dark Energy Survey Oracle database, includingautocompletion of tables, columns, users and commands, simple ways to uploadand download tables using csv, fits and HDF5 formats, iterators, search anddescription of tables among others. It can easily be extended to anothersurveys or SQL databases. The package was completely written in Python andsupport customized addition of commands and functionalities.},
doi = {},
journal = {J.Open Source Softw.},
number = ,
volume = ,
place = {United States},
year = {2018},
month = {10}
}

Journal Article:

Figures / Tables:

Figure 1 Figure 1: Number of user since first version

Save / Share:
Figures/Tables have been extracted from DOE-funded journal article accepted manuscripts.