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 |