Files
@ 72890999e24d
Branch filter:
Location: DA/lsst_blog/sql/create_source.sql - annotation
72890999e24d
3.5 KiB
application/sql
Running LSST baseline queries in MonetDB
72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d | CREATE TABLE %(tabname)s
(id BIGINT NOT NULL
,coord_ra double DEFAULT NULL
,coord_decl double DEFAULT NULL
,coord_htmId20 BIGINT DEFAULT NULL
,parent BIGINT DEFAULT NULL
,flags_badcentroid BOOLEAN NOT NULL
,centroid_sdss_x double DEFAULT NULL
,centroid_sdss_y double DEFAULT NULL
,centroid_sdss_xVar double DEFAULT NULL
,centroid_sdss_xyCov double DEFAULT NULL
,centroid_sdss_yVar double DEFAULT NULL
,centroid_sdss_flags BOOLEAN NOT NULL
,flags_pixel_edge BOOLEAN NOT NULL
,flags_pixel_interpolated_any BOOLEAN NOT NULL
,flags_pixel_interpolated_center BOOLEAN NOT NULL
,flags_pixel_saturated_any BOOLEAN NOT NULL
,flags_pixel_saturated_center BOOLEAN NOT NULL
,flags_pixel_cr_any BOOLEAN NOT NULL
,flags_pixel_cr_center BOOLEAN NOT NULL
,centroid_naive_x double DEFAULT NULL
,centroid_naive_y double DEFAULT NULL
,centroid_naive_xVar double DEFAULT NULL
,centroid_naive_xyCov double DEFAULT NULL
,centroid_naive_yVar double DEFAULT NULL
,centroid_naive_flags BOOLEAN NOT NULL
,centroid_gaussian_x double DEFAULT NULL
,centroid_gaussian_y double DEFAULT NULL
,centroid_gaussian_xVar double DEFAULT NULL
,centroid_gaussian_xyCov double DEFAULT NULL
,centroid_gaussian_yVar double DEFAULT NULL
,centroid_gaussian_flags BOOLEAN NOT NULL
,shape_sdss_Ixx double DEFAULT NULL
,shape_sdss_Iyy double DEFAULT NULL
,shape_sdss_Ixy double DEFAULT NULL
,shape_sdss_IxxVar double DEFAULT NULL
,shape_sdss_IxxIyyCov double DEFAULT NULL
,shape_sdss_IxxIxyCov double DEFAULT NULL
,shape_sdss_IyyVar double DEFAULT NULL
,shape_sdss_IyyIxyCov double DEFAULT NULL
,shape_sdss_IxyVar double DEFAULT NULL
,shape_sdss_flags BOOLEAN NOT NULL
,shape_sdss_centroid_x double DEFAULT NULL
,shape_sdss_centroid_y double DEFAULT NULL
,shape_sdss_centroid_xVar double DEFAULT NULL
,shape_sdss_centroid_xyCov double DEFAULT NULL
,shape_sdss_centroid_yVar double DEFAULT NULL
,shape_sdss_centroid_flags BOOLEAN NOT NULL
,shape_sdss_flags_unweightedbad BOOLEAN NOT NULL
,shape_sdss_flags_unweighted BOOLEAN NOT NULL
,shape_sdss_flags_shift BOOLEAN NOT NULL
,shape_sdss_flags_maxiter BOOLEAN NOT NULL
,flux_psf double DEFAULT NULL
,flux_psf_err double DEFAULT NULL
,flux_psf_flags BOOLEAN NOT NULL
,flux_psf_psffactor float DEFAULT NULL
,flux_psf_flags_psffactor BOOLEAN NOT NULL
,flux_psf_flags_badcorr BOOLEAN NOT NULL
,flux_naive double DEFAULT NULL
,flux_naive_err double DEFAULT NULL
,flux_naive_flags BOOLEAN NOT NULL
,flux_gaussian double DEFAULT NULL
,flux_gaussian_err double DEFAULT NULL
,flux_gaussian_flags BOOLEAN NOT NULL
,flux_gaussian_psffactor float DEFAULT NULL
,flux_gaussian_flags_psffactor BOOLEAN NOT NULL
,flux_gaussian_flags_badcorr BOOLEAN NOT NULL
,flux_sinc double DEFAULT NULL
,flux_sinc_err double DEFAULT NULL
,flux_sinc_flags BOOLEAN NOT NULL
,centroid_record_x double DEFAULT NULL
,centroid_record_y double DEFAULT NULL
,classification_extendedness double DEFAULT NULL
,aperturecorrection double DEFAULT NULL
,aperturecorrection_err double DEFAULT NULL
,refFlux double DEFAULT NULL
,refFlux_err double DEFAULT NULL
,objectId BIGINT NOT NULL
,coord_raVar double DEFAULT NULL
,coord_radeclCov double DEFAULT NULL
,coord_declVar double DEFAULT NULL
,exposure_id BIGINT NOT NULL
,exposure_filter_id INT NOT NULL
,exposure_time float DEFAULT NULL
,exposure_time_mid double DEFAULT NULL
,cluster_id BIGINT DEFAULT NULL
,cluster_coord_ra double DEFAULT NULL
,cluster_coord_decl double DEFAULT NULL
-- ,PRIMARY KEY (id)
)
;
|