Proxima Centauri B / Center Objects - CSV / ESA
Closest Exoplanetary Systems / CSV DATA / First On Kaggle
@kaggle.brsdincer_proxima_centauri_b_center_objects_csv_esa
Closest Exoplanetary Systems / CSV DATA / First On Kaggle
@kaggle.brsdincer_proxima_centauri_b_center_objects_csv_esa
Each csv is unique and represents an object. All objects of center diameter are present.
You can see the names of these objects by looking at the "TARGNAME" column.
Proxima Centauri b (also called Proxima b or Alpha Centauri Cb) is an exoplanet orbiting in the habitable zone of the red dwarf star Proxima Centauri, which is the closest star to the Sun and part of a triple star system. It is approximately 4.2 light-years (4.0×1013 km) from Earth in the constellation Centaurus, making it and Proxima c the closest known exoplanets to the Solar System.
Proxima Centauri b orbits the star at a distance of roughly 0.05 AU (7,500,000 km; 4,600,000 mi) with an orbital period of approximately 11.2 Earth days, and has an estimated mass of at least 1.2 times that of Earth. It is subject to stellar wind pressures of more than 2,000 times those of Earth from the solar wind, and its habitability has not yet been definitively established.
The planet's discovery was announced in August 2016. It was found using the radial velocity method, where periodic Doppler shifts of the parent star's spectral lines suggest an orbiting object. From these readings, the parent star's radial velocity relative to the Earth is varying with an amplitude of about 1.4 metres (4.5 feet) per second. According to Guillem Anglada‐Escudé, the planet's proximity to Earth offers an opportunity for robotic exploration with the Starshot project or, at least, "in the coming centuries".
Without its orbital inclination known, Proxima Centauri b's exact mass is unknown. If its orbit is nearly edge-on, it would have a mass of 1.173±0.086 M⊕ (Earth masses).Statistically, there is a roughly 90% chance that its mass is less than 2.77 M⊕.
In May 2019, a paper presenting recent Spitzer Space Telescope data concluded that Proxima Centauri b did not transit its sun relative to Earth, and attributed previous transit detections to correlated noise
CREATE TABLE data_proxima_136 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"fits_bits_pixel" BIGINT,
"number_of_axes" BIGINT,
"there_maybe_standard_extensions" BOOLEAN,
"real_tape_bscale_bzero" DOUBLE -- REAL \u003d TAPE*BSCALE + BZERO,
"psize_of_original_image" BIGINT,
"fitsio_version_21_feb_1996" VARCHAR,
"date_fits_file_was_created" TIMESTAMP,
"original_filename" VARCHAR,
"data_max_in_all_groups" DOUBLE,
"data_min_in_all_groups" DOUBLE,
"original_datatype_single_precision_real" VARCHAR -- Original Datatype: Single Precision Real,
"number_of_groups_in_original_image" BIGINT,
"data_min" DOUBLE,
"data_max" DOUBLE,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex)
);
CREATE TABLE data_proxima_137 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"fits_bits_pixel" BIGINT,
"number_of_axes" BIGINT,
"there_maybe_standard_extensions" BOOLEAN,
"real_tape_bscale_bzero" DOUBLE -- REAL \u003d TAPE*BSCALE + BZERO,
"psize_of_original_image" BIGINT,
"fitsio_version_21_feb_1996" VARCHAR,
"date_fits_file_was_created" TIMESTAMP,
"original_filename" VARCHAR,
"data_max_in_all_groups" DOUBLE,
"data_min_in_all_groups" DOUBLE,
"original_datatype_16_bits_integer" VARCHAR -- Original Datatype: 16 Bits Integer,
"number_of_groups_in_original_image" BIGINT,
"data_min" DOUBLE,
"data_max" DOUBLE,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex)
);
CREATE TABLE data_proxima_138 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"bits_per_pixel" BIGINT,
"number_of_axes" BIGINT,
"file_may_contain_extensions" BOOLEAN,
"fits_file_originator" VARCHAR,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"number_of_standard_extensions" BIGINT,
"name_of_file" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex),
"bad_data_fill_value_for_calibrated_images" BIGINT,
"commanded_duration_of_exposure_sec" BIGINT -- Commanded Duration Of Exposure (sec),
"number_of_ap17_shutter_b_closes" BIGINT,
"dark_time_seconds" DOUBLE -- Dark Time (seconds),
"major_frame_pulse_time_preceding_exposure_start" BIGINT,
"predicted_obs_start_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Start Time (yyyy.ddd:hh:mm:ss),
"predicted_obs_stop_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Stop Time (yyyy.ddd:hh:mm:ss),
"angle_between_sun_and_v1_axis" DOUBLE
);
CREATE TABLE data_proxima_14 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"bits_per_pixel" BIGINT,
"number_of_axes" BIGINT,
"file_may_contain_extensions" BOOLEAN,
"fits_file_originator" VARCHAR,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"number_of_standard_extensions" BIGINT,
"name_of_file" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex),
"bad_data_fill_value_for_calibrated_images" BIGINT,
"commanded_duration_of_exposure_sec" BIGINT -- Commanded Duration Of Exposure (sec),
"number_of_ap17_shutter_b_closes" BIGINT,
"dark_time_seconds" DOUBLE -- Dark Time (seconds),
"major_frame_pulse_time_preceding_exposure_start" BIGINT,
"predicted_obs_start_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Start Time (yyyy.ddd:hh:mm:ss),
"predicted_obs_stop_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Stop Time (yyyy.ddd:hh:mm:ss),
"angle_between_sun_and_v1_axis" DOUBLE
);
CREATE TABLE data_proxima_140 (
"unnamed_0" BIGINT -- Unnamed: 0,
"conforms_to_fits_standard" BOOLEAN,
"array_data_type" BIGINT,
"number_of_array_dimensions" BIGINT,
"number_of_standard_extensions" BIGINT,
"name_of_file" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"type_of_exposure_identifier" VARCHAR,
"instrument_designated_as_prime" VARCHAR,
"proposer_s_target_name" VARCHAR -- Proposer\u0027s Target Name,
"right_ascension_of_the_target_deg_j2000" DOUBLE -- Right Ascension Of The Target (deg) (J2000),
"declination_of_the_target_deg_j2000" DOUBLE -- Declination Of The Target (deg) (J2000),
"pep_proposal_identifier" BIGINT,
"proposal_logsheet_line_number" DOUBLE,
"last_name_of_principal_investigator" VARCHAR,
"first_name_of_principal_investigator" VARCHAR,
"middle_name_initial_of_principal_investigat" VARCHAR -- Middle Name / Initial Of Principal Investigat,
"angle_between_sun_and_v1_axis" DOUBLE,
"angle_between_moon_and_v1_axis" DOUBLE,
"commanded_fgs_lock_fine_coarse_gyros_unknown" VARCHAR -- Commanded FGS Lock (FINE,COARSE,GYROS,UNKNOWN),
"number_of_gyros_scheduled_t_3_obad" VARCHAR -- Number Of Gyros Scheduled, T\u003d3+OBAD,
"guide_star_catalog_version" VARCHAR,
"moving_target_flag_t_if_it_is_a_moving_target" VARCHAR -- Moving Target Flag; T If It Is A Moving Target,
"ut_date_of_start_of_observation_yyyy_mm_dd" TIMESTAMP -- UT Date Of Start Of Observation (yyyy-mm-dd),
"ut_time_of_start_of_observation_hh_mm_ss" VARCHAR -- UT Time Of Start Of Observation (hh:mm:ss),
"exposure_start_time_modified_julian_date" DOUBLE -- Exposure Start Time (Modified Julian Date),
"exposure_end_time_modified_julian_date" DOUBLE -- Exposure End Time (Modified Julian Date),
"exposure_duration_seconds_calculated" DOUBLE -- Exposure Duration (seconds)--calculated,
"exposure_interruption_indicator" VARCHAR,
"fiducial_pixel_dark_time_secs" DOUBLE -- Fiducial Pixel Dark Time (secs),
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"data_processing_software_system_versi" VARCHAR,
"cloud_infrastructure_package_version" VARCHAR,
"cloud_docker_image_version" VARCHAR,
"calibration_software_system_version_id" VARCHAR,
"calwf3_code_version" VARCHAR,
"observation_type_imaging_or_spectroscopic" VARCHAR -- Observation Type - Imaging Or Spectroscopic,
"operating_mode" VARCHAR,
"type_of_charge_transfer_image_if_applicable" VARCHAR -- Type Of Charge Transfer Image, If Applicable,
"lamp_status_none_or_name_of_lamp_which_is_on" VARCHAR -- Lamp Status, NONE Or Name Of Lamp Which Is On,
"number_of_repeat_exposures_in_set_default_1" BIGINT -- Number Of Repeat Exposures In Set: Default 1,
"data_from_a_subarray_t_or_full_frame_f" BOOLEAN -- Data From A Subarray (T) Or Full Frame (F),
"detector_in_use_uvis_or_ir" VARCHAR -- Detector In Use: UVIS Or IR,
"element_selected_from_filter_wheel" VARCHAR,
"aperture_name" VARCHAR,
"proposed_aperture_name" VARCHAR,
"direct_image_for_grism_or_prism_exposure" VARCHAR,
"cte_measurement_direction_serial_or_parallel" VARCHAR -- CTE Measurement Direction: Serial Or Parallel,
"number_of_cosmic_ray_split_exposures" BIGINT,
"name_of_the_cte_algorithm" VARCHAR,
"version_number_of_the_cte_algorithm" DOUBLE,
"date_of_wfc3_uvis_installation_in_hst_mjd" DOUBLE -- Date Of WFC3/UVIS Installation In HST (MJD),
"reference_date_of_cte_model_pinning_mjd" DOUBLE -- Reference Date Of CTE Model Pinning (MJD),
"maximum_length_of_cte_trail" BIGINT,
"read_noise_amplitude" DOUBLE,
"number_iterations_used_in_cte_forward_modeling" BIGINT,
"number_of_iterations_used_in_parallel_transfer" BIGINT,
"scaling_of_cte_model_relative_to_ctedate1" DOUBLE -- Scaling Of CTE Model (relative To CTEDATE1),
"read_noise_mitigation_algorithm" BIGINT,
"over_subtraction_threshold" DOUBLE,
"fix_readout_cosmic_rays" BIGINT,
"c_bostrophidon_d_c_with_dwell_n_n_a" VARCHAR -- C:bostrophidon; D:C With Dwell; N:N/A,
"scan_width_arcsec" DOUBLE -- Scan Width (arcsec),
"angle_between_sides_of_parallelogram_deg" DOUBLE -- Angle Between Sides Of Parallelogram (deg),
"dwell_pts_line_for_scan_pointing_1_99_0_if_na" BIGINT -- Dwell Pts/line For Scan Pointing (1-99,0 If NA),
"wait_time_duration_at_each_dwell_point_sec" DOUBLE -- Wait Time (duration) At Each Dwell Point (sec),
"position_angle_of_scan_line_deg" DOUBLE -- Position Angle Of Scan Line (deg),
"commanded_rate_of_the_line_scan_arcsec_sec" DOUBLE -- Commanded Rate Of The Line Scan (arcsec/sec),
"number_of_lines_per_scan_1_99_0_if_na" BIGINT -- Number Of Lines Per Scan (1-99,0 If NA),
"scan_length_arcsec" DOUBLE -- Scan Length (arcsec),
"scan_coordinate_frame_of_ref_celestial_vehicle" VARCHAR -- Scan Coordinate Frame Of Ref: Celestial,vehicle,
"channel_select_mechanism_id" VARCHAR,
"write_out_error_array_extension" BOOLEAN,
"data_quality_initialization" VARCHAR,
"correct_for_a_to_d_conversion_errors" VARCHAR,
"subtract_bias_level_computed_from_overscan" VARCHAR,
"subtract_bias_image" VARCHAR,
"post_flash_correction" VARCHAR,
"combine_observations_to_reject_cosmic_rays" VARCHAR,
"process_individual_observations_after_cr_reject" VARCHAR,
"apply_shutter_shading_correction" VARCHAR,
"subtract_dark_image" VARCHAR,
"flat_field_data" VARCHAR,
"cte_correction" VARCHAR,
"populate_photometric_header_keywords" VARCHAR,
"drizzle_processing" VARCHAR,
"scale_uvis2_to_match_uvis1_using_phtratio" VARCHAR,
"bad_pixel_table" VARCHAR,
"detector_calibration_parameters" VARCHAR,
"analog_to_digital_correction_file" VARCHAR,
"detector_overscan_table" VARCHAR,
"bias_image_file_name" VARCHAR,
"post_flash_correction_file_name" VARCHAR,
"cosmic_ray_rejection_parameters" VARCHAR,
"shutter_shading_correction_file" VARCHAR
);
CREATE TABLE data_proxima_141 (
"unnamed_0" BIGINT -- Unnamed: 0,
"data_conform_to_fits_standard" BOOLEAN,
"bits_per_data_value" BIGINT,
"number_of_data_axes" BIGINT,
"file_may_contain_standard_extensions" BOOLEAN,
"number_of_standard_extensions" BIGINT,
"image_is_in_group_format" BOOLEAN,
"date_this_file_was_written_yyyy_mm_dd" TIMESTAMP -- Date This File Was Written (yyyy-mm-dd),
"name_of_file" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"instrument_designated_as_prime" VARCHAR,
"proposer_s_target_name" VARCHAR -- Proposer\u0027s Target Name,
"right_ascension_of_the_target_deg_j2000" DOUBLE -- Right Ascension Of The Target (deg) (J2000),
"declination_of_the_target_deg_j2000" DOUBLE -- Declination Of The Target (deg) (J2000),
"pep_proposal_identifier" BIGINT,
"proposal_logsheet_line_number" DOUBLE,
"last_name_of_principal_investigator" VARCHAR,
"first_name_of_principal_investigator" VARCHAR,
"middle_name_initial_of_principal_investigat" VARCHAR -- Middle Name / Initial Of Principal Investigat,
"ut_date_of_start_of_first_exposure_in_file" TIMESTAMP,
"ut_start_time_of_first_exposure_in_file" VARCHAR,
"start_time_mjd_of_1st_exposure_in_file" DOUBLE -- Start Time (MJD) Of 1st Exposure In File,
"end_time_mjd_of_last_exposure_in_the_file" DOUBLE -- End Time (MJD) Of Last Exposure In The File,
"total_exposure_time_seconds" DOUBLE -- Total Exposure Time (seconds),
"postarg_in_axis_1_direction" DOUBLE,
"postarg_in_axis_2_direction" DOUBLE,
"number_of_science_data_overflows" BIGINT,
"data_processing_software_system_version" VARCHAR,
"calstis_code_version" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"calibration_software_system_version_id" VARCHAR,
"configuration_status_support_avail_eng" VARCHAR -- Configuration Status (support., Avail., Eng.),
"observation_type_imaging_or_spectroscopic" VARCHAR -- Observation Type - Imaging Or Spectroscopic,
"operating_mode" VARCHAR,
"obser" VARCHAR,
"lamp_status_none_or_name_of_lamp_which_is_on" VARCHAR -- Lamp Status, NONE Or Name Of Lamp Which Is On,
"spectral_cal_lamp_current_value_milliamps" DOUBLE -- Spectral Cal Lamp Current Value (milliamps),
"number_of_repeat_exposures_in_set_default_1" BIGINT -- Number Of Repeat Exposures In Set: Default 1,
"data_from_a_subarray_t_or_full_frame_f" BOOLEAN -- Data From A Subarray (T) Or Full Frame (F),
"detector_in_use_nuv_mama_fuv_mama_or_ccd" VARCHAR -- Detector In Use: NUV-MAMA, FUV-MAMA, Or CCD,
"optical_element_in_use" VARCHAR,
"aperture_name" VARCHAR,
"proposed_aperture_name" VARCHAR,
"filter_in_use" VARCHAR,
"aperture_field_of_view" VARCHAR,
"number_of_cosmic_ray_split_exposures" BIGINT,
"ccd_amplifier_read_out_a_b_c_d" VARCHAR -- CCD Amplifier Read Out (A,B,C,D),
"commanded_gain_of_ccd" BIGINT,
"commanded_ccd_bias_offset" BIGINT,
"subarray_axis1_center_pt_in_unbinned_dect_pix" BIGINT -- Subarray Axis1 Center Pt In Unbinned Dect. Pix,
"subarray_axis2_center_pt_in_unbinned_dect_pix" BIGINT -- Subarray Axis2 Center Pt In Unbinned Dect. Pix,
"subarray_axis1_size_in_unbinned_detector_pixels" BIGINT,
"subarray_axis2_size_in_unbinned_detector_pixels" BIGINT,
"axis1_data_bin_size_in_unbinned_detector_pixels" BIGINT,
"axis2_data_bin_size_in_unbinned_detector_pixels" BIGINT,
"inverse_sensitivity_ergs_s_cm2_ang_per_count_s" DOUBLE -- Inverse Sensitivity, Ergs/s/cm2/Ang Per Count/s,
"st_magnitude_zero_point" DOUBLE,
"pivot_wavelength_angstroms" DOUBLE -- Pivot Wavelength (Angstroms),
"rms_bandwidth_of_filter_plus_detector" DOUBLE,
"data_quality_initialization" VARCHAR,
"subtract_bias_level_computed_from_overscan_img" VARCHAR,
"subtract_bias_image" VARCHAR,
"combine_observations_to_reject_cosmic_rays" VARCHAR,
"add_individual_repeat_observations" VARCHAR,
"process_individual_observations_after_cr_reject" VARCHAR,
"subtract_dark_image" VARCHAR,
"flat_field_data" VARCHAR,
"populate_photometric_header_keywords" VARCHAR,
"calculate_statistics" BOOLEAN -- Calculate Statistics?,
"perform_geometric_correction_for_imaging_modes" VARCHAR,
"bad_pixel_table" VARCHAR,
"dark_image_file_name" VARCHAR,
"pixel_to_pixel_flat_field_file_name" VARCHAR,
"low_order_flat" VARCHAR,
"photometric_throughput_table" VARCHAR,
"imaging_photometric_table" VARCHAR,
"relative_aperture_throughput_table" VARCHAR,
"ccd_calibration_parameters" VARCHAR,
"bias_image_file_name" VARCHAR,
"cosmic_ray_rejection_parameters" VARCHAR,
"image_distortion_correction_table" VARCHAR,
"time_dependent_sensitivity_algorithm_used" VARCHAR,
"reference_exposure_time_for_parameters" DOUBLE,
"multiplicative_scale_factor_applied_to_noise" DOUBLE,
"initial_guess_method_min_or_med" VARCHAR -- Initial Guess Method (MIN Or MED),
"sky_value_subtracted_mode_or_none" VARCHAR -- Sky Value Subtracted (MODE Or NONE),
"sky_level_from_the_sum_of_all_constituent_image" DOUBLE,
"statistical_rejection_criteria" VARCHAR,
"rejection_propagation_radius_pixels" DOUBLE -- Rejection Propagation Radius (pixels),
"rejection_propagation_threshold" DOUBLE,
"data_quality_flag_bits_to_reject" BIGINT,
"rate_at_which_pixels_are_affected_by_cosmic_ray" DOUBLE,
"flag_cr_rejected_pixels_in_input_files_t_f" BOOLEAN -- Flag CR-rejected Pixels In Input Files (T/F),
"calibrated_ccd_amplifier_gain_value" DOUBLE,
"calibrated_ccd_read_noise_value" DOUBLE,
"bandwidth_of_the_data" DOUBLE
);
CREATE TABLE data_proxima_142 (
"unnamed_0" BIGINT -- Unnamed: 0,
"conforms_to_fits_standard" BOOLEAN,
"array_data_type" BIGINT,
"number_of_array_dimensions" BIGINT,
"number_of_standard_extensions" BIGINT,
"name_of_file" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"type_of_exposure_identifier" VARCHAR,
"instrument_designated_as_prime" VARCHAR,
"proposer_s_target_name" VARCHAR -- Proposer\u0027s Target Name,
"right_ascension_of_the_target_deg_j2000" DOUBLE -- Right Ascension Of The Target (deg) (J2000),
"declination_of_the_target_deg_j2000" DOUBLE -- Declination Of The Target (deg) (J2000),
"pep_proposal_identifier" BIGINT,
"proposal_logsheet_line_number" DOUBLE,
"last_name_of_principal_investigator" VARCHAR,
"first_name_of_principal_investigator" VARCHAR,
"middle_name_initial_of_principal_investigat" VARCHAR -- Middle Name / Initial Of Principal Investigat,
"angle_between_sun_and_v1_axis" DOUBLE,
"angle_between_moon_and_v1_axis" DOUBLE,
"commanded_fgs_lock_fine_coarse_gyros_unknown" VARCHAR -- Commanded FGS Lock (FINE,COARSE,GYROS,UNKNOWN),
"number_of_gyros_scheduled_t_3_obad" VARCHAR -- Number Of Gyros Scheduled, T\u003d3+OBAD,
"guide_star_catalog_version" VARCHAR,
"moving_target_flag_t_if_it_is_a_moving_target" VARCHAR -- Moving Target Flag; T If It Is A Moving Target,
"ut_date_of_start_of_observation_yyyy_mm_dd" TIMESTAMP -- UT Date Of Start Of Observation (yyyy-mm-dd),
"ut_time_of_start_of_observation_hh_mm_ss" VARCHAR -- UT Time Of Start Of Observation (hh:mm:ss),
"exposure_start_time_modified_julian_date" DOUBLE -- Exposure Start Time (Modified Julian Date),
"exposure_end_time_modified_julian_date" DOUBLE -- Exposure End Time (Modified Julian Date),
"exposure_duration_seconds_calculated" DOUBLE -- Exposure Duration (seconds)--calculated,
"exposure_interruption_indicator" VARCHAR,
"fiducial_pixel_dark_time_secs" DOUBLE -- Fiducial Pixel Dark Time (secs),
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"data_processing_software_system_versi" VARCHAR,
"cloud_infrastructure_package_version" VARCHAR,
"cloud_docker_image_version" VARCHAR,
"calibration_software_system_version_id" VARCHAR,
"calwf3_code_version" VARCHAR,
"observation_type_imaging_or_spectroscopic" VARCHAR -- Observation Type - Imaging Or Spectroscopic,
"operating_mode" VARCHAR,
"type_of_charge_transfer_image_if_applicable" VARCHAR -- Type Of Charge Transfer Image, If Applicable,
"lamp_status_none_or_name_of_lamp_which_is_on" VARCHAR -- Lamp Status, NONE Or Name Of Lamp Which Is On,
"number_of_repeat_exposures_in_set_default_1" BIGINT -- Number Of Repeat Exposures In Set: Default 1,
"data_from_a_subarray_t_or_full_frame_f" BOOLEAN -- Data From A Subarray (T) Or Full Frame (F),
"detector_in_use_uvis_or_ir" VARCHAR -- Detector In Use: UVIS Or IR,
"element_selected_from_filter_wheel" VARCHAR,
"aperture_name" VARCHAR,
"proposed_aperture_name" VARCHAR,
"direct_image_for_grism_or_prism_exposure" VARCHAR,
"cte_measurement_direction_serial_or_parallel" VARCHAR -- CTE Measurement Direction: Serial Or Parallel,
"number_of_cosmic_ray_split_exposures" BIGINT,
"name_of_the_cte_algorithm" VARCHAR,
"version_number_of_the_cte_algorithm" DOUBLE,
"date_of_wfc3_uvis_installation_in_hst_mjd" DOUBLE -- Date Of WFC3/UVIS Installation In HST (MJD),
"reference_date_of_cte_model_pinning_mjd" DOUBLE -- Reference Date Of CTE Model Pinning (MJD),
"maximum_length_of_cte_trail" BIGINT,
"read_noise_amplitude" DOUBLE,
"number_iterations_used_in_cte_forward_modeling" BIGINT,
"number_of_iterations_used_in_parallel_transfer" BIGINT,
"scaling_of_cte_model_relative_to_ctedate1" DOUBLE -- Scaling Of CTE Model (relative To CTEDATE1),
"read_noise_mitigation_algorithm" BIGINT,
"over_subtraction_threshold" DOUBLE,
"fix_readout_cosmic_rays" BIGINT,
"c_bostrophidon_d_c_with_dwell_n_n_a" VARCHAR -- C:bostrophidon; D:C With Dwell; N:N/A,
"scan_width_arcsec" DOUBLE -- Scan Width (arcsec),
"angle_between_sides_of_parallelogram_deg" DOUBLE -- Angle Between Sides Of Parallelogram (deg),
"dwell_pts_line_for_scan_pointing_1_99_0_if_na" BIGINT -- Dwell Pts/line For Scan Pointing (1-99,0 If NA),
"wait_time_duration_at_each_dwell_point_sec" DOUBLE -- Wait Time (duration) At Each Dwell Point (sec),
"position_angle_of_scan_line_deg" DOUBLE -- Position Angle Of Scan Line (deg),
"commanded_rate_of_the_line_scan_arcsec_sec" DOUBLE -- Commanded Rate Of The Line Scan (arcsec/sec),
"number_of_lines_per_scan_1_99_0_if_na" BIGINT -- Number Of Lines Per Scan (1-99,0 If NA),
"scan_length_arcsec" DOUBLE -- Scan Length (arcsec),
"scan_coordinate_frame_of_ref_celestial_vehicle" VARCHAR -- Scan Coordinate Frame Of Ref: Celestial,vehicle,
"channel_select_mechanism_id" VARCHAR,
"write_out_error_array_extension" BOOLEAN,
"data_quality_initialization" VARCHAR,
"correct_for_a_to_d_conversion_errors" VARCHAR,
"subtract_bias_level_computed_from_overscan" VARCHAR,
"subtract_bias_image" VARCHAR,
"post_flash_correction" VARCHAR,
"combine_observations_to_reject_cosmic_rays" VARCHAR,
"process_individual_observations_after_cr_reject" VARCHAR,
"apply_shutter_shading_correction" VARCHAR,
"subtract_dark_image" VARCHAR,
"flat_field_data" VARCHAR,
"cte_correction" VARCHAR,
"populate_photometric_header_keywords" VARCHAR,
"drizzle_processing" VARCHAR,
"scale_uvis2_to_match_uvis1_using_phtratio" VARCHAR,
"bad_pixel_table" VARCHAR,
"detector_calibration_parameters" VARCHAR,
"analog_to_digital_correction_file" VARCHAR,
"detector_overscan_table" VARCHAR,
"bias_image_file_name" VARCHAR,
"post_flash_correction_file_name" VARCHAR,
"cosmic_ray_rejection_parameters" VARCHAR,
"shutter_shading_correction_file" VARCHAR
);
CREATE TABLE data_proxima_143 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"bits_per_pixel" BIGINT,
"number_of_axes" BIGINT,
"file_may_contain_extensions" BOOLEAN,
"fits_file_originator" VARCHAR,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"number_of_standard_extensions" BIGINT,
"name_of_file" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex),
"bad_data_fill_value_for_calibrated_images" BIGINT,
"commanded_duration_of_exposure_sec" BIGINT -- Commanded Duration Of Exposure (sec),
"number_of_ap17_shutter_b_closes" BIGINT,
"dark_time_seconds" DOUBLE -- Dark Time (seconds),
"major_frame_pulse_time_preceding_exposure_start" BIGINT,
"predicted_obs_start_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Start Time (yyyy.ddd:hh:mm:ss),
"predicted_obs_stop_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Stop Time (yyyy.ddd:hh:mm:ss),
"angle_between_sun_and_v1_axis" DOUBLE
);
CREATE TABLE data_proxima_144 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"bits_per_pixel" BIGINT,
"number_of_axes" BIGINT,
"file_may_contain_extensions" BOOLEAN,
"fits_file_originator" VARCHAR,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"number_of_standard_extensions" BIGINT,
"name_of_file" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex),
"bad_data_fill_value_for_calibrated_images" BIGINT,
"commanded_duration_of_exposure_sec" BIGINT -- Commanded Duration Of Exposure (sec),
"number_of_ap17_shutter_b_closes" BIGINT,
"dark_time_seconds" DOUBLE -- Dark Time (seconds),
"major_frame_pulse_time_preceding_exposure_start" BIGINT,
"predicted_obs_start_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Start Time (yyyy.ddd:hh:mm:ss),
"predicted_obs_stop_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Stop Time (yyyy.ddd:hh:mm:ss),
"angle_between_sun_and_v1_axis" DOUBLE
);
CREATE TABLE data_proxima_146 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"bits_per_pixel" BIGINT,
"number_of_axes" BIGINT,
"file_may_contain_extensions" BOOLEAN,
"fits_file_originator" VARCHAR,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"number_of_standard_extensions" BIGINT,
"name_of_file" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex),
"bad_data_fill_value_for_calibrated_images" BIGINT,
"commanded_duration_of_exposure_sec" BIGINT -- Commanded Duration Of Exposure (sec),
"number_of_ap17_shutter_b_closes" BIGINT,
"dark_time_seconds" DOUBLE -- Dark Time (seconds),
"major_frame_pulse_time_preceding_exposure_start" BIGINT,
"predicted_obs_start_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Start Time (yyyy.ddd:hh:mm:ss),
"predicted_obs_stop_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Stop Time (yyyy.ddd:hh:mm:ss),
"angle_between_sun_and_v1_axis" DOUBLE
);
CREATE TABLE data_proxima_147 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"bits_per_pixel" BIGINT,
"number_of_axes" BIGINT,
"file_may_contain_extensions" BOOLEAN,
"fits_file_originator" VARCHAR,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"number_of_standard_extensions" BIGINT,
"name_of_file" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex),
"bad_data_fill_value_for_calibrated_images" BIGINT,
"commanded_duration_of_exposure_sec" BIGINT -- Commanded Duration Of Exposure (sec),
"number_of_ap17_shutter_b_closes" BIGINT,
"dark_time_seconds" DOUBLE -- Dark Time (seconds),
"major_frame_pulse_time_preceding_exposure_start" BIGINT,
"predicted_obs_start_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Start Time (yyyy.ddd:hh:mm:ss),
"predicted_obs_stop_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Stop Time (yyyy.ddd:hh:mm:ss),
"angle_between_sun_and_v1_axis" DOUBLE
);
CREATE TABLE data_proxima_148 (
"unnamed_0" BIGINT -- Unnamed: 0,
"conforms_to_fits_standard" BOOLEAN,
"array_data_type" BIGINT,
"number_of_array_dimensions" BIGINT,
"number_of_standard_extensions" BIGINT,
"name_of_file" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"type_of_exposure_identifier" VARCHAR,
"instrument_designated_as_prime" VARCHAR,
"proposer_s_target_name" VARCHAR -- Proposer\u0027s Target Name,
"right_ascension_of_the_target_deg_j2000" DOUBLE -- Right Ascension Of The Target (deg) (J2000),
"declination_of_the_target_deg_j2000" DOUBLE -- Declination Of The Target (deg) (J2000),
"pep_proposal_identifier" BIGINT,
"proposal_logsheet_line_number" DOUBLE,
"last_name_of_principal_investigator" VARCHAR,
"first_name_of_principal_investigator" VARCHAR,
"middle_name_initial_of_principal_investigat" VARCHAR -- Middle Name / Initial Of Principal Investigat,
"angle_between_sun_and_v1_axis" DOUBLE,
"angle_between_moon_and_v1_axis" DOUBLE,
"commanded_fgs_lock_fine_coarse_gyros_unknown" VARCHAR -- Commanded FGS Lock (FINE,COARSE,GYROS,UNKNOWN),
"number_of_gyros_scheduled_t_3_obad" VARCHAR -- Number Of Gyros Scheduled, T\u003d3+OBAD,
"guide_star_catalog_version" VARCHAR,
"moving_target_flag_t_if_it_is_a_moving_target" VARCHAR -- Moving Target Flag; T If It Is A Moving Target,
"ut_date_of_start_of_observation_yyyy_mm_dd" TIMESTAMP -- UT Date Of Start Of Observation (yyyy-mm-dd),
"ut_time_of_start_of_observation_hh_mm_ss" VARCHAR -- UT Time Of Start Of Observation (hh:mm:ss),
"exposure_start_time_modified_julian_date" DOUBLE -- Exposure Start Time (Modified Julian Date),
"exposure_end_time_modified_julian_date" DOUBLE -- Exposure End Time (Modified Julian Date),
"exposure_duration_seconds_calculated" DOUBLE -- Exposure Duration (seconds)--calculated,
"exposure_interruption_indicator" VARCHAR,
"fiducial_pixel_dark_time_secs" DOUBLE -- Fiducial Pixel Dark Time (secs),
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"data_processing_software_system_versi" VARCHAR,
"cloud_infrastructure_package_version" VARCHAR,
"cloud_docker_image_version" VARCHAR,
"calibration_software_system_version_id" VARCHAR,
"calwf3_code_version" VARCHAR,
"observation_type_imaging_or_spectroscopic" VARCHAR -- Observation Type - Imaging Or Spectroscopic,
"operating_mode" VARCHAR,
"type_of_charge_transfer_image_if_applicable" VARCHAR -- Type Of Charge Transfer Image, If Applicable,
"lamp_status_none_or_name_of_lamp_which_is_on" VARCHAR -- Lamp Status, NONE Or Name Of Lamp Which Is On,
"number_of_repeat_exposures_in_set_default_1" BIGINT -- Number Of Repeat Exposures In Set: Default 1,
"data_from_a_subarray_t_or_full_frame_f" BOOLEAN -- Data From A Subarray (T) Or Full Frame (F),
"detector_in_use_uvis_or_ir" VARCHAR -- Detector In Use: UVIS Or IR,
"element_selected_from_filter_wheel" VARCHAR,
"aperture_name" VARCHAR,
"proposed_aperture_name" VARCHAR,
"direct_image_for_grism_or_prism_exposure" VARCHAR,
"cte_measurement_direction_serial_or_parallel" VARCHAR -- CTE Measurement Direction: Serial Or Parallel,
"number_of_cosmic_ray_split_exposures" BIGINT,
"name_of_the_cte_algorithm" VARCHAR,
"version_number_of_the_cte_algorithm" DOUBLE,
"date_of_wfc3_uvis_installation_in_hst_mjd" DOUBLE -- Date Of WFC3/UVIS Installation In HST (MJD),
"reference_date_of_cte_model_pinning_mjd" DOUBLE -- Reference Date Of CTE Model Pinning (MJD),
"maximum_length_of_cte_trail" BIGINT,
"read_noise_amplitude" DOUBLE,
"number_iterations_used_in_cte_forward_modeling" BIGINT,
"number_of_iterations_used_in_parallel_transfer" BIGINT,
"scaling_of_cte_model_relative_to_ctedate1" DOUBLE -- Scaling Of CTE Model (relative To CTEDATE1),
"read_noise_mitigation_algorithm" BIGINT,
"over_subtraction_threshold" DOUBLE,
"fix_readout_cosmic_rays" BIGINT,
"c_bostrophidon_d_c_with_dwell_n_n_a" VARCHAR -- C:bostrophidon; D:C With Dwell; N:N/A,
"scan_width_arcsec" DOUBLE -- Scan Width (arcsec),
"angle_between_sides_of_parallelogram_deg" DOUBLE -- Angle Between Sides Of Parallelogram (deg),
"dwell_pts_line_for_scan_pointing_1_99_0_if_na" BIGINT -- Dwell Pts/line For Scan Pointing (1-99,0 If NA),
"wait_time_duration_at_each_dwell_point_sec" DOUBLE -- Wait Time (duration) At Each Dwell Point (sec),
"position_angle_of_scan_line_deg" DOUBLE -- Position Angle Of Scan Line (deg),
"commanded_rate_of_the_line_scan_arcsec_sec" DOUBLE -- Commanded Rate Of The Line Scan (arcsec/sec),
"number_of_lines_per_scan_1_99_0_if_na" BIGINT -- Number Of Lines Per Scan (1-99,0 If NA),
"scan_length_arcsec" DOUBLE -- Scan Length (arcsec),
"scan_coordinate_frame_of_ref_celestial_vehicle" VARCHAR -- Scan Coordinate Frame Of Ref: Celestial,vehicle,
"channel_select_mechanism_id" VARCHAR,
"write_out_error_array_extension" BOOLEAN,
"data_quality_initialization" VARCHAR,
"correct_for_a_to_d_conversion_errors" VARCHAR,
"subtract_bias_level_computed_from_overscan" VARCHAR,
"subtract_bias_image" VARCHAR,
"post_flash_correction" VARCHAR,
"combine_observations_to_reject_cosmic_rays" VARCHAR,
"process_individual_observations_after_cr_reject" VARCHAR,
"apply_shutter_shading_correction" VARCHAR,
"subtract_dark_image" VARCHAR,
"flat_field_data" VARCHAR,
"cte_correction" VARCHAR,
"populate_photometric_header_keywords" VARCHAR,
"drizzle_processing" VARCHAR,
"scale_uvis2_to_match_uvis1_using_phtratio" VARCHAR,
"bad_pixel_table" VARCHAR,
"detector_calibration_parameters" VARCHAR,
"analog_to_digital_correction_file" VARCHAR,
"detector_overscan_table" VARCHAR,
"bias_image_file_name" VARCHAR,
"post_flash_correction_file_name" VARCHAR,
"cosmic_ray_rejection_parameters" VARCHAR,
"shutter_shading_correction_file" VARCHAR
);
CREATE TABLE data_proxima_149 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"fits_bits_pixel" BIGINT,
"number_of_axes" BIGINT,
"there_maybe_standard_extensions" BOOLEAN,
"real_tape_bscale_bzero" DOUBLE -- REAL \u003d TAPE*BSCALE + BZERO,
"psize_of_original_image" BIGINT,
"fitsio_version_21_feb_1996" VARCHAR,
"date_fits_file_was_created" TIMESTAMP,
"original_filename" VARCHAR,
"data_max_in_all_groups" DOUBLE,
"data_min_in_all_groups" DOUBLE,
"original_datatype_single_precision_real" VARCHAR -- Original Datatype: Single Precision Real,
"number_of_groups_in_original_image" BIGINT,
"data_min" DOUBLE,
"data_max" DOUBLE,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex)
);
CREATE TABLE data_proxima_15 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"bits_per_pixel" BIGINT,
"number_of_axes" BIGINT,
"file_may_contain_extensions" BOOLEAN,
"fits_file_originator" VARCHAR,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"number_of_standard_extensions" BIGINT,
"name_of_file" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex),
"bad_data_fill_value_for_calibrated_images" BIGINT,
"commanded_duration_of_exposure_sec" BIGINT -- Commanded Duration Of Exposure (sec),
"number_of_ap17_shutter_b_closes" BIGINT,
"dark_time_seconds" DOUBLE -- Dark Time (seconds),
"major_frame_pulse_time_preceding_exposure_start" BIGINT,
"predicted_obs_start_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Start Time (yyyy.ddd:hh:mm:ss),
"predicted_obs_stop_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Stop Time (yyyy.ddd:hh:mm:ss),
"angle_between_sun_and_v1_axis" DOUBLE
);
CREATE TABLE data_proxima_155 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"fits_bits_pixel" BIGINT,
"number_of_axes" BIGINT,
"there_maybe_standard_extensions" BOOLEAN,
"real_tape_bscale_bzero" DOUBLE -- REAL \u003d TAPE*BSCALE + BZERO,
"psize_of_original_image" BIGINT,
"fitsio_version_21_feb_1996" VARCHAR,
"date_fits_file_was_created" TIMESTAMP,
"original_filename" VARCHAR,
"data_max_in_all_groups" DOUBLE,
"data_min_in_all_groups" DOUBLE,
"original_datatype_single_precision_real" VARCHAR -- Original Datatype: Single Precision Real,
"number_of_groups_in_original_image" BIGINT,
"data_min" DOUBLE,
"data_max" DOUBLE,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex)
);
CREATE TABLE data_proxima_158 (
"unnamed_0" BIGINT -- Unnamed: 0,
"conforms_to_fits_standard" BOOLEAN,
"array_data_type" BIGINT,
"number_of_array_dimensions" BIGINT,
"number_of_standard_extensions" BIGINT,
"name_of_file" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"type_of_exposure_identifier" VARCHAR,
"instrument_designated_as_prime" VARCHAR,
"proposer_s_target_name" VARCHAR -- Proposer\u0027s Target Name,
"right_ascension_of_the_target_deg_j2000" DOUBLE -- Right Ascension Of The Target (deg) (J2000),
"declination_of_the_target_deg_j2000" DOUBLE -- Declination Of The Target (deg) (J2000),
"pep_proposal_identifier" BIGINT,
"proposal_logsheet_line_number" DOUBLE,
"last_name_of_principal_investigator" VARCHAR,
"first_name_of_principal_investigator" VARCHAR,
"middle_name_initial_of_principal_investigat" VARCHAR -- Middle Name / Initial Of Principal Investigat,
"angle_between_sun_and_v1_axis" DOUBLE,
"angle_between_moon_and_v1_axis" DOUBLE,
"commanded_fgs_lock_fine_coarse_gyros_unknown" VARCHAR -- Commanded FGS Lock (FINE,COARSE,GYROS,UNKNOWN),
"number_of_gyros_scheduled_t_3_obad" VARCHAR -- Number Of Gyros Scheduled, T\u003d3+OBAD,
"guide_star_catalog_version" VARCHAR,
"moving_target_flag_t_if_it_is_a_moving_target" VARCHAR -- Moving Target Flag; T If It Is A Moving Target,
"ut_date_of_start_of_observation_yyyy_mm_dd" TIMESTAMP -- UT Date Of Start Of Observation (yyyy-mm-dd),
"ut_time_of_start_of_observation_hh_mm_ss" VARCHAR -- UT Time Of Start Of Observation (hh:mm:ss),
"exposure_start_time_modified_julian_date" DOUBLE -- Exposure Start Time (Modified Julian Date),
"exposure_end_time_modified_julian_date" DOUBLE -- Exposure End Time (Modified Julian Date),
"exposure_duration_seconds_calculated" DOUBLE -- Exposure Duration (seconds)--calculated,
"exposure_interruption_indicator" VARCHAR,
"fiducial_pixel_dark_time_secs" DOUBLE -- Fiducial Pixel Dark Time (secs),
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"data_processing_software_system_versi" VARCHAR,
"cloud_infrastructure_package_version" VARCHAR,
"cloud_docker_image_version" VARCHAR,
"calibration_software_system_version_id" VARCHAR,
"calwf3_code_version" VARCHAR,
"observation_type_imaging_or_spectroscopic" VARCHAR -- Observation Type - Imaging Or Spectroscopic,
"operating_mode" VARCHAR,
"type_of_charge_transfer_image_if_applicable" VARCHAR -- Type Of Charge Transfer Image, If Applicable,
"lamp_status_none_or_name_of_lamp_which_is_on" VARCHAR -- Lamp Status, NONE Or Name Of Lamp Which Is On,
"number_of_repeat_exposures_in_set_default_1" BIGINT -- Number Of Repeat Exposures In Set: Default 1,
"data_from_a_subarray_t_or_full_frame_f" BOOLEAN -- Data From A Subarray (T) Or Full Frame (F),
"detector_in_use_uvis_or_ir" VARCHAR -- Detector In Use: UVIS Or IR,
"element_selected_from_filter_wheel" VARCHAR,
"aperture_name" VARCHAR,
"proposed_aperture_name" VARCHAR,
"direct_image_for_grism_or_prism_exposure" VARCHAR,
"cte_measurement_direction_serial_or_parallel" VARCHAR -- CTE Measurement Direction: Serial Or Parallel,
"number_of_cosmic_ray_split_exposures" BIGINT,
"name_of_the_cte_algorithm" VARCHAR,
"version_number_of_the_cte_algorithm" DOUBLE,
"date_of_wfc3_uvis_installation_in_hst_mjd" DOUBLE -- Date Of WFC3/UVIS Installation In HST (MJD),
"reference_date_of_cte_model_pinning_mjd" DOUBLE -- Reference Date Of CTE Model Pinning (MJD),
"maximum_length_of_cte_trail" BIGINT,
"read_noise_amplitude" DOUBLE,
"number_iterations_used_in_cte_forward_modeling" BIGINT,
"number_of_iterations_used_in_parallel_transfer" BIGINT,
"scaling_of_cte_model_relative_to_ctedate1" DOUBLE -- Scaling Of CTE Model (relative To CTEDATE1),
"read_noise_mitigation_algorithm" BIGINT,
"over_subtraction_threshold" DOUBLE,
"fix_readout_cosmic_rays" BIGINT,
"c_bostrophidon_d_c_with_dwell_n_n_a" VARCHAR -- C:bostrophidon; D:C With Dwell; N:N/A,
"scan_width_arcsec" DOUBLE -- Scan Width (arcsec),
"angle_between_sides_of_parallelogram_deg" DOUBLE -- Angle Between Sides Of Parallelogram (deg),
"dwell_pts_line_for_scan_pointing_1_99_0_if_na" BIGINT -- Dwell Pts/line For Scan Pointing (1-99,0 If NA),
"wait_time_duration_at_each_dwell_point_sec" DOUBLE -- Wait Time (duration) At Each Dwell Point (sec),
"position_angle_of_scan_line_deg" DOUBLE -- Position Angle Of Scan Line (deg),
"commanded_rate_of_the_line_scan_arcsec_sec" DOUBLE -- Commanded Rate Of The Line Scan (arcsec/sec),
"number_of_lines_per_scan_1_99_0_if_na" BIGINT -- Number Of Lines Per Scan (1-99,0 If NA),
"scan_length_arcsec" DOUBLE -- Scan Length (arcsec),
"scan_coordinate_frame_of_ref_celestial_vehicle" VARCHAR -- Scan Coordinate Frame Of Ref: Celestial,vehicle,
"channel_select_mechanism_id" VARCHAR,
"write_out_error_array_extension" BOOLEAN,
"data_quality_initialization" VARCHAR,
"correct_for_a_to_d_conversion_errors" VARCHAR,
"subtract_bias_level_computed_from_overscan" VARCHAR,
"subtract_bias_image" VARCHAR,
"post_flash_correction" VARCHAR,
"combine_observations_to_reject_cosmic_rays" VARCHAR,
"process_individual_observations_after_cr_reject" VARCHAR,
"apply_shutter_shading_correction" VARCHAR,
"subtract_dark_image" VARCHAR,
"flat_field_data" VARCHAR,
"cte_correction" VARCHAR,
"populate_photometric_header_keywords" VARCHAR,
"drizzle_processing" VARCHAR,
"scale_uvis2_to_match_uvis1_using_phtratio" VARCHAR,
"bad_pixel_table" VARCHAR,
"detector_calibration_parameters" VARCHAR,
"analog_to_digital_correction_file" VARCHAR,
"detector_overscan_table" VARCHAR,
"bias_image_file_name" VARCHAR,
"post_flash_correction_file_name" VARCHAR,
"cosmic_ray_rejection_parameters" VARCHAR,
"shutter_shading_correction_file" VARCHAR
);
CREATE TABLE data_proxima_159 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"fits_bits_pixel" BIGINT,
"number_of_axes" BIGINT,
"there_maybe_standard_extensions" BOOLEAN,
"real_tape_bscale_bzero" DOUBLE -- REAL \u003d TAPE*BSCALE + BZERO,
"psize_of_original_image" BIGINT,
"fitsio_version_21_feb_1996" VARCHAR,
"date_fits_file_was_created" TIMESTAMP,
"original_filename" VARCHAR,
"data_max_in_all_groups" DOUBLE,
"data_min_in_all_groups" DOUBLE,
"original_datatype_16_bits_integer" VARCHAR -- Original Datatype: 16 Bits Integer,
"number_of_groups_in_original_image" BIGINT,
"data_min" DOUBLE,
"data_max" DOUBLE,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex)
);
CREATE TABLE data_proxima_16 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"fits_bits_pixel" BIGINT,
"number_of_axes" BIGINT,
"there_maybe_standard_extensions" BOOLEAN,
"real_tape_bscale_bzero" DOUBLE -- REAL \u003d TAPE*BSCALE + BZERO,
"psize_of_original_image" BIGINT,
"fitsio_version_21_feb_1996" VARCHAR,
"date_fits_file_was_created" TIMESTAMP,
"original_filename" VARCHAR,
"data_max_in_all_groups" DOUBLE,
"data_min_in_all_groups" DOUBLE,
"original_datatype_16_bits_integer" VARCHAR -- Original Datatype: 16 Bits Integer,
"number_of_groups_in_original_image" BIGINT,
"data_min" DOUBLE,
"data_max" DOUBLE,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex)
);
CREATE TABLE data_proxima_160 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"fits_bits_pixel" BIGINT,
"number_of_axes" BIGINT,
"there_maybe_standard_extensions" BOOLEAN,
"real_tape_bscale_bzero" DOUBLE -- REAL \u003d TAPE*BSCALE + BZERO,
"psize_of_original_image" BIGINT,
"fitsio_version_21_feb_1996" VARCHAR,
"date_fits_file_was_created" TIMESTAMP,
"original_filename" VARCHAR,
"data_max_in_all_groups" DOUBLE,
"data_min_in_all_groups" DOUBLE,
"original_datatype_16_bits_integer" VARCHAR -- Original Datatype: 16 Bits Integer,
"number_of_groups_in_original_image" BIGINT,
"data_min" DOUBLE,
"data_max" DOUBLE,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex)
);
CREATE TABLE data_proxima_161 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"bits_per_pixel" BIGINT,
"number_of_axes" BIGINT,
"file_may_contain_extensions" BOOLEAN,
"fits_file_originator" VARCHAR,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"number_of_standard_extensions" BIGINT,
"name_of_file" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex),
"bad_data_fill_value_for_calibrated_images" BIGINT,
"commanded_duration_of_exposure_sec" BIGINT -- Commanded Duration Of Exposure (sec),
"number_of_ap17_shutter_b_closes" BIGINT,
"dark_time_seconds" DOUBLE -- Dark Time (seconds),
"major_frame_pulse_time_preceding_exposure_start" BIGINT,
"predicted_obs_start_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Start Time (yyyy.ddd:hh:mm:ss),
"predicted_obs_stop_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Stop Time (yyyy.ddd:hh:mm:ss),
"angle_between_sun_and_v1_axis" DOUBLE
);
CREATE TABLE data_proxima_162 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"fits_bits_pixel" BIGINT,
"number_of_axes" BIGINT,
"there_maybe_standard_extensions" BOOLEAN,
"real_tape_bscale_bzero" DOUBLE -- REAL \u003d TAPE*BSCALE + BZERO,
"psize_of_original_image" BIGINT,
"fitsio_version_21_feb_1996" VARCHAR,
"date_fits_file_was_created" TIMESTAMP,
"original_filename" VARCHAR,
"data_max_in_all_groups" DOUBLE,
"data_min_in_all_groups" DOUBLE,
"original_datatype_single_precision_real" VARCHAR -- Original Datatype: Single Precision Real,
"number_of_groups_in_original_image" BIGINT,
"data_min" DOUBLE,
"data_max" DOUBLE,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex)
);
CREATE TABLE data_proxima_164 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"fits_bits_pixel" BIGINT,
"number_of_axes" BIGINT,
"there_maybe_standard_extensions" BOOLEAN,
"real_tape_bscale_bzero" DOUBLE -- REAL \u003d TAPE*BSCALE + BZERO,
"psize_of_original_image" BIGINT,
"fitsio_version_21_feb_1996" VARCHAR,
"date_fits_file_was_created" TIMESTAMP,
"original_filename" VARCHAR,
"data_max_in_all_groups" DOUBLE,
"data_min_in_all_groups" DOUBLE,
"original_datatype_single_precision_real" VARCHAR -- Original Datatype: Single Precision Real,
"number_of_groups_in_original_image" BIGINT,
"data_min" DOUBLE,
"data_max" DOUBLE,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex)
);
CREATE TABLE data_proxima_165 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"fits_bits_pixel" BIGINT,
"number_of_axes" BIGINT,
"there_maybe_standard_extensions" BOOLEAN,
"real_tape_bscale_bzero" DOUBLE -- REAL \u003d TAPE*BSCALE + BZERO,
"psize_of_original_image" BIGINT,
"fitsio_version_21_feb_1996" VARCHAR,
"date_fits_file_was_created" TIMESTAMP,
"original_filename" VARCHAR,
"data_max_in_all_groups" DOUBLE,
"data_min_in_all_groups" DOUBLE,
"original_datatype_single_precision_real" VARCHAR -- Original Datatype: Single Precision Real,
"number_of_groups_in_original_image" BIGINT,
"data_min" DOUBLE,
"data_max" DOUBLE,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex)
);
CREATE TABLE data_proxima_166 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"fits_bits_pixel" BIGINT,
"number_of_axes" BIGINT,
"there_maybe_standard_extensions" BOOLEAN,
"real_tape_bscale_bzero" DOUBLE -- REAL \u003d TAPE*BSCALE + BZERO,
"psize_of_original_image" BIGINT,
"fitsio_version_21_feb_1996" VARCHAR,
"date_fits_file_was_created" TIMESTAMP,
"original_filename" VARCHAR,
"data_max_in_all_groups" DOUBLE,
"data_min_in_all_groups" DOUBLE,
"original_datatype_single_precision_real" VARCHAR -- Original Datatype: Single Precision Real,
"number_of_groups_in_original_image" BIGINT,
"data_min" DOUBLE,
"data_max" DOUBLE,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex)
);
CREATE TABLE data_proxima_167 (
"unnamed_0" BIGINT -- Unnamed: 0,
"fits_standard" BOOLEAN,
"bits_per_pixel" BIGINT,
"number_of_axes" BIGINT,
"file_may_contain_extensions" BOOLEAN,
"fits_file_originator" VARCHAR,
"date_fits_file_was_generated" TIMESTAMP,
"time_of_last_modification" VARCHAR,
"number_of_standard_extensions" BIGINT,
"name_of_file" VARCHAR,
"type_of_data_found_in_data_file" VARCHAR,
"telescope_used_to_acquire_data" VARCHAR,
"identifier_for_instrument_used_to_acquire_data" VARCHAR,
"equinox_of_celestial_coord_system" DOUBLE -- Equinox Of Celestial Coord. System,
"rootname_of_the_observation_set" VARCHAR,
"pipeline_processing_time_mjd" DOUBLE -- Pipeline Processing Time (MJD),
"opus_software_system_version_number" VARCHAR,
"calwp2_code_version" VARCHAR,
"instr_mode_full_full_res_area_area_int" VARCHAR -- Instr. Mode: FULL (full Res.), AREA (area Int.),
"serial_clocks_on_off" VARCHAR -- Serial Clocks: ON, OFF,
"dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
"generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
"packet_format_code" BIGINT,
"first_filter_name" VARCHAR,
"second_filter_name" VARCHAR,
"first_filter_number_0_48" BIGINT -- First Filter Number (0-48),
"second_filter_number_0_48" BIGINT -- Second Filter Number (0-48),
"partial_filter_rotation_angle_degrees" DOUBLE -- Partial Filter Rotation Angle (degrees),
"linear_ramp_filter_wavelength" DOUBLE,
"bandwidth_of_the_filter" DOUBLE,
"central_wavelength_of_the_filter" DOUBLE,
"tec_cold_junction_1_temperature_celsius" DOUBLE -- TEC Cold Junction #1 Temperature (Celsius),
"tec_cold_junction_2_temperature_celsius" DOUBLE -- TEC Cold Junction #2 Temperature (Celsius),
"tec_cold_junction_3_temperature_celsius" DOUBLE -- TEC Cold Junction #3 Temperature (Celsius),
"tec_cold_junction_4_temperature_celsius" DOUBLE -- TEC Cold Junction #4 Temperature (Celsius),
"bay_3_a1_temperature_deg_c" DOUBLE -- Bay 3 A1 Temperature (deg C),
"status_of_kelsall_spot_lamps_on_off" VARCHAR -- Status Of Kelsall Spot Lamps: ON, OFF,
"shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
"analog_to_digital_gain_electrons_dn" DOUBLE -- Analog To Digital Gain (Electrons/DN),
"do_mask_correction_perform_omit_complete" VARCHAR -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
"do_a_to_d_correction_perform_omit_complete" VARCHAR -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
"correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
"do_bias_level_correction" VARCHAR,
"do_bias_correction_perform_omit_complete" VARCHAR -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
"do_dark_correction_perform_omit_complete" VARCHAR -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
"do_flat_field_correction" VARCHAR,
"do_shaded_shutter_correction" VARCHAR,
"output_saturated_pixel_map" VARCHAR,
"fill_photometry_keywords" VARCHAR,
"make_histograms_perform_omit_complete" VARCHAR -- Make Histograms: PERFORM, OMIT, COMPLETE,
"drizzle_processing" VARCHAR,
"output_image_datatype_real_long_short" VARCHAR -- Output Image Datatype: REAL, LONG, SHORT,
"name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
"name_of_the_a_to_d_conversion_file" VARCHAR,
"name_of_the_wf4_correction_reference_file" VARCHAR,
"engineering_file_with_extended_register_da" VARCHAR,
"engineering_file_dqf" VARCHAR,
"name_of_the_bias_frame_reference_file" VARCHAR,
"name_of_the_bias_frame_reference_dqf" VARCHAR,
"name_of_the_dark_reference_file" VARCHAR,
"name_of_the_dark_reference_dqf" VARCHAR,
"name_of_the_flat_field_reference_file" VARCHAR,
"name_of_the_flat_field_reference_dqf" VARCHAR,
"name_of_the_reference_file_for_shutter_sha" VARCHAR,
"name_of_the_photometry_calibration_table" VARCHAR,
"the_hst_graph_table" VARCHAR,
"the_hst_components_table" VARCHAR,
"distortion_correction_table" VARCHAR,
"drift_correction_table" VARCHAR,
"distortion_correction_image" VARCHAR,
"data_value_at_which_saturation_occurs" BIGINT,
"scale_factor_for_output_image" DOUBLE,
"zero_point_for_output_image" DOUBLE,
"length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
"position_angle_of_v3_axis_of_hst_deg" DOUBLE -- Position Angle Of V3-axis Of HST (deg),
"right_ascension_of_the_sun_deg" DOUBLE -- Right Ascension Of The Sun (deg),
"declination_of_the_sun_deg" DOUBLE -- Declination Of The Sun (deg),
"equinox_of_the_sun" DOUBLE,
"moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN -- Moving Target Flag; T If It Is A Moving Target,
"equatorial_radius_of_target_km" DOUBLE -- Equatorial Radius Of Target (km),
"flattening_of_target" DOUBLE,
"north_pole_declination_of_target_deg" DOUBLE -- North Pole Declination Of Target (deg),
"north_pole_right_ascension_of_target_deg" DOUBLE -- North Pole Right Ascension Of Target (deg),
"rotation_rate_of_target" DOUBLE,
"longitude_of_prime_meridian_deg" DOUBLE -- Longitude Of Prime Meridian (deg),
"epoch_of_longitude_of_prime_meridian_sec" DOUBLE -- Epoch Of Longitude Of Prime Meridian (sec),
"surface_feature_latitude_deg" DOUBLE -- Surface Feature Latitude (deg),
"surface_feature_longitude_deg" DOUBLE -- Surface Feature Longitude (deg),
"surface_feature_altitude_km" DOUBLE -- Surface Feature Altitude (km),
"n_0_no_podps_fill_1_podps_fill_present" BIGINT -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
"n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
"st_dcf_fill_pattern_hex" VARCHAR -- St Dcf Fill Pattern (hex),
"bad_data_fill_value_for_calibrated_images" BIGINT,
"commanded_duration_of_exposure_sec" BIGINT -- Commanded Duration Of Exposure (sec),
"number_of_ap17_shutter_b_closes" BIGINT,
"dark_time_seconds" DOUBLE -- Dark Time (seconds),
"major_frame_pulse_time_preceding_exposure_start" BIGINT,
"predicted_obs_start_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Start Time (yyyy.ddd:hh:mm:ss),
"predicted_obs_stop_time_yyyy_ddd_hh_mm_ss" VARCHAR -- Predicted Obs. Stop Time (yyyy.ddd:hh:mm:ss),
"angle_between_sun_and_v1_axis" DOUBLE
);
Anyone who has the link will be able to view this.