Skip to main content

Table 3 Cypher query used to create “Moves” and “Stops” nodes

From: STVG: an evolutionary graph framework for analyzing fast-evolving networks

“Moves” nodes

“Stops” nodes

Load csv with headers from

Load csv with headers from

‘file:///data/Moves.csv’ as csv

‘file:///data/Stops.csv’ as csv

MERGE(r:Moves{MoveID: csv.moveid})

MERGE (r:Stops {StopID: csv.stopid}) ON CREATE SET

ON CREATE SET

r.TripID = csv.Tripid, r.Street = csv.streetname,

r.TripID = csv.Tripid, r.Street = csv.streetname,

r.BusStop = csv.BusStop,r.latitude = toFloat(csv.lat),

r.BusStop = csv.Busstop,

r.longitude = toFloat(csv.long),

r.latitude = toFloat(csv.lat), r.longitude = toFloat(csv.long),

r.Date = csv.Date, r.Time = csv.Time,

r.Date = csv.Date,r.Time = csv.Time, r.Sequence = toInteger(csv.sequence),r.State = csv.state,

r.Sequence = toInteger(csv.sequence),r.State = csv.state,

r.year = toInteger(substring(csv.Date,6,4)),

r.year = toInteger(substring(csv.Date,6,4)),

r.month = toInteger(substring(csv.Date,3,2)),

r.month = toInteger(substring(csv.Date,3,2)),r.day = toInteger(substring(csv.Date,0,2)),

r.day = toInteger(substring(csv. Date,0,2)),

r.hour = toInteger(substring(csv.Time,0,2));

r.hour = toInteger(substring(csv.Time,0,2));