Catalogue Logo
  • Services
    • Information about JPAS-EDR Services
    • Sky Navigator
    • Object List Search
    • Cone Search
    • Coverage Map
    • Multi-Order Coverage Map (MOC)
    • V.O. Services
  • Information about JPAS-EDR Services
  • Data Access Manual
  • Home - Projects list
  • Contact
  • Register
  • Login
ADQL Help and Examples

Introduction

Functions

  • ABS
  • ACOS
  • AREA
  • ARR_AGG
  • ARR_AVG
  • ARR_CONTAINS
  • ARR_CONTAINS_NULL
  • ARR_COUNT
  • ARR_DOT
  • ARR_MAX
  • ARR_MIN
  • ARR_SUM
  • ASIN
  • ATAN
  • ATAN2
  • BOX
  • CEFCA_FLAMBDATOFNU
  • CEFCA_FNUFLUXTOJANSKY
  • CEFCA_FNUFLUXTOMAGAB
  • CEFCA_FNUTOFLAMBDA
  • CEFCA_JANSKYTOFNUFLUX
  • CEFCA_MAGABTOFNUFLUX
  • CEILING
  • CIRCLE
  • CONTAINS
  • COORD1
  • COORD2
  • COORDSYS
  • COS
  • DEGREES
  • DISTANCE
  • EXP
  • FLOOR
  • INTERSECTS
  • IVO_BIT_AND_AGG
  • IVO_BIT_OR_AGG
  • IVO_CORR
  • IVO_COVAR_SAMP
  • IVO_DMS_TO_DEGREES
  • IVO_HMS_TO_DEGREES
  • IVO_REGR_INTERCEPT
  • IVO_REGR_R2
  • IVO_REGR_SLOPE
  • IVO_STDDEV
  • IVO_STRING_AGG
  • IVO_TO_JD
  • IVO_TO_MJD
  • IVO_VARIANCE
  • LOG
  • LOG10
  • LOWER
  • MOD
  • PI
  • POINT
  • POLYGON
  • POWER
  • RADIANS
  • RAND
  • ROUND
  • SIN
  • SQRT
  • TAN
  • TRUNCATE
  • UPPER

Enumerations

  • calibration_method
  • jpas

Tables: InfoTables

  • jpas.CalibTileImage
  • jpas.Filter
  • jpas.TileImage

Tables: DualModePhot

  • jpas.DuplicatedFLambdaDualObj
  • jpas.DuplicatedFNuDualObj
  • jpas.DuplicatedMagABDualObj
  • jpas.FLambdaDualObj
  • jpas.FNuDualObj
  • jpas.MagABDualObj
  • jpas.MWExtinction

Tables: Photo-z

  • jpas.PhotoZLephare

Tables: SingleModePhot

  • jpas.DuplicatedFLambdaSingleObj
  • jpas.DuplicatedFNuSingleObj
  • jpas.DuplicatedMagABSingleObj
  • jpas.FLambdaSingleObj
  • jpas.FNuSingleObj
  • jpas.MagABSingleObj

Tables: IndividualPhot

  • jpas.FLambdaIndividual_DualObj
  • jpas.FLambdaIndividualObj
  • jpas.FNuIndividual_DualObj
  • jpas.FNuIndividualObj
  • jpas.MagABIndividual_DualObj
  • jpas.MagABIndividualObj
  • jpas.ReducedIndividualImage

Tables: xmatch

  • jpas.xmatch_2mass
  • jpas.xmatch_alhambra
  • jpas.xmatch_allwise
  • jpas.xmatch_cfrs
  • jpas.xmatch_deep2_photo
  • jpas.xmatch_desi
  • jpas.xmatch_gaia_dr3
  • jpas.xmatch_galex_ais
  • jpas.xmatch_Individual_DualObj
  • jpas.xmatch_jplus_dr3
  • jpas.xmatch_minijpas_pdr201912
  • jpas.xmatch_panstarrs_dr1
  • jpas.xmatch_sdss_dr12
  • jpas.xmatch_subaru_pdr2

Tables: All J-PAS

  • jpas.CalibTileImage
  • jpas.DuplicatedFLambdaDualObj
  • jpas.DuplicatedFLambdaSingleObj
  • jpas.DuplicatedFNuDualObj
  • jpas.DuplicatedFNuSingleObj
  • jpas.DuplicatedMagABDualObj
  • jpas.DuplicatedMagABSingleObj
  • jpas.Filter
  • jpas.FLambdaDualObj
  • jpas.FLambdaIndividual_DualObj
  • jpas.FLambdaIndividualObj
  • jpas.FLambdaSingleObj
  • jpas.FNuDualObj
  • jpas.FNuIndividual_DualObj
  • jpas.FNuIndividualObj
  • jpas.FNuSingleObj
  • jpas.MagABDualObj
  • jpas.MagABIndividual_DualObj
  • jpas.MagABIndividualObj
  • jpas.MagABSingleObj
  • jpas.MWExtinction
  • jpas.PhotoZLephare
  • jpas.ReducedIndividualImage
  • jpas.TileImage
  • jpas.xmatch_2mass
  • jpas.xmatch_alhambra
  • jpas.xmatch_allwise
  • jpas.xmatch_cfrs
  • jpas.xmatch_deep2_photo
  • jpas.xmatch_desi
  • jpas.xmatch_gaia_dr3
  • jpas.xmatch_galex_ais
  • jpas.xmatch_Individual_DualObj
  • jpas.xmatch_jplus_dr3
  • jpas.xmatch_minijpas_pdr201912
  • jpas.xmatch_panstarrs_dr1
  • jpas.xmatch_sdss_dr12
  • jpas.xmatch_subaru_pdr2

Tables: VO Services

  • ivoa.ObsCore
  • TAP_SCHEMA.columns
  • TAP_SCHEMA.key_columns
  • TAP_SCHEMA.keys
  • TAP_SCHEMA.schemas
  • TAP_SCHEMA.tables
Copyright © 2024-2025 Javalambre Physics of the Accelerating Universe Astrophysical Survey. All Rights Reserved. - How to cite JPAS-EDR - Acknowledgements - v1.33
Developed and maintained by Tamara Civera (CEFCA)