SDDOT_HNAR_25RFP12707_Requirements.xlsx
XLSX spreadsheet 18 KB Posted
- Attached to
- Highway Needs and Analysis Report Tool
- Solicitation number
- 25RFP12707
- Issued by
- Harding County, South Dakota
About this file
This is a requirements checklist document from the South Dakota Department of Transportation (SDDOT) for an Internet-based Highway Needs and Analysis Report (Needs Book) Software system. The software must be accessible via any Internet browser with LDAP credential-based access restrictions, featuring GIS integration capabilities, map displays with corresponding tabular data, and the ability to generate PDF reports. The system must be fully operational for the SDDOT Pavement Management annual data reporting and analysis period beginning April 1, 2026. The project includes software implementation, maintenance, technical support, and training requirements, with specific deliverables including test plans, training manuals, and user documentation.
The vendor must provide detailed hosting options and technical support plans, including software maintenance and upgrades. The system must integrate with South Dakota's standard identity management service single sign-on (SSO) using OAuth 2.0 protocol and support multi-factor authentication. Integration requirements include compatibility with Microsoft Power BI, ESRI, Tableau, and other platforms, along with the ability to connect to dTims pavement management data and other GIS data services. The document does not specify pricing terms or funding requirements, but notes that travel expenses for training will be reimbursed at actual costs.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFP Document.pdf | ||
| Response to Offeror Questions document.pdf | ||
| SDDOT_HNAR_25RFP12707_NeedsBookSample.pdf | ||
| SDDOT_HNAR_25RFP12707_Requirements.xlsx | XLSX spreadsheet | |
| SDDOT_HNAR_25RFP12707_Costs.xlsx | XLSX spreadsheet | |
| SDDOT_HNAR_25RFP12707_Vendor_Questions.docx | DOCX document | |
| SDDOT_HNAR_25RFP12707_Data_specifications.xlsx | XLSX spreadsheet | |
| RFP Document.pdf | ||
| SDDOT_HNAR_25RFP12707_NeedsBookSample.pdf | ||
| SDDOT_HNAR_25RFP12707_Costs.xlsx | XLSX spreadsheet | |
| SDDOT_HNAR_25RFP12707_Data_specifications.xlsx | XLSX spreadsheet | |
| SDDOT_HNAR_25RFP12707_Vendor_Questions.docx | DOCX document |
Show all 12
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Requirement Checklist
| How to use this document | ||
| How to use this document | ||
| Use this list to indicate whether your firm can meet the requirements. This does not replace the narrative portion of the RFP. It is intended to be a quick checklist. Comments are optional and should be brief. Detailed responses should be part of the narrative. | ||
| Requirement | Vendor response (Yes , No, Optional, N/A) | Comments/Notes |
| 3.1. System Features & Functionalities |
SDDOT needs the Highway Needs and Analysis Report (Needs Book) Software to be an Internet-based system, accessible from any Internet browser, but configurable with access restrictions based on State of South Dakota LDAP credentials.
The Offeror will be required to provide a solution necessary to meet all system functions and requirements described in this RFP and the resulting contract, to include at a minimum:
| 3.1.1. Software |
| 3.1.2. Full implementation of system based on required features and functionalities. |
| 3.1.3. Maintenance and update of system as time and operating system requirements arise. |
| 3.1.4. Technical support for issues that may occur during the operation of the software |
| 3.1.5. Training for start-up, maintenance, and use of the system |
| 3.2. SDDOT has identified the following system features and functionalities required to deliver a fully functional Needs Book. The Offeror will, at a minimum, configure the Needs Book Software to: |
| 3.2.1. Connect and maintain connections to the GIS feature service for the dTims pavement management data and any other GIS data services SDDOT may deem necessary or desirable to properly convey needs across pavement and other transportation assets. |
| 3.2.2. Display a map and the corresponding tabular data of selected segments, together in an organized and navigable web-based format. |
| 3.2.2.1. Devise a method to denote the location of section breaks of the Asset data on the map (e.g. leader lines, patterns or color shifts). See example in Appendix C. |
| 3.2.2.2. Include tools to filter and sort data based on the tabular attributes of the asset segments. |
| 3.2.2.3. Have the ability to turn on or turn off specific groups of tabular attributes of the segments. |
| 3.2.2.4. Have a method of turning on or turning off data layers and metadata based on additional GIS feature services that are available and a method to add additional GIS feature services in the future. |
| 3.2.2.5. Include the capability to print the mapping and tabular data displayed in web-based format. |
| 3.2.2.6. Have the ability to modify the content and format of tabular data provided for the application. |
| 3.2.2.7. Where specific codes are present, have the ability to hover over a code to display the definition. |
| 3.2.2.8. If a new attribute is to be added or an old attribute deleted, it can be modified. |
| 3.2.2.9. Provide flexibility to apply this application to additional asset class data sets (not just Pavement Management) |
| 3.2.3. Include a module that will create a set of .pdf or similar files to create a printed book of all data provided by the dTims pavement management system. (see example in..) |
| 3.2.4. The module should include an automatic page generator that can do the following: |
| 3.2.4.1. Create 8½ x 11 pages, in a specified Highway and Linear Reference System (LRS) order, up to a specified number of segments per page (ideally, 7). |
| 3.2.4.2. This should include a method to denote section breaks of the Pavement Management tabular data on the map (e.g. leader lines, patterns or color shifts) |
| 3.2.4.3. Orient the maps on each page to correct the cardinal direction based on LRS increasing from left to right and display to full extent the segments. |
| 3.2.4.4. The module should also include a method to manually adjust the generated pages. |
| 3.2.4.5. Adjust pages by adjusting the specified number of segments on each page. |
| 3.2.4.6. The use of a live map to adjust the extent and orientation of the map to better fit with the listing of tabular data. |
| 3.2.4.7. When the automatic page generator has been run and manual adjustments completed, the module should be able to publish a set of pdf (or similar) files that each represent a page in the Needs Book. |
| 3.3. Deliver and Configure the Needs Book Software for operational use during the SDDOT Pavement Management annual data reporting and analysis period of 2025 data beginning April 1 of 2026; |
| 3.3.1. The Offeror will be responsible for the operations of the software, troubleshooting outages, and resetting the system when needed. |
| 3.3.2. Map out current workflow |
| 3.3.2.1. Map our current work flow and data sources to |
| 3.3.2.2. Suggest improvements, if any, that you would recommend |
| 3.3.3. Provide Annual Support to modify configurations of the Needs Book Software, as needed, to reflect changes in the SDDOT reporting process, requirements, software validations and will provide consulting support to SDDOT Pavement Management/GIS staff to support them using the software to complete the annual Needs Book; and |
| 3.3.4. Provide Training and Operations Support for the Needs Book Software. |
| 3.3.5. Need to control when changes are updated. |
Updates should be made in consultation with DOT so that we are never caught unaware by updates.
| 3.3.6. Provide the data that is currently uploaded for the Needs Book. |
| 3.3.7. Future Enhancements to include additional updated assets currently being collected by SDDOT. |
| 3.4. RFP Deliverables |
The State’s specific system requirements and specifications for the Needs Book Software are in Attachment 1.
The requirements were developed by the SDDOT Needs Book Team to document the functions that the Needs Book Software must perform to meet all the end users’ needs, but not to dictate ‘how’ they must be performed; the requirements are intentionally defined at high levels. Nonetheless, SDDOT is interested in all features and functions of a fully functional Needs Book software, regardless of whether the functions are mentioned in the requirements.
The Offeror will be responsible for performing the tasks outlined / described in this section.
| 3.4.1. Task 1: The Offeror response will demonstrate that they can produce a product acceptable by the SDDOT Needs Book Team. This means |
| 3.4.2. Ability to configure the Needs Book software as outlined in detail in section 3.1. This generally includes: |
| 3.4.3. Display a GIS map and the corresponding tabular data of selected multiple Pavement Management segments together in an organized and navigable web-based format. |
| 3.4.4. Include a module that will create a set of .pdf or similar files to create a printed book of all data provided by the GIS dTims pavement management feature service. |
| 3.4.5. To produce these reports the Offeror system will need to be able to provide an on-demand connection to these current data sources maintained by SDDOT as provided through a GIS service. |
| 3.4.5.1. Provided output from dTims pavement management software (Deighton) |
| 3.4.5.2. Any other GIS data the SDDOT may deem necessary or desirable. |
3.4.6. Deliverable: Sample Web-based Needs Book
Presentation that shows capability of software to Display a GIS map and the corresponding tabular data of selected multiple Pavement Management segments together in an organized and navigable web-based format.
3.4.5.7. Deliverable - Needs Book Page rendering module.
Presentation that shows the capability of a module that will generate a set of .pdf or similar files to create a printed book of all data provided by the dTims pavement management system.
3.4.5.8. Deliverable - System Integration
A description of how you will integrate with existing data sources. This should be in the form of both
| 3.4.5.8.1. A high-level diagram of how your system works with other systems data sources. |
| 3.4.5.8.2. A technical description of how you will create, operate, and maintain data connections. This will be reviewed by BIT. |
| 2. |
| 3.4.9. Task 2: Plan for Needs Book Software delivery, configuration of interfaces to external systems, and demonstration of ability to generate Needs Book related products. |
| The Offeror will outline a “typical” plan for installation and providing Quality Assurance testing. In Task 2, the Offeror will detail their plans to install, configure, and bring to operation one (1) version of the Needs Book Software, establishing needed connections to all SDDOT systems, including the dTims Pavement Management system output and any other GIS data the SDDOT may deem necessary or desirable. |
| Test Plan (or Test Implementation Plan) |
| The proposal will explain how the Offeror will perform an initial test of the Needs Book System for the purpose of system testing. This will also outline how SDDOT will test the system with guidance from the Offeror. |
This guidance should clearly define the testing strategy and responsibilities. For example, the connections to the external business systems or services provided that contain the Needs Book data elements, performing data validations, coding data items, data formatting, and generating reports must be described. Test Scripts must be developed and supplied by the Offeror to aid in testing. Electronic Test Plans, Cases, and Scripts are acceptable.
The Offeror must be available for consultation and/or assistance during testing, at no additional cost to the State, until the SDDOT Project Manager has signed the Letter of Acceptance for the Needs Book System. It is anticipated that testing may take 14 days however, the actual length of testing may vary.
The Needs Book System must perform all aspects of system functionality as described in the RFP and resulting contract.
| 3.4.9.1. For the proposal, the Offeror should provide a detailed plan with timeline for. |
| 3.4.9.1.1. Discovery |
| 3.4.9.1.2. Creating data connections |
| 3.4.9.1.3. Launching a test environment |
| 3.4.9.1.4. Creating the Fully functioning/operational Needs Book Software, as determined by the State, in-use by SDDOT users and pulling data from external systems for at least 14 consecutive days without fail. |
| 3.4.9.2. Deliverable: Test Plan (or Test Plan Implementation) |
| As part of the response outline your |
| 3.4.9.2.1. Test Plan/Cases/Scripts, Consultation (On-site if requested) |
| 3.4.9.2.2. Walkthrough/Virtual Session (if applicable). |
| 2. |
| 3.4.10. Task 3: Training |
| 3.4.10.1. Data Manager Training |
| In Task 3, the Offeror will provide in-person training to SDDOT staff / users on loading and operating the web-based and page rendering Needs Book Software (the Data Managers). The Offeror will perform one training session. The in-person training session will be a minimum of one (1), eight-hour days, to allow for full staff interaction and one-on-one training. It is estimated that training will consist of up to five (5) SDDOT staff, with one to two trainers provided by the Offeror. The training environment will be provided by SDDOT. |
| 3.4.10.2. End User Training |
| The Offeror will also provide training, utilizing a video or similar media, on how to use the software from an End User perspective. SDDOT will add the training to SDLearn. |
| 3.4.10.3. Training Manuals |
| In addition to training, the Offeror will deliver two (2) Training Manuals and two (2) User Manuals that describe the core functionality of the system, how to use it, and the key functions and roles required to operate the system. |
Manuals will be provided electronically to the Project Director in Microsoft Word (MS Word) and PDF format.
3.4.10.4. All travel for training will be reimbursed at actual expenses.
| The proposal should provide a narrative describing how they will provide the following deliverables. |
| 3.4.10.5. Deliverable: Data Manager Training: |
| The proposal should outline a plan for conducting one, one (1) day on-site Training Sessions in Pierre, South Dakota. |
| 3.4.10.6. Deliverable: End User Training |
| Training videos for the end user to include tips and tricks on how to effectively use the software. |
| 3.4.10.7. Deliverable: Training Manual |
| Deliver two (2) electronic MS Word (or similar) copies, describing the core functionality of the system, how to use it, and the key function and roles required to operate. |
| 3.4.10.8. Deliverable: User’s Manual |
| Deliver two (2) electronic MS Word (or similar) copies, describing the core functionality of the system, how to use it, and the key function and roles required to operate. |
| 3.4.10.9. Task: Operation Support |
| The Offeror will make clear if the software will be hosted by them or by South Dakota. If both are options then this should be explained. |
Either way, we expect the Offeror to perform technical support to maintain the operations of the Needs Book Software. the software will be installed in a SDDOT provided environment.
The Offeror will remain responsible for software maintenance, upgrades as needed, troubleshooting outages, and restoring operations that are not related to the hosting environment.
In addition, the Offeror will be responsible for performing all operations of the system, maintaining regular back-ups, and any database administration needed, perform back-ups of the system data, and deliver backups to SDDOT at a regular planned cycle to be agreed during system development.
The proposal should include a narrative describing how you will meet this deliverable.
| 3.4.10.10. Deliverable: Operations Support |
| 3.4.10.10.1. Describe the options for hosting the software. |
| 3.4.10.10.2. Describe your maintenance and technical support plans, including software supports and upgrades. |
| 3.4.10.10.3. If hosting, please describe your disaster recovery and back up plans. As well as your database maintenance plans. |
| 3. |
| 3.5. Hosting and Data Access Requirements |
If no data is stored with in the vendor system respond to 3.5.1 and 3.5.2 with N/A
| 3.5.1. The contract doubles as an agreement for the State to own the data tables and is able to manipulate data, run reports as needed, pull code tables, access raw data, and develop dashboards as needed through Microsoft Power BI, ESRI, Tableau and associated platforms. |
| 3.5.2. The Offeror shall describe the process by which the State can access data housed within the proposed solution for ingestion into a state data repository, encompassing available methodologies (e.g., flat file, API), data formatting, frequency of updates, and any inherent constraints. Additionally, provide a high-level architecture diagram, as part of the Solution Diagram, elucidating the proposed solution's data provision mechanism. |
| 3.6. Single Sign-On Requirements |
| 3.6.1. As part of the State’s Identity and Access Management (IAM) strategy, the proposed solution will need to integrate with the State of South Dakota’s standard identity management service single sign-on (SSO) which enables custom control of how citizens and state employees sign up, sign in, and manage their profiles. |
3.6.2. The SSO supports the industry standard OAuth 2.0 protocol. This identity management will handle password recovery and multi-factor authentication (MFA). MFA is required for all application Administrators and may be required for other users. Microsoft’s official documentation on the identity provider the State has implemented can be found https://learn.microsoft.com/en-us/azure/active-directory/architecture/auth-oauth2 and https://learn.microsoft.com/en-us/azure/active-directory/develop/v2-protocols-oidc for state employees, businesses, partners, providers, etc. (Azure Active Directory).
3.6.3. If the offeror is not able to fulfill this identity management standard, they will be excluded from the list.
| 3.6.4. Onboarding/Provisioning Users |
| The offeror must describe how new users are onboarded/provisioned in the system using an external identity provider and provide an Identity/SSO/Login Design Document. |
3.7. Interfaces and Integration
3.7.1. The offeror must describe how the system can adapt to business necessary interfaces using widely adopted open APIs and standards. Additionally, SDDOT expects that the offeror will make available/expose software services and publish documentation for those software services that would enable third party developers to interface other business applications. A detailed description of system capability must be included in the proposal.
3.8. Solution Diagram
3.8.1. The offeror must provide a solution diagram providing specific details of how the entire solution will meet the requirements of the RFP. This will include integration with the State’s infrastructure, existing systems that will integrate with the proposed solution, how data would flow between systems, the technology stack of the solution including any dependencies, and include, but not be limited to, user onboarding/provision and SSO.
File details come from the government source that posted it. Updated .