Showing posts with label GIS. Show all posts
Showing posts with label GIS. Show all posts

Thursday, February 19

Using GIS to Manage the Redlands Bicycle Classic


This is Marilyn Dreuker's MSGIS Major Individual Project from 2003.

For 19 years, the City of Redlands has been hosting the Redlands Bicycle
Classic which is considered one of the most fun races in the U. S. by some
cyclists. This national event has endured longer than any other cycling event in
the U. S. For 6 days, this professional cyclistsí race takes place not only in
Redlands, but also in the cities of Riverside, Highland, and Yucaipa. The race in
April 2003 had almost 250 riders covering a total distance of approximately 348
miles for the menís races and 280 miles for the womenís races. There were nearly
1000 volunteers and an estimate of 50,000 spectators. (Oberjuerge 2003).
There is no question that credit for the raceís success has to be given to the
race committee, made up of the Redlandsí community and the police department.
Their well-organized efforts to run things smoothly makes the race enjoyable for
everyone. But to plan such a big event as the Bicycle Classic, especially
managing the number of people involved and the associated problems, takes a
great deal of time and effort. Everyone would benefit if there is a more efficient,
easier way to manage security, spectators, traffic, and road closures when planning
for this type of event.
This project addresses a better way to solve this planning problem by using
GIS to integrate the data, visually display the information on maps and perform
visual and spatial analysis of the integrated data sets. Using GIS, the police
department can improve the effectiveness of the planning by displaying the
integrated data on a map to see where problems have occurred or are likely to
occur. Visual or spatial analysis can help with planning the logistics of the event,
planning for security and medical emergencies, easing traffic problems, and
maintaining order.
This report communicates how GIS can be used as a tool to help with the
planning and implementation tasks. It begins by looking at other GIS applications
that relate to this activity. It then provides a concise look at the goals, scope and
objectives of this project and specifies the design, development and analysis that
were taken to address the issues. The report contains the products that will be
delivered to the client ñ the Redlands Police Department. Finally, conclusions and
recommendations for further study are provided.

Entire pdf located here (94 pgs)


Monday, January 5

InPrint: Remote Implementation of CityWorks in Redlands CA



