Transcript SF Data Integration Project

BAAMA Education Session:
“Prioritizing Capital Resource
Allocation: Using GIS to Calculate
Consent”
January 22, 2004
George White/Ryan Robley
Policy Innovation Works
Policy Innovation Works
Vision
To work with high performance teams that
produce innovative results.
Mission
To integrate people, process, and
technology for better location decisionmaking.
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
2
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
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
3
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
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
4
Introduction
Integrating People, Process & Technology
Demo
Results/Lessons Learned
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
5
Project Strategy
Integrate people, process, and workflow to
create policy driven technology that would
become a decision making tool for multiple
stakeholders
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
6
Systems Analysis Results
Responsibility Matrix
Stakeholder Access Privileges
Identify Entities
Determine Entity Relationships
Preliminary Report to Produce Feedback
and Buy-in
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
7
Understanding Work Process
Purpose: Display Entity C lusters
ER 1
Identify
Curb R am p
Locations
ER 5
Creates/
Im plem ents
Curb Ram p
Projects
(Crinventory)
(P rojects)
ER 4
Prioritze/Plan
Curb Ramp
Construction
Projects
(Priority)
Decision
Point
ER 2
Assess
Curb R am p
Condition
(Crassessm ent)
ER 3
Track Curb Ram p
Com plaints
(Citizen;
CitizenInquiry)
Prepared by GW
PIW 073103
January 22, 2004
Current Database Component
New Database Component
Policy Innovation Works Presentation at
BAAMA Education Session
8
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
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
9
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
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
10
Application Development:
Database Preparation
SF Street Centerline Basemap
Curb Ramp Inventory Database (Access)
Request and Complaints Database
(Access)
Project Management Tracking Database
(SQL Server)
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
11
Application Development:
Programming
Autodesk MapGuide Viewer API Examples
MapGuide Busy Events
Application Using MapGuide vs.
MapGuide Application
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
12
Curb Ramp Information System
Main Menu
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
13
Inventory Location Information
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
14
Insert New Assessment
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
15
Citizen Complaint Report
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
16
Priority Ranking Report
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
17
Demo
Inventory and Assessment Views
Requests and Complaints Views
Project Tracking Views
Reporting Views
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
18
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
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
19
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
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
20
Contact Us
George White
Policy Innovation Works
1440 Broadway, Suite 800
Oakland, CA. 94612
510-839-7132
[email protected]
January 22, 2004
Policy Innovation Works Presentation at
BAAMA Education Session
21