options
string(815) "SELECT (((ACOS(SIN(r.lat * PI() / 180) * SIN(i.lat * PI() / 180) + COS(r.lat * PI() / 180) * COS(i.lat * PI() / 180) * COS((r.lon - i.lon) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) * 1.609344) AS distance, ABS(TIMESTAMPDIFF(SECOND,r.first_reported,i.first_reported)) as seconds_difference, i.id, i.severity, i.region, i.location, i.type, i.advice, i.response, i.last_updated, i.first_reported, i.suburb, i.lat, i.lon, i.code, i.accuracy, i.state, TIMESTAMPDIFF(SECOND,i.last_updated,REPLACE_TIME) as ago, TIMESTAMPDIFF(SECOND,i.first_reported,REPLACE_TIME) as timeago, i.suburb_links, i.lanes, i.extrainfo, i.reported_by_department, i.ended FROM incidents i, incidents r WHERE r.id = 175592 AND i.code = "Y" AND i.accuracy >= 4 AND i.id != 175592 HAVING distance < 3.000 ORDER BY seconds_difference ASC LIMIT 0, 2"
Incident Details
This incident has ended.
Suburb Wahroonga
Location M1 Pacific Motorway (F3) near Pacific Highway
Lanes Northbound - 1(Lane 1) of 3 lanes closed
Region Sydney North
Reported 28 Aug, 2013 - 11:48 AM
Updated 28 Aug, 2013 - 12:15 PM
Type Breakdown - Truck
Information
Source Transport for NSW