[ 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.

Scroll Back to Top ⏏

Last Modified: 29 August 2024