|
@@ 77-106 (lines=30) @@
|
| 74 |
|
geom = Column(Geometry("POINT", 4326), index=True, nullable=True) |
| 75 |
|
|
| 76 |
|
|
| 77 |
|
class EgonPowerPlantsWind(Base): |
| 78 |
|
__tablename__ = "egon_power_plants_wind" |
| 79 |
|
__table_args__ = {"schema": "supply"} |
| 80 |
|
|
| 81 |
|
id = Column(Integer, Sequence("pp_wind_seq"), primary_key=True) |
| 82 |
|
bus_id = Column(Integer, nullable=True) # Grid district id |
| 83 |
|
gens_id = Column(String, nullable=True) # EinheitMastrNummer |
| 84 |
|
|
| 85 |
|
status = Column(String, nullable=True) # EinheitBetriebsstatus |
| 86 |
|
commissioning_date = Column(DateTime, nullable=True) # Inbetriebnahmedatum |
| 87 |
|
postcode = Column(String(5), nullable=True) # Postleitzahl |
| 88 |
|
city = Column(String(50), nullable=True) # Ort |
| 89 |
|
municipality = Column(String, nullable=True) # Gemeinde |
| 90 |
|
federal_state = Column(String(31), nullable=True) # Bundesland |
| 91 |
|
zip_and_municipality = Column(String, nullable=True) |
| 92 |
|
|
| 93 |
|
site_type = Column(String(17), nullable=True) # Lage |
| 94 |
|
manufacturer_name = Column(String(100), nullable=True) # Hersteller |
| 95 |
|
type_name = Column(String(100), nullable=True) # Typenbezeichnung |
| 96 |
|
hub_height = Column(Float, nullable=True) # Nabenhoehe |
| 97 |
|
rotor_diameter = Column(Float, nullable=True) # Rotordurchmesser |
| 98 |
|
|
| 99 |
|
capacity = Column(Float, nullable=True) # Nettonennleistung |
| 100 |
|
feedin_type = Column(String(47), nullable=True) # Einspeisungsart |
| 101 |
|
voltage_level = Column(Integer, nullable=True) |
| 102 |
|
voltage_level_inferred = Column(Boolean, nullable=True) |
| 103 |
|
|
| 104 |
|
geometry_geocoded = Column(Boolean) |
| 105 |
|
|
| 106 |
|
geom = Column(Geometry("POINT", 4326), index=True, nullable=True) |
| 107 |
|
|
| 108 |
|
|
| 109 |
|
class EgonPowerPlantsBiomass(Base): |
|
@@ 109-137 (lines=29) @@
|
| 106 |
|
geom = Column(Geometry("POINT", 4326), index=True, nullable=True) |
| 107 |
|
|
| 108 |
|
|
| 109 |
|
class EgonPowerPlantsBiomass(Base): |
| 110 |
|
__tablename__ = "egon_power_plants_biomass" |
| 111 |
|
__table_args__ = {"schema": "supply"} |
| 112 |
|
|
| 113 |
|
id = Column(Integer, Sequence("pp_biomass_seq"), primary_key=True) |
| 114 |
|
bus_id = Column(Integer, nullable=True) # Grid district id |
| 115 |
|
gens_id = Column(String, nullable=True) # EinheitMastrNummer |
| 116 |
|
|
| 117 |
|
status = Column(String, nullable=True) # EinheitBetriebsstatus |
| 118 |
|
commissioning_date = Column(DateTime, nullable=True) # Inbetriebnahmedatum |
| 119 |
|
postcode = Column(String(5), nullable=True) # Postleitzahl |
| 120 |
|
city = Column(String(50), nullable=True) # Ort |
| 121 |
|
municipality = Column(String, nullable=True) # Gemeinde |
| 122 |
|
federal_state = Column(String(31), nullable=True) # Bundesland |
| 123 |
|
zip_and_municipality = Column(String, nullable=True) |
| 124 |
|
|
| 125 |
|
technology = Column(String(45), nullable=True) # Technologie |
| 126 |
|
fuel_name = Column(String(52), nullable=True) # Hauptbrennstoff |
| 127 |
|
fuel_type = Column(String(19), nullable=True) # Biomasseart |
| 128 |
|
|
| 129 |
|
capacity = Column(Float, nullable=True) # Nettonennleistung |
| 130 |
|
th_capacity = Column(Float, nullable=True) # ThermischeNutzleistung |
| 131 |
|
feedin_type = Column(String(47), nullable=True) # Einspeisungsart |
| 132 |
|
voltage_level = Column(Integer, nullable=True) |
| 133 |
|
voltage_level_inferred = Column(Boolean, nullable=True) |
| 134 |
|
|
| 135 |
|
geometry_geocoded = Column(Boolean) |
| 136 |
|
|
| 137 |
|
geom = Column(Geometry("POINT", 4326), index=True, nullable=True) |
| 138 |
|
|
| 139 |
|
|
| 140 |
|
class EgonPowerPlantsHydro(Base): |
openego /
eGon-data
