ES15-0121F
Item Requirement
Response (Yes/No)
1.1
Is the proposal form signed and sealed per RFP requirements? The proposal shall include a cover sheet that includes the complete name, address and phone number of the Company and the name, title and phone number of the key person to contact for questions and evaluation of the RFP.
1.2
Please respond Yes/No and indicate in the comments field if the proponent is the manufacturer of the product. If the proponent is not the manufacturer, the proponent must:
a. be a distributor or authorized reseller for the proposed software or products prior to the RFP Closing Deadline and, upon request, provide written confirmation to the City of such authorization from the Manufacturer.
b. upon request, provide written confirmation to the City from the Manufacturer that all rights granted in relation to the proposed Software or products are agreed to by the Manufacturer.
1.3
Please include a profile providing background information on the company. This information may include: ● Company overview, history, core competencies, mission, values, etc.
● Company strategic direction and commitment to the product and technology. ● Financial stability.
● Organization’s experience in providing asset management and capital planning solutions and services.
N/A
1.4
Proponents must supply at least one reference of existing customer projects that are similar to the scope of requirements specified in this RFP. The referenced information must include the following information:
● A description of the product and services provided. ● The start and end date of the installation.
● Contact name, title, address, telephone number and email address for the person directly responsible for the project.
N/A
1.5 Please describe why you believe that your Product is the best fit for the City for the provision of the products and services outlined in this
RFP, what key strengths they will bring to the City of Tacoma, and why the City should award this Agreement to them.
N/A
General Requirements 2.1
Is the application built as an add-on/extension for ESRI ArcGIS 10.x and is it fully utilized within ArcGIS (Basic, Standard or Advanced)? If yes, please describe how this is accomplished within the proposed application. If no, please describe how the application will interact with ESRI data and allow the direct display of data within the native software.
2.2
Does this application include an ArcGIS license and/or will this application work with ArcGis Floating licenses? If so which version and type of license is included.
2.3 Is the application vendor neutral (except for ESRI)?
2.4 Will the software require current or future updates to ESRI ArcGIS 10.x to continue use (will the software be backwards compatible with current versions of ESRI 10.x)? Describe software design in relation to updates of ESRI products.
2.5 Is the application an open system design with access to all background data? For example, can we connect our ArcServer to look at the output from the software program? Describe how data is accessed and note any data that is only accessible from within the software or through 3rd party software or services.
2.6
Will the software utilize the City's existing GIS database(ESRI based) as its asset inventory? Describe how the software connects to ESRI based asset inventory data. If no, provide explanation in the comments field how you would propose to meet this requirement.
Data Capture
2.7 Is the software able to load PACP compliant inspection data (Video/inspection reports/inspection codes) from CUES' Granite XP? Granite data is stored in an Oracle database on the City network. Please describe.
2.8 Is the software able to load PACP compliant inspection data (Video/inspection reports/inspection codes) from RedZone ICOM3? Please note that RedZone's data is externally hosted. It is not stored in the City network. Please describe.
2.9 Is the software able to load Non-PACP compliant inspection data (Video/inspection reports/inspection codes) from other sources? (SQL data, MPEG2 video) Please describe the flexibility of the software to accommodate different types of data.
2.10 Does the application have the ability to consume web services (REST, SOAP)? If yes, describe.
2.11 SAP is the City's ERP system. Does your organization have experience working with SAP? If yes, describe. Data Management
2.12
Does the application support the automation of data Quality Control processing (e.g., quality marking of data on load/import)? If yes, provide an overview of how the proposed application automates data quality marking.
Data Editing
2.13 Does the proposed application support multiple import/export formats? If yes, please describe the available import/export formats. If no, please describe how you would propose to meet this requirement.
Section 2 - Technical Specifications (55%) City of Tacoma
Linear Asset Management Software
Comments
Section 1 - Vendor Qualifications (10%)
Appendix C - Technical Specifications 2 of 3 3/6/2015 ES15-0121F Item Requirement Response (Yes/No) City of Tacoma
Linear Asset Management Software
Comments Instructions - For each question, please respond yes or no in the "Response (Yes/No)" column unless the column is marked "N/A". Please add additional details in the "Comments" column.
Data Source Management
2.15 Does the application provide API's? If yes, please list each additional import and export format and how each is accomplished within the proposed application.
2.16
Does the software support MSSQL Server 2008 or newer? Provide all compatibility information in relation to MSSQL Server.
2.17 Does the software interface directly with ESRI SDE geodatabase? If yes, please describe the approach. If no, please describe how you
would propose to meet this requirement and if it can be done.
Map Integration
2.18 Does the application support the integration of information with GIS to display data on a map layer? If yes, please describe the approach used to incorporate map images (or other theme layers) into the application and how data is displayed. If no, please describe how you would propose to meet this requirement if it can be done.
Data Analysis
2.19 Does the application visualize PACP codes on a GIS Layer or as a separate layer with GIS? (ESRI based layer files)
2.20 Does the software have the ability to project a 3D Pipe model and display visible defects (PACP Codes)? Describe 3D projection capability and include if it has the ability to zoom, pan, rotate.
2.21 Does the software allow end users to establish rehabilitation requirements based on PACP codes and then apply these rehabilitation requirements to the data? If multiple rehabiliations are close to each other, is the software able to combine these rehabilitations (e.g., two spot repairs close to each other would be combined into one spot repair, more than four spot repairs on one pipe would require replacement of the whole pipe)?
2.22 Does the application display (view) GIS selected CCTV inspection video within the application?
2.23 Does the application have the ability to filter a list of assets or filter assets found in a geographic area? Describe how this is accomplished.
2.24 Does the application have asset management tools to calculate both likelihood(probability) and consequence of failure factors to assets to determine risk? Does the application allow the user to easily calculate consequence of failure from GIS layers based on distances from other layers(e.g., distance from railroad) or based on characteristics of the assets (e.g., depth of pipe)? If no, please indicate how you would propose to meet this requirement.
2.25 Does the application have a configurable risk matrix that allows the City to determine the importance of the consequence of failure and likelihood of failure scores in calculating risk? Describe risk matrix capabilities.
2.26
Does the application have a graphics user interface for drag and dropping decision options for Risk Analysis by Asset classes? For example, can the decision trees identify which assets should receive CCTV next, which assets should be reassessed in 5 years based on the PACP codes, or which pipes need immediate repair since they are high risk?
2.27 Does the application allow analysis of surface water assets separate from wastewater assets, utilizing different workflows/decision trees? Describe capabilities.
2.28 Does the application have the ability to run multiple analytical scenarios, including pipe failure statistical analysis with configurable variables (age, material, soil type, etc.)? Describe capabilities.
2.29
Does the application compare analytical scenarios against historical (saved) scenarios and identify any variance? Describe capabilities.
Reporting
2.30 The City of Tacoma has a requirement for both standard and custom reports. Does the proposed application have both standard and customizable reporting capabilities? If yes, please describe how this is done within the proposed application. If no, please indicate how you would propose to meet this requirement.
2.31 Does the application have the ability to identify and generate a 5,10, and 100 year Capital Improvement Plan list projection? Does the capital improvement planning component allow the user to estimate pipe replacement costs based on the pipe attributes (e.g., size, depth) or based on other GIS layers (e.g., surface restoration requirements). Describe the process, results, and customization possible within the application.
2.32 What types of functionality is available for doing ad-hoc reporting? Are third party tools such as Microsoft Reporting Services available to run against the data structure?
N/A 2.33 For the standard reporting features contained in the application, please list the standard reports delivered with the application. Please
include a brief description of each report, its information and usage. N/A
2.34 Does the application enable users to define report content, layout, and formats (fonts, trace symbols and colors) for customizable reports? If yes, please describe what user customizable elements are supported in the proposed application. If no, please indicate how you would propose to meet this requirement (e.g., report wizard).
2.35 Does the proposed application support the creation of a "favorites" directory approach to save custom reports that can be reused/shared by users? If yes, please describe how this is done within the proposed application. If no, please indicate how you would propose to meet this requirement.
2.36 Does the application accommodate publishing the report outputs to a website? If yes, are they dynamic reports using latest technologies (HTML5/CSS/JavaScript)? Please describe how this is done within the proposed application.
Non-Functional Requirements
2.37 Describe the technical architecture including client, database, server, application server and document storage. Make recommendations
where options are available. N/A
2.38 Please describe the application development environment for both the screen forms and the reports. N/A 2.39 Please describe the fail over and backup capabilities of the application. N/A 2.40 Describe the hardware platforms that are supported for both the client and server machines for this product. Describe minimum and
recommended amounts of disk, memory and processor for the client and server platforms. Where sizing is based on the size of the organization implementing the package (e.g., server, disk and processor).
ES15-0121F
Item Requirement
Response (Yes/No) City of Tacoma
Linear Asset Management Software
Comments Instructions - For each question, please respond yes or no in the "Response (Yes/No)" column unless the column is marked "N/A". Please add additional details in the "Comments" column.
2.41 Are there inherent limitations on the amount of data that can be stored within the database? (Database limitations related to the design of the database, # of records, record size, data types, field width limitations.)
2.42 Does the application support simultaneous multiuser access with appropriate record locking to insure data integrity through relational database? Describe multi-user data storage and manipulations.
2.43 Are there inherent limitations on the number of users accessing the same data concurrently?
2.44 Does the application ensure that data integrity (value checks, date logic checks, etc.) is maintained? Please explain.
2.45 Proponents provide/state delivery lead time of software and implementation services, after receipt of order. N/A
User Acceptance Testing
3.1 The City will perform User Acceptance Tests (UAT) after the product has been successfully installed, configured and tested by the Contractor and made available in the City’s Acceptance Test environment. During the UAT period, it is expected that any software malfunctions (“bugs”) reported by the City will be corrected by the Contractor as soon as possible such that the application downtime is limited to no more than 4 hours per incident during the test period.
Please describe your approach to participation during UAT, to providing support during the User Acceptance Test period, and compliance to the requirements described above.
N/A
Training
3.2 The City of Tacoma will require training for users, system administrators and IT staff. Currently, we estimate 10 staff. Please provide your approach to training for the City. This approach should include the following:
● Training schedule ● Training content ● Audience
● Method (e.g., classroom, hands-on, web-based)
N/A
Documentation
3.3 Please describe the documentation that is provided with the package. Does it include operational procedures, detailed user manuals
and/or data and process models? Is this documentation provided in paper form, on-line help and/or CD-ROM? N/A
Warranty
3.4 Warranty period begins after the software and any acquired hardware has been accepted in writing by the City after successful completion of user acceptance testing. The Proponent must provide 90days of warranty on the software installation and configuration (including any customization), and any hardware purchased under this RFP. Any malfunction or defect reported by the City during the warranty period must be corrected by the Proponent within the service levels specified in the Maintenance and Support Agreement signed with the City at no additional cost to the City. Please state your agreement with the above warranty requirements and provide your approach to warranty support.
N/A
Maintenance and Technical Support 3.5
Please describe the support that is provided by your company. Specify the service levels of support provided (support availability and timeframes). This should include but is not restricted to ongoing support, support availability, turnaround timeframes and remote support. Is there a hotline? What are the hours of availability? Detail the costs associated with the various levels of support.
N/A
3.6 Does the proponent have standard license and maintenance agreements? Please respond with yes or no and provide copies of the standard licensing support agreements/contracts.
3.7 Please describe in detail the process by which support is initiated, escalated and resolved. Details should include initial response time,
escalation process and times in the event initial service was unable to resolve the problem, and recovery options the Proponent is willing to engage in the event a problem cannot be resolved in a timely or satisfactory manner. Provide any supplementary documentation.
N/A
3.8 Does your company provide toll-free technical support via phone, fax, or e-mail? Provide details on technical support.
3.9 Please describe the on-going City roles and required skill sets as well as staffing levels to maintain and support the system. N/A Release Strategy
3.10 Please provide a detailed description of the application release strategy. Please include the release schedule (annually, every 6 months, other timing). Explain how you handle new releases where portions of the system have been customized or user configured. Indicate how the City can provide input into future product releases.
N/A
SPECIFICATION NO. ES15-0121F
LINEAR ASSET MANAGEMENT SOFTWARE