590 likes | 730 Views
Philadelphia Region Community Statistical Systems Robert Cheetham Avencia Incorporated. Avencia. Clients: Local/State/Federal Government Non-Profits Academic Institutions Topic Domains: GIS Software Development in: Real Estate Urban/Neighborhood Redevelopment
E N D
Philadelphia Region Community Statistical Systems Robert Cheetham Avencia Incorporated Avencia
Avencia • Clients: • Local/State/Federal Government • Non-Profits • Academic Institutions • Topic Domains: • GIS Software Development in: • Real Estate • Urban/Neighborhood Redevelopment • Natural Resources • Crime Analysis Avencia
Business Metrics • BAM • BAP • BIF • SCA • BPM • CRM • ERP • OLAP, HOLAP, ROLAP, MOLAP • DM • RTM Avencia
Public and Non-Profit Metrics • CompStat • CityStat • SUMS • SmartConservation • NatureServe DSS • Neighborhood Information Systems • Federal/Foundation Grant ROI Avencia
Presentation 1. Philadelphia Region Indicator Systems 2. Common Points 3. Challenges and Lessons Avencia
Philadelphia Region • Neighborhoods/Real Estate • Social Services • Crime • Conservation/Ecology Avencia
ParcelBase Avencia
ParcelBase Avencia
ParcelBase Avencia
Community Surveys Avencia
NeighborhoodBase Avencia
NeighborhoodBase Avencia
NeighborhoodBase Avencia
Customized Map Products Phila PD Crime Analysis Unit Weekly CompStat Meetings “Real Time” Intranet Web Site • Updated Daily • Automated Routines for Geocoding • Date Range, Time of Day, Day of Week • Crime or Incident Type, Nature Code • District, Sector or Street Address Avencia
PhiCAMS Avencia
PhiCAMS Avencia
PhiCAMS Avencia
PhiCAMS Avencia
PhiCAMS Avencia
CEWS Avencia
CrimeBase Avencia
Partnership - Manages the Project - Aggregates Data - Hosts Application CML - Strip out personal id’s - Send Data - Develop Software Components - Develop Database Design - Install and maintain software Avencia Phila PD Avencia
Tables Avencia
Stats Avencia
Scatter Charts Avencia
Trend Charts Avencia
Maps Avencia
Custom Neighborhoods Avencia
Custom Neighborhoods Avencia
MuralBase Avencia
MuralBase Avencia
MuralBase Avencia
Administration Avencia
Reviviendo Avencia
Others • Philly Site Finder: • Industrial Sites for Redevelopment (Brownfields) • Social Services (SUMS): • Same software framework for: • Public Health • Education • Social Services • Demographics • Rolled out in: • Philadelphia • Palm Beach County • Franklin County (Columbus, OH) Avencia
SmartConservation TM • A method of identifying, evaluating and prioritizing landscape resources for their potential habitat health and viability. • A weighted hierarchical model for evaluating arbitrary areas of land in Southeast Pennsylvania for their conservation value. Avencia
What is SmartConservation? A Decision Support System for assessing the ecological/conservation value of a given site: - Model - Web-based assessment tool - Data Sets – existing + derived maps - Green Infrastructure Plan Avencia
What is SmartConservation? Data + Methods Standard Weights Site Assessment + Metrics Metrics Avencia
Objectives • Score any arbitrary polygon in Piedmont region • Use publicly available data (mostly) • Generate Comparable Scores • Make all assessments available to all users • Integrate data with processes and make available to organizations that don’t have access to analysis tools. Avencia
Partnerships - Manage the Project - Convene Science Forum committees - Develop methodologies - Acquire data sets Science Forum NLT - Assess data sets - Develop assessment methodologies - Approve methodologies and weights - Host web site and data - Primary Data Provider - Develop Software Components - Develop Algorithms - Collaborate w/ NLT on methodologies - Install and maintain software Avencia PASDA Avencia
Process Modeling Avencia
Interior Forest Habitat Forested areas – edge = Interior Forest Rank based on size Avencia
Watershed Land Cover 1. Buffer site by 2 miles 2. Using site as pour point, calculate upstream watershed 3. Clip to 2 mile buffer. 4. Calculate Zonal mean of aquatic land cover Avencia
Riparian Corridor Fragmentation • Clip Land Cover to Site Boundary • Clip Site Land Cover to the Stream Corridor • Reclass using Aquatic Land Cover and site survey adjustments • Average the Land Cover Values • Calculate NeighborhoodVariety • Convert to a 0-10 scale and Average for corridors • Lather, Rinse, Repeat…. Avencia
Landscape Ecology Protected Lands Merged Hubs Before merge merge PNDI Cons. Resource Locations After merge Avencia
Automated Calculations • Perform several automated calculations, each of which produces a score and/or map for one or more taxa groups. Avencia
Site Score Avencia
Model Weights Avencia
Compare Results • Possible to compare the results to other sites in the same watershed, county, etc. Avencia
NatureServe DSS • Each element has: • A name • A weight • A conservation unit • A quantitative goal • Compatibility to land use types • A spatial distribution map Avencia