Code Duplication    Length = 32-32 lines in 3 locations

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

@@ 984-1015 (lines=32) @@
981
    return df
982
983
984
class Vg250Lan(Base):
985
    """
986
    Class definition of table boundaries.vg250_lan.
987
988
    """
989
990
    __tablename__ = "vg250_lan"
991
    __table_args__ = {"schema": "boundaries"}
992
993
    id = Column(BigInteger, primary_key=True, index=True)
994
    ade = Column(BigInteger)
995
    gf = Column(BigInteger)
996
    bsg = Column(BigInteger)
997
    ars = Column(String)
998
    ags = Column(String)
999
    sdv_ars = Column(String)
1000
    gen = Column(String)
1001
    bez = Column(String)
1002
    ibz = Column(BigInteger)
1003
    bem = Column(String)
1004
    nbd = Column(String)
1005
    sn_l = Column(String)
1006
    sn_r = Column(String)
1007
    sn_k = Column(String)
1008
    sn_v1 = Column(String)
1009
    sn_v2 = Column(String)
1010
    sn_g = Column(String)
1011
    fk_s3 = Column(String)
1012
    nuts = Column(String)
1013
    ars_0 = Column(String)
1014
    ags_0 = Column(String)
1015
    wsk = Column(String)
1016
    debkg_id = Column(String)
1017
    rs = Column(String)
1018
    sdv_rs = 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):