The Bronson Files, Dataset 2, Field 17, 2013 by US Government | Environmental and Climate Sciences

About this Dataset

The Bronson Files, Dataset 2, Field 17, 2013

Dr. Kevin Bronson provides this unique nitrogen and water management in cotton agricultural research dataset for compute, including notation of field events and operations, an intermediate analysis mega-table of correlated and calculated parameters, and laboratory analysis results generated during the experimentation, plus high resolution plot level intermediate data analysis tables of SAS process output, as well as the complete raw sensor recorded logger outputs.

This data was collected during the beginning time period of our USDA Maricopa terrestrial proximal high-throughput plant phenotyping tri-metric method generation, where a 5Hz crop canopy height, temperature and spectral signature are recorded coincident to indicate a plant health status. In this early development period, our Proximal Sensing Cart Mark1 (PSCM1) platform supplants people carrying the CropCircle (CC) sensors, and with an improved view mechanical performance result.

See included README file for operational details and further description of the measured data signals.

Summary: Active optical proximal cotton canopy sensing spatial data and including additional related metrics such as thermal are presented. Agronomic nitrogen and irrigation management related field operations are listed. Unique research experimentation intermediate analysis table is made available, along with raw data. The raw data recordings, and annotated table outputs with calculated VIs are made available. Plot polygon coordinate designations allow a re-intersection spatial analysis. Data was collected in the 2013 season at Maricopa Agricultural Center, Arizona, USA. High throughput proximal plant phenotyping via electronic sampling and data processing method approach is exampled. Acquired data using USDA Maricopa first mobile platforms, such as the Proximal Sensing Cart Mark 1, where the first dual sliding arm configuration was deployed and platform clearance raised successfully as design improvements. SAS and GIS compute processing output tables, including Excel formatted examples are presented, where intermediate data tabulation and analysis is available. The weekly proximal sensing data collected include canopy reflectance at six wavelengths, ultrasonic distance sensing of canopy height, and infrared thermometry. Lint and seed yields, first open boll biomass, and nitrogen uptake were also determined. Soil profile nitrate to 1.8 m depth was determined in 30-cm increments, before planting and after harvest. Nitrous oxide emissions were determined 20 or more weeks in the season with 1-L vented chambers (samples taken at 0, 12, and 24 minutes). Nitrous oxide was determined by gas chromatography (electron detection detector).
Organization: Department of Agriculture
Last updated: 2024-03-30T12:21:36.792256
Tags: agroecosystems-environment-weather-and-climate, ars, data-gov, earth-science-agriculture-soils-nitrogen, earth-science-biosphere-vegetation-plant-phenology, field-based-high-throughput-phenotyping, np211, plant-phenotyping

Tables

2013 F17 Data Dictionary

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.n_2013_f17_data_dictionary

7.56 KB
47 rows
7 columns


CREATE TABLE n_2013_f17_data_dictionary (
  "element_name" VARCHAR,
  "description" VARCHAR,
  "data_type" VARCHAR,
  "character_length" VARCHAR,
  "acceptable_values" VARCHAR,
  "required" VARCHAR,
  "accepts_null" VARCHAR
);

2013 F17 ActivitiesLog

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.n_2013_f17_activitieslog

6.95 KB
81 rows
4 columns


CREATE TABLE n_2013_f17_activitieslog (
  "date" VARCHAR,
  "doy" VARCHAR,
  "activity" VARCHAR,
  "comment_2013_season_field_13_cotton_n_study_the_bronso_584e1711" VARCHAR
);

2013 F017 Plot Coordinates

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.n_2013_f017_plot_coordinates

6.84 KB
360 rows
5 columns


CREATE TABLE n_2013_f017_plot_coordinates (
  "key" BIGINT,
  "treatment" BIGINT,
  "repetition" BIGINT,
  "meterseast" DOUBLE,
  "metersnorth" DOUBLE
);

F017–2013 05–23 HS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_05_23_hs_data

