datasets/sunroof_solar/pipelines/solar_potential_by_censustract/solar_potential_by_censustract_dag.py [62:234]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - skip_leading_rows=1, allow_quoted_newlines=True, write_disposition="WRITE_TRUNCATE", schema_fields=[ { "name": "region_name", "type": "STRING", "description": "Census Tract", "mode": "NULLABLE", }, { "name": "state_name", "type": "STRING", "description": "Name of the state containing that region", "mode": "NULLABLE", }, { "name": "lat_max", "type": "FLOAT", "description": "maximum latitude for that region", "mode": "NULLABLE", }, { "name": "lat_min", "type": "FLOAT", "description": "minimum latitude for that region", "mode": "NULLABLE", }, { "name": "lng_max", "type": "FLOAT", "description": "maximum longitude for that region", "mode": "NULLABLE", }, { "name": "lng_min", "type": "FLOAT", "description": "minimum longitude for that region", "mode": "NULLABLE", }, { "name": "lat_avg", "type": "FLOAT", "description": "average latitude for that region", "mode": "NULLABLE", }, { "name": "lng_avg", "type": "FLOAT", "description": "average longitude for that region", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_kw_threshold_avg", "type": "FLOAT", "description": "75% of the optimimum sunlight in the county containing that zip code", "mode": "NULLABLE", }, { "name": "count_qualified", "type": "INTEGER", "description": "# of buildings in Google Maps that are suitable for solar", "mode": "NULLABLE", }, { "name": "percent_covered", "type": "FLOAT", "description": "% of buildings in Google Maps covered by Project Sunroof", "mode": "NULLABLE", }, { "name": "percent_qualified", "type": "FLOAT", "description": "% of buildings covered by Project Sunroof that are suitable for solar", "mode": "NULLABLE", }, { "name": "number_of_panels_n", "type": "INTEGER", "description": "# of solar panels potential for north-facing roof space in that region, assuming 1.650m x 0.992m panels", "mode": "NULLABLE", }, { "name": "number_of_panels_s", "type": "INTEGER", "description": "# of solar panels potential for south-facing roof space in that region, assuming 1.650m x 0.992m panels", "mode": "NULLABLE", }, { "name": "number_of_panels_e", "type": "INTEGER", "description": "# of solar panels potential for east-facing roof space in that region, assuming 1.650m x 0.992m panels", "mode": "NULLABLE", }, { "name": "number_of_panels_w", "type": "INTEGER", "description": "# of solar panels potential for west-facing roof space in that region, assuming 1.650m x 0.992m panels", "mode": "NULLABLE", }, { "name": "number_of_panels_f", "type": "INTEGER", "description": "# of solar panels potential for flat roof space in that region, assuming 1.650m x 0.992m panels", "mode": "NULLABLE", }, { "name": "number_of_panels_median", "type": "INTEGER", "description": "# of panels that fit on the median roof", "mode": "NULLABLE", }, { "name": "number_of_panels_total", "type": "INTEGER", "description": "# of solar panels potential for all roof space in that region, assuming 1.650m 0.992m panels", "mode": "NULLABLE", }, { "name": "kw_median", "type": "FLOAT", "description": "kW of solar potential for the median building in that region (assuming 250 watts per panel)", "mode": "NULLABLE", }, { "name": "kw_total", "type": "FLOAT", "description": "# of kW of solar potential for all roof types in that region (assuming 250 watts per panel)", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_n", "type": "FLOAT", "description": "total solar energy generation potential for north-facing roof space in that region", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_s", "type": "FLOAT", "description": "total solar energy generation potential for south-facing roof space in that region", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_e", "type": "FLOAT", "description": "total solar energy generation potential for east-facing roof space in that region", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_w", "type": "FLOAT", "description": "total solar energy generation potential for west-facing roof space in that region", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_f", "type": "FLOAT", "description": "total solar energy generation potential for flat roof space in that region", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_median", "type": "FLOAT", "description": "kWh/kw/yr for the median roof, in DC (not AC) terms", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_total", "type": "FLOAT", "description": "total solar energy generation potential for all roof space in that region", "mode": "NULLABLE", }, { - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - datasets/sunroof_solar/pipelines/solar_potential_by_postal_code/solar_potential_by_postal_code_dag.py [62:234]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - skip_leading_rows=1, allow_quoted_newlines=True, write_disposition="WRITE_TRUNCATE", schema_fields=[ { "name": "region_name", "type": "STRING", "description": "Census Tract", "mode": "NULLABLE", }, { "name": "state_name", "type": "STRING", "description": "Name of the state containing that region", "mode": "NULLABLE", }, { "name": "lat_max", "type": "FLOAT", "description": "maximum latitude for that region", "mode": "NULLABLE", }, { "name": "lat_min", "type": "FLOAT", "description": "minimum latitude for that region", "mode": "NULLABLE", }, { "name": "lng_max", "type": "FLOAT", "description": "maximum longitude for that region", "mode": "NULLABLE", }, { "name": "lng_min", "type": "FLOAT", "description": "minimum longitude for that region", "mode": "NULLABLE", }, { "name": "lat_avg", "type": "FLOAT", "description": "average latitude for that region", "mode": "NULLABLE", }, { "name": "lng_avg", "type": "FLOAT", "description": "average longitude for that region", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_kw_threshold_avg", "type": "FLOAT", "description": "75% of the optimimum sunlight in the county containing that zip code", "mode": "NULLABLE", }, { "name": "count_qualified", "type": "INTEGER", "description": "# of buildings in Google Maps that are suitable for solar", "mode": "NULLABLE", }, { "name": "percent_covered", "type": "FLOAT", "description": "% of buildings in Google Maps covered by Project Sunroof", "mode": "NULLABLE", }, { "name": "percent_qualified", "type": "FLOAT", "description": "% of buildings covered by Project Sunroof that are suitable for solar", "mode": "NULLABLE", }, { "name": "number_of_panels_n", "type": "INTEGER", "description": "# of solar panels potential for north-facing roof space in that region, assuming 1.650m x 0.992m panels", "mode": "NULLABLE", }, { "name": "number_of_panels_s", "type": "INTEGER", "description": "# of solar panels potential for south-facing roof space in that region, assuming 1.650m x 0.992m panels", "mode": "NULLABLE", }, { "name": "number_of_panels_e", "type": "INTEGER", "description": "# of solar panels potential for east-facing roof space in that region, assuming 1.650m x 0.992m panels", "mode": "NULLABLE", }, { "name": "number_of_panels_w", "type": "INTEGER", "description": "# of solar panels potential for west-facing roof space in that region, assuming 1.650m x 0.992m panels", "mode": "NULLABLE", }, { "name": "number_of_panels_f", "type": "INTEGER", "description": "# of solar panels potential for flat roof space in that region, assuming 1.650m x 0.992m panels", "mode": "NULLABLE", }, { "name": "number_of_panels_median", "type": "INTEGER", "description": "# of panels that fit on the median roof", "mode": "NULLABLE", }, { "name": "number_of_panels_total", "type": "INTEGER", "description": "# of solar panels potential for all roof space in that region, assuming 1.650m 0.992m panels", "mode": "NULLABLE", }, { "name": "kw_median", "type": "FLOAT", "description": "kW of solar potential for the median building in that region (assuming 250 watts per panel)", "mode": "NULLABLE", }, { "name": "kw_total", "type": "FLOAT", "description": "# of kW of solar potential for all roof types in that region (assuming 250 watts per panel)", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_n", "type": "FLOAT", "description": "total solar energy generation potential for north-facing roof space in that region", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_s", "type": "FLOAT", "description": "total solar energy generation potential for south-facing roof space in that region", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_e", "type": "FLOAT", "description": "total solar energy generation potential for east-facing roof space in that region", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_w", "type": "FLOAT", "description": "total solar energy generation potential for west-facing roof space in that region", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_f", "type": "FLOAT", "description": "total solar energy generation potential for flat roof space in that region", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_median", "type": "FLOAT", "description": "kWh/kw/yr for the median roof, in DC (not AC) terms", "mode": "NULLABLE", }, { "name": "yearly_sunlight_kwh_total", "type": "FLOAT", "description": "total solar energy generation potential for all roof space in that region", "mode": "NULLABLE", }, { - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -