HomeMy WebLinkAboutContract3815 Plaza Drive
Ann Arbor, Michigan 48108
734.995.0200 Fax 734.995-0599
www.ms2soft.com
Page 1
City of Renton, Washington
Cloud-based Traffic Crash Analysis and Reporting System
(February 21, 2014)
MS2 is pleased to submit this proposal to the City of Renton for providing Software as a
Service (SaaS) to host and maintain a cloud-based Traffic Crash Analysis and
Reporting System (CARS). The primary goal is to provide better and more complete
information to the city departments. Providing this information allows the city staff to:
Assess crash causes
Direct enforcement or safety patrol activities
Plan appropriate roadway, lighting, signal, signage or pavement
improvements to mitigate problems
Avoid the costs and damages of fault litigation, and
Improve the overall quality of life in the city by reducing injuries and fatalities.
This initiative is an extension of the work the city staff has been doing. Its focus is to
implement an innovative solution, using a proven, web-based platform, which
accomplishes the following:
Integrates crash data from the Washington State Department of
Transportation (WSDOT) crash reporting system or the city police
department, including crash details and scanned police reports
Affords all authorized users a web-based system that provides them the
ability to query and analyze the unified data for intersections, segments,
corridors or community statistics
Links crash records to geographic locations for the purpose of mapping
crashes and relating crashes to a variety of other information sources
through a geographic information system (GIS), and
Provides a data portal that is secure, accessible, and scalable.
Background
City of Renton is an eastside edge city in King County, Washington. Situated 11 miles
southeast of Seattle, Washington, Renton straddles the southeast shore of Lake
Washington. The city is a center of manufacturing and technology companies, such as
Boeing, Paccar, and several dot-com companies. The City of Renton's population was
90,927 as of April 1, 2010 United States Census. Renton currently contains the 9th
largest population in the state, and 4th largest in King County. There are approximately
460 lane miles in the city and averaging 1,200 crashes per year. Currently, the city
does not have a system that meets all the functional and technical requirements set out
in this document. The proposed software must have the ability to import information
from the Washington State Department of Transportation’s existing crash reporting
system or city police department’s database.
CAG-22-017
3815 Plaza Drive
Ann Arbor, Michigan 48108
734.995.0200 Fax 734.995-0599
www.ms2soft.com
Page 2
System Specifications
The software proposed is a fully developed and implemented product. The main
features are summarized as follows:
System Features
1. Delivered via Software as a Service (hosted and maintained by MS2)
2. Allow unlimited number of users
3. Provide unlimited data storage
4. Dashboard for crash statistics summary
5. Manage study locations (intersections and segments)
6. Manage traffic crash data (all attributes from the state crash form)
7. Manage scanned police reports
8. Automatic data import routine for monthly traffic crash data update
9. Allow ad-hoc queries for study locations and crash data
10. Allow a user to export selected study location and crash data to MS Excel file
11. Integrated map interface using both ArcGIS Server and Google Maps
12. Allow display of relevant GIS layers from the city
13. Traffic crash density heat map for a specific year
14. Allow search of study location and crash data through the map interface
15. Highlight study locations and crash data points on the map based on
database search result
3815 Plaza Drive
Ann Arbor, Michigan 48108
734.995.0200 Fax 734.995-0599
www.ms2soft.com
Page 3
16. Interactive intersection collision diagram based on user-defined criteria
17. Study location ranking reports (e.g. crash frequency, severity and rate) based
on use-defined searching criteria
18. Integration with traffic count data management for crash rate analysis
19. Allow a user to customize and save searching criteria and reports
20. Allow the city system administrator to manage user accounts
Software License Agreement
The software license agreement of the cloud-based Transportation Data Management
System is attached.
System Implementation Plan
MS2 will implement the system based on the existing and proven software platform of
the cloud-based Transportation Data Management System (TMS) developed by MS2.
MS2 has put more than a decade of in-depth software development and testing ʊ
including over 500,000 lines of software code ʊ into the TMS products. The result is
stable, reliable, and interactive cloud-based software available for customizations at a
fraction of the cost that would be required for developing a similar system. A general
system implementation plan is as follows:
TASK 1 – TCLS LICENSE AND SETUP
MS2 staff will conduct a kickoff meeting via WebEx with the agency staff and any
stakeholders to complete a full assessment of the agency’s needs. The meeting will
include the following:
x Introduce key staff members from MS2 and the agency and describe their roles
x Document the full extent of data types and needs to incorporate into the program
including GIS layers
x Document the variety/type of anticipated program users
x Identify and document the anticipated customizations that will be required
During or shortly after the meeting, existing databases, GIS layers, and documentations
will be collected from the agency.
3815 Plaza Drive
Ann Arbor, Michigan 48108
734.995.0200 Fax 734.995-0599
www.ms2soft.com
Page 4
MS2 will activate a standard TCLS on MS2’s secure server for access by the agency.
Once activated, the agency staff can begin to use and become familiar with the system
through their current web browsers.
Deliverable: Fully functional TCLS
TASK 2 – ANNUAL SUPPORT
MS2 will be supporting the cloud-based TCLS as follows:
x Perform system maintenance as necessary
x Perform nightly backup of the system and store copies of the monthly backup
offsite as part of MS2’s data warehousing procedures
x Implement system enhancements when available
x Provide technical support to the agency and stakeholder users as requested
TASK 3 – DATA MIGRATION
Upon the setup of the standard TCLS, MS2 will perform data migration to import all
relevant data into the system, including:
x Raw crash data
x Exiting intersection list
x Existing road segment list
x GIS layers
Deliverable: TCLS loaded with all required historic data
TASK 4 – SYSTEM CUSTOMIZATION
MS2 staff will customize the standard TCLS to meet the complete needs of the agency
as discussed in the initial needs assessment meeting and any subsequent
communications.
Deliverable: Fully customized TCLS
TASK 5 – TRAINING WEBINARS
The best way to ensure success of the system is to make sure that the agency staff can
effectively use and manage the TCLS. Shortly following system implementation, a
series of two (2) training webinars will be conducted. As a combined
presentation/demonstration and hands-on question/answer session, the training will
enable staff to learn the use of the system in an efficient and effective manner.
Deliverable: Two (2) webinars
3815 Plaza Drive
Ann Arbor, Michigan 48108
734.995.0200 Fax 734.995-0599
www.ms2soft.com
Page 5
Cost Quote
The delivery of the software as a service will be no later than sixty (60) days after the
city issues the purchase order. Overall cost is detailed as follow:
ITEM QUANTITY UNIT PRICE AMOUNT
TCLS (Traffic Crash) License and Setup
(Unlimited number of users)1 $ 15,000 $ 15,000
Annual Support & Data Update
- System hosting and support
- Import data from WSDOT or other sources
- Update data monthly
- Geocode crash data
- See above System Implementation Plan for
details.
(cost valid for 5 years and subject to annual
cost-of-living-adjustment)
1 $ 4,500 / Year $ 4,500
Historic Data Migration
- Import existing data
- Geocode crash data
9 Years $ 600 / Year $ 5,400
TOTAL AMOUNT $24,900
Very Truly Yours,
___________________________
Ben Chen, PE, PTOE
Principal
bc@ms2soft.com
Transportation Data Management System
Software License Agreement
120211
Midwestern Software Solutions (MS2) provides its Software and services
to its customers based upon the terms and conditions herein. By ordering
the Software and services, you (Licensee) indicate your acceptance of the
terms of this License Agreement:
1. DEFINITIONS
(a) “Software” means the Transportation Data Management System
(TMS) Software and includes any upgrades and additional modules
provided by MS2.
(b) “Documentation” means any materials and documentation provided by
MS2 to describe the features and operation of the Software.
2. LICENSE GRANT. Subject to the terms and conditions of this
Agreement, MS2 grants to Licensee a non-exclusive license to use the
Software.
3. SINGLE AGENCY USE. Licensee may use the Software only for the
purposes of its own agency and may not use the Software to store or
process data for another agency without first obtaining a separate license
for such use.
4. OWNERSHIP. The Software and associated documentation are being
licensed, not sold, to Licensee. MS2 owns all rights, title, and interest in
and to the Software and associated documentation, including copyrights,
patents and other intellectual property rights. Thus, Licensee may not
copy, distribute, modify, or use the Software and associated
documentation, or any portion thereof, other than what is expressly
authorized by this Agreement. The data stored in the Software is the
property of the licensee. MS2 may not use, sell or share the data without
the licensee’s express written consent. These provisions shall not apply if
MS2 is required by law to share the data or ordered to produce the data
by a court or other legal entity having the legal jurisdiction. MS2 may also
share the data if the disclosure is reasonably necessary to defend itself
from any legal action or claim. The data shall be delivered to the licensee
upon demand or termination of this agreement.
5. NO REVERSE ENGINEERING. Licensee may not cause or permit the
Software to be reverse engineered, decompiled, or disassembled, except
to the extent that applicable law permits such activity notwithstanding
contrary contractual obligations.
6. GOVERNMENT - RESTRICTED RIGHTS. The Software and
associated documentation are provided with RESTRICTED RIGHTS.
Use, duplication, or disclosure by the Government is subject to restrictions
as set forth in DFARS 252.227-7013 (c)(1)(ii) or FAR 52.227-19, as
applicable. Manufacturer is Midwestern Software Solutions, LLC., 3815
Plaza Drive, Ann Arbor, Michigan 48108.
7. WARRANTIES. Licensee acknowledges that (a) the operation of the
Software may not be uninterrupted or error-free; and (b) the functions of
the Software may not meet Licensee’s requirements. MS2 warrants that
the Software will function substantially in accordance with the
Documentation for a period of which the support fee is paid. MS2
disclaims any and all other warranties as to the Software, including any
implied warranties of merchantability and fitness for a particular purpose
of use.
8. EXCLUSIVE REMEDIES. Licensee’s exclusive remedies for any
claims against MS2 arising out of this Agreement will be limited to the
following, at the option of MS2: (a) replacement by MS2 of the Software
with software which functions substantially in accordance with the
Documentation; (b) repair by MS2 of the Software, by patch or
workaround, so that it functions substantially in accordance with the
Documentation; or (c) refund by MS2 of the funds paid by Licensee and
received by MS2 with respect to the Software and services.
9. LIMITATION OF LIABILITY.
(a) Limited Liability of MS2. MS2's liability in connection with the
Software, any services, any license granted under this Agreement, or any
other matter relating to this Agreement will not exceed the fee that
licensee actually paid to MS2 for the Software or services giving rise to
the liability.
(b) Exclusion of Damages. Regardless of whether any remedy set forth in
this Agreement fails its essential purpose or otherwise, in no event will
MS2 be liable to licensee for any special, incidental, or consequential
damages—including, but not limited to, loss of data, loss of revenue or
profits, failure to realize savings, personal injury, property damage, or
commercial loss—whether based on breach of contract, tort (including
negligence), product liability, or otherwise, and whether or not MS2 has
been advised of the possibility of such damage.
(c) Special Exclusions. The Software is intended to be used as a
supplement for normal office procedures and is not intended to be a
substitute for good professional interpretation, analysis, and judgment.
MS2 assumes no liability for any type of damage or injury resulting from
use of the Software or from conclusions drawn on information obtained
using the Software. Use of the Software and reliance on data obtained
using the Software is entirely at the user's risk.
(d) Basis of the bargain. Licensee acknowledge that MS2 has set its fees
and entered into this Agreement in reliance upon the limitations of liability
and the disclaimers of warranties and damages set forth in this
Agreement, and that those limitations and disclaimers form an essential
basis of the bargain between the parties.
10. TERMINATION.
(a) Termination. This Agreement will take effect upon acceptance by MS2
and will continue in effect as long as the annual support fee is paid. Either
party has the right to terminate this Agreement. To terminate this
Agreement, the party seeking termination must give the other party written
notice thirty (30) days before the termination. In the event that Licensee
fails to comply with any of the provisions of this Agreement, this
Agreement will automatically terminate without notice.
(b) Effect of Termination. Upon termination of this Agreement for any
reason, Licensee will discontinue further use of the Software, will promptly
return to MS2 or, at MS2' request, will destroy all copies of the Software,
and will certify to MS2 in writing that Licensee has done so. MS2 will
provide the Licensee with a copy of the Licensee’s data stored in the
Software at the time of termination.
(c) Survival Of Obligations. The provisions of Sections 5 and 9 shall
survive termination of this Agreement.
(d) Termination Is Without Prejudice. Termination of this Agreement will
be without prejudice to the terminating party’s other rights and remedies
pursuant to this Agreement.
11. RENTAL. Licensee may not rent, lease, or lend the Software or any
portion thereof.
12. ASSIGNMENT. Licensee may not assign or otherwise transfer any of
its rights or obligations under this Agreement and the Software may not be
transferred to or used by any other person or entity for any reason
whatsoever.
13. SEVERANCE CLAUSE. If any provision of this Agreement is illegal
or unenforceable, it will be deemed stricken from the Agreement and the
remaining provisions of the Agreement will remain in full force and effect.
14. ENTIRE AGREEMENT. This Agreement contains the entire
understanding of the parties with respect to its subject matter, and
supersedes and extinguishes all prior oral and written communications
between the parties about its subject matter, including any prior or
subsequent purchase order terms that are contrary or inconsistent with
the terms and conditions of this Agreement. No modification of this
Agreement will be effective unless it is in writing, is signed by each party,
and expressly provides that it amends this Agreement.
15. GOVERNING LAW. This Agreement will be governed by and
construed under the laws of the State of Michigan, without resort to its
conflict of laws principles.