{"columns":[{"name":"system_id","type":"int32"},{"name":"metric_id","type":"int32"},{"name":"sensor_name","type":"string"},{"name":"common_name","type":"string"},{"name":"raw_units","type":"string"},{"name":"units","type":"string"},{"name":"calc_scale","type":"double"},{"name":"calc_offset","type":"double"},{"name":"calc_details","type":"string"},{"name":"aggregation_type","type":"string"},{"name":"source_type","type":"string"},{"name":"source_id","type":"int32"},{"name":"comments","type":"string"},{"name":"standard_name","type":"string"}],"n_rows":100,"rows_kept":100,"cut":false,"text_format":"parquet-jsonl-2026-10-02","bounds":{"document_bytes":16777216,"package_text_limit_bytes":33554432,"package_text_slack_bytes":1024,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096,"vector_min":64,"vector_head_fixed":16,"vector_head_variable":64,"kv_value_chars":1048576,"nesting_max":64,"binary_text":true},"cells_cut":0,"cells_bad_utf8":0,"cells_raw":0,"cells_binary":0,"cells_binary_text":0,"cells_vector":0,"n_row_groups":1,"reader":"pyarrow 23.0.1, python 3.13","created_by":"Amazon Redshift","schema":{"fields":[{"name":"system_id","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"metric_id","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"sensor_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"common_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"raw_units","type":"string","nullable":true,"metadata":null,"children":null},{"name":"units","type":"string","nullable":true,"metadata":null,"children":null},{"name":"calc_scale","type":"double","nullable":true,"metadata":null,"children":null},{"name":"calc_offset","type":"double","nullable":true,"metadata":null,"children":null},{"name":"calc_details","type":"string","nullable":true,"metadata":null,"children":null},{"name":"aggregation_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"source_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"source_id","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"comments","type":"string","nullable":true,"metadata":null,"children":null},{"name":"standard_name","type":"string","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 schema {\n  optional int32 field_id=-1 system_id (Int(bitWidth=32, isSigned=true));\n  optional int32 field_id=-1 metric_id (Int(bitWidth=32, isSigned=true));\n  optional binary field_id=-1 sensor_name (String);\n  optional binary field_id=-1 common_name (String);\n  optional binary field_id=-1 raw_units (String);\n  optional binary field_id=-1 units (String);\n  optional double field_id=-1 calc_scale;\n  optional double field_id=-1 calc_offset;\n  optional binary field_id=-1 calc_details (String);\n  optional binary field_id=-1 aggregation_type (String);\n  optional binary field_id=-1 source_type (String);\n  optional int32 field_id=-1 source_id (Int(bitWidth=32, isSigned=true));\n  optional binary field_id=-1 comments (String);\n  optional binary field_id=-1 standard_name (String);\n}\n"},"kv_metadata":[]}
[4901,82498,"AmbTemp_C_Avg","Temperature ambient","C","C",1.0,0.0,"","avg","OTHER",2200,"","temperature_ambient_o_2200"]
[4901,82575,"Battery_A_Avg","DC current battery","A","A",1.0,0.0,"","avg","",null,"","battery_a_avg__82575"]
[4901,82574,"Battery_V_Min","DC voltage battery","V","V",1.0,0.0,"","min","",null,"","battery_v_min__82574"]
[4901,82491,"CR1000Temp_C_Avg","Temperature enclosure","C","C",1.0,0.0,"","avg","OTHER",null,"","cr1000temp_c_avg__82491"]
[4901,82578,"ChgSource_Min","Battery other","-","-",1.0,0.0,"","min","",null,"","chgsource_min__82578"]
[4901,82577,"ChgState_Min","Battery other","-","-",1.0,0.0,"","min","",null,"","chgstate_min__82577"]
[4901,82579,"CkBatt_Max","Battery other","-","-",1.0,0.0,"","max","",null,"","ckbatt_max__82579"]
[4901,82510,"InvEtot_kWh_Max","AC energy","kWh","kWh",1.0,0.0,"","max","INVERTER",14537,"","ac_energy_inv_14537"]
[4901,82503,"InvIa_Avg","AC current other","A","A",1.0,0.0,"","avg","INVERTER",14537,"","ac_current_other_inv_14537"]
[4901,82504,"InvIb_Avg","AC current other","A","A",1.0,0.0,"","avg","INVERTER",14537,"","ac_current_other_inv_14537_2"]
[4901,82505,"InvIc_Avg","AC current other","A","A",1.0,0.0,"","avg","INVERTER",14537,"","ac_current_other_inv_14537_3"]
[4901,82509,"InvPAC_kW_Avg","AC power","kW","kW",1.0,0.0,"","avg","INVERTER",14537,"","ac_power_inv_14537"]
[4901,82512,"InvPDC_kW_Avg","DC power","kW","kW",1.0,0.0,"","avg","INVERTER",14537,"","dc_power_inv_14537"]
[4901,82518,"InvTempFault_Max","Temperature inverter","-","-",1.0,0.0,"","max","INVERTER",14537,"","temperature_inverter_inv_14537"]
[4901,82506,"InvVDCin_Avg","DC voltage other","V","V",1.0,0.0,"","avg","INVERTER",14537,"","dc_voltage_other_inv_14537"]
[4901,82511,"InvVPVin_Avg","DC voltage other","V","V",1.0,0.0,"","avg","INVERTER",14537,"","dc_voltage_other_inv_14537_2"]
[4901,82500,"InvVa_Avg","AC voltage other","V","V",1.0,0.0,"","avg","INVERTER",14537,"","ac_voltage_other_inv_14537"]
[4901,82501,"InvVb_Avg","AC voltage other","V","V",1.0,0.0,"","avg","INVERTER",14537,"","ac_voltage_other_inv_14537_2"]
[4901,82502,"InvVc_Avg","AC voltage other","V","V",1.0,0.0,"","avg","INVERTER",14537,"","ac_voltage_other_inv_14537_3"]
[4901,82540,"PwrMtrEdel_kVARh_Max","AC power","kVARh","kVARh",1.0,0.0,"","max","METER",1863,"","ac_power_meter_1863"]
[4901,82538,"PwrMtrEdel_kWh_Max","AC power","kWh","kWh",1.0,0.0,"","max","METER",1863,"","ac_power_meter_1863_2"]
[4901,82541,"PwrMtrErec_kVARh_Max","AC power","kVARh","kVARh",1.0,0.0,"","max","METER",1863,"","ac_power_meter_1863_3"]
[4901,82539,"PwrMtrErec_kWh_Max","AC power","kWh","kWh",1.0,0.0,"","max","METER",1863,"","ac_power_meter_1863_4"]
[4901,82530,"PwrMtrFreqMax_Max","AC other","Hz","Hz",1.0,0.0,"","max","METER",1863,"","ac_other_meter_1863"]
[4901,82529,"PwrMtrFreqMin_Min","AC other","Hz","Hz",1.0,0.0,"","min","METER",1863,"","ac_other_meter_1863_2"]
[4901,82528,"PwrMtrFreq_Avg","AC other","Hz","Hz",1.0,0.0,"","avg","METER",1863,"","ac_other_meter_1863_3"]
[4901,82542,"PwrMtrPF_Avg","AC power other","-","-",1.0,0.0,"","avg","METER",1863,"","ac_power_other_meter_1863"]
[4901,82536,"PwrMtrP_kVAR_Avg","AC power other","kVAR","kVAR",1.0,0.0,"","avg","METER",1863,"","ac_power_other_meter_1863_2"]
[4901,82537,"PwrMtrP_kVA_Avg","AC power other","kVA","kVA",1.0,0.0,"","avg","METER",1863,"","ac_power_other_meter_1863_3"]
[4901,82535,"PwrMtrP_kW_Avg","AC power","kW","kW",1.0,0.0,"","avg","METER",1863,"","ac_power_meter_1863_5"]
[4901,82531,"PwrMtrPhaseRev_Avg","AC power other","-","-",1.0,0.0,"","avg","METER",1863,"","ac_power_other_meter_1863_4"]
[4901,82543,"PwrMtrVaTHDMax_Max","AC voltage other","%","%",1.0,0.0,"","max","METER",1863,"","ac_voltage_other_meter_1863"]
[4901,82532,"PwrMtrVa_Avg","AC voltage other","V","V",1.0,0.0,"","avg","METER",1863,"","ac_voltage_other_meter_1863_2"]
[4901,82544,"PwrMtrVbTHDMax_Max","AC voltage other","%","%",1.0,0.0,"","max","METER",1863,"","ac_voltage_other_meter_1863_3"]
[4901,82533,"PwrMtrVb_Avg","AC voltage other","V","V",1.0,0.0,"","avg","METER",1863,"","ac_voltage_other_meter_1863_4"]
[4901,82545,"PwrMtrVcTHDMax_Max","AC voltage other","%","%",1.0,0.0,"","max","METER",1863,"","ac_voltage_other_meter_1863_5"]
[4901,82534,"PwrMtrVc_Avg","AC voltage other","V","V",1.0,0.0,"","avg","METER",1863,"","ac_voltage_other_meter_1863_6"]
[4901,82493,"Pyra1_mV_Avg","Irradiance POA","mV","mV",1.0,0.0,"","avg","OTHER",2195,"west tilt","irradiance_poa_o_2195"]
[4901,82494,"Pyra2_mV_Avg","Irradiance GHI","mV","mV",1.0,0.0,"","avg","OTHER",2196,"","irradiance_ghi_o_2196"]
[4901,82495,"Pyra3_mV_Avg","Irradiance POA","mV","mV",1.0,0.0,"","avg","OTHER",2197,"east tilt","irradiance_poa_o_2197"]
[4901,82581,"RTD_C_Avg_1","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_1__82581"]
[4901,82590,"RTD_C_Avg_10","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_10__82590"]
[4901,82582,"RTD_C_Avg_2","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_2__82582"]
[4901,82583,"RTD_C_Avg_3","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_3__82583"]
[4901,82584,"RTD_C_Avg_4","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_4__82584"]
[4901,82585,"RTD_C_Avg_5","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_5__82585"]
[4901,82586,"RTD_C_Avg_6","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_6__82586"]
[4901,82587,"RTD_C_Avg_7","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_7__82587"]
[4901,82588,"RTD_C_Avg_8","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_8__82588"]
[4901,82589,"RTD_C_Avg_9","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_9__82589"]
[4901,82496,"RefCell1_Wm2_Avg","Irradiance POA","W/m^2","W/m^2",1.0,0.0,"","avg","OTHER",2198,"west tilt","irradiance_poa_o_2198"]
[4901,82497,"RefCell2_Wm2_Avg","Irradiance POA","W/m^2","W/m^2",1.0,0.0,"","avg","OTHER",2199,"east tilt","irradiance_poa_o_2199"]
[4901,82522,"SEWSAmbientTemp_C_Avg","Temperature ambient","C","C",1.0,0.0,"","avg","OTHER",2201,"","temperature_ambient_o_2201"]
[4901,82523,"SEWSModuleTemp_C_Avg","Temperature module","C","C",1.0,0.0,"","avg","OTHER",2201,"","temperature_module_o_2201"]
[4901,82546,"ShuntCurrent_A_Avg_1","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_1__82546"]
[4901,82547,"ShuntCurrent_A_Avg_2","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_2__82547"]
[4901,82548,"ShuntCurrent_A_Avg_3","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_3__82548"]
[4901,82549,"ShuntCurrent_A_Avg_4","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_4__82549"]
[4901,82550,"ShuntCurrent_A_Avg_5","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_5__82550"]
[4901,82551,"ShuntCurrent_A_Avg_6","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_6__82551"]
[4901,82552,"ShuntCurrent_A_Avg_7","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_7__82552"]
[4901,82560,"ShuntEtot_kWh_Max_1","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_1__82560"]
[4901,82561,"ShuntEtot_kWh_Max_2","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_2__82561"]
[4901,82562,"ShuntEtot_kWh_Max_3","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_3__82562"]
[4901,82563,"ShuntEtot_kWh_Max_4","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_4__82563"]
[4901,82564,"ShuntEtot_kWh_Max_5","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_5__82564"]
[4901,82565,"ShuntEtot_kWh_Max_6","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_6__82565"]
[4901,82566,"ShuntEtot_kWh_Max_7","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_7__82566"]
[4901,82553,"ShuntPDC_kW_Avg_1","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_1__82553"]
[4901,82554,"ShuntPDC_kW_Avg_2","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_2__82554"]
[4901,82555,"ShuntPDC_kW_Avg_3","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_3__82555"]
[4901,82556,"ShuntPDC_kW_Avg_4","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_4__82556"]
[4901,82557,"ShuntPDC_kW_Avg_5","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_5__82557"]
[4901,82558,"ShuntPDC_kW_Avg_6","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_6__82558"]
[4901,82559,"ShuntPDC_kW_Avg_7","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_7__82559"]
[4901,82572,"WindHeatStateID_Avg","AC other","-","-",1.0,0.0,"","avg","OTHER",2201,"","wind_other_o_2201_2"]
[4901,82571,"WindRef_V_Min","AC other","V","V",1.0,0.0,"","min","OTHER",2201,"","wind_other_o_2201_3"]
[4901,82570,"WindSpeed_ms_Max","AC other","m/s","m/s",1.0,0.0,"","max","OTHER",2201,"","wind_speed_o_2201_2"]
[4901,82573,"WindValid_Avg","AC other","-","-",1.0,0.0,"","avg","OTHER",2201,"","wind_other_o_2201_4"]
[4901,82492,"DoorOpen_Min","System other","-","-",1.0,0.0,"","min","",null,"","dooropen_min__82492"]
[4901,82515,"InvDriveFault_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14537,"","system_other_inv_14537"]
[4901,82508,"InvFreq_Avg","System other","Hz","Hz",1.0,0.0,"","avg","INVERTER",14537,"","system_other_inv_14537_2"]
[4901,82517,"InvGridFault_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14537,"","system_other_inv_14537_3"]
[4901,82507,"InvIDCin_Avg","System other","A","A",1.0,0.0,"","avg","INVERTER",14537,"","system_other_inv_14537_4"]
[4901,82514,"InvMainFault_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14537,"","system_other_inv_14537_5"]
[4901,82513,"InvOpStatus_Avg","System other","-","-",1.0,0.0,"","avg","INVERTER",14537,"","system_other_inv_14537_6"]
[4901,82521,"InvPVMStatus_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14537,"","system_other_inv_14537_7"]
[4901,82519,"InvSystemFault_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14537,"","system_other_inv_14537_8"]
[4901,82520,"InvSystemWarn_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14537,"","system_other_inv_14537_9"]
[4901,82499,"InvVDVoltage_V_Avg","System other","V","V",1.0,0.0,"","avg","INVERTER",14537,"","system_other_inv_14537_10"]
[4901,82516,"InvVoltageFault_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14537,"","system_other_inv_14537_11"]
[4901,82576,"Load_A_Avg","System other","A","A",1.0,0.0,"","avg","",null,"","load_a_avg__82576"]
[4901,82525,"PwrMtrIa_Avg","System other","A","A",1.0,0.0,"","avg","METER",1863,"","system_other_meter_1863"]
[4901,82526,"PwrMtrIb_Avg","System other","A","A",1.0,0.0,"","avg","METER",1863,"","system_other_meter_1863_2"]
[4901,82527,"PwrMtrIc_Avg","System other","A","A",1.0,0.0,"","avg","METER",1863,"","system_other_meter_1863_3"]
[4901,82580,"Qloss_Ah_Max","System other","Ah","Ah",1.0,0.0,"","max","",null,"","qloss_ah_max__82580"]
[4901,82524,"SEWSPOAIrrad_Wm2_Avg","System other","W/m^2","W/m^2",1.0,0.0,"","avg","",2201,"","sewspoairrad_wm2_avg__82524"]
[4901,82568,"WindDirAve_deg","AC other","Deg","Deg",1.0,0.0,"","wvc","OTHER",2201,"","wind_direction_o_2201"]
[4901,82569,"WindDirStdDev_deg","AC other","Deg","Deg",1.0,0.0,"","wvc","OTHER",2201,"","wind_other_o_2201"]
[4901,82567,"WindSpeedAve_ms","AC other","m/s","m/s",1.0,0.0,"","wvc","OTHER",2201,"","wind_speed_o_2201"]