The URL can be used to link to this page

Home My WebLink AboutUNI Contract for Digitization Services of Traffic Ordinance - 6.3.2024Contract for Services Contractor: University of Northern Iowa, henceforth "Service Provider" Issuing Entity: City of Waterloo, Iowa henceforth "Sponsor" Contract #: 308.000 Contract Value: $5,368.00 Source $ Federal? Yes❑ No ❑x CFDA # N/A Period of Performance: Start Date: 06/06/2023 End Date: 9/30/2024 Project Title: Financial Terms: Cost Reimbursable 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.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. Invoices shall be sent to the Sponsor's Financial Contact identified in Attachment 1. 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 may request 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. Contract #: 308.000 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 may request 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. Contingency: Contingency amount can only be used upon written request by the Service Provider and approval of Sponsor's Project Director/Coordinator. By an Authorized Official of Service Provider Signature Name Title Date By an Authorized Official of Sponsor: Signature Querz_ith SIGNED SED 6/3/2024te SIGNED Signature Name Quentin Hart Date Name Title Mayor Title 8 S N TI 2 Contract #: 308.000 Attachment 1 Administrative and Project Points of Contact Sponser Contacts Service Provider Contacts Institution/Organization Institution/Organization Place of Performance UEI.: EIN: Congressional District: Registered in System for Award Management (SAM)? Yes No Institution Type: UEI.: PLZ1BS2RC597 EIN: 42-6004333 Congressional District: IA02 Registered in System for Award Management (SAM)? Yes _x _ No_ Institution Type: Institution of Higher Education. Administrative Contact Administrative Contact Name: Title: Address: Country: Telephone: Fax: E-mail: Name: Sean Parrish Title: Clerk IV Address: 213 East Bartlett Hall, Cedar Falls, IA 50613 Telephone: 319-2733025 E-mail: rsp@uni.edu Project Director/Coordinator Project Director/Coordinator Name: Mohammad Elahi Title: Traffic Operations Director Address: 625 Glenwood St, Waterloo, IA 50703 Country: USA Telephone: 319-291-4440 Fax: E-mail: mohammad.elahi@waterloo-ia.org Name: Title: Address: Telephone: Fax: E-mail: @uni.edu Financial Contact Financial Contact Name: Barbara Reiter Title: Administrative Secretary Address: 625 Glenwood St, Waterloo, IA 50703 Telephone: 319-291-4440 E-mail: traffic-invoices@waterloo-ia.org Name: Eryn Hamann Title: Accounts Specialist Address: 213 East Bartlett Hall Telephone: 319-273-7054 E-mail: eryn.hamann@uni.edu Authorized Official Authorized Official Name: Title: Address: Telephone: Fax: E-mail: Name: Tolif Hunt Title: Director RSP Address: 213 East Bartlett Hall, Cedar Falls, IA 50613 Telephone: 319-273-3025 E-mail: Tolif.hunt@uni.edu 3 Attachment 2 Scope of Work, Budget, and Technical Reporting 'I"' Research, Education, 0 T & and Extension Center Geoinformatics Training, Digitization of traffic ordinance information into a GIS database UNI GeoTREE Center May 14, 2024 Background and Purpose: The City of Waterloo Traffic Operations Department is hoping to translate Traffic Ordinance information that is codified (Traffic Code) in language and stored in supplied PDF files into a GIS database. This information is inherently spatial or geographic as each rule or ordnance is defined by a street segment, an intersection (a point), or some other real -world geographic feature that is in a GIS database already or could be added as a new feature in a GIS feature class. This proposal attempts to detail steps to translate that textual information into a GIS database. By building into a GIS database the Waterloo Traffic Operations staff, as well as others, will gain efficiencies in being able to see the data on a map by clicking on a feature or also being able to develop queries that reveal information in a tabular or map form. The table in the Appendix at the end of this document highlights the Ordinance sections and the potential type of GIS feature such as lines (street segments either from existing City of Waterloo GIS database or created) and points (intersections or other points to be created) which would be built into the new GIS database. Ben Wagner, City GIS Coordinator, has provided a copy of the city's street and alley GIS data (Figure 1). Below some examples are supplied to demonstrate how specific features would be translated into the database. A I] Alleys I.'I City_Roads 1 :k Hawk ;reek fenhe It Wa terloo Reg l&nhl Airport Katoski Greenbelt Good hepherd EDE, E -. II111111 #■■� {llllrilll MI l Ill■ .101111111Wfir F:, I i' B33 fr Figure 1: City of Waterloo streets and alleys. Proposed Workflow: Evansdale Elk Run Heights The proposed workflow will involve the following steps: • Define a GIS database schema in collaboration with City of Waterloo Traffic Operations and GIS staff o Type of features — e.g. street segments as lines, intersections and beacons as points o Attributes or properties to store per feature (section #, description, notes from details — e.g. Figure 2) o Set attribute rules (e.g. Domains for Sections) and potentially topology rules (e.g. intersections must overlap with street segment intersections). ■ For example each section will be pre-set as a Subtypes and Domain in the GIS database allowing the editor to just choose from a dropdown menu (e.g. SectionNumber will be set as a Subtype and editor will choose that from a dropdown menu to automatically set SectionDescription value). • Digitize new features (e.g. intersection point) as needed • Or select out road or alley segment from existing road network data • Set relevant attributes J wlit Star Attributes Geometr: OBJECl1D 1 SectionNumber 539 SectionDeseription Notes SubSection Figure 2: An example of digitizing an intersection for Section 539. NO TURN ALLOWED AT RED LIGHT. Campbell Avenue, Kimball Avenue an There likely will be a significant number of entries that are unclear. The GeoTREE Center will maintain separate table of those for review with the city later. For example, the below entry is not immediately clear where this is although the location is likely shown below also (Figure 3). For locations like this an extra attribute might be added to the feature table and a flag for further checking later. SEC. 539. NO TURN ALLOWED AT RED LIGHT. (A) Vehicular traffic shall not be permitted to turn at the follownrg intersections: (1) Ansborough Avenue and southbound ramp Figure 3: An ambiguous location that might need confirmation from the city of Waterloo Figure 4 below demonstrates the process of copying exact geometric features from the City of Waterloo GIS database and pasting into the new feature class and setting the relevant attributes. SEC. 541. INCREASING SPEED LIMITS IN CERTAIN AREAS. Speeds hereinafter stated in excess of those stated in Section 150 hereof are hereby authorized on the streets or portions thereof described in this section upon the posting of signs giving notice thereof as follows: (1) STREETS Airline Highway (East) - from Logan Avenue also known as U.S. Highway 63 North to the easterly corporate limits (2) Airline Highway (West) also known as Highway 57 - from Logan Avenue to the west corporate limits (Ord. #4229, 4/21/97) (3) Ansborough Avenue - from Rainbow Drive to San Marnan Drive from San Marnan Drive to southerly corporate limits 41 9/7/82; Ord. #3554, 5/9/88; Ord. #4585, 11/18/02) (4) Baltimore Street - El El D,awi,g Order P&P o, eegm. tr ❑ all, Roads from West Fifth Street to East Ridgeway Avenue o World ropo„apn„map ❑.J World Hilishade MAXIMUM SPEED 45 mph 45 mph 35 mph 45 mph Project Map ID Cut L=—J� Copy O Copy Path =1;6 Paste Insert v �t Explore 71 i Paste Special Paste Properties • Li m ersec ons Paste Special X Paste into Template Layer StreetSegments ❑ Keep source attribute values Learn more about paste special I] C y_Roads EaSI E✓ World Topographic Map E✓ World Hlllshade Selection Layers Change the selection. A StreetSegments (19) 1 2 3 4 5 6 7 S 9 10 11 12 13 14 i5 06JEC11D (Different Values) Shape_Length (Different Values) SectionNumber 541 SubSection Nulls ISection Description Notes INCREASING SPEED LIMIT IN CERTAIN AREAS' 6aktimore Street - from West F Maxi mumSpeed 30 OK w�ei �wr rde co��e Cancel eer,.. W 3rd St Home Park Blvd e_ Kingsley Are Q,a NI Aldge.ay Ara West Centre Figure 4: Copying features from Waterloo GIS feature class to new feature class with specific attributes. It is envisioned that there will need to be an original meeting with the City staff to defined the schema for the database and that subsequent phone calls and meeting will be used to refine the process and reconcile questions about ambiguous features. Deliverables and Timeline: The deliverables for the project would include an ESRI File Geodatabase with a feature created for every instance in the For GIS pages from Traffic Code 2008_REVISED 8.2020.pdf document provided. The project will begin by June 1, 2024 and be finished by August 31, 2024. 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. Budget Below is a budget outline including hourly rates based on the GeoTREE Center's published rates (https://www.geotree.uni.edu/en/services/). A rough estimate of 1 hour of production work per page from For GIS pages from Traffic Code 2008 REVISED 8.2020.pdf along with some cleanup work, the database design aspect and UNI's indirect cost make up the budget. 1 GeoTREE Center -Waterloo Traffic 4peration5 Activity Number of Hours Rate Direct Indirect (8% Total Indirect) Amount Meetwith city staff to plan and design GIS database schema 12 35 420 33.6 453.6 Create features in GIS database and set attributes 155 25 3875 310 4185 Meet with city staff to work through problematic features 5 35 175 14 189 Fix or update features to complete GIS database development 20 25 500 40 540 Totals 4970 397.6 5367.6 ❑irect Indirect 44,970 $398 Project Total $5,368 Project total cost includes project fixed cost of $4,887.00 and a contingency amount $481.00 Appendix Table of ordinance sections and potential GIS feature Section Description 539 No Turn Allowed at Red Light 540 Obeediance to official traffic control device 540A Activated Hybrid Beacons 541 Increasing Speed limits in certain areas 541A Decreasing speed limits in certain areas 542 One-way streets and alleys 543 Thru-streets 544 All -way stops and intersections 545 Yield streets 546 Yield intersections 547 Stop at certain railroad crossings 548 Bus zones 548A No parking - pick up and drop off only 549 Loading zones 550 Taxicab zones 551 Parking prohibited at all times on certain streets 552 No parking between signs 553 No Parking here to corner 553A No parking here to corner Monday through Friday 554 No parking here to drive 555 No parking here to tracks 556 No parking here to alley 557 No parking mail drop 558 No parkinig hotel entrance 559 10 minute parking 559A 15 minute parking 560 30 minute parking 561 30 minute parking between 8 am and 12 noon 562 30 minute parking behind city hall 563 One hour parking Type Intersection Street Segment Point Location Street Segment Street Segment Street Segment/Alleys Street Segment Intersection Street Segment Intersection Intersection Street Segment Street Segement Steet Segment Street Segment Street Segment Street Segment Street Segment Street Segment Street Segment Street Segment Street Segment Street Segment Street Segment Street Segment Street Segment Street Segment Street Segment Note *possibly more than one *possibly more than one *possibly more than one *possibly more than one or other point? Likely new feature to be created Likely new feature to be created Likely new feature to be created Likely new feature to be created Likely new feature to be created Likely new feature to be created Likely new feature to be created Likely new feature to be created Likely new feature to be created Likely new feature to be created Likely new feature to be created Likely new feature to be created Likely new feature to be created Likely new feature to be created 564 Two hour parking Street Segment Likely new feature to be created 564A Two hour parking, 8 am to 6 pm, Monday through Friday Street Segment Likely new feature to be created 565 Two hour parking Street Segment Likely new feature to be created 566 Two hour parking, between 6 am and 8 pm Street Segment Likely new feature to be created 567 Two hour parking, between 8 am and 6 pm Street Segment Likely new feature to be created 568 Two hour parking, between 8 am and 4 pm Street Segment Likely new feature to be created 569 Three hour parking - between 8 am and 5 pm Street Segment Likely new feature to be created 570 Four hour parking Street Segment Likely new feature to be created 571 No parking 8 am to 4 pm Street Segment Likely new feature to be created 571A No parking 8a m to 4 pm during school Street Segment Likely new feature to be created 571B No parking 7 am to 4 pm during school Street Segment Likely new feature to be created 571C No parking 7 am to 3 pm during school Street Segment Likely new feature to be created 572 No parking 7 am to 4 pm during school Street Segment Likely new feature to be created 573 No parking 1 pm to 4 pm Street Segment Likely new feature to be created 574 no parking 12 noon to 4 pm Street Segment Likely new feature to be created 575 No parking 6 am to 6 pm except Sunday Street Segment Likely new feature to be created 576 No parking 11 pm to 5 am Street Segment Likely new feature to be created 577 No parking 6 pm to 5 am Street Segment Likely new feature to be created 578 No parking 10 pm to 6 am Street Segment Likely new feature to be created 579 No parking any time except Sunday Street Segment Likely new feature to be created 580 No parking any time except Sunday from 7 am to 12 pm Street Segment Likely new feature to be created 580A No parking any time except Sunday and Wednesday pm Street Segment Likely new feature to be created No parking except Friday, Saturday, and Sunday from 12 noon to 10 580B pm Street Segment Likely new feature to be created 581 School stop signs Intersection or other point? 582 Truck traffic prohibited on certain streets Street Segment 583 Buses only Street Segment