882.78 KB
41580 rows
13 columns


CREATE TABLE f017_2013_05_23_hs_data (
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "elevation" DOUBLE,
  "fix_type" BIGINT,
  "utc_time" DOUBLE,
  "speed" DOUBLE,
  "course" DOUBLE,
  "sensor" BIGINT,
  "vi1" DOUBLE,
  "vi2" DOUBLE,
  "r1" DOUBLE,
  "r2" DOUBLE,
  "r3" DOUBLE
);

F017–2013 05–28 HS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_05_28_hs_data

837.42 KB
39190 rows
13 columns


CREATE TABLE f017_2013_05_28_hs_data (
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "elevation" DOUBLE,
  "fix_type" BIGINT,
  "utc_time" DOUBLE,
  "speed" DOUBLE,
  "course" DOUBLE,
  "sensor" BIGINT,
  "vi1" DOUBLE,
  "vi2" DOUBLE,
  "r1" DOUBLE,
  "r2" DOUBLE,
  "r3" DOUBLE
);

F017–2013 06–04 HS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_06_04_hs_data

951.54 KB
48020 rows
13 columns


CREATE TABLE f017_2013_06_04_hs_data (
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "elevation" DOUBLE,
  "fix_type" BIGINT,
  "utc_time" DOUBLE,
  "speed" DOUBLE,
  "course" DOUBLE,
  "sensor" BIGINT,
  "vi1" DOUBLE,
  "vi2" DOUBLE,
  "r1" DOUBLE,
  "r2" DOUBLE,
  "r3" DOUBLE
);

F017–2013 06–05 HS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_06_05_hs_data

961.93 KB
50392 rows
13 columns


CREATE TABLE f017_2013_06_05_hs_data (
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "elevation" DOUBLE,
  "fix_type" BIGINT,
  "utc_time" DOUBLE,
  "speed" DOUBLE,
  "course" DOUBLE,
  "sensor" BIGINT,
  "vi1" DOUBLE,
  "vi2" DOUBLE,
  "r1" DOUBLE,
  "r2" DOUBLE,
  "r3" DOUBLE
);

F017–2013 06–14 HS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_06_14_hs_data

1.19 MB
60542 rows
13 columns


CREATE TABLE f017_2013_06_14_hs_data (
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "elevation" DOUBLE,
  "fix_type" BIGINT,
  "utc_time" DOUBLE,
  "speed" DOUBLE,
  "course" DOUBLE,
  "sensor" BIGINT,
  "vi1" DOUBLE,
  "vi2" DOUBLE,
  "r1" DOUBLE,
  "r2" DOUBLE,
  "r3" DOUBLE
);

F017–2013 06–19 HS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_06_19_hs_data

957.11 KB
45860 rows
13 columns


CREATE TABLE f017_2013_06_19_hs_data (
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "elevation" DOUBLE,
  "fix_type" BIGINT,
  "utc_time" DOUBLE,
  "speed" DOUBLE,
  "course" DOUBLE,
  "sensor" BIGINT,
  "vi1" DOUBLE,
  "vi2" DOUBLE,
  "r1" DOUBLE,
  "r2" DOUBLE,
  "r3" DOUBLE
);

F017–2013 06–26 HS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_06_26_hs_data

1.04 MB
51394 rows
13 columns


CREATE TABLE f017_2013_06_26_hs_data (
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "elevation" DOUBLE,
  "fix_type" BIGINT,
  "utc_time" DOUBLE,
  "speed" DOUBLE,
  "course" DOUBLE,
  "sensor" BIGINT,
  "vi1" DOUBLE,
  "vi2" DOUBLE,
  "r1" DOUBLE,
  "r2" DOUBLE,
  "r3" DOUBLE
);

F017–2013 07–09 HS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_07_09_hs_data

1.69 MB
81578 rows
13 columns


