openego /
eGon-data
| @@ 41-62 (lines=22) @@ | ||
| 38 | status = Column(Integer) |
|
| 39 | ||
| 40 | ||
| 41 | class EgonHvmvSubstation(Base): |
|
| 42 | __tablename__ = "egon_hvmv_substation" |
|
| 43 | __table_args__ = {"schema": "grid"} |
|
| 44 | bus_id = Column( |
|
| 45 | Integer, |
|
| 46 | primary_key=True, |
|
| 47 | ) |
|
| 48 | lon = Column(Float(53)) |
|
| 49 | lat = Column(Float(53)) |
|
| 50 | point = Column(Geometry("POINT", 4326), index=True) |
|
| 51 | polygon = Column(Geometry) |
|
| 52 | voltage = Column(Text) |
|
| 53 | power_type = Column(Text) |
|
| 54 | substation = Column(Text) |
|
| 55 | osm_id = Column(Text) |
|
| 56 | osm_www = Column(Text) |
|
| 57 | frequency = Column(Text) |
|
| 58 | subst_name = Column(Text) |
|
| 59 | ref = Column(Text) |
|
| 60 | operator = Column(Text) |
|
| 61 | dbahn = Column(Text) |
|
| 62 | status = Column(Integer) |
|
| 63 | ||
| 64 | ||
| 65 | def create_tables(): |
|
| @@ 17-38 (lines=22) @@ | ||
| 14 | Base = declarative_base() |
|
| 15 | ||
| 16 | ||
| 17 | class EgonEhvSubstation(Base): |
|
| 18 | __tablename__ = "egon_ehv_substation" |
|
| 19 | __table_args__ = {"schema": "grid"} |
|
| 20 | bus_id = Column( |
|
| 21 | Integer, |
|
| 22 | primary_key=True, |
|
| 23 | ) |
|
| 24 | lon = Column(Float(53)) |
|
| 25 | lat = Column(Float(53)) |
|
| 26 | point = Column(Geometry("POINT", 4326), index=True) |
|
| 27 | polygon = Column(Geometry) |
|
| 28 | voltage = Column(Text) |
|
| 29 | power_type = Column(Text) |
|
| 30 | substation = Column(Text) |
|
| 31 | osm_id = Column(Text) |
|
| 32 | osm_www = Column(Text) |
|
| 33 | frequency = Column(Text) |
|
| 34 | subst_name = Column(Text) |
|
| 35 | ref = Column(Text) |
|
| 36 | operator = Column(Text) |
|
| 37 | dbahn = Column(Text) |
|
| 38 | status = Column(Integer) |
|
| 39 | ||
| 40 | ||
| 41 | class EgonHvmvSubstation(Base): |
|
