## CivilEngineers

ProjectID | Intersection | Civil_Engineer | Engineering_Firm | StartDate | EndDate | Budget
--- | --- | --- | --- | --- | --- | ---
1 | Main St & Oak Ave | John Doe | ABC Engineering | 2021-06-01 | 2021-09-30 | 500000.0
2 | Elm St & Pine Ave | Jane Smith | XYZ Engineering | 2021-07-01 | 2021-10-31 | 600000.0

## Roads

RoadID | StreetName | City | State | ZipCode
--- | --- | --- | --- | ---
1 | Bridge St | Springfield | IL | 62704
2 | Parkway Dr | Chicago | IL | 60616

## Accidents

AccidentID | DateOfAccident | TimeOfAccident | LocationText | Latitude | Longitude | Severity
--- | --- | --- | --- | --- | --- | ---
1 | 2021-08-01 | 10:30 AM | Main St & Oak Ave | 40.0 | -89.0 | Minor
2 | 2021-08-02 | 11:15 AM | Elm St & Pine Ave | 41.0 | -90.0 | Moderate

## VehicleTypes

TypeID | Make | Model | Year
--- | --- | --- | ---
1 | Toyota | Corolla | 2018
2 | Honda | Civic | 2019

## Drivers

DriverID | LicenseNumber | Name | Address | PhoneNumber
--- | --- | --- | --- | ---
1 | A1234CD | Alice Johnson | 123 Main St, Springfield, IL | 555-123-4567
2 | BCDEFGH | Bob Smith | 456 Elm St, Chicago, IL | 555-987-6543

## PoliceReports

ReportID | DateReported | OfficerID | AccidentID | OffenseType | Penalty
--- | --- | --- | --- | --- | ---
1 | 2021-08-01 | 1 | 1 | Speeding | Warning
2 | 2021-08-02 | 2 | 2 | Running Red Light | $100 Fine