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