BAAMA Education Session:BAAMA Education Session:““Prioritizing Capital Resource Prioritizing Capital Resource

Allocation: Using GIS to Calculate Allocation: Using GIS to Calculate Consent”Consent”

January 22, 2004January 22, 2004

George White/Ryan RobleyGeorge White/Ryan RobleyPolicy Innovation WorksPolicy Innovation Works

22January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Policy Innovation WorksPolicy Innovation Works

Vision Vision

To work with high performance teams that To work with high performance teams that produce innovative results.produce innovative results.

MissionMission

To integrate people, process, and To integrate people, process, and technology for better location decision-technology for better location decision-making.making.

33January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Policy Innovation WorksPolicy Innovation Works

Focus: Integrating People, Process, and Technology for Focus: Integrating People, Process, and Technology for effective location decision makingeffective location decision makingConsulting ServicesConsulting Services

Systems Analysis Systems Analysis to identify how best to integrate people to identify how best to integrate people process and technologyprocess and technology

Facilities Asset ManagementFacilities Asset Management to inventory, plan resource to inventory, plan resource allocation, and track capital project decision makingallocation, and track capital project decision making

Strategy ImplementationStrategy Implementation to put innovation into practice to put innovation into practice Quality AssuranceQuality Assurance to ensure complete and accurate information to ensure complete and accurate information Strategic Resource PlanningStrategic Resource Planning to maximize use of scarce to maximize use of scarce Project ManagementProject Management to maximize mission driven stakeholder to maximize mission driven stakeholder

teamworkteamwork

For more information visit: www.4piw.comFor more information visit: www.4piw.com

44January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Client for “Policy Innovation Works”Client for “Policy Innovation Works”

City and County Government OrganizationsCity and County Government Organizations that that focus on facility asset management and focus on facility asset management and economic developmenteconomic developmentGIS CompaniesGIS Companies that need specialized systems that need specialized systems analysis and project implementation expertiseanalysis and project implementation expertiseNew Technology CompaniesNew Technology Companies that are creating that are creating innovations innovations Systems Integrators Systems Integrators that need project that need project coordination/management to create synergies coordination/management to create synergies between GIS and non-GIS technologies between GIS and non-GIS technologies

55January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

IntroductionIntroduction

Integrating People, Process & Technology Integrating People, Process & Technology

DemoDemo

Results/Lessons LearnedResults/Lessons Learned

66January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Project StrategyProject Strategy

Integrate people, process, and workflow to Integrate people, process, and workflow to create policy driven technology that would create policy driven technology that would become a decision making tool for multiple become a decision making tool for multiple stakeholdersstakeholders

77January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Systems Analysis ResultsSystems Analysis Results

Responsibility MatrixResponsibility Matrix

Stakeholder Access PrivilegesStakeholder Access Privileges

Identify EntitiesIdentify Entities

Determine Entity RelationshipsDetermine Entity Relationships

Preliminary Report to Produce Feedback Preliminary Report to Produce Feedback and Buy-in and Buy-in

88January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Prepared by GWPIW 073103

ER 2Assess

Curb R am p Condition

(C rassessm ent)

ER 5Creates/

Im plem ents Curb Ram p

Projects (P rojects)

ER 4Prioritze/Plan

Curb Ram p Construction

Projects(Priority)Decision

Point

ER 3Track Curb Ram p

Com plaints

(C itizen;CitizenInquiry)

ER 1Identify

Curb R am pLocations

(Crinventory)

New Database Com ponent

Current Database Com ponent

Purpose: D isplay Entity C lusters

Understanding Work ProcessUnderstanding Work Process

99January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Mapping Policy to GIS Mapping Policy to GIS

Identify Policy ParametersIdentify Policy ParametersTranslate Policy into Prioritization Scoring Translate Policy into Prioritization Scoring FrameworkFrameworkMap Database Field Assessment Map Database Field Assessment Collection to Policy FrameworkCollection to Policy FrameworkGenerate Prioritization Score Based on Generate Prioritization Score Based on Policy FrameworkPolicy FrameworkMap Prioritization Score to Geospatial Map Prioritization Score to Geospatial Entities Entities

