@@ 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): |
@@ 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: |