[ English | Japanese ]
Searchable Data with the DARTS/Astro Query System
Schema of Tables about Bisei Spaceguard Center (BSGC)
| Satelite/Project | Abstract of the data product | Database table name | Number of entries in the database | Searhcable with Basic Search | Searchable with SQL/ADQL Search |
|---|---|---|---|---|---|
| BSGC | Observation data list of the Bisei Spacegurd Center (BSGC). | bsgc_data | 322,449 | Yes | Yes |
bsgc_data
Observation data list of the Bisei Spacegurd Center (BSGC). The archive data of Bisei Spaceguard Center at DARTS are mainly astronomical data such as asteroids approaching to Earth. The data are taken using the 25 cm telescope at BSGC during the period from June 2000 through September 2002 and the 1 m telescope at BSGC during the period from Mar 2007 through Mar 2017. Please see BSGC data document for more details.
| No. | Column Name | Type | Unit | Description |
|---|---|---|---|---|
| 1 | observation_id | character varying(50) | ID specified by DARTS. Data observed continuously about time and area have the same ID. |
|
| 2 | ql_image_url | character varying(255) | URL of the quick look imags | |
| 3 | data_access_url | character varying(255) | URL of the data file | |
| 4 | tracking_type | character varying(30) | Tracking method There are two ways, but they are not strictly different. |
|
| 5 | target_coordinate | character varying(13) | Center coordinate of chip b2 or g3, HHMMSS[n or s]DDMM format. (n=north, means DEC is +, s=south, means DEC is -) |
|
| 6 | target_from_dirname | character varying(30) | Target name in the directory name. | |
| 7 | date_from_dirname | date | Observation date in the directory name. | |
| 8 | date_from_filename | date | UTC | Observation date in the file name. b1, b2, b3, g1, g2, g3, or g4. |
| 9 | ccd_id | character varying(10) | CCD chip number in the file name. | |
| 10 | neo_temporary_designation | character varying(120) | Near-Earth Object temporary designation | |
| 11 | provisional_designation | character varying(120) | Asteroid's provisional designation | |
| 12 | minor_planet_number | integer | Asteroid's number | |
| 13 | commet_iau_designation | character varying(30) | Commet's IAU Designation | |
| 14 | periodic_commet_number | character varying(10) | Periodic Comet Number | |
| 15 | object_name | character varying(50) | Target Name | |
| 16 | observation_start_time | timestamp without time zone | UTC | Observation start time [UTC] |
| 17 | observation_start_time_mjd | double precision | MJD | Observation start time [MJD] |
| 18 | observation_end_time | timestamp without time zone | UTC | Observation end time [UTC] |
| 19 | observation_end_time_mjd | double precision | MJD | Observation end time [MJD] |
| 20 | exposure_sec | double precision | seconds | Exposure time [seconds] |
| 21 | exposure | double precision | ksec | Exposure time [ksec] |
| 22 | center_ra_hms | character varying(12) | hh:mm:ss.ss | Nominal center J2000 RA [hh:mm:ss.ss] |
| 23 | center_dec_dms | character varying(12) | ±dd:mm:ss.s | Nominal center J2000 Dec [±dd:mm:ss.s] |
| 24 | center_ra | double precision | degree | Nominal center J2000 RA [degree] |
| 25 | center_dec | double precision | degree | Nominal center J2000 Dec [degree] |
| 26 | center_ra_b1950 | double precision | degree | Nominal center B1950 RA [degree] |
| 27 | center_dec_b1950 | double precision | degree | Nominal center B1950 Dec [degree] |
| 28 | center_ecliptic_lon | double precision | degree | Nominal center ecliptic longitude [degree] |
| 29 | center_ecliptic_lat | double precision | degree | Nominal center ecliptic latitude [degree] |
| 30 | center_galactic_lon | double precision | degree | Nominal center galactic longitude [degree] |
| 31 | center_galactic_lat | double precision | degree | Nominal center galactic latitude [degree] |
| 32 | position_angle | character varying(10) | ±ddd:mm:ss | Position angle, degrees, +W [dd:mm:ss] |
| 33 | elevation | double precision | degree | Degrees above horizon [degree] |
| 34 | azimuth | double precision | degree | Degrees E of N [degree] |
| 35 | local_hour_angle | character varying(12) | ±hh:mm:ss.ss | Local hour angle [hh:mm:ss.ss] |
| 36 | telescope | character varying(50) | Telescope name | |
| 37 | instrument | character varying(30) | Camera name | |
| 38 | filter_code | character varying(10) | Filter code filter_code : filter W : Wideband filter (490-910 nm) C : Same as W V : Johnson V filter (before Jan 2009) G : SLOAN/SDSS g' filter (after Jan 2009) R : Cousins Rc filter (before Jan 2009) R : SLOAN/SDSS r' filter (after Jan 2009) I : Johnson IJ filter (before Jan 2009) I : SLOAN/SDSS i' filter (after Jan 2009) Z : SLOAN/SDSS z' filter (after Jan 2009) Clear : (no filter) |
|
| 39 | filter_name | character varying(30) | Filter name | |
| 40 | quantity_of_pixel_x | smallint | Number of pixels of x axis | |
| 41 | quantity_of_pixel_y | smallint | Number of pixels of y axis | |
| 42 | pixel_scale | double precision | arcsec/pixcel | Camera pixel scale [arcsec/pixel] |
| 43 | corner1_ra | double precision | degree | Coordinate of the vertex1 of the observation field of view, Right Ascension J2000. |
| 44 | corner1_dec | double precision | degree | Coordinate of the vertex1 of the observation field of view, Declination J2000. |
| 45 | corner2_ra | double precision | degree | Coordinate of the vertex2 of the observation field of view, Right Ascension J2000. |
| 46 | corner2_dec | double precision | degree | Coordinate of the vertex2 of the observation field of view, Declination J2000. |
| 47 | corner3_ra | double precision | degree | Coordinate of the vertex3 of the observation field of view, Right Ascension J2000. |
| 48 | corner3_dec | double precision | degree | Coordinate of the vertex3 of the observation field of view, Declination J2000. |
| 49 | corner4_ra | double precision | degree | Coordinate of the vertex4 of the observation field of view, Right Ascension J2000. |
| 50 | corner4_dec | double precision | degree | Coordinate of the vertex4 of the observation field of view, Declination J2000. |
| 51 | corner1_ra_b1950 | double precision | degree | Coordinate of the vertex1 of the observation field of view, Right Ascension B1950. |
| 52 | corner1_dec_b1950 | double precision | degree | Coordinate of the vertex1 of the observation field of view, Declination B1950. |
| 53 | corner2_ra_b1950 | double precision | degree | Coordinate of the vertex2 of the observation field of view, Right Ascension B1950. |
| 54 | corner2_dec_b1950 | double precision | degree | Coordinate of the vertex2 of the observation field of view, Declination B1950. |
| 55 | corner3_ra_b1950 | double precision | degree | Coordinate of the vertex3 of the observation field of view, Right Ascension B1950. |
| 56 | corner3_dec_b1950 | double precision | degree | Coordinate of the vertex3 of the observation field of view, Declination B1950. |
| 57 | corner4_ra_b1950 | double precision | degree | Coordinate of the vertex4 of the observation field of view, Right Ascension B1950. |
| 58 | corner4_dec_b1950 | double precision | degree | Coordinate of the vertex4 of the observation field of view, Declination B1950. |
| 59 | corner1_ecliptic_lon | double precision | degree | Coordinate of the vertex1 of the observation field of view, Ecliptic Longitude. |
| 60 | corner1_ecliptic_lat | double precision | degree | Coordinate of the vertex1 of the observation field of view, Ecliptic Latitude. |
| 61 | corner2_ecliptic_lon | double precision | degree | Coordinate of the vertex2 of the observation field of view, Ecliptic Longitude. |
| 62 | corner2_ecliptic_lat | double precision | degree | Coordinate of the vertex2 of the observation field of view, Ecliptic Latitude. |
| 63 | corner3_ecliptic_lon | double precision | degree | Coordinate of the vertex3 of the observation field of view, Ecliptic Longitude. |
| 64 | corner3_ecliptic_lat | double precision | degree | Coordinate of the vertex3 of the observation field of view, Ecliptic Latitude. |
| 65 | corner4_ecliptic_lon | double precision | degree | Coordinate of the vertex4 of the observation field of view, Ecliptic Longitude. |
| 66 | corner4_ecliptic_lat | double precision | degree | Coordinate of the vertex4 of the observation field of view, Ecliptic Latitude. |
| 67 | corner1_galactic_lon | double precision | degree | Coordinate of the vertex1 of the observation field of view, Galactic Longitude. |
| 68 | corner1_galactic_lat | double precision | degree | Coordinate of the vertex1 of the observation field of view, Galactic Latitude. |
| 69 | corner2_galactic_lon | double precision | degree | Coordinate of the vertex2 of the observation field of view, Galactic Longitude. |
| 70 | corner2_galactic_lat | double precision | degree | Coordinate of the vertex2 of the observation field of view, Galactic Latitude. |
| 71 | corner3_galactic_lon | double precision | degree | Coordinate of the vertex3 of the observation field of view, Galactic Longitude. |
| 72 | corner3_galactic_lat | double precision | degree | Coordinate of the vertex3 of the observation field of view, Galactic Latitude. |
| 73 | corner4_galactic_lon | double precision | degree | Coordinate of the vertex4 of the observation field of view, Galactic Longitude. |
| 74 | corner4_galactic_lat | double precision | degree | Coordinate of the vertex4 of the observation field of view, Galactic Latitude. |