Details
-
Type:
Story
-
Status: Done
-
Resolution: Done
-
Fix Version/s: None
-
Component/s: None
-
Labels:
-
Epic Link:
-
Sprint:DB_S17_10
-
Team:Data Access and Database
Description
Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017.
Properties of the dataset are documented at:
Catalog descriptions
AllWISE
| catalog (link to IPAC) | PDAC database | table (link to PDAC schema) |
|---|---|---|
| AllWISE source Catalog, equivalent to LSST object | wise_00 | allwise_p3as_psd |
| AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | wise_ext_00 | allwise_p3as_psr |
| AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | wise_00 | allwise_p3as_mep |
| AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | wise_00 | allwise_p3am_cdd |
| AllWISE Atlas Metadata Table | wise_00 | allwise_p3as_cdd |
WISE All-Sky, 3-band Cryo, and Post-Cryo databases, the single exposure image meta data
| catalog (link to IPAC) | PDAC database | table (link to PDAC schema) |
|---|---|---|
| WISE All-Sky Single Exposure (L1b) Image Inventory Table | wise_00 | allsky_4band_p1bm_frm |
| WISE 3-Band Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | allsky_3band_p1bm_frm |
| WISE Post-Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | allsky_2band_p1bm_frm |
WISE All-Sky, 3-band Cryo, and Post-Cryo databases
| catalog (link to IPAC) | PDAC database | table (link to PDAC schema) |
|---|---|---|
| WISE All-Sky Single Exposure (L1b) Source Table | wise_00 | allsky_4band_p1bs_psd |
| WISE 3-Band Cryo Single Exposure (L1b) Source Table | wise_00 | allsky_3band_p1bs_psd |
| WISE Post-Cryo Single Exposure (L1b) Source Table | wise_00 | allsky_2band_p1bs_psd |
NeoWISE
| catalog (link to IPAC) | PDAC database | table (link to PDAC schema) |
|---|---|---|
| NEOWISE-R Year 1 Single Exposure (L1b) Source Table | neowiser_yr1_00 | neowiser_yr1_p1bs_psd |
Changes made to the original schema
Data types
The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping:
| Oracle | MySQL |
|---|---|
| SERIAL8 | BIGINT |
| SMALLFLOAT | FLOAT |
| INT8 | BIGINT |
| VARCHAR2(N BYTE) | VARCHAR(N) |
| NUMBER(M,D) | DECIMAL(M,D) |
| NUMBER(10,0) | INT |
| NUMBER(10) | INT |
| NUMBER(19) | BIGINT |
Indexes
The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema.
Replaced dec with decl as column names
Due to a bug in Qserv implementation (see DM-9736) reserved words of the SQL-92 (or MySQL) can't be used to identifiers in tables schema. One particular problem of the original WISE dataset is caused by using dec (for declination) as the column names of both tables. The problem was discovered later on when testing the loaded dataset (see the log of downstream comments for details). A workaround deployed then was to rename the columns of both tables as decl.
Attachments
Issue Links
- relates to
-
- Done
-
DM-8762 WISE single epoch source table integration(f17)
- Done
-
- Done
-
- Done
-
- Done
- mentioned in
-
Page Loading...
(1 mentioned in)
Activity
| Field | Original Value | New Value |
|---|---|---|
| Epic Link |
|
| Description |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. h1. References Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] A list of WISE catalogs to be loaded: * [https://confluence.lsstcorp.org/display/DM/PDAC+v2] Tools and scripts developed for this efforts are found at the GitHub package: * [https://github.com/lsst-dm/db_pdac_wise] h1. Catalog descriptions h2. AllWISE || catalog || PDAC database || table || | AllWISE source Catalog, equivalent to LSST object | wise_00 | allwise_p3as_psd | | AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | wise_ext_00 | allwise_p3as_psr | | AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | wise_00 | allwise_p3as_mep | | AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | wise_00 | allwise_p3am_cdd | | AllWISE Atlas Metadata Table | wise_00 | allwise_p3as_cdd | h1. Changes made to the original schema A few minor adjustments to the schema had to be made to due to differences in ORACLE-specific (WISE) and MySQL types. |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog || PDAC database || table || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | allwise_p3as_psd | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | allwise_p3as_psr | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | allwise_p3as_mep | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | allwise_p3am_cdd | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | allwise_p3as_cdd | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
| Description |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog || PDAC database || table || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | allwise_p3as_psd | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | allwise_p3as_psr | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | allwise_p3as_mep | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | allwise_p3am_cdd | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | allwise_p3as_cdd | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
| Description |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [WISE All-Sky Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [allsky_4band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql ] | | [ WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/ ] | wise_00 | [ allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql ] | | [ WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/ ] | wise_00 | [ allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [ NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/ ] | neowiser_year1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql ] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
| Description |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [WISE All-Sky Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [allsky_4band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql ] | | [ WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/ ] | wise_00 | [ allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql ] | | [ WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/ ] | wise_00 | [ allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [ NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/ ] | neowiser_year1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql ] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [ WISE All-Sky Single Exposure (L1b) Source Table|http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [ allsky_4band_p1bs_psd|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql ] | | [ WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/ ] | wise_00 | [allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql ] | | [ WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/ ] | wise_00 | [allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [ NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/ ] | neowiser_year1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql ] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
| Description |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [ WISE All-Sky Single Exposure (L1b) Source Table|http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [ allsky_4band_p1bs_psd|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql ] | | [ WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/ ] | wise_00 | [allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql ] | | [ WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/ ] | wise_00 | [allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [ NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/ ] | neowiser_year1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql ] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [WISE All-Sky Single Exposure (L1b) Source Table|http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [ allsky_4band_p1bs_psd|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql ] | | [WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/ ] | wise_00 | [allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql ] | | [WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/ ] | wise_00 | [allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/] | neowiser_year1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
| Description |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [WISE All-Sky Single Exposure (L1b) Source Table|http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [ allsky_4band_p1bs_psd|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql ] | | [WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/ ] | wise_00 | [allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql ] | | [WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/ ] | wise_00 | [allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/] | neowiser_year1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [WISE All-Sky Single Exposure (L1b) Source Table|http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [ allsky_4band_p1bs_psd|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql] | | [WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/] | wise_00 | [allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql] | | [WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/] | wise_00 | [allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/] | neowiser_year1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
| Description |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [WISE All-Sky Single Exposure (L1b) Source Table|http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [ allsky_4band_p1bs_psd|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql] | | [WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/] | wise_00 | [allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql] | | [WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/] | wise_00 | [allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/] | neowiser_year1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [WISE All-Sky Single Exposure (L1b) Source Table|http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [allsky_4band_p1bs_psd|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql] | | [WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/] | wise_00 | [allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql] | | [WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/] | wise_00 | [allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/] | neowiser_year1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
| Description |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [WISE All-Sky Single Exposure (L1b) Source Table|http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [allsky_4band_p1bs_psd|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql] | | [WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/] | wise_00 | [allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql] | | [WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/] | wise_00 | [allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/] | neowiser_year1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases, the single exposure image meta data || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | WISE All-Sky Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_4band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bm_frm.sql] | | WISE 3-Band Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_3band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bm_frm.sql] | | WISE Post-Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_2band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bm_frm.sql] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [WISE All-Sky Single Exposure (L1b) Source Table|http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [allsky_4band_p1bs_psd|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql] | | [WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/] | wise_00 | [allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql] | | [WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/] | wise_00 | [allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/] | neowiser_year1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
| Description |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases, the single exposure image meta data || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | WISE All-Sky Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_4band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bm_frm.sql] | | WISE 3-Band Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_3band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bm_frm.sql] | | WISE Post-Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_2band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bm_frm.sql] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [WISE All-Sky Single Exposure (L1b) Source Table|http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [allsky_4band_p1bs_psd|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql] | | [WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/] | wise_00 | [allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql] | | [WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/] | wise_00 | [allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/] | neowiser_year1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases, the single exposure image meta data || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | WISE All-Sky Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_4band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bm_frm.sql] | | WISE 3-Band Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_3band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bm_frm.sql] | | WISE Post-Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_2band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bm_frm.sql] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [WISE All-Sky Single Exposure (L1b) Source Table|http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [allsky_4band_p1bs_psd|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql] | | [WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/] | wise_00 | [allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql] | | [WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/] | wise_00 | [allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/] | neowiser_year1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
| Assignee | Igor Gaponenko [ gapon ] |
| Status | To Do [ 10001 ] | In Progress [ 3 ] |
| Resolution | Done [ 10000 ] | |
| Status | In Progress [ 3 ] | Done [ 10002 ] |
| Remote Link | This issue links to "Page (Confluence)" [ 15808 ] |
| Description |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases, the single exposure image meta data || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | WISE All-Sky Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_4band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bm_frm.sql] | | WISE 3-Band Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_3band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bm_frm.sql] | | WISE Post-Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_2band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bm_frm.sql] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [WISE All-Sky Single Exposure (L1b) Source Table|http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [allsky_4band_p1bs_psd|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql] | | [WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/] | wise_00 | [allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql] | | [WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/] | wise_00 | [allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/] | neowiser_year1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases, the single exposure image meta data || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | WISE All-Sky Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_4band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bm_frm.sql] | | WISE 3-Band Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_3band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bm_frm.sql] | | WISE Post-Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_2band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bm_frm.sql] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [WISE All-Sky Single Exposure (L1b) Source Table|http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [allsky_4band_p1bs_psd|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql] | | [WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/] | wise_00 | [allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql] | | [WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/] | wise_00 | [allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/] | neowiser_yr1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
| Description |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases, the single exposure image meta data || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | WISE All-Sky Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_4band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bm_frm.sql] | | WISE 3-Band Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_3band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bm_frm.sql] | | WISE Post-Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_2band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bm_frm.sql] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [WISE All-Sky Single Exposure (L1b) Source Table|http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [allsky_4band_p1bs_psd|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql] | | [WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/] | wise_00 | [allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql] | | [WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/] | wise_00 | [allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/] | neowiser_yr1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
h1. Scope
This tickets represents a summary of WISE catalogs loaded into PDAC Qserv in the year of 2017. Properties of the dataset are documented at: * [https://confluence.lsstcorp.org/display/DM/Properties+of+the+WISE+and+NEOWISE+mission+data] h1. Catalog descriptions h2. AllWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [AllWISE source Catalog, equivalent to LSST object|http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_00 | [allwise_p3as_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psd.sql] | | [AllWISE Reject Table, equivalent to LSST object (faint, rejected objects) | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec2_1.html] | wise_ext_00 | [allwise_p3as_psr | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_psr.sql] | | [AllWISE Multiepoch Photometry Table, equivalent to LSST forced source | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec3_1a.html] | wise_00 | [allwise_p3as_mep |https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_mep.sql] | | [AllWISE Atlas Image Inventory Table, the meta data for AllWISE coadd images | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3am_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3am_cdd.sql] | | [AllWISE Atlas Metadata Table | http://wise2.ipac.caltech.edu/docs/release/allwise/expsup/sec1_3.html#atlas] | wise_00 | [allwise_p3as_cdd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allwise_p3as_cdd.sql ] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases, the single exposure image meta data || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | WISE All-Sky Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_4band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bm_frm.sql] | | WISE 3-Band Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_3band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bm_frm.sql] | | WISE Post-Cryo Single Exposure (L1b) Image Inventory Table | wise_00 | [allsky_2band_p1bm_frm|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bm_frm.sql] | h2. WISE All-Sky, 3-band Cryo, and Post-Cryo databases || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [WISE All-Sky Single Exposure (L1b) Source Table|http://irsa.ipac.caltech.edu/data/download/wise-4band-psd/] | wise_00 | [allsky_4band_p1bs_psd|https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_4band_p1bs_psd.sql] | | [WISE 3-Band Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-3band-psd/] | wise_00 | [allsky_3band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_3band_p1bs_psd.sql] | | [WISE Post-Cryo Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/wise-2band-psd/] | wise_00 | [allsky_2band_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/allsky_2band_p1bs_psd.sql] | h2. NeoWISE || catalog (link to IPAC) || PDAC database || table (link to PDAC schema) || | [NEOWISE-R Year 1 Single Exposure (L1b) Source Table | http://irsa.ipac.caltech.edu/data/download/neowiser_year1/] | neowiser_yr1_00 | [neowiser_yr1_p1bs_psd | https://github.com/lsst-dm/db_pdac_wise/blob/master/sql/neowiser_yr1_p1bs_psd.sql] | h1. Changes made to the original schema h2. Data types The original schema files of the input datasets had to be adjusted to map Oracle-specific types into standard SQL or MySQL types. The table below show the mapping: || Oracle || MySQL || | SERIAL8 | BIGINT | | SMALLFLOAT | FLOAT | | INT8 | BIGINT | | VARCHAR2(N BYTE) | VARCHAR(N) | | NUMBER(M,D) | DECIMAL(M,D) | | NUMBER(10,0) | INT | | NUMBER(10) | INT | | NUMBER(19) | BIGINT | h2. Indexes The original schema files had no indexes. A minimal set (depending on a table) of indexes were added into the output schema. h2. Replaced *dec* with *decl* as column names Due to a bug in Qserv implementation (see [ |
| Risk Score | 0 |