| 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 |
| RoadID | StreetName | City | State | ZipCode |
|---|---|---|---|---|
| 1 | Bridge St | Springfield | IL | 62704 |
| 2 | Parkway Dr | Chicago | IL | 60616 |
| 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 |
| TypeID | Make | Model | Year |
|---|---|---|---|
| 1 | Toyota | Corolla | 2018 |
| 2 | Honda | Civic | 2019 |
| 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 |
| 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 |