CivilEngineers

ProjectIDIntersectionCivil_EngineerEngineering_FirmStartDateEndDateBudget
1Main St & Oak AveJohn DoeABC Engineering2021-06-012021-09-30500000.0
2Elm St & Pine AveJane SmithXYZ Engineering2021-07-012021-10-31600000.0

Roads

RoadIDStreetNameCityStateZipCode
1Bridge StSpringfieldIL62704
2Parkway DrChicagoIL60616

Accidents

AccidentIDDateOfAccidentTimeOfAccidentLocationTextLatitudeLongitudeSeverity
12021-08-0110:30 AMMain St & Oak Ave40.0-89.0Minor
22021-08-0211:15 AMElm St & Pine Ave41.0-90.0Moderate

VehicleTypes

TypeIDMakeModelYear
1ToyotaCorolla2018
2HondaCivic2019

Drivers

DriverIDLicenseNumberNameAddressPhoneNumber
1A1234CDAlice Johnson123 Main St, Springfield, IL555-123-4567
2BCDEFGHBob Smith456 Elm St, Chicago, IL555-987-6543

PoliceReports

ReportIDDateReportedOfficerIDAccidentIDOffenseTypePenalty
12021-08-0111SpeedingWarning
22021-08-0222Running Red Light$100 Fine