CREATE TABLE f017_2013_07_09_hs_data (
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "elevation" DOUBLE,
  "fix_type" BIGINT,
  "utc_time" DOUBLE,
  "speed" DOUBLE,
  "course" DOUBLE,
  "sensor" BIGINT,
  "vi1" DOUBLE,
  "vi2" DOUBLE,
  "r1" DOUBLE,
  "r2" DOUBLE,
  "r3" DOUBLE
);

F017–2013 07–19 HS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_07_19_hs_data

1.69 MB
86168 rows
13 columns


CREATE TABLE f017_2013_07_19_hs_data (
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "elevation" DOUBLE,
  "fix_type" BIGINT,
  "utc_time" DOUBLE,
  "speed" DOUBLE,
  "course" DOUBLE,
  "sensor" BIGINT,
  "vi1" DOUBLE,
  "vi2" DOUBLE,
  "r1" DOUBLE,
  "r2" DOUBLE,
  "r3" DOUBLE
);

F017–2013 07–25 HS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_07_25_hs_data

1.41 MB
65289 rows
13 columns


CREATE TABLE f017_2013_07_25_hs_data (
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "elevation" DOUBLE,
  "fix_type" BIGINT,
  "utc_time" DOUBLE,
  "speed" DOUBLE,
  "course" DOUBLE,
  "sensor" BIGINT,
  "vi1" DOUBLE,
  "vi2" DOUBLE,
  "r1" DOUBLE,
  "r2" DOUBLE,
  "r3" DOUBLE
);

F017–2013 08–05 HS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_08_05_hs_data

1.26 MB
59494 rows
13 columns


CREATE TABLE f017_2013_08_05_hs_data (
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "elevation" DOUBLE,
  "fix_type" BIGINT,
  "utc_time" DOUBLE,
  "speed" DOUBLE,
  "course" DOUBLE,
  "sensor" BIGINT,
  "vi1" DOUBLE,
  "vi2" DOUBLE,
  "r1" DOUBLE,
  "r2" DOUBLE,
  "r3" DOUBLE
);

F017–2013 08–19 HS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_08_19_hs_data

1.39 MB
67896 rows
13 columns


CREATE TABLE f017_2013_08_19_hs_data (
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "elevation" DOUBLE,
  "fix_type" BIGINT,
  "utc_time" DOUBLE,
  "speed" DOUBLE,
  "course" DOUBLE,
  "sensor" BIGINT,
  "vi1" DOUBLE,
  "vi2" DOUBLE,
  "r1" DOUBLE,
  "r2" DOUBLE,
  "r3" DOUBLE
);

F017–2013 05–23 CS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_05_23_cs_data

1.77 MB
35783 rows
31 columns


CREATE TABLE f017_2013_05_23_cs_data (
  "timestamp" TIMESTAMP,
  "record" BIGINT,
  "counter" BIGINT,
  "gpsyear" BIGINT,
  "gpsmonth" BIGINT,
  "gpsday" BIGINT,
  "gpshour" BIGINT,
  "gpsminute" BIGINT,
  "gpssecond" BIGINT,
  "batt_volt_min" DOUBLE,
  "rmc_lat" DOUBLE,
  "rmc_long" DOUBLE,
  "rmc_date" BIGINT,
  "rmc_utc" DOUBLE,
  "rmc_knots" DOUBLE,
  "gga_quality" BIGINT,
  "gga_sat" BIGINT,
  "ptemp" DOUBLE,
  "airtemp" DOUBLE,
  "targtemp_1022" DOUBLE,
  "targtemp_1023" DOUBLE,
  "targtemp_1052" DOUBLE,
  "sbtemp_1022" DOUBLE,
  "sbtemp_1023" DOUBLE,
  "sbtemp_1052" DOUBLE,
  "tmv_1022" DOUBLE,
  "tmv_1023" DOUBLE,
  "tmv_1052" DOUBLE,
  "honeyvolts" DOUBLE,
  "honeyinches" DOUBLE,
  "honey_cm" DOUBLE
);

