The URL can be used to link to this page

Home My WebLink Aboutresolution.council.127-17 ATTACHMENT C RESOLUTION #127 (Series of 2017) A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF ASPEN, COLORADO, APPROVING AN AMENDMENT TO THE PROFESSIONAL SERVICES AGREEMENT BETWEEN THE CITY OF ASPEN AND FEHR& PEERS AUTHORIZING THE CITY MANAGER TO EXECUTE SAID AMENDMENT ON BEHALF OF THE CITY OF ASPEN, COLORADO. WHEREAS, there has been submitted to the City Council An amendment to the professional services agreement for services to analyze the collected Air Sage cell phone data and provide a web-interactive interface, between the City of Aspen and Fehr & Peers, a true and accurate copy of which is attached hereto as Exhibit «A,,. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF ASPEN, COLORADO, That the City Council of the City of Aspen hereby approves the amendment to the professional services agreement for services to analyze the collected Air Sage cell phone data and provide a web-iriteractive interface, between the City of Aspen and Fehr & Peers, a copy of which is annexed hereto and incorporated herein, and does hereby authorize the City Manager to execute said agreement on behalf of the City of Aspen. INTRODUCED, READ AND ADOPTED by the City Counc'I of the City of Aspen on the 9th day of October 2017. Steven SkAdron, Mayor I, Linda Manning, duly appointed and acting City lerk do certify that the foregoing is a true and accurate copy of that resolution adopted by the City Council of the City of Aspen, Colorado, at a meeting held, October 9, 2017. s Linda Manning, City Clerk Attachment D Amendment to the Professional Services Agreement between the City of Aspen and Fehr& Peers approved by City Council on May 22, 2017, Resolution#91, Series 2017, amending the original contract with an additional statement of work and the compensation associated with the additional work. Statement of Work TASK 1: KICK-OFF Fehr and Peers will host a teleconference meeting with Aspen City staff to kick-off the project and develop a list of basic questions that the City would like to see answered from the AirSage data that the City has already collected.The kick-off meeting will be used to understand the City's goals in collecting and analyzing the data and Fehr& Peers will discuss what types of analyses and web-interface are possible given the data.This task will cover all coordination between Fehr& Peers and the City on available data and desired outcomes. Deliverable: Kick-off teleconference meeting & notes, including a list of basic questions the City hopes to answer through this project. TASK 2: WEB-INTERACTIVE INTERFACE Based on guidance provided by the City in Task 1, Fehr & Peers will analyze the AirSage data (all 47 zones) and develop a web-based interactive interface to display, organize and provide a summary of the data. The interface will be designed so staff can,with relative ease, find the answers to basic questions identified in Task 1 as well as use the interface to explore and discover other trends. Fehr& Peers will develop a user interface where it is possible to toggle between the possible scenarios from the provided AirSage data. Fehr& Peers will also add a feature to the interface so that users can easily print basic PDF maps of their findings. Fehr& Peers will present the interface to City staff via teleconference.This will include teaching staff how to use the application and showcasing some of its capabilities. We assume that Fehr& Peers will own the web interface and that it will be located on our servers. The City will access the interface via a web browser. Fehr& Peers will password protect the interface so that it is only accessible to those with a password. Fehr& Peers will maintain the interface on our server for one year;after a year the City will have the option to extend this maintenance for $5,000 per year. Deliverable:Web-based interactive data interface including teleconference presentation to staff. TASK 3: DATA REVIEW AND FOLLOW-UP QUESTIONS Following draft completion of the web-based interface identified in Task 2, Fehr& Peers will review initial findings with City staff(answers to questions identified in Task 1) and will follow-up with staff to see if there are additional questions staff would like summarized in the final memo. Deliverable:Teleconference with presentation of initial data findings and discussion of follow-up list of additional questions. TASK 4: TECHNICAL MEMORANDUM Fehr& Peers will summarize the outcomes.of the data analysis into a written technical memorandum.The memorandum will provide a summaryof the data analysis methodology, and key trends and findings revealed by the data, including answers to up to 12 questions City staff asked as part of Task 1 and Task 3. Text and graphics will be used to illustrate the findings.This task will also include additional data analysis to answer additional follow-up questions posed in Task 3. Deliverable:Final technical memorandum summarizing outcomes of the data analysis. Compensation TaskPrincipal Project Planner Admin. Subtotal scription Senior GIS/Web Manager/ Associate Technician Planner $225 $185 $140 $115 $150 $1 no 1 Kick-Off 1 2 4 0 0 1 $ 1255 2 Web-Based Interactive 4 20 64 6 84 2 S 33,720 3 Data Review/Follow-up 2 416 1 4 1 5,970 4 Final Technical Memorandum 3 22 48 4 4 2 16,865 10 48 132 12 92 6 . Total labor $ 57,810 Direct Costs Communications&Reproduction $ 2,190 Total Budget $ 60,000 Invoicing Invoices must be submitted to APRcitvofaspen.com and include the City's PO number on each invoice. Failure to do so may result in significant delays in processing payment. CITY OF ASPEN,COLORADO: FEHR&PEERS: � . �{/J,�-y,. [sigJaMe]�j�-1� r' [Signature] A By: [Name] ,� t-j��` [Name] Title: (V//��,,��51 G I lC h1Title: �u�1ar �sSnr ink Date: Date: City Council Approval: Date: October 9, 2017 Resolution No: (Z.I:, Series 2017 Attachment B Aspen Airsage Web Interface September 29, 2017 • What is a Web interface?A Web interface for origin-destination data allows users to view,study and interact with origin-destination data through a simple Web browser platform. • Where else has a Web interface like this been used?Fehr&Peers has developed similar Web interfaces for clients in most of our markets including Colorado, Utah, Northern California, Southern California and Seattle. • What are the benefits of a Web interface?Why not just document all of the findings in a report or technical memorandum? Fehr&Peers'scope of work includes some traditional origin-destination analysis which will be documented in a technical memorandum for the City. This will ensure that high-priority questions are investigated,answered and documented. However, in our experience with Big Data such as Airsage data,we find that by giving users full access to the data and pairing that with visualizations,users are able to identify meaningful trends that otherwise may not have been identified.The aim of this tool is to allow users to form their own hypothesis,then test that hypothesis with the data to see if previously unknown trends are revealed. • What will it look like and how will it work? See the following examples of Web interfaces using origin-destination data in Los Angeles County and bike share data from LA Metro 1. City staff and other authorized users will be able access the Web interface using a Web browser and a login 2. Once logged in, users will see polygons representing different areas of Aspen, Pitkin County and any other areas for which data was available.This example is Los Angeles County. 3. Users will be able to select polygons and immediately be provided with a visualization of what other polygons have many trips to/from the selected polygon. In this example a polygon representing Santa Monica is selected (in purple).The dark green polygons have many trips to/from Santa Monica,the light green polygons have few trips to/from Santa Monica. 4. By selecting another polygon, users will be able to immediately the difference in trips to/from the new polygon. In this example a polygon representing downtown Los Angeles is selected(in purple); note how the polygons with trips to/from downtown Los Angeles are different than those to/from Santa Monica. 5. Users will also be provided with: • A data table to summarize high-level statistics regarding trip origins and destinations. • An "easy PDF"feature so they can document interesting findings in PDF format. 6. Users will have the option to toggle between different scenarios.Some of the scenarios may include:season, month, day of week,time of day(AM vs. mid-day vs. PM, etc.), residents vs. visitors,etc.This example from LA Metro's bike share system (showing bike checkouts per station)shows drop-down menus for the different scenarios available with this dataset. In the drop-down menu selected, a user is selecting between 2016 data and 2017 data. Although we expect to use the polygon structure of the first example, the drop-down menus will be similar to this second example. r r' 7. Selecting a different scenario will result in a different visualization. In this example, notice how bike checkouts at each station compare in the AM peak period to the PM peak period. Checkouts during the AM peak period(7-10 AM) Y' Checkouts during the PM Peak period(3-7 PM)