ev charging stations table structure

Lists all electric vehicle charging stations available in the model.

The number of chargers and charger types are on EV_Charging_Station_Plugs and EV_Charging_Station_Plug_Types, respectively. The cost of charging at the specific station is defined in the EV_Charging_Station_Pricing table. The number of bays available at the charging station defined in the EV_Charging_Station_Service_Bays table.

Not required by all models.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
ID*	INTEGER	NO			Unique identifier for the charging station
X	REAL	YES			X coordinate of the charging station
Y	REAL	YES			Y coordinate of the charging station
location	INTEGER	YES			Foreign key reference to the nearest record in the Location table, where this charging station is location in the model. Auto-generated with geo-consistency.
zone	INTEGER	YES			Foreign key reference to the Zone where this charging station is situated. Auto-generated with geo-consistency.
Station_Type	INTEGER	YES	1		Type of station (either public, private, or freight) denoted by the enum Values at Station_Type.
geo	POINT	YES

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS EV_Charging_Stations(
    ID           INTEGER NOT NULL PRIMARY KEY,
    X            REAL,
    Y            REAL,
    location     INTEGER,
    zone         INTEGER,
    Station_Type INTEGER DEFAULT 1
);
select AddGeometryColumn( 'EV_Charging_Stations', 'geo', SRID_PARAMETER, 'POINT', 'XY');
create INDEX IF NOT EXISTS "EV_Charging_Stations_ID_I" ON "EV_Charging_Stations" ("ID");
select CreateSpatialIndex( 'EV_Charging_Stations' , 'geo' );

Enums

The following enums are used in this table.

Station_Type

Enum Values Description

Value	Name	Description
0	PUBLIC
1	PRIVATE_TNC
2	PUBLIC_FREIGHT
3	HOME
4	WORK	outputs the snapshot from previous iteration
5	DEPOT
6	DOCK