HomeMy WebLinkAboutUNI_GeoTree_-_GIS_Services_-_4.7.2025 Docusign Envelope ID:722763F4-1 F54-4496-BA4C-953837DF90A0
Contract for Services
Contractor: University of Northern Iowa, Issuing Institution/Organization Name: City of Waterloo
henceforth "Service Provider" henceforth "Sponsor"
Contract#: 25-0118 Contract Value: $9,585 Source $ Federal? CFDA#
YesN No ❑
Period of Performance: Start Date: 3/15/2025 End Date: 8/31/2025
Project Title: Digitization of on-street traffic markings for the City of Waterloo Traffic Operations
Cost Reimbursable
Financial Terms: x Firm Fixed Price Deliverables Based
Firm Fixed Price Unit Based
Other(describe):
Travel priced and paid separately from fixed price quote
Terms and Conditions
1. General Statement: This Contract for Services, henceforth referred to as "Contract", is between Service Provider
and Sponsor to complete the scope of work provided in Attachment 2. In performing the stated scope of work
Service Provider shall operate as an independent entity and not an employee or agent of Sponsor. Service
Provider shall not subcontract any aspects of the project without prior written approval by Sponsor.
2. Invoicing & Payments: Sponsor shall pay Service Provider an amount not to exceed the Project Cost identified in
the second line of this Contract for the services identified in Attachment 2 according to the generally accepted
terms of the contract type identified in the Financial Terms section above. Payments will be made based on
Service Provider standard invoice template. Service Provider shall invoice no more than monthly. A final invoice
marked "Final" will be submitted to Sponsor no later than 90 days after the end date of this Contract. Service
Provider shall include a copy of the invoice with payment. Service Provider shall submit just one invoice at the
end of the period of performance and once services are provided for the full lump sum of this agreement..
3. Allowable Costs: Allowable costs and expenditures shall follow Sponsor's financial acquisition and expensing
policies and shall not be in violation of applicable Iowa Code and the Iowa Administrative Code. No costs shall be
incurred under this Contract prior to the start date or after the end date of this Contract.
4. Service Provider Internal Financial Controls: Service Provider hereby certifies that it has financial internal
controls in place that ensure industry applicable regulatory compliance and adherence to industry standard cost
accounting systems.
5. Technical Reporting: Matters concerning Service Provider technical performance should be directed to the
Service Provider Technical Contact. Reporting intervals and formatting requirements, if applicable, shall be
described in Attachment 2.
6. Administrative Requests: Changes to the terms and conditions of this Contract must be done so via bilaterally
agreed upon written amendment.
7. Indemnification: Each party shall be responsible for its negligent acts or omissions and the negligent acts or
omissions of its employees, officers, directors, and agents to the extent allowed by law.
8. Copyright: All copyrightable materials developed during the implementation of this contract's scope of work, such
as but not limited to audiovisuals, computer programs, software, publications, curricula, research materials,
training materials, etc. shall be vested with Sponsor. Service Provider is granted a royalty-free, non-exclusive, and
irrevocable license to reproduce, publish, or otherwise use copyrighted materials for the Service Provider's normal
business operations. Such permissions shall only be granted by written permission by Sponsor to Service
Provider via an agreement separate of this Contract.
Docusign Envelope ID:722763F4-1 F54-4496-BA4C-953837DF90A0
Contract#:
9. Intellectual Property: Title to all intellectual property developed during and resulting from the work performed
under this Contract shall be owned by Sponsor. Service Provider is granted permissions for royalty-free, non-
exclusive, and irrevocable rights to reproduce, publish, or otherwise use intellectual property resulting from work
performed under this Contract for use in performing Service Provider's normal business/operating purposes.
10. Confidentiality: For the purpose of implementing this Contract either party (Discloser) may disclose information to the
other party (Receiver) it considers confidential. Any exchange of confidential information must be declared in writing by
Discloser to Receiver as being confidential and if special protections are deemed necessary to protect such confidential
information Discloser shall propose an amendment to this Contract detailing the special terms and conditions related to
the disclosed confidential information. Said amendment shall require bilateral agreement to be valid.
11. Certifications and assurances: By signing the Contract, the authorized official of Service Provider certifies, to the
best of his/her knowledge and belief that:
a. Non-Discrimination. In accordance with federal and state law and Sponsor policy, the parties agree not to
discriminate against any person on the basis of sex, race, creed, national origin, color, religious belief, age,
disability, sexual orientation, gender identity, status as a disabled veteran or veteran of the Vietnam era, or any
other basis protected by law in the performance of this Agreement.
b. Conflict of Interest. The Service Provider certifies that it has established written policy guidelines on conflict
of interest and the avoidance thereof and that in performing the work related to this Agreement the Service
Provider shall adhere to and monitor its policy.
c. Debarment, Suspension, and Other Responsibility Matters. Service Provider certifies by signing this
Service Provider Agreement that neither it nor its principals are presently debarred, suspended, proposed for
debarment, declared ineligible or voluntarily excluded from participation in this transaction by any federal
department or agency.
12. Integration: This Contract and Attachments contain the entire agreement between the parties, and no statements,
promises, or inducements made by either party or agent of either party that are not contained in this written Contract
shall be valid or binding; and this Contract may not be enlarged, modified, or altered except in writing signed by the
parties.
13. Termination: Either party may terminate this Contract for cause or convenience with thirty days written notice.
14. Blank
By an Authorized Official of Service Provider r¢ed Official of Sponsor:
To I i f R. Hun t Digitally signed by Tolif R.Hunt 6,l�w A� 4/7/2025
Date:2025.05.20 12:51:57
uvu
-05'00' Signature Date
Signature Date Signature Date
Name
Name Name
Title
Title Title
2
Docusign Envelope ID:722763F4-1 F54-4496-BA4C-953837DF90A0
Contract#:
Attachment 1
Administrative and Project Points of Contact
Sponsor Contacts Service Provider Contacts
Institution/Organization Institution/Organization Place of Performance
City of Waterloo University of Northern Iowa
715 Mulberry St 1227 W. 27th St
Waterloo, IA 50703 Cedar Falls, IA 50614
UEI.: HSMCQE255TG9 UEI.: PLZ1BS2RC597
EIN: 47-3373953 EIN: 42-6004333
Congressional District: IA02 Congressional District: IA02
Registered in System for Award Management(SAM)? Registered in System for Award Management(SAM)?
Yes_x No_ Yes_x_ No
Institution Type: City Government Institution Type: Institution of Higher Education.
Administrative Contact Administrative Contact
Name: Name: Sean Parrish
Title: Title: Clerk IV
Address: Address: 213 East Bartlett Hall, Cedar Falls, IA 50613
Country:
Telephone:
Fax: Telephone: 319-2733025
E-mail: E-mail: rsp@uni.edu
Project Director/Coordinator Project Director/Coordinator
Name: Mohammad Elahi Name: John DeGroote
Title: Traffic Operations Director Title: Director of GeoTREE
Address: 625 Glenwood St, Waterloo, IA 50703 Address: 1227 W. 27th St, Cedar Falls, IA 50614
Telephone: 319-291-4440
E-mail: mohammad.elahi@waterloo-ia.org Telephone: 319-273-6158
E-mail:john.degroote@uni.edu
Financial Contact Financial Contact
Name: Bridgett Wood Name: Eryn Hamann
Title: Finance Director Title: Accounts Specialist
Address: 715 Mulberry St, Waterloo, IA 50703 Address: 213 East Bartlett Hall, Cedar Falls, IA 50614
Telephone: 319-291-4323
Fax: 319-291-4571 Telephone: 319-273-7054
E-mail: eryn.hamann@uni.edu
E-mail: Bridgett.Wood@waterloo-ia.org
Authorized Official Authorized Official
Name: Mohammad Elahi Name: Tolif Hunt
Title: Traffic Operations Director Title: Director RSP
Address: 625 Glenwood St, Waterloo, IA 50703 Address: 213 East Bartlett Hall, Cedar Falls, IA 50613
Telephone: 319-291-4440 Telephone: 319-273-3025
E-mail: mohammad.elahi@waterloo-ia.org
E-mail: Tolif.hunt@uni.edu
3
Docusign Envelope ID:722763F4-1 F54-4496-BA4C-953837DF90A0
Contract#:
Attachment 2
Scope of Work, Budget, and Technical Reporting
Background and Purpose:
The City of Waterloo Traffic Operations Department is hoping to digitize into a Geographic Information Systems
database traffic marking features for roads under the cities'jurisdiction. This proposal presents a manual digitizing
workflow to accomplish that overall goal. The City of Waterloo Traffic Operations has shared the categorization of
types of features (pasted below) and the Iowa Department of Transportation (DOT) road plan schematics. The
GeoTREE Center has also compiled a set of examples in the Appendix at the end of this document. This
information will help the GeoTREE Center formulate the plan for the database and guide digitization of features.
1. Longitudinal Markings:
o Dashed Lane lines
o Solid Lane Lines
o Double Solid Centerlines (yellow)
o Dashes Centerlines (yellow)
o Edge lines
o Parking Stall Lines
o Hash Marks
o Dotted Lines Through Intersection
o Chevrons
o No Passing Zone (Yellow)
o Speed table or speed hump
2. Transverse Markings:
o Plain Crosswalks (just 2 parallel lines)
o Zebra Crosswalks (with bars between parallel lines)
o Stop Bars
o Yield Lines
o Curb Markings
3. Symbols:
o Right Turn Arrows
o Left Turn Arrow
o Straight Arrow
o Straight and Left Arrow
o Straight and right Arrow
o Roundabout markings
o Bike lane symbols
o Handicap symbols
4. Text:
o STOP
o SCHOOL
o ONLY
o RR
o YIELD
5. Colored Pavement Areas:
o Green
o Yellow Median Nose
4
Docusign Envelope ID:722763F4-1 F54-4496-BA4C-953837DF90A0
Contract#:
Proposed Workflow:
The proposed workflow will involve the following steps:
• In the beginning of the project, meet with City of Waterloo Traffic Operations staff for project planning
o The GeoTREE Center will come with a proposed geodatabase schema but also with
questions and flexibility for adapting based on staff recommendations.
• Define a GIS database schema in collaboration with City of Waterloo Traffic Operations and GIS staff.
The majority of features will be instituted as line features but during database design some might be set
up as either points (e.g. bike lane symbols)or polygons (e.g. turn arrows)
o The Geodatabase will have Subtypes set to list of possible feature types above and a Domain
for the categories. When a new subtype feature is set it will automatically set the category
feature. For example, when `Dashed Lane Lines' is chosen the Category attribute would set
`Longitudinal Markings'.
■ If extra attributes are needed these can be added in. So, for example a Domain could
be set up also to record condition of the marking with available choices being possibly
Good, Fair, Poor. A default value would be triggered but then the worker could change
that default value if visual inspection calls for it.
• E.g. Good (>90% intact paint), Fair(50-90% paint intact), Poor(<50% paint
intact).
o Through visual inspection of imagery GeoTREE student research assistants will digitize
features using the defined File Geodatabase schema
■ The GeoTREE Center has already obtained high resolution 2024 imagery from Black
Hawk County GIS Coordinator Natalie Nunez.
■ Google Street View will be used as an ancillary source of information for making
decisions
o In addition to attribute rules described above the GeoTREE Center will build in topological rules
to ensure geometric integrity in features. For example, if breaking the digitizing of a long linear
feature (e.g. double solid centerlines) into multiple parts, a topological rule will be in place to
ensure the endpoints snap to each other.
5
Docusign Envelope ID:722763F4-1 F54-4496-BA4C-953837DF90A0
Contract#:
❑Map Subtypes:WaterlooTrafficMarkings X
Subtype Name> Dashed lane Lines 'M, Solid Lane Lines i Plain Crosswalks
Field Name Data Type Domain Default Value Domain Defaultvalue Domain Default Value
QBJECl1D object ID
Shape Geometry
Shape-Len gth Double
*111Aer<ner7ype Short
MC Text IMarkerCategories Longitudnali Markings MarkerCategories Longitudnal Markings Marker"egories Tansverse Markings rL
71
/ f
1:48 �+� N " 5,234,774.81E 3,645,912.82N%1S
IM Wate,I—TratFiWarkings X
Field:F.9 Add 171 Calculate Sekdian: L°''®Select By Attributes +�-Zoom To ®®Swdch MCI— V Delete EC-
OBJ
GOBJ ECnD• SHAPE• Sh.pK_Length Markeriype MC
1 I 1 Polyline Z 10.462902 Dashed Lane Lines Longitudnal Markings
Z Z PolylineZ 11.162469 Dashed Lane Lines Longitudnal Markings
3 3 Polyline Z 9.763931 Dashed Lane Lines Longitudnal Markings
4 4 PolylineZ 10.078354 Dashed Lane Lines Longitudnal Markings
5 5 Polyline Z 10.160404 Dashed Lane Lines Longitudnal Markings
5 6 PolylineZ 9.654383 Dashed Lane Lines Longitudnal Markings
POPyline Z 10.263446 Dashed Lane Lines Longitudnal Markings
Deliverables and Timeline:
The deliverables for the project would include an ESRI File Geodatabase with the digitized features and a summary
final report.
The project could begin my March 15, 2025 and be finished by August 31, 2025.
GeoTREE Experience and Qualifications
The GeoTREE Center will leverage their experience in GIS database development, including a history of
automating geoprocessing, that has been demonstrated in many projects for agencies such as Iowa Department of
Natural Resources, Iowa Department of Agriculture and Land Stewardship, Black Hawk Soil and Water
Conservation District, City of Madison, WI, City of Waterloo, IA, and others.
6
Docusign Envelope ID:722763F4-1 F54-4496-BA4C-953837DF90A0
Contract#:
Budget
Below is a budget outline including hourly rates based on the GeoTREE Center's published rates
(https://www.geotree.uni.edu/en/services/). This would be the not to exceed overall budget.
GeoTREE Center-Waterloo Traffic Operations
Pavement Markings Project
Number of Indirect(8% Total
Activity Hours Rate Direct Indirect) Amount
Database design,testing,and refinement,consultation with City 20 35 700 56 756
Beate features in GIS database and set attributes 300 25 7500 600 8100
Meetwith city staffto workthrough problematic features 5 35 175 14 189
Fix or update features to complete GIS database development 20 25 500 40 540
Totals 8875 710 9585
Direct $8,875
Indirect 5710
Project Total $9,585
Appendix: Traffic Marking Feature Type examples
Compiled By GeoTREE Center student research assistant Aliyah Hudson
Potential Resources
Longitudinal Marking
Pavement and Curb Markings
Longitudinal Markings Guide
Markings List
• Dashed Lane lines
• Solid Lane Lines
• Double Solid Centerlines (yellow)
• Dashes Centerlines (yellow)
• Edge lines
• Parking Stall Lines
• Hash Marks
• Dotted Lines Through Intersection
• Chevrons
• No Passing Zone (Yellow)
• Speed table or speed hump
neral Street Structure
EdLine
ge
7
Docusign Envelope ID:722763F4-1 F54-4496-BA4C-953837DF90A0
Contract#:
Cnlirl R nncharl I inn^
Double Solid Yellow= Double Solid Centerlines (yellow)
Broken White = Dashed Lane Lines
Solid White = Edge Line
Broken
Double • Yellow
i • Yellow
Broken White
Double S ! • White
Solid White
Dotted Whit•
Solid Lane Lines (Probably the same as Solid White from the picture above)
Solid White Line
Solid Lane Line,Width Can Vary,4"-6"Wide,White
i
A solid white line is used to mark the right edge of the roadway(edge lines),and also to delineate lanes for travel in the same direction where lane changing is discouraged.Its normal
application is as a lane line on multilane approaches to intersections and,particularly,to delineate left-and right-turn lanes.
8
Docusign Envelope ID:722763F4-1F54-4496-BA4C-953837DF90A0
Contract#:
rai r mg OLdll Lines (Any markings ti,at indicate a designated parking spot)
Hash Marks (Could look like any of the following pictures)
L f
_.. L7!!RRIIl.�R}�lR�AAlI�
9
Docusign Envelope ID:722763F4-1 F54-4496-BA4C-953837DF90A0
Contract#:
LJU«Cu Lines Through Intersection
RVSEF ( > X
Jan
Chevrons
�fuValereB '` 11 �-
- e�Aa
n YI-
,m.
VRWa—.0 WAN r
.Md.td�=�.
OpWK lVlEbl� yMy
rypgumnyl �dm
rWd dated d�A
WMYN !
��wmGe��A arnr ai:�•..: r
•M�
ouwe�m sd d Y
.Yiu.arcw.Ylw.
t0 Mon�Cr
goda In
u.tlNnpwnd WM.0
d
.�Mrr wr
ncrmn wtltlf
dp�d r1ii�
dd
area duw4
utmnum of rgM•
t•aM1C dGpb ImY
- •.dvimdpnw
10
Docusign Envelope ID:722763F4-1 F54-4496-BA4C-953837DF90A0
Contract#:
No vassing Zone
Solid Yellow Line
� �30,� NO Paeig
The solid yellow line indicates a no passing zone applying to traffic with the solid line to its immediate left.This can be used adjacent to a broken yellow line to indicate no passing in one
direction.
Speed Hump/Table (I assume it will look something like along the lines of the following pictures)
nlyNi9hwsYman
Traverse Markings
Markings List
• Plain Crosswalks (just 2 parallel lines)
• Zebra Crosswalks (with bars between parallel lines)
• Stop Bars
• Yield Lines
• Curb Markings
11
Docusign Envelope ID:722763F4-1 F54-4496-BA4C-953837DF90A0
Contract#:
,ategorizea as zer,
Solid Standard Continental Dashed ■ Ladder
Stop Bars (Could look like any of the following pictures)
PENN
. . . _ . .
a � �
- �mmiz• - I sa•
In R. '/�ZgMin R,
12
Docusign Envelope ID:722763F4-1 F54-4496-BA4C-953837DF90A0
Contract#:
Yield Markings
y�
n Tann a OC.os:aw�1k OCiosswraix',
e ea a'o y Owe-way ranm
nem uae -
Curb Markings (Could come in other colors such as red, white or striped)
Symbols
Markings List
• Right Turn Arrows
• Left Turn Arrow
• Straight Arrow
• Straight and Left Arrow
• Straight and right Arrow
• Roundabout markings
• Bike lane symbols
• Hand'Gap mbels
Arrow Markin s
13
Docusign Envelope ID:722763F4-1 F54-4496-BA4C-953837DF90A0
Contract#:
r-uuncianout Markings
Figure 3C-2.Lane-Use Anrow Pavement Marking Options for Roundabout Approaches
A-N.—I-—- S•Flsh•hoak crows
r'�� hTatch anow(s) !r5
! wdh desiV lane
! sa corrlrgu ration
f
pal lav rl I; wr'Ihdes.r�d bare
ecorrAguraVon
r
rr� r!f
Optional for r ! tlonal for `
leamosllane"rn�' red-mast lane
Bike Lane Symbols
60
Handicap S,
i
14
Docusign Envelope ID:722763F4-1 F54-4496-BA4C-953837DF90A0
Contract#:
Markings List
• STOP
• SCHOOL
• ONLY
• RR
• YIELD
Stop
--�hool (Sometimes includes something like School Ahead)
Onl
_+ 1
i
15
Docusign Envelope ID:722763F4-1 F54-4496-BA4C-953837DF90A0
Contract#:
46
Colored Pavement Areas
16