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
¶