United States Offshore Wind Supply Curves 2024
Department of Energy
@usgov.doe_gov_offshore_wind_composite_siting_exclusions_scenarios
Department of Energy
@usgov.doe_gov_offshore_wind_composite_siting_exclusions_scenarios
CREATE TABLE limited_scenario_supply_curve (
"latitude" DOUBLE,
"longitude" DOUBLE,
"sc_point_gid" BIGINT,
"sc_gid" BIGINT,
"resource" DOUBLE,
"area_developable_sq_km" DOUBLE,
"capacity_ac_mw" DOUBLE,
"mean_depth" DOUBLE,
"mean_dist_p_to_s" DOUBLE,
"mean_wake_losses_means" DOUBLE,
"dist_to_coast_offshore" DOUBLE,
"dist_spur_km" DOUBLE,
"dist_export_km" DOUBLE,
"dist_reinforcement_km" DOUBLE,
"cost_spur_usd_per_mw" DOUBLE,
"cost_poi_usd_per_mw" BIGINT,
"cost_export_usd_per_mw" DOUBLE,
"cost_reinforcement_usd_per_mw" DOUBLE,
"cost_total_trans_usd_per_mw" DOUBLE,
"lcot_usd_per_mwh" DOUBLE,
"offtake_state" VARCHAR,
"cost_occ_2035_usd_per_mw" DOUBLE,
"cost_opex_2035_usd_per_mw" DOUBLE,
"ncf_2035" DOUBLE,
"technology" VARCHAR,
"site_lcoe_usd_per_mwh_2035" DOUBLE,
"all_in_lcoe_2035" DOUBLE
);
CREATE TABLE open_scenario_supply_curve (
"latitude" DOUBLE,
"longitude" DOUBLE,
"sc_point_gid" BIGINT,
"sc_gid" BIGINT,
"resource" DOUBLE,
"area_developable_sq_km" DOUBLE,
"capacity_ac_mw" DOUBLE,
"mean_depth" DOUBLE,
"mean_dist_p_to_s" DOUBLE,
"mean_wake_losses_means" DOUBLE,
"dist_to_coast_offshore" DOUBLE,
"dist_spur_km" DOUBLE,
"dist_export_km" DOUBLE,
"dist_reinforcement_km" DOUBLE,
"cost_spur_usd_per_mw" DOUBLE,
"cost_poi_usd_per_mw" BIGINT,
"cost_export_usd_per_mw" DOUBLE,
"cost_reinforcement_usd_per_mw" DOUBLE,
"cost_total_trans_usd_per_mw" DOUBLE,
"lcot_usd_per_mwh" DOUBLE,
"offtake_state" VARCHAR,
"cost_occ_2035_usd_per_mw" DOUBLE,
"cost_opex_2035_usd_per_mw" DOUBLE,
"ncf_2035" DOUBLE,
"technology" VARCHAR,
"site_lcoe_usd_per_mwh_2035" DOUBLE,
"all_in_lcoe_2035" DOUBLE
);
CREATE TABLE reference_scenario_supply_curve (
"latitude" DOUBLE,
"longitude" DOUBLE,
"sc_point_gid" BIGINT,
"sc_gid" BIGINT,
"resource" DOUBLE,
"area_developable_sq_km" DOUBLE,
"capacity_ac_mw" DOUBLE,
"mean_depth" DOUBLE,
"mean_dist_p_to_s" DOUBLE,
"mean_wake_losses_means" DOUBLE,
"dist_to_coast_offshore" DOUBLE,
"dist_spur_km" DOUBLE,
"dist_export_km" DOUBLE,
"dist_reinforcement_km" DOUBLE,
"cost_spur_usd_per_mw" DOUBLE,
"cost_poi_usd_per_mw" BIGINT,
"cost_export_usd_per_mw" DOUBLE,
"cost_reinforcement_usd_per_mw" DOUBLE,
"cost_total_trans_usd_per_mw" DOUBLE,
"lcot_usd_per_mwh" DOUBLE,
"offtake_state" VARCHAR,
"cost_occ_2035_usd_per_mw" DOUBLE,
"cost_opex_2035_usd_per_mw" DOUBLE,
"ncf_2035" DOUBLE,
"technology" VARCHAR,
"site_lcoe_usd_per_mwh_2035" DOUBLE,
"all_in_lcoe_2035" DOUBLE
);
Anyone who has the link will be able to view this.