F017–2013 06–14 CS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_06_14_cs_data

2.69 MB
64750 rows
31 columns


CREATE TABLE f017_2013_06_14_cs_data (
  "timestamp" TIMESTAMP,
  "record" BIGINT,
  "counter" BIGINT,
  "gpsyear" BIGINT,
  "gpsmonth" BIGINT,
  "gpsday" BIGINT,
  "gpshour" BIGINT,
  "gpsminute" BIGINT,
  "gpssecond" BIGINT,
  "batt_volt_min" DOUBLE,
  "rmc_lat" DOUBLE,
  "rmc_long" DOUBLE,
  "rmc_date" BIGINT,
  "rmc_utc" DOUBLE,
  "rmc_knots" DOUBLE,
  "gga_quality" BIGINT,
  "gga_sat" BIGINT,
  "ptemp" DOUBLE,
  "airtemp" DOUBLE,
  "targtemp_1022" DOUBLE,
  "targtemp_1023" DOUBLE,
  "targtemp_1052" DOUBLE,
  "sbtemp_1022" DOUBLE,
  "sbtemp_1023" DOUBLE,
  "sbtemp_1052" DOUBLE,
  "tmv_1022" DOUBLE,
  "tmv_1023" DOUBLE,
  "tmv_1052" DOUBLE,
  "honeyvolts" DOUBLE,
  "honeyinches" DOUBLE,
  "honey_cm" DOUBLE
);

F017–2013 06–19 CS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_06_19_cs_data

3.44 MB
92214 rows
31 columns


CREATE TABLE f017_2013_06_19_cs_data (
  "timestamp" TIMESTAMP,
  "record" BIGINT,
  "counter" BIGINT,
  "gpsyear" BIGINT,
  "gpsmonth" BIGINT,
  "gpsday" BIGINT,
  "gpshour" BIGINT,
  "gpsminute" BIGINT,
  "gpssecond" BIGINT,
  "batt_volt_min" DOUBLE,
  "rmc_lat" DOUBLE,
  "rmc_long" DOUBLE,
  "rmc_date" BIGINT,
  "rmc_utc" DOUBLE,
  "rmc_knots" DOUBLE,
  "gga_quality" BIGINT,
  "gga_sat" BIGINT,
  "ptemp" DOUBLE,
  "airtemp" DOUBLE,
  "targtemp_1022" DOUBLE,
  "targtemp_1023" DOUBLE,
  "targtemp_1052" DOUBLE,
  "sbtemp_1022" DOUBLE,
  "sbtemp_1023" DOUBLE,
  "sbtemp_1052" DOUBLE,
  "tmv_1022" DOUBLE,
  "tmv_1023" DOUBLE,
  "tmv_1052" DOUBLE,
  "honeyvolts" DOUBLE,
  "honeyinches" DOUBLE,
  "honey_cm" DOUBLE
);

F017–2013 06–26 CS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_06_26_cs_data

3.56 MB
76029 rows
31 columns


CREATE TABLE f017_2013_06_26_cs_data (
  "timestamp" TIMESTAMP,
  "record" BIGINT,
  "counter" BIGINT,
  "gpsyear" BIGINT,
  "gpsmonth" BIGINT,
  "gpsday" BIGINT,
  "gpshour" BIGINT,
  "gpsminute" BIGINT,
  "gpssecond" BIGINT,
  "batt_volt_min" DOUBLE,
  "rmc_lat" DOUBLE,
  "rmc_long" DOUBLE,
  "rmc_date" BIGINT,
  "rmc_utc" DOUBLE,
  "rmc_knots" DOUBLE,
  "gga_quality" BIGINT,
  "gga_sat" BIGINT,
  "ptemp" DOUBLE,
  "airtemp" DOUBLE,
  "targtemp_1022" DOUBLE,
  "targtemp_1023" DOUBLE,
  "targtemp_1052" DOUBLE,
  "sbtemp_1022" DOUBLE,
  "sbtemp_1023" DOUBLE,
  "sbtemp_1052" DOUBLE,
  "tmv_1022_avg" DOUBLE,
  "tmv_1023_avg" DOUBLE,
  "tmv_1052_avg" DOUBLE,
  "honeyvolts" DOUBLE,
  "honeyinches" DOUBLE,
  "honey_cm" DOUBLE
);

