Catalogue Logo
  • Services
    • Information about J-PLUS-EDR Services
    • Sky Navigator
    • Object List Search
    • Image Search
    • Cone Search
    • Coverage Map
    • Multi-Order Coverage Map (MOC)
    • ASCII Image Catalogues
    • VO Asynchronous Queries (ADQL)
    • ADQL Help and Examples
    • V.O. Services
    • Direct Download Services
  • Information about J-PLUS-EDR Services
  • Data Access Manual
  • Home - Projects list
  • Contact
  • Register
  • Login
ADQL Help and Examples

Introduction

Functions

  • ABS
  • ACOS
  • ARC_DISTANCE
  • AREA
  • ARRAY_MAX_FLOAT
  • ARRAY_MAX_INT
  • ARRAY_MAX_TS
  • ARRAY_MIN_FLOAT
  • ARRAY_MIN_INT
  • ARRAY_MIN_TS
  • ASIN
  • ATAN
  • ATAN2
  • bit_and
  • bit_or
  • BOX
  • CEILING
  • CIRCLE
  • CONTAINS
  • COORD1
  • COORD2
  • COORDSYS
  • corr
  • COS
  • covar_samp
  • DEGREES
  • DISTANCE
  • dms_to_degrees
  • EXP
  • fLambdaToFNu
  • FLOOR
  • fNuFluxToJansky
  • fNuFluxToMagAB
  • fNuToFLambda
  • hms_to_degrees
  • IN_ARRAY_INT
  • INTERSECTS
  • janskyToFNuFlux
  • LOG
  • LOG10
  • magABToFNuFlux
  • MOD
  • PI
  • POINT
  • POLYGON
  • POWER
  • RADIANS
  • RAND
  • REGR_INTERCEPT
  • REGR_R2
  • REGR_SLOPE
  • ROUND
  • SIN
  • SQRT
  • STDDEV
  • string_agg
  • TAN
  • TRUNCATE
  • ts_to_jd
  • ts_to_mjd
  • VARIANCE

Enumerations

  • jplus
  • jplus_img_flag

Tables: Most used

  • jplus.Filter
  • jplus.MagABDualObj
  • jplus.MagABSingleObj
  • jplus.TileImage

Tables: All scientific

  • jplus.DuplicatedFLambdaDualObj
  • jplus.DuplicatedFLambdaSingleObj
  • jplus.DuplicatedFNuDualObj
  • jplus.DuplicatedFNuSingleObj
  • jplus.DuplicatedMagABDualObj
  • jplus.DuplicatedMagABSingleObj
  • jplus.Filter
  • jplus.FLambdaDualObj
  • jplus.FLambdaSingleObj
  • jplus.FNuDualObj
  • jplus.FNuSingleObj
  • jplus.MagABDualObj
  • jplus.MagABSingleObj
  • jplus.StarGalClass
  • jplus.TileImage
  • jplus.TileImageWithFlag
  • jplus.xmatch_allwise
  • jplus.xmatch_gaia_dr2
  • jplus.xmatch_galex_ais
  • jplus.xmatch_panstarrs_dr1
  • jplus.xmatch_sdss_dr12

Tables: VO Services

  • TAP_SCHEMA.columns
  • TAP_SCHEMA.key_columns
  • TAP_SCHEMA.keys
  • TAP_SCHEMA.schemas
  • TAP_SCHEMA.tables
Copyright © 2015-2019 Javalambre Photometric Local Universe Survey. All Rights Reserved. - How to cite J-PLUS-EDR - Acknowledgements - v1.26
Developed and maintained by Tamara Civera (CEFCA)