﻿
# HCFF.db

# select distinct
# printf('0x%06X', (deviceFamily.id << 16) | (deviceModel.model_number << 8) | (component.component_number)) as 'Device ID'
# --, deviceFamily.id as deviceFamilyId
# --, deviceModel.model_number
# --, component.component_number
# --, familyName.english as 'Family Name'
# --, modelName.english as 'Model Name'
# , componentName.english as 'Device Name'
# --, componentAbbr.english as 'Component Abbr'
# from
# deviceFamily
# join deviceModel on deviceModel.deviceFamily_id = deviceFamily.id
# join component on component.deviceModel_id = deviceModel.id
# left join deviceString as familyName on familyName.id = deviceFamily.name_deviceString_id
# left join deviceString as modelName on modelName.id = deviceModel.name_deviceString_id
# left join deviceString as componentName on componentName.id = component.name_deviceString_id
# left join deviceString as componentAbbr on componentAbbr.id = component.abbr_deviceString_id
# order by deviceFamily.id, deviceModel.model_number, component.component_number;

# Device ID, Device Name

0x020101, Temperature
0x030101, Circulator
0x040101, Conductivity
0x050101, Clark DO
0x050201, Hach LDO
0x060101, pH
0x070101, ORP
0x080101, Depth 10 meter
0x080201, Depth 25 meter
0x080301, Depth 100 meter
0x080401, Depth 200 meter
0x080501, DepthSim100
0x090101, Total Dissolved Gas
0x0A0101, Turbidity
0x0A0201, Turbidity/Brush
0x0A0301, Central Wiper
0x0B0101, Chlorophyll a
0x0B0201, Rhodamine WT
0x0B0301, Blue-Green Algae Fresh
0x0B0401, Blue-Green Algae Marine
0x0D0101, Ammonium-Ammonia
0x0D0201, Nitrate
0x0D0301, Chloride
0x0E0101, Barometric Pressure
0x0F0101, Central Wiper
0x100101, Location
0x970101, pH
0x970102, ORP
0x980101, Temperature
0x980102, Circulator
0x990101, Ammonium-Ammonia
0x990102, Nitrate
0xC80101, Communications Module (USB)
0xC80201, Communications Module SDI-12
0xC80301, Modbus RS232
0xC80401, Modbus RS485
0xC80501, TTY RS232
0xC90101, Surveyor HL
0xC90201, Surveyor 2HL
0xCA0101, HL4
0xCA0201, HL7