F017–2013 07–09 CS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_07_09_cs_data

5.45 MB
116509 rows
31 columns


CREATE TABLE f017_2013_07_09_cs_data (
  "timestamp" TIMESTAMP,
  "record" BIGINT,
  "counter" BIGINT,
  "gpsyear" BIGINT,
  "gpsmonth" BIGINT,
  "gpsday" BIGINT,
  "gpshour" BIGINT,
  "gpsminute" BIGINT,
  "gpssecond" BIGINT,
  "batt_volt_min" DOUBLE,
  "rmc_lat" DOUBLE,
  "rmc_long" DOUBLE,
  "rmc_date" BIGINT,
  "rmc_utc" DOUBLE,
  "rmc_knots" DOUBLE,
  "gga_quality" BIGINT,
  "gga_sat" BIGINT,
  "ptemp" DOUBLE,
  "airtemp" DOUBLE,
  "targtemp_1022" DOUBLE,
  "targtemp_1023" DOUBLE,
  "targtemp_1052" DOUBLE,
  "sbtemp_1022" DOUBLE,
  "sbtemp_1023" DOUBLE,
  "sbtemp_1052" DOUBLE,
  "tmv_1022_avg" DOUBLE,
  "tmv_1023_avg" DOUBLE,
  "tmv_1052_avg" DOUBLE,
  "honeyvolts" DOUBLE,
  "honeyinches" DOUBLE,
  "honey_cm" DOUBLE
);

F017–2013 07–19 CS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_07_19_cs_data

4.46 MB
101546 rows
31 columns


CREATE TABLE f017_2013_07_19_cs_data (
  "timestamp" TIMESTAMP,
  "record" BIGINT,
  "counter" BIGINT,
  "gpsyear" BIGINT,
  "gpsmonth" BIGINT,
  "gpsday" BIGINT,
  "gpshour" BIGINT,
  "gpsminute" BIGINT,
  "gpssecond" BIGINT,
  "batt_volt_min" DOUBLE,
  "rmc_lat" DOUBLE,
  "rmc_long" DOUBLE,
  "rmc_date" BIGINT,
  "rmc_utc" DOUBLE,
  "rmc_knots" DOUBLE,
  "gga_quality" BIGINT,
  "gga_sat" BIGINT,
  "ptemp" DOUBLE,
  "airtemp" DOUBLE,
  "targtemp_1022" DOUBLE,
  "targtemp_1023" DOUBLE,
  "targtemp_1052" DOUBLE,
  "sbtemp_1022" DOUBLE,
  "sbtemp_1023" DOUBLE,
  "sbtemp_1052" DOUBLE,
  "tmv_1022_avg" DOUBLE,
  "tmv_1023_avg" DOUBLE,
  "tmv_1052_avg" DOUBLE,
  "honeyvolts" DOUBLE,
  "honeyinches" DOUBLE,
  "honey_cm" DOUBLE
);

F017–2013 07–25 CS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_07_25_cs_data

4.03 MB
84974 rows
31 columns


