Download "user manual"
Transcript
May 2006 Volume 7 Issue 2 Modification to Interrogation Data Loader (IDL) DOUG CLOUGH (Synergetics Engineered Systems) Two modifications have been made in the pre-processing of interrogation records by the Interrogation Data Loader FIGURE 1 • Storing Tranceiver ID in cksm column (IDL). These changes are not retroactive, and therefore only ÕÌ«iÝi` /À>ÃViÛiÀ apply to data received on or after 27 February 2006. 1. Store transceiver identifiers For data arriving in Minimon, MobileMon, or M4 files, store the transceiver identifier in the cksm column of the obs_data database table (Figure 1). Note that this value is available only if the interrogation was captured by a multiplexing transceiver, for example a Digital Angel FS1001M. If the interrogation was captured by a non-multiplexing transceiver, such as a Digital Angel FS1001A, store the coil identifier (redundantly) in the cksm column (Figure 2). 8£ Ó £ Teqc qcdiAdqceTi5qq5qA i FIGURE 2 • Storing Coil ID (redundantly) in cksm column ÕÌ«iÝi` /À>ÃViÛiÀ LÃÊ`>Ì> LÃÚ`>Ìi LÃÚÃÌi Ì>}Ú` Và VÌÀ Ài>`ÃÊ V£ LÃÚviÊ Ê Alters the processing of all interrogation files PTAGIS is always open to correspondence. If you have any comments, questions or suggestions please contact ptagis. [email protected] T "iÊÌiÀÀ}>ÌÊ,iVÀ` ÊiÊ---99°* ÊÊÊ 2. Store identical-record counts As a file is pre-processed in preparation for loading to the database, count the number of identical copies of each record. For every set of duplicates found in the file, load a single interrogation record into the database, storing the identical-record count in the nreads column of the obs_data table (Figure 3). Note that in this context, “identical” interrogation records may actually differ slightly: a “millisecond” component of the interrogation timestamp, present at the end of some records, will differ record-torecord within “a set of duplicates.” However, the millisecond values are not stored in the database, and are ignored for purposes of counting “identical” records. hQYT:h Ó Teqc qcdiAdqceTi5qq5qA hQYT:h i i "iÊÌiÀÀ}>ÌÊ,iVÀ` ÊiÊ---99°* ÊÊÊ FIGURE 3 • S toring Identical-Record Count in nreads column /À>ÃViÛiÀÊ-iÌ Ìʼ1µÕiÊ"vv½ LÃÊ`>Ì> Ó LÃÚ`>Ìi LÃÚÃÌi Ì>}Ú` Và VÌÀ Ài>`ÃÊ V£ LÃÚviÊ Ê Does not alter the processing of Multimon files LÃÚ`>Ìi LÃÚÃÌi Ì>}Ú` Và VÌÀ Ài>`ÃÊ V£ LÃÚviÊ Ê LÃÊ`>Ì> Î Teqc qcdiAdqceTi5qq5qA hQYT:h i i Teqc qcdiAdqceTi5qq5qA hQYT:h i i Teqc qcdiAdqceTi5qq5qA hQYT:h i i ÎÊ`iÌV>ÊÌiÀÀ}>ÌÊ,iVÀ`ÃÊÊ