Quantitative School Bus Stop Risk Assessment of Redlands, California

This was a Major Individual Project for the University of Redlands working with Claiborn Lewis Phillips in 2005.


















The purpose of this Major Individual Project (MIP) was to identify public school bus
stops in the city of Redlands with certain risks. Those risks being violent crimes, drug
related crimes and the homes of convicted sex offenders. The MIP made use of the
Kernel density function along with the Getis-Ord Hotspot function in ESRI’s ArcGIS 9.1
software. These functions were both used alone and combined. The Kernel Density
function was used alone to derive a density surface that would be reclassified to produce
a risk surface that would identify the risk of the school bus stops. The Hot Spot Analysis
(Getis-Ord Gi*) with and without (z-score) Rendering were use in combination with the
Kernel Density function. The pairing of these two functions, Kernel density and Hot
Spot Analysis, was utilized to produce surfaces that would act as visual aids to better
identify hot and cold spots. These surfaces were generated by using the Hot Spot
Analysis functions to compute the Getis-Ord Gi* (with and without rendering) values.
Those values were then used as the Population field for the Kernel density function that
produced Hot Spot/Kernel density surface. These results were used to produce maps to
aid police officers, and school officials and produce an IMS site to inform the parents of
the community.

The project paper can be found here...

GIS Project Proposal #1 MSGIS

Why do this project?
The City of Redlands is an average-sized city that is rapidly becoming a representative example of ESRI’s market base. For this reason, Redlands stands to be the model city for
the adoption of GIS technology. GIS has been a part of the police department’s regular business process since the mid 90’s, and there are two crime analysts and a database
technician that will be available to facilitate your success with this project.

The City of Redlands holds an enterprise GIS license and is also a user of the Omega Group’s CrimeView, one of ESRI’s most active business partners. There is an explicit need
for this project, and there is a culture of acceptance and data sharing with the Redlands Police Department and the City of Redlands. Here is your chance to work with an
emerging field of GIS.


There are two very attractive features to partnering with us:
1. We are close enough to meet with frequently.
2. Your client has been through the U of Redlands MSGIS program, and understands what
the MIP process entails. Scope creep will be minimized and we’ll tailor your project to suit
your needs and interests.

What is this project about?

Time-based correlative analysis
There are currently 16 cars being tracked by in-car GPS
units in the RPD. The GPS unit is embedded in the wireless
modem and updates the live signal to the server. This produces
a database that is transfered from the UNIX environment
into a SQL table. We regualrly geoprocess this into a
feature class. The table identifies which incidents are being
worked on, or if the officer is on proactive patrol time.
What we need is a time-based correlative analysis to answer
the question: are the officers patrolling the right places at
the right times? Because this is a new process for police
departments and crime analysis units, this methodology
stands to be very repeatable and will be shared with the
broader crime analysis community. We have developed
some concepts, but there will be an opportunity to brainstorm
use case scenarios and produce an original solution to
a new problem.

Product
There is flexibility for what the data-product will entail, but
the ideal situation will include a series of geoprocessing
tasks and a series of ArcGIS Server mapservices to be
shown through intranet-based applications and desktop
clients.
Support for your MIP will include regular access to our
network and our staff. For this reason, a light background
check will be necessary.

Who should I contact about this project?

Philip Mielke
Interim GIS Administrator
City of Redlands
pmielke@cityofredlands.org
909-335-4784
redlandsgis.blogspot.com
gis.cityofredlands.org

Wildfire Urban Interface UML

Renee has been working on a UML diagram to better understand how to model fire risk for her Major Individual Project at the University of Redlands MSGIS program. This is part of the conceptualization phase of the project, and this diagram helps to explain the relationship different entities have with each other. This phase helps her think through the process of geodatabase creation.

Disaster Mitigation Models for the City of Redlands

This is a Major Individual Project (MIP) project proposal by Renee Bousselaire from the University of Redlands MSGIS Program. We're glad to work with her, and will gradually add more content and rough examples of the models (with her permission) as they are developed.

Earthquake history shows that the southern San Andreas fault has earthquakes an average of once every one hundred and fifty years with a magnitude of 7.0 or greater. The last two major earthquakes on the southern San Andreas fault occurred in 1680 and 1812. Certain areas, close to San Bernardino County, are at risk because they have gone the longest without major earthquake activity (Jones, et al. 2008). Earthquake modeling has been conducted at the federal and state level for California, but the City of Redlands requires analysis at the city level. This project will demonstrate how ArcGIS spatial operators, ModelBuilder, and network functions can aid in disaster mitigation efforts for the City of Redlands, California. Based on predefined water pipeline breaks, the water response model will use geometric network features and Network Analyst to combine water pipeline and transportation networks to model which valves need to be turned off and how long it will take responders to reach the valves. The fire behavior model will use ModelBuilder and a variety of spatial operators to assign risk values to fuel loads, weather, and topography to create an output layer identifying probable fire locations. The models will serve as an introductory component of a larger disaster plan for the City of Redlands