|
This page last changed on Feb 27, 2007 by graybeal.
Introduction
This page describes normalization planned for various fields. The actual steps required to perform this normalization are documented in MakingData.
BOG fields for Model and Serial Numbers
Guidelines:
- Model: The available labels are not as well codified as Type, Manufacturer. As long as the two tables agree (initially), it doesn't matter if it's "37IM" or "37 IM" or "37-IM" etc; it's been suggested that tools for searching on model be case-insensitive, also ignoring spaces, hyphens. There's sure to be a lot of hand-alignment.
- The serial number should be the most complete serial number as presented and formatted by the vendor — as written on the invoice, written on the label, etc. This will often include some model information. (The short serial number in the Instru 'Serial' field is the last unique part of the full serial number. We will support that also but it will not be primary.)
- Name may be the Type or Model or a more descriptive name, potentially in alignment with that provided by the manufacturer. This information can be constructed from the other fields in any case, and so it is believed not critical to processing.
Some example formats for the different manufacturers are in this table.
| Mannufacturer |
Model |
Serial Number |
Name |
| Aanderaa Data Instruments |
just number (3830, 3835) |
just number (131, 121) |
Name as provided by Aandreaa ("Oxygen Optode", "Oxygen Optode Shallow Water") |
| WHOI (was ASIMET) |
three-letter abbrev from ASIMET (LWR, SWR) |
three-digit number |
"ASIMET " + model (e.g. "ASIMET SWR") |
| Benthos |
as provided by company (865-A, UAT-376) |
as provided by company |
Description "release" or "transducer" |
| Biospherical |
as provided by company (PRR-620, PRR-620-T2) |
as provided by company |
|
To create the normalized SSDS serial number field, we plan the following.
| BOG Field |
Current Values |
Suggested Value |
| FullSerial |
A real mess |
If Instru has a full serial number, use it. If not, then if SSDS has FullSerial, use that. Lacking that, if only a (short) Serial is in BOG, use that instead. |
| Serial |
Shore serial numbers |
Copy the BOG short Serial field into a similar field in SSDS. |
| Model |
A real mess |
Should be as presented and formatted by the manufacturer if possible. |
BOG field "Manufacturer"
If at all possible, the Manufacturer should be the complete name of the company, though "Inc" or "Co" can be excluded. (Go to website, how does company refer to itself?) Abbreviations should be expanded except in extreme, well-known cases (e.g., MBARI, WHOI, HOBI Labs).
Until we have a proper company table, we propose to update the company name to the current name whenever it's known to change. (Better answer long term is to create Company Names and Company tables, so multiple names can reference the same company. This can also support lookups of older names and other historical referencing.)
The following table was an initial cut at final names, and is now deprecated. (Kept only for reference.) For the ultimate answers see the final names list.
| BOG has... |
SSDS Has... |
Suggested compromise |
| Aanderaa |
Aanderaa; Aanderaa Instruments |
Aanderaa Data Instruments
|
| Asimet |
Asimet; ASIMET; Asimet/WHOI; WHOI |
WHOI |
| Benthos |
n/a |
Benthos |
| Biospherical |
Biospherical |
Biospherical |
| Garmin |
Garmin |
Garmin |
| HOBI Labs |
Hobi Labs; HOBI Labs, Inc |
HOBI Labs |
| MBARI |
MBARI |
MBARI |
| RD Instruments |
RDI; RD Instruments |
RD Instruments |
| Satlantic |
Satlantic |
Satlantic |
| Sea-Bird |
Seabird; Sea-bird; Seabird Electronics; Sea-Bird Electronics; Sea-Bird Electronics Inc |
Sea-Bird Electronics |
| SeaTech |
n/a |
SeaTech |
| Simrad |
n/a |
Simrad |
| WET Labs |
WETLabs; Wetlabs; WET Labs |
WET Labs |
| Xantrex |
Xantrex |
Xantrex |
BOG field "Type"
| BOG has... |
SSDS has... |
Suggested compromise (types new to SSDS in italics) |
Comments? |
| ADCP |
ADCP |
Current Sensor-ADCP |
ADCP should have been deprecated in SSDS. It is a particular kind of this type of instrument. |
| backscatter |
Scatterometer; Backscatterometer |
HOBI HS2 is a Backscatterometer-Fluorometer; WET Labs BBSB is a Backscatterometer; WET Labs VSFS is a Backscatterometer |
HOBI Labs HS2 units are marked as both in SSDS. WETLabs BBSB units are only Scatterometers. Are the two categories distinct or not? In BOG they're both "backscatter" |
| backscatter/fluorometer |
(need to add) |
Backscatterometer-Fluorometer |
In BOG there as WET Labs ECO BB2F-067 and -065 |
| battery |
n/a |
Battery |
RDI battery packs |
| controller; Controller |
? |
Controller for HydroDAS units; Controller-Mooring Node for OASIS units |
Includes MBARI OASIS-x and HOBI HydroDAS |
| CTD |
CTD |
CTD |
|
| e-meter |
Electrical Sensor |
Electrical Sensor |
|
| fluor/turbidity |
Fluorometer; Fluorometer-Nephalometer (some ECO-FLNT units marked as Fluormeter) |
Fluorometer-Nephelometer |
WET Labs ECO-FLNTUS. Some ECO-FLNTU units are incorrectly identified at Fluorometers?). Also, apparently (at least according to Google Fight), it's a nephelometer, not a nephalometer |
| fluorometer |
Fluorometer |
Fluorometer |
WET Labs ECO FLS and WETStar |
| GPS |
GPS |
GPS |
|
| ICC |
n/a |
Inductive Modem Cable Coupler |
Not really a distinct component, more like a modem accessory. However, Paul is tracking it in BOG (though he may not in the future). |
| Meteorological |
Metsys |
Meteorology Package |
Although "Metsys" is used as the common parlance for this package, it is not self-explanatory and is not trivial to derive from a Google search. |
| modem |
Inductive Modem; Inductive Modem-Surface; Inductive Modem-Underwater |
Inductive Modem; Inductive Modem-Surface; Inductive Modem-Underwater |
Backport from SSDS to BOG. "Inductive Modem" isn't a used category (yet). |
| Nitrate; Nitrate analyzer |
Nitrogen Sensor-ISUS |
Nitrogen Sensor-ISUS for MBARI units, Nitrogen Sensor for Satlantic units |
Apparently the ISUS and Satlantic units are sufficently distinct that they should be considered different things. |
| Oxygen optode; Oxygen Optode |
Oxygen; Oxygen Sensor |
Oxygen Sensor |
|
| pCO2 |
CO2 Monitor |
CO2 Monitor |
|
| Platform |
Mooring |
Mooring |
|
| power source |
? |
Power Supply |
MBARI WH-CPS-I and WH-CPS-E. This is a unit developed inhouse for powering the Workhorse ADCPs off mooring power |
| pump |
n/a |
Pump |
|
| radiometer |
Radiometer; Radiometer-Hyperspectral; Radiometer-Longwave; Radiometer-Multispectral; Radiometer-Shortwave |
Radiometer; Radiometer-Hyperspectral; Radiometer-Longwave; Radiometer-Multispectral; Radiometer-Shortwave |
Backport info to BOG |
| release |
n/a |
Release |
|
| shutter |
n/a |
Shutter-Antifouling |
New term? Replace Bioshutter in SSDS? |
| temperature/humidity |
Meteorology Package |
Meteorology Package |
Asimet HRH packages |
| Transducer |
n/a |
Transponder |
One instance, Benthos UAT-376. It's a pinger/transponder. |
| transmissometer |
n/a |
Transmissometer |
Can't find matching instruments in SSDS: SeaTech and WET Labs C-Star units) |
BOG field Technician
This field is entirely filled with 'pc' in BOG, and appears to have the same function as the PersonID_FK field in SSDS. (This is not the 'owner' or 'custodian' functions of BOG, but is just the person who knows about this instrument and its properties.) Suggest replacing Paul Coenen as the PersonID_FK for any device in Instru.
Deferred to phase 2:
| Calibration Organization |
Aandreaa, Benthos, Biospherical, HOBI, HOBI Labs, MBARI, MBARI-Heller, MBARI-Kocher, RD Instruments, RDI, Satlantic, SBE, Sea-Bird, Sea-Bird Electronics, WET Labs, WETLabs, |
(line up organization with Manufacturer fields, add person field) |
| Custodian |
_some multiples i.e. _ Coenen/Heller. Also "??" |
|
| Owner |
Mix of people and projects, some with slashes |
|
|
