openego /
eGon-data
| @@ 70-101 (lines=32) @@ | ||
| 67 | geometry = Column(Geometry(srid=4326), index=True) |
|
| 68 | ||
| 69 | ||
| 70 | class Vg250Gem(Base): |
|
| 71 | __tablename__ = "vg250_gem" |
|
| 72 | __table_args__ = {"schema": "boundaries"} |
|
| 73 | ||
| 74 | id = Column(BigInteger, primary_key=True, index=True) |
|
| 75 | ade = Column(BigInteger) |
|
| 76 | gf = Column(BigInteger) |
|
| 77 | bsg = Column(BigInteger) |
|
| 78 | ars = Column(String) |
|
| 79 | ags = Column(String) |
|
| 80 | sdv_ars = Column(String) |
|
| 81 | gen = Column(String) |
|
| 82 | bez = Column(String) |
|
| 83 | ibz = Column(BigInteger) |
|
| 84 | bem = Column(String) |
|
| 85 | nbd = Column(String) |
|
| 86 | sn_l = Column(String) |
|
| 87 | sn_r = Column(String) |
|
| 88 | sn_k = Column(String) |
|
| 89 | sn_v1 = Column(String) |
|
| 90 | sn_v2 = Column(String) |
|
| 91 | sn_g = Column(String) |
|
| 92 | fk_s3 = Column(String) |
|
| 93 | nuts = Column(String) |
|
| 94 | ars_0 = Column(String) |
|
| 95 | ags_0 = Column(String) |
|
| 96 | wsk = Column(String) |
|
| 97 | debkg_id = Column(String) |
|
| 98 | rs = Column(String) |
|
| 99 | sdv_rs = Column(String) |
|
| 100 | rs_0 = Column(String) |
|
| 101 | geometry = Column(Geometry(srid=4326), index=True) |
|
| 102 | ||
| 103 | ||
| 104 | class DestatisZensusPopulationPerHa(Base): |
|
| @@ 36-67 (lines=32) @@ | ||
| 33 | ) |
|
| 34 | ||
| 35 | ||
| 36 | class Vg250Sta(Base): |
|
| 37 | __tablename__ = "vg250_sta" |
|
| 38 | __table_args__ = {"schema": "boundaries"} |
|
| 39 | ||
| 40 | id = Column(BigInteger, primary_key=True, index=True) |
|
| 41 | ade = Column(BigInteger) |
|
| 42 | gf = Column(BigInteger) |
|
| 43 | bsg = Column(BigInteger) |
|
| 44 | ars = Column(String) |
|
| 45 | ags = Column(String) |
|
| 46 | sdv_ars = Column(String) |
|
| 47 | gen = Column(String) |
|
| 48 | bez = Column(String) |
|
| 49 | ibz = Column(BigInteger) |
|
| 50 | bem = Column(String) |
|
| 51 | nbd = Column(String) |
|
| 52 | sn_l = Column(String) |
|
| 53 | sn_r = Column(String) |
|
| 54 | sn_k = Column(String) |
|
| 55 | sn_v1 = Column(String) |
|
| 56 | sn_v2 = Column(String) |
|
| 57 | sn_g = Column(String) |
|
| 58 | fk_s3 = Column(String) |
|
| 59 | nuts = Column(String) |
|
| 60 | ars_0 = Column(String) |
|
| 61 | ags_0 = Column(String) |
|
| 62 | wsk = Column(String) |
|
| 63 | debkg_id = Column(String) |
|
| 64 | rs = Column(String) |
|
| 65 | sdv_rs = Column(String) |
|
| 66 | rs_0 = Column(String) |
|
| 67 | geometry = Column(Geometry(srid=4326), index=True) |
|
| 68 | ||
| 69 | ||
| 70 | class Vg250Gem(Base): |
|
| @@ 1370-1401 (lines=32) @@ | ||
| 1367 | return df |
|
| 1368 | ||
| 1369 | ||
| 1370 | class Vg250Lan(Base): |
|
| 1371 | __tablename__ = "vg250_lan" |
|
| 1372 | __table_args__ = {"schema": "boundaries"} |
|
| 1373 | ||
| 1374 | id = Column(BigInteger, primary_key=True, index=True) |
|
| 1375 | ade = Column(BigInteger) |
|
| 1376 | gf = Column(BigInteger) |
|
| 1377 | bsg = Column(BigInteger) |
|
| 1378 | ars = Column(String) |
|
| 1379 | ags = Column(String) |
|
| 1380 | sdv_ars = Column(String) |
|
| 1381 | gen = Column(String) |
|
| 1382 | bez = Column(String) |
|
| 1383 | ibz = Column(BigInteger) |
|
| 1384 | bem = Column(String) |
|
| 1385 | nbd = Column(String) |
|
| 1386 | sn_l = Column(String) |
|
| 1387 | sn_r = Column(String) |
|
| 1388 | sn_k = Column(String) |
|
| 1389 | sn_v1 = Column(String) |
|
| 1390 | sn_v2 = Column(String) |
|
| 1391 | sn_g = Column(String) |
|
| 1392 | fk_s3 = Column(String) |
|
| 1393 | nuts = Column(String) |
|
| 1394 | ars_0 = Column(String) |
|
| 1395 | ags_0 = Column(String) |
|
| 1396 | wsk = Column(String) |
|
| 1397 | debkg_id = Column(String) |
|
| 1398 | rs = Column(String) |
|
| 1399 | sdv_rs = Column(String) |
|
| 1400 | rs_0 = Column(String) |
|
| 1401 | geometry = Column(Geometry(srid=EPSG), index=True) |
|
| 1402 | ||
| 1403 | ||
| 1404 | def federal_state_data(to_crs: CRS) -> gpd.GeoDataFrame: |
|
