Code Duplication    Length = 32-32 lines in 3 locations

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

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

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

@@ 980-1011 (lines=32) @@
977
    return df
978
979
980
class Vg250Lan(Base):
981
    __tablename__ = "vg250_lan"
982
    __table_args__ = {"schema": "boundaries"}
983
984
    id = Column(BigInteger, primary_key=True, index=True)
985
    ade = Column(BigInteger)
986
    gf = Column(BigInteger)
987
    bsg = Column(BigInteger)
988
    ars = Column(String)
989
    ags = Column(String)
990
    sdv_ars = Column(String)
991
    gen = Column(String)
992
    bez = Column(String)
993
    ibz = Column(BigInteger)
994
    bem = Column(String)
995
    nbd = Column(String)
996
    sn_l = Column(String)
997
    sn_r = Column(String)
998
    sn_k = Column(String)
999
    sn_v1 = Column(String)
1000
    sn_v2 = Column(String)
1001
    sn_g = Column(String)
1002
    fk_s3 = Column(String)
1003
    nuts = Column(String)
1004
    ars_0 = Column(String)
1005
    ags_0 = Column(String)
1006
    wsk = Column(String)
1007
    debkg_id = Column(String)
1008
    rs = Column(String)
1009
    sdv_rs = Column(String)
1010
    rs_0 = Column(String)
1011
    geometry = Column(Geometry(srid=EPSG), index=True)
1012
1013
1014
def federal_state_data(to_crs: CRS) -> gpd.GeoDataFrame: