BAAMA Education Session: “Prioritizing Capital Resource Allocation: Using GIS to Calculate Consent” January 22, 2004 Geo

1. BAAMA Education Session: “Prioritizing Capital Resource Allocation: Using GIS to Calculate Consent” January 22, 2004 George White/Ryan Robley Policy Innovation Works

2. Policy Innovation Works Vision • To work with high performance teams that produce innovative results. Mission • To integrate people, process, and technology for better location decision-making. Policy Innovation Works Presentation at BAAMA Education Session

3. Policy Innovation Works • Focus: Integrating People, Process, and Technology for effective location decision making • Consulting Services • Systems Analysis to identify how best to integrate people process and technology • Facilities Asset Management to inventory, plan resource allocation, and track capital project decision making • Strategy Implementation to put innovation into practice • Quality Assurance to ensure complete and accurate information • Strategic Resource Planning to maximize use of scarce • Project Management to maximize mission driven stakeholder teamwork • For more information visit: www.4piw.com Policy Innovation Works Presentation at BAAMA Education Session

4. Client for “Policy Innovation Works” • City and County Government Organizations that focus on facility asset management and economic development • GIS Companies that need specialized systems analysis and project implementation expertise • New Technology Companies that are creating innovations • Systems Integrators that need project coordination/management to create synergies between GIS and non-GIS technologies Policy Innovation Works Presentation at BAAMA Education Session

5. Introduction • Integrating People, Process & Technology • Demo • Results/Lessons Learned Policy Innovation Works Presentation at BAAMA Education Session

6. Project Strategy • Integrate people, process, and workflow to create policy driven technology that would become a decision making tool for multiple stakeholders Policy Innovation Works Presentation at BAAMA Education Session

7. Systems Analysis Results • Responsibility Matrix • Stakeholder Access Privileges • Identify Entities • Determine Entity Relationships • Preliminary Report to Produce Feedback and Buy-in Policy Innovation Works Presentation at BAAMA Education Session

8. Understanding Work Process Policy Innovation Works Presentation at BAAMA Education Session

9. Mapping Policy to GIS • Identify Policy Parameters • Translate Policy into Prioritization Scoring Framework • Map Database Field Assessment Collection to Policy Framework • Generate Prioritization Score Based on Policy Framework • Map Prioritization Score to Geospatial Entities Policy Innovation Works Presentation at BAAMA Education Session

10. Policy Rating Framework • Unsafe location for disabled access: 1000 Points • ADA Title 2 Program Access: 750 Points • No Curb Ramp: 500 Points • There is one curb ramp but the location could use two curb ramps: 250 Points • Difficult Physical Condition: 120 points • Safe Curb Ramp but does not comply with current standards: 60 Points • Citizen Requests/Complaints: 5 points for each contact by a different individual, up to a maximum of 50 points added to the above scores Policy Innovation Works Presentation at BAAMA Education Session

11. Application Development: Database Preparation • SF Street Centerline Basemap • Curb Ramp Inventory Database (Access) • Request and Complaints Database (Access) • Project Management Tracking Database (SQL Server) Policy Innovation Works Presentation at BAAMA Education Session

12. Application Development:Programming • Autodesk MapGuide Viewer API Examples • MapGuide Busy Events • Application Using MapGuide vs. MapGuide Application Policy Innovation Works Presentation at BAAMA Education Session

13. Curb Ramp Information System Main Menu Policy Innovation Works Presentation at BAAMA Education Session

14. Inventory Location Information Policy Innovation Works Presentation at BAAMA Education Session

15. Insert New Assessment Policy Innovation Works Presentation at BAAMA Education Session

16. Citizen Complaint Report Policy Innovation Works Presentation at BAAMA Education Session

17. Priority Ranking Report Policy Innovation Works Presentation at BAAMA Education Session

18. Demo • Inventory and Assessment Views • Requests and Complaints Views • Project Tracking Views • Reporting Views Policy Innovation Works Presentation at BAAMA Education Session

19. Other Decision Support Applications • Blight Studies • Facility Condition Assessment • Pavement Management • Street Lights • Parking Meters • Traffic Signals • Capital Program Resource Allocation Planning • Seismic Retrofit Project Planning Policy Innovation Works Presentation at BAAMA Education Session

20. Results/Lessons Learned • Key Result: Have a robust application running in three months • Phase Implementation Based on Budget and Schedule Constraints • Workflow Process Modeling Integrated People, Process and Technology • Policy Framework Drives Prioritization Methodology • Database Centric Applications Work More Efficiently • Importance of End User Documentation & Orientation Policy Innovation Works Presentation at BAAMA Education Session

21. Contact Us George White Policy Innovation Works 1440 Broadway, Suite 800 Oakland, CA. 94612 510-839-7132 gwhite@4piw.com Policy Innovation Works Presentation at BAAMA Education Session