Loading...
HomeMy WebLinkAboutRESPONSE - RFP - 8391 OPEN DATA PORTAL SOFTWARE AS A SERVICEThe City of Fort Collins, Colorado Technical Proposal for Open Data Portal Submitted To: City of Fort Collins c/o Financial Services Purchasing Division 215 N. Mason Street, 2nd Floor PO Box 580 Fort Collins, CO 80522 Submitted By: Shawn Ahmadi, Account Executive - Socrata 705 5th Ave S #600, Seattle, WA 98104 Phone: (425) 205-9579 Email: shawn.ahmadi@socrata.com Executive Summary & Solution Overview Socrata, Inc. and Carahsoft are pleased to jointly present this proposal for an open data program and consulting services to support the City of Fort Collins, CO. Carahsoft, our authorized reseller, will act as an order fulfiller and will provide an additional buying point with authority to quote and accept orders on the contract holders’ (Socrata) behalf. The City’s mission is to provide exceptional services for an exceptional community, and it does so by fostering operational excellence and a culture of innovation. In support of this critical mission, the City is seeking to increase accessibility and transparency by equipping residents with the tools they need to view, visualize, and analyze its current and historical data sets. Socrata understands the power of unlocking the City of Fort Collins’ data to be used as a powerful asset, and Socrata is the industry leader to empower the City not only to publish raw data, but more importantly to improve data-driven decision making. Socrata’s mission statement is unleashing the power of government data to improve society. We believe our mission complements the City’s mission, vision, Open City Initiative, and overall goals for a 21st Century Government. Since our founding, we have only focused on public sector organizations, and in doing so have worked on over 1,300 projects, with clients across governments, NGOs, non-profits, and multilaterals organizations globally. This includes virtually all the major cities in the United States, dozens of counties, roughly half of all states, 19 Federal customers, and multiple international groups. Socrata is an Ideal Partner for The City of Fort Collins Socrata’s approach spans across People, Process, and Technology, which collectively will help guide the City of Fort Collins to each of their stated goals. ● People:No other vendor has more hands-on experience planning, implementing and executing public sector performance management initiatives. Socrata’s proposed team includes former government performance analysts, program managers, data analysts, and systems engineers -- all of whom work exclusively on local government projects. ● Process:Socrata’s seven step implementation methodology: Socrata Blueprint and data maturity model has been created to ensure the City of Fort Collins’ project is rich with repeatable industry best practices. Socrata also brings the world’s leading best practices in Open Data for government - one of City of Fort Collin’s main goals as described in this RFP. The linked document in the footer is © Copyright 2016 1 an example of thought leadership documents that will be used during the City’s project: The Open Data Handbook for the State of Iowa. 1 ● Technology:Our technical proposal includes the following solutions and communication applications: Socrata Publica Open Data Cloud™ and Perspective,™ which sit on top of the best-in-class Socrata Cloud Data Platform.™ Collectively, this performance solution meets 100% of the technical requirements included in this proposal. Socrata’s Best-in-Class Solution The City’s goal is to enhance the quality of life across its 161,000 residents, employees and student base by providing on-demand data including Financials, GIS, capital improvement project, crime, performance measures, transportation, planning, development, recreation, and code enforcement data. In order to be successful, The City of Fort Collins is looking for an open data tool that will enable it to showcase critical datasets at launch, and scale that number significantly in the years ahead. These datasets will fully align with the OpenCity initiative. Socrata will support The City of Fort Collins’ open data mission by delivering a cost-effective Open Data platform that allows the public to find, download, and visualize public datasets of interest. Additionally, the proposed solution will include dashboarding capabilities via Socrata’s Perspectives solution,for city-wide indicators and priority areas; departmental measures; data by specific topics; and geospatial information to simplify data search and collection processes for city’ citizens. The image below represents an initial mock-up of the Socrata Open Data portal for Ft. Collins. We will confirm all branding requirements and content priorities with the Ft. Collins team during the planning stage of this project. 1 https://drive.google.com/file/d/0B6GnYDq-pGaVdGRWN09BVV9IU0k/view?usp=sharing - Iowa Open Data Handbook © Copyright 2016 2 Preliminary mock-up of Fort Collins Open Data Portal. We describe high-level capabilities of Open Data and Perspectives below: High-Level Capabilities of the Socrata Data Platform The Socrata Data Platform is a cloud-based, turnkey, software-as-a-service (SaaS) solution designed from the ground up to simplify the process of publishing public data to the web. It empowers end-users internally and externally with tools for ad-hoc data exploration and visualization, and provides tools to enable the sharing of that information out across social channels. The platform is delivered as a web portal that allows users to: ● Perform robust searches for data and information, ● Interact with that data by sorting, filtering, and performing group-by and roll-up operations, ● Create real-time visualizations on top of the data with charts, graphs and maps and save these visualizations to user profiles, ● Share data and saved views in context rich reports, dashboards and stories to extend its reach and utility, ● Integrate, extract and cleanse a variety of shapes and sizes of source system data in real time and present that information in a consumption formats, and ● Empower advanced users and developers with machine readable data, APIs and tools to create sophisticated services, robust interfaces and dynamic mobile applications. © Copyright 2016 3 High-Level Capabilities of Socrata Perspectives Socrata Perspectives augments the Socrata Data Platform by helping the City connect the dots between policy and outcomes for its users. With Socrata Perspectives, users are able to quickly produce the relevant dashboards, as well as associated ad-hoc reports and stories, using drag-and-drop functionality that allows for text, images, maps, and data visualizations. The screenshots below show a sample dashboard before context and data is added (left), and after the resulting dashboards are created (middle and right). By promoting a digital-first data society within the City, residents can uncover valuable information they need to make educated decisions, and local policymakers can make more informed policy changes based upon real data. With a highly-defined implementation and successful methodology, Socrata will help the City of Fort Collins build upon the OpenCity Initiative through the Digital Government Maturity Model, thus enabling it to achieve long-term, sustained success. Supporting the City’s Vision of Open Data Transparency and Value, and Beyond Socrata’s technology, implementation team, and ongoing engagement from the city’s named Customer Success Manager will enable Fort Collins to accomplish its Open Data goals and establish a foundation for its future of data-driven government. © Copyright 2016 4 In Socrata’s Digital Government Maturity Model, shown below, establishing an Open Data program is the technological and cultural foundation on the path to becoming a mature digital government. Socrata’s enclosed proposal includes the People, Process, and Technology that will deliver to Fort Collins the necessary infrastructure to continue advancing its digital government path, to a data-driven organization that goes far beyond Open Data (seen as Experimental Open Government on the model below). Our focus on our government partners’ continued success beyond the first Open Data project is perhaps Sorata’s largest differentiator from our competition, and we are overly excited to have the opportunity to partner with Fort Collins to accomplish the goals of this and future data-related initiatives. Please feel free to contact me directly at (425) 205-9579 or shawn.ahmadi@socrata.com with any questions or communications that will assist you in your evaluation of our response. Shawn Ahmadi, Account Executive 705 5th Ave S #600, Seattle, WA 98104 Phone: (425) 205-9579 Email: shawn.ahmadi@socrata.com © Copyright 2016 5 I. Methods & Approach A. Implementation Services Socrata has included below all associated information related to our implementation services, including details about how we will deliver this project to the City of Ft. Collins. 1. Project Planning: Define in a written Project Plan, the tasks, milestones, schedule, deliverables, communication, risk management and resource management of the implementation project. Project Plan & Communication Channels Socrata’s Project Planning approach is comprehensive and includes both transparent communication channels, and system-based management tools. ● Project Plan & Schedule: At the outset of this project, Socrata’s Project Manager will create a clear, easily understood project plan and schedule. This deliverable will outline all tasks, milestones, and deliverables, and we will use it to keep the project on track and alert key team members of potential risks. This schedule will also indicate where within the process specific team members need to weigh in, thus eliminating problems that arise when stakeholders are not involved early and often. ● Online Project Workspace:Socrata uses an online project collaboration tool called “WorkFront,” which will provide Ft. Collins staff with real-time access to project information, including minutes to project meetings, deliverables, feature lists, web prototypes, and project status updates. WorkFront provides a joint workspace for the Socrata and Ft. Collins teams to better collaborate and track and assign tasks through a detailed task tracking system. ● Weekly Status Updates: Socrata will send a report each week during the implementation process that outlines completed tasks, tasks underway, and upcoming activities, as well as any outstanding risks or issues that must be addressed. These updates will allow us to make any necessary course corrections early in the process, and they will give us the opportunity to discuss any risks that may thwart the process. Socrata’s Seven Step Implementation Methodology - Tasks, Milestones, Deliverables Below we include a high-level description of each phase of our seven-step implementation methodology, including all proposed tasks, milestones and deliverables. © Copyright 2016 6 The Socrata Project Manager will be responsible for coordinating and guiding Ft. Collins stakeholders through each stage of the project described here. Step 1: Plan The goal of the Plan stage is to confirm scope, resources, timeline, and budget to guide the implementation of the project. During this stage, our team will create a Program Plan that includes the activities, timeline, and resources required to deliver all defined outcomes within the project. We will include a recommended education plan, by role, for various Customer team members, as well as a test plan and marketing and communications plan to be followed during and after customer launch. Socrata Recommended Preparation Activities Tasks for Customer team to complete prior to Program start: ● Identification of team members, and classification into Program roles, including: ○ Executives ○ Administrator s ○ Publishers ○ Curators ● Identification of key datasets for Program engagement Plan Activities ● Program planning session ● Creation of detailed Program plan ● Data readiness evaluation ● Risk assessment ● Creation of team education plan, to be leveraged during the Educate stage ● Creation of communication plan, to be leveraged during the Launch stage Plan Deliverables Socrata Consulting and Education Teams’ deliverables include: ● Program, education, resource, marketing and communication plans ● Initial consulting engagement agenda ● Creation of a QA/QC plan, to be leveraged during the Build stage ● Data readiness evaluation ● Risk assessment ● Production site ready for customer use, e.g. <customername>.data.socrata.com Customer Team’s deliverables include: ● Applicable Education courses completed prior to start of engagement ● Customer preparation tasks completed as applicable ● Identification of corresponding data source systems for selected datasets ● Identification of any compelling events or key dates ● Review of available template design options ● Confirmation of scope, timeline, and resources ● Configuration of production Open Data platform site ready for customer use Step 2: Educate The “Educate” stage of the Socrata Customer Success Methodology leverages the Socrata Education Program, and requires that the initial training recommended for key Program team members be completed prior to the start of implementation. This includes Socrata recommended courses for each role per the Education Plan defined in the Plan stage (above). Education Plan The Education Plan will specify the approach to educating the Customer team on the Socrata solution. This will include recommendations around pre-engagement, beginning, and advanced levels of education for the Program team, as well as for data stewards of identified datasets and corresponding source systems. Course Description Suggested Roles Socrata Fundamentals Administrator Publisher Executive Curator Administering Your Site Administrator Introduction to Automated Publishing Administrator Publisher Advanced Data Integration Administrator Publisher Advanced Visualizations ○ Performance Management ○ Marketing and Communications Planning ○ Includes advanced courses: ■ Promoting Your Launch and Beyond ■ Programmatic Best Practices ○ Best practices on different vehicles for an Open Data policy ○ Facilitation of outreach and training of agencies, departments, and external users Step 3: Design The objective of the “Design” stage is to architect the Open Data platform to meet the goals and objectives defined in the “Plan” stage. Design Activities ● Design Session, based on Socrata-defined agenda ● Customer Approval of Design recommendations to meet objectives and defined outcomes for this project ● Selection of templated homepage styling with standard layout options ● Creation of Design Document ● Creation of an automated publishing plan, including preferred publishing tool for in-scope datasets ● Development of plan for site review and acceptance testing Design Deliverables Socrata Consulting and Education Teams’ deliverables include: ● Automated publishing plan ● Design document ● Organizational structure and business model mapping Customer Team’s deliverables include: ● Completed design requirements questionnaire ● Agreement on design requirements Step 4: Data The “Data” stage of the project includes knowledge transfer around key concepts of data governance (e.g. dataset owners, publishing workflows, ensuring data quality, etc.), and an initial data governance plan for the datasets that will be published in their solution. This also includes training on metadata, the concepts of custom metadata, and the creation of a metadata schema for the Customer. Includes coaching Customer team on the concepts of a dataset inventory and administration tools for data governance, as well as orientation to their automated publishing options. The next (more advanced) phases of the education plan will be executed during this stage. Data Activities ● Open Data best practices mentorship ● Overview of Open Data Network, interoperable data standards, opportunities for peer benchmarking Data Deliverables Socrata Consulting and Education Teams’ deliverables include: ● Advanced Education Plan (if applicable) ● Publishing workflow to support in-scope datasets within the Design Document ● Dataset inventory template © Copyright 2016 9 ● Dataset inventory review based on list of in-scope datasets ● Metadata mentorship and creation of metadata guide ● Mentorship on automated publishing options and strategy ● Documented metadata schema for in-scope datasets within the Design Document Customer Team’s deliverables include: ● One dataset ready for use on the Socrata Platform Stage 5: Build The objective of the “Build” stage is to architect the Open Data platform to meet the requirements defined in the “Design” stage. Build Activities ● Deployment of site style to production site, according to design document ● Configuration of custom metadata in platform for use during upload ● Initial users added to platform with correct roles per data governance plan ● Loading of initial datasets and creation of initial visualizations ● Configuration of automated publishing job(s) for at least one key dataset; additional datasets may be supported if Program budget allows ● Verification to ensure results meet Program business objectives ● DNS and SSL setup for one (1) custom domain; SSL certificate included at no cost ● Test Plan updates to determine test plan length (recommended 2 week minimum) ● Testing and Validation of Solution ○ Technical Validation ○ Business Process Validation ○ Review Go-Live Critical Issues ○ Resolve Go-Live Critical Issues ● End User Acceptance and Stakeholders approval Build Deliverables Socrata Consulting and Education Teams’ deliverables include: ● Production site tested and validated ● Up-to-date implementation issues log with designated critical issues and resolution tracks ● Additional curator and publisher education plans ● End User Training program Customer Team’s deliverables include: ● Completed QA/QC test plan ● End User Acceptance and Stakeholder Approval ● End User Training completed Stage 6: Launch The “Launch” stage focuses on production readiness and includes all activities to prepare the Customer for using the Socrata Data Portal once live. This stage will give the Customer team everything they need in order to follow new business practices and processes for using data on the platform. We will also provide education and marketing activities for end users, so that they understand the value of the data available and how to use it to optimize their operations, organization, programs, and performance. This audience may be the general public, or users internal to the organization. Socrata will provide support to the Customer team during this stage. Launch Activities ● Confirmation of Go-Live date ● Completion of all launch activities (events, announcements, etc.) ● Execution of marketing communication plan (both internal and external) ● Confirmation of completed SOW ● Confirmation that customer has signed up for Socrata Customer Community and appropriate user groups ● Program Wrap-Up Session ● Transition to Customer Success and Customer Support ● Production site launched ● Education on Customer Success Plan and Customer Support processes Customer Team’s deliverables include: ● Final user acceptance; Product site meets success criteria defined in SOW Step 7: Evolve This final stage includes developing a roadmap for continued program success ongoing support wherever needed. Evolve Activities ● Ongoing improvements and customizations to align with Customer’s evolving business goals ● Continuous prioritization to ensure improvements are made based upon level of importance, number of users affected, and level of effort to complete. Evolve Deliverables ● Roadmap for Continued Program Success Expected Work Schedule Typical Socrata deployments take approximately eight weeks from planning to launch (shown in draft schedule below), and we will finalize this schedule with much more detailed milestones upon project onset. We expect Ft. Collins staff to be readily involved in the planning and design stages of this project, as well as across all educational trainings we provide. Furthermore, we will collaborate closely with your team throughout the build stage, to ensure your team has been able to provide client-based quality assurance testing and approval. © Copyright 2016 11 Risk & Resource Management Under Section V: Availability, Socrata talks about our Resource Management approach, which is centered on a shared resources arrangement, ensuring each engagement has a dedicated team booked and fully available on the program prior to commencing work. Doing so allows us to maximize the quality and speed of delivery, and minimize inefficiencies by customer randomization. As part of Socrata’s Risk Management approach, our Project Manager and key team members discuss an internal risk management plan, where we: ● Assess any identified risks (e.g., lack of stakeholder involvement, technical risks, schedule risks, cost, etc.), ● Rank these risks based upon estimated impact to overall scope, and ● Devise a mitigation plan for ongoing risk identification and mitigation. Failures in communication are often central to project-related issues, which is why our team focuses on open and transparent communication, and frequent check-ins with our clients. Should any risk arise within the Ft. Collins project, our team will monitor and report on progress daily until the issue is resolved. 2. Requirements Definition: Document the roles, processes, and software functions to be accomplished by the system, using requirements provided by the City, and a structured documentation methodology. During the “Design” stage of this project, Socrata will create a requirements document that specifies all technical, functional, and design requirements for our solution. We will base this document on Ft. Collins’ existing branding guidelines, and on the various types of data that Ft. Collins will need to accommodate as part of this Initial Phase, including: ● City Expense Data: This data represents payments made by the City of Fort Collins to vendors, employees, and other entities. The frequency of data export will need to be determined. ● Employee Pay ● Crime-Related Data ● GIS data sets: The GIS data sets that the City makes openly available, viewable in a mapping interface. The frequency of data export will be weekly. a. Current building permits b. Street centerlines with address ranges c. Floodplains d. Parcels e. District precincts f. Zoning g. FEMA floodplains h. Liquor Licenses © Copyright 2016 12 i. Annexations ● Water Production and Quality ● Development Review and Land Management Data ● Customer Service Requests ● Nuisance Code Violations Our plan will collectively identify all user roles and workflows required as part of the solution, including standard users who may only need access to drill-down reports and filtering capabilities, as well as advanced users who may need the ability to generate reports, set up queries, etc. 3. Services Access: Confirm access needed from workstations for development and testing purposes, noting any required plug-ins or other needed modules. Socrata is a Software as a Service offering that is delivered over the web. To this end, our team will only need access to the internet on workstations in order to test across local machines. Since Socrata is configuring an off-the-shelf application, there will be no traditional development work required. 4. Infrastructure Plan: Include a Plan that describes any needed additions and/or changes to the City's infrastructure in order to support the portion of the application hosted at the City or for access from the City staff. Socrata does not foresee the need to establish an elaborate Infrastructure Plan for the City, as our solution is a fully hosted, cloud solution that handles all infrastructure requirements. During the Education stage of this project, we will train your team on how to configure and use Socrata tools, including all options for the automation of data from enterprise systems within Fort Collins. 5. Security Plan: Include a Plan that describes the security related changes needed by the hosting environment or applications in order to meet the City's needs. Socrata’s hosted cloud solution handles all of the platform security requirements on behalf of the City of Fort Collins. We do not foresee a need to change the existing hosting environment on the City’s end to meet the needs of the solution. 6. Software Configuration: Submit a Configuration Plan that describes how the provided software service will be configured to meet City needs as documented. Configuration Plan is to include the following: Modifying screens, menus, reports, and adding user-defined fields to adapt to the City's needs, including any custom programming. The City of Fort Collins would be licensing “Consumer Off The Shelf Software” (COTS) from Socrata to meet the needs documented by the City. Each data extract that the city chooses to automatically publish to Socrata will have their own workflow, and those processes can change and grow over time as the Open Data Program within Fort Collins grows. Since Socrata is working with pre-existing data, there is nothing that will need to be added to the existing line of business systems in order to deliver this open data program. The citizen-facing catalog landing page is a Socrata-powered web page that we manage on behalf of the customers that we serve. The City of Fort Collins will be able to choose © Copyright 2016 13 from a number of design templates to help define the look and feel that best meets its branding requirements, and Socrata will then configure the platform to achieve this design direction. 7. Data Conversion: Include cost for conversion of up to five years of existing data for use within the proposed solution as needed. As part of the Socrata Implementation Methodology, Socrata consultants will educate and train the City on how to manipulate and upload data to the Socrata platform. Through this process, Socrata will take data to be used as a part of the proposed solution and demonstrate how to develop an automated workflow that will move data from the City of Fort Collins’ source systems into Socrata. Socrata’s goal is to make our clients feel as comfortable with the open data portal as possible, so that they feel empowered to convert, load, and administer data without needing to engage additional resources. Doing so is more cost effective for our clients, and it enables them to retain a greater sense of control over their solution moving forward. Our implementation package includes an education plan that provides extensive training to promote a deep understanding of our solution. This process takes place during the “educate” stage of our project methodology, during which we will pull from the Socrata Education Program to train all Ft. Collins stakeholders. Typical course descriptions and recommended user roles to attend these sessions include: Course Description Suggested Roles To Attend Socrata Fundamentals Administrator Publisher Executive Curator Administering Your Site Administrator Introduction to Automated Publishing Administrator Publisher Advanced Visualizations Administrator Publisher Curator Building an Open Performance Dashboard Administrator Publisher Curator The Education Plan we develop will specify basic and advanced levels of education for all project team members and data stewards. Specific training activities include: © Copyright 2016 14 ● Orientation to Socrata Education Program and the Socrata Knowledge Base ● Core Team Training based on recommended Education Plan ● Development of End User Training Plan and ongoing Training Plan ● Unlimited access to online training via webinars and videos ● Additional education options (i.e., based upon the Education Program purchased): ○ Instructor-led interactive virtual Education courses ○ Two hours per topic session, based upon set schedule within U.S. timezones ○ Unlimited course attendance ○ Two remote courses per year of your choosing, including the following, available topics: ○ Intro to Open Data ○ How to Publish Data ○ Data Readiness ○ Data Integration and Automated Publishing ○ Administration (for Apps, for Open Data, for Open Performance) ○ Advanced Visualizations and Data Storytelling ○ Dashboards and Creating Goals ○ Performance Management ○ Marketing and Communications Planning ○ Promoting Your Launch and Beyond ○ Programmatic Best Practices Specific training deliverables include: ● Final Education plan by role ● Education plan communication to all team members ● Administrators and Publishers educated and ready for implementation ● Recommended End User Training Plan Please note:Should City staff require additional support beyond staff training, Socrata has the resources available to contract out independently to offer more robust support on specific data conversion use cases. 8. Hosting: Provide an overview of SaaS infrastructure environment including up-time history, response time, etc. The Socrata platform is highly scalable and optimized specifically for small-scale and large-scale government data. The platform is hosted on the AWS hosting infrastructure, which allows us to handle spikes much more gracefully than would be possible in a dedicated environment. Our enterprise-class infrastructure allows us to generally sustain a target availability of 99% (less downtime for scheduled maintenance and circumstances beyond its control). We schedule specific maintenance windows once per month, during which we reserve © Copyright 2016 15 the option to bring the Socrata platform down for scheduled maintenance and upgrades. These windows include: ● The third Saturday of January, February, April, May, July, August, October, and November, Socrata-powered data sites may be unavailable from 8:00 PM to 9:00 PM ET. ● The third Saturday of March, June, September and December Socrata-powered data sites may be unavailable from 8:00 PM to midnight ET. Additional, short windows of downtime may occur due to emergency maintenance. Site scheduled maintenance reminders will be posted publicly on each Socrata-powered datasite at least 48 hours before the start of that maintenance window. 9. Testing: The City will be responsible for conducting tests to ensure that the base software, any modifications, interfaces, and hardware meet the City's business needs and it functions properly in the City's environment. As part of our project process, Socrata will create a Test Plan, which will outline the processes we will use to verify that our technology solution performs as expected. It is guided by formal acceptance criteria against all identified user stories, which we collaboratively establish with your team during the Design Stage. User Acceptance Testing (UAT) allows us to ensure that all features and functionality align with the City’s business needs and any required branding guidelines, and functions flawlessly in your environment. The test team required for conducting user testing consists of members from both the customer and the Socrata teams assigned to this project. Terminology User Acceptance Testing (UAT):Actual software users test the solution to make sure they can complete required tasks in real-world scenarios. This is the final verification that the platform is complete and fully-functioning according to specifications and that the stated business needs are met. User Acceptance Criteria: The requirements that must be met for a solution to be assessed as complete. The criteria define the specific workflows and outcomes that the customer expects based on design conversations. During the Build stage, we will test the solution in two ways. First, our team will ensure that the technical solution performs as expected and that the required end-user tasks can be completed. Second, City stakeholders assigned to the testing team will perform User Acceptance Testing to verify that the solution delivers the expected outcomes and success criteria: 1. Step 1: Socrata Quality Assurance Socrata is committed to delivering the highest quality solutions to help our customers become 21st century digital governments. At the end of the Build © Copyright 2016 16 Phase, the Socrata project team will conduct a comprehensive internal QA test to identify and resolve any technical issues within the solution. 2. Step 2: Customer User Acceptance Testing As soon as the Build stage is complete, we will enter the User Acceptance Testing phase of the City of Ft. Collins’ Platform launch. This stage is guided by a formal list of acceptance criteria for each user story that our teams collectively created during the Design stage of the project. It is at this point where your team will provide end-user testing to confirm that we have built the platform under real-life scenarios, that all functionality is aligned with the agreed-upon Statement of Work, and that City stakeholders have been able to provide necessary feedback prior to launch. Upon completion of the Acceptance Testing phase, the Socrata team will require a minimum of five to ten days turnaround time, from the last day of the Acceptance Testing phase, to address all issues identified. This turnaround time may scale, depending on the number of issues identified, and the degree of change involved. By the end of the Build stage, the City will return the Test Plan with the User Acceptance Testing section completed. Our assigned Project Manager will provide oversight across training and will be responsible for managing and minimizing any risk that may arise. We have identified common risks below, and the appropriate actions needed to mitigate the impact of these risks on the project: Risk Impact Trigger Mitigation Plan User acceptance testing (UAT) not completed within specified period of time. High Potential bugs or requested improvements not identified. Socrata will outline the number of days available for UAT, provide a UAT tracking document, and guidance on how to use the tracking document. Socrata will also send a brief reminder 48 hours prior to the end of the UAT period. Scope Creep - As testers become more familiar with the tool, they will want more functionality. High Delays in implementation schedule. Throughout each iteration, functionality will be monitored closely. Priorities will be set and discussed by stakeholders. Since the driver is functionality and not time, it may be necessary to push the date out. © Copyright 2016 17 Changes to the functionality may negate the tests already written and we may lose test cases already written. High Loss of all test cases. Export data prior to any upgrade, massage as necessary and re-import after upgrade. i. The City and the Respondent will work to resolve any issues in configuration, data conversion, or performance. The Respondent will obtain written verification from the City's Contract Administrator of this task. During implementation, a Socrata Program Manager and the City will jointly document the objectives, as well as the product configuration options and data requirements, to help the City achieve its technology and business goals. Issues that prevent the success of the implementation will be documented, shared with the City, and tracked internally by the Socrata Program Manager. During launch planning, if any critical issues exist, they will be thoroughly identified, and we will then develop a resolution plan, which we will execute on prior to launch. ii. The Respondent will immediately provide resources for product fixes resulting from errors identified during the software testing process and provide additional training and/or support where necessary. Socrata has a dedicated support staff that respond to bug fixes in the software. This includes bugs in the testing process and ongoing throughout the terms of the agreement. Our support is ongoing and lives beyond the duration of the initial implementation. In addition, Every Socrata customer is assigned a dedicated customer success manager who acts as the single point of contact after the initial implementation, and throughout the duration of our relationship. The customer success manager is responsible for the creation of the client’s ongoing Roadmap, the sharing of best practices, as well as ongoing guidance to help with program adoption. © Copyright 2016 18 Socrata’s Support options are listed above, and we have included Basic support as part of this response. Additional support options with specific SLAs are available upon request. iii. Respondent’s proposal shall address all sections of Acceptance Testing to be specified by the City of Fort Collins. During the scoping and design phase of the project implementation, the Socrata Program Manager will work closely with the Program Manager at Ft. Collins to document all relevant use cases for our solution. These are the high-level outcomes that will be critical to the success of the City of Fort Collins’ open data program. Your Socrata Program Manager will translate these use cases into specific “User Acceptance Criteria” that can be tested once the solution is built. Project success criteria are the standards by which the project will be judged upon its completion, and they will be critical to understanding whether the solution implementation has been successful in the eyes of the stakeholders. The Program Manager and the City of Fort Collins will also identify potential project risks to be mitigated throughout the build and testing phases. 10. Performance Tuning: The provided environment will be assessed and modified to achieve best performance and optimum settings. Respondent shall specify measures and targets to track user experience in relation to system responsiveness. Respondent shall provide regular updates of these measures and commit to address any degradation in user experience. The proposed Socrata solution can meet the +15M row expectations and has multiple datasets over this capacity hosted for our partners at this time. Socrata maintains performance expectations of: © Copyright 2016 19 ● 75% of requests return data in 0.4 seconds ● 95% of requests return data in 1.0 seconds ● 99% of requests return data in 4.0 seconds We operate on a shared infrastructure among all of our different customers. This means that we support very large workloads of concurrent users, with no noticeable degradation in performance. This infrastructure runs entirely on AWS, allowing Socrata to scale up and down with the workloads that are required on the platform. 11. Startup: Provide assistance with project setup to resolve initial issues. The Socrata implementation methodology includes initial setup and configuration. This covers branding and site design to map the look and feel of the platform to the City of Fort Collins’ branding requirements, as well as the design of our solution against all functional requirements. In addition, the Socrata team plans for QA / QC periods across each of its implementation projects as a way to review how the site is functioning before final acceptance and launch. 12. Training: Submit a comprehensive Training Plan to include, but not limited to, conducting training on-site or remotely for up to 10 staff members at varying levels of use. An Education Package (i.e., Training Plan) provides the opportunity to educate all Socrata users on any Socrata Education course, as often as is needed, based on the program purchased. Education Packages allow for ongoing training to foster the creation of power users throughout the organization. These courses allow our customers to train new Socrata users as they come on-board, as well as offer refresher courses to improve a user’s existing training and knowledge. Education Packages Include: ● A one-year package, ● Unlimited access for your users to attend any course included in your package, ● Cost-effective training of all users, with a focus on bringing users up to speed on Socrata’s solutions quickly and efficiently, and ● Webinar courses related to the corresponding program. Education and knowledge transfer are key success factors in the Socrata platform deployment. Socrata provides qualified, certified instructors who help transfer the knowledge of Socrata to our customers. The Education group will provide customers with a formal education plan to assist them with ensuring breadth and depth knowledge transfer to their team. The following are the current online Course Offerings (as of May 1, 2016) available for registration on the Support Portal. These are provided via our Live instructor-led software: © Copyright 2016 20 Course Description Suggested Roles Socrata Fundamentals ● Executive ● Administrator ● Publisher ● Curator Administering Your Site ● Administrator Introduction to Automated Publishing ● Administrator ● Publisher Advanced Data Integration ● Administrator ● Publisher Advanced Visualizations ● Administrator ● Publisher ● Curator Creating a Story in Perspectives ● Administrator ● Publisher ● Executive ● Curator Building an Open Performance Dashboard ● Administrator ● Publisher ● Curator Making the Most of the Latest Features ● Administrator ● Publisher ● Executive ● Curator B. Data & Platform Services Below we outline our responses to all Data & Platform Services requirements, as identified by the City of Ft. Collins. 1. Import data such that there is the greatest opportunity for the automation of the loading and general maintenance of data sets. Socrata has become the single-most integrated data portal in the world, making our approach to source systems integration as easy and flexible as possible. This has allowed us to integrate with thousands of different systems and variations, and our methods to ingress data from source systems include: © Copyright 2016 21 ● A manual upload wizard for uploading a variety of file types. ● A web wizard for uploading geospatial boundary files, used to create interactive maps on the platform. Uploaded boundary files can be matched with deposited data, which includes geographic information to enable the creation of valuable point, choropleth, and multi-layer maps. ● Automated data publishing via our “Publisher API” and related “Metadata API”. Socrata exposes the entire spectrum of publishing capabilities that are available throughout the platform additionally through these APIs, including all Create/Replace/Update/Delete operations and POST requests to update individual data records (for data hosted on the DDH). This is an extremely intuitive and powerful mechanism for keeping data updated, particularly for research-heavy organizations. ● Publishing via third-party ETL solutions, such as Safe FME Desktop or Pentaho, both of which have built-in Socrata connectors for automating the ingest of metadata and data into the Socrata data platform. Any ETL tool that can write to a RESTful API (including Informatica, DataStage, and others) can also be used. ● Publishers can also set up FTP Dropbox for regular ingestion of data from a designated location, or leverage Socrata’s lightweight Java app, “DataSync”, for writing through the API via a user interface. DataSync, an open source solution created and maintained by Socrata, is a publishing tool that allows users to schedule automatic publishing of data to the Socrata Data Platform. Publishing criteria are fully customizable at the individual dataset level, and Fort Collins staff can find more information about this feature here: https://github.com/socrata/datasync. Socrata's web-based manual upload wizard is as easy as uploading a photo to Facebook. Socrata DataSync automates the publishing of your datasets using file-sync and API methods. Socrata will fully assist Fort Collins in setting up its automated data integration process during implementation, and we will confirm these needs during the planning and © Copyright 2016 22 initiation portions of this project. In the example shown here, The City of Raleigh publishes a number of different datasets at independent frequencies. The administrative tool gives publishers easy access to the status of the individual dataset publishing activities. 2. A platform that presents data and services to the public in a manner that is relatively easy to navigate and makes use of with little or no training. Socrata aims to make its solutions as intuitive as possible, both for the end users and for more advanced users administering the tool. We have included below a sample landing page for the Ft. Collins Open Data portal. This page serves as an entry point for the public to easily understand and access all of the data that the City of Fort Collins wants to provide through the platform. The visual hierarchy and frequent use of iconography makes it easy for users with very little or no training to understand what is available, and quickly navigate to the content that will be most meaningful to them. © Copyright 2016 23 Sample landing page for Fort Collins’ Open Data Portal. Once a user clicks on a category above and chooses a specific dataset, they are presented with a primer page (example below), which shows them information about the dataset in question. The primer page allows these particular datasets to be optimized both for search engines, and for presenting users with high-level information about a particular dataset in an engaging way. © Copyright 2016 24 Example Ft. Collins primer page. 3. Analyze data in graphical format. All data sets available within Socrata have 13 different visualization formats available out-of-the-box, which can be dynamically applied to datasets for maximum flexibility in displaying critical information about the data: Area chart, Bar chart, Bubble chart, Column chart, Donut chart, Line chart, Pie chart, Stacked bar chart, Stacked column chart, Timeline and Tree map. Socrata visualizations give internal users immediate access to save views, download the raw data to their own machine, comment on and participate in conversations about the data, receive embed codes to share the view in their own reports, access the SODA 2.0 API (for internal application developers), and print the dataset or visualization. © Copyright 2016 25 Examples of types of graphical formats available to Ft. Collins staff. 4. Analyze data in a tabular format. Open Data Portal allows users to view and analyze rows of tabular data in multiple different ways. The different view formats can be found next to the “Find in this Dataset” field. An example of a dataset in a tabular view is shown here: Example dataset shown in tabular format. © Copyright 2016 26 5. Generate and view multiple graphical formats such as pie, line, bar, or similar charts. As stated in #3 above, data sets are able to be generated and viewed in 13 formats, including but not limited to: Area chart, Bar chart, Bubble chart, Column chart, Donut chart, Line chart, Pie chart, Stacked bar chart, Stacked column chart, Timeline and Tree map. We will discuss Ft. Collins’ graphical formatting requirements at the outset of the project, ensuring we allow for maximum flexibility with the City’s presentation of its data. 6. Search for presented data by one or more of the provided data elements. Socrata provides a number of different ways to search for data. This includes traditional search by keyword or phrase, or filtering and searching based upon a specific visualization type. The example below shows search results in the Fort Collins data catalog - with additional options on the left to adjust search parameters even further. Example search results - Ft. Collins sample portal. 7. Filter and sort data by one or more of the provided data elements. Socrata’s filter tab allows users to manipulate data dynamically from within the platform. This includes performing filtering and grouping on datasets - where users can summarize the data and create different views, as well as modify and delete data columns and rows. The example here shows how a user can group warrants by month, and then roll up those warrants and count the number of incidents. Most reporting tools are structured around a seat-based model in order to manipulate data, making Socrata unique in the fact that it is a non-user based model. This allows for a greater breadth of users who can actually manipulate data in the platform - business analysts and data stewards some of the most popular. © Copyright 2016 27 8. Export data from the platform into a wide variety of digital formats. Data will be exportable and downloadable via numerous methods: © Copyright 2016 28 Downloading through the user interface, seen above in CSV, XLS, XLSX, JSON, PDF, RSS, and XML file formats. Accessing/exporting tabular data using the OData endpoint, which allows users comfortable with Tableau, Microsoft Excel, PowerBI, Oracle, and other OData-compliant tools. Access via a dataset-level API, for automated access to rows and columns of deposited data. 9. Create bookmarks or share links to searches or filtered results. Socrata allows users to save what we call “Views” within the portal, which are dynamic views that reflect the most current version of information. Views can be of charts, graphs, rollups, or filters, and they live within the catalog as primary assets that are fully discoverable by end users. Each view is given a URL, which users can share via social media and bookmark for future use. © Copyright 2016 29 Example of saving a view for social sharing and/or bookmarking. 10. Access the data in machine readable formats and be accessible in current industry standard application programming interfaces. The Socrata Data Platform will create standardized, configurable, machine-readable APIs for all Ft. Collins data from source systems. This data can be exported and downloaded in the following ways: Downloading through the user interface, seen above in CSV, XLS, XLSX, JSON, PDF, RSS, and XML file formats. Accessing/exporting tabular data using the OData endpoint, which allows users comfortable with Tableau, Microsoft Excel, PowerBI, Oracle, and other OData-compliant tools. Access via a dataset-level API, for automated access to rows and columns of deposited data. © Copyright 2016 30 11. Provide opportunities for robust description of the data sets to be available with each data set. Socrata Primer is the principal front-page experience for uploaded datasets, allowing dataset owners to fully describe a dataset. This mobile responsive page contains useful introductory information about the data, helping to answer questions such as: "Is this the data that I'm looking for?" "How up to date is this data?" "What is the data being used for now?" A Primer page includes: ● Info Pane - Includes key metadata, such as: the dataset title, description, last updated date and the data provider. Important navigation components are also found here, with options to view the data table, download the data, access the API or share it socially. ● Featured Content - Includes up to three featured visualizations, stories or other content from around the web. Dataset editors curate this related content, and if no content is configured, this section simply will not show to users. ● About this Dataset - Includes information about the dataset, such as the metadata and metrics. ● What’s in this dataset?- Includes quick snapshot of the total rows, total columns, and information about what each row of data represents. ● Preview Data Table - Allows for views of all the rows of the dataset, 10 at a time, right from the landing page. Also allows for the filtering of datasets and creation of visualizations via the “Explore Data” option. ● Public Views Created from this Dataset - Allows users to see and explore the most popular views that have been created from a particular dataset. The most popular three appear by default, but find more by click Show More. The example below is from the City of Chicago that highlights a dataset called Crimes - 2001 to Present. © Copyright 2016 31 Example Primer page from City of Chicago. 12. Visualize data sets with a geographic element in a mapping format. Socrata’s Data Lens enables the exploration of data in a variety of different geospatial manners, including: choropleth maps, spatial lens, point maps, base maps, and GeoJSON APIs. The example shown below uses existing Fort Collins data to create a choropleth map that is counting the number of building permits by council district. We have specified the colors for this particular option to illustrate the breadth of configuration options available to users for advanced customization. Example Fort Collins choropleth map. © Copyright 2016 32 Example Point Map. 13. The presentation of thematic groupings of data sets such that visitors to the site can start with a general theme, such as “Budget” or “Finances” and drill down into layered, logical groups of data. Socrata allows users to control the grouping of datasets, and to change this over time as specific priorities of the open data program grow. The City of Fort Collins will be able to configure this via the administrative interface, without ever needing to contact Socrata for assistance. The example below is from the City of St. Paul Minnesota and highlights budget information as one of its top-line, layered categories. 14. Create the opportunity for public discussions related to data set(s). Datasets specified as “public” allow for commenting and public discussions around that data, and the platform also supports a built-in, native nomination mechanism for © Copyright 2016 33 datasets within the platform. Dataset owners can selectively disable this feature on any individual dataset that they own. Socrata has an in-platform commenting module that allows for the discussion of datasets between the community and the program owners of the datasets themselves. Socrata supports the ability to share datasets and other Socrata assets to social networks. This example is a Facebook shared story about the Great American Opiod Crisis. 15. A platform that has demonstrated a very high level of availability. Socrata maintains an enterprise-class infrastructure with availability and uptime SLOs. We schedule time windows once per month where we reserve the option to bring the Socrata platform down for scheduled maintenance & upgrades: ● On the third Saturday of January, February, April, May, July, August, October, and November, Socrata-powered data sites may be unavailable from 8:00 PM to 9:00 PM Eastern time. ● On the third Saturday of March, June, September and December Socrata-powered data sites may be unavailable from 8:00 PM to Midnight Eastern time. We also schedule downtown for necessary emergency maintenance, and all maintenance reminders will be posted publicly on each Socrata-powered datasite at least 48 hours before the beginning of the maintenance window. An alternative status page will be displayed during scheduled maintenance windows. While we attempt to meet these levels, this is a service level objective only. Socrata is delivered as a SaaS offering exclusively on AWS and Data is mirrored across a minimum of two AWS Availability Zones (AZs), and backups are stored in AWS Simple Storage Service (S3). © Copyright 2016 34 This section includes all information related to Socrata’s Support Services, spanning software maintenance, education and training, and ongoing growth and support. Software Maintenance 1a. With the City's approval, updates or upgrades of the software service can be incorporated for bug fixes, new features or other software enhancements included in future versions. Socrata is a SaaS solution that is constantly growing and evolving and the City of Fort Collins would be licensing the use of that software for the length of that contract. All enhancements made to the existing solutions are included as part of the subscription. Major releases typically happen on a six week cadence, and product release notes can be subscribed to so that the city can be kept up to date about changes that have been made. 1b. A description of the roles, responsibilities, problem escalations path, scheduled downtimes, contact names, emails, and phone numbers in support of the Respondent’s hosted system. Roles & Responsibilities Upon initial launch of the Ft. Collins Open Data Portal, Ft. Collins staff will be given a Customer Success Manager, who will be responsible for ongoing support and the monitoring of program adoption and usage. This team member is central to providing guidance on the next phase of the customer roadmap, and for overseeing all ongoing support that takes place. For any required technical support in relation to product issues, we will have a Support Specialist in charge of these changes. The Support Specialist is part of Socrata’s Support Team - a full-time team dedicated to responding to on-call requests from our customer base. We augment this team with Coaches and coaching hours aligned with the tier of support that Ft. Collins is interested in purchasing. These Coaches will sit down with key Ft. Collins stakeholders in one-on-one sessions and will help answer any specific questions that your team has about the Socrata solution. Problem Escalation Path The Socrata Program Manager will be the main point of contact throughout the implementation stage of this project. This team member will monitor project health and identify any potential risks that may negatively impact project schedule, technical and functional implementation work, and/or budget. For any issues that require a higher degree of attention, Socrata’s Consulting Manager will act as an additional escalation resource for all issues pertaining to our consulting services. Post-launch, the Customer Success Manager will take over as the main point of contact for all ongoing support needs (bug fixes, ongoing growth and expansion, etc.). Scheduled Downtimes The Socrata platform is highly scalable and specifically optimized for small-scale and large-scale government data. The platform is built on top of the AWS infrastructure, © Copyright 2016 35 which allows us to handle spikes much more gracefully than would be possible in a dedicated environment. Our enterprise-class infrastructure allows us to sustain an uptime target of 99% on a monthly basis, less downtime for scheduled maintenance or circumstances beyond its control. We do schedule specific maintenance windows once per month, during which we reserve the option to bring the Socrata platform down for scheduled maintenance and upgrades. These windows include: ● The third Saturday of January, February, April, May, July, August, October, and November, Socrata-powered data sites may be unavailable from 8:00 PM to 9:00 PM ET. ● The third Saturday of March, June, September and December Socrata-powered data sites may be unavailable from 8:00 PM to midnight ET. Additional, short windows of downtime may occur due to emergency maintenance. Site scheduled maintenance reminders will be posted publicly on each Socrata-powered data site at least 48 hours before the start of that maintenance window. Contact Names, Emails, and Phone Numbers Socrata’s support team can be reached at: Email: support@socrata.com | Phone:+1 (888) 997-6762. Our full support policy can be found here: https://support.socrata.com/hc/en-us/articles/216962648-Support-Policy Telephone and/or Remote Support: Software troubleshooting and usage advice provided via telephone and / or tools that allow remote support. Socrata offers remote training and support services, through its Customer Success delivery methodology. Training is offered to equip all Ft. Collins team members with the tools and knowledge needed to effectively manage and administer the Open Data solution post-launch. These trainings are offered as part of the Socrata University Webinar Series, which provides new and experienced users with first-hand knowledge of the many features within the platform: ● Socrata 101: Held twice a month, this class includes basic site training, publishing, built-in dataset features, data visualization, embedding, and more. There will be 60 minutes of presentation followed by 30 minutes of Q&A. ● Socrata 201:Held once a month, this class includes advanced visualization training, advanced Social Data Player usage, Mondara geospatial skills, dataset routing and approval, and more. There will be 60 minutes of presentation followed by 30 minutes of Q&A. ● Socrata API School:Held at least once a month, this class is led by our engineering team to get you started on using SODA to publish and consume data. There will be 60 minutes of presentation followed by 30 minutes of Q&A. © Copyright 2016 36 ● Graduation: Socrata students that attend 101, 201, API classes, and pass a publishing and visualization "exam" will receive a certified graduate diploma in mail from Socrata headquarters. Telephone & Remote Support Socrata also has a Support team dedicated to answering questions and helping our users resolve issues. The Customer Support Center is accessed through the Knowledge base at https://support.socrata.com/. Email support allows users to email: support@socrata.com and receive ongoing assistance over email. For technical users that are building applications on the proposed solution or creating system integrations, we also offer a Developer Community Portal at (http://dev.socrata.com). We provide this support from 8:00 AM to 6:00 PM Pacific Time M-F, with the exception of Federal holidays. For Support Programs see https://support.socrata.com/hc/en-us/articles/216962648-Support-Policy On-Site Support: Software troubleshooting, reconfiguration, retraining or other specialized assistance provided on-site. In addition to our remote trainings (via Socrata University) and our remote support, Socrata can also provide in-person refresher trainings and troubleshooting as needed by the Ft. Collins team. Based on the Education Program Purchased, the following, ongoing education options are also available: ● Instructor-led interactive virtual Education courses ● Two (2) hours per topic sessions, per a set schedule optimized for US timezones ● Unlimited course attendance ● Two (2) on-site courses per year of your choosing ● Topics available: ○ Intro to Open Data ○ How to Publish Data ○ Data Readiness ○ Data Integration and Automated Publishing ○ Administration (for Apps, for Open Data, for Open Performance) ○ Advanced Visualizations and Data Storytelling ○ Dashboards and Creating Goals ○ Performance Management ○ Marketing and Communications Planning ○ Promoting Your Launch and Beyond ○ Programmatic Best Practices Warranty: The City desires a one-year warranty to follow final acceptance. This includes free upgrade maintenance and support services during the one- year warranty period. See Legal Response and Sample of Socrata’s Software Subscription Agreement for warranties. © Copyright 2016 37 II. Qualifications & Experience Socrata has demonstrated excellence in developing high-profile open data portals, and in addressing administrative, usability, and ongoing support needs. Our clients include federal, state, and local governments, many of which we have worked with for years. The projects and clients we have chosen to highlight below underscore the expertise we bring to each core competency area required by the City of Fort Collins. City of Austin, Texas Client Name: City of Austin, Texas Contact Name: Charles Purma Telephone:(512) 974-5644 Fax Number:N/A Email Address:Charles.PurmaIII@austintexas.gov Total Dollar Value of Contract: $240,000 annually Contract Term:November 2011 - Present Description of Services The City of Austin created its annual performance report - Performance ATX - as a way to help bring the City’s performance to life, and improve engagement with local government. The goal of this data performance offering is to enrich the City’s civic dialogue around how it is delivering public services and responding to community needs, and to identify ways in which it can continue to do better. Performance ATX presents progress on over 120 key performance indicators. The focus is on direct services to residents, featuring a “citywide dashboard” of 21 critical indicators and clickable categories organized around public safety, mobility and infrastructure, development services, utilities and major business, community services, and financial health. © Copyright 2016 38 Performance measurement, tracking, and review ties to city departments’ annual business planning and the annual budget. City stakeholders use this information to track performance and regularly review and adjust. Moving beyond the city’s static PDF report has been a major part of the City of Austin’s multi-pronged strategy in pursuit of performance excellence. Its team focuses on adaptive strategic planning, business performance planning, enterprise alignment and impact, customer research, integrated continuous improvement — all underscored by citizen and employee engagement. Placing Austin’s annual performance report in a digital interactive format is a move toward further opening a dialogue around the city’s performance. It represents the City’s first time adding photos and visualizations tied to open data, and already it has seen thousands of views. The platform has spurred important conversations inside and outside of the organization organization, and the City feels confident the platform will continue to make it easier for citizens to engage with local government. The City of Chattanooga Client Name: The City of Chattanooga Contact Name: David Carmody, Deputy Chief Operating Officer - Office of Mayor Berke City of Chattanooga Telephone: (423) 605-1094 Fax Number:N/A Email Address: carmody_d@chattanooga.gov Services Subcontracted: No subcontractors used on this effort. Total Dollar Value of Contract: $249,996 Contract Term:April, 2014 - present. Description of Services © Copyright 2016 39 Chattanooga wasn’t always drawing businesses and tourists. City mayor Andy Berke has recalled what the city looked like in 1969, a year in which Walter Cronkite famously called Chattanooga “the dirtiest city in America.” “We saw our city die,” Berke states. The population dropped, as people escaped for a better life somewhere else. After industry in Chattanooga collapsed, the air got cleaner, but the economic base was gone. At that moment, city leaders began anew, with what Berke reflects on as “a visioning process with people from all over the community.” This vision gave rise to a community-based plan and eye for tourism. An aquarium, waterfront parks, and other assets followed, “to bring energy and vibrancy to the city,” explains Berke. Berke injected this spirit of innovation into the mayor’s office, by transforming the department to get “people thinking about how we move our economy forward.” Part of this innovation included switching to a Budgeting for Outcomes (BFO) model to ensure that the city’s budget outlines its priorities clearly. In partnership with Socrata, the city developed ChattaData, a showcase of an open data portal. The online performance dashboard makes it possible for citizens to understand, evaluate, and participate in city government, 24/7. Berke has explained the value in having highly visible, openly shared information: “When you set a bold goal, then people buy in” because they understand you cannot succeed without their help, “and you can truly bring people together.” He offers the example of Chattanooga’s commitment to reducing violent crime by 20 percent. The goal, the 2015 projects funded to achieve it, and their progress, are all displayed on ChattaData for citizens and city workers to assess together. “Linking up what we’re doing with our goals with the actual numbers. That’s a terrific part of ChattaData,” he reflects. ChattaData also helped transform the city library, leading The National Journal to call it “the library of the future.” With 300 datasets hosted and more to come, an entire library © Copyright 2016 40 floor is dedicated to open data, and developers and innovators flock there for creative discussions around how to innovate even more. Chattanooga embraces open data, “with purpose and reason – to improve the lives of our constituents each and every day,” Berke explains. And while the availability of technology won’t solve every problem, open data will continue to give Chattanoogans greater information to discover solutions that can truly change people’s lives. The City of of Los Angeles Client Name: City of Los Angeles Project Name:City of Los Angeles, Open Data Portal, ControlPanel LA, & Payroll Explorer Client POC Name:Varouj Abkian, Assistant Director - Bureau of Sanitation (main reference for LA’s Open Data Portal) Client POC Phone:(800) 773-2489 Client Email:varouj.abkian@lacity.org Description of Project In 2013, Los Angeles City Controller Ron Galperin and Socrata launched an open data and financial transparency portal, ControlPanel LA, to give the public greater insight and access to city services and stimulate new business activity based upon ready access to government data. Through Socrata’s cloud-based, Open Data Portal and Open Payroll solutions, the site provides key information about the City’s expenditures, revenues, payroll, purchasing, and special funds. It offers both the public and government leaders new applications to review city programs and hold city government accountable – in terms of how money is spent, revenues are collected, and employees and vendors are compensated. © Copyright 2016 41 ControlPanel LA provides information about the City of Los Angeles' expenditures, revenues, payroll, purchasing, special funds, and city performance dashboards in one location. We have also supported the City in the design and implementation of its “Payroll Explorer” (shown here), which provides data transparency around employee compensation, base pay, overtime, personnel benefits, and top departments by total payroll, across the City’s 55,000 employees. The portal has been used to help employees plan their career trajectories, to automate FOIA requests (payroll is LA's most frequently requested data, and requests have declined dramatically since releasing this data more proactively), for reporters and the public, and as part of labor negotiations (i.e., ability to analyze data by MOU in the payroll app). An internal database has also been used by auditors and fraud investigators to identify anomalies and outliers, especially in the City's use of overtime. Our team recently extended its relationship with the City through new support for the LA Bureau of Sanitation, in which we helped with their data inventory, and identified © Copyright 2016 42 opportunities for the department to become more data driven (e.g., Clean Streets LA “CleanStat”). We continue to offer industry best practices and reach-back to LA City on the most valuable advances in data transparency, data access, and data-driven action. III. List of Project Personnel Our project staffing provides consistent leadership across strategy, branding, creative design, and interface development coordination. Everyone we have proposed below has unique experience leading and contributing to Open Data projects across federal, state, city, and international projects. Please note that Socrata is on a shared resource model, and resources are finalized at the time of kick-off. Roles, Responsibilities, and Estimated Participation of Key Personnel Resource Role Key Responsibilities Est. Participation (%) Across Total Budget Consulting Manager Shawn Ahmadi Escalation resource for Customer regarding consulting services. 5% Project Manager Robin Rosenberg Lead consultant. Program monitoring, planning, and execution of the engagement as describe in this RFQ. 45% Data Analyst Peter Moore Responsible for communicating and implementing data extraction, transformation, ingress, and analysis procedures. 10% Developer Hiko Naito Key developer during Build and Launch stages. 40% Shawn Ahmadi, Consulting Manager Shawn Ahmadi is a Consulting Manager at Socrata, where he helps decision makers identify gaps in their process, assess risk, and accomplish ambitious data-driven goals by bridging high business problems with effective SaaS solutions. In this role, Shawn has the opportunity to help enterprise-level accounts adopt open data solutions that will address pressing issues around quality of life, operational efficiency, and economic impact. Current and Past Relevant Work Experience Prior Employment History, Projects, and Dates Senior Account Executive, Socrata - November 2015 - Present 2015-2016 Socrata Sales Rep of the Year ● Responsible for over 50+ SMB-Enterprise transactions and over 10% of entire company new acquisition portfolio. ○ 120% Q2 Attainment 2016 | Rep of the Quarter ○ 177% Annual Attainment 2015 | Rep of the Year ○ FY16 Presidents Club © Copyright 2016 43 ○ Q3 2015 Rep of the Quarter ○ Q1 2015 Heavy Hitter Award Territory Sales Team Lead, Socrata - July 2014 - November 2015 ● Structured and scaled Inside Sales framework while responsible for Regional West District. ● Developed in-depth selling strategies and account plans to drive new opportunities, expansion, cross-sells, and professional services in a targeted book of business. ● Identified, closed deals and built momentum in new verticals such as internal data management and regional government data sharing. ● Managed and navigated complex sales cycles and procurement processes with C-level and other government leaders. ● Partnered with product, marketing, customer success teams to develop go-to-market strategies and plans; drove customer acquisition to validate public finance solution. ● Partnered with product, marketing, customer success teams to develop go-to-market strategies and plans; drove customer acquisition to validate public finance solution. ● Developed sales frameworks, workflow processes, and sales assets to support each stage of the buyer’s journey. ● Led weekly meetings with sales reps to outline strategy, overcome objections, identify internal resources to accelerate opportunities; participate as a senior partner in customer meetings. Market Development, TalentWise - September 2013 - July 2014 ● Led a team of 8 market development reps; shadowed and coached them through selling process. ● Developed and standardized onboarding content and process that accelerated ramp. ● Created sales enablement materials, including value drivers, call scripts, email templates and pitches. ● Owned healthcare vertical nationwide and enterprise accounts for the entire state of California. ● Generated $4.3 million in pipeline in 11 months. ● Exceeded annual quota by 600%. Education ● University of Washington Bothell School of Business. Robin Rosenberg, Project Manager Professional Background With over 10 years of experience working with governments, multilateral organizations, and non-governmental organizations, Robin thrives in the space of operations where she matches customer needs to technical solutions. As a Senior Program Manager at Socrata, Robin works closely with a team of technical experts to advise and build open data programs. Professional Quals & Certs Performance management consulting, open data strategy consulting, Progress out of Poverty Index. © Copyright 2016 44 Current and Past Relevant Work Experience Socrata Experience Robin’s work at Socrata focuses on strategic and custom projects with a focus on both government and non-governmental / multilateral sectors - spanning open data and open performance programs. In her role, Robin ensures customer success through her thought leadership in open data and performance programs for governments and NGOs. She provides day-to-day management of project activities including scoping, budgeting and agile site development. She leads UX tasks such as user research, information architecture, wireframes, and content strategy. And, she assesses risk and executes risk mitigation plans. Prior Employment History, Projects, and Dates Independent Consultant - February 2012 - April 2014 ● Independent consultant for a range of non-governmental organizations including the Aga Khan Agency for Microfinance and the Grameen Foundation; advised on poverty measurement approaches, specifically the Progress out of Poverty Index (PPI); developed monitoring and evaluation tools with an eye towards social performance and product development strategy. Red Lotus Technologies, Chief Operating Officer - April 2012 - May 2013 ● Co-founded and ran operations for a business dedicated to developing landmine detection technologies; negotiated and secured subcontract from Carnegie Mellon University and the US Department of Defense; spearheaded business development; interfaced between customers and engineering team to steer product development to the market demand; conducted field testing with customers. Education ● M.A. - University of Melbourne ● B.A. - Northern Arizona University Peter Moore Professional Background Peter joined Socrata as a Data Analyst specializing in communicating and implementing data extraction, transformation, ingress, and analysis procedures - including automation and technical training. Prior to Socrata, Peter completed his master’s degree in Public Affairs from the University of Texas LBJ School of Public Affairs, with a specialization in information, innovation and technology policy. As part of his degree, Peter was educated in advanced econometrics, statistical analysis, and report writing. During his time in Austin, Peter worked as an intern for a Texas state senator consulting on technology policy, as well as data analysis for a technology start-up. Professional Quals & Certs ETL Processes, Python, FME, STATA, ArcGIS, R, QGIS, Java Current and Past Relevant Work Experience Socrata Experience Socrata, Chattanooga, TN - January 2016 © Copyright 2016 45 Currently implementing a comprehensive Open Performance dashboard involving 12 departments over the course of the year. Peter combines a variety of data source systems to populate metrics and has a strong desire to automate where possible. USAID ALC - January 2016 Worked closely with the Administrator’s Leadership Council to collect data from all bureaus within USAID pertaining to their quarterly and annual goals. Data was collected within a Google sheet and then automatically extracted, transformed and validated, and loaded into Socrata to power a custom performance dashboard. USAID DDL - January 2016 Adopted the data catalog and submission process for the USAID open data initiative, which receives data from USAID partner organizations and other bureaus in a variety of formats and sources. Oversaw the ingress process to ensure it was robust and clear, especially with the required metadata fields that correspond to each dataset. Federal Communications Commission - December 2015 Created an automation python script to extract information from the FCC Zendesk API in order to provide a clear insight into the types, locations, and frequencies of consumer complaints filed with the FCC. Required in-depth analysis of the Zendesk API in order to collect the proper information. European Commission - December 2015 Oversaw custom initiative involving complex financial and project level data to be accurately displayed at many levels of granularity. Goals included timely updates of quality assured data, inclusion of various funding sources, and properly aggregated data. Office of Senator Judith Zaffirini Technology Policy Intern - January 2015 - May 2015 Drafted and reviewed potential technology policy legislation, including meeting with stakeholders and compiling supporting documents. Successfully submitted three cybersecurity bills. SIFMA Cybersecurity Policy Intern - January 2015 - May 2015 Drafted and reviewed potential technology policy legislation, including meeting with stakeholders and compiling supporting documents. Successfully submitted three cybersecurity bills. Education ● MPA - The University of Texas, LBJ School of Public Affairs ● BA - Kenyon College Hiko Naito Professional Background With over 18 years of experience in design and implementation of large-scale web-based applications for U.S. Federal government agencies, Hiko brings a deep understanding and comprehensive knowledge of IT project implementations in the public sector to the Socrata Customer Success technical consultant team. Prior to joining Socrata, he worked with GSA to implement websites focused on government transparency, including Data.gov, the U.S. Federal government’s open data portal, and Recovery.gov, a website designed for citizens to help keep the government accountable. © Copyright 2016 46 Professional Quals & Certs ● HTML, CSS, JavaScript (jQuery, React, D3), Node.js, PHP, Drupal, MySQL, Web Accessibility/Section 508 Compliance ● Japanese (fluent) ● DOD security clearance (inactive) Current and Past Relevant Work Experience Socrata, Inc. Centers for Medicare and Medicaid Services - September 2012 - present ● Data.Medicare.gov - custom Open Data Portal website. ● Open Payments - custom front-end application to assist users to search over 15 million records of payment records to physicians. ● Performance Indicators - data collection tool for ACA metrics and present data visually in dashboard style. Department of Health and Human Services - Sept. 2012 - October 2015 ● Implemented a custom dashboard using D3 visualizations and choropleth maps. The World Bank - January 2013 - July 2015 ● Implemented a custom Open Data Portal website in 6 different languages. State of Maryland - August 2012 - July 2015 ● Implemented Maryland StateStat website with visual data-driven progress report pages. United Nations, Development Programme - October 2012 - October 2014 ● Integrated Socrata data into UNDP’s Drupal website. REI Systems, Inc. Program Manager - January 2005 - July 2012 ● Led and supervised technical operations team to assist GSA launch Data.gov in a cloud environment, including taking the team through a Certification and Accreditation (C&A) process. Led a team of six to eight software engineers to design and implement Data.gov communities using Drupal, and was recognized by the U.S. CIO Council. Served as a technical program manager to lead a team of three to four software engineers to implement online proposal management systems with DHS and NASA. Principal Engineer - January 2001 - December 2004 ● Supervised a team of four software engineers to design, develop and deploy an online proposal management system for NASA’s Earth Science Technology Office. Education ● Colorado School of Mines, B.S., Mathematics and Computer Science IV. Organizational Chart The following organizational chart shows our team breakdown and hierarchy across the project. We will confirm all team members upon contract signing. © Copyright 2016 47 V. Availability Socrata Availability Throughout every customer engagement, a Consulting Manager, Program Manager, Data Analyst, and Developer staff the Socrata Services team. Typical project engagements take approximately eight weeks to complete (and an estimated 144 service hours), and these hours are shared by the resources described, to accomplish the established goals of the engagement. Socrata works on a shared resources arrangement and ensures that each engagement has a dedicated team booked and fully available on the program, prior to us starting work. Each team member engaged in a Customer engagement is fully booked on these projects in order to provide maximum support. Additionally, Socrata schedules working sessions with customers at least two weeks in advance to ensure dedicated, uninterrupted time to concentrate on a single customer at any given point of time. Doing so ensures we maximize the quality and speed of delivery and minimize inefficiencies by customer randomization. Implementation Schedule Across Available Resources At the outset of this engagement, the Socrata PM will provide a detailed implementation plan and schedule across our Plan, Educate, Design, Data, Build, and Launch stages. The typical breakdown of time for each step is outlined below: © Copyright 2016 48 Plan Educate Design Data Build Launch Consulting Manager & Program Manager – 88 hours Data Analyst – 40 hours Web Developer 16 hours Please note that the Socrata team is fully available for an on-site interview in Fort Collins during the weeks of November 4 and November 11. VI. Cost Schedule The table below outlines a proposed level of effort and associated costs for the City of Fort Collins’ Open Data Portal. This budget is based on our current understanding of your needs and provides a good-faith estimate for the level of effort needed to achieve your online goals. Hosted Software Subscription and Support Order Solution Type Term (Months) TOTAL Publica Open Data Cloud (50k - 150k) with 50 public data sources 12 $34,176 Perspectives (50k-150k) with 5 creator licenses 12 $19,200 Education & Support Program Standard 12 $6,405 Compelling Stories; Open Data Program / Perspectives Launch Package Program Standard N/A - one time $25,920 TOTAL $85,701 *Pricing under this Order valid for 90 days beyond RFP submission deadline of 10/17/2016. © Copyright 2016 49 VII. Vendor Statement I have read and understand the specifications and requirements for this Request for Proposal and I agree to comply with such specifications and requirements. I further agree that the method of award is acceptable to my company. Socrata agrees to mutually negotiate and execute an agreement for software-as-a-service with the City of Fort Collins within 30 days of notice of award. If contract is not completed and signed within 30 days, City reserves the right to cancel and award to the next highest rated firm. FIRM NAME: Socrata, Inc. ADDRESS: 705 5th Ave S #600, Seattle, WA 98104 EMAIL ADDRESS: shawn.ahmadi@socrata.com PHONE: (425) 205-9579 BIDDER’S NAME:Socrata, Inc. SIGNATURE:_ PRIMARY SERVICES ISSUES CONTACT:_Shawn Ahmadi TELEPHONE:(206) 340-8008 CELL: (206) 686-7566 EMAIL:_shawn.ahmadi@socrata.com © Copyright 2016 50 Legal Response:City of Fort Collins RFP #8391 Open Data Portal Software as a Service & Consulting Contact: Musa Kewa– Contracts Administrator (Contracts@socrata.com) Responder Name: Socrata, Inc. Prospect Name: City of Fort Collins Fort Collins Professional Services Agreement Template: Please note that Socrata is not a professional services company; there is no custom development by Socrata, nor is any custom or perpetual software being delivered or installed on your network. Socrata’s is a software-as-a-service (SaaS), which delivers to you via a web-account a commercial off the shelf “ready to use” public data cloud service. Except as set forth in an order, we provide configuration support and training for the Service. Generally professional services agreements include (or exclude) key public cloud clauses and require long cycles of negotiation to fit a software license into an agreement only intended for custom development. To decrease unnecessary cycles of negotiation (and oftentimes misalignment of what is being sold, versus what is being contracted), a copy of our Public Cloud Subscription Agreement is attached for your review. We provide several options on signing up for our subscription ● We have such subscription agreements in place with Colorado public agencies already, which you can use to piggy-back if this is permitted by your procurement department. ● You can purchase directly from Socrata using our attached standard subscription agreement as a springboard (or if you have a SaaS Agreement template for Public Cloud, we can start with that from of agreement) ● You can purchase through our reseller, Carahsoft, through many cooperative purchase vehicles if you are currently an active participant on any VAR Software Agreements (or Public Cloud Agreements): i.e., NASPO VALUEPoint, TCPN, NCPA. Our Public Cloud Subscription Agreement would be attached to purchase orders that are run through these vehicles. ● You may purchase Socrata through the GSA, also through Carahsoft. In this case, Socrata’s standard GSA EULA would be applied to the purchase order. If Socrata is downselected as a vendor, we generally suggest a conversation with you on the path forward on the contract, and which option, above, is best suited for your procurement team. Subscription Agreement PUBLIC DATA CLOUD PLEASE READ THIS AGREEMENT CAREFULLY BEFORE USING THIS SERVICE. BY USING THE SERVICE OR CLICKING “AGREE” CUSTOMER IS AGREEING TO BE BOUND BY THIS AGREEMENT. IF CUSTOMER IS AGREEING TO THIS AGREEMENT ON BEHALF OF OR FOR THE BENEFIT OF THEIR EMPLOYER, THEN CUSTOMER REPRESENTS AND WARRANTS THAT THEY HAVE THE NECESSARY AUTHORITY TO AGREE TO THIS AGREEMENT ON THEIR EMPLOYER’S BEHALF. This agreement is between Socrata, Inc. a Delaware corporation (Socrata), and the customer agreeing to these terms (Customer). 1. WEB BASED SOFTWARE SERVICE. a. Description. Socrata grants Customer the right to access and use the Socrata platform web based service (Platform Service) up to the capacity purchased as specified on an order form (each an “Order”). b. Access to the Platform Service. Access to the Platform Service is provided through a designated Customer account accessed via the internet through a browser by Customer’s designated internal users (Users). Users must keep their individual login credentials secure and shall not share them with anyone else. Users shall use commercially reasonable efforts to prevent unauthorized access to or use of Services and Customer Content (defined below) through its account, and notify Socrata promptly of any such unauthorized access or use. c. Ownership of Customer Content. As between Socrata and Customer, Customer owns all Customer Content. Customer Content means any datasets, discussion forums, and other interactive areas, features or services which Customer creates, posts or stores or uploads to the Service or provides to Socrata (including, without limitation, any content, messages, materials, data, data structures, spreadsheets, entries, information, text, music, sound, photos, video, graphics, code or other items or materials) provided by Customer for use with the Service, but expressly excludes any Third Party Services. d. Public Users. Customer designates which Customer Content is shared publicly, and should determine the appropriate terms regarding such public usage. Once Customer Data has been shared publicly, Socrata has no control over a public users’ use or distribution of such Customer Content. e. Setup and Configuration Services and Training. Except as otherwise set forth in an Order (or as otherwise mutually agreed to by the parties), all of Socrata’s set-up and training services are done remotely and Socrata personnel will not have access to Customer networks. 2. TECHNICAL SUPPORT AND UPTIME SERVICE LEVEL. a. Socrata will provide its technical support services to Customer as described at https://support.socrata.com/hc/en-us/articles/216962648-Support-Policy. 3. UPDATES TO Platform Service. Socrata is constantly improving the Platform Service. Socrata may implement, at its sole discretion, changes, updates, and free upgrades at any time (“Updates”). Most Updates are communicated via release notes on support.socrata.com or via email. Requests to continue using out-of-date versions of the Socrata service are out of scope, and require a Change Order mutually agreed upon and may void warranties, service level and support agreement in their entirety. All such Updates are automatically incorporated into the documentation and specifications to the Platform Service by reference (the “Documentation”). 4. THIRD PARTY SERVICES. As part of the Platform Service, Customer will be provided access and usage of certain third party services (example , third party stock photos and third party map location services), which services are provided at no additional charge to Customer (TPS). Customer must agree to the terms of service or online contracts provided by such third party providers if it chooses to use those features of the Platform Service. 5. PAYMENT. a. Unless otherwise provided on an Order, all fees for the Platform Service are due annually in advance for the service, but in any event within 30 days of a correct invoice date, plus applicable sales taxes, if any. 6. Customer Content. a. License to Customer Content. When Customer uploads or provides to Socrata Customer Content to incorporate with the Platform Service, Customer grants to Socrata a non-exclusive, worldwide, royalty-free, sub-licensable, and transferable license to use, reproduce, publicly display, distribute, modify, create derivative works of, and translate the Customer Content as needed in response to User driven actions, instructions, or otherwise by public users. ● Customer is solely responsible for (i) which Customer Content it chooses to make public and (ii) what terms apply to any Customer Content which is made public. b. Restrictions. Customer may not use the Platform Service for any illegal, harmful or offensive purpose, or to transmit, store, display, distribute or otherwise make available Customer Content that is illegal, harmful, or offensive. For example , prohibited use of the Platform Service and Customer Content includes anything that: (1) is in violation of any law, (2) is harmful to others, Socrata’s operations, including offering or disseminating fraudulent goods, services, schemes, or promotions or engaging in other deceptive practices; (3) infringes or misappropriates the intellectual property or proprietary rights of others; (4) violates the privacy or publicity rights of anyone; (5) is defamatory, obscene, abusive, invasive of privacy, or otherwise objectionable; (6) may damage, interfere with, surreptitiously intercept, or expropriate any system, program, or data, including viruses, Trojan horses, worms, time bombs, or cancelbots. c. Suspension of Service. If, in Socrata’s reasonable judgment, Customer’s use of the Service threatens the security, integrity, stability, or availability of the Services, or is otherwise in violation of this agreement, Socrata may temporarily suspend the Platform Service (or Users access), however Socrata will use commercially reasonable efforts to provide Customer with notice and an opportunity to remedy such violation or threat prior to such suspension. d. Backup of Customer Content. Socrata is not the system of record of the Customer Content. CUSTOMER IS SOLELY RESPONSIBLE FOR CREATING BACKUPS OF ANY CUSTOMER CONTENT STORED ON THE PLATFORM SERVICE. 7. Indemnification. a. Socrata will defend or settle any third party claim against the other party to the extent that such claim alleges that (i) the Socrata’s personnel caused the bodily injury, death, or physical property damage of Customer while on the Customer’s premises; or (ii) the Platform Service violates a U.S. copyright, patent, trademark or other intellectual property right; or (iii) arising out of or related to any claims or penalties with respect to such withholding taxes, labor or employment requirements, including any liability for, or assessment of, withholding taxes imposed on Socrata by the relevant taxing authorities with respect to any compensation paid to the Socrata’s personnel. b. Customer shall promptly notify the Socrata of the claim in writing, cooperates with Socrata in the defense, and allows the Socrata to solely control the defense or settlement of the claim. Socrata will pay indemnification claim defense costs incurred as part of its obligations above, and Socrata negotiated settlement amounts, and court awarded damages. c. If such a claim appears likely under (a) (ii) above, then Socrata may modify the Platform Service, procure the necessary rights, or replace it with the functional equivalent. If Socrata determines that none of these are reasonably available, then Socrata may terminate the Platform Service and refund any prepaid and unused fees in connection with the canceled Platform Service. Socrata has no obligation for any claim arising from: Socrata’s compliance with the Customer’s specifications; a combination of the Service with other technology where the infringement would not occur but for the combination; use of the Customer Content; or technology not provided by Socrata. EXCEPT FOR CUSTOMER’S TERMINATION RIGHTS, THIS SECTION CONTAINS THE CUSTOMER’S EXCLUSIVE REMEDIES AND SOCRATA’S SOLE LIABILITY FOR CLAIMS ARISING AND COVERED UNDER THIS SECTION 7. 8. Ownership. a. Ownership. Customer acknowledges that Socrata and its licensors retain all rights and ownership, including all intellectual property rights, developed, embodied in or practiced in connection with the Platform Services, Socrata’s Confidential Information and Third Party Materials, or other proprietary Information, including but not limited to all modifications, enhancements, derivative works, configurations, translations, upgrades and interfaces thereto. Customer shall not assign, transfer, modify, create any derivative work of the Socrata Works, or reverse assemble, decompile, circumvent, reverse engineer, OEM, or attempt to derive source code or the underlying ideas, algorithms, structure of organization of the Socrata Services. b. Federal Government Provisions. If Customer purchases the Services for ultimate federal government end use, Socrata provides such Services solely in accordance with the following: Government technical data and software rights related to the Services include only those rights customarily provided to the public as defined in this Agreement. This customary commercial license is provided in accordance with FAR 12.211 (Technical Data) and FAR 12.212 (Software) and, for Department of Defense transactions, DFAR 252.227-7015 (Technical Data – Commercial Items) and DFAR 227.7202-3 (Rights in Commercial Computer Software or Computer Software Documentation). 9. Confidentiality. a. “Confidential Information” means any proprietary information, technical data, trade secrets or know-how of the disclosing Party, including, but not limited to, research, product plans, products, services, suppliers, customer lists, prices/costs, markets, designs or other business or technical information of disclosing Party that is designated as confidential or proprietary or which reasonably appears to be confidential or proprietary. Confidential Information shall include, but not be limited to, the terms of this Agreement and any Order, or any information which concerns technical details of the operation of the Services. Confidential Information does not include anything (i) already in the possession of the receiving Party without obligation of confidence, (ii) that is independently developed by the receiving Party without use of the other's Confidential Information, (iii) that becomes available to the general public without breach of this agreement, or (iv) that is rightfully received by receiving Party from a third party without obligation of confidence. Each Party agrees that the receiving Party will use the same standard of care to protect Confidential Information as the Party uses to protect its own confidential and proprietary information and will not use the Confidential Information in any way except for performing the receiving Party’s obligations under this Agreement; provided, however, that the receiving Party may disclose such information (a) to its advisors, contractors and agents if such third parties agree to maintain the confidentiality on terms no less restrictive than those set forth herein or (b) provided that the receiving Party gives prompt advance notice, when permitted, to the extent necessary to comply with applicable law or legal process. Notwithstanding the foregoing, Socrata may collect, use, store and distribute the results from a program or data from the Service in an aggregated form for comparative and marketing purposes and to test and improve the Services. Upon request, receiving Party agrees to promptly return or certify the destruction of all Confidential Information provided by the disclosing Party. The Parties agree that any violation or threatened violation of this Section 11 may cause irreparable injury, entitling a Party to seek injunctive relief in addition to other available legal remedies. b. Freedom of Information Act. IF CUSTOMER IS A GOVERNMENTAL AGENCY, THE OBLIGATIONS OF NONDISCLOSURE IN THIS SECTION 9 SHALL BE LIMITED ONLY TO THE EXTENT REQUIRED BY FREEDOM OF INFORMATION ACT LAWS OF CUSTOMER. 10. Insurance. a. Socrata shall procure and maintain, at its sole cost and expense for the duration of the agreement insurances on forms reasonably acceptable to Customer, adding Customer as an additional insured on Socrata’s standard policies as of the date of the Order, upon written request. Socrata will provide Customer prior notice of any non-renewal or cancellation of these coverages that might affect the provision of its Services under an Order. Socrata agrees to waive subrogation as to its General Liability, Auto, and Worker’s Compensation (if permitted by law), for claims arising from Socrata’s personnel. b. Socrata does not issue surety or fidelity bonds, or crime insurance, in connection with its Services. Socrata is not a construction, professional services, or consultant company developing or delivering custom code which are being installed on Customer’s software or systems, nor does it handle Sensitive Data of Customer. 11. WARRANTIES AND DISCLAIMERS. a. Socrata will use commercially reasonable efforts maintain the availability of the Platform Service of an average of 99.5% on a monthly basis, less downtime for scheduled maintenance or events beyond its reasonable control. Notification of outages are given to Customers who have opted-in to Socrata’s downtime notification system. Each party warrants to the other that they are authorized to enter into this agreement and perform their obligations herein, and (as Customer to Socrata), that funds have been approved, allocated and set aside for payment to Socrata of all fees set forth in an Order. b. EXCEPT FOR THE WARRANTIES SET FORTH IN SECTION 11(A), SOCRATA DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING, WITHOUT LIMITATION, IMPLIEDWARRANTIESOFMERCHANTABILITY,AND FITNESS FOR A PARTICULAR PURPOSE. WHILE SOCRATA WILL ATTEMPT TO MAKE THE SERVICE SAFE AND ACCESSIBLE TO CUSTOMER AND USERS, CUSTOMER UNDERSTANDS AND ACKNOWLEDGES THAT THE SERVICE IS NOT FAULT TOLERANT, NORWILLITWILLBEFREEOFINTERRUPTIONSOROTHEREVENTSTHAT ARE OUTSIDE OF SOCRATA’S REASONABLE CONTROL. THE PLATFORM SERVICE IS NOT DESIGNED TO (I) PROCESS OR STORE NON-PUBLIC ‘SENSITIVE DATA,’ OR (II) WHERE AN INTERRUPTION OF THE PLATFORM SERVICE COULD CAUSE PERSONAL INJURY (INCLUDING DEATH) OR PROPERTY DAMAGE. ANY USE OF THE SERVICES IN CONNECTION WITH THESE ACTIVITIES IS AT CUSTOMER’S SOLE RISK AND LIABILITY. 12. LIMITATION OF LIABILITY. NEITHER PARTY IS LIABLE TO THE OTHER PARTY FOR ANY INDIRECT, PUNITIVE, CONSEQUENTIAL, INCIDENTAL OR SPECIAL DAMAGES (INCLUDINGWITHOUTLIMITATION,REPLACEMENT COSTS, LOST PROFITS AND LOST DATA, INFORMATION OR CONTENT) ARISING OUT OF THIS AGREEMENT, REGARDLESS OF THE THEORY OF LIABILITY (INCLUDING NEGLIGENCE AND STRICT LIABILITY). EXCEPT FOR A PARTY’S INDEMNIFICATION OBLIGATIONS UNDER SECTION 9 (“INDEMNIFICATION”), ABOVE, OR OTHERWISE DUE TO THE GROSS NEGLIGENCE, WILLFUL MISCONDUCT OF A PARTY, A PARTY’S TOTAL LIABILITY ARISING OUT OF THIS AGREEMENT IS LIMITED TO THE AMOUNT PAID BY CUSTOMER WITHIN THE 12-MONTH PERIOD PRIOR TO THE EVENT WHICH GAVE RISE TO THE CLAIM. 13. Socrata Compliance with Laws. a. Government Purchases. Socrata must comply with all applicable federal, state and local laws and regulations that apply to Socrata and its personnel when performing under this agreement, including without limitation as applicable, any license, registration, employment, non-discrimination, anti-harassment, equal opportunity employment, minimum wage requirements, conflict of interest, and anti-bribery (gifts and gratuities laws). 14. Term and Termination. a. Term. This agreement remains in effect until all Orders (and Platform Services) have expired or terminated and Platform Services have been turned down. Unless expressly set forth in an Order, an Order does not auto-renew or require Socrata to provide Platform Services after the Order (or subscription) expiration date(s). Any renewals or expansions of the Platform Services Ordered by Customer will be subject to this agreement. b. Termination for Breach. Either party may terminate an Order, in the event the other party is in material breach of the Order or this agreement, and such breach has not been cured within 30 days of receipt of notice therefor. c. Termination for Convenience or Non-Appropriation. Customer may terminate this agreement for convenience or non-appropriation of funds with 30 days’ prior written notice to Socrata, provided, however, that all of Customer’s obligations under this agreement and Orders submitted to Socrata (including its payment obligations) prior to the effective date of termination are non-cancelable and non-refundable under this subsection (c) and will survive early termination of this agreement hereunder. d. Final Export and Return of Customer Content. Customer will have thirty (30) days to export Customer Content from the Service upon termination or expiration of the Order. After thirty (30) days, Socrata will delete the Customer Content in its system. e. Survival. Terms and conditions which by their nature survive the termination of this Agreement shall survive and continue beyond the term and termination of this Agreement, including payment, indemnification, limitation of liability. 15. Assignment of Agreement or an Order. Neither party shall assign or transfer (by operation of law or otherwise) this agreement (including any Order) or any of its rights or obligations hereunder without the other party's express, prior written consent. Notwithstanding the foregoing, a party may assign this Agreement (i) to an affiliate by providing the other party with written notice of such assignment; (ii) to a third party in connection with a merger, acquisition, divestiture or business combination involving a party or a party’s business unit to which this agreement relates where the assignee is bound by the terms of this Agreement. 16. Severability. If one or more provisions of this agreement are held to be unenforceable by applicable law, such provision shall be excluded from this agreement and the balance of the agreement shall be interpreted as if such provision were so excluded and shall be enforceable in accordance with its terms. 17. Governing Law. This agreement is governed by the laws of the state, province, or territory of Customer. 18. Miscellaneous. This agreement and each Order for the Platform Service, constitutes the entire agreement between the parties and supersede any prior or contemporaneous negotiations or agreements, whether oral or written, related to this subject matter. Neither party is relying on any representation concerning this subject matter, oral or written, not included in this agreement. No representation, promise or inducement not included in this agreement is binding. No modification, amendment or waiver of any term of this agreement is effective until signed by both parties. There are no third party beneficiaries to this agreement. Except for the payment of monies, neither party is liable for any non-performance as a result of activities beyond its reasonable control, including without limitation force majeure events. Customer agrees that any additional or conflicting terms contained in any Customer form-purchasing document are replaced in its entirety with this agreement. By submitting ideas, suggestions or feedback to Socrata regarding the Service, and Customer hereby grants Socrata a royalty-free and fully-paid license to use such items for any business purpose. Launch Deliverables Socrata Consulting and Education Teams’ deliverables include: © Copyright 2016 10 Administrator Publisher Curator Educate Activities ● Orientation to Socrata Education Program and the Socrata Knowledge Base ● Core Team Training based on recommended Education Plan ● Development of End User Training Plan and ongoing Training Plan ● Unlimited access to online training via webinars and videos ● Based on the Education Program Purchased in Order Agreement, the following additional education options are also available: ○ Instructor-led interactive virtual Education courses ○ Two (2) hours per topic session, following a set schedule optimized for US timezones ○ Unlimited course attendance ○ Two (2) on-site courses per year of your choosing ○ Topics available include: ○ Intro to Open Data ○ How to Publish Data ○ Data Readiness ○ Data Integration and Automated Publishing ○ Administration (for Apps, for Open Data, for Open Performance) ○ Advanced Visualizations and Data Storytelling ○ Dashboards and Goals creation Educate Deliverables Socrata Consulting and Education Teams’ deliverables include: ● Final Education plan by role ● Education plan communication to all team members ● Administrators and Publishers educated and ready for implementation ● Recommended End User Training Plan © Copyright 2016 8 © Copyright 2016 7