CREATE TABLE f017_2013_07_25_cs_data (
  "timestamp" TIMESTAMP,
  "record" BIGINT,
  "counter" BIGINT,
  "gpsyear" BIGINT,
  "gpsmonth" BIGINT,
  "gpsday" BIGINT,
  "gpshour" BIGINT,
  "gpsminute" BIGINT,
  "gpssecond" BIGINT,
  "batt_volt_min" DOUBLE,
  "rmc_lat" DOUBLE,
  "rmc_long" DOUBLE,
  "rmc_date" BIGINT,
  "rmc_utc" DOUBLE,
  "rmc_knots" DOUBLE,
  "gga_quality" BIGINT,
  "gga_sat" BIGINT,
  "ptemp" DOUBLE,
  "airtemp" DOUBLE,
  "targtemp_1022" DOUBLE,
  "targtemp_1023" DOUBLE,
  "targtemp_1052" DOUBLE,
  "sbtemp_1022" DOUBLE,
  "sbtemp_1023" DOUBLE,
  "sbtemp_1052" DOUBLE,
  "tmv_1022_avg" DOUBLE,
  "tmv_1023_avg" DOUBLE,
  "tmv_1052_avg" DOUBLE,
  "honeyvolts" DOUBLE,
  "honeyinches" DOUBLE,
  "honey_cm" DOUBLE
);

F017–2013 08–05 CS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_08_05_cs_data

4.19 MB
97279 rows
31 columns


CREATE TABLE f017_2013_08_05_cs_data (
  "timestamp" TIMESTAMP,
  "record" BIGINT,
  "counter" BIGINT,
  "gpsyear" BIGINT,
  "gpsmonth" BIGINT,
  "gpsday" BIGINT,
  "gpshour" BIGINT,
  "gpsminute" BIGINT,
  "gpssecond" BIGINT,
  "batt_volt_min" DOUBLE,
  "rmc_lat" DOUBLE,
  "rmc_long" DOUBLE,
  "rmc_date" BIGINT,
  "rmc_utc" DOUBLE,
  "rmc_knots" DOUBLE,
  "gga_quality" BIGINT,
  "gga_sat" BIGINT,
  "ptemp" DOUBLE,
  "airtemp" DOUBLE,
  "targtemp_1022" DOUBLE,
  "targtemp_1023" DOUBLE,
  "targtemp_1052" DOUBLE,
  "sbtemp_1022" DOUBLE,
  "sbtemp_1023" DOUBLE,
  "sbtemp_1052" DOUBLE,
  "tmv_1022_avg" DOUBLE,
  "tmv_1023_avg" DOUBLE,
  "tmv_1052_avg" DOUBLE,
  "honeyvolts" DOUBLE,
  "honeyinches" DOUBLE,
  "honey_cm" DOUBLE
);

F017–2013 08–19 CS Data

@usgov.usda_gov_the_bronson_files_dataset_2_field_17_2013_86dfb.f017_2013_08_19_cs_data

4.09 MB
82230 rows
31 columns


CREATE TABLE f017_2013_08_19_cs_data (
  "timestamp" TIMESTAMP,
  "record" BIGINT,
  "counter" BIGINT,
  "gpsyear" BIGINT,
  "gpsmonth" BIGINT,
  "gpsday" BIGINT,
  "gpshour" BIGINT,
  "gpsminute" BIGINT,
  "gpssecond" BIGINT,
  "batt_volt_min" DOUBLE,
  "rmc_lat" DOUBLE,
  "rmc_long" DOUBLE,
  "rmc_date" BIGINT,
  "rmc_utc" DOUBLE,
  "rmc_knots" DOUBLE,
  "gga_quality" BIGINT,
  "gga_sat" BIGINT,
  "ptemp" DOUBLE,
  "airtemp" DOUBLE,
  "targtemp_1022" DOUBLE,
  "targtemp_1023" DOUBLE,
  "targtemp_1052" DOUBLE,
  "sbtemp_1022" DOUBLE,
  "sbtemp_1023" DOUBLE,
  "sbtemp_1052" DOUBLE,
  "tmv_1022_avg" DOUBLE,
  "tmv_1023_avg" DOUBLE,
  "tmv_1052_avg" DOUBLE,
  "honeyvolts" DOUBLE,
  "honeyinches" DOUBLE,
  "honey_cm" DOUBLE
);