Code Duplication    Length = 32-32 lines in 3 locations

src/egon/data/datasets/power_plants/pv_rooftop_buildings.py 1 location

@@ 970-1001 (lines=32) @@
967
    return df
968
969
970
class Vg250Lan(Base):
971
    """
972
    Class definition of table boundaries.vg250_lan.
973
974
    """
975
    __tablename__ = "vg250_lan"
976
    __table_args__ = {"schema": "boundaries"}
977
978
    id = Column(BigInteger, primary_key=True, index=True)
979
    ade = Column(BigInteger)
980
    gf = Column(BigInteger)
981
    bsg = Column(BigInteger)
982
    ars = Column(String)
983
    ags = Column(String)
984
    sdv_ars = Column(String)
985
    gen = Column(String)
986
    bez = Column(String)
987
    ibz = Column(BigInteger)
988
    bem = Column(String)
989
    nbd = Column(String)
990
    sn_l = Column(String)
991
    sn_r = Column(String)
992
    sn_k = Column(String)
993
    sn_v1 = Column(String)
994
    sn_v2 = Column(String)
995
    sn_g = Column(String)
996
    fk_s3 = Column(String)
997
    nuts = Column(String)
998
    ars_0 = Column(String)
999
    ags_0 = Column(String)
1000
    wsk = Column(String)
1001
    debkg_id = Column(String)
1002
    rs = Column(String)
1003
    sdv_rs = Column(String)
1004
    rs_0 = Column(String)

src/egon/data/datasets/zensus_vg250.py 2 locations

@@ 87-118 (lines=32) @@
84
    geometry = Column(Geometry(srid=4326), index=True)
85
86
87
class Vg250Gem(Base):
88
    __tablename__ = "vg250_gem"
89
    __table_args__ = {"schema": "boundaries"}
90
91
    id = Column(BigInteger, primary_key=True, index=True)
92
    ade = Column(BigInteger)
93
    gf = Column(BigInteger)
94
    bsg = Column(BigInteger)
95
    ars = Column(String)
96
    ags = Column(String)
97
    sdv_ars = Column(String)
98
    gen = Column(String)
99
    bez = Column(String)
100
    ibz = Column(BigInteger)
101
    bem = Column(String)
102
    nbd = Column(String)
103
    sn_l = Column(String)
104
    sn_r = Column(String)
105
    sn_k = Column(String)
106
    sn_v1 = Column(String)
107
    sn_v2 = Column(String)
108
    sn_g = Column(String)
109
    fk_s3 = Column(String)
110
    nuts = Column(String)
111
    ars_0 = Column(String)
112
    ags_0 = Column(String)
113
    wsk = Column(String)
114
    debkg_id = Column(String)
115
    rs = Column(String)
116
    sdv_rs = Column(String)
117
    rs_0 = Column(String)
118
    geometry = Column(Geometry(srid=4326), index=True)
119
120
121
class DestatisZensusPopulationPerHa(Base):
@@ 53-84 (lines=32) @@
50
        )
51
52
53
class Vg250Sta(Base):
54
    __tablename__ = "vg250_sta"
55
    __table_args__ = {"schema": "boundaries"}
56
57
    id = Column(BigInteger, primary_key=True, index=True)
58
    ade = Column(BigInteger)
59
    gf = Column(BigInteger)
60
    bsg = Column(BigInteger)
61
    ars = Column(String)
62
    ags = Column(String)
63
    sdv_ars = Column(String)
64
    gen = Column(String)
65
    bez = Column(String)
66
    ibz = Column(BigInteger)
67
    bem = Column(String)
68
    nbd = Column(String)
69
    sn_l = Column(String)
70
    sn_r = Column(String)
71
    sn_k = Column(String)
72
    sn_v1 = Column(String)
73
    sn_v2 = Column(String)
74
    sn_g = Column(String)
75
    fk_s3 = Column(String)
76
    nuts = Column(String)
77
    ars_0 = Column(String)
78
    ags_0 = Column(String)
79
    wsk = Column(String)
80
    debkg_id = Column(String)
81
    rs = Column(String)
82
    sdv_rs = Column(String)
83
    rs_0 = Column(String)
84
    geometry = Column(Geometry(srid=4326), index=True)
85
86
87
class Vg250Gem(Base):