db_classes

DB tables / SQLAlchemy ORM classes for motorized individual travel

class EgonEvCountMunicipality(**kwargs)[source]

Bases: sqlalchemy.ext.declarative.api.Base

Class definition of table demand.egon_ev_count_municipality.

Contains electric vehicle counts per municipality.

ags
bev_luxury
bev_medium
bev_mini
phev_luxury
phev_medium
phev_mini
rs7_id
scenario
scenario_variation
class EgonEvCountMvGridDistrict(**kwargs)[source]

Bases: sqlalchemy.ext.declarative.api.Base

Class definition of table demand.egon_ev_count_mv_grid_district.

Contains electric vehicle counts per MV grid district.

bev_luxury
bev_medium
bev_mini
bus_id
phev_luxury
phev_medium
phev_mini
rs7_id
scenario
scenario_variation
class EgonEvCountRegistrationDistrict(**kwargs)[source]

Bases: sqlalchemy.ext.declarative.api.Base

Class definition of table demand.egon_ev_count_registration_district.

Contains electric vehicle counts per registration district.

ags_reg_district
bev_luxury
bev_medium
bev_mini
phev_luxury
phev_medium
phev_mini
reg_district
scenario
scenario_variation
class EgonEvMetadata(**kwargs)[source]

Bases: sqlalchemy.ext.declarative.api.Base

Class definition of table demand.egon_ev_metadata.

Contains EV Pool Metadata.

end_date
eta_cp
grid_timeseries
grid_timeseries_by_usecase
scenario
soc_min
start_date
stepsize
class EgonEvMvGridDistrict(**kwargs)[source]

Bases: sqlalchemy.ext.declarative.api.Base

Class definition of table demand.egon_ev_mv_grid_district.

Contains list of electric vehicles per MV grid district.

bus_id
egon_ev_pool_ev_id
id
scenario
scenario_variation
class EgonEvPool(**kwargs)[source]

Bases: sqlalchemy.ext.declarative.api.Base

Class definition of table demand.egon_ev_pool.

Each row is one EV, uniquely defined by either (ev_id) or (rs7_id, type, simbev_id).

ev_id:
Unique id of EV
rs7_id:
id of RegioStar7 region
type:
type of EV, one of
  • bev_mini
  • bev_medium
  • bev_luxury
  • phev_mini
  • phev_medium
  • phev_luxury
simbev_ev_id:
id of EV as exported by simBEV
ev_id
rs7_id
scenario
simbev_ev_id
type
class EgonEvTrip(**kwargs)[source]

Bases: sqlalchemy.ext.declarative.api.Base

Class definition of table demand.egon_ev_trip.

Each row is one event of a specific electric vehicle which is uniquely defined by rs7_id, ev_id and event_id.

scenario:
Scenario
event_id:
Unique id of EV event
egon_ev_pool_ev_id:
id of EV, references EgonEvPool.ev_id
simbev_event_id:
id of EV event, unique within a specific EV dataset
location:
Location of EV event, one of
  • “0_work”
  • “1_business”
  • “2_school”
  • “3_shopping”
  • “4_private/ridesharing”
  • “5_leisure”
  • “6_home”
  • “7_charging_hub”
  • “driving”
use_case:
Use case of EV event, one of
  • “public” (public charging)
  • “home” (private charging at 6_home)
  • “work” (private charging at 0_work)
  • <empty> (driving events)
charging_capacity_nominal:
Nominal charging capacity in kW
charging_capacity_grid:
Charging capacity at grid side in kW, includes efficiency of charging infrastructure
charging_capacity_battery:
Charging capacity at battery side in kW, includes efficiency of car charger
soc_start:
State of charge at start of event
soc_start:
State of charge at end of event
charging_demand:
Energy demand during parking/charging event in kWh. 0 if no charging takes place.
park_start:
Start timestep of parking event (15min interval, e.g. 4 = 1h)
park_end:
End timestep of parking event (15min interval)
drive_start:
Start timestep of driving event (15min interval)
drive_end:
End timestep of driving event (15min interval)
consumption:
Energy demand during driving event in kWh

Notes

pgSQL’s REAL is sufficient for floats as simBEV rounds output to 4 digits.

charging_capacity_battery
charging_capacity_grid
charging_capacity_nominal
charging_demand
consumption
drive_end
drive_start
egon_ev_pool_ev_id
event_id
location
park_end
park_start
scenario
simbev_event_id
soc_end
soc_start
use_case