Appendix 6. Merged Working Database Source Information

3. Merged Database Table Formats

c. Merged Source Cross-Reference (Link) Tables

The following table contains brief descriptions of the entries in the Survey, 6x and Calibration Merged Source Cross-Reference Tables. The Cross-Reference Tables for the Merged Point and Extended Sources have the same format.

The Cross-Reference tables contain information linking each merged group with its individual extractions in the respective WDB. The tables contain one row for each WDB extraction that has been associated with a merged source group. Each row in the tables contains the unique merged group identifier (gcntr), the unique WDB identifier (cntr/pts_key for Point Source WDBs and cntr/ext_key for Extended Source WDBs) and the number of groups with which that WDB extraction has been associated (ngrp). A WDB extraction may be associated with more than one merged group in confused situations. The cntr/pts_key/ext_key values for such WDB extractions will appear more than once in the Cross-Reference Tables, accompanied by the gcntr of each of the groups to which it has been associated.

Searching this table for all entries with a particular value of gcntr returns the identifiers of all WDB entries in a particular merged group. Alternately, searching this table for a particular value of cntr/pts_key/ext_key returns a list of all groups to which a particular WDB extraction belongs.

The order of the entries in this table is the same as that presented in the IRSA/GATOR query page for these tables.

The columns in the following table are:

• Column Name: The parameter name in the Merged Source Information Cross-Reference table. Click on this to go to the section of the Explanatory Supplement where the derivation and/or usage of that parameter is described in more detail.



• Format: The ascii-equivalent format of the field in the PSWDB, expressed in "C" readable notation. This is useful when parsing the aligned tabular output from IRSA/GATOR. Although the data values will conform to these formats, the actual width of the field in the GATOR output may be padded with extra blank spaces to accommodate column headers. Note that some fields contain null values that will require special handling when parsing tables drawn from IRSA/GATOR output.



• Units: The units of the parameter. A value of "---" in this column means that the parameter is dimensionless.



• nulls: A "yes" in this column means that this parameter can be null in the Merged Source table. A "no" means that there will always be a value in this column in the table. Note that null values are represented differently in the IRSA/GATOR output and the ascii DVD-ROM or ftp versions of the Merge Source tables.



• Description: A brief description of the parameter and its values.