openego /
eGon-data
| @@ 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): |
|
| @@ 1424-1455 (lines=32) @@ | ||
| 1421 | return df |
|
| 1422 | ||
| 1423 | ||
| 1424 | class Vg250Lan(Base): |
|
| 1425 | __tablename__ = "vg250_lan" |
|
| 1426 | __table_args__ = {"schema": "boundaries"} |
|
| 1427 | ||
| 1428 | id = Column(BigInteger, primary_key=True, index=True) |
|
| 1429 | ade = Column(BigInteger) |
|
| 1430 | gf = Column(BigInteger) |
|
| 1431 | bsg = Column(BigInteger) |
|
| 1432 | ars = Column(String) |
|
| 1433 | ags = Column(String) |
|
| 1434 | sdv_ars = Column(String) |
|
| 1435 | gen = Column(String) |
|
| 1436 | bez = Column(String) |
|
| 1437 | ibz = Column(BigInteger) |
|
| 1438 | bem = Column(String) |
|
| 1439 | nbd = Column(String) |
|
| 1440 | sn_l = Column(String) |
|
| 1441 | sn_r = Column(String) |
|
| 1442 | sn_k = Column(String) |
|
| 1443 | sn_v1 = Column(String) |
|
| 1444 | sn_v2 = Column(String) |
|
| 1445 | sn_g = Column(String) |
|
| 1446 | fk_s3 = Column(String) |
|
| 1447 | nuts = Column(String) |
|
| 1448 | ars_0 = Column(String) |
|
| 1449 | ags_0 = Column(String) |
|
| 1450 | wsk = Column(String) |
|
| 1451 | debkg_id = Column(String) |
|
| 1452 | rs = Column(String) |
|
| 1453 | sdv_rs = Column(String) |
|
| 1454 | rs_0 = Column(String) |
|
| 1455 | geometry = Column(Geometry(srid=EPSG), index=True) |
|
| 1456 | ||
| 1457 | ||
| 1458 | def federal_state_data(to_crs: CRS) -> gpd.GeoDataFrame: |
|
