Information on Service 'PDS-PPI VO server TAP service'

The PDS-PPI VO server's TAP end point. The Table Access Protocol (TAP) lets you execute queries against our database tables, inspect various metadata, and upload your own data. It is thus the VO's premier way to access public data holdings. Tables exposed through this endpoint include: epn_core from the cassini_caps_calibrated_els schema, epn_core from the cassini_caps_calibrated_ibs schema, epn_core from the cassini_caps_calibrated_ion schema, epn_core from the cassini_caps_calibrated_sng schema, epn_core from the cassini_caps_calibrated_toflef schema, epn_core from the cassini_caps_calibrated_tofst schema, epn_core from the cassini_caps_derived_ele_mom schema, epn_core from the cassini_caps_derived_ion_mom schema, epn_core from the cassini_caps_derived_scpot schema, epn_core from the cassini_caps_fitted_parameters schema, epn_core from the cassini_rpws_electron_density schema, epn_core from the cassini_rpws_hfr_qtn schema, epn_core from the galileo_epd_cal_corrected_cms_events_deltaexe schema, epn_core from the galileo_epd_cal_corrected_cms_events_tof schema, epn_core from the galileo_epd_cal_corrected_high_res schema, epn_core from the galileo_epd_cal_corrected_low_res schema, epn_core from the galileo_epd_cal_corrected_med_res schema, epn_core from the galileo_hic_jup_calibrated_highres schema, epn_core from the galileo_hic_jup_calibrated_highres_amalthea schema, epn_core from the galileo_hic_jup_calibrated_highres_callisto schema, epn_core from the galileo_hic_jup_calibrated_highres_europa schema, epn_core from the galileo_hic_jup_calibrated_highres_ganymede schema, epn_core from the galileo_hic_jup_calibrated_highres_io schema, epn_core from the galileo_hic_jup_calibrated_survey_countrate schema, epn_core from the galileo_hic_jup_derived schema, epn_core from the galileo_hic_jup_raw schema, epn_core from the galileo_hic_prejup_derived schema, epn_core from the galileo_mag_jup_calibrated_highres_callisto schema, epn_core from the galileo_mag_jup_calibrated_highres_europa schema, epn_core from the galileo_mag_jup_calibrated_highres_ganymede schema, epn_core from the galileo_mag_jup_calibrated_highres_io schema, epn_core from the galileo_mag_jup_calibrated_highres_magnetoshpere schema, epn_core from the galileo_mag_jup_calibrated_magspheric_survey schema, epn_core from the galileo_pls_jup_fitted_parameters schema, epn_core from the insight_ifg_mars_calibrated schema, epn_core from the insight_ifg_mars_newcal_calibrated schema, epn_core from the insight_ifg_mars_newcal_calibrated_maven_20hz schema, epn_core from the insight_ifg_mars_newcal_partially_processed schema, epn_core from the insight_ifg_mars_newcal_raw schema, epn_core from the insight_ifg_mars_partially_processed schema, epn_core from the insight_ifg_mars_raw schema, epn_core from the insight_ifg_mars_sc_engineering schema, epn_core from the maven_anc_drf_eps schema, epn_core from the maven_anc_drf_gnc schema, epn_core from the maven_anc_drf_ngms schema, epn_core from the maven_anc_drf_pf schema, epn_core from the maven_anc_drf_pte schema, epn_core from the maven_anc_drf_rs schema, epn_core from the maven_anc_drf_sasm1 schema, epn_core from the maven_anc_drf_sasm2 schema, epn_core from the maven_anc_drf_sasm3 schema, epn_core from the maven_anc_drf_usm1 schema, epn_core from the maven_anc_drf_usm2 schema, epn_core from the maven_anc_drf_usm3 schema, epn_core from the maven_anc_drf_usm4 schema, epn_core from the maven_anc_drf_usm5 schema, epn_core from the maven_anc_drf_usm6 schema, epn_core from the maven_anc_events schema, epn_core from the maven_anc_imu schema, epn_core from the maven_euv_calibrated schema, epn_core from the maven_euv_modelled_daily schema, epn_core from the maven_euv_modelled_minute schema, epn_core from the maven_insitu_calibrate_kp schema, epn_core from the maven_lpw_calibrated_lp_iv schema, epn_core from the maven_lpw_calibrated_mrg_scpot schema, epn_core from the maven_lpw_calibrated_w_e12 schema, epn_core from the maven_lpw_calibrated_w_e12bursthf schema, epn_core from the maven_lpw_calibrated_w_e12burstlf schema, epn_core from the maven_lpw_calibrated_w_e12burstmf schema, epn_core from the maven_lpw_calibrated_w_specact schema, epn_core from the maven_lpw_calibrated_w_specpas schema, epn_core from the maven_lpw_derived_lpnt schema, epn_core from the maven_lpw_derived_wn schema, epn_core from the maven_mag_calibrated_pc schema, epn_core from the maven_mag_calibrated_pl schema, epn_core from the maven_mag_calibrated_ss schema, epn_core from the maven_rose_calibrated_sky schema, epn_core from the maven_rose_derived_edp schema, epn_core from the maven_sep_calibrate_anc schema, epn_core from the maven_sep_calibrate_counts schema, epn_core from the maven_sep_calibrate_spec schema, epn_core from the maven_static_c_2a_hkp schema, epn_core from the maven_static_c_c0_64e2m schema, epn_core from the maven_static_c_c2_32e32m schema, epn_core from the maven_static_c_c4_4e64m schema, epn_core from the maven_static_c_c6_32e64m schema, epn_core from the maven_static_c_c8_32e16d schema, epn_core from the maven_static_c_ca_16e4d16a schema, epn_core from the maven_static_c_cc_32e8d32m schema, epn_core from the maven_static_c_cd_32e8d32m schema, epn_core from the maven_static_c_ce_16e4d16a16m schema, epn_core from the maven_static_c_cf_16e4d16a16m schema, epn_core from the maven_static_c_d0_32e4d16a8m schema, epn_core from the maven_static_c_d1_32e4d16a8m schema, epn_core from the maven_static_c_d4_4d16a2m schema, epn_core from the maven_static_c_d6_events schema, epn_core from the maven_static_c_d7_fsthkp schema, epn_core from the maven_static_c_d8_12r1e schema, epn_core from the maven_static_c_d9_12r64e schema, epn_core from the maven_static_c_da_1r schema, epn_core from the maven_static_c_db_1024tof schema, epn_core from the maven_swea_arc_3d schema, epn_core from the maven_swea_arc_pad schema, epn_core from the maven_swea_svy_3d schema, epn_core from the maven_swea_svy_pad schema, epn_core from the maven_swea_svy_spec schema, epn_core from the maven_swia_coarse_arc_3d schema, epn_core from the maven_swia_coarse_svy_3d schema, epn_core from the maven_swia_fine_arc_3d schema, epn_core from the maven_swia_fine_svy_3d schema, epn_core from the maven_swia_onboard_svy_mom schema, epn_core from the maven_swia_onboard_svy_spec schema, epn_core from the mess_epps_eps_calibrated_hi_spectra schema, epn_core from the mess_epps_eps_calibrated_hires_spectra schema, epn_core from the mess_epps_eps_calibrated_lores_spectra schema, epn_core from the mess_epps_eps_calibrated_med_spectra schema, epn_core from the mess_epps_eps_calibrated_pha schema, epn_core from the mess_epps_eps_calibrated_scan_spectra schema, epn_core from the mess_epps_eps_calibrated_summary_spectra schema, epn_core from the mess_epps_eps_derived_pa_daily_spectrogram schema, epn_core from the mess_epps_eps_derived_pa_values schema, epn_core from the mess_epps_fips_calibrated_hi_spectra schema, epn_core from the mess_epps_fips_calibrated_hires_proton_v schema, epn_core from the mess_epps_fips_calibrated_med_spectra schema, epn_core from the mess_epps_fips_calibrated_pha schema, epn_core from the mess_epps_fips_calibrated_scan schema, epn_core from the mess_mag_calibrated_cal_lac schema, epn_core from the mess_mag_calibrated_j2k schema, epn_core from the mess_mag_calibrated_j2k_avg schema, epn_core from the mess_mag_calibrated_mbf schema, epn_core from the mess_mag_calibrated_mbf_avg schema, epn_core from the mess_mag_calibrated_mso schema, epn_core from the mess_mag_calibrated_mso_avg schema, epn_core from the mess_mag_calibrated_rtn schema, epn_core from the mess_mag_calibrated_rtn_avg schema, epn_core from the mess_mag_calibrated_sc schema, epn_core from the mess_mag_calibrated_sc_avg schema, epn_core from the mess_mag_calibrated_vso schema, epn_core from the mess_mag_calibrated_vso_avg schema, epn_core from the mess_mag_crustal_field_map schema, epn_core from the mess_mag_kt17_model_residuals_mbf schema, epn_core from the mess_mag_kt17_model_residuals_mso schema, epn_core from the mess_mag_raw_burst_data schema, epn_core from the mess_mag_raw_housekeeping_data schema, epn_core from the mess_mag_raw_housekeeping_header schema, epn_core from the mess_mag_raw_log_ac_data schema, epn_core from the mess_mag_raw_mag_burst_log schema, epn_core from the mess_mag_raw_science_data schema, epn_core from the mess_mag_raw_science_header schema, epn_core from the mess_mag_raw_status_data schema, epn_core from the pvo_ephem_vso_asc schema, epn_core from the pvo_ephem_vso_bin schema, epn_core from the radiojove_aj4co_dps schema, epn_core from the radiojove_aj4co_fs200 schema, epn_core from the radiojove_hnrao_fsx2raw schema, epn_core from the radiojove_hnrao_fsx8sraw schema, epn_core from the radiojove_k4led_fsx11raw schema, epn_core from the radiojove_k4led_sdrlcpraw schema, epn_core from the radiojove_k4led_sdrrcpraw schema, epn_core from the radiojove_mtsu_fsx6sraw schema, columns, groups, key_columns, keys, schemas, tables from the tap_schema schema, epn_core from the vex_aspera4_els_derived schema, epn_core from the vex_aspera4_els_eng schema, epn_core from the vex_aspera4_els_raw schema, epn_core from the vex_cleaned_high_res_mag schema, epn_core from the vg1_mag_jupiter_hgcoords_1_92sec schema, epn_core from the vg1_mag_jupiter_hgcoords_48sec schema, epn_core from the vg1_mag_jupiter_hgcoords_9_60sec schema, epn_core from the vg1_mag_jupiter_s3coords_1_92sec schema, epn_core from the vg1_mag_jupiter_s3coords_48sec schema, epn_core from the vg1_mag_jupiter_s3coords_9_60sec schema, epn_core from the vg1_mag_jupiter_sc_field schema, epn_core from the vg2_mag_jupiter_hgcoords_1_92sec schema, epn_core from the vg2_mag_jupiter_hgcoords_48sec schema, epn_core from the vg2_mag_jupiter_hgcoords_9_60sec schema, epn_core from the vg2_mag_jupiter_s3coords_1_92sec schema, epn_core from the vg2_mag_jupiter_s3coords_48sec schema, epn_core from the vg2_mag_jupiter_s3coords_9_60sec schema, epn_core from the vg2_mag_jupiter_sc_field schema, epn_core from the voyager1_pws_sa schema, epn_core from the voyager1_pws_wf schema, epn_core from the voyager2_pws_sa schema, epn_core from the voyager2_pws_wf schema.

