Description
Hey everyone, I have a term project for my transportation engineering course. So I need some solution of it which includes calculation, knowing Sumo Simulation software, transportation engineering knowledge and excel. This project is very important for me so hopefully you will do it by no mistake.Thanks!
Unformatted Attachment Preview
CE 310: TRANSPORTATION ENGINEERING
TAKE-HOME PROJECT DESIGN
Problem 1 Using SUMO simulation software:
a) MODEL1: Built a simulation model of a 2-km long 3-lane freeway in west to east direction only.
The hourly demand on this freeway is 3,200 vehicles, composed of 85 percent cars and 15
percent trucks.
b) Run MODEL1 for 10 different seed values, tabulate the average travel time for each seed and
calculate the 95 percent confidence interval for the travel time on this freeway.
c) MODEL2: Modify MODEL1 so that at 1-km (meaning the middle of the freeway), the road
becomes 2-lanes.
d) Run MODEL2 for 10 different seed values, tabulate the average travel time for each seed and
calculate the 95 percent confidence interval for the travel time on this freeway.
e) Compare and comment on the results of MODEL1 and MODEL2.
Problem 2
Please read the supplementary document to this exam sheet very carefully. Also watch the instructional
video.
a) Calculate the CMF of each curve detected on the given roadway Route 152. Show your calculations. b)
Submit the Excel spreadsheet you filled out. c) KMZ file
Problem 3
A 6-lane divided highway is on a rolling terrain with only two access points per mile. The highway has 10ft lanes, with a 5-ft shoulder on the right side and a 3-ft shoulder on the left side. The peak-hour factor is
0.90. The directional peak-hour volume is 3,000 vehicles per hour. There are 6% large trucks, 2% buses,
and 2% recreational vehicles. Population adjustment factor is 0.95). Base free-flow speed is 60 mph.
a) Determine the current level of service.
b) A local supply store is to open a factory near this highway. How many large trucks can be added to the
peak-hour directional volume before LOS becomes E?
ALL SOLUTIONS MUST BE TYPE IN MS WORD.
DO NOT SEND ANY HANDWRITTEN SOLUTIONS.
1
SUBMIT A ZIPPED FILE CONTAINING:
1- MS WORD DOCUMENT CONTAINING SOLUTIONS TO PROBLEM 1 AND 3
2- MS EXCEL FILE FOR PROBLEM 2
3- KMZ FILE FOR PROBLEM 2
2
CE 310 FALL 2023
TAKE-HOME PROJECT DESIGN
SUPPLEMANTARY DOCUMENT
Extracting Horizontal Curvature Data Using Google Earth™
Background
Nearly 25 percent of fatal motor vehicle crashes occur on horizontal curves. Therefore knowing where
these curves are located and the related information such as curve radius and length are crucial in
roadway safety analyses. How much a curve increases the number of crashes is measured by the term
called Crash Modification Factor (CMF). Basically, CMF means how much percent more crashes a
curved roadway segment would have as opposed to a straight segment. In other words, assume that the
expected number of crashes per year on a straight roadway segment of length L is X crashes/year. If the
same roadway segment had been a curved segment with radius R, then the expected number of crashes
would have been Y, where Y > X. The generic formula of CMF is = ⁄ . The specific formula of
CMF is as follows:
= 1 +
51.742
.
Where, R is radius in feet and L is length in miles.
The next section presents a simple method that can be used to extract horizontal curvature information
of a given roadway.
Chord Method
The objective of this data extraction effort is to calculate the radius and length of horizontal curves along
a given roadway, which are needed to calculate the CMF as explained above. The method that is being
used here is called the “Chord Method.” This method allows us to calculate the radius without
measuring the deflection angle, I, shown in the figure below.
1
The chord method uses the locations of the start of the curve (PC) and the end of the curve (PT). The
direct link between these points is the chord. The length of this chord is denoted by LC. The distance
between the curve and the midpoint of the chord is denoted by M. Using these values, radius is
estimated using the following formula:
R = (M2 + 0.25 * LC2) / 2M
The calculated R value is highly dependent on the accurate positioning of PC and PT points.
Radius R and the length of the curve is L is used in calculating the CMF related to horizontal curvature
in calculating the expected frequency of crashes.
We will be extracting the R and L values of each horizontal curve using Google Earth.
Below are the steps for this procedure.
Set Up
Download Google Earth using the following link:
https://earth.google.com/download-earth.html
Tools->Options->3D View
Under Show Lat/Long tab, select “Decimal Degrees”
Template for Data Input
The template for data input is generated in MS Excel, named “CURVATURE DATA EXTRACTION
TEMPLATE.xlsx”.
The fields that need to be filled out are:
2
CURVE NO, PC LAT (latitude of PC), PC LONG (longitude of PT), PT LAT and PT LONG and M.
These values will be obtained from Google Earth as described below.
Curvature Extraction
(1) Make sure that the view is aerial view of the terrain and not the roadway map. Enter the start
coordinates (latitude and longitude) of the roadway of interest in the Search box located on the upper left
corner of Google Earth.
Note: The start and end coordinate of each roadway is given in the corresponding worksheet of the data
input template.
Starting from this point, follow the centerline and the outlines of the roadway to virtually detect the start
of a horizontal curve (Be very careful with this process. Zoom in as close as you can in the aerial view
and follow the roadway so as not to miss any curves. Make sure to pick the closest point for the start
of the curve).
(2) Once you make sure that the point is the start of a horizontal curve, select Add->Placemark from
the top menu or simply click on the shortcut icon on the menu bar
.
Move the Untitled Placemark to the exact point of the start of the curve (PC) along the centerline, as
shown in the figure below.
3
(3) Rename the location as PC # (Where # denotes the number of the curve along the roadway. For
example if you have identified the third curve from the start of the roadway, name the placemark as PC
3). See the figure below as an example.
(4) Copy the Latitude and Longitude values (in decimal points) without the degree sign (o) to the data
input spreadsheet template and paste it under PC LAT and PC LONG columns.
(5) Click OK to save this new Placemark.
(Note that if you save it before you copy and paste the coordinate values, you can always find the PC #
placemark from the left menu, right click on the tab and look at the Properties).
4
(6) Repeat Steps 2 through 5 for the end of the curve (PT), as shown in the figure below.
(7) Select Tools->Ruler and click on the Line tab. Measure the chord distance between PC and PT of
the curve in feet. Make sure to zoom in to PC and PT to get the most accurate reading.
Copy the length of the chord under LC column in the data input spreadsheet.
Make sure to save the line using the Save button in the Ruler window. Name the chord as LC # (Where
# signifies the curve number), as shown below.
5
(8) The data input spreadsheet calculates the midpoint of the chord drawn in Step 7. These values are
given under MID LAT and MID LONG fields. Note that these values will appear as #DIV/0! before
entering the coordinates of the PC and PT.
Copy these coordinates and enter it in the Search box located in the upper left corner of Google Earth. It
will automatically create a placemark in the middle of the chord between PC and PT, as shown below.
(9) Using the ruler (Tools->Ruler), draw a line between the centerline of the roadway perpendicular to
the LC # chord, as shown in the figure below.
6
Measure this distance in feet and record it in the data input spreadsheet under the field M.
(10) The only input that is left is the CURVE LENGTH field in the data input spreadsheet. For that we
will use the ruler again by selecting (Tools->Ruler) but this time using the tab Path. This feature allows
us to draw a path along the horizontal curvature.
Create a path along the centerline of the curve. Make sure to zoom in and draw the path as close to the
centerline as possible to get an accurate reading.
Note the total distance in feet and record it under CURVE LENGTH field in the data input spreadsheet.
7
Purchase answer to see full
attachment
