db_classes

DB tables / SQLAlchemy ORM classes for motorized individual travel

class EgonEvCountMunicipality(**kwargs)[source]

Bases: 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: 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: 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: 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: 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: 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).

Columns

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: 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.

Columns

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

add_metadata()[source]: Add metadata to tables egon_ev_metadata, egon_ev_mv_grid_district, egon_ev_trip in schema demand