For a list of all services and tables belonging to this service's resource, see Information on resource '__system__/tap'

Service Documentation

This service speaks TAP, a protocol designed to allow the exchange of queries and data between clients (that's normally something running on your computer) and servers (e.g., us).

You will want to use some sort of client to query TAP services; examples for those include:

You can, in a pinch, use our service in an XML-enabled browser, too. Under Overview, look for the bullet point on tap and follow the link to "this service". Then, click on "New job..." in the job list, enter your query, click "Set query", then "Execute query". Reload the page you are redirected to now and then to see when your job is finished, then retrieve the result.

The queries this service executes are written an a dialect of SQL called ADQL. You need to learn it to use this service. See our ADQL tutorial. Also do not miss the local examples.

By the way, for quick ad-hoc queries from within a browser, our ADQL form service may be more convenient than TAP.

Also see the table metadata of the tables exposed here.

Local information: This service may put a much lower limit on uploads in sync queries than advertised in the table metadata. Unfortunately, current TOPCAT versions don't give terribly helpful error messages when the server rejects a query because the attached upload is too large (something like “Error writing request body to server“). If that happens to you, just switch to asynchronous querying (in TOPCAT, that's in the “Mode” combo box just above the query editor).

Issues

For information on our ADQL implementation, see the ADQL service info.

