Overview: Cincinnati Public School GIS Project proposal • Presented by • Jaya Bathmaraj • Sean Crowe • Lan Anh Thai • Thomas Wuerzer June May 30 2007
Introduction • A class project for GIS Project Formulation & Management course • Students will design and carry out a GIS project addressing real world issues • This project involves a team of 4 members
Overview Project Proposal Current Usage of GIS at CPS Process About GIS User groups Database design Development of Project Module
Project Proposal • Goal : to propose the applications of GIS in the Cincinnati Public Schools (CPS) operation and management through an enterprise GIS solution • Focuses on data sharing between depts. with multi-level access to data base
Current GIS Usage at CPS • Implemented GIS in 1999 • Part of the Cincinnati Area Geographic Information System (CAGIS) Consortium • Has an administrator to manage and coordinate GIS data and applications • GIS was used in the preparation of the CPS Facilities Master Plan, and renovation of schools
What is GIS? • GIS stands for Geographic Information System • A system of computer hardware, software used for: • Data capturing • Storing • Integrating • Analyzing and displaying of data
What is GIS? • Components of GIS
Why GIS? • To organize, analyze and monitor information • Explore information in a totally different way through layers • Decision-making • It consists of layers: • Images, roads, businesses, demographics, environmental hazards, parcels • Economic data, utilities, transportation, medical facilities
Where is GIS used? • GIS is used everywhere! • Government agencies use it for: • Planning and organizing • Keeping track of properties, road network and land use • Emergency services • Crime analysis • Shortest travel routes • Daily operations
Where is GIS used.. • Other areas: • Health services • Utility expansions • School district • Real estates • Park • Environmental services • Building permits
Different Products of GIS • CAGIS • Google Earth • Web mapping • Desktop ArcGIS • Mobile GIS • Tele Atlas
Mobile GIS Google Earth Internet Map server Tele Atlas
What can GIS do? • Perform queries • Find all the hospitals with pediatric centers • Analysis • How many fire hydrants are located within 0.25 miles of a school • Select the schools which are 1000ft away from incident site • Trends, Patterns and relationship • Student enrollment for last 5 years • Population density Crime pattern • Visualization • Display information in 2D, 3D
What is Enterprise GIS? • Provides a framework for collaboration and communication by providing a common frame of location—and allowing people to share information • To help an organization to • Coordinate users to spend more time on the analytical capabilities of a GIS • Less time searching for compiling and integrating the data
User Groups • Central Office • Administrators and staffs, departments • Access tailored further through the design of tool-sets available to each administrative department • School Specific: • Educators and staff at schools • Access tailored with individual interfaces and tool-sets within unique user-accounts for each staff member • Public • General public (parents) • have no data editing or creation capabilities and will be limited strictly to display of non-sensitive data
Database Design Data sharing between CPS & other Depts.
Database Design – Create Connectivity Graffiti Mapping GIS education
Development of Project Modules • A meeting was setup with CPS panel members to discuss about their needs, workflow pattern and issues • Based on the needs, the following project modules were developed
Project Modules • Graffiti mapping • Sex Offender mapping Security & crime Prevention Bus Routing • Bus routing • Incident mapping • Critical facilities mapping • Emergency site and route Emergency planning Community resource mapping • Targeted marketing for CPS • Asset inventory & analysis
GIS Project proposal Emergency Planning Module : Cincinnati Public School
Content Background Module Objective How can GIS help CPS User groups Information products Live Presentation
Background Crises range in scope and intensity from incidents that directly or indirectly affect the entire community It can happen before, during, or after school To mitigate them, it is necessary to adopt and implement a comprehensive emergency response plan http://www.ed.gov/admins/lead/safety/emergencyplan/crisisplanning.pdf
Background.. Crisis/ emergency management involves : emergency preparedness, response, recovery and mitigation Cincinnati Public Schools (CPS) has prepared its emergency management plan for entire school district
Module Objective Objective of the module is to assist CPS to scrutinize and handle effectively during crisis This goal could be achieved by: Development of a multi-user database system Assistance to CPS with information products Creation of community awareness
How can GIS help Where is the emergency? What is the best route and time taken? Where are the closest available evacuation sites? What is the land use type, and how many people may need rescue or evacuation? How many people/students the site can best accommodate? How many schools are located within 300 ft of floodplain ?
How can GIS help… Simple GIS spatial analysis tools Buffer & selection tool Attribute query Gradual symbols / symbol ranges based on quantitative attributes Interactive mapping/ GUI ArcGIS extension: Network analyst Network based spatial analysis through routing
Information Products Incident Mapping GIS tools: buffer and selection tool Output: flooded areas, gas spill regions, landslide maps Existing Facility Mapping GIS functions: buffer, selection tool Facility type varies Emergency Sites & Routes ArcGIS extension – Network Analyst Facility type and route is different for different emergencies
Information products Using Network Analyst, CPS can create: Routing Multi-point routing Emergency response Calculate drive time for first responding units Driving Directions Expandable inset maps Map the incidents and determine the affect Identify the closest facility
Creation of Buffer zones Buffer zones of radii 0.25, 0.5 and 1 mi To know how many schools fall under potential risk zones
Live Presentation First step Create network dataset using street layer Second step Load required layers: schools, gas spill, hospitals, daycare, firehouses, hydrants, parks Third step Turn on the extension and add the toolbar Start the show!
GPS- Global Positioning System • AVL- Automatic Vehicle Location • System for tracking moving vehicles • XY coordinates transmitted to computer from GPS receivers on board buses.
Automatic Vehicle Location with GPS and ArcGIS Tracking Analyst XY Coordinates
Automatic Vehicle Location with GPS and ArcGIS Tracking Analyst • Users and Implementation: • Limited to administrative use at schools and central office. • Cost sharing for GPS transmitter installation on buses. • Tracking Analyst extension built onto ArcGIS package. • Ease of staff training and implementation
GIS PROJECT PROPOSAL Graffiti Mapping and Analysis Tool (GMAT) Module
GMAT – Graffiti Mapping and Analysis Tool • Graffiti is perceived as • Vandalism and property damaging • Personal threats • Territorial behavior of gangs • Or even as Arts?