SE1051 Active Places - Geospatial infrastructure, database and user platforms for the sports sector

Description

Summary of the work Design, build and operate a new solution for Active Places, the national sports facility database and web-based user platforms, and Sport England's geospatial infrastructure. Expected Contract Length Up to 24 months Latest start date Saturday 1 April 2023 Budget Range The budget for the redevelopment and migration of Active Places (database(s), Active Places Power, Active Places Data Platform) and the GIS infrastructure to a MVP is a maximum of £850,000. Note: This does not include (a) year 1/2 hosting costs, or (b) year 3/4 hosting and continuous improvement costs. Why the Work is Being Done Active Places, the national sports facility database and its user interfaces, underpin the strategic planning of sports provision in England. Mapping and geospatial analysis within Active Places, and wider Sport England systems, are provided by an associated geospatial infrastructure which supplies both data and geoprocessing (i.e. routing/catchment, geocoding, proximity) services. Active Places is now in excess of 10-years old. Consequently, the database and supporting web-interfaces are based on ageing code and technologies. These technologies have a limited support lifetime and constrain full benefits realisation. Active Places and the current GIS hosting solution do not maximise cloud-based technologies creating inflexibility in the system. To support Sport England's new strategy, Uniting the Movement, and growth in Place-Based working, we are seeking to reshape, realign and redevelop Active Places and its allied GIS infrastructure to ensure the organisation and wider sector can fully leverage the benefits from the sports facility data held in Active Places and Sport England's other corporate spatial data holdings. Problem to Be Solved The redevelopment of Active Places and GIS infrastructure will address: a) Active Places -The Active Places Power UI is dated and does not meet the digital expectations of modern users. Users unfamiliar with the data/tools find it difficult to move through the tools and explore the data. Potential insights are not maximised. - The Active Places Power Data Platform is dated (functionality, design). Processes/tools have evolved over time and require review/refresh to maximise efficiencies while ensuring data is captured to defined quality standards. - Data collection is focused on one data model and collection approach. New technologies/approaches are being explored to diversify data capture and collection but these do not fit within the current solution. - Increased two-way integration between Active Places and systems both internally and externally is needed to maximise data sharing and reuse across the sector. - Benefits realisation is constrained by the available resources. b) GIS infrastructure - Sport England lack a centralised geospatial resource from which to grow the use of these tools/technologies in support of Uniting the Movement. Spatial data and systems are dispersed. A centralised, foundational system is needed to maximise collaboration, data sharing and reuse so to better support Uniting the Movement. Who Are the Users For the Active Places data/tools accessed via Active Places Power: - Sport England, Government Bodies (national, regional, local), National Governing Bodies for Sport (NGBS), and others, can access comprehensive, accurate information on the location and characteristics of England's sport facility stock. As a single-point of truth, the data underpins efficiencies and cost savings across the sector. - Local Authorities can access facilities data and planning tools, such as,the Playing Pitch and Sports Facility calculators to estimate facility demand, to support evidence based strategies and decisions on facility provision and leverage funding into sports. - Local Authorities can use facility data and tools to underpin Assessments of Needs and the development of playing pitch/built facility strategies. - NGBS can explore the relationship between facility catchments and population in easy to use geospatial routing tools. Analysis outcomes evidence strategic planning and funding decisions. - Sport England Planners can understand facility stock, catchment of a new/existing site and population able to reach a site. This supports their statutory planning role regarding the protection of playing fields. - A diverse set of users can access the Active Places open data APIs and downloads, for example, NHS Choices promotes opportunities for sports and physical activity. Early Market Engagement A early market engagement session was held on the 26th August 22. DOS 5 suppliers who referenced 'GIS' or 'Geospatial' in their Digital Marketplace listing were invited. The slides and recording from that session can be found at: https://login-uk.mimecast.com/lfs/app/?tkn=3.jhy6EGum1NkdjW_93FUvRS6K7P35-MQXIfwsGCYxRdCHlf1daa-x4hSXzC8-ToeMLNhhfv4Dn8vWjhYD5pvdd-qnupL4kqiUWgEQI3uWEABI1aSOBwPBrHS9TcXeDdC17MkuuLJ03VM6jEpPB5T4PA.wVxEOm75C_WAMgDNBkT_hw#/landing?token=o9M0hp-y8zBoEKhQZDpyfXQ2hIhLeuCUgCwF7YwsJFZUxyIFjUYY_X6y-638r5EoZQ4_8iWBqYQrIlAAq_oeQcxi6Ns5WSpYYXjJvEDyeVu7WDVmAOaCUnApcI3TUJcKltWnfDQ8qdXaWvJWhvu8idk5Dbf3gL1fARJW4nJ09wiaaCljcI_6wPjpaY-ZebgaMFO11u28o_nfhPzMgrpOHsozebEW0-DoShho73YNGEIVv4mlk0f5xjtEY6uzWDFZ4hw1KD_SKA5HAzURqBQf3MCt1SxUm6e4l1OJmePnJMY&recipient=grace.mckenna%40sportengland.org&sender=grace.mckenna%40sportengland.org&go=download Alternatively, email Procurement@SportEngland.org to receive a copy. Work Already Done The redevelopment will build upon, and maintain functional parity with, the existing Active Places user platforms although, this may be delivered in a different way. Active Places Power A users view into the sport facility database, this (B2B website) providing access to reporting, analysis and mapping tools. https://www.activeplacespower.com/ Registration is required. Active Places Data Platform A self-service website which enables site owners and the data validation team to update and audit facilities data. Access to this site is restricted. Screenshots of the platform can be provided on request. Access to the UAT environment will be provided to shortlisted candidates. Existing Team Project Management and System Owners: Head of GIS, Head of Planning Expert Users and Primary Stakeholders - Facilities Data, Active Places Power: National Planning Team - Geospatial Infrastructure and services: IT, Place Directorate - Facilities Data Maintenance, Active Places Data Platform: Adetiq (External contractor) External stakeholders (NGBs, Local Authorities) may be represented on the User Group. Current Phase Not started Skills & Experience • Demonstratable experience, and in-house technical competence, in the architectural design and deployment of, and development within, the esri technology stack. This must include deployment and development within a cloud-based environment. • Demonstratable experience, and in-house technical competence, in the creation and management of national-scale spatial datasets and the publication and maintenance of data and geoprocessing services (incl. routing analysis) • Demonstratable experience, and in-house technical competence, in database design, deployment and management. This must include geospatial databases. • Demonstratable experience in delivery of web-based user interfaces. Must include interfaces that enable the collection and quality-assurance of data, visualise data in multiple formats, and support user-driven analysis. • Demonstratable experience ensuring continuity while deploying a new service. Must include migrating existing applications into a new digital service, and delivering new components which integrate into existing services/systems. • Demonstrable experience in working on digital services which: a) Meet data protection or equivalent information regulations. b) Meet web accessibility standards. • Demonstratable experience delivering complex projects and digital services according to Agile methodologies and user-centred design principles and within iterative development cycles including capturing and prioritising user stories and designing/facilitating UAT. Nice to Haves • Demonstratable experience of successfully delivering large-scale system solutions. • Demonstratable experience of a staged project implementation from Minimum Viable Product (MVP) deployment to a 'live' robust product or service. • Demonstratable substantive experience of providing hybrid digital solutions which maximise commercial-off-the-shelf (COTS) components while also harnessing bespoke development to successful achieve user requirements and maximise benefit realisation. • Social Value - Able to demonstrate action to identify and manage cyber security risks in the delivery of the contract including in the supply chain. • Social Value - Able to demonstrate the development of scalable and future-proofed new methods to modernise delivery and increase productivity Work Location Where required, in person meetings to be held in Sport England Offices - London, Loughborough or Bisham. Working Arrangments Due to a dispersed team, it is expected that the majority of the work and meetings will be undertaken remotely. Security Clearance None required. Additional T&Cs All outputs developed within and resulting from this contract shall be the intellectual property of Sport England, this includes (but is not limited to) the systems, configuration of those systems, bespoke code, database, and data which it contains, which shall be the property of Sport England. Sport England will retain the Intellectual Property for all analytical models and/or calculators included within the solution. The supplier shall not disclose details of, provide access to, or reuse/distribute those solutions unless Sport England gives expressed written consent to do so. Shortlisted suppliers will be asked to complete a Sport England GDPR questionnaire. No. of Suppliers to Evaluate 5 Proposal Criteria • Describe how the ActivePlaces ecosystem will be implemented. Include the technology stack and integration points. Indicate which requirements can/cannot be met and whether this is by COTS and/or bespoke development. • Describe how your solution will enable SE to flex to future geospatial demands, maximise data-sharing and reuse and support the growth/migration of spatial technologies in the context of place-based working. • Describe your proposed plan to migrate data and users from the existing Active Places solution to the MVP. Include details on your approach to service continuity during this period. • Describe your approach to ensuring delivery a quality product. Include details of your approach to defining requirements, sign-off, documentation, user-acceptance testing and release management. • Describe your approach to ensuring delivery of a quality product. Include details of your approach to defining requirements, sign-off, documentation, user-acceptance testing and release management. • Create a delivery plan for the project estimating time frames, identifying any risk and dependencies. The plan should encompass development, deployment and migration to the Minimum Viable Product. • Describe the proposed project team including key staff their roles and experience. Clearly demonstrate the team structure, assigned responsibilities and how you would adapt the team to changing priorities. • Describe how you envisage the Active Places/ GIS solutions will be managed and maintained following MVP release. Detail how the managed service would support business as usual and continued improvements. Cultural Fit Criteria • Demonstrate your experience of working with multidisciplinary teams, this should include teams external to your organisation. Detail how you shared knowledge, learnt from others and worked collaboratively • Social Value - Describe how you demonstrate collaboration throughout your supply chain/third-party stakeholders, and a fair and responsible approach to working with partners in delivery of the contract. • Detail your organisational approach to ensuring service continuity both in terms of system knowledge/development and client relationship management. • Detail your approach to managing risks and resolving issues effectively. Include how you define and understand risk, how you resolve issues and ensure lessons are learnt. Payment Approach Capped time and materials Assessment Method Presentation Evaluation Weighting Technical competence 70% Cultural fit 10% Price 20% Questions from Suppliers 1. I would like to confirm the procurement process for this opportunity as follows:1. Complete the published ITT by answering the questions on the DOS portal by 14th September.2. Following this 5 suppliers will be downselected to receive the FRP3. Those 5 suppliers will provide a full priced proposal.To confirm, all we need to do now is complete the 100-word questions on the portal? 1. Yes - we have made a request to CCS to see if this can be extended to the 21st but please work towards the 14th and this will be updated if extra time is permitted.2. Yes - we intend to shortlist 5 who will be sent more detailed requirements and will be asked to complete a proposal.3. Yes - a commercial workbook will be provided to shortlisted candidates to submit with their final proposal.Guidance on completing your DOS response can be found here: https://www.gov.uk/guidance/how-to-sell-your-digital-outcomes-and-specialists-services#writing-evidence 2. Please confirm that you are expecting suppliers to respond to each skill requirement using a single example in the SWR format as per the DOS guidance? Yes - the 'writing evidence' section of the following offers guidance on this: https://www.gov.uk/guidance/how-to-sell-your-digital-outcomes-and-specialists-services 3. Please clarify how the development of scalable and future-proofed new methods to modernise delivery and increase productivity relates to social value. This relates to Theme 2 of the Social Value Model (Tackling economic inequality) and the Policy Outcome 'Increase supply chain resilience and capacity'.This question is adapted from the Social Value Model, and related to Model Award Criteria 3.3. Further information on the Model can be found here:https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/940828/Social-Value-Model-Quick-Reference-Table-Edn-1.1-3-Dec-20.pdf 4. Further Information on the Q&A Session. A Q&A session will be held at 10am on the 6th September 2022.You can join the session at the following link:https://teams.microsoft.com/l/meetup-join/19%3ameeting_MjRhYTk3YWEtYjJmZS00NDFkLTliZDYtMjE3OTQwZGFiMjg1%40thread.v2/0?context=%7B%22Tid%22%3A%22c8aa047b-166f-4855-90ea-b8ab9d872d1d%22%2C%22Oid%22%3A%22f97ea9a2-a8df-49c3-8635-00fb168f2f99%22%2C%22IsBroadcastMeeting%22%3Atrue%2C%22role%22%3A%22a%22%7D&btype=a&role=a 5. Please confirm whether you require two examples for this response – ‘Demonstrable experience in working on digital services which: a) Meet data protection or equivalent information regulations. B) Meet web accessibility standards' This can be answered with either i) a single example of a digital service that demonstrates both requirements ii) an example for each requirement 6. In relation to: • Demonstrable experience, and in-house technical competence, in the architectural design and deployment of, and development within, the esri technology stack. This must include deployment and development within a cloud-based environment.Is this limited to the Esri technology stack or will Sport England consider using alternative technologies such as Open Source technology stacks and the benefits that could come with this? The esri technology stack is the required solution for this procurement.Sport England has multiple internal solutions which are built, and dependent upon, esri technologies/services. To ensure compatibility, minimise disruption and cost and maximise interoperability and take full advantage of resources and licences, the GIS infrastructure and Active Places will be built on this stack. 7. Is it essential the solution uses the ESRI stack or would other GIS solutions be possible? The esri technology stack is the required solution. See Q6. 8. - Could you please confirm the approximate number of concurrent users of the current system?AND- How many users are envisaged for the Active Places solution? Active Places Power: Current users c. 1600. (concurrent unknown). Users generate c. 1700 - 3115 reports per quarter.Active Places Data Platform: Current users c. 8500. APDP is used daily by the data validation team (average ten concurrent users). Other users accessing the system, at any one time, is variable.Open data downloads and APIs: Open data (CSV and JSON) up to c. 500 downloads per month. APIs c. 1790 calls/month.Active Places users are expected to grow. Growth is also expected in API usage as the APIs are increasingly being used by the sector. 9. Could you please provide information on the current volume, data source and its format? The current Active Places database (SQL Server Version 14.0.3370.1) is approximately 3.6GB in size. This is the active database and does not include a) historic snapshots of the database (taken annually since 2018 for audit purposes), b) GIS datasets, and c) ancillary tables required to support export functionality. 10. Please could you share the High Level Functional/Technical Architecture of the current solution (including API architecture)? Detailed functional requirements and a system overview will be shared with those shortlisted.For information, the current data structure is described in the Sports Data Model (https://www.activeplacespower.com/Sdm) and the Active Places APIs described at (https://www.activeplacespower.com/OpenData/Api/Docs).As this is a redevelopment project and we wish to promote innovation, we do not envisage sharing the technical architecture of the current solution. 11. Could you please provide screenshots of the Active Places Data Platform? While unable to register for the Active Places Data Platform, it is possible to access the home page of the site (https://dataplatform.activeplacespower.com/). The openly available FAQs (https://dataplatform.activeplacespower.com/faqs) and training videos (https://www.youtube.com/channel/UCFjaTZEj704PoOczEjSVPDQ) will provide good examples of the structure and use cases for the platform.Please access only the open resources. Do not register for an account. 12. We would envisage using any one of the following technologies:• AWS• Azure• PostgreSQL• MS SQL Server• NodeJS based API• React/Angular JavaScript frameworksWill any of these be non-compliant with your technology standards? The technologies listed do not raise any concerns and could form the basis of the Active Places redevelopment. 13. Will the documentation of the systems reviews to date be made available for those shortlisted? Detailed functional requirements and a system overview will be shared with those shortlisted. As this is a redevelopment project and we wish to promote innovation, we do not envisage sharing the system reviews for the current solution. 14. Will Sport England consider Open Source based solutions? Sport England envisage a solution which utilises both open source and licensed products. Where open source components are utilised, a risk assessment will be required to ensure compliance with Government and Sport England technology standards.Please note there is a requirement that all GIS data and geoprocessing services be published as esri rest services (see question 6). 15. What software and infrastructure is the existing GIS system built on? The current solutions utilise the esri technology stack (see also question 6).