This was just published in "InPrint" (Azteca's industry publication). Authors: Philip Mielke of Redlands, Matt Harman from Azteca


Azteca Systems provides two implementation methods to
assist clients with their deployment of Cityworks — standard
implementation and Remote Implementation Support (RIS).
A brief description of both methods follows. Both involve an
Azteca Project Manager (PM) assigned to manage the effort
and deliver the tasks from beginning to end. Several of
Azteca’s customers have experienced great success (and cost
savings since the bulk of the work is performed in-house)
with RIS. Most recently the City of Redlands, CA, chose RIS
to deploy Cityworks.
Standard Implementation
In a standard implementation, the Azteca PM is responsible
for a larger portion of the workload and configuration. The
tasks typically include a kickoff meeting, configuration/
implementation of workflows, review and installation of the
configured database/system, administrative training, end
user training, and rollout support. This method averages
about three months from start to finish, depending on the
number of departments being implemented and the number
of users being trained.
Remote Implementation Support
In this approach, the Azteca PM meets with the organization’s
representative through a series of webcast meetings to
implement the Cityworks software. (Meetings average
2-3 hours and are billed incrementally.) RIS is made
up of two primary tasks — implementation and training.
Implementation provides hands-on instruction for the
installation of the software and database, and all the
necessary configuration in Designer. (Designer is the
Cityworks administration tool used to define workflows and
related elements.) At the end of each meeting, the client’s
“homework” is to complete what was covered. When the
work is completed, a meeting takes place for the next lesson
and the process is repeated until the implementation is
complete. There is a standard list of lessons/topics covered
but, similar to the standard implementation, the content can
be tailored to the needs/goals of the organization.
Once the database and system configuration is complete,
training can be provided onsite or remotely via webcast. Or,
in some instances the client has been able to conduct their
own internal training as a result of the education gleaned
through RIS. Delivery time is subjective and moves at the
pace the organization sets.
Redlands GIS
Redlands is a city of approximately 70,000 nestled in the
San Bernardino Mountains in the Inland Empire of Southern
California. Since May of 2008, Azteca has
been working with Phil Mielke (Interim GIS
Administrator) and Marc Rolle (Database
Analyst) to configure Cityworks for the Quality
of Life and Municipal Utilities & Engineering
departments. Redlands has a variety of land uses and levels
of development, so providing service to the people and
businesses presents unique challenges. Like many cities,
Redlands has a growing need to reduce spending and take
measures to increase efficiency of work crews. Central to
that need is a work order system that utilizes a Geographic
Information System (GIS) to process work orders from call to
assignment through to completion.
The Redlands Information Technology Service Department
has incorporated GIS into nearly every aspect of City
operation. The Redlands Police Department has been a
long-time user of ESRI products and practices efficient
community policing through the sharing of information and
mapping through GIS. Citizen COMPASS, a tool developed
to share crime data with the public, is accessible through
gis.cityofredlands.org/compass. Redlands GIS Department
utilizes ESRI’s enterprise GIS licensing and supports 20
individual deployments, including instances of ArcGIS Server,
ArcSDE, and ArcIMS. Part of the philosophy of the enterprise
deployment allows users to take ownership of their use of
GIS. People with the domain knowledge take responsibility
for the quality of their data and become more knowledgeable
about the way their data can interact with other City
information.
Phil summarizes the City’s approach to maintaining their
operation. “Cityworks is the perfect solution for us to
incorporate GIS users from customer service to supervisors
to line-level operators. Information is easily accessible and
delivered through a clear and easy-to-use interface. Reports
give decision makers the information they need to be able
make informed decisions about where work is being done,
what materials are used, and how much money is being
spent for work orders grouped by any date interval
required. Cityworks saves the City of Redlands money
and is a great way to make the power of GIS accessible
to a broader group of users.”
Redlands RIS
At the beginning of the project, the project outline was
provided covering the steps required to complete the
implementation. Each week thereafter, web meetings
were held to train Phil and Marc on how to configure
the Cityworks topic for that week. These meetings are
hosted by Azteca Systems via the GoToMeeting software
produced by Citrix Systems. GoToMeeting allows both
the Azteca PM and the new client to view and control
each other’s computers via the internet. This web
meeting interaction allows for more effective training as
both the trainer and trainee can actually view what is
being described during the conference call.
Marc says, “The web meetings via GoToMeeting were so
convenient and very helpful during the implementation
process of Cityworks. There was no lag in connectivity
whatsoever! Having the capability to view each other’s
computer screen makes it much easier to learn the
system remotely. It seemed as if Matt was sitting next to
me showing me what to do. Also, we were able to record
the meetings (both audio and visual). So if we need a
refresher of how to do things, we simply go back to the
recordings and follow the step-by-step solutions that Matt
illustrated to us.“
The outline of the project progresses through each
component of Cityworks, building upon each other until
the software is ready to be used. Meeting durations
were typically 2 hours, during which the week’s topic
was demonstrated on a completed Cityworks database
(running on Matt’s machine) and then Phil and Marc
added the information and configured the week’s topic for
their database. The goal of the weekly meetings was to
provide sufficient training so both Phil and Marc could add
to the database throughout the week, circling back with
follow-up questions as needed. Cityworks administrators
gain valuable knowledge by actually performing these
tasks themselves.
In addition, the RIS approach also allows for training end
users on Cityworks via GoToMeeting. In Redlands, once
the database was ready to use for service requests, a
web meeting was set up to train some of the call takers
on the software. They received basic training on creating
service requests. The training sessions were recorded so
they can be used at a later time to train other users or as
a refresher for existing users.
As the project progressed, both Phil and Marc gained the
knowledge necessary to perform the remaining tasks to
complete the configuration of the software. At this time,
they are currently running live with service requests. As
for future use of the software, Phil and Marc dictate the
pace of the project themselves, asking for assistance
Project Outline
as needed. They plan to move forward with work orders and
include additional departments as time permits over the coming
months. At a later date, on-site training will be conducted for
the remaining end users.
RIS is an excellent option for those municipalities looking for a
more cost-effective and hands-on implementation of Cityworks.
GoToMeeting provides a virtual office environment in which
the Azteca PM can interact effectively with the City staff to
demonstrate, train, assist, and oversee the configuration of the
Cityworks software.

ID Task Name
1 Database Creation
2 Install RDBMS on Server (if necessary)
3 Install Cityworks on Server
4 Create New Cityworks Database
5 Create User Azteca
6 Create PWDP USER Role
7 Create ODBC Connection
8 Run DB Manager
9 Cityworks Domains
10 Add Super User Login
11 Add Domain Names
12 Add Domain Administrators
13 Designer Preferences per Domain
14 Domain Groups
15 Create Employee/Security Domain Groups
16 Add Employees to Groups
17 Employees
18 Import Employees with Rates
19 Create Logins on Server
20 Add Employee Custom Fields
21 Add Skills
22 Set Employee Relates
23 ArcGIS Setup
24 Review Geodatabase Model
25 Add Required Attribute Fields
26 Define Asset Groups
27 Assign Assets
28 Define Relationships
29 Create .mxd(s)
30 Import/Enter Data
31 Contractors
32 Equipment
33 Materials
34 Customer Accounts
35 Street Codes
36 Request Templates
37 Define Problem Codes
38 Add to Hierarchy
39 Questions/Answers
40 Security
41 Custom Field Templates
42 Work Order Templates
43 Define Work Order Activities
44 Import Work Order Descriptions
45 Tasks
46 Custom Field Templates
47 Security
48 Print Templates
49 Service Request
50 Work Order
51 Codes
52 Add All Codes (Priority, Status, etc.)
53 Final Review and Rollout
54 Review Databa

Monday, December 1

GIS Project Proposal #2 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.

20 Years of Crime
Crime analysis units work with pieces of data at a time.
Windows of time. Some procedures group incidents by the
most recent set of a week; some procedures compare one
month to the previous month; some compare 3 recent
months to the previous 3 months. This is a different
approach.

The Redlands Police Department has 20 years of geocoded crime
data, and there have been some changes over the
years. There are 2 sets of Census data available to correlate
values to (1990 and 2000). There may also be a possible
preliminary 2010 Census data set available.
Population has changed. Landuse has changed.
The infinite set of human variables are constantly changing what
is the effect?

Product
There is flexibility for what the data-product will entail.
The MIP and presentation will be the final deliverable, and
ideally we would like to see animations that depict the
changes that have occured over time. We can assist in the
development of these animations.
Support for your MIP will include regular access to our
network and our staff. For this reason, a light background
check will be necessary.

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

Flash for Animated Crime Maps

This is a earlier example (much earlier- 2002) of using animation to tell a story within a mapping environment. This is a gallery of animated maps showing burglary, assaults, all incidents, and vehicle thefts year-by-year. Also included is an example of an hour-by-hour analysis of traffic collisions.

Methodology

This is completed by exporting individual layers into Macromedia (Now Adobe) Flash. Flash is a perfect medium for this because it is able to handle raster and vectors with different levels of compression. In these (old...) examples, the densities(rasters) are vectorized, reducing the size substantially. What would be a 30-100MB avi file exported from ArcScene is an 80kb swf file.
I teach a class about this, and have since (2005) developed a way to incorporate Modelbuilder to create and symbolize the densities automatically.






CityWorks Service Request Report (video)

Here is a short video highlighting how great the Cityworks Service Request Report helps the City of Redlands keep better tabs on their resources and how they are being utilized. As calls for Quality of Life issues are taken, this helps to geographically prioritize work as well as keeping duplicate work orders (two neighbors complaining about the same issue) down to a minimum.

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.

Wednesday, November 26

City of Redlands GIS Architecture

We're on the move with the deployment of our enterprise GIS license within the City of Redlands. The overall obstacle is working with four distinct networks (Municipal Utilities, Police, Emergency Ops/Fire, and Quality of Life/City), and this presents a challenge with serving large datasets and bottleneck points. We intend to reach out and provide enterprise and desktop solutions to department other than the server-based IMS (Internet Mapping System) sites.

This is an overall diagram of the current GIS Server Architecture for the City of Redlands and will serve as a base for growth and strategic planning. (click on the image for a full-size diagram)

Redlands GIS News, Issue 1


Welcome to the first installment of the Redlands GIS News. In these communiqués the City will not only outline how GIS technology is currently being utilized within the City, but also provide status on current implementations and identification of future plans for extending GIS throughout the enterprise.

The focus of this initial edition will be to provide a brief overview of the GIS products currently available within the City and to summarize the current GIS projects staff is working on.

EXISTING GIS CAPABILITY

City Website
The City currently utilizes ArcIMS to provide many products through the City GIS website which is at http://gis.cityofredlands.org. The departments supported and some of the data provided include the following:

Municipal Utilities
Capital Improvement projects, Water System, Storm Network, Sidewalk Survey, Traffic Sign and Signal inventory
Police
Incidents, Arrestees, Collisions, Citations.
Redevelopment
Businesses, RDA & CDBG boundaries
Fire / EOC
Fire Demand Zones, High Fire Hazard Areas, HAZMAT locations, Response zones
Quality of Life
City owned trees, groves, street network, parks, trails, solid waste areas
Community Development
Zoning, General Plan, FEMA Flood Plain

Other support
GIS also provides data to the City’s new One Stop Permit Center, supports other ongoing services such as map generation, and supports applications such as CrimeView, GeoNotify, Veritracks, and provides data to the Police Department’s Crime Analysis Unit.
CURRENT MAJOR PROJECTS

CityWorks (Azteca) – This is a new project at the City to provide a common map-based Work Order solution to the enterprise. It is anticipated to be rolled out first to the Quality of Life and Municipal Utilities and Engineering departments.

CAD system upgrade (Spillman) – The Police Department will be utilizing a new ArcGIS Server addressing system to support dispatch. This will facilitate new created and mapped addresses to immediately show up in the PD’s addressing system.

WebEOC (ESi) – This system provides an electronic method for data entry and dissemination within the City’s EOC to better communicate during an incident. These electronic boards will replace the current use of white boards currently around the EOC.


IN SUMMARY

We look forward to communicating on our progress utilizing GIS technology within the City of Redlands on a regular basis in the future. We hope that this provides a window into how the City of Redlands plans to use technology to better serve not only the city staff, but the residents and visitors to Redlands. If you have any questions, please do not hesitate to contact us.


David Hexem, Chief Information Officer
dhexem@cityofredlands.org
Philip Mielke, Interim GIS Administrator
pmielke@cityofredlands.org

City of Redlands Information Technology
35 Cajon
Redlands, CA 92373

Tuesday, November 25

Street Signs Project- Working in the field (virtually)

Mike Wahl (our great intern- anyone want to hire him?) has been saving time and money, which is great in times like these. We needed a street sign layer for our Cityworks project. Essentially, Cityworks is a GIS-enabled work order system, and we want to be able to tie work orders to sign feature classes. We didn't need sub-meter accuracy, and getting GPS-points in the field would have been overkill (in this case- there are plenty of places for GPS collection).

This is written by Mike:

The purpose of this project is to identify and locate all city street signs and street lights within the City of Redlands that have not been geocoded previously. In this screenshot the red line indicates a street segment that has been checked and all the street signs on that street have been identified. The green line means that the street segment has not yet been checked. The blue line is a segment that has been selected (as seen in the ‘Attributes of Streets’ box at the bottom) and will be checked. The small dots represent the street lights and the large pink dots represent the street signs. The highlighted street sign (toward the middle of the screen) is a stop sign as can be seen in the TYPE column of the ‘Attributes’ box at the left. There are many types of street signs and a large part of this project is to identify which type they are.


In order to identify and locate the city street signs we use the Street View feature in Google Maps. The stop sign seen above is the street sign that was highlighted in Arc Map. The Google Map Street View is current data and by using it the project can be completed quicker than if we were to take gps coordinates from every individual street sign in the field. The only problems are that some of the signs are hard to see and some of the streets are not covered either due to construction or that the street was not on their list to cover. Despite these limitations the majority of street signs can be identified and any field work will be cut down to a minimum if need be.


At this time (11/25/08) nearly half of the city streets have been checked. This process has taken over forty hours to accomplish in what would have taken several months to accomplish in the field.




Monday, November 24

Geography & Public Safety: Using Geographic Information Systems to Support Broken Windows Policing



When New York City police began
targeting graffiti crews and turnstile
jumpers instead of the city’s rampant violence
and crack use, many critics objected. But when
their strategy gave way to success, police began
seriously considering broken windows policing
as an excellent crime-reduction policy. Today,
police can use geographic information system
tools to reduce blight and graffiti in a city and
enhance broken windows policing strategies.
Broken windows policing is a theory
developed by George Kelling and James
Wilson. It suggests that if minor crimes and
disorders are targeted, major crime will be
prevented. In other words, an environmental
context sets norms of acceptable behavior—if
one window is broken, vandals will think that
breaking windows is an acceptable behavior.
Journalist Malcolm Gladwell highlights
these ideas in his book, The Tipping Point,
illustrating that many relatively benign factors
can combine to produce a “tip” in forces at
play. Criminal behavior or public disorder
grows exponentially rather than following
a straight linear path; thus, targeting small
crimes and blight can have an outstanding
effect on city crime prevention.

Crime analysts can respond to blight and
graffiti issues within a city in many different
ways. Maps using different data sources help
analysts consider the environmental factors at
play and make crime prevention a major factor
in a city’s planning and development. When
creating a plan for citywide crime prevention,
geographic information system (GIS)
analysts must combine officers’ observations
of neighborhood crime and disorder with
external data and policing initiatives.
Riverside’s Graffiti Abatement Partnership

(This article refers to Riverside CA's Graffiti abatement program. It further highlights a server-based system that utilizes GPS-enabled cameras to take images and data in the field. Public works and the PD work on the same business process. It's a great highlight of city departments working together for problem-solving initiatives).
More here...





Geography & Public Safety: Using ModelBuilder for Geographic Information System Tasks


This was published in the National Institute of Justice's Geography and Public Safety Bulletin:


Crime analysis requires a Geographic Information System (GIS)—a software program for capturing, managing, and analyzing geographic and spatial data—to process data and create data products (e.g., printed maps, pamphlets) for a wide audience. Crime data can change daily, which makes producing maps and other products a daunting task for many analysts. Automating regular tasks will save time and allow for more sophisticated tools for analysis. Crime analysts need a mapping program that allows them to regularly update data in a timely fashion. Environmental Systems Research Institute’s (ESRI) ModelBuilder is a component of a type of ArcMap that allows for drag-and-drop development of complex geoprocessing tasks (e.g., placing points on the map based on addresses, summarizing data). It helps crime analysts expedite their daily geoprocessing tasks for map production.


Advancing Earlier Modeling Tools


ESRI’s ModelBuilder is a drag-and-drop process modeling environment that comes standard with ArcMap version 9.x. ModelBuilder is an advancement of ArcView 3.x’s Geoprocessing Wizard Extension. Where the Geoprocessing Wizard was limited to tasks like spatially joining, merging, and clipping data, ESRI introduces all of ArcMap’s functional capabilities (e.g., spatial analysis, geoprocessing) into the Toolbox. A large number of different tools and tasks can be strung together in the literal sense of a systems technology: data go in, a process occurs, and data come out. The potential to string complex tasks together and automate them to run regularly makes ModelBuilder an attractive option for any Crime Analysis Unit.


The rest of the article, and a series of other articles can be found at
http://www.ojp.usdoj.gov/nij/maps/gpsBulletin-2008v1.pdf.pdf