No preview available
HomeMy WebLinkAboutRESPONSE - RFP - P940 RIDESHARE MATCHING SOFTWAREProposal for Carpool Matching Software Proposal Number: P-P940 for The City of Fort Collins May 12, 2004 WARM Environmental Scientists and Engineers, LLC 1 11 u -Walsh an ecology and en�cnt oomrzr SMARTTRIPS commuter choice The created buffer will be used to select origin points of existing carpoolers whose geographic profile is similar to the current rider/driver's. The selected candidate's information will be displayed in a form with an option for the rider/driver to email the list of potential candidates and a map of the locations to themselves. The integrated web -based carpool matching application will be accessed through the www.smarttrips.org website, but the application will be hosted on Walsh/E & E's web server infrastructure. The look and feel of the application will match the SmartTrips website so that it will be a seamless transition from one website to another. Extensive reporting capability as well as the ability to produce mailing lists and labels will be available to administrative users regardless of physical location or computing platform. TASK 3 - TRAINING AND DEPLOYMENT Walsh/E & E will provide training for the SmartTrips staff on how to use the application and how to perform administrative functions, including database management, reporting or producing mailing labels. The application would be developed in a testing environment where SmartTrips staff will have continual access to the monitor application as it is being developed. After thorough final testing of the integrated application has been conducted, the application will be migrated onto hosting server where the system would become live for users. SmartTrips staff will be provided an illustrated administrator's user guide --- -------- as well as two hall' days of on -site training over a period of three days. This approach allows for an intensive hands-on training during the first half -day session and some time for SmartTrips staff to use the site and explore the administrative capabilities before continuing the training The second half -day session would be an interactive question / answer session driven by staff needs. An online user's guide and FAQ would accompany the site. It is our belief that our proposed development approach will reduce the need for an extensive post - development training as the SmartTrips staff will be consistently involved in the development of the application throughout the project. As part of our proposed maintenance package, SmartTrips staff would have access to Walsh/E & E PMs and developers should questions arise regarding the use of the carpool matching application over a 5-year time period. All hardware and software upgrades, licensing fees, and maintenance would occur on Walsh/E & E servers and would therefore also be covered under this plan. SmartTrips staff would only be responsible for administrative functions including reporting and the maintenance of database records. Commercial GIS data layers (e.g., centerlines will be updated on an annual basis. DELIVERABLES 1. Project Plan 2. Converted database 3. Integrated, web -based carpool matching application (including relational and spatial components) 4. On -site training and user's guides (administrative and public) 5. Hosting and maintenance package 2. ASSIGNED PERSONNEL Walsh/E & E has carefully chosen a Fort Collins -based Project Management team to manage project tasks and work directly with SmartTrips staff. Additionally, we have selected database and GIS-related applications developers with extensive municipal_ experience from our Headquarters to do the application development and training. 5111/2004.Carpool_Matching_App-Ft-Collins-NFRMPO-proposalv6.doc Page 6 M =Walsh SMARTTRIPS m ecology end rnvironmrnt company commuter choice John Armstrong AICP — Project Manager We are proposing Mr. Armstrong as lead consultant and Project Manager on this project. He will be on - site during the project kick-off, as well as working with our developer staff to recommend modifications and an approach for both projects. Mr. Armstrong has a long history of using and applying GIS, project facilitation, and management skills. Mr. Armstrong is a certified planner with nine years of GIS and planning experience. His planning strengths include natural resource, land use and transportation planning, ecological management and applied landscape ecology; watershed, landscape, and conservation planning; facilitation of public involvement (including collaborative planning processes), information management and Internet applications. He has managed a variety of projects for local and federal clients. This includes work in Larimer County including county -wide conservation plans and watershed -based landscape assessments. For the past nine years, Mr. Armstrong has developed and used geographic information systems utilizing ArcGIS 8.1 (ArcView and Arch►fo), Archifo, GRID, TIN, ArcPress, ArcView, Spatial Analyst, 3D Analyst, Atlas GIS, and GRASS. He also has experience with remote sensing, mobile mapping and GPS technologies. Mr. Armstrong has worked on a variety of GIS-related projects for Colorado and New Mexico municipalities and counties. As a GIS Specialist for the City of Boulder Mountain Parks, he developed the GIS component of a forest vegetation mapping effort that served as the basis for forest management. Mr. Armstrong also helped develop a weed mapping GIS database along transportation routes for the City of Boulder. He also developed county -wide voluntary conservation plans for El Paso and Eagle • Counties. Both planning processes were GIS-based, relying on the analysis of complex spatial relationships to develop conservation strategies within a collaborative process. While at the University of New Mexico, Mr. Armstrong developed a GIS-based watershed management plan as part of community - based effort to manage local watersheds. Greg Coniglio — Senior GIS Developer Mr. Coniglio is an ESRI programming professional with eight years experience. He has a played a key role in the development of dozens of ArcIMS Internet sites, projects involving other types of GIS computer programming, and cartographic mapping. He has developed hundreds of Avenue, AML, and Visual Basic programs to provide clients with customized GIS solutions. His GIS skills include ArcObjects, ArcIMS (customizations using HTML and Javascript), Map Objects, VBA, ArcEdit, Librarian, AML, GRID, Visio, Spatial Analyst, Network, and 3D Analyst. His operating system experience includes VAX VMS, IBM AIX, Sun UNIX, MS DOS, Macintosh, and Windows 3/1/9x/NT/2000/XP. His programming languages include Javascript, Visual Basic (VB), ARC/INFO Arc Marco Language, and ArcView Avenue. He has considerable experience in training clients in the use of GIS, both in custom, "hands-on" settings and in training courses authorized by ESRI. For the Town of Amherst, NY, Mr. Conigho developed user-friendly maintenance routines for tax parcel base maps. He interviewed staff of the towns of Tonawanda, NY, Grand Island, NY, and Boston, MA, to determine GIS system user needs, then recommended and created user applications based on the interviews. He compiled reports and developed application description forms, application and data matrix tables, and data flow diagrams. He provided Visual Basic and Avenue programming, as well as user consultation, for GIS applications for Erie County, NY, the towns of Victor and East Bloomfield, NY, and Mount Calvary Cemetery. He also conducted data conversion, training, and map plotting for the City of Olean, the Town of Penfield, and over 20 private -sector clients. 5 /1112004.Carpool_Matching App-Ft_Collins-NFRMPO-proposalv6.doc Page 7 -Walsh an ecology aid mn imnmwt company SMARTTRIPS,. commuter choice Renee Walmsley — GIS Specialist/Functional Manager Ms. Walmsley is a GIS Specialist with 5 years of experience. She specializes in using GIS, GPS, 3-D modeling, satellite imagery, and aerial photography to assess environmental and socioeconomic factors both domestically and internationally. Ms. Walmsley is currently pursuing a master's degree in Project Management. She has worked on dozens of environmental projects throughout the United States as well as in Peru, Yemen, Albania, Trinidad and Tobago, and Ecuador. Ms. Walmsley is proficient in all ESRI software including ArcScene, ArcPad, ArcView, and ArcMap as well as ENVI, Imagine, Adobe Photoshop and Corel Draw. Derek Amerlinck — GIS Developer Mr. Amerlinck has four years' experience with Object -Oriented GIS desktop and Web client/server applications. His background encompasses all aspects of the application development life cycle, including requirements specification; design documentation; and application development, testing, and technical support. He is well versed in the analysis and cartographic presentation of geographic data to support project decision -making. His technical skills include programming in ArcObjects, ArcXML, ASP, ASP.NET, Avenue, HTML, Javascript, Map Objects, SQL, Visual Basic (VB), VBA, VBScript, and VB.NET. His broad background in GIS programming and analysis has given him proficiency in the use of GIS software including, ArcGIS, ArcFM, ArclMS, ARC/INFO, ArcPAD, ArcSDE, and ArcView 3.x. As a GIS programmer/analyst for the City of Riverside, CA, Mr. Amerlinck was responsible for developing, administering, and promoting the City's GIS Web applications. To support the redistricting of City Council ward boundaries, he developed a multi-user ArcIMS intranet site that allowed the redistricting committee to log in, create, save, print, and recall various redistricting scenarios while keeping track of population percentages for each ward; he also was the committee's GIS technical advisor. He created a variety of customized ArcIMS applications for municipal property profiles, site locations, historic resources, and infill eligibility. Mr. Amerlinck converted the City of Riverside's Avenue and ArcView 3.x applications into the ArcObject and ArcGIS 8 environment. He also was the lead technical specialist for the public works initiative to develop a field application that would streamline the code violation inspection process. His ArcPAD application cut the time needed to perform the inspections in half. Additionally, he rewrote and managed the Access database used to track planning requests and enhanced and managed the Historic Resources Inventory Database, also in Access. The database won a series of prestigious awards, including the Outstanding Award for Innovative Use of Technology (American Planning Association, Inland Empire); the Outstanding Award for Innovative Use of Technology (American Planning Association, California Chapter, California Preservation Foundation); the California Governor's Award for Excellence in Historic Preservation; and a Certificate of Appreciation (City of Riverside). Mr. Amerlinck routinely installed and upgraded system software, and provided training on various GIS applications. Maria Viana — IT Developer Ms. Viana manages and participates in the development, processing, and maintenance of Walsh/E & E's project -specific and corporate environmental management information systems; computer -assisted communication networks; and work, cost, equipment, and schedule tracking systems. She has developed a variety of secure websites to facilitate project data management and information exchange. For DOI's Minerals Management Service, Ms. Viana developed the website used to handle private and public comments addressing the use of floating production systems in the outer continental shelf. 5/1112004.Carpool_Matching App-Ft_Collins-NFRMPO-proposalv6.doc Page 8 =Walsh = otology and eav nmmt company SMARTTRIPS commuter choice Andy Mehalick — Web Developer Mr. Mehalick participates in the development, processing, and maintenance of Walsh/E & E's computer - assisted communication networks and work, cost, equipment, and schedule tracking systems. He develops Internet -based project management systems for both internal and external use, with the objective of increasing project efficiency through information management and distribution. For the Air Force Reserve Command (AFRC), Mr. Mehalick was a key contributor to Walsh/E & E's development of a centralized data repository of environmental management databases that provide accurate, "real-time" information to support linked Internet documents. He helped formulate the Web site conceptual model (including back -end site file structure and coding standards); developed the site's design template; initiated the database transition from stand-alone personal database software to enterprise -level database software; and developed and implemented the security model for site authentication. 3. AVAILABILITY 3.1 Key Personnel Availability While Walsh/E & E's GIS department has a solid workload, there is ample availability to service the City of Fort Collins. Walsh/E & E is able to make this commitment due to the local presence of a large GIS and IT resources. Key personnel for this project will be available on average the following amount of time for this project: Key Personnel Task Time devoted to this project John Armstrong Project Management 40% Greg Coniglio Application Development 45% Renee Walmsley Project Management / GIS 40% Derek Amerlinck Application Development 50% Maria Viana IT Development 30% Andy Mehalick Web Development 30% During critical project phases, the team's key staff will be able to devote 100% of their time to this project. Additional Resources In addition to our staff of over 60 professionals in Colorado, we have approximately 1,000 technical specialists that can be tapped including biologists, ecologists, planners, community relation specialists, hydrologists, soil scientist, civil engineers, landscape architects, wetland specialists, asbestos -lead based pant specialists, emergency responders, and homeland/security specialists. Because we have people who are specialists in each of the areas above and have experience with Colorado Front Range municipal governments, we are able to rapidly answer specific questions regarding the city's potential use of these customized GIS applications. 3.2 Northern Colorado Front Range Office It is important to note that Walsh/E & E has a Northern Colorado Front Range office located in the City of Fort Collins. In addition, several Walsh employees live in Fort Collins, including Mr. Armstrong (Project Manager). Mr. Armstrong will be available to the Smart Trips Staff at least one morning per week, as specified in our approach. Our team will be able to cost effectively meet at your Fort Collins office, at your request. 5/1112004.Carpool_Matching_App-Ft_Collins-NFRMPO-proposalv6.doc Page 9 =Walsh SMARTTRIPS„ commuter choice m ecology and mvimmnmt company 3.3 Project Schedule A project schedule outlining a proposed time frame for this project can be found in the Gantt chart on the following page. Our team firmly believes that our close proximity to the City of Fort Collins combined with a highly skilled GIS group will enable Walsh/E & E to service the City of Fort Collins in a timely and efficient manner. 511112004.Carpool_Matching_App-Ft_Collins-NFRMPO-proposalv6.doc Page 10 Proposal for Carpool Matching Software City of Fort Collins Page 1 -Walsh an ecology wd mvnro mt company SMARTTRIPS commuter choice 4. MOTIVATION 4.1 Experience with Internet Mapping The development of customized Internet and enterprise intranet mapping applications for our customers is a predominant service of the rr/GIS group. Our GIS Developers have a wide range of programming skills and a selection of the latest developer's tools to design, develop, and deploy applications ranging from stand-alone data viewers, to secure Web -based solutions, to enterprise -wide GIS. Our applications focus on the link between data stored in large databases and data stored as geo-spatial information. Some of the key features of a web -based mapping application are: ■ Access spatial data via a user friendly web -based GIS interface, allowing the user to better understand a project area, implement visualization strategies, and query and report spatially -related data; • Live -link from spatial locations to relevant documents or photos about a particular area; • Geocoding features (i.e. Finding a location by entering its addresses); and • Downloading GIS data layers from the map interface. We work closely with our clients to conduct thorough needs assessments to outline the features, processes, data requirements, user profiles, and deployment considerations necessary to optimally complete a project. Our is experienced in implementing a variety of web -based mapping solutions — from local government projects to highly customized and large-scale ventures. Walsh/E & E's enterprise level intemet mapping applications are developed to interact with wireless mobile mapping devices, corporate databases, and document management websites to create a seamless and robust solution that meets the unique needs of our clients. 4.2 Experience with Web Development Walsh/E & E has ap&d Web software and technology on a wide variety of rp oiects to improve efficiency and communications, ensure compliance with environmental regulations, facilitate public participation, and coordinate tasks and activities. We develop and maintain Web sites to support emergency response services, environmental forensics, litigation, remediation projects, and the preparation of environmental impact statements for domestic and international government and commercial clients. Our web services provide many benefits to our clients including centralizing and standardizing information, enhancing project communication and interoperability with existing systems, eliminating duplication of data, and improving development of deliverables. 4.3 Experience with Municipal Planning Organizations Walsh/E & E provided customized GIS/ESRI training to the New York State Municipal Planning Organization (NYSMPO). We initiated this project by holding a kick off meeting, setting goals, and developing an Walsh/E & E created this interview strategy. The results from the interview process and subsequent ArcGIS Custom Training Needs Assessment resulted in a detailed training program for the Manual for the New York State Municipal Planning 511112004.Carpool_Matching App-Ft_Collins-NFRMPO-proposalv6.doc Page 11 -Walsh an ecology and envssmment cnmpmy SMARTTRIPS commuter choice Organization, which includes 13 New York State Municipal Planning Organizations. The project involves customized GIS training provided to municipal planning organizations across the New York State. The courses were written with the GIS datasets used on a daily basis by these the NYSMPO agencies and instruct specifically towards their specific uses of GIS technology. Slides, training sessions, and exercises using "real world" examples were the foundation to the training course elements. Five courses have been developed: Introduction to ArcGIS, Advanced ArcGIS, Cartography with ArcGIS, Introduction to Visual Basic for ArcGIS, and Advanced Visual Basic for ArcGIS. E & E staff is developing the course materials, and also teaching the courses at various locations throughout New York State. 4.4 Providing Quality Service to the Cities of Fort Collins, Greeley, and Loveland Continuing to provide quality service to the cities of Fort Collins, Greeley and Loveland is important to us. Over the years, we have performed a wide variety of services for the cities and have formed a solid reputation and working relationship with each. The City of Fort Collins: Since 1997, Walsh/E & E has completed nearly 100 different projects for the City of Fort Collins, successfully completing all on time and on or under budget. We have completed many projects in the key service areas of the General Environmental Services Contract. We have a strong knowledge of the city of Fort Collins workplace, geography, and community. Some examples include: Walsh/E & E mapped, surveyed and delineated wetlands boundaries at the SouthRidge Golf Course using GIS. Walsh/E & E also prepared and submitted the appropriate documents for the Army Corps of Engineers. Walsh/E & E has completed over 40 different Phase I Environmental Site Assessment (ESA) projects for the City of Fort Collins, providing ESAs on approximately 200 properties. Walsh/E & E has provided ESAs on large areas, including Timberline Avenue Extension Project, the Lee Martinez Development, and the Downtown River Corridor. Walsh/E & E has provided Phase I ESAs on numerous commercial properties, including former service stations, the former Ricker Brothers Warehouse, and the Poudre Valley Creamery. The City of Greeley: Walsh/E & E conducted asbestos and lead -based pain inspections for the entire campus of the University ` of Northern Colorado in Greeley. The total inspected area was over 1.8 million square feet and encompassed over 80 buildings, including dormitories, classrooms, offices, and other university facilities. After completing the inspections, Walsh/E & E was retained to perform the remediation design and abatement oversight for numerous campus buildings. Walsh/E & E provided a data management system that utilized ADAM software to track and estimate abatement projects as well as provide ACM identification and condition assessment information for reinspection and long-term material management. Walsh/E & E technicians with specialized training in the use of the ADAM system imputed data generated by the inspections. Data entry took place on dedicated PCs in the Walsh office and was supervised, monitored and subject to QA/QC review by the project manager and software specialists. As the asbestos inspections for buildings were completed and data were entered, analyzed and finalized Walsh/E & E delivered sections of the database to UNC electronically or via CDROM. 511112004.Carpool_Matching_App-Ft_Collins-NFRNPO-proposalv6.doc Page 12 "II i -Walsh an momgy and en�imammt company SMARTTRIPS commuter choice The City of Loveland: Walsh/E & E has provided the City with a variety of environmental services over the years. Currently, under an Environmental Clean-up contract for the City, Walsh/E & E is involved in a petroleum release, CDLE-Oil and Public Safety Project for the City of Loveland/Thompson School District Service Center. For the Madison Avenue Apartments in Loveland, Walsh recently conducted an Asbestos Abatement Project Oversight and Air Monitoring project. Walsh/E & E recently completed a Petroleum Above -ground Storage Tank Closure Project at the Loveland Municipal Airport in (Fort Collins). Also under this contract Walsh/E & E performed a Site Assessment at the Loveland Utility Corridor. Additional project experience for the City includes performing lighting waste characterization at the City of Loveland solid waste facility at 105 West 5th Street in Loveland, and completing a sound level survey at a facility in Loveland. 4.5 Understanding the Needs of Colorado Front Range Municipalities Our project teams understand the needs of Colorado municipalities -- during the past 10 years, 60% of our work in Colorado has been for Front. Range.=Dicipalities. We currently hold multi -year contracts with the Cities of Fort Collins, Loveland, Longmont, Boulder, Denver, Aurora, Arvada, Westminster, and Colorado Springs. We have also worked with most municipal departments, including planning, transportation, health, public safety, utilities, parks, open space and recreation, and many others. Representative municipal development projects that we have completed in Colorado include: ➢ Acquisition of new lands ➢ Roadway construction ➢ Acquisition for parks/open space ➢ Brownfields redevelopment ➢ Environmental Site Assessments ESA) ➢ Emergency response and clean-up ➢ RCRA and OSHA audits and consulting ➢ Hazardous waste clean-up ➢ Construction monitoring ➢ Asbestos and Industrial Hygiene construction (Phase 1 and II) ➢ Ecological Planning ➢ GIS / IT / DBMS 5. COST AND WORK HOURS Please find Walsh/E & E's proposed cost and work hours on the attached spreadsheet. Given our past experience on similar projects, we feel that the work hours we have presented are reasonable for the effort required in each project task. 5111/2004.Carpool_Matching App-FL_Collins-NFRMPO-proposalv6.doc Page 13 t SmartTrips A%a�j Carpool Application Cost Estimate Detail ($US) 5/12/2004 Task 1: Task 2: Task 3: Project Work Plan & Application Training & Kick Off Develo ment Deployment Name Responsibility Rate Hours Total Hours Total Total John Armstrong DerekAmerlink Project Manager Senior GIS Developer $95.00 $95.00 24 32 $ 2,280 $ 3,040 50 $ 4,750$ 80 7.600$ rHours 2,850 760 $ 7,350$ AndrewMehalick Senior Application Developer $105.00 10 $ 1,05070 Greg Conigllo Maria Vlana SeniorGISDeveloper Data Management Coordinator $105.00 $105.00 32 $ $ 3,360 40 $ 4200$ 60 $ 6,300$ 840 � d__._W._s _® _-_� Renee Wamsley-� Functional Manager- $75.00 20 _.__- $ 1,500 40 $ 3,000 20 $ 1,500 - 66 $ 5,950 Labor Subtotals 118 $ 11,230 340 $ 33,200 Other Direct Costs Per diem/lodging — Round Trip Airfare Rental Car Maintenance Costs Street Center Line Data Acquisition Year 1 Street Center EmeData Acquisition Year 2-5 Ongoing Maintenance and Support_ ODC Subtotals Unit 4 2 2 --- ;y Buffalo- - -- qy $115 $275 $75 $ 460 $ 550 $ 150 ---- 2 1 2 ----- - �$_ 230- f $ 275 j $ 150 --__0 0 -0 $ $ $ Unit J $3,900 -; _-- $ $ $ $ -1,160 1 4-_..$ _ ._. $ - I $ 3,900 7,800 $ - 'er Year ` -- ---- $ - $ - mr $1,950 is $150 $ I $ 12,355 60 $ 9,0 $ 9,0 15.00% $ 174 $ 1,853 $ 1,3 Assumptions: 1. The contract will be on a time -and -materials, not to ex` teed basis. 2. The travel costs are estimated based on a 14 day advanced purchase round trip airfare from Buffalo to Denver, Per Diem/Lodging for 2 nights in Boulder, CO. 3. Walsh assumes no responsibility for the accuracy of Street Centerline provided by TeleAtlas. 4. Walsh assumes responsibilty for hosting and maintenance of Web Server. 5. We assume that to meet the due date of August 31st, the project kickoff will be by June 15, 2004. l 7F' Walsh Environmental, LLC. Confidential 5/11/2004 Proposal for Carpool Matching Software Proposal Number: P-P940 ' for The City of Fort Collins and SmartTrips S MtARTTR I PS commuter choice City of Fort Collins May 12, 2004 Prepared for: Mr. James B. O'Neill H, CPPO, FNIGP Director of Purchasing & Risk Management 215 North Mason Street, 2nd Floor Fort Collins, Colorado 80524 A Submitted by: kevirikuluvar 4888 Pearl East Circle, Suite 108 Boulder, CO 80301-2475 (303)443-3282 ��aISh an ecology and environment company 51112004.Carpool_Matching App-Ft_Collins-NFRMPO-proposatv6.doc Page ii Wi , -Walsh an ecology end cnviron t camipany SMARTTRIPS commuter choice 6. FIRM CAPABILITIES 6.1 Experience on Previous Projects Walsh/E & E has successfully conducted a number of GIS projects for municipalities that include many of the same technical elements that will need to be addressed in this assessment. Descriptions of several of these projects are provided below. Development of Web -Based GIS for Statewide Environmental Assessment Projects and GIS Training - Illinois DOT Walsh/E & E's GIS staff is currently developing a Web -based Extranet GIS for the Illinois DOT to display and analyze environmental information associated with major transportation projects statewide. The initial information contained within the Web site will serve the information needs of Illinois DOT for its environmental assessment and other projects. However, the Web site —along with its underlying GIS, database, and server architectures —also are intended to be expandable in order to serve as the basis for the Illinois DOT's interdepartmental system across multiple agencies for the State of Illinois. Our GIS specialists are developing a customized GIS based on ArclMS software that will handle all programming i E has used a variety of .prograing languages to customize required functionality for Illinois DOT staff. The ArcIMS GIS GIS databases for government clients. software (Internet Map Server) will enable Illinois DOT This example shows an ArcIMS representatives to view interactive, application created for the Illinois r Department of Transportation. ,It]Techno statewide maps showing their ➢ 'ArcIMSlIVIS s districts, roads, and highways; along with the locations of sites significant to ➢ ArcIllinois DOT construction projects (e.g., maintenance facilities, highway ➢ ArcGIS authority agreements, preliminary environmental site assessment reports). As ➢ Javascript part of this project, we are designing a customized GIS training class for ➢ XML Illinois DOT staff to efficiently use the developed system. 511112004.Carpool_Matching_App-Ft_Collins-NFRMPOyroposaiv6.doc Page 14 A.' ---Walsh an ecology and environment company SMARTTRIPS commuter choice GIS-Based Data Management and Hazardous Materials (HazMat) Training Module, Air Force Reserve Command (AFRC), Nationwide. Walsh/E & E is providing the full scope of environmental and GIS services at all 12 AFRC installations nationwide, ranging from environmental impact analyses to GIS/database management support. AFRC e '[hnoCagy ➢Mobile Mapping ➢C++ ➢ArcIMS ➢Visual Basic ➢ArcPad GIS specialists developed a customized, Oracle -based GIS, using ArcIMS, to synchronize and subsequently display environmental information collected through the use of a Web -based tracking system, in order to compile hazardous material inventories for each AFRC installation. We converted data into GIS and Web -based formats; developed a hazardous material GIS and Web -based data management system; and integrated the hazardous materials system with AFRC's existing data structure and Web system. We also developed and hosted Intranet -based solutions for environmental For the Air Force Reserve Command, Walsh/E & E created a custom mobile mapping data management and warehousing; developed Personal Digital application by using Visual Assistant (PDA) applications using GIS (ArcPad), Visual Basic, Basic and C++. and C++; programming languages for field data collection; and provided training to AFRC staff in the effective and efficient use of the GIS-/Web-based applications. Our GIS/IT specialists designed and implemented a database tracking system that resulted in a 90% reduction in annual groundwater and surface water monitoring costs. We also designed a Web site and provided data management support for the development of multiple environmental databases and related Web -format documents residing in a centralized data repository accessible to AFRC personnel for accurate, "real-time" information. To help AFRC improve its strategic information management, project staff reviewed information resources and existing databases at AFRC Headquarters and interviewed Headquarters management staff. In addition, we prepared a report that contained recommendations for additional GIS/information technology improvements and Web -based management systems. Citywide Asset Logistics Management System (CALMS) for the New York City Office of Emergency Management. Walsh/E & E developed a comprehensive resource management system that inventories assets such as facilities, fleet, personnel, contracts, and equipment and supplies. Walsh/E & E created a comprehensive facility inventory for OEM's shelters, Points of Dispensing, and staging areas for use during emergencies. Data contained within CALMS 511112004.Carpool_Matching_App-Ft_Collins-NFRMPO-proposalv6.doc Page 15 -Walsh =wologyandmvkm twmpmy SMARTTRIPS commuter choice is linked to a GIS system, which visually displays the resource data with information such as the locations of police departments, fire departments, hospitals, and other critical facilities. GIS Data Management for Roan Plateau RMP/EIS for BLM, Western Colorado Walsh/E & Eis currently preparing a Resource Management Plan (RMP) and developing an associated EIS for the Roan Plateau planning unit in Colorado. The planning area comprises 73,602 acres in western Colorado. As part of this process, Walsh/E & Ehas developed a GIS to manage dozens of layers of land use, environmental, mineral rights, and other types of data. This has included the incorporation of satellite images and aerial photographs, and digital elevation models. ® m 01 o � s I 4 m m © >f m Walsh/E & E designed a project management web Walsh/E & E created a GIS and imported data from a variety of sources to assist with land site to provide BLM with a secure and confidential use planning in the Roan Plateau, Colorado Internet site for reviewing data on line and area for BLM. This example shows an exchanging information among the project team. Use automatically generated land use map of the of the web site reduces the need for numerous hard- study area. copy document revisions, cuts turnaround time on deliverables, and reduces BLM's costs while improving quality. The project management web site is separate from the Web site used for the public input process and is used to provide easy, self -conducted dissemination of the most up-to-date information to BLM and members of the project team. 'GIS Development and Data Management for California Gulch CERCLA Site, Leadville, Colorado Walsh/E & E performed numerous studies for ASARCO at the California Gulch site in Leadville. A major portion of the work was a Remedial Investigation (RI) to evaluate the impacts of historical smelting operations. Walsh/E & E collected and interpreted data, including historical information, an air dispersion model, and metal concentrations in soil samples from 700 locations. GIS and statistical techniques were employed to map soils with a geochemical signature characteristic of smelter emissions. Our findings were integral in apportioning liabilities in the settling of this Superfund site litigation. Our client, ASARCO, needed a way to store and analyze voluminous data generated during years of site investigations at a mining Superfund site in Colorado. We developed and maintained an extensive sample logging and tracking database for ASARCO that catalogued several thousand locations with multiple samples and multiple analyses. Walsh/E & E incorporated all data into a GIS to facilitate integration of laboratory data with CADD maps and digital aerial orthophotography. A forensic geochemistry model using the data determined potential sources of contamination by metals; metal concentration contours were integrated with topographic and aerial photographic data and analyzed for potential fate and transport. 511112004.Carpool_Matching_App-Ft_Collins-NFRMPO-proposalv6.doc Page 16 w =Walsh an ecology and environment company SMARTTRIPS commuter choice 6.2 Established Relationship with ESRI Walsh/E & E has an outstanding relationship with ESRI. Walsh/E & E is an ESRI Business Partner and employs ESRI- authorized trainers. We were recently awarded "New Business Partner of the Year" by ESRI's Boston office, an award we accepted at the 2003 ESRI International Business Partner Conference in Palm Springs, California. $PC 2-003 New Qart..er of TLe Yewr From the onset, Walsh/E & E's GIS group has enthusiastically At the 2003 ESRI Business Partner incorporated new ESRI software into its projects. One of the Conference, ESRI honored us with its examples of Walsh/E & E's integration of ESRI "New Business Partner of the Year more recent exam p � award. software is in ArcPad development and beta testing. Walsh/E & E designed and developed a customized ArcPad solution that works in conjunction with a GPS unit and barcode scanners. Walsh/E & E is successfully using this application to perform data gathering in the field. In addition, as a result of our participation in ESRI's on-line forums and user resources, several companies have sought our advice regarding recent versions of ArcView, ArcWO, ArcIMS, and ArcPad software; SDE; and the development of innovative, customized GIS applications. As a result of this experience, ESRI invited Walsh/E & E to jointly prepare an ArcPad "white paper" on the application of these technologies to environmental projects. Walsh/E & E's close relationship with ESRI will benefit the SmartTrips program and the Northern Front Range communities it serves by leveraging ESRI technologies. Due to our intimate ESRI product knowledge, we are well aware of most software bugs, we stay on the forefront of product updates and enhancements, and we can recommend innovative uses for ESRI software products. In addition, our ESRI instructors always receive updates on the latest software and undergo re -certification whenever new products are introduced. 7. ADDITIONAL RESOURCES Walsh/E & E's public website portfolio includes: ` Avon Parks: Peacebridge: Region 10 Regional Response Team: Orion: Cabrillo Port: Minerals Management Service: Efaircraft: ConocoPhillips: Chautauqua Wind: BLM Roan Plateau: httD://www.avOnnarks.ene.com http://www.peacebrid eg x.com http://www.rrtlOnwac.com http://www.orion.ene.com http://www.cabrilloport.ene.com http://www.mms.ene.com http://www.efaircraft.ene.com http://www.conocophillips.ene.com h_ttp://www.chautauguawind.ene.com http://www.roanplateau.ene.com 5/1112004.Carpool_Matching_App-Ft Collins-NFRMPO-proposalv6.doc Page 17 I n r r n C 11 W I r May 12, 2004 Mr. James B. O'Neill II, CPPO, FNIGP Director of Purchasing & Risk Management 215 North Mason Street, 2nd Floor Fort Collins, Colorado 80524 SUBJECT: Proposal for Carpool Matching Software for the City of Fort Collins and SmartTrips Dear Mr. O'Neill: Walsh Environmental Scientists and Engineers LLC, the Rocky Mountain Division of Ecology & Environment, Inc. (Walsh/E & E) is pleased to submit this proposal for developing Carpool Matching Software for the City of Fort Collins and SmartTrips. As a broad -based environmental and engineering consulting firm, Walsh/E & E has established and maintains a dedicated, full -service Information Technology and Geographic Information Systems (TT/GIS) department to ensure effective management of geospatial data. Our TT/GIS department is equipped with the most technologically advanced computer hardware and software available and staffed with IT and GIS specialists with experience in supporting a variety of programming, development, transportation, and sustainability projects. We would like to introduce a summary of our qualifications: ➢ We have an office in Fort Collins, which combined with its regularly scheduled visits by our Boulder - based project staff and our 24/7 availability, ensures provision of timely and efficient service. ➢ We are offering an efficient and maintenance free approach to this project, where Walsh/E & E will w�l host the proposed website and application, as well as manage the data acquisition, server maintenance, and software upgrades. ➢ A clear understanding of Municipal Planning Organizations and how multiple departments benefit from an easy to use, web based applications for the transfer of data, knowledge, and reports. ➢ An established relationship with the Environmental Systems Research Institute (ESRI), which enables us to keep the SmartTrips apprised of the latest software enhancements and bug fixes. In 2003, ESRI voted Walsh/E & E "New Business Partner of the Year." ➢ Over 15 years of experience with Colorado municipalities including several multi -year contracts with the Fort Collins, Loveland, Longmont, Boulder, Denver, Aurora, Arvada, Westminster, and Colorado Springs. ➢ Over 15 years of experience with CDOT providing a variety of innovative services. If there are any questions, please feel free to call me at any time at (303) 443-3282 or e-mail me at kkuluvar@ene.com. Sincerely, Kevin Kuluvar Walsh/E & E W[ -Walsh an ecology and envitmmcnt company SMARTTRIPS commuter choice TABLE OF CONTENTS INTRODUCTION.............................................................................................................................................. I 1. PROJECT APPROACH.......................................................................................................................... 2 2. ASSIGNED PERSONNEL...................................................................................................................... 6 3. AVAILABILITY...................................................................................................................................... 9 3.1 Key Personnel Availability................................................................................................................... 9 3.2 Northern Colorado Front Range Office................................................................................................ 9 3.3 Project Schedule................................................................................................................................. 10 4. MOTIVATION........................................................................................................................................II 4.1 Experience with Internet Mapping......................................................................................................11 4.2 Experience with Web Development....................................................................................................11 4.3 Experience with Municipal Planning Organizations........................................................................... I I 4.4 Providing Quality Service to the Cities of Fort Collins, Greeley, and Loveland ................................ 12 4.5 Understanding the Needs of Colorado Front Range Municipalities................................................... 13 5. COST AND WORK HOURS................................................................................................................ 13 6. FIRM CAPABILITIES.......................................................................................................................... 14 6.1 Experience on Previous Projects........................................................................................................ 14 6.2 Established Relationship with ESRI................................................................................................... 17 7. ADDITIONAL RESOURCES............................................................................................................... 17 5/112004.Carpool_Matching_App-FLCollins-NFRMPO-proposalv6.doc Page ii -Walsh an ecology and environment company SMARTTTRIPS commuter choice INTRODUCTION PROPOSAL FOR THE CITY OF FORT COLLINS AND SMARTTRIPS Carpool Matching Software Development Walsh Environmental (Walsh /E & E) is the Rocky Mountain Division of Ecology and Environment. Walsh/E & E is an environmental consulting firm founded in 1979 that provides services in the USA and internationally. We employ nearly 1,000 professionals, including scientists, engineers, planners, architects, and construction managers, GIS professionals, application developers, and serve public and private clients through a network of 22 offices across the United States and more than 25 locations worldwide. Our Rocky Mountain operations are headquartered in Boulder, with a full time staff of 60 employees, and regional offices in Fort Collins, Grand Junction, and Colorado Springs, Colorado. We employ over 30 IT professionals, including 15 GIS specialists, that provide unique services to municipalities throughout the United States. Our GIS staff consists of programmers, analysts, and technicians. Our IT staff includes application developers and network system administrators. Many of our GIS analysts and programmers hold advanced degrees and specialize in ArcIMS, ArcSDE, and ArcPad applications. In addition, we have ESRI-certified GIS training instructors on staff. Walsh/E & E's staff of GIS specialists will be supported by additional IT staff members, including application developers who specialize in customized Web site design and hosting. These IT specialists are responsible for Web and database development projects and the creation of stand-alone Windows applications. Walsh/E & E currently hosts over 50 secure client Web sites, most of which are used to manage vast amounts of analytical, financial, environmental, and biographical data. Walsh/E & E has managed contracts and conducted projects for federal, state, and local agencies for over 30 years. In 2001, Engineering News Record ranked our company 51st in the top 200 A-E firms with annual revenues of approximately $100 million. ENVIRONMENTAL STEWARDSHIP PROGRAMS Walsh/E & E encourages its employees to be environmentally responsible through participation in both corporate and FPA'S tXZ?MP0fUt3017 publicly sponsored programs, including the use of recycling pafthm ftseds bins for home and office paper, plastic, and glass products; energy conservation; a monetary incentive program for It Pays to Carpool carpooling, bicycling, and walking to and from work; and 4INs involvement in programs that sponsor environmental gym. , such as the federal Adopt -a- rraW Otf�ti0n CERTIFICATE OF maintenance and cleanup, P Par41ers RECOGNITION Highway program. t j bn in Como* This commitment is reflected in Walsh/E & E's receipt of a A'�"" Certificate of Recognition from EPA for its innovative work aiwraeaa aatir..�r'i ,u��ww..a an�wrrw in transportation improvements. The award was for the "It Pays to Carpool" program, which encourages employees to EPA recognized Walsh/E & E for its walk, bicycle, carpool, and use mass transit to get to work. contributions to energy efficiency and Since inception, the program has reduced over 25 million corporate carpool incentive program. passenger miles traveled, eliminating the emission of 1.2 million pounds of carbon monoxide, 100,000 pounds of oxides of nitrogen, 170,000 pounds of hydrocarbons, and over 10,000 tons of carbon dioxide to the atmosphere. 5/112004.Carpool_MatchingApp-Ft_Collins-NFRMPO-proposalv6.doc Page 1 =W SMARTTRIPS ��olosr .a M�,®mt con1nmr commuter choice 1. PROJECT APPROACH PROJECT UNDERSTANDING AND OVERVIEW During the contract term, we will assist the SmartTrips program in creating a state-of-the-art, sustainable, responsive and user friendly, web -based carpool matching application that is accessible by any computer with an Internet connection. Our approach includes conversion of the current RidePro database to a web -based database that is scalable, robust and built upon standards to ensure future compatibility and expansion opportunities. Walsh/E & E will develop a user-friendly, intuitive and Internet accessible carpooling application that can be administered by SmartTrips staff rEREd1W of physical location. Carpooler home and destination locations will be geocoded and resulting maps will show potential carpooling scenarios based on a user's preferences and needs. The end result will be a tool to encourage and facilitate a meaningful reduction in Northern Front Range single passenger vehicle trips. Below we describe the customized application that we will deliver to you. Our project team will embrace the "s iral opment' approach whereby components of the application are posted for review by SmartTrips staff on our production server as they are made ready. Thus, testing and refinement of application components will occur throughout the development process. It's our Loaf to work as a member of this team, facilitating the needs of the SmartTrips program and the communities it serves. PROJECT MANAGEMENT Given the aggressive time schedule associated with this project, efficient and effective project management (PM) is of utmost importance. Our PM team consists of two persons, each having slightly different responsibilities. John Armstrong will manage the overall project, to ensure deadlines are met and the final products are delivered on time. Based in Fort Collins, he also will be the primary contact with the SmartTrips staff. Renee Walmsley will manage application development and ensure that the development track stays on schedule and within budget. Ms. Walmsley will also be a functional part of the development team. The PM team will facilitate communication between the application development team and SmartTrips staff to ensure that technical aspects of the project are communicated effectively and in language appropriate for the respective audience. As the PM team is locally based, we plan to make Mr. Armstrong accessible in person on a wee gkly "check -in" basis to ensure that communication between SmartTrips and Walsh team is clear throughout the course of the project. This project check -in might consist of a briefing as to the project's progress and the fielding of ongoing questions. We believe this face-to-face process will greatly aid to the iterative nature of our spiral development approach and help ensure that the final application fully meets the needs and exceeds the expectations of SmartTrips staff and the public. Project management will be aided by the use of Microsoft Project and other software tools to provide the PM team with readily accessible information on task progress and associated costs. Project updates will be provided to SmartTrips PMs on a weekly basis. ` The PM team will be primarily responsible for training and support of the final carpool matching application. Training will occur on site in a "real world," hands-on scenario to ensure that SmartTrips 5/1112004.Carpool_Matching_App-Ft_Collins-NFRMPO-proposalv6.doc Page 2 -Walsh en ecology and environment company SMARTTRIPS commuter choice Rider/Drivw Fills Out Reglsbalbn Form Log on credentials are Sam via e4naii Rider/Driver loge on to application F /Driver enters intormatlon about commute staff can confidently support public use of the application. Should SmartTrips staff have questions, this same team will respond to those questions. The PM staff is highly experienced in fT/GIS application development and use in their own right; therefore, they will be effective facilitators during the course of the project and efficiently support it after implementation. TECHNICAL PROCESS We have organized our approach into three primary tasks: 1) Scoping and project kick-off; 2) Data collection and database development; and 3) Training and application deployment. Given the iterative nature of the development process, these Module geographically primary tasks will overlap and encourage feedback to ensure the locatas#* origin and final products are the result of a greater Walsh/E & E/SmartTrips eatlnationvia gBocodhg collaboration. TASK 1 - SCOPING AND PROJECT KICK-OFF is provided with atool to manually Walsh/E & E proposes to kick-off the project with a two-day JNoPoder/Driver create origin and workshop that will include a traditional scoping component destination locations where our technical and PM teams will work with SmartTrips yes staff to develop a detailed work plan consisting of identified needs and desired outcomes. Given the RFP contained a rather x and Y of origin is detailed and thorough needs assessment, we will plan to use a Rteo-to captured and database the derabase majority of this time engaged in a work session where we resent j YP usable examples and demonstrations of our proposed approach (as documented below) and begin soliciting feedback from SmartTrips staff based on these functional examples. This nns ie abetween nd ti» origin and destination portion of the workshop will use our collective time more P and a buffer Is crowd efficiently and ensure we kick-off the project "running" TASK 2 - DATA COLLECTION AND DATABASE DEVELOPMENT Appllcetion provides let of potential cerpoolers Database Conversion and Web Interface Development and map of locations ' Based on desired outcomes for the carpool matching application specified in the RFP, our development team will begin programming an application that meets these needs keeping in mind the need for the application to be intuitive, easy to navigate, dynamic and flexible. The application will be developed in incremental, but discreet stages so that application review by SmartTrips staff can be occur over the course of the development phase. The application will be developed on a production server accessible to the PM team and SmartTrips staff. Weekly progress reports will be made to the PM team, which in turn will summarize, present and demonstrate progress at the weekly check -in meetings. Our proposed workflow process will ensure that project development is iterative, reflects ongoing (and possibly newly identified) application needs and results in a final product that presents no surprises at the end of the development cycle. 5/11/2004.Carpool_Matching_App-Ft_Collins-NFRMPO-proposaiv6.doc Page 3 -WaLSh . moiogy and =.P." SMARTTRIPS commuter choice Existing carpool data will be imported from the RidePro database into a Microsoft SQL Server database. The new database platform will provide a stantjardized, expandable, reliable, and secure foundation for storing an ever growing and expanded set of carpooling information. This platform will also be designed to support the use of web -based GIS technologies, including geocoding capabilities. Prospective_carpoolers will enter information (and SmartTrips staff will administer that information) via an intuitive, user friendly web -based front end. Carpoolers will create user accounts using a web -based form. This form will be used to collect initial information on the rider/driver and then will prompt them through a user account creation process. Once an account is created, the rider/driver will be asked to enter additional information about the type of car they drive, origin and destination data, shift times, days they will be available to carpool, notification and privacy -related preferences, and other pertinent information. Users can revisit the site, update their accounts as their needs or circumstances change. Changes to accounts are live and instantaneous. Once the rider/driver information is entered, the website will generate a possible list of carpoolers and a map showing other potential carpoolers, based on location. This list will display information that has been entered by other rider/drivers. Some information may not be displayed, depending on a user's privacy preferences. For example, some rider/drivers may choose not to disclose their phone number, instead providing only an email address. The website will give a rider/driver the ability to request that an email be sent to them with the map and list of potential carpoolers as well. Finally, the website will also provide for instantaneous customer follow-up through an email/web survey. This survqy will_meet the CD T standards solicited n the Request for Proposal or include questions suggested by SmaztTrips staff. To the extent possible, the surveys can be managed and updated using administrative functions built into the application. In addition, a follow-up survey will be submitted to the carpoolers so that information can be verified and to determine if they are still using the carpool service. GIS Data Collection and System Development Walsh/E & E will use ArcIMS (ESRI) web mapping technology as a basis to match carpooling candidates by origin and destination locations. This platform will provide the ability to create dynamic, accessible maps and interactive tools for information viewing, query and exchange. Walsh/E & E will acquire and load geographic data layers for use with the spatial component of the database. To create dynamic maps using ArclMS software, GIS data in the form of shapefiles is required. To successfully implement the proposed solution, a street center line layer is required for each city/county in the project area. We pro Rose that a commercial product be used to reduce inefficiencies inherent in coordinating with various county GIS departments and making the data layers consistent over the project area. Additional reference data layers (including municipal and county boundaries, etc.) will be obtained from standard, public domain sources such as the Colorado Departments of Local Affairs and Transportation to reduce cost and ensure consistency with other regional datasets. Using javascript, ASP, and HTML, Walsh/E & E will customize the ArcIMS environment to create a series of user-friendly, interactive tools that will aid a potential carpooler in finding existing carpoolers with similar geographic profiles. Upon logging in to the carpool application using the username and password emailed to them during the registration process, the rider/driver will be prompted for information to define their profile (i.e., origin and destination locations and time of travel). 511112004.Carpool_MatchingApp-Ft_Collins-NFRMPO-proposalv6.doc Page 4 -Walsh commuter MA RTTR I PS� commuter choice m ecology and mvitotmeat c®pa¢y The application will present a list of potential meeting places that are within the rider/driver's acceptable travel distance. Once this information has been supplied, the rider/driver will be presented with a map of the project area and the x and y locations of existing carpool registrants. During the map loading process, a custom function will geocode the origin and destination provided by the rider/driver. If the addresses provided are successfully geocoded, points will be displayed on the map indicating the location of the origin and destination. In the event that an address cannot be located, a tool will be provided to manually create origin and destination points on the map. Upon successful location of the origin and destination locations, the x and y location of the origin will be captured and written to the database. This information will be used to create locations for potential carpool matches of future carpool registrants. A straight line will then be created between the origin and destination points and will be used as a basis to create a buffer at a distance representing the acceptable distance the rider/driver will travel to a meeting location. This system will allow riders to search for other carpoolers, display information on potential meeting places (which may not be a carpoolers home, but rather a public meeting place such as a coffee shop, etc.), provide users with a map of the routes, and account for differing shift times. ltlli �PM2 �^�..�'a'w '.�'Wt'.•"•• rIWIY�fM.NIM00MIRC'�+iY'*-'^�AOS,'ID11,}E, ,,.�MM'`�ENPMP. ��JCNAOE - -. Go to Private EKtranet Ste Mailing List ,f OMO t r d i •'Sa-. £ 34. � }' _' 1" F'y A T.i p 1Yd Soarch ,.. iQy's C:Itii�w`iAEv { ; First Name ft"t Name A 1910 WILLIAMS DRIVE ULC (hrGRn1zaHen/Jt1k ,Aild"St Cft StAlt ?jn Code Phone/email ATTN STEVEN K CHANCS 610 W PLYMOU H PA two { GERMANTOWN MEETING y` PIKE 0450 PLYMOUn1 MEETING, PA e NMI as 511 W CHANNEL PORT CA 93041 ISLANDS BL HUENEME PORT MLRNEME, I? CA ACG-BEST BUY INVESTORS ATTN I4UGH M BOSS ESQ 115 S LA CUMAE SANTA CA 90105 LA a902 BARSAAA G{ SAWA BARBARA, CA ACRES SUNNY ELC 6243 ELLERVIEW WEST HILLS CA 91107 AV ' WEST HELLS, CA n, BECERRA ADAL1101" ROORIGUE2 ELEUGAEEIO• Z311 MURPMTLN 0101RRD CA 92015 CECELIA ONNARD, CA MARRISOR ROORAICION-30HR 1112 KIHBAL ST HANFORD CA 91210 r, HANFORD, CA - } ALAMILLO JOSE P-TFRESA TA 1950 LINCOLN CT ONWARD CA 95010 ' 17 E & E developed a Mailing List application which allows administrators to sort and search for records and generate reports from web -based database. 5/11/1004.Carpool_Matching App-Ft_Collins-NFRMPO-proposalv6.doc Page 5