INSERT INTO test_type(type_name,description,required_attr) VALUES ('sensor_range', 'Sensor manufacturer~Rs stated measurement bounds (minimum and maximum) and is range of possible valid measurement.', 'sensor_rh,sensor_rl'); INSERT INTO test_type(type_name,description,required_attr) VALUES ('rate_of_change', 'Intended to check for physically impossible changes with time but can be refined for general areas and include frontal passage limits', 'delta_time,delta_obs'); INSERT INTO test_type(type_name,description,required_attr) VALUES ('data_availability', 'Unreported data are usually caused by communication failures or bad or partial data transmission or problems related to data acquisition', NULL); INSERT INTO test_type(type_name,description,required_attr) VALUES ('gross_range', 'Regional sanity check that a measurement falls within an annual range based on knowledge of the general location of the platform.', 'gross_rh,gross_rl'); INSERT INTO test_type(type_name,description,required_attr) VALUES ('climatological_range', 'Historically derived site specific data range. These include seasonal or monthly ranges derived at a specific platform for several years.', 'clim_rh,clim_rl');