If multiple output columns in a query would end up having the same name, in the output VOTable they are disambiguated by appending underscores. This is in violation of the specification, but since fixing it would require rather intrusive changes into our software and it is not clear why one should want to use names when they are not unique to begin with, this will probably not be fixed.

Overview

You can access this service using:

This service is published as follows:

local means it is listed on our front page, ivo_managed means it has a record in the VO registry.

Input Fields

The following fields are available to provide input to the service (with some renderers, some of these fields may be unavailable):

NameTable Head DescriptionUnitUCD
format Format Deprecated alias of RESPONSEFORMAT N/A N/A
lang Lang A name of a language that QUERY should be parsed as. See capabilities for what you can pass in here. N/A N/A
maxrec Match limit Maximum number of records returned. Pass 0 to retrieve service parameters. N/A N/A
maxrec Match limit Maximum number of records returned. Pass 0 to retrieve service parameters. N/A N/A
query Query The query to be executed. N/A N/A
request Request Type of operation requested; this can be doQuery or getCapabilities. Preferably, don't pass it at all. N/A N/A
responseformat Output Format File format requested for output. N/A meta.code.mime
responseformat Output Format File format requested for output. N/A meta.code.mime
upload Upload A TAP-compliant upload; roughly: (tablename,source-uri), where source-uri can also have a param: scheme. N/A N/A
verb Verbosity Exhaustiveness of column selection. VERB=1 only returns the most important columns, VERB=2 selects the columns deemed useful to the average user, VERB=3 returns a table with all available columns. N/A N/A
verb Verbosity Exhaustiveness of column selection. VERB=1 only returns the most important columns, VERB=2 selects the columns deemed useful to the average user, VERB=3 returns a table with all available columns. N/A N/A
version Version Don't use this parameter. You'll only break stuff. N/A N/A

VOResource XML (that's something exclusively for VO nerds)