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