1010January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Policy Rating Framework Policy Rating Framework

Unsafe location for disabled access: 1000 PointsUnsafe location for disabled access: 1000 Points ADA Title 2 Program Access: 750 PointsADA Title 2 Program Access: 750 PointsNo Curb Ramp: 500 PointsNo Curb Ramp: 500 PointsThere is one curb ramp but the location could use two There is one curb ramp but the location could use two curb ramps: 250 Points curb ramps: 250 Points Difficult Physical Condition: 120 pointsDifficult Physical Condition: 120 pointsSafe Curb Ramp but does not comply with current Safe Curb Ramp but does not comply with current standards: 60 Pointsstandards: 60 PointsCitizen Requests/Complaints: 5 points for each contact Citizen Requests/Complaints: 5 points for each contact by a different individual, up to a maximum of 50 points by a different individual, up to a maximum of 50 points added to the above scoresadded to the above scores

1111January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Application Development: Application Development: Database PreparationDatabase Preparation

SF Street Centerline BasemapSF Street Centerline Basemap

Curb Ramp Inventory Database (Access)Curb Ramp Inventory Database (Access)

Request and Complaints Database Request and Complaints Database (Access)(Access)

Project Management Tracking Database Project Management Tracking Database (SQL Server)(SQL Server)

1212January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Application Development:Application Development:ProgrammingProgramming

Autodesk MapGuide Viewer API Autodesk MapGuide Viewer API ExamplesExamples

MapGuide Busy EventsMapGuide Busy Events

Application Using MapGuide vs. Application Using MapGuide vs. MapGuide ApplicationMapGuide Application

1313January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Curb Ramp Information System Curb Ramp Information System Main MenuMain Menu

1414January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Inventory Location InformationInventory Location Information

1515January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Insert New AssessmentInsert New Assessment

1616January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Citizen Complaint ReportCitizen Complaint Report

1717January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Priority Ranking ReportPriority Ranking Report

1818January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

DemoDemo

Inventory and Assessment ViewsInventory and Assessment Views

Requests and Complaints ViewsRequests and Complaints Views

Project Tracking ViewsProject Tracking Views

Reporting ViewsReporting Views

1919January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Other Decision Support Other Decision Support ApplicationsApplications

Blight StudiesBlight Studies

Facility Condition AssessmentFacility Condition Assessment

Pavement ManagementPavement Management

Street LightsStreet Lights

Parking MetersParking Meters

Traffic SignalsTraffic Signals

Capital Program Resource Allocation PlanningCapital Program Resource Allocation Planning

Seismic Retrofit Project PlanningSeismic Retrofit Project Planning

2020January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Results/Lessons LearnedResults/Lessons Learned

Key Result: Have a robust application running in Key Result: Have a robust application running in three months three months Phase Implementation Based on Budget and Phase Implementation Based on Budget and Schedule ConstraintsSchedule ConstraintsWorkflow Process Modeling Integrated People, Workflow Process Modeling Integrated People, Process and TechnologyProcess and TechnologyPolicy Framework Drives Prioritization Policy Framework Drives Prioritization MethodologyMethodologyDatabase Centric Applications Work More Database Centric Applications Work More EfficientlyEfficientlyImportance of End User Documentation & Importance of End User Documentation & OrientationOrientation

2121January 22, 2004January 22, 2004 Policy Innovation Works Presentation at Policy Innovation Works Presentation at BAAMA Education Session BAAMA Education Session

Contact UsContact Us

George WhiteGeorge White

Policy Innovation WorksPolicy Innovation Works

1440 Broadway, Suite 8001440 Broadway, Suite 800

Oakland, CA. 94612Oakland, CA. 94612

510-839-7132510-839-7132

gwhite@4piw.comgwhite@4piw.com