High-Resolution Floating Solar PV Data
Department of Energy
@usgov.doe_gov_high_resolution_floating_solar_pv_data
Department of Energy
@usgov.doe_gov_high_resolution_floating_solar_pv_data
CREATE TABLE floating_pv_altamonte_fl_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"acpwrt" DOUBLE,
"dcvolt" DOUBLE,
"resist" DOUBLE,
"temper" DOUBLE,
"vl1to2" DOUBLE,
"vl2to3" DOUBLE,
"vl3to1" DOUBLE,
"accur1" DOUBLE,
"accur2" DOUBLE,
"accur3" DOUBLE,
"acvlt1" DOUBLE,
"acvlt2" DOUBLE,
"acvlt3" DOUBLE,
"acfrq1" DOUBLE,
"acfrq2" DOUBLE,
"acfrq3" DOUBLE,
"appwr1" DOUBLE,
"appwr2" DOUBLE,
"appwr3" DOUBLE,
"acpwr1" DOUBLE,
"acpwr2" DOUBLE,
"acpwr3" DOUBLE,
"repwr1" DOUBLE,
"repwr2" DOUBLE,
"repwr3" DOUBLE,
"fsbatt" DOUBLE,
"fstemp" DOUBLE,
"nwptma" DOUBLE,
"nwptmb" DOUBLE,
"nwptmc" DOUBLE,
"swptma" DOUBLE,
"swptmb" DOUBLE,
"swptmc" DOUBLE,
"septma" DOUBLE,
"septmb" DOUBLE,
"septmc" DOUBLE,
"neptma" DOUBLE,
"neptmb" DOUBLE,
"neptmc" DOUBLE,
"mdptma" DOUBLE,
"mdptmb" DOUBLE,
"mdptmc" DOUBLE,
"fpoai1" DOUBLE,
"fpoai2" DOUBLE,
"fspirr" DOUBLE,
"wtplow" DOUBLE,
"wtpmid" DOUBLE,
"wtpdep" DOUBLE,
"fpvdbt" DOUBLE,
"fpv_rh" DOUBLE,
"frairp" DOUBLE,
"fwinda" DOUBLE,
"fwindm" DOUBLE,
"fwindv" DOUBLE,
"frsrvd" DOUBLE,
"fprect" DOUBLE,
"fpreci" DOUBLE,
"fdptmp" DOUBLE,
"fwctmp" DOUBLE,
"fprecd" DOUBLE,
"fwndac" DOUBLE,
"fwndmn" DOUBLE,
"fwndvt" DOUBLE,
"fpvwbt" DOUBLE,
"fwdira" DOUBLE,
"fwdirn" DOUBLE,
"fwdirx" DOUBLE,
"fenthp" DOUBLE,
"sparf1" DOUBLE,
"sparf2" DOUBLE,
"sparf3" DOUBLE,
"lsbatt" DOUBLE,
"lstemp" DOUBLE,
"lpvdbt" DOUBLE,
"lpv_rh" DOUBLE,
"lrairp" DOUBLE,
"lwinda" DOUBLE,
"lwindm" DOUBLE,
"lwindv" DOUBLE,
"lrsrvd" DOUBLE,
"lprect" DOUBLE,
"lpreci" DOUBLE,
"ldptmp" DOUBLE,
"lwctmp" DOUBLE,
"lprecd" DOUBLE,
"lwndac" DOUBLE,
"lwndmn" DOUBLE,
"lwndvt" DOUBLE,
"lpvwbt" DOUBLE,
"lwdira" DOUBLE,
"lwdirn" DOUBLE,
"lwdirx" DOUBLE,
"lenthp" DOUBLE,
"lhzirr" DOUBLE,
"sparl1" DOUBLE,
"sparl2" DOUBLE,
"sparl3" DOUBLE
);
CREATE TABLE floating_pv_oakville_ca_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"fsbatt" DOUBLE,
"fstemp" DOUBLE,
"septma" DOUBLE,
"septmb" DOUBLE,
"septmc" DOUBLE,
"swptma" DOUBLE,
"swptmb" DOUBLE,
"swptmc" DOUBLE,
"mdptma" DOUBLE,
"mdptmb" DOUBLE,
"mdptmc" DOUBLE,
"nwptma" DOUBLE,
"nwptmb" DOUBLE,
"nwptmc" DOUBLE,
"neptma" DOUBLE,
"neptmb" DOUBLE,
"neptmc" DOUBLE,
"fhzirr" DOUBLE,
"fpairr" DOUBLE,
"frt1pt" DOUBLE,
"wtm1_5" DOUBLE,
"wtm5_0" DOUBLE,
"wtm10" DOUBLE,
"fpvdbt" DOUBLE,
"fpv_rh" DOUBLE,
"frairp" DOUBLE,
"fwinda" DOUBLE,
"fwindm" DOUBLE,
"fwindv" DOUBLE,
"frsrvd" DOUBLE,
"fprect" DOUBLE,
"fpreci" DOUBLE,
"fdptmp" DOUBLE,
"fwctmp" DOUBLE,
"fprecd" DOUBLE,
"fwndac" DOUBLE,
"fwndmn" DOUBLE,
"fwndvt" DOUBLE,
"fpvwbt" DOUBLE,
"fwdira" DOUBLE,
"fwdirn" DOUBLE,
"fwdirx" DOUBLE,
"fenthp" DOUBLE,
"sparf1" DOUBLE,
"sparf2" DOUBLE,
"sparf3" DOUBLE,
"lsbatt" DOUBLE,
"lstemp" DOUBLE,
"lhzirr" DOUBLE,
"lpairr" DOUBLE,
"lrt1pt" DOUBLE,
"lrtd01" DOUBLE,
"lrtd02" DOUBLE,
"lpvdbt" DOUBLE,
"lpv_rh" DOUBLE,
"lrairp" DOUBLE,
"lwinda" DOUBLE,
"lwindm" DOUBLE,
"lwindv" DOUBLE,
"lrsrvd" DOUBLE,
"lprect" DOUBLE,
"lpreci" DOUBLE,
"ldptmp" DOUBLE,
"lwctmp" DOUBLE,
"lprecd" DOUBLE,
"lwndac" DOUBLE,
"lwndmn" DOUBLE,
"lwndvt" DOUBLE,
"lpvwbt" DOUBLE,
"lwdira" DOUBLE,
"lwdirn" DOUBLE,
"lwdirx" DOUBLE,
"lenthp" DOUBLE,
"ltc_01" DOUBLE,
"ltc_02" DOUBLE,
"ltc_03" DOUBLE,
"gridvt" DOUBLE,
"gridct" DOUBLE,
"invpwr" DOUBLE,
"mppt1p" DOUBLE,
"mppt1v" DOUBLE,
"mppt1c" DOUBLE,
"mppt2p" DOUBLE,
"mppt2v" DOUBLE,
"mppt2c" DOUBLE,
"spar01" DOUBLE,
"spar02" DOUBLE,
"spar03" DOUBLE,
"spar04" DOUBLE,
"spar05" DOUBLE
);
CREATE TABLE floating_pv_oakville_ca_inverter_11_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"acpwrt" DOUBLE,
"dcvolt" DOUBLE,
"resist" DOUBLE,
"temper" DOUBLE,
"vl1to2" DOUBLE,
"vl2to3" DOUBLE,
"vl3to1" DOUBLE,
"accur1" DOUBLE,
"accur2" DOUBLE,
"accur3" DOUBLE,
"acvlt1" DOUBLE,
"acvlt2" DOUBLE,
"acvlt3" DOUBLE,
"acfrq1" DOUBLE,
"acfrq2" DOUBLE,
"acfrq3" DOUBLE,
"appwr1" DOUBLE,
"appwr2" DOUBLE,
"appwr3" DOUBLE,
"acpwr1" DOUBLE,
"acpwr2" DOUBLE,
"acpwr3" DOUBLE,
"repwr1" DOUBLE,
"repwr2" DOUBLE,
"repwr3" DOUBLE
);
CREATE TABLE floating_pv_oakville_ca_inverter_12_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"acpwrt" DOUBLE,
"dcvolt" DOUBLE,
"resist" DOUBLE,
"temper" DOUBLE,
"vl1to2" DOUBLE,
"vl2to3" DOUBLE,
"vl3to1" DOUBLE,
"accur1" DOUBLE,
"accur2" DOUBLE,
"accur3" DOUBLE,
"acvlt1" DOUBLE,
"acvlt2" DOUBLE,
"acvlt3" DOUBLE,
"acfrq1" DOUBLE,
"acfrq2" DOUBLE,
"acfrq3" DOUBLE,
"appwr1" DOUBLE,
"appwr2" DOUBLE,
"appwr3" DOUBLE,
"acpwr1" DOUBLE,
"acpwr2" DOUBLE,
"acpwr3" DOUBLE,
"repwr1" DOUBLE,
"repwr2" DOUBLE,
"repwr3" DOUBLE
);
CREATE TABLE floating_pv_oakville_ca_inverter_1_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"acpwrt" DOUBLE,
"dcvolt" DOUBLE,
"resist" DOUBLE,
"temper" DOUBLE,
"vl1to2" DOUBLE,
"vl2to3" DOUBLE,
"vl3to1" DOUBLE,
"accur1" DOUBLE,
"accur2" DOUBLE,
"accur3" DOUBLE,
"acvlt1" DOUBLE,
"acvlt2" DOUBLE,
"acvlt3" DOUBLE,
"acfrq1" DOUBLE,
"acfrq2" DOUBLE,
"acfrq3" DOUBLE,
"appwr1" DOUBLE,
"appwr2" DOUBLE,
"appwr3" DOUBLE,
"acpwr1" DOUBLE,
"acpwr2" DOUBLE,
"acpwr3" DOUBLE,
"repwr1" DOUBLE,
"repwr2" DOUBLE,
"repwr3" DOUBLE
);
CREATE TABLE floating_pv_oakville_ca_inverter_2_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"acpwrt" DOUBLE,
"dcvolt" DOUBLE,
"resist" DOUBLE,
"temper" DOUBLE,
"vl1to2" DOUBLE,
"vl2to3" DOUBLE,
"vl3to1" DOUBLE,
"accur1" DOUBLE,
"accur2" DOUBLE,
"accur3" DOUBLE,
"acvlt1" DOUBLE,
"acvlt2" DOUBLE,
"acvlt3" DOUBLE,
"acfrq1" DOUBLE,
"acfrq2" DOUBLE,
"acfrq3" DOUBLE,
"appwr1" DOUBLE,
"appwr2" DOUBLE,
"appwr3" DOUBLE,
"acpwr1" DOUBLE,
"acpwr2" DOUBLE,
"acpwr3" DOUBLE,
"repwr1" DOUBLE,
"repwr2" DOUBLE,
"repwr3" DOUBLE,
"fsbatt" DOUBLE,
"fstemp" DOUBLE,
"nwptma" DOUBLE,
"nwptmb" DOUBLE,
"nwptmc" DOUBLE,
"swptma" DOUBLE,
"swptmb" DOUBLE,
"swptmc" DOUBLE,
"septma" DOUBLE,
"septmb" DOUBLE,
"septmc" DOUBLE,
"neptma" DOUBLE,
"neptmb" DOUBLE,
"neptmc" DOUBLE,
"mdptma" DOUBLE,
"mdptmb" DOUBLE,
"mdptmc" DOUBLE,
"fpoai1" DOUBLE,
"fpoai2" DOUBLE,
"fspirr" DOUBLE,
"wtplow" DOUBLE,
"wtpmid" DOUBLE,
"wtpdep" DOUBLE,
"fpvdbt" DOUBLE,
"fpv_rh" DOUBLE,
"frairp" DOUBLE,
"fwinda" DOUBLE,
"fwindm" DOUBLE,
"fwindv" DOUBLE,
"frsrvd" DOUBLE,
"fprect" DOUBLE,
"fpreci" DOUBLE,
"fdptmp" DOUBLE,
"fwctmp" DOUBLE,
"fprecd" DOUBLE,
"fwndac" DOUBLE,
"fwndmn" DOUBLE,
"fwndvt" DOUBLE,
"fpvwbt" DOUBLE,
"fwdira" DOUBLE,
"fwdirn" DOUBLE,
"fwdirx" DOUBLE,
"fenthp" DOUBLE,
"sparf1" DOUBLE,
"sparf2" DOUBLE,
"sparf3" DOUBLE,
"lsbatt" DOUBLE,
"lstemp" DOUBLE,
"lpvdbt" DOUBLE,
"lpv_rh" DOUBLE,
"lrairp" DOUBLE,
"lwinda" DOUBLE,
"lwindm" DOUBLE,
"lwindv" DOUBLE,
"lrsrvd" DOUBLE,
"lprect" DOUBLE,
"lpreci" DOUBLE,
"ldptmp" DOUBLE,
"lwctmp" DOUBLE,
"lprecd" DOUBLE,
"lwndac" DOUBLE,
"lwndmn" DOUBLE,
"lwndvt" DOUBLE,
"lpvwbt" DOUBLE,
"lwdira" DOUBLE,
"lwdirn" DOUBLE,
"lwdirx" DOUBLE,
"lenthp" DOUBLE,
"lhzirr" DOUBLE,
"sparl1" DOUBLE,
"sparl2" DOUBLE,
"sparl3" DOUBLE
);
CREATE TABLE floating_pv_oakville_ca_inverter_3_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"acpwrt" DOUBLE,
"dcvolt" DOUBLE,
"resist" DOUBLE,
"temper" DOUBLE,
"vl1to2" DOUBLE,
"vl2to3" DOUBLE,
"vl3to1" DOUBLE,
"accur1" DOUBLE,
"accur2" DOUBLE,
"accur3" DOUBLE,
"acvlt1" DOUBLE,
"acvlt2" DOUBLE,
"acvlt3" DOUBLE,
"acfrq1" DOUBLE,
"acfrq2" DOUBLE,
"acfrq3" DOUBLE,
"appwr1" DOUBLE,
"appwr2" DOUBLE,
"appwr3" DOUBLE,
"acpwr1" DOUBLE,
"acpwr2" DOUBLE,
"acpwr3" DOUBLE,
"repwr1" DOUBLE,
"repwr2" DOUBLE,
"repwr3" DOUBLE
);
CREATE TABLE floating_pv_oakville_ca_inverter_4_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"acpwrt" DOUBLE,
"dcvolt" DOUBLE,
"resist" DOUBLE,
"temper" DOUBLE,
"vl1to2" DOUBLE,
"vl2to3" DOUBLE,
"vl3to1" DOUBLE,
"accur1" DOUBLE,
"accur2" DOUBLE,
"accur3" DOUBLE,
"acvlt1" DOUBLE,
"acvlt2" DOUBLE,
"acvlt3" DOUBLE,
"acfrq1" DOUBLE,
"acfrq2" DOUBLE,
"acfrq3" DOUBLE,
"appwr1" DOUBLE,
"appwr2" DOUBLE,
"appwr3" DOUBLE,
"acpwr1" DOUBLE,
"acpwr2" DOUBLE,
"acpwr3" DOUBLE,
"repwr1" DOUBLE,
"repwr2" DOUBLE,
"repwr3" DOUBLE
);
CREATE TABLE floating_pv_oakville_ca_inverter_5_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"acpwrt" DOUBLE,
"dcvolt" DOUBLE,
"resist" DOUBLE,
"temper" DOUBLE,
"vl1to2" DOUBLE,
"vl2to3" DOUBLE,
"vl3to1" DOUBLE,
"accur1" DOUBLE,
"accur2" DOUBLE,
"accur3" DOUBLE,
"acvlt1" DOUBLE,
"acvlt2" DOUBLE,
"acvlt3" DOUBLE,
"acfrq1" DOUBLE,
"acfrq2" DOUBLE,
"acfrq3" DOUBLE,
"appwr1" DOUBLE,
"appwr2" DOUBLE,
"appwr3" DOUBLE,
"acpwr1" DOUBLE,
"acpwr2" DOUBLE,
"acpwr3" DOUBLE,
"repwr1" DOUBLE,
"repwr2" DOUBLE,
"repwr3" DOUBLE
);
CREATE TABLE floating_pv_oakville_ca_inverter_6_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"acpwrt" DOUBLE,
"dcvolt" DOUBLE,
"resist" DOUBLE,
"temper" DOUBLE,
"vl1to2" DOUBLE,
"vl2to3" DOUBLE,
"vl3to1" DOUBLE,
"accur1" DOUBLE,
"accur2" DOUBLE,
"accur3" DOUBLE,
"acvlt1" DOUBLE,
"acvlt2" DOUBLE,
"acvlt3" DOUBLE,
"acfrq1" DOUBLE,
"acfrq2" DOUBLE,
"acfrq3" DOUBLE,
"appwr1" DOUBLE,
"appwr2" DOUBLE,
"appwr3" DOUBLE,
"acpwr1" DOUBLE,
"acpwr2" DOUBLE,
"acpwr3" DOUBLE,
"repwr1" DOUBLE,
"repwr2" DOUBLE,
"repwr3" DOUBLE
);
CREATE TABLE floating_pv_oakville_ca_inverter_7_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"acpwrt" DOUBLE,
"dcvolt" DOUBLE,
"resist" DOUBLE,
"temper" DOUBLE,
"vl1to2" DOUBLE,
"vl2to3" DOUBLE,
"vl3to1" DOUBLE,
"accur1" DOUBLE,
"accur2" DOUBLE,
"accur3" DOUBLE,
"acvlt1" DOUBLE,
"acvlt2" DOUBLE,
"acvlt3" DOUBLE,
"acfrq1" DOUBLE,
"acfrq2" DOUBLE,
"acfrq3" DOUBLE,
"appwr1" DOUBLE,
"appwr2" DOUBLE,
"appwr3" DOUBLE,
"acpwr1" DOUBLE,
"acpwr2" DOUBLE,
"acpwr3" DOUBLE,
"repwr1" DOUBLE,
"repwr2" DOUBLE,
"repwr3" DOUBLE
);
CREATE TABLE floating_pv_oakville_ca_inverter_8_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"acpwrt" DOUBLE,
"dcvolt" DOUBLE,
"resist" DOUBLE,
"temper" DOUBLE,
"vl1to2" DOUBLE,
"vl2to3" DOUBLE,
"vl3to1" DOUBLE,
"accur1" DOUBLE,
"accur2" DOUBLE,
"accur3" DOUBLE,
"acvlt1" DOUBLE,
"acvlt2" DOUBLE,
"acvlt3" DOUBLE,
"acfrq1" DOUBLE,
"acfrq2" DOUBLE,
"acfrq3" DOUBLE,
"appwr1" DOUBLE,
"appwr2" DOUBLE,
"appwr3" DOUBLE,
"acpwr1" DOUBLE,
"acpwr2" DOUBLE,
"acpwr3" DOUBLE,
"repwr1" DOUBLE,
"repwr2" DOUBLE,
"repwr3" DOUBLE
);
CREATE TABLE floating_pv_oakville_ca_inverter_9_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"acpwrt" DOUBLE,
"dcvolt" DOUBLE,
"resist" DOUBLE,
"temper" DOUBLE,
"vl1to2" DOUBLE,
"vl2to3" DOUBLE,
"vl3to1" DOUBLE,
"accur1" DOUBLE,
"accur2" DOUBLE,
"accur3" DOUBLE,
"acvlt1" DOUBLE,
"acvlt2" DOUBLE,
"acvlt3" DOUBLE,
"acfrq1" DOUBLE,
"acfrq2" DOUBLE,
"acfrq3" DOUBLE,
"appwr1" DOUBLE,
"appwr2" DOUBLE,
"appwr3" DOUBLE,
"acpwr1" DOUBLE,
"acpwr2" DOUBLE,
"acpwr3" DOUBLE,
"repwr1" DOUBLE,
"repwr2" DOUBLE,
"repwr3" DOUBLE
);
CREATE TABLE floating_pv_orlando_fl_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"fsbatt" DOUBLE,
"fptemp" DOUBLE,
"septma" DOUBLE,
"septmb" DOUBLE,
"septmc" DOUBLE,
"neptma" DOUBLE,
"neptmb" DOUBLE,
"neptmc" DOUBLE,
"mdptma" DOUBLE,
"mdptmb" DOUBLE,
"mdptmc" DOUBLE,
"nwptma" DOUBLE,
"nwptmb" DOUBLE,
"nwptmc" DOUBLE,
"swptma" DOUBLE,
"swptmb" DOUBLE,
"swptmc" DOUBLE,
"poair1" DOUBLE,
"poair2" DOUBLE,
"poair3" DOUBLE,
"wtm0_3" DOUBLE,
"wtm0_6" DOUBLE,
"wtm1_4" DOUBLE,
"fphirr" DOUBLE,
"rainmm" DOUBLE,
"strike" DOUBLE,
"fwinds" DOUBLE,
"fwindd" DOUBLE,
"fwindm" DOUBLE,
"fambtm" DOUBLE,
"fvpres" DOUBLE,
"fbpres" DOUBLE,
"fpv_rh" DOUBLE,
"frhtmp" DOUBLE,
"fnstlt" DOUBLE,
"fewtlt" DOUBLE,
"sparf1" DOUBLE,
"sparf2" DOUBLE,
"sparf3" DOUBLE,
"sparf4" DOUBLE,
"sparf5" DOUBLE,
"sparf6" DOUBLE,
"sparf7" DOUBLE,
"sparf8" DOUBLE,
"sparf9" DOUBLE,
"sprf10" DOUBLE,
"l_batt" DOUBLE,
"ldtemp" DOUBLE,
"lphirr" DOUBLE,
"lrainm" DOUBLE,
"lstrik" DOUBLE,
"lstrds" DOUBLE,
"lwinds" DOUBLE,
"lwindd" DOUBLE,
"lwindm" DOUBLE,
"lambtm" DOUBLE,
"lvpres" DOUBLE,
"lbpres" DOUBLE,
"lnd_rh" DOUBLE,
"lrhtmp" DOUBLE,
"lnstlt" DOUBLE,
"lewtlt" DOUBLE,
"sparl1" DOUBLE,
"sparl2" DOUBLE,
"sparl3" DOUBLE,
"invpwr" DOUBLE,
"mppt1p" DOUBLE,
"mppt2p" DOUBLE,
"mppt3p" DOUBLE,
"mppt4p" DOUBLE,
"mppt5p" DOUBLE,
"sparea" DOUBLE,
"spareb" DOUBLE,
"spar00" DOUBLE,
"spar01" DOUBLE,
"spar02" DOUBLE,
"spar03" DOUBLE,
"spar04" DOUBLE,
"spar05" DOUBLE,
"spar06" DOUBLE,
"spar07" DOUBLE,
"spar08" DOUBLE,
"spar09" DOUBLE,
"spar10" DOUBLE,
"spar11" DOUBLE,
"spar12" DOUBLE,
"spar13" DOUBLE,
"spar14" DOUBLE
);
CREATE TABLE floating_pv_windsor_ca_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"fsbatt" DOUBLE,
"fstemp" DOUBLE,
"nwptma" DOUBLE,
"nwptmb" DOUBLE,
"nwptmc" DOUBLE,
"noptma" DOUBLE,
"noptmb" DOUBLE,
"noptmc" DOUBLE,
"neptma" DOUBLE,
"neptmb" DOUBLE,
"neptmc" DOUBLE,
"mdptma" DOUBLE,
"mdptmb" DOUBLE,
"mdptmc" DOUBLE,
"soptma" DOUBLE,
"soptmb" DOUBLE,
"soptmc" DOUBLE,
"fhzirr" DOUBLE,
"fpairr" DOUBLE,
"fpnltc" DOUBLE,
"wtm1_0" DOUBLE,
"wtm275" DOUBLE,
"wtm4_5" DOUBLE,
"fpvdbt" DOUBLE,
"fpv_rh" DOUBLE,
"frairp" DOUBLE,
"fwinda" DOUBLE,
"fwindm" DOUBLE,
"fwindv" DOUBLE,
"frsrvd" DOUBLE,
"fprect" DOUBLE,
"fpreci" DOUBLE,
"fdptmp" DOUBLE,
"fwctmp" DOUBLE,
"fprecd" DOUBLE,
"fwndac" DOUBLE,
"fwndmn" DOUBLE,
"fwndvt" DOUBLE,
"fpvwbt" DOUBLE,
"fwdira" DOUBLE,
"fwdirn" DOUBLE,
"fwdirx" DOUBLE,
"fenthp" DOUBLE,
"sparf1" DOUBLE,
"sparf2" DOUBLE,
"sparf3" DOUBLE,
"lsbatt" DOUBLE,
"lstemp" DOUBLE,
"lpvdbt" DOUBLE,
"lpv_rh" DOUBLE,
"lpvdb2" DOUBLE,
"lpvrh2" DOUBLE,
"lwinda" DOUBLE,
"lpairr" DOUBLE,
"sparl1" DOUBLE,
"sparl2" DOUBLE,
"sparl3" DOUBLE,
"invacp" DOUBLE,
"invace" DOUBLE,
"invdci" DOUBLE,
"invsp1" DOUBLE,
"invsp2" DOUBLE,
"invsp3" DOUBLE,
"invsp4" DOUBLE,
"invsp5" DOUBLE,
"invsp6" DOUBLE,
"spar01" DOUBLE,
"spar02" DOUBLE,
"spar03" DOUBLE,
"spar04" DOUBLE,
"spar05" DOUBLE
);
CREATE TABLE land_pv_fsec_regional_test_ambient_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"ghrada" DOUBLE,
"dirraa" DOUBLE,
"difraa" DOUBLE,
"pmbara" DOUBLE,
"wsmean" DOUBLE,
"wdirea" DOUBLE,
"wdirst" DOUBLE,
"wsmsst" DOUBLE,
"ws3sma" DOUBLE,
"wddsmm" DOUBLE,
"tmpcav" DOUBLE,
"rhpcta" DOUBLE,
"ptmpca" DOUBLE,
"battva" DOUBLE,
"anom1m" DOUBLE,
"gmvave" DOUBLE,
"rmmtot" DOUBLE,
"rmmday" DOUBLE,
"tmpcm2" DOUBLE
);
CREATE TABLE land_pv_fsec_regional_test_baseline_data (
"unnamed_0" BIGINT,
"day" BIGINT,
"hour" VARCHAR,
"sy1vdc" DOUBLE,
"s1s1dc" DOUBLE,
"s1s2dc" DOUBLE,
"sy1vac" DOUBLE,
"sy1iac" DOUBLE,
"sy1wac" DOUBLE,
"sy1var" DOUBLE,
"sys1pf" DOUBLE,
"sys1fq" DOUBLE,
"modt01" DOUBLE,
"modt02" DOUBLE,
"modt03" DOUBLE,
"modt04" DOUBLE,
"modt05" DOUBLE,
"modt06" DOUBLE,
"modt07" DOUBLE,
"modt08" DOUBLE,
"sy2vdc" DOUBLE,
"s2s1dc" DOUBLE,
"s2s2dc" DOUBLE,
"s2vaca" DOUBLE,
"s2iaca" DOUBLE,
"s2waca" DOUBLE,
"s2vara" DOUBLE,
"s2pfav" DOUBLE,
"s2frqa" DOUBLE,
"modt09" DOUBLE,
"modt10" DOUBLE,
"modt11" DOUBLE,
"modt12" DOUBLE,
"modt13" DOUBLE,
"modt14" DOUBLE,
"modt15" DOUBLE,
"modt16" DOUBLE,
"rec1ir" DOUBLE,
"rec1te" DOUBLE,
"rec1re" DOUBLE,
"rec2ir" DOUBLE,
"rec2te" DOUBLE,
"rec2re" DOUBLE,
"lambta" DOUBLE,
"poair1" DOUBLE,
"icp1jt" DOUBLE,
"icp2jt" DOUBLE,
"icp3jt" DOUBLE,
"icp4jt" DOUBLE,
"icp5jt" DOUBLE,
"icp6jt" DOUBLE,
"icp7jt" DOUBLE
);
Anyone who has the link will be able to view this.