Code Duplication    Length = 29-30 lines in 2 locations

src/egon/data/datasets/power_plants/mastr_db_classes.py 2 locations

@@ 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"