openego /
eGon-data
| @@ 1467-1498 (lines=32) @@ | ||
| 1464 | return df |
|
| 1465 | ||
| 1466 | ||
| 1467 | class Vg250Lan(Base): |
|
| 1468 | __tablename__ = "vg250_lan" |
|
| 1469 | __table_args__ = {"schema": "boundaries"} |
|
| 1470 | ||
| 1471 | id = Column(BigInteger, primary_key=True, index=True) |
|
| 1472 | ade = Column(BigInteger) |
|
| 1473 | gf = Column(BigInteger) |
|
| 1474 | bsg = Column(BigInteger) |
|
| 1475 | ars = Column(String) |
|
| 1476 | ags = Column(String) |
|
| 1477 | sdv_ars = Column(String) |
|
| 1478 | gen = Column(String) |
|
| 1479 | bez = Column(String) |
|
| 1480 | ibz = Column(BigInteger) |
|
| 1481 | bem = Column(String) |
|
| 1482 | nbd = Column(String) |
|
| 1483 | sn_l = Column(String) |
|
| 1484 | sn_r = Column(String) |
|
| 1485 | sn_k = Column(String) |
|
| 1486 | sn_v1 = Column(String) |
|
| 1487 | sn_v2 = Column(String) |
|
| 1488 | sn_g = Column(String) |
|
| 1489 | fk_s3 = Column(String) |
|
| 1490 | nuts = Column(String) |
|
| 1491 | ars_0 = Column(String) |
|
| 1492 | ags_0 = Column(String) |
|
| 1493 | wsk = Column(String) |
|
| 1494 | debkg_id = Column(String) |
|
| 1495 | rs = Column(String) |
|
| 1496 | sdv_rs = Column(String) |
|
| 1497 | rs_0 = Column(String) |
|
| 1498 | geometry = Column(Geometry(srid=EPSG), index=True) |
|
| 1499 | ||
| 1500 | ||
| 1501 | def federal_state_data(to_crs: CRS) -> gpd.GeoDataFrame: |
|
| @@ 86-117 (lines=32) @@ | ||
| 83 | geometry = Column(Geometry(srid=4326), index=True) |
|
| 84 | ||
| 85 | ||
| 86 | class Vg250Gem(Base): |
|
| 87 | __tablename__ = "vg250_gem" |
|
| 88 | __table_args__ = {"schema": "boundaries"} |
|
| 89 | ||
| 90 | id = Column(BigInteger, primary_key=True, index=True) |
|
| 91 | ade = Column(BigInteger) |
|
| 92 | gf = Column(BigInteger) |
|
| 93 | bsg = Column(BigInteger) |
|
| 94 | ars = Column(String) |
|
| 95 | ags = Column(String) |
|
| 96 | sdv_ars = Column(String) |
|
| 97 | gen = Column(String) |
|
| 98 | bez = Column(String) |
|
| 99 | ibz = Column(BigInteger) |
|
| 100 | bem = Column(String) |
|
| 101 | nbd = Column(String) |
|
| 102 | sn_l = Column(String) |
|
| 103 | sn_r = Column(String) |
|
| 104 | sn_k = Column(String) |
|
| 105 | sn_v1 = Column(String) |
|
| 106 | sn_v2 = Column(String) |
|
| 107 | sn_g = Column(String) |
|
| 108 | fk_s3 = Column(String) |
|
| 109 | nuts = Column(String) |
|
| 110 | ars_0 = Column(String) |
|
| 111 | ags_0 = Column(String) |
|
| 112 | wsk = Column(String) |
|
| 113 | debkg_id = Column(String) |
|
| 114 | rs = Column(String) |
|
| 115 | sdv_rs = Column(String) |
|
| 116 | rs_0 = Column(String) |
|
| 117 | geometry = Column(Geometry(srid=4326), index=True) |
|
| 118 | ||
| 119 | ||
| 120 | class DestatisZensusPopulationPerHa(Base): |
|
| @@ 52-83 (lines=32) @@ | ||
| 49 | ) |
|
| 50 | ||
| 51 | ||
| 52 | class Vg250Sta(Base): |
|
| 53 | __tablename__ = "vg250_sta" |
|
| 54 | __table_args__ = {"schema": "boundaries"} |
|
| 55 | ||
| 56 | id = Column(BigInteger, primary_key=True, index=True) |
|
| 57 | ade = Column(BigInteger) |
|
| 58 | gf = Column(BigInteger) |
|
| 59 | bsg = Column(BigInteger) |
|
| 60 | ars = Column(String) |
|
| 61 | ags = Column(String) |
|
| 62 | sdv_ars = Column(String) |
|
| 63 | gen = Column(String) |
|
| 64 | bez = Column(String) |
|
| 65 | ibz = Column(BigInteger) |
|
| 66 | bem = Column(String) |
|
| 67 | nbd = Column(String) |
|
| 68 | sn_l = Column(String) |
|
| 69 | sn_r = Column(String) |
|
| 70 | sn_k = Column(String) |
|
| 71 | sn_v1 = Column(String) |
|
| 72 | sn_v2 = Column(String) |
|
| 73 | sn_g = Column(String) |
|
| 74 | fk_s3 = Column(String) |
|
| 75 | nuts = Column(String) |
|
| 76 | ars_0 = Column(String) |
|
| 77 | ags_0 = Column(String) |
|
| 78 | wsk = Column(String) |
|
| 79 | debkg_id = Column(String) |
|
| 80 | rs = Column(String) |
|
| 81 | sdv_rs = Column(String) |
|
| 82 | rs_0 = Column(String) |
|
| 83 | geometry = Column(Geometry(srid=4326), index=True) |
|
| 84 | ||
| 85 | ||
| 86 | class Vg250Gem(Base): |
|
