Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Agenda 03/12/2013 Item #16A10
3/12/2013 16.A.10. EXECUTIVE SUMMARY Recommendation to approve award of contract# 13-5993 for Project 60088 to Midwestern Software Solutions, LLC, for consulting services to develop and support a Traffic Count Software system. Contract award amount$101,840. OBJECTIVE: To gain approval by the Board of County Commissioners (Board) of staff's recommended award of contract for RFP # 13-5993 to Midwestern Software Solution, LLC (MSS) for implementing and supporting a cloud based Traffic Count Software system. CONSIDERATIONS: Collier County Traffic Operations currently uses four different vehicular count systems ACRTA, Sensys, Timemark, and Wavetronix combining the information from 194 permanent count stations. Traffic staff is often required to include additional count information for special projects and field studies. This information is then combined manually by personel to create quarterly and annual count reports. The Metropolitin Planing Office (MPO) and the Planning Department uses the information provided from these reports to generate the Annual Update Inventory Report (AUIR) that determines the health of the county's roadway system. This project would consolidate all four systems into a single automated database allowing indepth analysis with sophisticated database analytics. Consolidating the count information will allow superior internet browser based mapping and access to the information. The contract bidding procedure was initiated on October 15, 2012, when the Purchasing Department publicly requested solicitations for RFP # 13-5993 "Traffic Count Software." Inquiries were sent to 963 vendors; of that number 29 solicitations were downloaded, and two vendors requested the full RFP package and attended the mandatory pre-proposal meeting. Those two vendors submitted proposals by the November 7, 2012, due date. On December 7, 2012, a five-member RFP selection committee approved by the County Manager reviewed the submissions, and in a public meeting, discussed and ranked the proposals. By consensus, the following firms were ranked as: 1) Midwestern Software Solutions, LLC 2) Iteris, Inc. Traffic Operations staff requested that the Purchasing Department pursue a negotiated agreement with the top-ranked vendor,Midwestern Software Solutions,LLC. FISCAL IMPACT: The contract award amount of$101,840 is available in the Transportation Planning Gas Tax fund 313 project 60088. LEGAL CONSIDERATIONS: This item has been reviewed and approved by the County Attorney's Office, is legally sufficient for Board action and only requires a majority vote for approval—SRT. GROWTH MANAGEMENT IMPACT: There is no growth management impact associated with this Executive Summary. Packet Page -1126- 3/12/2013 16.A.10. RECOMMENDATION: That the Board approves the award of Contract for RFP # 13-5993 to Midwestern Software Solutions, LLC and authorizes the Chairwoman to execute the attached contract after final review by the County Attorney's Office. Prepared By: Rick Bossert, Signal Systems Network Specialist, Growth Management Division, Transportation Engineering, Traffic Operations Attachments: 1)Final score Sheet; 2)Agreement; and 3)Midwestern Count Proposal Packet Page-1127- 3/12/2013 16.A.10. COLLIER COUNTY Board of County Commissioners Item Number: 16.16.A.16.A.10. Item Summary: Recommendation to approve award of contract#13-5993 for Project 60088 to Midwestern Software Solutions for consulting services to develop and support a cloud-based Traffic Count Software system. Contract award amount$101,840. Meeting Date: 3/12/2013 Prepared By Name: BossertRick Title: VALUE MISSING 2/13/2013 12:22:43 PM Submitted by Title: VALUE MISSING Name:BossertRick 2/13/2013 12:22:44 PM Approved By Name:KearnsAllison Date: 2/14/2013 10:48:57 AM Name:AhmadJay Title: Director-Transportation Engineering,Transportation Engineering&Construction Management Date: 2/14/2013 12:07:13 PM Name:NauthRookmin Title: Management/Budget Analyst,Transportation Administr Date: 2/14/2013 3:22:01 PM Name:BrilhartBrenda Title: Purchasing Agent,Purchasing&General Services Date: 2/14/2013 3:32:56 PM Name:KhawajaAnthony Packet Page-1128- 3/12/2013 16.A.10. Title: Engineer-Traffic Operations,Transportation Engineering&Construction Management Date: 2/14/2013 3:50:42 PM Name: WardKelsey Title: Manager-Contracts Administration,Purchasing&Ge Date: 2/14/2013 4:27:17 PM Name: ShueGene Date: 2/15/2013 8:34:13 AM Name: LynchDiane Title:Administrative Assistant Date: 2/15/2013 5:16:27 PM Name: MarkiewiczJoanne Title: Manager-Purchasing Acquisition,Purchasing&Gene Date: 2/15/2013 6:53:33 PM Name: BathonDale Title: Project Manager,Principal,Transportation Engineer Date: 2/19/2013 7:21:51 AM Name: LaPierreBarbara Title: Management/Budget Analyst,Transportation Administr Date: 2/19/2013 4:37:25 PM Name: TeachScott Title: Deputy County Attorney,County Attorney Date: 2/19/2013 5:05:16 PM Name: MarcellaJeanne Title: Executive Secretary,Transportation Planning Date: 2/27/2013 2:41:59 PM Name: KlatzkowJeff Title: County Attorney Date: 2/28/2013 3:34:22 PM Name:UsherSusan Title: Management/Budget Analyst, Senior,Office of Manage Date: 3/5/2013 11:40:36 AM Name: OchsLeo Title: County Manager Packet Page-1129- 3/12/2013 16.A.10. Date: 3/5/2013 12:03:22 PM Packet Page-1130- 3/12/2013 16.A.10. / a - Et & � co k o q { \■ _. \ p- c., CO g 22 ... o _ ■ § a) } . � k 2 1- \ Q Q ; = c e e 2 as / . %CU CU 2 { ( _ / ® J . f-` , m ■ ; : o � . . k 0 \ : Q . :o _ 0 \ 0 0 \ ¥ a ) a,..,,!„„,,!,E �: - cI0 Cai . 0 \ _v ■ 1 • U) { CO \ . m E CO CI a c$ 2 g a% � . E r } ) $ 3 Q g 3 If / t .t cn k� 2 / as CC as J � � � � � 2 k � Packet Page-1131- 3/12/2013 16.A.10. AGREEMENT 13-5993 for Traffic Count Software THIS AGREEMENT,made and entered into on this day of 2013,by and between Midwestern Software Solution, LLC, authorized to do business in the State of Florida, whose business address is 3815 Plaza Drive Ann Arbor, Michigan 48108, (the "Consultant") and Collier County, a political subdivision of the State of Florida, (the "County" or "Customer"): WITNES SETH: 1. COMMENCEMENT. The Consultant shall commence the work upon Notice to Proceed. The initial term of the contract is one (1) year, with three (3) one (1) year renewal options. Development of the project action plan, system implementation and user training support (Exhibit "A" - Scope of Services) is anticipated to be completed within ninety (90) calendar days (Exhibit "B") from Notice to Proceed. The County Manager, or his designee, may, at his discretion, extend the Agreement under all of the terms and conditions contained in this Agreement for up to one hundred and eighty (180) days. The County Manager, or his designee, shall give the Consultant written notice of the County's intention to extend the Agreement term not less than thirty (30) days prior to the end of the Agreement term then in effect. 2. STATEMENT OF WORK. The Consultant shall provide consulting services to develop and support a cloud-based Traffic Count Software program in accordance with the terms and conditions of RFP #13-5993 and the Consultant's proposal referred to herein and made an integral part of this agreement. This Agreement contains the entire understanding between the parties and any modifications to this Agreement shall be mutually agreed upon in writing by the Consultant and the County Project or Contract Manager or his designee, in compliance with the County Purchasing Policy and Administrative Procedures in effect at the time such services are authorized. 3. THE CONTRACT SUM. The County shall pay the Consultant for the performance of this Agreement an estimated maximum amount of one hundred and one thousand eight hundred and forty dollars ($101,840.00), based on the fee schedule (Exhibit "C") set forth in this contract, subject to Change Orders as approved in advance by the County. Payment will be made upon receipt of a proper invoice and upon approval by the Project Manager and/or his designee, and in compliance with Chapter 218, Fla. Stats., otherwise known as the"Local Government Prompt Payment Act". 3.1 Payments will be made for services furnished, delivered, and accepted, upon receipt and approval of invoices submitted on the date of services or within six (6) Page 1 of 15 Packet Page-1132- 3/12/2013 16.A.10. months after completion of contract. Any untimely submission of invoices beyond the specified deadline period is subject to non-payment under the legal doctrine of "laches" as untimely submitted. Time shall be deemed of the essence with respect to the timely submission of invoices under this agreement. 3.2 TRAVEL AND REIMBURSABLE EXPENSES Travel and Reimbursable Expenses are not anticipated, but if requested must be approved in advance in writing by the County. Travel expenses shall be reimbursed as per Section 112.061 Ha. Stats. Reimbursements shall be at the following rates: Mileage $0.445 per mile Breakfast $6.00 Lunch $11.00 Dinner $19.00 Airfare Actual ticket cost limited to tourist or coach class fare Rental car Actual rental cost limited to compact or standard-size vehicles Lodging Actual cost of lodging at single occupancy rate with a cap of no more than$150.00 per night Parking Actual cost of parking Taxi or Airport Actual cost of either taxi or airport limousine Limousine 4. SALES TAX. Consultant shall pay all sales, consumer, use and other similar taxes associated with the Work or portions thereof, which are applicable during the performance of the Work. 5. NOTICES. All notices from the County to the Consultant shall be deemed duly served if mailed or faxed to the Consultant at the following Address: Ben Chen,Project Manager Midwestern Software Solution,LLC 3815 Plaza Drive Ann Arbor,MI 48108-1655 (734) 995-0200 bc@ms2.com Page 2 of 15 Packet Page-1133- 3/12/2013 16.A.10. All Notices from the Consultant to the County shall be deemed duly served if mailed or faxed to the County to: Collier County Government Center Purchasing Department 3327 Tamiami Trail,East Naples,Florida 34112 Attention:Purchasing &General Services Director Telephone: 239-252-8975 Facsimile: 239-252-6480 The Consultant and the County may change the above mailing address at any time upon giving the other party written notification. All notices under this Agreement must be in writing. 6. NO PARTNERSHIP. Nothing herein contained shall create or be construed as creating a partnership between the County and the Consultant or to constitute the Consultant as an agent of the County. 7. PERMITS: LICENSES: TAXES. In compliance with Section 218.80, F.S., all permits necessary for the prosecution of the Work shall be obtained by the Consultant. Payment for all such permits issued by the County shall be processed internally by the County. All non-County permits necessary for the prosecution of the Work shall be procured and paid for by the Consultant. The Consultant shall also be solely responsible for payment of any and all taxes levied on the Consultant. In addition, the Consultant shall comply with all rules, regulations and laws of Collier County,the State of Florida, or the U. S. Government now in force or hereafter adopted. The Consultant agrees to comply with all laws governing the responsibility of an employer with respect to persons employed by the Consultant. 8. NO IMPROPER USE. The Consultant will not use, nor suffer or permit any person to use in any manner whatsoever, County facilities for any improper, immoral or offensive purpose, or for any purpose in violation of any federal, state, county or municipal ordinance, rule, order or regulation, or of any governmental rule or regulation now in effect or hereafter enacted or adopted. In the event of such violation by the Consultant or if the County or its authorized representative shall deem any conduct on the part of the Consultant to be objectionable or improper, the County shall have the right to suspend the contract of the Consultant. Should the Consultant fail to correct any such violation, conduct, or practice to the satisfaction of the County within twenty-four (24) hours after receiving notice of such violation, conduct, or practice, such suspension to continue until the violation is cured. The Consultant further agrees not to commence operation during the suspension period until the violation has been corrected to the satisfaction of the County. 9. TERMINATION. Should the Consultant be found to have failed to perform his services in a manner satisfactory to the County as per this Agreement, the County may terminate said agreement for cause; further the County may terminate this Agreement 1)Packet Page-1134- 3/12/2013 16.A.10. for convenience with a thirty (30) day written notice. The County shall be sole judge of non-performance. In the event that the County terminates this Agreement,Consultant's recovery against the County shall be limited to that portion of the Contract Amount earned through the date of termination. The Consultant shall not be entitled to any other or further recovery against the County, including, but not limited to, any damages or any anticipated profit on portions of the services not performed. 10. NO DISCRIMINATION. The Consultant agrees that there shall be no discrimination as to race,sex,color,creed or national origin. 11. INSURANCE. The Consultant shall provide insurance as follows: A. Commercial General Liability: Coverage shall have minimum limits of $1,000,000 Per Occurrence, $1,000,000 aggregate for Bodily Injury Liability and Property Damage Liability. This shall include Premises and Operations; Independent Consultants; Products and Completed Operations and Contractual Liability. B. Workers' Compensation: Insurance covering all employees meeting Statutory Limits in compliance with the applicable state and federal laws. The coverage must include Employers' Liability with a minimum limit of$1,000,000 for each accident. Special Requirements: Collier County Government shall be listed as the Certificate Holder and included as an Additional Insured on the Comprehensive General Liability Policy. Current, valid insurance policies meeting the requirement herein identified shall be maintained by Consultant during the duration of this Agreement. The Consultant shall provide County with certificates of insurance meeting the required insurance provisions. Renewal certificates shall be sent to the County ten (10) days prior to any expiration date. Coverage afforded under the policies will not be canceled or allowed to expire until the greater of: ten (10) days prior written notice, or in accordance with policy provisions. Consultant shall also notify County, in a like manner, within twenty- four (24) hours after receipt, of any notices of expiration, cancellation, non-renewal or material change in coverage or limits received by Consultant from its insurer, and nothing contained herein shall relieve Consultant of this requirement to provide notice. Consultant shall ensure that all Subconsultants/Contractors comply with the same insurance requirements that he is required to meet. 12. INDEMNIFICATION. To the maximum extent permitted by Florida law, the Consultant shall indemnify and hold harmless Collier County, its officers and employees from any and all liabilities, damages, losses and costs, including, but not limited to, reasonable attorneys' fees and paralegals' fees, whether resulting from any claimed breach of this Agreement by Consultant, any statutory or regulatory violations, or from personal injury, property damage, direct or consequential damages, or economic loss, to the extent caused by the negligence, recklessness, or intentionally wrongful conduct of the Consultant or anyone employed or utilized by the Consultant Pf Packet Page-1135- 3/12/2013 16.A.10. in the performance of this Agreement. This indemnification obligation shall not be construed to negate, abridge or reduce any other rights or remedies which otherwise may be available to an indemnified party or person described in this paragraph. This section does not pertain to any incident arising from the sole negligence of Collier County. 12.1 The duty to defend under this Article 12 is independent and separate from the duty to indemnify, and the duty to defend exists regardless of any ultimate liability of the Consultant, County and any indemnified party. The duty to defend arises immediately upon presentation of a claim by any party and written notice of such claim being provided to Consultant. Consultant's obligation to indemnify and defend under this Article 12 will survive the expiration or earlier termination of this Agreement until it is determined by final judgment that an action against the County or an indemnified party for the matter indemnified hereunder is fully and finally barred by the applicable statute of limitations. 13. CONTRACT ADMINISTRATION. This Agreement shall be administered on behalf of the County by the Growth Management Division/Traffic Operations Department. 14. CONFLICT OF INTEREST: Consultant represents that it presently has no interest and shall acquire no interest, either direct or indirect, which would conflict in any manner with the performance of services required hereunder. Consultant further represents that no persons having any such interest shall be employed to perform those services. 15. COMPONENT PARTS OF THIS CONTRACT. This Contract consists of the following component parts, all of which are as fully a part of the contract as if herein set out verbatim: Consultant's Proposal, Insurance Certificate, RFP #13-5993-Traffic Count Software, County Software Specifications/Scope of Services, Addenda and any written response to questions. 16. SUBJECT TO APPROPRIATION.,It is further understood and agreed by and between the parties herein that this agreement is subject to appropriation by the Board of County Commissioners. 17. PROHIBITION OF GIFTS TO COUNTY EMPLOYEES. No organization or individual shall offer or give, either directly or indirectly, any favor, gift, loan, fee, service or other item of value to any County employee, as set forth in Chapter 112, Part III, Florida Statutes, Collier County Ethics Ordinance No. 2004-05, and County Administrative Procedure 5311. Violation of this provision may result in one or more of the following consequences: a. Prohibition by the individual, firm, and/or any employee of the firm from contact with County staff for a specified period of time; b. Prohibition by the individual and/or firm from doing business with the County for a specified period of time, including but not limited to: submitting bids, RFP, and/or quotes; and, c. immediate termination of any contract held by the individual and/or firm for cause. P`Packet Page-1136- 3/12/2013 16.A.10. 18. IMMIGRATION LAW COMPLIANCE. By executing and entering into this agreement, the Consultant is formally acknowledging without exception or stipulation that it is fully responsible for complying with the provisions of the Immigration Reform and Control Act of 1986 as located at 8 U.S.C. 1324, et seq. and regulations relating thereto, as either may be amended. Failure by the Consultant to comply with the laws referenced herein shall constitute a breach of this agreement and the County shall have the discretion to unilaterally terminate this agreement immediately. 19. OFFER EXTENDED TO OTHER GOVERNMENTAL ENTITIES. Collier County encourages and agrees to the successful proposer extending the pricing, terms and conditions of this solicitation or resultant contract to other governmental entities at the discretion of the successful proposer. 20. AGREEMENT TERMS. If any portion of this Agreement is held to be void, invalid, or otherwise unenforceable, in whole or in part, the remaining portion of this Agreement shall remain in effect. 21. ADDITIONAL ITEMS/SERVICES. Additional items and/or services may be added to this contract in compliance with the Purchasing Policy. 22. DISPUTE RESOLUTION. Prior to the initiation of any action or proceeding permitted by this Agreement to resolve disputes between the parties, the parties shall make a good faith effort to resolve any such disputes by negotiation. The negotiation shall be attended by representatives of Consultant with full decision-making authority and by County's staff person who would make the presentation of any settlement reached during negotiations to County for approval. Failing resolution, and prior to the commencement of depositions in any litigation between the parties arising out of this Agreement, the parties shall attempt to resolve the dispute through Mediation before an agreed-upon Circuit Court Mediator certified by the State of Florida. The mediation shall be attended by representatives of Consultant with full decision-making authority and by County's staff person who would make the presentation of any settlement reached at mediation to County's board for approval. Should either party fail to submit to mediation as required hereunder, the other party may obtain a court order requiring mediation under section 44.102, Fla. Stat. 23. VENUE. Any suit or action brought by either party to this Agreement against the other party relating to or arising out of this Agreement must be brought in the appropriate federal or state courts in Collier County, Florida, which courts have sole and exclusive jurisdiction on all such matters. 24. KEY PERSONNEL/PROTECT STAFFING: The Consultant's personnel and management to be utilized for this project shall be knowledgeable in their areas of expertise. The County reserves the right to perform investigations as may be deemed necessary to ensure that competent persons will be utilized in the performance of the contract. The Consultant shall assign as many people as necessary to complete the project on a timely basis, and each person assigned shall be available for an amount of time adequate to meet the dates set forth in the Project Schedule. The Consultant shall P`Packet Page-1137- ----- 3/12/2013 16.A.10. not change Key Personnel unless the following conditions are met: (1) Proposed replacements have substantially the same or better qualifications and/or experience. (2) that the County is notified in writing as far in advance as possible. The Consultant shall make commercially reasonable efforts to notify Collier County within seven (7) days of the change. The County retains final approval of proposed replacement personnel. 25. ORDER OF PRECEDENCE: In the event of any conflict between or among the terms of any of the Contract Documents, the terms of the Request for Proposal and/or the Consultant's Proposal, the Contract Documents shall take precedence. In the event of any conflict between the terms of the RFP and the Consultant's Proposal, the language in the RFP would take precedence. 26. ASSIGNMENT: Consultant shall not assign this Agreement or any part thereof, without the prior consent in writing of the County. Any attempt to assign or otherwise transfer this Agreement or any part herein, without the County's consent, shall be void. If Consultant does, with approval, assign this Agreement or any part thereof, it shall require that its assignee be bound to it and to assume toward Consultant all of the obligations and responsibilities that Consultant has assumed toward the County. 27. CONFIDENTIAL AND PROPRIETARY INFORMATION: A. Proprietary Information. Customer acknowledges that in order to perform the services called for in this contract, it shall be necessary for Consultant to disclose to the customer certain Proprietary Information that has been developed by Consultant at great expense and that has required considerable effort of skilled professionals. Customer further acknowledges that the programs will of necessity incorporate such Proprietary Information. Customer agrees that it shall not disclose, transfer, use, copy, or allow access to any such Proprietary Information to any employees or to any third parties, excepting those who have a need to know such Proprietary Information in order to give effect to the Customer's rights hereunder and who have bound themselves, in writing, to respect and protect the confidentiality of all such Proprietary Information. In no event shall the customer disclose any such Proprietary Information to any competitors of Consultant. B. Notwithstanding, anything to the contrary in any other section of this Contract, g t hereby acknowledges that the Customer is subject by law to certain Consultan y g l Y information and document disclosure and copying requirements that may require the County to disclose information or copies of documents relating to or forming part of the program(s) trade secret or copyright protection. Accordingly, prior to disclosing such information or reproducing such documents to a third party, the County shall seek the Consultant's written consent to each such disclosure or reproduction and the Consultant agrees not to unreasonably with hold such consent. Neither customer nor Consultant has any obligation to disclose any Trade Secret. "Trade Secret" as defined in Section 812.081,Florida Statutes, are exempt from"Public Records Law" disclosure by application of Section 119.08(3)(o), Florida Statutes. Customer shall not intentionally disclose any of the subject trade secrets. In the event that customer is unsure whether an item is a trade secret, Customer shall rely on Consultant's PI Packet Page-1138- 3/12/2013 16.A.10. assertion that the item is a trade secret and shall in reliance thereon treat the item as a trade secret vis-a-vis Chapter 119, Florida Statutes. In any case where the Consultant expressly consents to specific disclosure of information or reproduction of documents relating to or forming part of the program(s), the Consultant hereby waives for each specific disclosure or reproduction any claim against the County for violation of trade secret or copyright laws or violation of any term of this Contract for such a release of information or copies of documents. In any case where the Consultant refuses to consent to disclosure or reproduction and the County is as a result thereafter made a party to a suit arising under Chapter 119, Fla. Stat (i.e., the "Florida Public Records Law"), the Consultant agrees to intervene in such suit with counsel and at the Consultant's expense and to present evidence to establish that the information or documents the Consultant has requested the County to withhold under the terms of this Contract are in fact exempt from disclosure under the Florida Public Records Law pursuant to Section 119.07(3)(o). Should the court in such a suit determine that the information or documents in question must be disclosed or reproduced pursuant to the Florida Public Records Law, the Consultant shall have no claim against the County for violation of this Contract or trade secret or copyright laws or otherwise. However, to the extent the Consultant did not unreasonably withhold its consent to disclosure or reproduction in the first place, the Consultant also shall have no obligation to pay any attorneys' fees or costs assessed against the County as a result of the nondisclosure or non-reproduction of the information or documents. *******************************Remainder of page intentionally left blank***************************** Packet Page-1139- 3/12/2013 16.A.10. IN WITNESS WHEREOF, the Consultant and the County, have each, respectively, by an authorized person or agent, hereunder set their hands and seals on the date and year first above written. BOARD OF COUNTY COMMISSIONERS ATTEST: COLLIER COUNTY,FLORIDA Dwight E. Brock,Clerk of Courts By: By: Dated: Georgia A. Hiller,Esq.,Chairwoman (SEAL) Midwestern Software Solutions,LLC Consultant By: First Witness Signature TType/print witness namel' Second Witness Type/print signature and title 1'Type/print witness nameT Approved as to form and legal sufficiency: Assistant County Attorney Print Name Pi Packet Page-1140- 3/12/2013 16.A.10. EXHIBIT A SCOPE OF SERVICES I. Overview of Contract The Consultant shall implement, host and maintain a web-based traffic data management system for the Collier County Traffic Management Center's data processing and reporting. Services will include establishing automated polling procedures and data management systems to generate traffic data reports for Traffic Management Center requirements. The Consultant will host and maintain the web based management system for the initial four (4) year contract period. Services may include, but not be limited to, the following: A. An action plan for creating, importing historical data and hosting a data storage system for the Collier County Traffic Management Center (TMC) current and future traffic data sources. The Traffic Management Center currently uses multiple software tools and formats for processing and reporting traffic data such as Siemens ITS ACTRA/TACTICS System Software, Wavetronix CMD System, Time Mark Pneumatic Hose System and Turning Movements Counts. Spreadsheets, queries, and database storage of traffic information should be integrated into one web based hosted solution making it easier to analyze, query, report, display, access and utilize traffic counts database information. B. An automated traffic database for processing and reporting traffic data. The service shall provide database management tools that improve Collier County's TMC overall traffic data quality. The Consultant should provide a web based hosting application that can provide electronic tools for compiling the hourly, daily, monthly, quarterly and year-end processes. In support of providing processing and reporting of traffic data, the services should, at a minimum, provide: i. Traffic data polling management by auto-polling and receiving traffic data as machine- readable volumes, bins, or individual vehicle records. Traffic data devices used by Collier County Traffic Operations include the following vendors: a. ACTRA/TACTICS -Siemens Database b. Wavetronix c. Time Mark d. Sensys Networks ii. Traffic data collection site management; iii. Data workflow management; iv. Quality control and quality checking of data; v. Status reporting on failed sensors or count station(s) if not operating; vi. Calculation of Seasonal Adjustment Factors and Axle Adjustment Factors in accordance with FHWA Traffic Monitoring Guide procedures; vii. Calculation of Average Daily Traffic(ADT) and Annual Average Daily Traffic (AADT); viii. Calculation of Annual Highest Hours, Annual Hourly Day of Week, Annual Day of Week Percentage Statistics; ix. Processing and storage of short count data and continuous count data including volume, classification, and speed and length data; x. Reports of counts on customizable intervals and set intervals (hourly, daily, weekly, monthly, quarterly and year-end), both for specified station(s) as well as system-wide; xi. Calculation and plotting of the AM, Mid-Day and PM Peak hourly volumes for the various road segments, with the option to include or exclude weekend volumes; xii. The ability to display the AADT, the peak hour volume and turning movement volumes on the web based map interface; xiii. The ability to compare and display the growth or reduction in the traffic volumes (ADT) for the various roadway segments from the same periods (quarters or years) from previous years, on the web based map interface; Pa Packet Page-1141- 3/12/2013 16.A.10. xiv. Database management tools for the storage, modification, importing and extraction of traffic information. C. The hosted application must satisfy the FHWA Traffic Monitoring Guide (TMG) requirements and the American Association of State and Highway Officials (AASHTO) guidelines for Traffic Data Programs. D. The ability to display locations and count data on a web based map interface, such as Google Maps API, and the ability to add or modify stations. E. Provide training to CC TMC staff, which shall include but not be limited to: System operations training, System modification training, and Report generation training. F. Provide remote and on-site support services to CC TMC staff, which shall include, but not to be limited to: Troubleshooting system errors, customizing and building reports upon request, security and software updates. II. Service Level Agreement The consultant shall provide definitions of key terms used in the Service Level Agreement (SLA). This must include the definition of"The Service", which fully explains: A. The critical software applications and hardware devices involved in the provision of the service that the consultant is responsible for providing, such as: i. Database server ii. Web application server iii. All required hardware or software resources needed to implement the production database application. iv. Enough disk space to store all CC TMC's raw traffic data for at least 10 years, and a process to ensure its authenticity. v. This would include any licensing requirements for creating a Virtual Server for the above mentioned severs. vi. Uninterruptible power supply vii. Separate backup device or service for recovery of all Data by the CC TMC. B. Critical duties a consultant is responsible for performing. C. Responsibility that any shared or stored data is sole property of the Collier County Traffic Management Center, and is not available for sale or to be used for commercial gain without explicit consent of the Collier County Traffic Management Center. D. Any other applications, devices or duties for which Consultant is responsible for in maintaining the integrity and authenticity of the count data. III. Service Availability The application service must allow all its functions to be executed via a standard web browser. At a minimum the application service must be: • 99% available during working hours: between 6:30 AM and 5:30 PM EST, Monday through Friday, excluding public holidays observed by CC TMC • 95% all other times, including public holidays observed by CC TMC The consultant must define any exclusion that may apply to the service availability, for example; lost passwords, deliberate or accidental misuse by registered users, reasonable delays due to computer intensive activities such as data loading or performing intensive calculations, etc. IV. Performance Levels The application service must provide secure environments for two kinds of users: • A multi-user, collaborative, read/write environment for registered data analysts and administrators from CC TMC • A read-only reporting environment for non-authenticated (public) users The application service must provide at least the minimum licensing for the following: Pa Packet Page-1142- 3/12/2013 16.A.10. • 5 simultaneous registered data analysts • 20 simultaneous public users The application service must continue to operate with minimal changes to performance for the heaviest specified loads. V. Security The system must take measures to prevent security threats that may result in data loss or service degradation, including: A. Firewalls B. Built in Role Based Access Control for various objects and actions throughout the application C. A secure process for creating users, which details who controls user creation and their permissions D. Built in measures that prevent modification or destruction of data by unauthorized users E. Built in measures for managing typical input validation errors that may compromise security, such as format strings, SQL injection, cross-site scripting, HTTP header injection and the like. F. Secure password management policies that include, at a minimum, a process for password recovery, a process for changing the password, and a policy on password strength. G. Encryption policies and algorithms for the secure transmission of data between hosted service and connections to CC TMC or outside public intemet activity VI. Support Response The consultant must provide support response goals based on the level of urgency and present a schedule for response times for normal business hours and off shift hours. A resolution goal timeline will also be provided for handling support requests. VII. Other Policies The system must contain details on any other important service policies including: A. A backup and disaster recovery plan in the event of data loss due to natural or human induced disasters B. Control measures in recovery plan shall include preventive, detective and corrective measures C. An incident reporting and tracking process D. The approach to providing a fault tolerant computing environment VIII. Deductions for Non-Performance Fees for service will be reduced on a pro-rata basis by comparing time the service is not in compliance against the stated benchmarks. The contract may be terminated if the service is not available at least 80% of the time. IX. Definitions A. Mandatory Requirements — The terms "shall", "will', and "must" denote mandatory requirements. B. Permissible Action—The terms"should" and "may" denote an advisory or allowable action. C. Agency — Any department, commission, council, board, office, bureau, committee, institution, agency, government, corporation, or other establishment of the executive branch of this state authorized to participate in any contract resulting from this solicitation. D. Discussions — For the purposes of this contract, a formal, structured means of conducting written or oral communications with responsible proposers who submit proposals determined in writing to be reasonably susceptible of being selected for award. X. Performance Goals and Measures • Setup and maintain web hosting site for CC TMC traffic data storage and analysis. • Import CC TMC historical traffic data for display and analysis into web hosted site. • Increase the speed and efficiency of traffic data collection and processing. Pa Packet Page-1143- 3/12/2013 16.A.10. The services provided by the Consultant shall be evaluated to determine that these services are provided in a timely and professional manner by Anthony Khawaja, Traffic Operations Engineer. In coordination with the CC TMC a quarterly work schedule will be developed for consultant activities. Objectives and deliverables will be tracked for completion. Xl. Monitoring Plan: CC TMC will monitor the performance of the Consultant by: • Comparing deliverables and objectives to the quarterly audit plan. • Compare time required to collect, process and report traffic data to previous procedure. • Reviewing for accuracy all generated reports and polled data. • Feedback for the Consultants Audited. Pa Packet Page-1144- 3/12/2013 16.A.10. EXHIBIT B PROJECT SCHEDULE Project schedule is based upon issuance of the Notice to Proceed. PROPOSED PROJECT SCHEDULE Task Week 1 1 2 3 4 5 6 7 8 8 10 11 12 1,Project Action Plane _.1 t _._. f I ! I i I I 2.System hnplementatian iT. H — ] 3.User Training and System Support r ' :MIN Pa Packet Page-1145- 3/12/2013 16.A.1O. EXHIBIT C Project Cost Proposal Collier CountyTraffic Count Software Project Cost Proposal 466 lei..... 2 1 r... ''''' T5 Classification (Staff Name) W a o S m W a a Hourly Rate $160 $110 $95 ' $90 Task 1. Project.Action Plan - Project Kick-off Meeting.&Preparation 4 4 - Project Action Plan Development Task Total Hours 4 4 0 0 8 Task Total Fee $640 $440 $0 $0 $0 $1,080 Task 2. System Implementation _ j - TCDS/TMC License Fee $50,000 - Data Migration and System Customizations 16 60 40 40 Task Total Hours 16 60 40 40 156 Task Total Fee $2,560 $6,600 $3.800 $3,600 $50,000 $0 $66,560 Task 3. User Training and System Support - User Training 2 8 - - !User Year System and Support $0 Task Total Hours 2 8 0 0 10 Task Total Fee $320 $880 $0 $0 $0 $0 $1,200 Task 4. Additional 3-Year Hosting and Support - 2nd Year $10,500 - 3rd Year $11.000 - 4th Year $11,500 Task Total Hours 0 0 0 0 0 Task Total Fee $0 $0 $0 $0 $33,000 $0 $33,000 PROJECT FEE&HOUR SUMMARY TOTAL HOURS 22 72 40 40 174 TOTAL DAYS 8 13 5 5 29 TOTAL FEE $3,520 $7,920 $3,800 $3,600 $83,000 $0 $101,840 Additional Personnel Categories This list is not intended to be all inclusive. Hourly rates for other categories of professional, support and other personnel services shall be mutually negotiated by Collier County and firm as needed for the project. Pa Packet Page-1146- 3/12/2013 16.A.10. PROPOSAL RFP: 13-5993 November 7. 2012 Cott CaltintY 100.16N0111.004100 BOARD OF COUNTY COMMISSIONERS TRAFFIC COUNT SOFTWARE ,. .. .., .......... --. „,,; .,.7. , ..- :zai,...,,, - --, ,.. . ., . . .„.„...„._, .. ,... . ..4", Iv ' tr...--Ar— .. ' ..i....a...„0.; .--, ,•;,'I., . - - Nit. .i,L0,-: ,- . , , .-,-d" . .,,-9;-4,f; ./4^—r..0 ' ' r•-•' . -- P';• '" ••::"jelf2;;.L11,'"'.;:rd.!'...PP -'''..""' •'''' ''''',.. "....3 C.. • '7..: •...I. , 47 ti....'?•:',2r.:e? ,„i rp.....''',. '',,,,,1 P .4*• • " • "'PP P.1141e" . . '••"" .. "..., •'••',..i.,:. '''.... ' I P.... .',--k., 1- m ' a ...2%,.,:,,,..?„,„-f..--r-r-- .. .... --. - - - , ''.::: 7.41f— --;-1-', - .-r,si.` ',0- r .-., v. -. ..4.4% . ::,.._ .,, -- . . . I _..., -.._. 7 ...r.- -...-.0.;",.rw",,,,,,w ..,..*.r,14:,:-., . ,1,-. :::6- .0:z.y,,....,,,,...,- . ..-:. „.. ,,,,A- 4,,. .,- : . — ,,-;-_ • ,...„- ,.. -- k. a-,74fryor.,;:f - ------ ' .; :,--.74,—!, - ... th-.,4,_ • . ,...,-.-.--- 4'.- , . - ..:-.....„.e. ._ - .--; -:, -,:..,;.--,- ,,,-.4.0, ,-„,f.,,,,,...„ .. .., .-,.,:, , r.„40±0- -.-..;--:-;;;-;--.:°;,-'''..-, --...--;,..7'"f„: L 11,:#P.,...;... .--`,z4,...--.ivoi-i.0,/ ....t --- -,'---dr.:,.;!P'%144w ', IE4t-*,;:iir,-.Y.rt4':',:',;•t.' :=. ..7V,,,;:f f._"-,' . . .4-,,W.,'',..pl —11.Thrief'....w , '-t,.•4' .,,''._.- ."1",',...y 4 '1" '' '..,;'''i =.-. 411 i-:...... ."'"a . ' .,.0;,....;'-.„J,/,,,.. ,, .k,.4.„..,..,. ..,,,,_ .,o4o... r 1.-':...7„'...-'`..'...'•r,,•r• thq.6'. '—— 1, '..'` .' _ .,:.,,"''',..,„f.7, .1.,,,,,,Ipuipsekl.:::r..:01.'"f..".. .,- '0'':5 ,0-,.. 'Y 'Ljr - 00 ',:tti-r",-, --r-717--. irvo,41,1 • , - f ;- - ::-_---;,,‘-,-,- . . , ,....--... se.,=,--.54 - - , ----Ali*, , ,,,, ' — ,. r..7. "1:''---- t • ",. ;4 -'74 ' -,---,- '!''.7et'o,-, lee.-/'''',,- 4,,,,'':;.,,,--'.1....,,r,•• ' , . At., m 7- . re ..".- .. ,.-, re. 1,.. ,.. -,-,. -.'_.1' . arz' P....t . .' '. 0; r',P; -' ' •,(6 "',".:';',.;0",,r.iwraloll'ir..rdrov.,A11-■•4'>, ,,,, J",,,g;',01 .."..,41 7'',,,„,i,-,417,.,:,,.,..-.......: ,„.7,-,r ,--R7, „,.„,.,,,, -- - ... 6■ i...,'P, ..;..„. -. •.,,,,...,.,....,.. Jp. 0,0-.',.. 0 ' • - A ..- .4,V . ,. ! -..- NO' .- •-• "i' .',"'+1 --- '''. te" ..17.;117re*, -.43-i _,,r___e"' 1;;,.....?°....,10j6:2:: : •''',1, , ..,I cirl,..-:-.■-•.-. , '. ' ''' ''.'t,,,:12 AP, l',.. r.",:-.,-0 — . :.:.. Y-........'."4.%,.'",74.,-,i,i 1,4'-" -• ')1-77.;;-i'''' , '-7 ig- 4 7.". ' i.,4-.: - Otr,,4,fr' -.'"Y.," ,•;,'-- .."','..,, .''' - 7- ..,-"" - .":7 rt 1."".'-'1 :•'P"V,:ei.:•P•.'':''re r'''''. .,;''' 0••k..•'• J'', , P.,;re''';,..;V?tr'..4"1CW..14.', ,-•erl . .'-'e4;,;..7,4;;LP. ' . - ..04." **r---- • • . - ..--1 ... r;!!-----...i--,'- ..', '--- -'r '''''''t:144t.S'..ifgr*.''tlq.;t.' ..,406, ' .g.er)..''. ' •-.4'' ,,,, ottil-+-5:1Ltb ..'''.,-S i .', — --.1!-'7717."7"yi. ..°V...-f' ',. . ' ''-'' - C.."' ' plikkjssitt3i.„ 24t.'''4;f:.r•nitr,..., :,,t -,tr. -,,-). .•P',". ..,1), -.4,!5tqw " ..--°;..---,5_., .17-•`-'-t---- , .14," _. ,..____ --;Ic -....:Ls!, .- - ,-- ----,P, .J. MIDWESTERN a0 FT WARE 0 LUTI 0 N S COMPLEX DATA / SIMPLE MANAGEMENT Packet Page-1147- 3/12/2013 16.A.10. . muk5 Table of Contents ' 4- '.4 a t .t' 1w a .": .`'C"M 4 P ■1 5}, Ie Trr cCeatDabblte2S3et6m{fCDS) I ® ssp JQa9C Cana } 4 ,.. •.�.. �� ..�.� ....yam �_ ® A1a lo�tw � , �Enieraddralte 1���IPl'(A teal i i\ 6 2..."m.e. ! 1',,z,© rs.. 96 - _• LORI DA • Traffic Count Database System(TCDS) ©If31© n)r? e 1 TG0t6, G7 �I'r-amli1 1 1 ) III I l� �t�l .i ,�,�r,,,. ., f d i. a Ar4el41�Ap+e!^II,!(+'"" ern ....„ .aw.,a ,,,,,,,..., "k . t a . .. .,-cwgaeau �i , 20,71°'109.) peenmee pNo-b..t OFF y V-137 109)761631091 76.692(691 c�Q` "weaseaw fl la Q( © 22�06V(dBr b>21.. 021..D...w a,.o l_J Budd a.xaa ' ank ,. Et— i -. R "' 13.245169) m Re ,„ 1 ',,M?.;; "I-I ftlt,i, rd111llell &' :3 ,+. P �� Y r_ z M ;. ]1.679�6169) 1Lelltoo�'CCW006 ui"ameell I -taen Bay ,a il(wow G.. A W Gold Oolo na tl¢ 1 4.;''.'64.. [,^,j ViiroT.Nc Y wnwis,NC st016 au.."o 3 l6 we Pn.r.ee."e N' 24 940)09), .,,xstl0t caafides7. II F °'t _ Guidon , I , .$7Qraltp*6 Type` AM69a .2i639(09) '>.AFGreltp.. .-MLels: f FL1euaP t d Lima,fMCjCWS. pj Lea PSk ... '°4, o-...v,�n�Kwngpw#4r,W s °`=•?`Ra.rpeeaa 8106',LvastinlOo 8454 QE B51 �Naple9: oM'ea'" 27,sd9fae) 'tecobiloatGOMenoatePkwy , Bwei a 'l Aywl.1. NnSOr �' 11 ftweed84 L79 ^e �0 ,r s 1EaoMY''6aEe y:�P•orlRga>,I � ;l6aunW colter { Leh 1/3,166(09)66 • {`Adaeaallar;enlnYlbe S9 ,lanes 4r. r i Pmeyune simnel 1 JW 10aa� $a16ole-TyPi; t'1.,:',14,-,!='' s s. r -teNFkwn Slale7ore5) I� i, .268109) gisamwb 2&t7300x )'-Y r#3+•Il Pemo ate8on Yes ,1260515.46-81.686090 ( 1111444ion No 4peedtlnla'. & W. 1' :Halve,Yea s..';.�.*aei �'-1' ..` '',4'2' 557109) STATION©AV, " z,-'=" 4-M"mivem ' 1 i,"e Ci eze nm '. I' as 7A0rCD a,Ita.M: r t°'j„, t :'*s-,,,,,,.,,,,,,,,,,1.iwA-:'* cother.28 19 'MI 2009 EMEMI 0®■11111■11111■1 t , ', V 1. mm 8 qy we� , > http://collier.ms2soft.com I. COVER LETTER/MANAGEMENT SUMMARY 1 II. DATA BASE OPTIONS 4 III. COST OF SERVICES 15 IV, EXPERIENCE AND CAPACITY 16 V. PROJECT WORK PLAN 26 VI. REFERENCES 30 VII. ACCEPTANCE OF CONDITIONS 31 VIII. REQUIRED FORMS 32 Appendices Résumés Collier County RFP—13-5993 Traffic Count Software Packet Page-1148- • 3/12/2013 16.A.10. r ' .‘a 111101 MIDVVESTERN 3815 Plaza Drive OW,������ FTVVARE Ann Arbor, Michigan 48108 o" ' "` QLUTICDNS 9 " ► 734.995.0200 Fax 734.995 0599 +F S"" www.ms2soff.com November 5, 2012 Collier County Government Purchasing Department Attn: Brenda Brilhart,Procurement Strategist 3327 Tamiami Trail E Naples,FL 34112 Subject: RFP 13-5993 /Traffic Count Software Dear Ms. Brilhart: MS2 is pleased to submit this proposal to the Collier County Board of Commissioners for doud-based Traffic Count Software. We are prepared to provide all the services necessary to meet the County's needs and requirements. The Project Manager from MS2 will be Ben Chen, P.E., PTOE. Ben is a Principal with MS2 and a nationally renowned expert in the field of transportation data management. He is currently serving on the Expert Panel advising the Federal Highway Administration (FHWA) Traffic Monitoring Guide Update project. His contact information is as follows: Phone Number: (734) 995-0200 Email Address: be @ms2soft.com MS2 has pioneered and implemented an innovative cloud-based Transportation Data Management System (TDMS) for state DOTs, MPOs, counties, and cities across North America. More than 160 road agencies in 26 states, Canada, and Africa are using the'1'UMS to manage their transportation data in support of planning, engineering and operation efforts. The TDMS is fast-becoming the standard for transportation data management. The database is integrated with Google Maps and ArcGIS Server to assist users in efficiently retrieving and effectively presenting relevant information. The best indicator of our program's success is that many public agencies are using the TDMS every day to process data and share information with stakeholders and the public. Links to these real-time data portals are listed at http://www.ms2soft.com (under Active Systems). Unlike other "hidden-behind-a-wall" or still "work-in-progress systems," these are mature systems proven under real system loading and use. The advantages that set MS2's software apart from other systems: • Cloud-based solution that delivers economy of scale and saves you from the burden of system upkeeps • Hybrid use of Google Maps and ArcGIS Server that allows interactive map interface and powerful spatial analysis • Total solution from traffic/WIM/ITS data processing, data validation, statistical analysis,MEPDG data inputs, monthly TMAS submittals,to annual HPMS reports Page 1 of 2 Packet Page-1149- 3/12/2013 16.A.10. • Expandable and integrated system that manages various traffic data and assets • The only system in the cloud that you can test with your own data now ■ Scalable and robust system demonstrated by the fact that this is the largest traffic count database in the world today with 7,000 continuous count stations and 438,000 short count stations • Several state DOTs have been upgrading from other competing systems to MS2's TCDS (e.g.Arizona,Montana,and Indiana) MS2 is ready to build upon our long list of active and satisfied clients and provide Collier County with a cloud-based Traffic Count Database System that will meet all of your system requirements Very Truly Yours, Ben Chen,PE,PTOE Principal Page 2 of 2 Packet Page-1150- ``°''` 3/12/2013 16.A.10. 1 Management Summary MS2 understands that the primary objectives of the County's traffic count software are to: • Implement an efficient system for traffic data management at Import all historical traffic data for storage, display,analysis,and reporting • Increase the productivity of traffic data polling, collection and processing • Improve data quality and timeliness • Integrate data from various data sources Dashboard +" .�5.......waif ,i�w'.„.--, s^w-' r.,....._,,,--:,.-4,,-, .'",, ,,..„,,,wu:, t httpWidotmasaft.comhcd arch,esp"tlocaldot t - T Road Sign (RSMS) 1 , : -. . . IlI_,>oi�Department y e ° ” E0 a�rm"N of Transportation TratScQunt atabase System (TCDS) Traffic Video (RTTV) a �� � Project Planning (PMDS) emt Tea otha as •'_.^xed•t'. 1, 'tralaldaax ca",:fremtaCeW7 T*eaafi• was; INforte na, of been r* wed m a soAf,f red*1111 therefore flab not reflect toe fell 4U MIN .o Pavement Condition (PMS) Fir cord 4 et G`, Gate Fterora , w 3 i i `"�"" Travel Time (TTDS W�.,� - ®E = 'l - 14 e4, 4, �t.4 4. rii�, I `®®� Traffic Crash (TCLS) J ,, 1 is • = HICAGO ,� t-',:. u ..;..,. '1 q r;,,.F 4. ®® 1 auracc rtival q s i >> w i-PZ "a r� ; xi L 7i Traffic Signal (TSMS) 4h �x of � ®®�.t�� If Traffic Count (TCDS) -, ' MS2 has pioneered and implemented an innovative cloud-based Transportation Data Management System (TDMS) for state DOTs,MPOs, counties, and cities across North America. More than 160 road agencies in 26 states, Canada,and Africa are using the'1•DMS to manage their transportation data in support of transportation engineering and planning efforts. The'1'DMS is fast-becoming the standard for transportation data management. The database is integrated with Google Maps and ArcGIS Server to assist users in efficiently retrieving and effectively presenting relevant information. The fully integrated system includes the following modules: • Traffic Count Database System (TCDS) Collier County RFP—13-5993 1 Traffic Count Software Packet Page-1151- w .a4, 3/12/2013 16.A.10. • Turning Movement Count System (TMC) • Traffic Crash Location System (TCLS) • Project Management Database System (PMDS) —TIP/RTP Tracking • Traffic Signal Management System (TSMS) • Travel Time Database System (1`1DS) • Pavement Management System (PMS) • Road Sign Management System (RSMS) • Pavement Marking Management System (PMMS) • Pedestrian Count Database System (PCDS) • Real Time Traffic Video (RTTV) • Route Optimization System (ROS) • Work Order Tracking System (WOTS) • Performance Measure Monitoring (Dashboard) In working with all levels of transportation agencies across the United States, Canada and Africa,MS2 has worked with an extensive array of traffic count data types and formats from a wide variety of sources. Utilizing our vast data processing and importing experience,we will be able to efficiently migrate the County's historical data into the system and set up polling and import processes for future data uploads. From there,MS2's engineers will begin the necessary system customizations to meet any County requirements. As the live systems will display,many of the system features and functionalities desired by the County are already standard features of the TDMS. Because of this,the timeframe for producing a final product populated with all the historical data will be greatly reduced. Therefore,the County will be able to begin using the system in a very short period of time. As the support of the system continues,the County will be able to request additional customizations to meet ever changing traffic data management needs. As a cloud-based system,the County will also benefit from customization requests and implementations by all the other peer agencies across the country using the TDMS. For example, at the request of the Arizona Department of Transportation (ADOT),MS2 deployed the"Dynamic Graph" function shown below: 100002.18.Daily Volume Counts.All Counts r.«ss 2ss4u j a..uJ9 P4 2m lu 49.E to. .r.wa>•,RA 1,•Fit.,10_nI..w....•.ut \\11,, r--.e 3:2 .,y,. 44 F46 h414 2001 2009 2010 011 Collier County RFP—13-5993 Traffic Count Software 2 Packet Page-1152- 3/12/2013 16.A.10. "Dynamic Graph" allows users to quickly scroll across historical traffic counts over custom selected and adjustable timeframes. This is similar to the charts that track stock market activity over various user selected timeframes. Using"Dynamic Graph", especially with data from permanent count stations,users can quickly identify traffic data trends and patterns in just a few seconds. This feature was at the request of the ADOT,but it is now available for all TDMS clients to use with their own data. Main characteristics of the TDMS include: • True Cloud-based Application-Instead of masking a legacy database with a web interface,MS2 developed the TDMS from ground up with every component in a native web application architecture,which improves system performance and workflow efficiency. • Hybrid Use of Google Maps and ArcGIS Server-It takes advantage of both the popular spatial data from Google and the full power of ESRI ArcGIS Server,which enhances your ability to perform complex spatial query,analysis and reporting. • Easy Integration of Various Data Sources-The data portal architecture allows live data streams from all stakeholders (MPOs and local agencies) and various data sources (traditional counting stations and modern ITS operations),which reduces duplicate effort in data collection. • One-Stop Solution-All system elements and services (from database engine, data processing routines,user interface, to system hosting) are developed and maintained solely by MS2,which maximizes the system integrity, consistency, and reliability. Collier County RFP— 13-5993 Traffic Count Software 3 Packet Page-1153- 3/12/2013 16.A.10. App Data Base Options The Traffic Count Database System (TCDS) and Turning Movement Count System (TMC)were the original components of the'1'DMS and they have set the standard for cloud-based management of traffic count data. As a commercial off-the-shelf(COTS) product,the TCDS/TMC can be immediately implemented and meet most,if not all, of an agency's traffic count data management needs without any additional enhancements or customizations. The main functions of the TCDS/TMC include: • Traffic data collection management by auto-polling or importing of machine-readable volumes, bins,or individual vehicle records • Traffic data collection site management for traffic station identification and reference • Data workflow management to allow users to review and edit imported data prior to submitting the data into the database • Automated quality control and quality checking of data with the generation of alerts/flags to inform users of potential data issues or errors • Calculate Seasonal and Axle Adjustment Factors in accordance with FHWA Traffic Monitoring Guide procedures • Calculate Average Daily Traffic (ADT),Annual Average Daily Traffic (AADT), and Vehicle Mile Traveled (VMT) • Calculate Design Hourly Volumes (DHV),Annual Hourly Day of Week, and Annual Day of Week Percentage Statistics • Process and store short count data and continuous count data including volume,classification, weigh-in-motion, speed,gap, and length data • Data summary and reporting of data in various timeframes (daily,monthly,and annual) • Database management tools for the storage,modification,importing, and extraction of traffic information • Export capabilities to support FHWA monthly TMAS reporting requirements including 3-Card, S-Card,C-Card, and W-Card records • Export capabilities to support FHWA annual HPMS traffic data reporting requirements The TCDS/TMC is compatible with many popular traffic data collection devices,including the following: • ACTRA/Tactics—Siemens Database • Wavetronix • TimeMark • Sensys Networks • TimeMark Pneumatic Hose System and Turning Movements Counts System Specifications The TCDS/TMC is implemented to function with the following software: • Microsoft SQL Server (2008) Collier County RFP—13-5993 Traffic Count Software 4 Packet Page-1154- 5,h 3/12/2013 16.A.10. .1}71 • Microsoft IIS • Google Maps API /ArcGIS Server (10.0) • Internet Explorer or other common browsers As an enterprise solution hosted by MS2, the cloud-based TCDS/TMC does not entail any modification or addition to the client's owned computer software or hardware as it presently exists. System support provided by MS2 includes: • Host the TCDS/TMC on the MS2 servers • Perform system maintenance as necessary • Perform nightly backup of the system and store copies of the backup offsite as part of MS2's data warehousing procedures • Provide technical support to system users as requested The overall MS2 cloud infrastructure is illustrated in the following: 44. M ; Power ? Grid w TMS 0 / --- ---,L-4‘... • at&t Mss . .' 1 j Server Cluster rcomcast Alp.. . SIG r r 4 - Agency Staff and Public Users i% Dally ., Backup ;. Backup Server Power (Isolated) I Monthly ,u r Backup SOIL Main 1 Storage Database - - - - - Secondary (offslte) on DVD for Agency Collier County RFP—13-5993 Traffic Count Software 5 Packet Page-1155- 3/12/2013 16.A.10. The advantages of the cloud-based system over any traditional desktop-based applications include: • Easy Access—Users can access the data and analysis tools 24/7 from anywhere via Internet. • Staying Current—System enhancements and data updates are instant and frequent without any burden on agency staff. The system is shared by agencies throughout the country and continuously evolving with new features. • Worry Free—MS2 is responsible for the system's operation 24/7/365. Agency users can focus their effort on finding solutions using the system instead of maintaining it. • Cost Effective—An enterprise license would allow all agency staff members to use the system. There is no need to purchase multiple desktop licenses. There is no need to upgrade any hardware or software on multiple computers. MS2 can achieve the cost effectiveness through the pure economy of scale.We simultaneously provide many different road agencies with the hosted solution at a fraction of the cost that would be required for any one of them to provide similar database services in-house. Software and hardware costs add up, as do the cost for incremental system improvements, full upgrade, and 24/7 administration.With a hosted service,you can share and thereby reduce these and related costs rather than bearing them alone, and everyone subscribed to the service benefits. Collier County RFP—13-5993 Traffic Count Software 6 Packet Page-1156- x; p 3 /12/2013 16.A.10. The TCDS system flow is illustrated as follows: ,,, Data Analysis r 3e tirt.'. Count AADT -- - Locations DHV/K/D = Volume seasonal „ � : /Axle Trends . - __.. QA/QC Counts Factors VMTs Searchable Viewer New Counts ,I Speed Custom f Counts Reports Server Class Custom = f. T Counts Graphs Traffic Flow Map Data Import Gap M TMG I = Routine Counts i as Historic im Submittal -- Counts WIM Files == Data Travel -., rr Demand Editor ® Model ® Data Files Within the TCDS,multiple user levels can be set up to control access to various data elements and system functions. The user level scheme is shown below: Server rr�� Site Manager 'I .46 - User management II °4 - All admin user rights DOT Staff ':_.,.. y ,:.�: =,.:747.17:4:-..,- ,,,,,,-.,.... _ 1� ....,.ii.+`w t ist,lows . '° ,cif., b -.........-.... —_ z { H��. Admin - E dit/upload local data -_ ., - -$ II If -All login user rights — 7:7-r,-:-.1*, Stakeholder Agency Staff 1 User(w/login) �C �� - View all data/reports �1 r �" r r - �, . ?; 1 I I 1 1 t 1 I I I 11` Public (w/o login) Public - View selected data Collier County RFP-13-5993 Traffic Count Software 7 Packet Page-1157- `.,,,, 3/12/2013 16.A.10. The TCDS can streamline the whole process of traffic count data collection,processing,analysis, reporting,and sharing. Atypical workflow for Automatic Traffic Recorders (A 1'K) and Weigh in Motion (WIM) data management is illustrated in the diagram below. The automatic data polling and processing makes possible real time access by agency users to raw data as well as vital statistics. ® Server Vit 11': - ,. , ,41.7:--.4:- ;) _____ .4,y lot, ,,,,,,,,4Vi 4gekg..: -..- ,,r,..„..1-4° Auto DOT Transfer Staff Real Time http://dot.ms2soft.com Feed - -.� ....„..7,,,, ,- DOT Polling a,- gnu "'*" " pc w F' 1 1 % TT- :TAlf* �c - NIIV " arc 1 a7 ✓ fit'{ din ,r'.. x 0.; " .nk� ' �.,. ,� I f t Yt,S t� `d" .:5 . E 'E, u.3 fig �` ' 'a Stakeholder Agency Staff and Public Users Collier County RFP—13-5993 Traffic Count Software 8 Packet Page-1158- =:. wig 3/12/2013 16.A.10. ;il, v.r.. For short count data collection, the following diagram illustrates the workflow. A roadside access to the TCDS will allow a traffic count technician to upload and validate the count before leaving the site. It would eliminate the extra time and cost of making another trip to the site in the case of bad data due to unexpected events (e.g. cut tubes). -., �� . Server Wr IlijDOT Staff Up •ad Real Ti a http://dot.ms2soft.com eed I ,1' ,- 4'4x . R ..n .,.-. ..,. ; .... '9 . eoffi wmv h .* �i 1E''' 1 J Stakeholder Agency Staff and Public Users Collier County RFP— 13-5993 Traffic Count Software 9 Packet Page-1159- 3/12/2013 16.A.10. The TCDS has a comprehensive interface to allow easy upload of traffic count data from many commonly used traffic counters and data sources. The following is a screen-shot of the interface, which also illustrates the compatible data formats. Based on the same framework,MS2 can rapidly develop upload routines for any new formats an agency may need. l Transportation Data Management System Microsoft Internet Explorervro i k '14, , Foe Edtt iliew Favorites Tools Help Transportation Data Management System-Microsoft Internet Ex j.""''Back— 4 -4 ` r+ 5earch°-. Favorites : 'Media',4,A-. " I ,.0, "Address http:/f adot.ms2soft.comltcds/adminldeFault_tcds.asp " Go° Arizona Department of 111710% Transportation Help s. r:t DOT Transportation Data Management System TCDS Administration iGeneral ITCOS[ C l in :: P1 D5 RSM 1p,L jl : t 1 Import Count Data PRH JAMAR PerVeh Diamond HiStar TMINIn Single File (txt) Single File Single File Vehicle Count Multiple Files Single File Multiple Files Multiple Files Axle Count Multiple Files Per Vehicle ODOT Datalink XLS Template1 Wauetronix Wauetronix HO Single File Single File Single File Single File Single File Multiple Files Multiple Files GDOT Class GDOT Class MORPC(xis) VIAS Vol VIAS PerVeh (csv) (mdb) Single File Single File Single File Single File Single File Multiple Files Multiple Files Multiple Files WIM ECM Diamond PerVeh FHWA VDOT Peek RIMS Single File Single File Single File Single File Single File Multiple Files Multiple Files Multiple Files Multiple Files Multiple Files Smartway Centurion Centurion Centurion MOOT Short Count Single File PerVeh Volume Class (dbf) Multiple Files Single File Single File Single File Single File, Multiple Files Multiple Files Multiple Files Multiple Files Diamond BIN RTMS2 ECM Stat Miouision XLS Jamar Excel Single File Single File Single File Single File Single File Multiple Files Multiple Files Multiple Files Multiple Files Multiple Files TIRTL DV03 Excel Single File Single File Multiple Files Multiple Files Multi-file Upload withBaitch'Import Process" Multi-file Upload NOTE:This is a DELAYED batch process (Recommended for users experiencing timeout issues) Review Uploaded File Status-(0)Errors Collier County RFP–13-5993 Traffic Count Software 10 Packet Page-1160- 3/12/2013 16.A.10. System Setup and Security MS2's current server hardware and software setup—that supports data from over 160 agencies across the United States and Canada is as follows: • Five- Dell Quad Core servers operating Microsoft Windows 2008 Server Enterprise, 64bit edition with at least 8GB RAM, 1066MHz Dual Ranked RDIMMs, and 600 GB Hotplug Hard Drives. Each server is dedicated to one of the following functions o Web Server-running Microsoft IIS o GIS Server-running ESRI ArcGIS Server Enterprise o Database Server-running Microsoft SQL Server 2008 o Development Server-for software development and testing o Redundant Server-for failover functions • Dual Hot Swap power supplies • RAID 5/10 for redundancy • DVD+/-RW, SATA, Internal MS2 is constantly reviewing and projecting future data storage needs to ensure that there is more than adequate hard drive space to meet all client data needs including data backups. To protect the system,MS2 utilizes the WatchGuard Firebox X550e. The WatchGuard Firebox X550e includes the appliance security gateway with Virus/Intrusion Prevention,anti-spyware,WebBlocker, hardware warranty,logging, and threat alerts. The WatchGuard also provides load balancing and circuit failover functions between the dual Internet links (AT&T and Comcast). System Backup, Recovery, and Upkeep Transportation data management systems must be protected in the event of a system failure or natural disaster. Business recovery plans should be developed to support all potential failure scenarios. In line with the philosophy,MS2 has established robust business processes to ensure its own business continuity and disaster recovery. MS2's processes are: Backup Process The replication of all servers is performed to a storage server. The storage server is housed in a special fire-proof closet with a chemical-based fire retardant system. This replicated data and servers are also backed up to tape every month. The monthly tapes are stored in an off-site fire-proof vault. MS2 does full system backups of all their servers nightly using Veritas Backup Exec. This includes full SQL server backups. System Upkeep MS2 guarantees the system uptime to be at least 99%. We utilize the latest technologies to ensure the maximum uptime. Raid 5 or 10,hot swap hard drives,redundant hot swap power supplies,multiple processors,are just some of the technologies used on all servers. Dual internet links,backup power generator, firewalls, antivirus, and tight system security are used to prevent system outages. A notification system has been developed by MS2 staff to provide notification of any failure that would prevent access to MS2 applications. Notification is sent instantly to multiple staff members via email and text messaging to cell phones. This allows rapid response times to minimize down time. All key MS2 staff have access to servers from off site locations to manage those servers and systems as needed. Collier County RFP— 13-5993 Traffic Count Software 11 Packet Page-1161- 3/12/2013 16.A.10. TCDS System Feature Summary 1 •: ^-1 c v 4 tel w a System Feature w E 1 t t i.s 0 W U U W Z 'General"Features _, Cloud-based (delivered via Software as a Service) Commercial-off-the-shelf(system is ready to go) Allow as many users as the agency needs Allow agency system administrator to manage user accounts Allow multi-level of users (public,viewer, editor,and system manager) Provide as much data storage as the agency needs . Dashboard for traffic statistics summary Scalable and expandable to manage other transportation data and assets Complete system redundancy with dual Internet links, dual power sources,and multi-server setup System Uptime > 99% Data Management Satisfy the FHWA Traffic Monitoring Guide (TMG) requirements and the American Association of State and Highway Officials (AASHTO) guidelines for Traffic Data Programs Manage traffic count locations (intersection approach and/or segment) _ Manage short and continuous count data,including volume, speed classification,length,gap, and weigh-in-motion data On-demand backup routine to allow Admin users to retrieve a sub or full dataset in MS Access file Collier County RFP—13-5993 Traffic Count Software 12 Packet Page-1162- M1 3/12/2013 16.A.10. Data Processing _ , 4 ? _ Import machine-readable volumes,bins, or individual vehicle records Compatible with various data formats from the following traffic counters: Diamond,Peek,Jamar,TimeMark, ITC, IRD,HiStar, RTMS,Wavetronics, RIMS,ECM,and Miovision Automated QA/QC of data with the generation of alerts/flags to inform users of potential data issues or errors Allow users to review and edit imported data prior to submitting into the database Data Analysis and Reporting Calculate Seasonal and Axle Adjustment Factors in accordance with FHWA Traffic Monitoring Guide (TMG) Calculate AADT,DHV,K, D,truck statistics - j Back-calculate all annual statistics based on the current year seasonal and axle factors Data summary and reporting of data in various timeframes (daily,weekly, monthly, and annual) MEPDG traffic inputs per site,group,region, or state (hourly adjustment, monthly adjustment, class distribution,axle counts,load distribution) Database Search and Display Allow ad-hoc queries for count locations and count data Allow a user to customize and save searching criteria and reports Allow a user to export selected count locations and count data to MS Access and MS Excel files .interactive Map Iiiieifi6e Integrated with both ArcGIS Server and Google Maps Allow display of relevant GIS layers from the agency Clickable station icon to display count location and count details Highlight count locations on the map based on database search result Allow search of count location and count data through the map interface Traffic flow map for selected year Traffic growth heat map for selected year Collier County RFP—13-5993 Traffic Count Software 13 Packet Page-1163- 3/12/2013 16.A.10. Monthly TNIt S Su nnittal Pxocessuig Perform QA/QC on traffic data based on FHWA TMAS rules and TMG format specifications Selectable station list for submittal Create station,volume, classification,WIM data submittal files (S-Card,3-Card, C-Card,and W-Card files) Annual HPMS Txaffic Data Processing r t 4 { Cluster analysis for defining seasonal and axle groups Short count assignment (to seasonal group or axle group) based on traffic patterns HPMS statistics (AADT,K,D,truck stats, and growth factor) calculation and estimation Network VMT estimation HPMS traffic data report in both HTML and Excel formats ITS Daxa Integration Automatic nightly upload of traffic detection data Compatible with various systems such as SCATS,Naztec,MarcNX, Wavetronics,and RTMS Dynamically store and display the ITS data Include ITS traffic detectors as permanent count stations Collier County RFP— 13-5993 Traffic Count Software 14 Packet Page-1164- .H 5' F... 3/12/2013 16.A.10. 111 II Cost of Services co m = � u. Classification a i a o o ,A4-- y c o c o a a w co w co m a N N - Hourl Rate $180 $120 $100 Task 1. Pro'ect Action Plan 0 Pro'ect Kick-off Meeti • & Pre•aration 16 --- $1,000 0 Pro'ect Action Plan Develo•ment 8 24 ---= Task Total Hours 24 24 0 -- 48 Task Total Fee $4,320 $2,880 $0 $1,000 $8,200 Task 2. System Implementation •TCDS/TMC License Fee --- $50,000 • _— Data Migration and System Customizations 16 60 80 --- Task Total Hours 16 60 80 -- 156 Task Total Fee $2,880 $7,200 $8,000 $50,000 $0 $68,080 Task 3. User Trainin s and S stem Support 0 User Traini • 2 16 -- $1,000 0 1st Year S tem and Sue sort --- $10,000 Task Total Hours 2 16 0 -- 18 Task Total Fee $360 $1,920 $0 $10,000 $1,000 $13,280 Task 4. Additional 3-Year Hostin• and Su• •ort 0 2nd Year —_— $10,500 •3rd Year --- $11,000 e 4th Year --- $11,500 Task Total Hours 0 0 0 -- 0 Task Total Fee $0 $0 $0 $33,000 $33,000 PROJECT FEE&HOUR SUMMARY TOTAL HOURS 42 100 80 -- 222 TOTAL FEE $7,560 $12,000 $8,000 $93,000 $2,000 $122,560 Collier County RFP—13-5993 Traffic Count Software 15 Packet Page-1165- 3/12/2013 16.A.10. IV Experience and Capacity Firm Background MIDWESTERN SOFTWARE MS2 is a limited liability corporation incorporated in SOLUTIONS, LLC Michigan and providing services throughout North America. It is a wholly-owned subsidiary of 3815 Plaza Drive Midwestern Consulting,LLC,a professional consulting Ann Arbor,Michigan 48108 engineering firm licensed in Michigan since 1967. MS2 Phone: 734-995-0200 was formed specifically to provide system and software Fax: 734-995-0599 solutions to public and private clients with information management needs. The firm's services include: Michigan corporation lest.2003) • Transportation Planning and Traffic Engineering Wholly-owned subsidioty of • Geographic information systems (GIS) for Midwestern Consulting,LLC, lest 1967) integrating maps and data on the locations and conditions of physical elements • Management information systems (MIS) for Areas of Expertise: controlling events,processes,and records Traffic Count Database System • Program development to allow cloud-based access Traffic Crash Location System to information Traffic Signal Management System Travel Time Database System MS2 has pioneered and implemented an innovative Pavement Management System cloud-based Transportation Data Management System Road Sign Management System (1'DMS) for state DOTs,MPOs, counties,and cities Real Time Traffic Video across North America. More than 160 road agencies in Project Mgmt. Database System 26 states,Canada and Africa are using the TMS to Work Order Tracking System manage their transportation data in support of System Performance Dashboard transportation engineering and planning efforts. The TMS is fast-becoming the standard for transportation data management.We base the success of our business Primary Contact: on: Ben Chen, PE, PTOE • Transportation planning and traffic engineering Principal focus Email: bc@ms2soft.com • Database expertise Web: www.ms2soft.com • Continuous communication between and among the consultant and agency team • Meticulous attention to detail Staff Resources: • Effectively managing our work to consistently meet Manager 1 design,cost, and schedule requirements Software Engineer 5 • Continuous upgrades to software systems System Administrator 1 Transportation Engineer 1 The best indicator of MS2's success is that many public agencies are using MS2's system every day to share information with stakeholders and the public. These live examples are can be found on: http://www.ms2soft.com (under"Active Systems") Collier County RFP— 13-5993 Traffic Count Software 16 Packet Page-1166- ap 3/12/2013 16.A.10. Project Team Each project MS2 undertakes is overseen by Ben Chen, PE,PTOE. Ben is responsible for preparing proposals and contracts, assuring complete understanding of all project requirements, selecting the optimum staff for successful project completion, ensuring all necessary resources are available and ready when needed,monitoring project progress against technical/cost/schedule requirements,and regularly communicating with the client regarding project status. MS2 has a team of experienced transportation and software engineers, and a committed and creative staff who are currently providing services similar to those required by Collier County to more than 160 public transportation agencies. The team includes: Ben Chen, PE, PTOE Ben has 20+ years experience in transportation projects Project Manager including extensive experience developing innovative data Principal in charge collection methods and management systems for public and private sectors. He has developed and implemented GIS systems for numerous state DOTs,MPOs, county road agencies, and city engineering departments. He leads the firm's practice in developing and supporting the innovative web- based Transportation Data Management Systems (TDMS) for more than 160 agencies in 26 states and Canada. Ben is currently serving on the Expert Panel advising the Federal Highway Administration (FHWA)Traffic Monitoring Guide Update project. William J. Tomiko BJ has over 10 years experience in developing and Sr. Software Engineer implementing geographic and management information system User Support and GIS websites for public and private sectors. He is the lead GIS Applications Lead Specialist for the GIS implementation on the cloud-based Transportation Data Management System ('l'DMS). He is also an experienced database programmer who has developed and implemented database systems for many road agencies across the country. Steven M. Willaert Steven has over 10 years experience providing custom server Sr. Software Engineer software solutions and technical support to clients in a wide Web Applications Lead variety of industries. He is experienced with HTML,Unix, SQL Server Oracle,ASP,JavaScript,C/AL,Visual Basic and MFC Windows programming. Brian E. Rodgers Brian has more than 7 years experience in Information Software Engineer Technology and Information Systems solutions for public and private sector clients in web-based application development. He also has first hand experience in data collection and Aossk management for numerous transportation planning and traffic engineering projects. Collier County RFP—13-5993 Traffic Count Software 17 Packet Page-1167- 3/12/2013 16.A.10. Charles Huber A graduate of the University of Michigan, Chuck has extensive Software Engineer experience in web application development, system analysis, and data warehouse infrastructure. He is fluent in the latest programming languages and tools,including Cold Fusion, SQL,XML,JavaScript and PhotoShop. Dave Bow Dave has over 25 years of IT experience with client,data, and System Administrator server solutions. Over 20 years of experience with relational database systems. Dave is responsible for providing overall network infrastructure, data, and system solutions. He manages the firm's IT department to ensure optimum solutions to all IT requirements. Dave is the lead system administrator for the cloud-based Transportation Data Management System (TDMS). Complete résumés appear in the Appendices. Collier County RFP—13-5993 Traffic Count Software 18 Packet Page-1168- 3/12/2013 16.A.10. ,A6 Relevant Experience MS2 has been providing transportation engineering services to transportation agencies for nearly a decade. The following are some of the most recent and relevant projects: Start End Original Final No. of Project Description Date Date Budget Cost Change Orders Statewide Traffic Data Collection,Analysis, 2008 Ongoing $229,000 $229,000 None and Management hosting Arizona Department of Transportation 206 S. 17th Ave. Phoenix AZ 85007 Contact: Mark Catchpole / (602) 712-8596 MS2 Key Staff/Responsibilities: Ben Chen— Project Manager BJ Tomiko— Software Engineer(Mapping) Steve Willaert—Software Engineer(Web Services) ADOT has been using TRADAS to manage statewide traffic count data. The system has various limitations to meet ADOT's new initiatives: Amok • Sharing and exchanging data with MPOs and local agencies • Publishing traffic data for public needs • Improving the overal process of traffic data monitoring • Integrating traffic count data with others such as travel demand model output,travel time,traffic crash, and transportation assets To accomplish the above objectives,ADOT started using MS2's TCDS in 2008. Since then MS2 has been working with ADOT staff in identifying system needs and implementing process improvements. The proposed cloud-based system is to imrpove all traffic monitoring tasks, including the following: Data Processing and Analysis • Permanent count station data l'.---•:-;74;-:"-`,...—,-,-• wiYe5'0L5`10. 4 w , +i+=W • Short duration counts --- . - ■ Intersection turning movement counts — F • WIM data :.. ' ■ FHWA QA/QC business rules 4. Statisitical Analysis w`" _"" V • AADT/Seasonal&Axle factors /DHV/K%/ D% = - • VMT computation " ' -.' ; FHWA Submittal 1 • Station/Volume / Class /WIM/Speed data " j • HPMS reporting __ Live System: http://www.azdot.gov/mpd/data t -N "Transportation Data Management System (TDMS)" Collier County RFP—13-5993 Traffic Count Software 19 Packet Page-1169- 3/12/2013 16.A.10. Start End Original Final No.of Project Description Date Date Budget Cost Change Orders Statewide Traffic Data Collection,Analysis, 2008 Ongoing $271,000 $271,000 None and Management hosting Massachusetts Department of Transportation 10 Park Plaza,Suite 3170 Boston,MA 02116 Contact: William Mitchell/ (617) 719-9023 Transportation Program Planner MS2 Key Staff/Responsibilities: Ben Chen— Project Manager BJ Tomiko— Software Engineer (Mapping) Steve Willaert—Software Engineer(Web Services)ma, ,�„ ,� '°' The overall goal of this project ...,:'4°4,x6 a ems+ dMG6-t174.�1T1 ._. _„ was to review the traffic data 0.1 tea 4'n 6' :'' I ' collection processes, identify ❑ a;N 4 ' ' FHWA data submittal requirements and develop a - 7 cloud-based,centralised traffic ,— - ® • database system. A system c a ° ' 4 was developed to support .o = „ �° -' ca ; ' MassDOT's efficient _ -"IMP' �� manage e processes for 11.1==1111==1MMUMMil .1% ,. ' various traffic data. The study . 'y �# � � identified the available data MI 1 u,. _ sources formats and the most � efficient way to migrate the data into the central system. ..sr The data types and sources reviewed include the following: • MassDOT Statewide Traffic Data—The data consists of about 30 years of permanent count station data,turning movement data,speed data,weigh-in-motion data,and special counts • MassDOT ITS—This group has different data from various ITS devices,which can be used if it is loaded into the system and made available for wider use • MassDOT Traffic Operations—This group is involved with traffic crash information,traffic signals,and additional highway operations • CTPS—Most of the data from CTPS (Boston MPO) is the same as MHD but the study will identify potentially additional data • MA MPO's—Review if they have additional data for inclusion in the system Live System: http://mhd.ms2soft.com Collier County RFP—13-5993 Traffic Count Software 20 Packet Page-1170- 3/12/2013 16.A.10. Start End Original Final No.of Project Description Date Date Budget Cost Change Orders Cloud-based Traffic Count Database System 2006 Ongoing $119,000 $119,000 None (TCDS) hosting Illinois Department of Transportation 2300 S.Dirksen Pkwy Springfield,IL 62764 Contact: Rob Robinson/ (217) 782-0378 Data Management Unit Chief MS2 Key Staff/Responsibilities: Ben Chen- Project Manager BJ Tomiko- Software Engineer(Mapping) Steve Willaert-Software Engineer(Web Services) - _._-° IDOT collects traffic counts from over 16,000 locations statewide to provide raw hourly count If ° "n,'n r - �' jp, , ®'g -- . 3 . --i data to its users. Due to the ever-growing size f.,„ "" A. } , , ' ' . + "to.- of the count program,their existing Microsoft "-• * ' :--° Access based traffic count system began to fail ;.� „ ,.1:,:,.,� '� "*"-' ` ' : • _ to perform to their standards. R 1'--w 4∎«.• ° ' '"' The cloud based TCDS provided a powerful and efficient system to meet their count Hi_., '-"'� " - ' '. program's needs,added the GIS interface �.. ti .» F.7., .t ...,� t ` capabilities,and reduced staff time needed to e °, '�..r- --' L .rw ' maintain their legacy system. roam., J ' C , j t Live System: I L s , k i http://dot.state.il.us/maps/statistical.htm a—. #�^• (Select"Hourly Data") Collier County RFP— 13-5993 Traffic Count Software 21 Packet Page-1171- 2 3/12/2013 16.A.10. Start End Original Final ` No.of Project Description Date Date Budget Cost Change Orders Traffic Count Data Retrieval Systems 2008 Ongoing $177,000 $177,000 None hosting Maricopa Association of Governments MAG) 302 North 1st Avenue. Suite 300 Phoenix,AZ 85003 Contact: Wang Zhang/ (602) 452-5079 Transportation Engineer MS2 Key Staff/Responsibilities: Ben Chen— Project Manager BJ Tomiko— Software Engineer(Mapping) Steve Willaert—Software Engineer(Web Services) „.,. w..... : MAG maintains traffic count files for planning - - itp. studies,project development,and validation/ 1?w es At; a .,. `n "”"f .- - calibration of the regional travel demand 4 ❑ = .. "' ?'° P ., model. Previously,MAG would acquire traffic counts throughout the year in different formats ` � from various sources. Maintaining the traffic " '' r s5 count datasets with the level of detail required " ,.-- .y "" became a very resource intensive effort. . " MAG looked to implement a cloud-based,st• d GIS-enabled Traffic Count Data Retrieval a System that would minimize the staff time 1 � ?l a required for data management and also allow M 7:17 71'-711 ; member agencies to directly upload and access the count data in a timely fashion. Implementation of the new system involved almost 6,000 count locations and nearly 10,000 days of traffic counts at the time of the final version delivery in 2009. The count data has continued to grow through the on-going hosting services that are provided. Live System: http://ww-w.azmag.gov/transportation (Select"MAG Transportation Data Management System") Collier County RFP—13-5993 Traffic Count Software 22 Packet Page-1172- 3/12/2013 16.A.10. Start End Original Final No.of Project Description Date Date Budget Cost Change Orders ITS Vehicle Detection Data Analysis and 2008 Ongoing $48,000 $48,000 None Management hosting Road Commission for Oakland County 2420 Pontiac Lake Road Waterford,MI 48328 Contact: Gary Piotrowicz,PE,PTOE Director of Traffic-Safety (248) 858-4820 MS2 Key Staff/Responsibilities: Ben Chen— Project Manager BJ Tomiko— Software Engineer(Mapping) Steve Willaert—Software Engineer(Web Services) About 650 signalized intersections in Oakland County are r..J '.,e" equipped with SCATS vehicle detection devices. The goal of this project was to capture the continuous data feed from lane detectors and derive detailed statistics about the patterns and seasonality of the traffic on local street networks. The project + encompassed: • Develop data structure and interface to manage volume count data by lane at 15-min interval , • Program auto-polling routines to process SCATS binary - count files • Create intersection approach counts based on the lane counts and detector assignments • Automate data processing daily upon the direct data polling from about 650 intersections • Customize data displays,annual statistics reports and graphs • Customize computation routines for AADTs, seasonal factors,K/D factors, similar to permanent count stations Live System: http://oakland-scats.ms2soft.com Collier County RFP—13-5993 Traffic Count Software 23 Packet Page-1173- 3/12/2013 16.A.10. In addition,MS2 has developed and implemented numerous Transportation Data Management Systems (1'llMS) for state DOTs,MPOs, county road agencies, and local communities. The system is fast becoming the standard for transportation data management. The database is integrated with GIS road maps to assist users in efficiently retrieving and effectively presenting relevant information. As shown in the map below,more than 160 road agencies • 26 states are using the TDMS to manage transportation data, support project planning, and track work orders. villitIlige ?� � .4 -'z,,AN ' �r} �F s PLO , ., ° Yea; 4 AK . ED ills Client reference and contact information is available on: http://�nvw.ms2soft.com under "Active Systems" (Feel free to test drive these active systems in real time) Transportation Data Management System Client List (Partial) State Departments of Transportation Alaska/Arizona/ Colorado / Georgia/ Illinois / Indiana /Montana /Massachusetts / Michigan / DC Metropolitan Planning Organizations Birmingham MPO,AL Farmington MPO,NM Montgomery MPO,Al- Birmingham L Las Cruces MPO,NM Maricopa Association of Governments,AZ New York Metropolitan Transportation Council Southern California Association of Governments, CA (NYMTC),NY Space Coast Transportation Planning Organization,FL Association of Central Oklahoma Governments ,OK Indianapolis Metropolitan Planning Organization,IN Toledo Metro Area Council of Governments,OH South Central Planning Development Commission,LA Stark County Area Transportation Study,OH Southeast Michigan Council of Governments,MI Mid Ohio Regional Planning Commission, OH Genesee County Metropolitan Planning Commission,MI Clark County-Springfield Transportation Coordinating Grand Valley Metropolitan Council,MI Committee,OH Battle Creak Area Transportation Study(BOATS),MI Erie Regional Planning Commission,OH Kalamazoo Area Transportation Study(KATS),MI Licking County Area Transportation Study,OH Tri County Regional Planning Commission,MI Southwestern Pennsylvania Commission,PA Gulf Regional Planning Commission,MS Collier County RFP—13-5993 Traffic Count Software 24 Packet Page-1174- �' 3/12/2013 16.A.10. Counties Maricopa County,AZ Eaton County Road Commission,MI Sacramento County, CA Kalamazoo County Road Commission,MI Brevard County,FL Kent County Road Commission,MI Collier County,FL Washtenaw County Road Commission,MI Martin County,FL St. Clair County Road Commission,MI Lee County,FL Saginaw County Road Commission,MI DuPage County,IL Monroe County Road Commission,MI Lake County,IL Genesee County Road Commission,MI Road Commission for Oakland County,MI Delaware County Engineer,OH Wayne County Department of Public Services,MI Franklin County Engineer,OH Road Commission of Macomb County,MI Lucas County Engineer,OH Livingston County Road Commission,MI Wood County Engineer,OH Ingham County Road Commission,MI _ Stark County Engineer,OH Cities Montgomery,AL East Lansing,MI Las Cruces,NM Phoenix,AZ Farmington Hills,MI Oklahoma City,OK Tempe,AZ Flint,MI Edmond,OK Mesa,AZ Grand Rapids,MI Moore,OK Peoria,AZ Kalamazoo,MI Midwest City,OK Surprise,AZ Lansing,MI Norman,OK Glendale,AZ Livonia,MI Canton, OH • Chandler,AZ Novi,MI Columbus,OH Indianapolis, IN Pontiac,MI Toledo,OH Baltimore,MD Southfield,MI Oregon, OH Minneapolis,MN Troy,MI St. George,UT Battle Creek,MI Commerce Township,MI Virginia Beach,VA Detroit,MI Village of Lake Orion,MI Frisco,TX East Grand Rapids,MI Farmington,NM Coquitlam,BC, Canada Institutions University of Alabama at Birmingham,Alabama Bowling Green State University,Ohio Michigan State University,Michigan Howard University,DC Traffic Improvement Association,Michigan Private Sector Bergmann Associates Orchard,Hiltz&McCliment, Inc. Chrysler Group The Corradino Group HNI'B URS Corporation Hubbell,Roth&Clark,Inc. Wade Trim,Inc. Iteris Collier County RFP—13-5993 Traffic Count Software 25 Packet Page-1175- 3/12/2013 16.A.10. V Project Work Plan For this project,we propose the following tasks to meet the requirements as specified in the RFP: TASK 1 — PROJECT ACTION PLAN The development of a Project Action Plan will be initiated by a Kick-Off Meeting immediately following a Notice to Proceed from the County. MS2 staff will meet with the County staff associated with the project. The meeting is anticipated to include the following: • Introduce key staff members from MS2 and the County and describe their respective roles in the project • Finalize the proposed project's goals, data specifications,project schedule,and final deliverables • Document the full extent of data types and needs to incorporate into the program including GIS layers and databases/spreadsheets • Document the variety/type of anticipated program users • Utilizing the standard TCDS, discuss/brainstorm/document the anticipated customizations required for the project During or shortly after the meeting, existing traffic count data and GIS layers will be collected from the County, such as - • Traffic count location list (e.g.location/station ID, on road, from/to or intersecting road, functional class, community,x/y or latitude/longitude, etc.) • Historic count data (e.g.AADT,hourly or 15-min interval data,raw count data files,etc.) • Example count files of various formats for system verification and customization • Agency GIS layers (e.g. traffic count location points,road centerline, district boundary, community boundary, county boundary,etc.) Following the meeting,MS2 will summarize the meeting and utilize all of the items discussed-- including all historical data--to create a draft Project Action Plan for the data migration and system customizations to meet all of the County's needs. The draft Project Action Plan will be provided to County staff for review and revising as necessary. Following the review,MS2 will provide a finalized Project Action Plan to provide direction throughout the project. Deliverable: • A technical memorandum summarizing the kick-off meeting • A draft and finalized (following the County's review) Project Action Plan • One (1) on-site work trip for the kick-off meeting TASK 2 — SYSTEM IMPLEMENTATION Following the acceptance of the Project Action Plan and building on the standard TCDS,MS2 will begin a complete system implementation. The full system will incorporate the historical data from all the various sources as obtained from the County, functionality to import all on-going traffic count Collier County RFP—13-5993 Traffic Count Software 26 Packet Page-1176- 3/12/2013 16.A.10. activities, and the necessary customizations to meet all of the County's needs and requirements. The system functionality is anticipated to include,but is not limited to, the following features,a majority of which are standard TCDS features: • Traffic data polling management by auto-polling and manual imports of machine-readable volumes,bins, or individual vehicle records • Traffic data collection site management for traffic station identification and reference • Data workflow management to allow users to review and edit imported data prior to submitting the data into the database • Automated gnality control and quality checking of data with the generation of alerts/flags to inform users of potential data issues or errors • Calculate Seasonal and Axle Adjustment Factors in accordance with FHWA Traffic Monitoring Guide procedures • Calculate Average Daily Traffic (ADT),Annual Average Daily Traffic (AADT), and Vehicle Mile Traveled (VMT) • Calculate Annual Highest Hour,Annual Hourly Day of Week, and Annual Day of Week Percentage Statistics • Process and store short count data and continuous count data including volume, classification, weigh-in-motion, speed, and length data • Data summary and reporting of data in various timeframes (daily,monthly, quarterly, and year- end) • Database management tools for the storage,modification,importing, and extraction of traffic information • Export capabilities to support FHWA TMG reporting requirements including 3-Card, S-Card, C-Card,and W-Card records All historic data will be gathered from the County during or after the project kick-off. MS2 staff will perform the data migration and cleanup process to populate the TCDS. The TCDS,like every module of the TMS,has a seamlessly integrated GIS-enabled mapping component. MS2 uses an innovative hybrid mapping solution integrating Google Maps with ESRI's ArcGIS Server. This hybrid solution takes the widely-utilized Google Maps interface and combines it with the powerful GIS analytic capabilities of ArcGIS Server. The result is a mapping solution that displays an agency's GIS data layers on the Google Maps interface. MS2 will incorporate existing GIS layers,as desired by the County,into the TCDS's mapping component. System customizations will be made to meet all County's traffic monitoring needs. We are prepared to create automated processes to validate and import data from the County's ITS devices for volume, speed,length, and occupancy data. In addition,MS2 has the experience and system resources to handle the large datasets often created by these ITS data sources. The customizations may include: • Additional data attributes • Count location ID convention • Customized user interface • Additional data uploading routines rte. • Additional automated polling application for traffic detection devices • Additional data validation routines (e.g. trending and abnormalities) Collier County RFP— 13-5993 Traffic Count Software 27 Packet Page-1177- 3/12/2013 16.A.10. • Special data queries, analysis,graphs,and reports A 4-step system development process (brainstorming-prototype-feedback-refinement)will be used to ensure the customizations meet the requirements specified by County. Deliverables: • Customized TCDS populated with all historic data ■ TCDS interface for automated import and validation of data from various ITS devices TASK 3 — USER TRAINING AND SUPPORT MS2 understands that the best way to ensure a successful project is to make sure that County staff can effectively use and manage the system. Hands-on training will be provided so that the County staff will become familiar with all the tools and functionality within the system. As a combined presentation/demonstration and hands-on/question and answer session, on-site training will be conducted to enable staff to learn the use of the system. MS2 proposes one on-site training workshop for the County. The workshop will last between 6 and 8 hours in order to fully cover all functionality of the system. Training materials will be prepared ahead of time and be distributed to users before the training. The training will be conducted at a County facility using the agency's computer systems to ensure that the training occurs in the actual environment in which the staff will use the system. MS2 will prepare a TCDS User's Guide. The document is to provide the County staff with all of the information required to operate the system after the completion of the project. In addition, MS2 is prepared to provide additional training through interactive webinars as needed to ensure the County staff can properly use the system to meet all of their traffic data storage,analysis, and management needs. Recently,MS2 has been providing complimentary"How to Use"webinars for several of the TDMS modules. "How to Use the Traffic Count Database System"was the first webinar in this series. The webinars are also recorded and made available on our Events webpage for anyone to access at anytime. The Events webpage contains several recorded webinars including the TCDS as well as the announcement of upcoming webinars. MS2's Events webpage can be accessed at http://www.ms2soft.com (under Events) MS2 will continue supporting the system for the County throughout the length of the contract which includes,but is not limited to the following: • Perform system maintenance as necessary • Implement system enhancements when requested or available • Provide technical support to County staff as requested Deliverables: • One (1) on-site training workshop • TCDS/TMC User's Guide • Training webinars, as needed • On-going hosting and support Collier County RFP–13-5993 Traffic Count Software 28 Packet Page-1178- 3/12/2013 16.A.10. PROPOSED PROJECT SCHEDULE .-....... .. . Task Week 1 2 3 4 5 6 7 8 9 10 11 12 1.Project Action Plan 2.System Implementation 3.User Training and System Support Collier County RFP—13-5993 Traffic Count Software 29 Packet Page-1179- 3/12/2013 16.A.10. w „Y:ti�'•.. Vi References Space Coast Transportation Planning Organization, Florida Ms. Laura Carter Special Projects Coordinator (321) 690-6890 Martin County, Florida Mr. Erik Ferguson, PE Project Engineer (772)463-3229 City of Minneapolis, Minnesota Mr. Darryn Proch Traffic and Parking Services (612) 673-5516 City of Virginia Beach,Virginia Mr. Rodney Schwartz Traffic Engineering Division (757) 385-4131 Toledo Metropolitan Area Council of Governments, Ohio Ms. Lisa Householder Transportation Planner (419) 241-9155 Completed Questionnaires from the above references are included at the end of Section VIII, Required Forms. Collier County RFP—13-5993 Traffic Count Software 30 Packet Page-1180- 3/12/201316.A.10. italk I I Acceptance of Conditions MS2 will meet all requirements as specified in the RFP. Collier County RFP— 13-5993 Traffic Count Software 31 Packet Page-1181- 3/12/2013 16.A.10. Viii Required Forms Vendor Check List Conflict of Interest Affidavit Vendor Declaration Statement Affidavit for Claiming Status as a Local Business Immigration Affidavit Certification Vendor Substitute W-9 Insurance and Bonding Requirements Reference Questionnaire Collier County RFP—13-5993 Traffic Count Software 32 Packet Page-1182- 3/12/2013 16.A.10. CA.Comity_,.... A iristreave Services Attachment 2: Vendor Check List IMPORTANT: THIS SHEET MUST BE SIGNED. Please read carefully,sign in the spaces indicated and return with your Proposal. Vendor should check off each of the following items as the necessary action is completed: ® The Proposal has been signed. ® All applicable forms have been signed and included, along with licenses to complete the requirements of the project. ® Any addenda have been signed and included. ® The mailing envelope has been addressed to: Collier County Government Purchasing Department 3327 Tamiami Trail E Naples FL 34112 Attn: Brenda Brilhart,Procurement Strategist ® The mailing envelope must be sealed and marked with RFP 13-5993 Traffic Count Software. ® The Proposal will be mailed or delivered in time to be received no later than the specified due date and time. (Otherwise Proposal cannot be considered.) ALL COURIER-DELIVERED PROPOSALS MUST HAVE THE RFP NUMBER AND TITLE ON THE OUTSIDE OF THE COURIER PACKET. Name of Firm: Midwestern Software Solutions,LLC Address: 3815 Plaza Drive City, State,Zip: Ann Arbor,MI 48108-1655 Telephone: (734)995-0200 Email: bc@ms2.com Representative Signature: ti ----- Representative Name: Ben Chen,PE,PTOE Date 11/1/12 Collier County RFP—13-5993 Traffic Count Software Packet Page-1183- 3/12/2013 16.A.10. Cofer County Administrative SerVICBS Division Pum,asn Attachment 3: Conflict of Interest Affidavit By the signature below,the firm(employees,officers and/or agents)certifies,and hereby discloses,that,to the best of their knowledge and belief,all relevant facts concerning past,present,or currently planned interest or activity(financial,contractual,organizational,or otherwise)which relates to the proposed work; and bear on whether the firm(employees,officers and/or agents)has a possible conflict have been fully disclosed. Additionally,the firm(employees,officers and/or agents)agrees to immediately notify in writing the Purchasing/General Services Director,or designee,if any actual or potential conflict of interest arises during the contract and/or project duration, Finn: Midwestern Software Solutions,LLC Signature and Date: tit/2/2012 Print Name Ben Chen,PE,PTOE Title of Signatory Principal/Senior Project Manager State of Michigan County of Washtenaw SUBSCRIBED AND SWORN to before me this 1st day of November ,2012 , by Ben Chen,_PE,PTOE ,who is personally known to me to be the Principal/Senior Project Manager for the Finn,OR who produced the following identification f ,,,,t: ., 1_,,je," Notary Public t > My Commission Expires /- R- O / VITA M..0 NOTARYPUBUIC,STATE OF MI COUNTYOFWA$IrrENAW MY COMMISSION EXPIRES Dec 16,2018 ACTING IN COUNTY OF Collier County RFP—13-5993 Traffic Count Software Packet Page-1184- 3/12/2013 16.A.10. ig., CO County Adminisbabve Swims Carlson Purchasing Attachment 4: Vendor Declaration Statement BOARD OF COUNTY COMMISSIONERS Collier County Government Complex Naples,Florida 34112 RE: Solicitation: RFP 13-5993 Traffic Count Software Dear Commissioners: The undersigned, as Vendor declares that this proposal is made without connection or arrangement with any other person and this proposal is in every respect fair and made in good faith,without collusion or fraud. The Vendor agrees, if this proposal is accepted, to execute a Collier County document for the purpose of establishing a formal contractual relationship between the firm and Collier County, for the performance of all requirements to which the proposal pertains. The Vendor states that the proposal is based upon the proposal documents listed by Solicitation: RFP 13-5993 Traffic Count Software (Proposal Continued on Next Page) Amok Collier County RFP—13-5993 Traffic Count Software Packet Page-1185- 3/12/2013 16.A.10. PROPOSAL CONTINUED IN WITNESS WHEREOF,WE have hereunto subscribed our names on this 2nd day of November ,2012 in the County of Washtenaw ,in the State of_Michigan_. Firm's Legal Name: Midwestern Software Solutions,LLC Address: 3815 Plaza Drive City,State,Zip Code: Ann Arbor,MI 48108-1655 Florida Certificate of Authority * See following page. Document Number: Federal Tax Identification 20-2394124 Number Telephone: (734)995-0200 FAX: (734)995-0599 Signature by: /Ben Chen,PE,PTOE (Typed and written) Title: Principal/Senior Project Manager Additional Contact Information Send payments to: (required if different from above) Company name used as payee Contact name: Title: Address: City,State,ZIP Telephone: FAX: Email: Office servicing Collier County to place orders (required if different from above) Contact name: Title: Address: City,State,ZIP Telephone: Email Collier County RFP—13-5993 Traffic Count Software Packet Page-1186- 3/12/2013 16.A.1O. .x, From:BrilhartBrenda[BrendaBrilhart@colliergov.net] Sent:Wednesday,October 17,2012 4:12 PM To:Lev Wood Subject:RE:RFP 13-5993 Len,yes,this would be acceptable, please just include this email in your bid submittal. From: Lev Wood [mailto:CLW@n midwesternconsulting.com] Sent: Wednesday, October 17, 2012 9:54 AM To: BrilhartBrenda Subject: RFP 13-5993 Hello Brenda, MS2 is likely to submit a proposal in response to RFP 13-5993,Traffic Count Software. Regarding item#14 of page 18 of the RFP,Certificate of Authority to Conduct Business in the State of Florida,we have the forms from www.sunbiz.org. There is a$70 fee for getting registered. Can we wait to see if we win the project before submitting the forms and spending the$70? Of course,if we win the project we will submit the forms and the fee. Please advise. Lev Wood MS2 3810 Plaza Drive Ann Arbor,MI 48108 734-904-0868 www.ms2soft.com Under Florida Law,e-mail addresses are public records.If you do not want your e-mail address released in response to a public records request,do not send electronic mail to this entity.Instead,contact this office by telephone or in writing, Collier County RFP—13-5993 Traffic Count Software Packet Page-1187- 3/12/2013 16.A.1O. coltC�uexty Acranciantive Services Division Purchasreg Attachment 5: Affidavit for Claiming Status as a Local Business Solicitation: RFP 13-5993 Traffic Count Software (Check Appropriate Boxes Below) N/A State of Florida(Select County if Vendor is described as a Local Business ❑Collier County ❑Lee County Vendor affirms that it is a local business as defined by the Purchasing Policy of the Collier County Board of County Commissioners and the Regulations Thereto. As defined in Section XI of the Collier County Purchasing Policy; A"local business"is defined as a business that has a valid occupational license issued by either Collier or Lee County for a minimum of one(1)year prior to a Collier County bid or proposal submission that authorizes the business to provide the commodities or services to be purchased,and a physical business address located within the limits of Collier or Lee Counties from which the vendor operates or performs business.Post Office Boxes are not verifiable and shall not be used for the purpose of establishing said physical address.In addition to the foregoing,a vendor shall not be considered a"local business"unless it contributes to the economic development and well-being of either Collier or Lee County in a verifiable and measurable way.This may include,but not be limited to,the retention and expansion of employment opportunities,the support and increase to either Collier or Lee County's tax base,and residency of employees and principals of the business within Collier or Lee County.Vendors shall affirm in writing their compliance with the foregoing at the time of submitting their bid or proposal to be eligible for consideration as a"local business"under this section. Vendor must complete the following information: Year Business Established in['Collier County or❑Lee County: Number of Employees(Including Owner(s)or Corporate Officers): Number of Employees Living in❑Collier County or❑Lee(Including Owner(s)or Corporate Officers): If requested by the County,vendor will be required to provide documentation substantiating the information given in this affidavit.Failure to do so will result in vendor's submission being deemed not applicable. Vendor Name Date: Collier or Lee County Address: Signature: Title: STATE OF FLORIDA ❑COLLIER COUNTY ❑LEE COUNTY Sworn to and Subscribed Before Me,a Notary Public,for the above State and County,on this Day of ,20 . Notary Public My Commission Expires: (AFFIX OFFICIAL SEAL) Collier County RFP—13-5993 Traffic Count Software Packet Page-1188- 3/12/2013 16.A.10. 4 . aer C_;vricroy Purchasing Attachment 6: Immigration Affidavit Certification Solicitation:RFP 13-5993 Traffic Count Software This Affidavit is required and should be signed, notarized by an authorized principal of the firm and submitted with formal Invitations to Bid (ITB's) and Request for Proposals (RFP) submittals. Further, Vendors/ Bidders are required to enroll in the E-Verify program, and provide acceptable evidence of their enrollment, at the time of the submission of the vendor's/bidder's proposal. Acceptable evidence consists of a copy of the properly completed E-Verify Company Profile page or a copy of the fully executed E-Verify Memorandum of Understanding for the company. Failure to include this Affidavit and acceptable evidence of enrollment in the E-Verify program, may deem the Vendor/Bidder's proposal as non-responsive. Collier County will not intentionally award County contracts to any vendor who knowingly employs unauthorized alien workers, constituting a violation of the employment provision contained in 8 U.S.C. Section 1324 a(e)Section 274A(e)of the Immigration and Nationality Act("INA"). Collier County may consider the employment by any vendor of unauthorized aliens a violation of Section 274A (e) of the INA. Such Violation by the recipient of the Employment Provisions contained in Section 274A (e) of the INA shall be grounds for unilateral termination of the contract by Collier County. Vendor attests that they are fully compliant wit II applicable immigration laws (specifically to the 1986 Immigration Act and subsequent Amendme t(g)and agrees to comply with the provisions of the Memorandum of Understanding with E-Verify and to,pfovide proof enrollment in The Employment Eligibility Verification System (E-Verify), operated by the Department of Ho eland Security in partnership with the Social Security Administration at the time of submission of the Vend ifs/Bi s posal. Company Name Mid,vestern Software Sof ions, LLC Print Name Lev W;:d Title Business Development Mgr Signature Date 11/1/12 State of Michigan County of Washtenaw The foregoing instrument was signed and acknowledged before me this 2nd day of November , 2012 , by Lev Wood who has produced MI DL#W300128514394 as identification. -rint or T (�e Name (Type of Identification and Number) priory Public Si nature vim m.CISAIORIEK PV f -- M . /E/n I�0 g e_. COUNTY IC,STATE OFIAI ame of Notary Public MYCOM ONE [ 5,2018 / Iv ACTING IN COUNTY OF Notary Commission umber/Expiration The signee of this Affidavit guarantees,as evidenced by the sworn affidavit required herein,the truth and accuracy of this affidavit to interrogatories hereinafter made. Collier County RFP—13-5993 Traffic Count Software Packet Page-1189- 3/12/2013 16.A.10. -7,44.4j6... ...._,.. ,... E-VeriFy „* ,M... q +s..w oe Company D Number:809077 To be accepted as s participant in E Verily,you mould only sign the Employer's Section of the signature pope.it you have any questions,contact E Verify at 888-464 421E - over aid�nestera eoasaitlal e wood Toeor7 *) Signed OI1 12012 'Dfoe • . rt ment of Homeland Securityy-Veri6csfian Division CIS 1 eri&aNaa DiVWOn i+ eotr�oraicall�r Signed 612012 Information Required for the 'l/erffy Program nformation reialiing to your omptanyr Company 4 Company Fad .--."-ss=•15 p(sra drtre arbor.*48108 Company Alternate Addressrn : Cour or Parish: 115HTENAW Employer Idenfifioalion Number: <.a ■r Page t2 ar 131 E•Vegli ?U for Eeipbyer 1 Rew11Q1 bite O9A7A4 www:.dhs.gov!Ealertfy Collier County RFP—13-5993 Traffic Count Software Packet Page-1190- 3/12/2013 16.A.10. ,itjlig,, E-VeriFy ,,,,„,- T....,Itli",;• �� Company 10 Number 603077 North Amencsn industry CtessiEoebon Systems Code: Administrator Number of Eniplo�rees: 10 89 Number of Sites Vertied for. Are you veri Yia for more l site?If yes,please provide the caber of sites verified for in each State: . ?if:MOAN 1 (ig Information relating to the Program Administrators)for your Company on policy questions or operational problems: Name lee weed 'Telephone'Nvsabe (734)905-4240 Fax Nnmtec Page 13 ar 13 I E-Ven y M0U Mr EITe yer1 rreveaori Drre 09001109 ww et.dhs.gov/E-Verify Collier County RFP—13-5993 Traffic Count Software Packet Page-1191- 3/12/2013 16.A.10. JO C.I.A. 0 14 PIO LSD Purchasing Attachment 7:Vendor Substitute W—9 Request for Taxpayer Identification Number and Certification In accordance with the Internal Revenue Service regulations, Collier County is required to collect the following information for tax reporting purposes from individuals and companies who do business with the County(including social security numbers if used by the individual or company for tax reporting purposes). Florida Statute 119.071(5)require that the county notify you in writing of the reason for collecting this information,which will be used for no other purpose than herein stated. Please complete all information that applies to your business and return with your quote or proposal. 1. General Information(provide all information) Taxpayer Name Midwestern Consulting.LLC (Parent Company of Midwestern Software Solutions,LLC) (as shown on income tax return) Business Name_Midwestern Software Solutions,LLC (if different from taxpayer name) Address 3815 Plaza Drive City Ann Arbor State Michigan Zip 48108-1655 Telephone (734)995-0200 FAX (734)995-0599 Email bc(R)ms2soft.com Order Information Remit/Payment information Address 3815 Plaza Drive Address 3815 Plaza Drive City Ann Arbor State MI Zip 48108-1655 City Ann Arbor State MI Zip_48108-1655 FAX (734)995-0599 FAX (734)995-0200 Email bc@ems2soft.com Email_bcems2soft.com 2. Company Status(check only one) _Individual/Sole Proprietor Corporation partnership _Tax Exempt(Federal income tax-exempt entity X Limited Liability Company under Internal Revenue Service guidelines IRC 501 (c)3) P Enter the tax classification (D =Disregarded Entity, C-Corporation,P=Partnership) 3. Taxpayer Identification Number(for tax reporting purposes only) Federal Tax Identification Number(TIN) 20-2394124 (Vendors who do not have a TIN,will be required to provide a social security number prior to an award of the contract.) 4. Sign and Date Form Certification:Under penalties of perjury,I certify that the information shown on this form is correct to my knowledge. Signature 4e----------""""�— Date 1111/12 Title Principal/Senior Project Manager Phone Number (734)995-0200 Collier County RFP—13-5993 Traffic Count Software Packet Page-1192- 3/12/2013 16.A.10. AB uG acri*Strare Services Division Purchasing Attachment 8: Insurance and Bonding Requirements 3nsn®ce Bond. 'Pe ,,c, Required T mits y ~ ° _, Worker's Statutory Limits of Florida Statutes,Chapter 440 and all Federal Government Compensation Statutory Limits and Requirements 2. El Employer's Liability $1.000.000 single limit per occurrence 3. ®Commercial General Bodily Injury and Property Damage Liability(Occurrence Form)patterned after the $1,000,000 single limit per occurrence,$2,000,000 aggregate for Bodily Injury current ISO form Liability and Property Damage Liability. This shall include Premises and Operations;Independent Contractors;Products and Completed Operations and Contractual Liability 4. ®indemnification To the maximum extent permitted by Florida law,the ContractorNendor/ Consultant shall indemnify and hold harmless Collier County,its officers and employees from any and all liabilities,damages,losses and costs,including,but not limited to,reasonable attorneys'fees and paralegals'fees,to the extent caused by the negligence,recklessness,or intentionally wrongful conduct of the ContractorNendor/Consultant or anyone employed or utilized by the ContractorNendor/Consultant in the performance of this Agreement. This indemnification obligation shall not be construed to negate,abridge or reduce any other rights or remedies which otherwise may be available to an indemnified party or person described in this paragraph.This section does not pertain to any incident arising from the sole negligence of Collier County. 4. ®Automobile Liability $ 1.000.000 Each Occurrence;Bodily Injury&Property Damage, Owned/Non-owned/Hired;Automobile Included 5. ® Other insurance as 0 Watercraft $ Per Occurrence noted: 0 United States Longshoreman's and Harborworker's Act coverage shall be maintained where applicable to the completion of the work. $ Per Occurrence 0 Maritime Coverage(Jones Act)shall be maintained where applicable to the completion of the work. $ Per Occurrence 0 Aircraft Liability coverage shall be carried in limits of not less than$5,000,000 each occurrence if applicable to the completion of the Services under this Agreement. $ Per Occurrence 0 Pollution $ Per Occurrence 0 Professional Liability $ Per Occurrence • $ 500,000 each claim and in the aggregate • $1,000,000 each claim and in the aggregate • $2,000,000 each claim and in the aggregate Collier County RFP—13-5993 Traffic Count Software Packet Page-1193- 3/12/2013 16.A.10. Professional Liability $2,000,000 per claim and in the aggregate • $1,000,000 per claim and in the aggregate • $2,000,000 per claim and in the aggregate ❑Valuable Papers Insurance $ Per Occurrence 6. ❑Bid bond Shall be submitted with proposal response in the form of certified funds,cashiers' check or an irrevocable letter of credit,a cash bond posted with the County Clerk, or proposal bond in a sum equal to 5%of the cost proposal.All checks shall be made payable to the Collier County Board of County Commissioners on a bank or trust company located in the State of Florida and insured by the Federal Deposit Insurance Corporation. 7. ❑Performance and For projects in excess of$200,000,bonds shall be submitted with the executed Payment Bonds contract by Proposers receiving award,and written for 100%of the Contract award amount,the cost borne by the Proposer receiving an award.The Performance and Payment Bonds shall be underwritten by a surety authorized to do business in the State of Florida and otherwise acceptable to Owner;provided,however,the surety shall be rated as"A-"or better as to general policy holders rating and Class V or higher rating as to financial size category and the amount required shall not exceed 5%of the reported policy holders' surplus,all as reported in the most current Best Key Rating Guide,published by A.M.Best Company,Inc.of 75 Fulton Street, New York,New York 10038. 8. ® Vendor shall ensure that all subcontractors comply with the same insurance requirements that he is required to meet. The same Vendor shall provide County with certificates of insurance meeting the required insurance provisions. 9. Collier County must be named as"ADDITIONAL INSURED" on the Insurance Certificate for Commercial General Liability where required. 10. ® The Certificate Holder shall be named as Collier County Board of County Commissioners,OR, Board of County Commissioners in Collier County, OR Collier County Government,OR Collier County. The Certificates of Insurance must state the Contract Number, or Project Number, or specific Project description,or must read: For any and all work performed on behalf of Collier County. 11. ® Thirty(30)Days Cancellation Notice required. 12. Vendor's Insurance Statement We understand the insurance requirements of these specifications and that the evidence of insurability may be required within five(5)days of the award of this solicitation. Name of Firm Midwestern Software Solutions�LLC Date November 1 2012 Vendor Signature Print Name Ben Chen,PE,PTOE Insurance Agency Moore Insurance Services Inc. Agent Name Sarah Fasnacht,CISR Telephone Number (517)439-9345 Collier County REP—13-5993 Traffic Count Software Packet Page-1194- 3/12/2013 16.A.10. Brevard Co* 4emoosks Ave Semces Dron Purcnaurkg Attachment 9: Reference Questionnaire Solicitation: RFP 13-5993 Traffic Count Software Reference Questionnaire for: Midwestern Software Solutions— MS2 (Name of Company Requesting Reference Information) Ben Chen (Name of Individuals Requesting Reference Information) Name:Laura Carter Company:Space Coast Transportation Planning Org. (Evaluator completing reference questionnaire) (Evaluator's Company completing reference) Email: FAX: 321-690-6827 Telephone: 321-690-6890 Collier County, Florida is implementing a process that collects reference information on firms and their key personnel to be used in the selection of firms to perform this project. The Name of the Company listed in the Subject above has listed you as a client for which they have previously performed work. Please complete the survey. Please rate each criteria to the best of your knowledge on a scale of 1 to 10, with 10 representing that you were very satisifed (and would hire the firm/individual again) and 1 representing that you were very unsatisfied (and would never hire the firm/indivdival again). If you do not have sufficient knowledge of past performance in a particular area, leave it blank and the item or form will be scored"0." Project Description:TCDS/TSMS Completion Date: Beginning in 2007 oak Project Budget: $35,900 Project Number of Days:3 weeks Change Orders- Dollars Added : $0 Change Orders - Days Added: 0 Item Citeria Score 1 Ability to manage the project costs(minimize change orders to scope). 10 2 Ability to maintain project schedule (complete on-time or early). 10 3 Quality of work. 10 4 Quality of consultative advice provided on the project. 10 5 Professionalism and ability to manage personnel. 10 6 Close out project process (final product turnover; invoices; manuals or going 10 forward documentation, etc.) 7 Ability to verbally communicate and document information clearly and succinctly. 10 8 Abiltityto manage risks and unexpected project circumstances. 10 9 Ability to follow County policies, procedures, rules, regulations, etc. 10 10 Overall comfort level with hiring the company in the future (customer satisfaction). 10 TOTAL SCORE OF ALL ITEMS 100 Please email this completed survey to: Lev Wood at clw @ms2soft.com By Friday, October 19, 2012 Packet Page -1195- 3/12/2013 16.A.10. VBGOV Goer County Admistrative Savices Division Purchasing Attachment 9: Reference Questionnaire Solicitation: RFP 13-5993 Traffic Count Software Reference Questionnaire for: Midwestern Software Solutions—MS2 (Name of Company Requesting Reference Information) Ben Chen (Name of Individuals Requesting Ref rence Information) Name: b RQ'" ��i� t t� f v Company: Jt geftLL (Evaluator completing reference questionnaire) (Evaluator's Company completing reference) Emai1:K`'z --\1\° °"(*@VDYV U4Nk FAX:(7 ) � " 8"C— 1 Collier County, Florida is implementing a process that collects reference information on firms and their key personnel to be used in the selection of firms to perform this project. The Name of the Company listed in the Subject above has listed you as a client for which they have previously performed work. Please complete the survey. Please rate each criteria to the best of your knowledge on a scale of 1 to 10, with 10 representing that you were very satisifed (and would hire the firm/individual again) and 1 representing that you were very unsatisfied (and would never hire the firm/indivdival again). If you do not have sufficient knowledge of past performance in a particular area, leave it blank and the item or form will be scored"0." Project Description: TCDS/TMC Completion Date: Beginning in 2008 Project Budget: $60,700 Project Number of Days:3 weeks Change Orders-Dollars Added : $0 Change Orders-Days Added: 0 Item Citeria Score 1 Ability to manage the project costs(minimize change orders to scope). 2 Ability to maintain project schedule(complete on-time or early). t 3 Quality of work. \ D 4 Quality of consultative advice provided on the project. 5 Professionalism and ability to manage personnel. o 6 Close out project process (final product turnover; invoices; manuals or going forward documentation, etc.) 7 Ability to verbally communicate and document information clearly and succinctly. c D 8 Abiltity to manage risks and unexpected project circumstances. / 9 Ability to follow County policies, procedures, rules, regulations, etc. 10 Overall comfort level with hiring the company in the future(customer satisfaction). I� TOTAL SCORE OF ALL ITEMS i b (J' Please email this completed survey to: Lev Wood at ciw(c ms2soft.com By Friday,October 19,2012 Packet Page-1196- 3/12/2013 16.A.10. Toledo Coder County Adrrin strative Services Division Purchasing Attachment 9: Reference Questionnaire Solicitation: RFP 13-5993 Traffic Count Software Reference Questionnaire for: Midwestern Software Solutions—MS2 (Name of Company Requesting Reference Information) Ben Chen (Name of Individuals Requesting Reference Information) Name: Lisa Householder Company: Toledo Metropolitan Area Council of Governments (Evaluator completing reference questionnaire) (Evaluator's Company completing reference) Email: householder @tmacog.org FAX: (419)241-9116 Telephone: (419)241-9155 ext. 124 • Collier County, Florida is implementing a process that collects reference information on firms and their key personnel to be used in the selection of firms to perform this project. The Name of the Company listed in the Subject above has listed you as a client for which they have previously performed work. Please complete the survey. Please rate each criteria to the best of your knowledge on a scale of 1 to 10, with 10 representing that you were very satisifed (and would hire the firm/individual again) and 1 representing that you were very unsatisfied (and would never hire the firm/indivdival again). If you do not have sufficient knowledge of past performance in a particular area, leave it blank and the item or form will be scored "0." Project Description: TCDS Completion Date: Beginning in 2004 Project Budget: $51,700 Project Number of Days: 3 weeks Change Orders- Dollars Added : $0 Change Orders- Days Added: 0 Item Citeria Score 1 Ability to manage the project costs(minimize change orders to scope). 9 2 Ability to maintain project schedule(complete on-time or early). 10 3 Quality of work. 9 4 Quality of consultative advice provided on the project. 10 5 Professionalism and ability to manage personnel. 10 6 Close out project process (final product turnover; invoices; manuals or going 10 forward documentation, etc.) 7 Ability to verbally communicate and document information clearly and succinctly. 9 8 Abiltity to manage risks and unexpected project circumstances. 9 9 Ability to follow County policies, procedures, rules, regulations, etc. 10 10 Overall comfort level with hiring the company in the future (customer satisfaction). 10 TOTAL SCORE OF ALL ITEMS otook Please email this completed survey to: Lev Wood at clwCu.ms2soft.com By Friday,October 19,2012 Packet Page-1197- 3/12/2013 16.A.10. Mpls Cott County Administrative Services Division Purchasing Attachment 9: Reference Questionnaire Solicitation: RFP 13-5993 Traffic Count Software Reference Questionnaire for: Midwestern Software Solutions—MS2 (Name of Company Requesting Reference Information) Ben Chen (Name of Individuals Requesting Reference Information) Name:Darryn Proch Company:City of Minneapolis—Traffic Engineering (Evaluator completing reference questionnaire) (Evaluator's Company completing reference) Email: darryn.proch©minneapolismn.gov FAX: 612-370-3973 Telephone: 612-673-5516 Collier County, Florida is implementing a process that collects reference information on firms and their key personnel to be used in the selection of firms to perform this project. The Name of the Company listed in the Subject above has listed you as a client for which they have previously performed work. Please complete the survey. Please rate each criteria to the best of your knowledge on a scale of 1 to 10, with 10 representing that you were very satisifed (and would hire the firm/individual again) and 1 representing that you were very unsatisfied (and would never hire the firm/indivdival again). If you do not have sufficient knowledge of past performance in a particular area, leave it blank and the item or form will be scored"0." Project Description: TCDS/TCLS/TMC Completion Date: Since 2006 Project Budget: $121,300 Project Number of Days: 3 weeks Change Orders- Dollars Added : $0 Change Orders- Days Added: 0 Item Citeria Score 1 Ability to manage the project costs (minimize change orders to scope). 9 2 Ability to maintain project schedule(complete on-time or early). 9 3 Quality of work. 9 4 Quality of consultative advice provided on the project. 10 5 Professionalism and ability to manage personnel. 9 6 Close out project process (final product turnover; invoices; manuals or-going 9 forward documentation, etc.) 7 Ability to verbally communicate and document information clearly and succinctly. 9 8 Abiltity to manage risks and unexpected project circumstances. 9 9 Ability to follow County policies, procedures, rules, regulations, etc. 9 10 Overall comfort level with hiring the company in the future(customer satisfaction). 9 TOTAL SCORE OF ALL ITEMS 9/ Please email this completed survey to: Lev Wood at clwna ms2soft.com By Friday, October 19,2012 Packet Page-1198- 3/12/2013 16.A.10. Martin Cott County Adrreristrathe Services Division Purchasing Attachment 9: Reference Questionnaire Solicitation: RFP 13-5993 Traffic Count Software Reference Questionnaire for: Midwestern Software Solutions—MS2 (Name of Company Requesting Reference Information) Ben Chen (Name of Individuals Requesting Reference Information) Name:Erik Ferguson, PE Company:Martin County B.O.C.C. Traffic Eng. Division (Evaluator completing reference questionnaire) (Evaluator's Company completing reference) Email: eferguso @martin.fl.us FAX: 772-288-5955 Telephone: 772-288-5927 Collier County, Florida is implementing a process that collects reference information on firms and their key personnel to be used in the selection of firms to perform this project. The Name of the Company listed in the Subject above has listed you as a client for which they have previously performed work. Please complete the survey. Please rate each criteria to the best of your knowledge on a scale of 1 to 10, with 10 representing that you were very satisifed (and would hire the firm/individual again) and 1 representing that you were very unsatisfied (and would never hire the firm/indivdival again). If you do not have sufficient knowledge of past performance in a particular area, leave it blank and the item or form will be scored"0." Project Description: TCDS Completion Date: Beginning in 2007 Project Budget: $18,000 Project Number of Days: 3 weeks Change Orders-Dollars Added : $0 Change Orders- Days Added: 0 Item Citeria. Score 1 Ability to manage the project costs(minimize change orders to scope). 10 2 Ability to maintain project schedule(complete on-time or early). 10 3 Quality of work. 9 4 Quality of consultative advice provided on the project. 9 5 Professionalism and ability to manage personnel. 9 6 Close out project process(final product turnover; invoices; manuals or going 9 forward documentation, etc.) 7 Ability to verbally communicate and document information clearly and succinctly. 9 8 Abiltity to manage risks and unexpected project circumstances. 9 9 Ability to follow County policies, procedures, rules, regulations, etc. 9 10 Overall comfort level with hiring the company in the future (customer satisfaction). 9 TOTAL SCORE OF ALL ITEMS Please email this completed survey to: Lev Wood at clwems2soft.com By Friday, October 19,2012 Packet Page-1199- 3/12/2013 16.A.10. APPENDIX Resumes Hongbin (Ben) Chen, PE, PTOE —Principal (Project Manager) William J. Tomiko — Senior Software Engineer (GIS / User Support) Steven M. Willaert— Senior Software Engineer (Web Application) Brian E. Rodgers — Software Engineer (Web Application) Charles Huber— Software Engineer (Web Application) David J. Bow— System Administrator Collier County RFP—13-5993 Traffic Count Software Packet Page-1200- 3/12/2013 16.A.10. ��n,4i4iW Hongbin (Ben) Chen, PE, PTOE — Principal (Project Manager) Professional Over 22 years experience in transportation engineering projects primarily Qualifications involved in providing public sector clients with transportation data management software applications Education M.S. / Civil Engineering / New Jersey Institute of Technology Career History MS2/Midwestern Consulting since 2001 Giffels-Webster Engineers, Inc., Detroit,MI, 1996-2001 Ayres,Lewis,Norris &May, Inc.,Ann Arbor,MI, 1990-1996 Registration Professional Engineer / Michigan Professional Traffic Operations Engineer (PTOE) Affiliations Expert Panel Member—FHWA Traffic Monitoring Guide Update Transportation Research Board (TRB) Institute of Transportation Engineers (ITE) Experience Project Manager/ Lead Developer for a variety of transportation engineering computer applications including over 160 projects related to the web-based Transportation Data Management Systems used by State Department of Transportations (DOTs),Metropolitan Planning Organizations (MPOs), County Road Agencies, and City Engineering Departments in 26 states, Canada and Africa. Recent Projects and Project References: Project: Cloud-based Statewide Traffic Count Database System Project Role: Project Manager Project Dates: Implemented 2008&on-going hosting services/support Contact: Mark Catchpole—Transportation Data Section Supervisor Arizona Department of Transportation 1324 N. 22nd Avenue, Phoenix,AZ 85009 (602) 712-8596 Project: Cloud-based Statewide Traffic Count Database System Project Role: Project Manager Project Dates: Implemented 2008&on-going hosting services/support Contact: William Mitchell—Transportation Program Planner Massachusetts Department of Transportation 10 Park Plaza, Suite 3170, Boston,MA 02116 (617) 719-9023 Amok Collier County RFP—13-5993 Traffic Count Software Packet Page-1201- 3/12/2013 16.A.10. wy. Ben Chen Recent Projects and Project References (Continued): (Continued) Project: Cloud-based Statewide Traffic Count Database System Project Role: Project Manager Project Dates: Implemented 2006 &on-going hosting services/support Contact: Rob Robinson—Data Management Unit Chief Illinois Department of Transportation 2300 S.Dirksen Parkway, Springfield, IL 62764 (217) 782-0378 Project: Cloud-based Regional Traffic Count Retrieval System Project Role: Project Manager Project Dates: Implemented 2008 &on-going hosting services/support Contact: Vladimir Livshits—Systems Analysis Program Manager Maricopa Association of Governments 302 North 1St Avenue,Phoenix,AZ 85003 (602) 254-6300 Project: ITS Vehicle Detection Data Analysis and Management System Project Role: Project Manager Project Dates: Implemented 2008 &on-going hosting services/support Contact: Gary Piotrowicz—Deputy Managing Director Road Commission for Oakland County 2420 Pontiac Lake Road,Waterford,MI 48328 (248) 407-6882 Project: Updated Regional Transportation Monitoring&Information System Project Role: Project Manager Project Dates: Implemented 2009 &on-going hosting services/support Contact: Javier Minjares—Regional Planning Specialist Southern California Association of Governments 818 W. Seventh St., 12th Floor,Los Angeles, CA 90017 (213) 236-1893 Project: Cloud-based Regional GIS for Transportation—Phase II Project Role: Project Manager Project Dates: Implemented 2009 &on-going hosting services/support Contact: Vladimir Livshits—System Analysis Project Manager Maricopa Association of Governments 302 North 1St Avenue,Phoenix,AZ 85003 (602) 452-5079 Project: Cloud-based Regional Screenline Traffic Count Database System Project Role: Project Manager Project Dates: Implemented 2004&on-going hosting services/support Contact: Tom Bruff—Transportation Manager Southeast Michigan Council of Governments 535 Griswold Street, Suite 300,Detroit,MI 48226 (313) 961-4266 Collier County RFP—13-5993 Traffic Count Software Packet Page-1202- 3/12/2013 16.A.10. William J. Tomiko — Senior Software Engineer (GIS / User Support) Professional Over 10 years experience in developing and implementing geographic and Qualifications management information systems for public and private sector clients. Education B.S. / Computer Science / Michigan Technological University,Houghton,MI Career History MS2/Midwestern Consulting since 2002 The Gale Group,Farmington Hills,MI, 1999-2000 System Administration Services,work study program, Houghton,MI, 1998-2002 Experience Extensive GIS knowledge including ArcGIS(Arclnfo),ArcIMS,ArcGIS Server, and Network Analyst applications utilized by more than 140 agencies in 22 states and Canada Experienced in multiple operating systems,programming languages, and database platforms,including: UNIX,Linux,Windows, C, C++, C Builder, OpenGL,Java,Xlib,Lisp, CLOS, Prolog, CLIPS,Pascal,Visual Basic,HTML,ASP,ASP.NET,VBScript, JavaScript,Solaris Assembly, POVRay, Microsoft Access, SQL Server System Development—developed a variety of engineering applications,widely used throughout North America,including: Traffic Crash Location System– 10+ million crashes in 10 states Traffic Count Database System–250,000+ locations for 100+ agencies Traffic Signal Management System (TSMS) –10,000+ signals Travel Time Database System–2,000+ miles of major corridors GIS Analysis—developed innovative geocoding algorithms to geocode GPS data,intersections, and links to GIS and Google Map applications. Recent Projects and Project References: Project: Cloud-based Statewide Traffic Count Database System Project Role: User Support& GIS Map Services Project Dates: Implemented 2008 &on-going hosting services/support Contact: Mark Catchpole–Transportation Data Section Supervisor Arizona Department of Transportation 1324 N. 22nd Avenue,Phoenix,AZ 85009 (602) 712-8596 Project: Cloud-based Statewide Traffic Count Database System Project Role: User Support& GIS Map Services Project Dates: Implemented 2008 &on-going hosting services/support Contact: William Mitchell–Transportation Program Planner Massachusetts Department of Transportation 10 Park Plaza, Suite 3170,Boston,MA 02116 (617) 719-9023 Collier County RFP—13-5993 Traffic Count Software Packet Page-1203- 3/12/2013 16.A.10. ihoWilliam Tomiko Recent Projects and Project References (Continued): (Continued) Project: Cloud-based Statewide Traffic Count Database System Project Role: User Support& GIS Map Services Project Dates: Implemented 2006 & on-going hosting services/support Contact: Rob Robinson—Data Management Unit Chief Illinois Department of Transportation 2300 S.Dirksen Parkway, Springfield, IL 62764 (217) 782-0378 Project: Cloud-based Regional Traffic Count Retrieval System Project Role: User Support& GIS Map Services Project Dates: Implemented 2008 &on-going hosting services/support Contact: Vladimir Livshits —Systems Analysis Program Manager Maricopa Association of Governments 302 North 1st Avenue, Phoenix,AZ 85003 (602) 254-6300 Project: ITS Vehicle Detection Data Analysis and Management System Project Role: User Support& GIS Map Services Project Dates: Implemented 2008 & on-going hosting services/support Contact: Gary Piotrowicz—Traffic Safety Department Director Road Commission for Oakland County 2420 Pontiac Lake Road,Waterford, MI 48328 (248) 407-6882 Project: Updated Regional Transportation Monitoring& Information System Project Role: User Support&GIS Map Services Project Dates: Implemented 2009 &on-going hosting services/support Contact: Javier Minjares—Regional Planning Specialist Southern California Association of Governments 818 W. Seventh St., 12th Floor,Los Angeles, CA 90017 (213) 236-1893 Project: Cloud-based Regional GIS for Transportation—Phase II Project Role: User Support&GIS Map Services Project Dates: Implemented 2009 &on-going hosting services/support Contact: Vladimir Livshits—System Analysis Project Manager Maricopa Association of Governments 302 North 1st Avenue, Phoenix,AZ 85003 (602) 452-5079 Project: Cloud-based Regional Screenline Traffic Count Database System Project Role: User Support&GIS Map Services Project Dates: Implemented 2004&on-going hosting services/support Contact: Tom Bruff—Transportation Manager Southeast Michigan Council of Governments 535 Griswold Street, Suite 300,Detroit,MI 48226 (313) 961-4266 Collier County RFP—13-5993 Traffic Count Software Packet Page-1204- 3/12/2013 16.A.10. 0.:Apo Steven M. Willaert — Senior Software Engineer (Web Application) Professional Over 10 years experience providing custom client-server software solutions and Qualifications technical support to clients in a wide variety of industries Education M.B.A. /Accounting/ University of Michigan,Ann Arbor,MI B.S. / Computer Science / Eastern Michigan University,Ypsilanti,MI B.A. / Economics and Political Science /Adrian College,Adrian,MI Career History MS2/Midwestern Consulting since 2008, also 1994-1998 Tectura Corp.,Ann Arbor,MI,2000-2007 Advantage Computing Systems, Inc.,Ann Arbor,MI, 1998-2000 S.S.A., Inc.,Ann Arbor,MI, 1991-1994 M.D.J. Ventures,Ann Arbor,MI, 1989-1991 Experience Experienced with HTML, Unix, Oracle,Microsoft SQL Server,Visual Basic, ASP,ASP.NET, and JavaScript,including Google Maps and ArcGIS Server JavaScript APIs. System Development—developed system web application features for a variety of TMS currently utilized by over 140 agencies in 22 states and Canada and has been largely involved in the development and on-going support of the following TMS modules: - TIP/RTP Project Management Database System - Performance Measures (Dashboard) - Traffic Crash Location System Software Engineer—provided database management support for the publishing industry,including producing custom reports, designing custom data entry and query processes, and overseeing product installation Recent Projects and Project References: Project: Cloud-based Statewide Traffic Count Database System Project Role: Web Application Development Project Dates: Implemented 2008 & on-going hosting services/support Contact: Mark Catchpole–Transportation Data Section Supervisor Arizona Depaitment of Transportation 1324 N. 22nd Avenue, Phoenix,AZ 85009 (602) 712-8596 Project: Cloud-based Statewide Traffic Count Database System Project Role: Web Application Development Project Dates: Implemented 2008& on-going hosting services/support Contact: William Mitchell–Transportation Program Planner Massachusetts Department of Transportation 10 Park Plaza, Suite 3170,Boston,MA 02116 Aerlik (617) 719-9023 Collier County RFP—13-5993 Traffic Count Software Packet Page-1205- 3/12/2013 16.A.10. oo Steve Willaert Recent Projects and Project References (Continued): (Continued) Project: Web-based Statewide"Short Count"Traffic Count Database System Project Role: Web Application Development Project Dates: Implemented 2006 &on-going hosting services/support Contact: Rob Robinson—Data Management Unit Chief Illinois Department of Transportation 2300 S. Dirksen Parkway,Springfield, IL 62764 (217) 782-0378 Project: Cloud-based Regional Traffic Count Retrieval System Project Role: Web Application Development Project Dates: Implemented 2008&on-going hosting services/support Contact: Vladimir Livshits—Systems Analysis Program Manager Maricopa Association of Governments 302 North 1"Avenue, Phoenix,AZ 85003 (602) 254-6300 Project: ITS Vehicle Detection Data Analysis and Management System Project Role: Web Application Development Project Dates: Implemented 2008&on-going hosting services/support Contact: Gary Piotrowicz—Traffic Safety Department Director Road Commission for Oakland County 2420 Pontiac Lake Road,Waterford,MI 48328 (248) 407-6882 Project: Updated Regional Transportation Monitoring&Information System Project Role: Web Application Development Project Dates: Implemented 2009 &on-going hosting services/support Contact: Javier Minjares—Regional Planning Specialist Southern California Association of Governments 818 W. Seventh St., 12`'' Floor,Los Angeles, CA 90017 (213) 236-1893 Project: Cloud-based Regional GIS for Transportation—Phase II Project Role: Web Application Development Project Dates: Implemented 2009 &on-going hosting services/support Contact: Vladimir Livshits—System Analysis Project Manager Maricopa Association of Governments 302 North 1St Avenue,Phoenix,AZ 85003 (602) 452-5079 Collier County RFP—13-5993 Traffic Count Software Packet Page-1206- r4 ^/ 3/12/2013 16.A.10. ifb nti' Brian E. Rodgers — Software Engineer (Web Application) Professional Seven years experience in Information Technology and Information System Qualifications solutions for public and private sector clients in web-based application development Experienced in multiple programming languages and database platforms, including: Windows,ASP.NET,XML, HTML,JavaScript,VBScript, VB, C, C++,Microsoft Excel,Microsoft Access,Microsoft SQL Server, Google Maps API,and ArcGIS Server Javascript API Computer skills include hardware and software troubleshooting Education BS, Computer Science / Michigan Technological University / Houghton,MI Career History MS2 / Midwestern Consulting since 2005 Abrams Aerial Surveying,Lansing,MI,2001-2002 Ingham County Road Commission,Mason,MI, 2000 Experience Web-Based Application Services • Developed and enhanced data processing routines for multiple existing and custom file formats for Traffic Count Database System • Implemented Google Maps interaction with ArcGIS Server and Dynamic Map Services • Developed tools for enhancing Google Maps functionality including selection, and search tools as well as tools to interact with the ArcGIS Dynamic Map Services • Created processes to automatically retrieve information from client locations and updated MS2 modules to reflect this information • Developed system development applications for tracking and maintaining project scheduling and progress as well as equipment location • Developed features for several MS2 modules including: Traffic Count Database System Traffic Crash Location System Traffic Signal Managements System Traffic Count Location System Travel Time Database System Project Management Database System Collier County RFP—13-5993 Traffic Count Software Packet Page-1207- 3/12/2013 16.A.10. 39 Charles Huber — Software Engineer (Web Application) Professional Develops and implements geographic and management information Qualifications systems for public and private sector clients. Over 10 years experience providing custom client-server software solutions and technical support to clients in a wide variety of industries. Proficient in ASP.NET, ColdFusion, SQL Server,JavaScript Education BA / General Studies / University of Michigan,Dearborn,MI Associate Degree / Computer Science / Northwestern Michigan College,Traverse City,MI Associate Degree / General Arts and Science / Northwestern Michigan College,Traverse City,MI Career History MS2 / Midwestern Consulting, 2002-present Rogue River Mortgage,Ann Arbor,MI,2002 Cherryland Online,Traverse City,MI 2000-2001 Experience Web Development—developed Work Order Tracking System that provides users with an efficient system to administer all aspects of the work order process from initial creation to final close out including location of work order on an interactive map. Developed user interface for the Routing Optimization System,which uses ArcGIS to find the best route between user specified points on a map,using ASP.NET,JavaScript,ESRI API's and Google API's. Developed Midwestern Consulting Intranet using ColdFusion, SQL, XML,JavaScript,and PhotoShop; developed complex"sandbox" style security in ColdFusion; developed powerful client and project report generator allowing central database searches; developed variety of web applications;introduced and implemented"Fusebox" methodology of web development;maintained client FTP access and remote administration of web servers. Network Administration—monitored server logs and HP ProCurve switch traffic, set up new Windows users/systems,rebuilt/reallocated Windows systems, desktop support to 80+ users,daily backup using Norton Backup Exec Collier County RFP—13-5993 Traffic Count Software Packet Page-1208- 3/12/2013 16.A.10. David J. Bow — System Administrator Professional Over 25 years of IT experience with client,data,and server solutions; 15 Qualifications years supporting multiple systems. Responsible for CAD system implementation,training,and technical support to staff and other corporate clients. Technical liaison between company departments, project managers, and engineers. Over 20 years of experience with relational database systems. Education Computer Information Systems / Oakland Community College Information Technologies / Schoolcraft College Information Technologies and Project Management /Lawrence Tech Business Administration / Oakland Community College Career History MS2 / Midwestern Consulting since 1993 Design Engineers,Brighton,MI, 1991-1993 McNamee,Porter and Sealy,Ann Arbor,MI, 1990-1991 Lynn Medical Instrument Company,Bloomfield Hills,MI, 1980-1990 Experience Responsible for providing overall network infrastructure, data, and system solutions. Manages IT department to ensure optimum solutions to all IT requirements. Provides CAD and desktop support to in-house staff and other clients. Experience includes: • Works with and maintains Windows NT through Windows 2008 Server systems,including 64bit environments • Responsible for upkeep and maintenance of multiple SQL Servers • Develops corporate information systems • Maintains multiple SAN Systems for storage and archive of historical data, system backups, and system replication • Maintains multiple WEB Servers for internal use and client projects. Software and systems include IIS,Apache,Wordpress, PHP, .Net, and others • Familiar with the most current replication and failover systems and technologies including block level replication and Automatic DNS failover solutions Collier County RFP—13-5993 Traffic Count Software Packet Page-1209-