Daylight Characteristics Across Locations
Spectral Irradiance Measurements
@kaggle.thedevastator_daylight_characteristics_across_locations
Spectral Irradiance Measurements
@kaggle.thedevastator_daylight_characteristics_across_locations
CREATE TABLE daylight_differentlocations_v1_2 (
"unnamed_0" VARCHAR,
"info" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"data" VARCHAR,
"unnamed_10" VARCHAR,
"spectral_irradiance_w_m_2nm_1" VARCHAR,
"unnamed_12" DOUBLE,
"unnamed_13" DOUBLE,
"unnamed_14" DOUBLE,
"unnamed_15" DOUBLE,
"unnamed_16" DOUBLE,
"unnamed_17" DOUBLE,
"unnamed_18" DOUBLE,
"unnamed_19" DOUBLE,
"unnamed_20" DOUBLE,
"unnamed_21" DOUBLE,
"unnamed_22" DOUBLE,
"unnamed_23" DOUBLE,
"unnamed_24" DOUBLE,
"unnamed_25" DOUBLE,
"unnamed_26" DOUBLE,
"unnamed_27" DOUBLE,
"unnamed_28" DOUBLE,
"unnamed_29" DOUBLE,
"unnamed_30" DOUBLE,
"unnamed_31" DOUBLE,
"unnamed_32" DOUBLE,
"unnamed_33" DOUBLE,
"unnamed_34" DOUBLE,
"unnamed_35" DOUBLE,
"unnamed_36" DOUBLE,
"unnamed_37" DOUBLE,
"unnamed_38" DOUBLE,
"unnamed_39" DOUBLE,
"unnamed_40" DOUBLE,
"unnamed_41" DOUBLE,
"unnamed_42" DOUBLE,
"unnamed_43" DOUBLE,
"unnamed_44" DOUBLE,
"unnamed_45" DOUBLE,
"unnamed_46" DOUBLE,
"unnamed_47" DOUBLE,
"unnamed_48" DOUBLE,
"unnamed_49" DOUBLE,
"unnamed_50" DOUBLE,
"unnamed_51" DOUBLE,
"unnamed_52" DOUBLE,
"unnamed_53" DOUBLE,
"unnamed_54" DOUBLE,
"unnamed_55" DOUBLE,
"unnamed_56" DOUBLE,
"unnamed_57" DOUBLE,
"unnamed_58" DOUBLE,
"unnamed_59" DOUBLE,
"unnamed_60" DOUBLE,
"unnamed_61" DOUBLE,
"unnamed_62" DOUBLE,
"unnamed_63" DOUBLE,
"unnamed_64" DOUBLE,
"unnamed_65" DOUBLE,
"unnamed_66" DOUBLE,
"unnamed_67" DOUBLE,
"unnamed_68" DOUBLE,
"unnamed_69" DOUBLE,
"unnamed_70" DOUBLE,
"unnamed_71" DOUBLE,
"unnamed_72" DOUBLE,
"unnamed_73" DOUBLE,
"unnamed_74" DOUBLE,
"unnamed_75" DOUBLE,
"unnamed_76" DOUBLE,
"unnamed_77" DOUBLE,
"unnamed_78" DOUBLE,
"unnamed_79" DOUBLE,
"unnamed_80" DOUBLE,
"unnamed_81" DOUBLE,
"unnamed_82" DOUBLE,
"unnamed_83" DOUBLE,
"unnamed_84" DOUBLE,
"unnamed_85" DOUBLE,
"unnamed_86" DOUBLE,
"unnamed_87" DOUBLE,
"unnamed_88" DOUBLE,
"unnamed_89" DOUBLE,
"unnamed_90" DOUBLE,
"unnamed_91" DOUBLE,
"unnamed_92" DOUBLE,
"unnamed_93" DOUBLE,
"unnamed_94" DOUBLE,
"unnamed_95" DOUBLE,
"unnamed_96" DOUBLE,
"unnamed_97" DOUBLE,
"unnamed_98" DOUBLE,
"unnamed_99" DOUBLE
);
CREATE TABLE daylight_timelapse_v1_2 (
"unnamed_0" VARCHAR,
"info" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"data" VARCHAR,
"unnamed_9" VARCHAR,
"spectral_radiance_w_sr_1m_2nm_1" VARCHAR,
"unnamed_11" DOUBLE,
"unnamed_12" DOUBLE,
"unnamed_13" DOUBLE,
"unnamed_14" DOUBLE,
"unnamed_15" DOUBLE,
"unnamed_16" DOUBLE,
"unnamed_17" DOUBLE,
"unnamed_18" DOUBLE,
"unnamed_19" DOUBLE,
"unnamed_20" DOUBLE,
"unnamed_21" DOUBLE,
"unnamed_22" DOUBLE,
"unnamed_23" DOUBLE,
"unnamed_24" DOUBLE,
"unnamed_25" DOUBLE,
"unnamed_26" DOUBLE,
"unnamed_27" DOUBLE,
"unnamed_28" DOUBLE,
"unnamed_29" DOUBLE,
"unnamed_30" DOUBLE,
"unnamed_31" DOUBLE,
"unnamed_32" DOUBLE,
"unnamed_33" DOUBLE,
"unnamed_34" DOUBLE,
"unnamed_35" DOUBLE,
"unnamed_36" DOUBLE,
"unnamed_37" DOUBLE,
"unnamed_38" DOUBLE,
"unnamed_39" DOUBLE,
"unnamed_40" DOUBLE,
"unnamed_41" DOUBLE,
"unnamed_42" DOUBLE,
"unnamed_43" DOUBLE,
"unnamed_44" DOUBLE,
"unnamed_45" DOUBLE,
"unnamed_46" DOUBLE,
"unnamed_47" DOUBLE,
"unnamed_48" DOUBLE,
"unnamed_49" DOUBLE,
"unnamed_50" DOUBLE,
"unnamed_51" DOUBLE,
"unnamed_52" DOUBLE,
"unnamed_53" DOUBLE,
"unnamed_54" DOUBLE,
"unnamed_55" DOUBLE,
"unnamed_56" DOUBLE,
"unnamed_57" DOUBLE,
"unnamed_58" DOUBLE,
"unnamed_59" DOUBLE,
"unnamed_60" DOUBLE,
"unnamed_61" DOUBLE,
"unnamed_62" DOUBLE,
"unnamed_63" DOUBLE,
"unnamed_64" DOUBLE,
"unnamed_65" DOUBLE,
"unnamed_66" DOUBLE,
"unnamed_67" DOUBLE,
"unnamed_68" DOUBLE,
"unnamed_69" DOUBLE,
"unnamed_70" DOUBLE,
"unnamed_71" DOUBLE,
"unnamed_72" DOUBLE,
"unnamed_73" DOUBLE,
"unnamed_74" DOUBLE,
"unnamed_75" DOUBLE,
"unnamed_76" DOUBLE,
"unnamed_77" DOUBLE,
"unnamed_78" DOUBLE,
"unnamed_79" DOUBLE,
"unnamed_80" DOUBLE,
"unnamed_81" DOUBLE,
"unnamed_82" DOUBLE,
"unnamed_83" DOUBLE,
"unnamed_84" DOUBLE,
"unnamed_85" DOUBLE,
"unnamed_86" DOUBLE,
"unnamed_87" DOUBLE,
"unnamed_88" DOUBLE,
"unnamed_89" DOUBLE,
"unnamed_90" DOUBLE,
"unnamed_91" DOUBLE,
"unnamed_92" DOUBLE,
"unnamed_93" DOUBLE,
"unnamed_94" DOUBLE,
"unnamed_95" DOUBLE,
"unnamed_96" DOUBLE,
"unnamed_97" DOUBLE,
"unnamed_98" DOUBLE,
"unnamed_99" DOUBLE
);
CREATE TABLE reflectance_v1_1 (
"category" VARCHAR,
"scientific_name" VARCHAR,
"used_in_analysis" VARCHAR,
"date" TIMESTAMP,
"n_380_nm" DOUBLE,
"n_385" DOUBLE,
"n_390" DOUBLE,
"n_395" DOUBLE,
"n_400" DOUBLE,
"n_405" DOUBLE,
"n_410" DOUBLE,
"n_415" DOUBLE,
"n_420" DOUBLE,
"n_425" DOUBLE,
"n_430" DOUBLE,
"n_435" DOUBLE,
"n_440" DOUBLE,
"n_445" DOUBLE,
"n_450" DOUBLE,
"n_455" DOUBLE,
"n_460" DOUBLE,
"n_465" DOUBLE,
"n_470" DOUBLE,
"n_475" DOUBLE,
"n_480" DOUBLE,
"n_485" DOUBLE,
"n_490" DOUBLE,
"n_495" DOUBLE,
"n_500" DOUBLE,
"n_505" DOUBLE,
"n_510" DOUBLE,
"n_515" DOUBLE,
"n_520" DOUBLE,
"n_525" DOUBLE,
"n_530" DOUBLE,
"n_535" DOUBLE,
"n_540" DOUBLE,
"n_545" DOUBLE,
"n_550" DOUBLE,
"n_555" DOUBLE,
"n_560" DOUBLE,
"n_565" DOUBLE,
"n_570" DOUBLE,
"n_575" DOUBLE,
"n_580" DOUBLE,
"n_585" DOUBLE,
"n_590" DOUBLE,
"n_595" DOUBLE,
"n_600" DOUBLE,
"n_605" DOUBLE,
"n_610" DOUBLE,
"n_615" DOUBLE,
"n_620" DOUBLE,
"n_625" DOUBLE,
"n_630" DOUBLE,
"n_635" DOUBLE,
"n_640" DOUBLE,
"n_645" DOUBLE,
"n_650" DOUBLE,
"n_655" DOUBLE,
"n_660" DOUBLE,
"n_665" DOUBLE,
"n_670" DOUBLE,
"n_675" DOUBLE,
"n_680" DOUBLE,
"n_685" DOUBLE,
"n_690" DOUBLE,
"n_695" DOUBLE,
"n_700" DOUBLE,
"n_705" DOUBLE,
"n_710" DOUBLE,
"n_715" DOUBLE,
"n_720" DOUBLE,
"n_725" DOUBLE,
"n_730" DOUBLE,
"n_735" DOUBLE,
"n_740" DOUBLE,
"n_745" DOUBLE,
"n_750" DOUBLE,
"n_755" DOUBLE,
"n_760" DOUBLE,
"n_765" DOUBLE,
"n_770" DOUBLE,
"n_775" DOUBLE,
"n_780" DOUBLE
);
CREATE TABLE reflectance_v1_2 (
"category" VARCHAR,
"scientific_name" VARCHAR,
"used_in_analysis" VARCHAR,
"date" TIMESTAMP,
"n_380_nm" DOUBLE,
"n_385" DOUBLE,
"n_390" DOUBLE,
"n_395" DOUBLE,
"n_400" DOUBLE,
"n_405" DOUBLE,
"n_410" DOUBLE,
"n_415" DOUBLE,
"n_420" DOUBLE,
"n_425" DOUBLE,
"n_430" DOUBLE,
"n_435" DOUBLE,
"n_440" DOUBLE,
"n_445" DOUBLE,
"n_450" DOUBLE,
"n_455" DOUBLE,
"n_460" DOUBLE,
"n_465" DOUBLE,
"n_470" DOUBLE,
"n_475" DOUBLE,
"n_480" DOUBLE,
"n_485" DOUBLE,
"n_490" DOUBLE,
"n_495" DOUBLE,
"n_500" DOUBLE,
"n_505" DOUBLE,
"n_510" DOUBLE,
"n_515" DOUBLE,
"n_520" DOUBLE,
"n_525" DOUBLE,
"n_530" DOUBLE,
"n_535" DOUBLE,
"n_540" DOUBLE,
"n_545" DOUBLE,
"n_550" DOUBLE,
"n_555" DOUBLE,
"n_560" DOUBLE,
"n_565" DOUBLE,
"n_570" DOUBLE,
"n_575" DOUBLE,
"n_580" DOUBLE,
"n_585" DOUBLE,
"n_590" DOUBLE,
"n_595" DOUBLE,
"n_600" DOUBLE,
"n_605" DOUBLE,
"n_610" DOUBLE,
"n_615" DOUBLE,
"n_620" DOUBLE,
"n_625" DOUBLE,
"n_630" DOUBLE,
"n_635" DOUBLE,
"n_640" DOUBLE,
"n_645" DOUBLE,
"n_650" DOUBLE,
"n_655" DOUBLE,
"n_660" DOUBLE,
"n_665" DOUBLE,
"n_670" DOUBLE,
"n_675" DOUBLE,
"n_680" DOUBLE,
"n_685" DOUBLE,
"n_690" DOUBLE,
"n_695" DOUBLE,
"n_700" DOUBLE,
"n_705" DOUBLE,
"n_710" DOUBLE,
"n_715" DOUBLE,
"n_720" DOUBLE,
"n_725" DOUBLE,
"n_730" DOUBLE,
"n_735" DOUBLE,
"n_740" DOUBLE,
"n_745" DOUBLE,
"n_750" DOUBLE,
"n_755" DOUBLE,
"n_760" DOUBLE,
"n_765" DOUBLE,
"n_770" DOUBLE,
"n_775" DOUBLE,
"n_780" DOUBLE
);
CREATE TABLE transmittance_backsideup (
"scientific_name" VARCHAR,
"date" VARCHAR,
"n_380_nm" DOUBLE,
"n_385" DOUBLE,
"n_390" DOUBLE,
"n_395" DOUBLE,
"n_400" DOUBLE,
"n_405" DOUBLE,
"n_410" DOUBLE,
"n_415" DOUBLE,
"n_420" DOUBLE,
"n_425" DOUBLE,
"n_430" DOUBLE,
"n_435" DOUBLE,
"n_440" DOUBLE,
"n_445" DOUBLE,
"n_450" DOUBLE,
"n_455" DOUBLE,
"n_460" DOUBLE,
"n_465" DOUBLE,
"n_470" DOUBLE,
"n_475" DOUBLE,
"n_480" DOUBLE,
"n_485" DOUBLE,
"n_490" DOUBLE,
"n_495" DOUBLE,
"n_500" DOUBLE,
"n_505" DOUBLE,
"n_510" DOUBLE,
"n_515" DOUBLE,
"n_520" DOUBLE,
"n_525" DOUBLE,
"n_530" DOUBLE,
"n_535" DOUBLE,
"n_540" DOUBLE,
"n_545" DOUBLE,
"n_550" DOUBLE,
"n_555" DOUBLE,
"n_560" DOUBLE,
"n_565" DOUBLE,
"n_570" DOUBLE,
"n_575" DOUBLE,
"n_580" DOUBLE,
"n_585" DOUBLE,
"n_590" DOUBLE,
"n_595" DOUBLE,
"n_600" DOUBLE,
"n_605" DOUBLE,
"n_610" DOUBLE,
"n_615" DOUBLE,
"n_620" DOUBLE,
"n_625" DOUBLE,
"n_630" DOUBLE,
"n_635" DOUBLE,
"n_640" DOUBLE,
"n_645" DOUBLE,
"n_650" DOUBLE,
"n_655" DOUBLE,
"n_660" DOUBLE,
"n_665" DOUBLE,
"n_670" DOUBLE,
"n_675" DOUBLE,
"n_680" DOUBLE,
"n_685" DOUBLE,
"n_690" DOUBLE,
"n_695" DOUBLE,
"n_700" DOUBLE,
"n_705" DOUBLE,
"n_710" DOUBLE,
"n_715" DOUBLE,
"n_720" DOUBLE,
"n_725" DOUBLE,
"n_730" DOUBLE,
"n_735" DOUBLE,
"n_740" DOUBLE,
"n_745" DOUBLE,
"n_750" DOUBLE,
"n_755" DOUBLE,
"n_760" DOUBLE,
"n_765" DOUBLE,
"n_770" DOUBLE,
"n_775" DOUBLE,
"n_780" DOUBLE
);
CREATE TABLE transmittance_backsideup_v1_1 (
"scientific_name" VARCHAR,
"date" VARCHAR,
"n_380_nm" DOUBLE,
"n_385" DOUBLE,
"n_390" DOUBLE,
"n_395" DOUBLE,
"n_400" DOUBLE,
"n_405" DOUBLE,
"n_410" DOUBLE,
"n_415" DOUBLE,
"n_420" DOUBLE,
"n_425" DOUBLE,
"n_430" DOUBLE,
"n_435" DOUBLE,
"n_440" DOUBLE,
"n_445" DOUBLE,
"n_450" DOUBLE,
"n_455" DOUBLE,
"n_460" DOUBLE,
"n_465" DOUBLE,
"n_470" DOUBLE,
"n_475" DOUBLE,
"n_480" DOUBLE,
"n_485" DOUBLE,
"n_490" DOUBLE,
"n_495" DOUBLE,
"n_500" DOUBLE,
"n_505" DOUBLE,
"n_510" DOUBLE,
"n_515" DOUBLE,
"n_520" DOUBLE,
"n_525" DOUBLE,
"n_530" DOUBLE,
"n_535" DOUBLE,
"n_540" DOUBLE,
"n_545" DOUBLE,
"n_550" DOUBLE,
"n_555" DOUBLE,
"n_560" DOUBLE,
"n_565" DOUBLE,
"n_570" DOUBLE,
"n_575" DOUBLE,
"n_580" DOUBLE,
"n_585" DOUBLE,
"n_590" DOUBLE,
"n_595" DOUBLE,
"n_600" DOUBLE,
"n_605" DOUBLE,
"n_610" DOUBLE,
"n_615" DOUBLE,
"n_620" DOUBLE,
"n_625" DOUBLE,
"n_630" DOUBLE,
"n_635" DOUBLE,
"n_640" DOUBLE,
"n_645" DOUBLE,
"n_650" DOUBLE,
"n_655" DOUBLE,
"n_660" DOUBLE,
"n_665" DOUBLE,
"n_670" DOUBLE,
"n_675" DOUBLE,
"n_680" DOUBLE,
"n_685" DOUBLE,
"n_690" DOUBLE,
"n_695" DOUBLE,
"n_700" DOUBLE,
"n_705" DOUBLE,
"n_710" DOUBLE,
"n_715" DOUBLE,
"n_720" DOUBLE,
"n_725" DOUBLE,
"n_730" DOUBLE,
"n_735" DOUBLE,
"n_740" DOUBLE,
"n_745" DOUBLE,
"n_750" DOUBLE,
"n_755" DOUBLE,
"n_760" DOUBLE,
"n_765" DOUBLE,
"n_770" DOUBLE,
"n_775" DOUBLE,
"n_780" DOUBLE
);
CREATE TABLE transmittance_backsideup_v1_2 (
"scientific_name" VARCHAR,
"date" VARCHAR,
"n_380_nm" DOUBLE,
"n_385" DOUBLE,
"n_390" DOUBLE,
"n_395" DOUBLE,
"n_400" DOUBLE,
"n_405" DOUBLE,
"n_410" DOUBLE,
"n_415" DOUBLE,
"n_420" DOUBLE,
"n_425" DOUBLE,
"n_430" DOUBLE,
"n_435" DOUBLE,
"n_440" DOUBLE,
"n_445" DOUBLE,
"n_450" DOUBLE,
"n_455" DOUBLE,
"n_460" DOUBLE,
"n_465" DOUBLE,
"n_470" DOUBLE,
"n_475" DOUBLE,
"n_480" DOUBLE,
"n_485" DOUBLE,
"n_490" DOUBLE,
"n_495" DOUBLE,
"n_500" DOUBLE,
"n_505" DOUBLE,
"n_510" DOUBLE,
"n_515" DOUBLE,
"n_520" DOUBLE,
"n_525" DOUBLE,
"n_530" DOUBLE,
"n_535" DOUBLE,
"n_540" DOUBLE,
"n_545" DOUBLE,
"n_550" DOUBLE,
"n_555" DOUBLE,
"n_560" DOUBLE,
"n_565" DOUBLE,
"n_570" DOUBLE,
"n_575" DOUBLE,
"n_580" DOUBLE,
"n_585" DOUBLE,
"n_590" DOUBLE,
"n_595" DOUBLE,
"n_600" DOUBLE,
"n_605" DOUBLE,
"n_610" DOUBLE,
"n_615" DOUBLE,
"n_620" DOUBLE,
"n_625" DOUBLE,
"n_630" DOUBLE,
"n_635" DOUBLE,
"n_640" DOUBLE,
"n_645" DOUBLE,
"n_650" DOUBLE,
"n_655" DOUBLE,
"n_660" DOUBLE,
"n_665" DOUBLE,
"n_670" DOUBLE,
"n_675" DOUBLE,
"n_680" DOUBLE,
"n_685" DOUBLE,
"n_690" DOUBLE,
"n_695" DOUBLE,
"n_700" DOUBLE,
"n_705" DOUBLE,
"n_710" DOUBLE,
"n_715" DOUBLE,
"n_720" DOUBLE,
"n_725" DOUBLE,
"n_730" DOUBLE,
"n_735" DOUBLE,
"n_740" DOUBLE,
"n_745" DOUBLE,
"n_750" DOUBLE,
"n_755" DOUBLE,
"n_760" DOUBLE,
"n_765" DOUBLE,
"n_770" DOUBLE,
"n_775" DOUBLE,
"n_780" DOUBLE
);
CREATE TABLE transmittance_frontsideup (
"scientific_name" VARCHAR,
"date" VARCHAR,
"n_380_nm" DOUBLE,
"n_385" DOUBLE,
"n_390" DOUBLE,
"n_395" DOUBLE,
"n_400" DOUBLE,
"n_405" DOUBLE,
"n_410" DOUBLE,
"n_415" DOUBLE,
"n_420" DOUBLE,
"n_425" DOUBLE,
"n_430" DOUBLE,
"n_435" DOUBLE,
"n_440" DOUBLE,
"n_445" DOUBLE,
"n_450" DOUBLE,
"n_455" DOUBLE,
"n_460" DOUBLE,
"n_465" DOUBLE,
"n_470" DOUBLE,
"n_475" DOUBLE,
"n_480" DOUBLE,
"n_485" DOUBLE,
"n_490" DOUBLE,
"n_495" DOUBLE,
"n_500" DOUBLE,
"n_505" DOUBLE,
"n_510" DOUBLE,
"n_515" DOUBLE,
"n_520" DOUBLE,
"n_525" DOUBLE,
"n_530" DOUBLE,
"n_535" DOUBLE,
"n_540" DOUBLE,
"n_545" DOUBLE,
"n_550" DOUBLE,
"n_555" DOUBLE,
"n_560" DOUBLE,
"n_565" DOUBLE,
"n_570" DOUBLE,
"n_575" DOUBLE,
"n_580" DOUBLE,
"n_585" DOUBLE,
"n_590" DOUBLE,
"n_595" DOUBLE,
"n_600" DOUBLE,
"n_605" DOUBLE,
"n_610" DOUBLE,
"n_615" DOUBLE,
"n_620" DOUBLE,
"n_625" DOUBLE,
"n_630" DOUBLE,
"n_635" DOUBLE,
"n_640" DOUBLE,
"n_645" DOUBLE,
"n_650" DOUBLE,
"n_655" DOUBLE,
"n_660" DOUBLE,
"n_665" DOUBLE,
"n_670" DOUBLE,
"n_675" DOUBLE,
"n_680" DOUBLE,
"n_685" DOUBLE,
"n_690" DOUBLE,
"n_695" DOUBLE,
"n_700" DOUBLE,
"n_705" DOUBLE,
"n_710" DOUBLE,
"n_715" DOUBLE,
"n_720" DOUBLE,
"n_725" DOUBLE,
"n_730" DOUBLE,
"n_735" DOUBLE,
"n_740" DOUBLE,
"n_745" DOUBLE,
"n_750" DOUBLE,
"n_755" DOUBLE,
"n_760" DOUBLE,
"n_765" DOUBLE,
"n_770" DOUBLE,
"n_775" DOUBLE,
"n_780" DOUBLE
);
CREATE TABLE transmittance_frontsideup_v1_1 (
"scientific_name" VARCHAR,
"date" VARCHAR,
"n_380_nm" DOUBLE,
"n_385" DOUBLE,
"n_390" DOUBLE,
"n_395" DOUBLE,
"n_400" DOUBLE,
"n_405" DOUBLE,
"n_410" DOUBLE,
"n_415" DOUBLE,
"n_420" DOUBLE,
"n_425" DOUBLE,
"n_430" DOUBLE,
"n_435" DOUBLE,
"n_440" DOUBLE,
"n_445" DOUBLE,
"n_450" DOUBLE,
"n_455" DOUBLE,
"n_460" DOUBLE,
"n_465" DOUBLE,
"n_470" DOUBLE,
"n_475" DOUBLE,
"n_480" DOUBLE,
"n_485" DOUBLE,
"n_490" DOUBLE,
"n_495" DOUBLE,
"n_500" DOUBLE,
"n_505" DOUBLE,
"n_510" DOUBLE,
"n_515" DOUBLE,
"n_520" DOUBLE,
"n_525" DOUBLE,
"n_530" DOUBLE,
"n_535" DOUBLE,
"n_540" DOUBLE,
"n_545" DOUBLE,
"n_550" DOUBLE,
"n_555" DOUBLE,
"n_560" DOUBLE,
"n_565" DOUBLE,
"n_570" DOUBLE,
"n_575" DOUBLE,
"n_580" DOUBLE,
"n_585" DOUBLE,
"n_590" DOUBLE,
"n_595" DOUBLE,
"n_600" DOUBLE,
"n_605" DOUBLE,
"n_610" DOUBLE,
"n_615" DOUBLE,
"n_620" DOUBLE,
"n_625" DOUBLE,
"n_630" DOUBLE,
"n_635" DOUBLE,
"n_640" DOUBLE,
"n_645" DOUBLE,
"n_650" DOUBLE,
"n_655" DOUBLE,
"n_660" DOUBLE,
"n_665" DOUBLE,
"n_670" DOUBLE,
"n_675" DOUBLE,
"n_680" DOUBLE,
"n_685" DOUBLE,
"n_690" DOUBLE,
"n_695" DOUBLE,
"n_700" DOUBLE,
"n_705" DOUBLE,
"n_710" DOUBLE,
"n_715" DOUBLE,
"n_720" DOUBLE,
"n_725" DOUBLE,
"n_730" DOUBLE,
"n_735" DOUBLE,
"n_740" DOUBLE,
"n_745" DOUBLE,
"n_750" DOUBLE,
"n_755" DOUBLE,
"n_760" DOUBLE,
"n_765" DOUBLE,
"n_770" DOUBLE,
"n_775" DOUBLE,
"n_780" DOUBLE
);
CREATE TABLE transmittance_frontsideup_v1_2 (
"scientific_name" VARCHAR,
"date" VARCHAR,
"n_380_nm" DOUBLE,
"n_385" DOUBLE,
"n_390" DOUBLE,
"n_395" DOUBLE,
"n_400" DOUBLE,
"n_405" DOUBLE,
"n_410" DOUBLE,
"n_415" DOUBLE,
"n_420" DOUBLE,
"n_425" DOUBLE,
"n_430" DOUBLE,
"n_435" DOUBLE,
"n_440" DOUBLE,
"n_445" DOUBLE,
"n_450" DOUBLE,
"n_455" DOUBLE,
"n_460" DOUBLE,
"n_465" DOUBLE,
"n_470" DOUBLE,
"n_475" DOUBLE,
"n_480" DOUBLE,
"n_485" DOUBLE,
"n_490" DOUBLE,
"n_495" DOUBLE,
"n_500" DOUBLE,
"n_505" DOUBLE,
"n_510" DOUBLE,
"n_515" DOUBLE,
"n_520" DOUBLE,
"n_525" DOUBLE,
"n_530" DOUBLE,
"n_535" DOUBLE,
"n_540" DOUBLE,
"n_545" DOUBLE,
"n_550" DOUBLE,
"n_555" DOUBLE,
"n_560" DOUBLE,
"n_565" DOUBLE,
"n_570" DOUBLE,
"n_575" DOUBLE,
"n_580" DOUBLE,
"n_585" DOUBLE,
"n_590" DOUBLE,
"n_595" DOUBLE,
"n_600" DOUBLE,
"n_605" DOUBLE,
"n_610" DOUBLE,
"n_615" DOUBLE,
"n_620" DOUBLE,
"n_625" DOUBLE,
"n_630" DOUBLE,
"n_635" DOUBLE,
"n_640" DOUBLE,
"n_645" DOUBLE,
"n_650" DOUBLE,
"n_655" DOUBLE,
"n_660" DOUBLE,
"n_665" DOUBLE,
"n_670" DOUBLE,
"n_675" DOUBLE,
"n_680" DOUBLE,
"n_685" DOUBLE,
"n_690" DOUBLE,
"n_695" DOUBLE,
"n_700" DOUBLE,
"n_705" DOUBLE,
"n_710" DOUBLE,
"n_715" DOUBLE,
"n_720" DOUBLE,
"n_725" DOUBLE,
"n_730" DOUBLE,
"n_735" DOUBLE,
"n_740" DOUBLE,
"n_745" DOUBLE,
"n_750" DOUBLE,
"n_755" DOUBLE,
"n_760" DOUBLE,
"n_765" DOUBLE,
"n_770" DOUBLE,
"n_775" DOUBLE,
"n_780" DOUBLE
);
Anyone who has the link will be able to view this.