User Presentations

In an effort to address the need for a Common Operational Picture (COP) for incidents management, the City of Rancho Cucamonga has designed a unique GIS application that addresses the needs of public safety field officers. This GIS/Adobe AIR application provides officers with standard protocols for Active Shooter, Fire, Flood, Terrorist Attack, and Chemical spills under one common picture.

This GIS application provides a friendly and easy-to-use navigation interface, dynamic imagery, schools and city facilities floor plans, panoramic views, and emergency contact list, making this application a vital management tool for an emergency situation. This application runs on a Mobile Data Computer (MDC) located within the public safety vehicles and affords public safety officers a common operational picture that will reduce information redundancy and allow for a rapid response to the emergency situation. The application is written and developed in Adobe Flex and ArcGIS for Server.

POLB's "Virtual Port" project is a $5 million, grant-funded, GIS-based effort to ensure security at the Nation's largest Port complex. The presentation will discuss the crucial and unique role GIS plays in the project, for while Port security is the goal, "Virtual Port" is not a security application per se, but rather a Reference Domain Awareness Tool for POLB to be shared with various organizations (e.g., POLA, Coast Guard, LBPD, DHS, etc.).

The intent of Virtual Port is to automatically collect information from various sources/feeds and present them in a spatially enabled graphical interface (e.g., web-based GIS). The tool will then enable the sharing and dissemination of information related to domain awareness to key stakeholders both in and outside of the Port.

The presentation will cover several basic topics:

• The core capabilities of "Virtual Port" and how GIS supports them
  • Data Mining
  • Threat Assessment
  • GIS and Visualization
  • Operational Awareness
• The role GIS plays in furthering the relationships with POLB stakeholders and partners
• Lessons learned during the formulation and vendor selection process
  • Demo from vendors prior to RFP critical for quality responses
  • Focusing on COTS solution to ensure a robust and successful system
  • Conveying to stakeholders the full nature of GIS and how it, not intelligence or security tools, was the correct foundation for what was desired
  • Need for GIS expertise to manage system after implementation
  • Requires buy-in and support from related agencies

The San Bernardino County GIS customers acquired the expectation for current orthographic imagery as a key base map layer to important GIS applications that used this imagery, to perform analysis, and support decision making. With the increasing cost of acquiring imagery and our decreasing budgets, it was becoming a challenge to meet this expectation. The County found itself with no other alternative but to seek help from like-minded entities. Having built good relations with the USGS/NGA (Drew Decker) and County of Riverside (Damian Laning), it became evident, after discussions, that we were all seeking the same imagery for 2011. In some previous years, the same imagery was purchased independently since there were no collaborative efforts in place. Through collaboration in 2011, we negotiated the best price, found a reliable vendor and flew our area of interest once, and paid for it once and plan on making it available to everyone.

Primary sclerosing cholangitis (PSC) is a rare disease whose cause is largely unknown. We aimed to determine patterns in PSC distribution, which may lend insight into environmental causes. Prevalence rates of liver transplant registrants with PSC were calculated using the United Network for Organ Sharing database (1995 to 2009). Rates were assigned to ZIP Codes nationwide based upon permanent residence.

Geographic information system (GIS) software was used to determine significant clusters of PSC using hot spot analysis. Several areas of hot spots were identified, primarily in the Rocky Mountains, Upper Midwest, Ohio River Valley, Susquehanna River Valley, and Buffalo, New York. We also analyzed the relationship of several variables to the hot and cold spots (gender, race, tenure, urbanicity, and distance to the nearest transplant center). This ongoing study further employs geostatistical analysis and regression modeling to elicit the contribution of environmental phenomena to PSC causes.

The California Office of Statewide Health Planning and Development (OSHPD) has published its "Healthcare Atlas" website since 2005 as part of our ongoing efforts to illuminate the vast and complex healthcare landscape in California for the public, researchers, policy makers, and community advocates. While the site has been regularly and incrementally enhanced over the years, we have produced a significantly new version (release 2012/Q1) that overcomes past challenges such as content discovery, referencing and cross-referencing very complex content, refining user experience, and extending content.

GIS technology and techniques are used throughout all phases from the back-end data preparations to the front-end rich Internet application. This presentation will cover the primary lessons learned over the years with particular emphasis on how those lessons, combined with new UX techniques and new technology, solved real-world problems. Our technology stack includes Esri ArcGIS for Server, .NET MVC, jQuery, and Microsoft SQL Server.

Annual fitness testing in schools provides a novel source for analyzing trends in childhood obesity. Each year, public school students across California take part in physical fitness tests that evaluate performance according to benchmarks. Students who do not meet the standard are said to fall outside the Healthy Fitness Zone (HFZ). We characterized childhood obesity by determining the percentage of students, by school ZIP Code, who fell outside of the HFZ. Data for students in grades 5, 7, and 9 at all schools located within each ZIP Code was aggregated and the Percent Overweight, Relative Standard Error, and Confidence Intervals were calculated.

The resulting maps and data products demonstrate dramatic differences across communities. The results have been used in presentations and publications, leading to local press coverage. Local policy makers, community coalitions, and researchers have used the data to plan interventions and refine outreach efforts.

In February 2011, the City of Redlands deployed a smartphone application with Esri-partner CitySourced. Up until February, reports of infrastructure issues (graffiti, potholes, abandoned vehicles, etc.) would have to be called in to a particular phone number at the City. The City desired to provide an easier way for the residents and visitors to Redlands to report infrastructure issues as they encountered them utilizing smartphone technology. The CitySourced phone app is supported on all versions of smartphones (iPhone, Android, BlackBerry, and Windows Phone 7) and is anticipated to interact with the City's primary work order system (CityWorks) in a completely automated manner.

This presentation will highlight the history of work orders and volumes for Redlands, the initial implementation process of CitySourced, the current success stories, and what future phases are anticipated to bring to the efficiency and effectiveness of City staff to support our community.

The District 11 GIS team provides "traditional" GIS support, internal web applications and data services supporting a wide range of business processes and workflows. Internal applications are focused within specific business areas to facilitate workflow efficiencies, decision making support and transparency. A key challenge we've faced is placing content into the public domain to support external customers.

ArcGIS Online enables us to publish focused, map-based content that can be shared with partner agencies, stakeholders, ArcGIS Online groups, and the public. This content provides added value within our external facing web pages and helps streamline public awareness and marketing activities. Further, using ArcGIS Online resources improves our ability to display data and information related to Caltrans assets and programs, complementing our existing GIS framework.

This framework, and the examples covered in our presentation, underscore our approach to developing focused, simple and repeatable in-house solutions using existing resources and off-the-shelf technology.

The Special Districts Division is responsible for submitting over $30,000,000 of city special assessments to the County of San Bernardino Auditor-Controller/Treasurer/Tax Collector for the yearly property tax bills.

This presentation will discuss how GIS has allowed the Special Districts Division to improve the efficiency and effectiveness of managing the special assessment by utilizing ArcGIS 10 models and Python scripts to reduce data formatting time while improving data quality and the ability to go out in the field utilizing hand held mobile devices to collect and edit data. GIS has allowed the Special Districts Division to deliver improved public value to the residents of Rancho Cucamonga by having the ability to audit streetlight pole data while working with Southern California Edison to redo the billing for the Street Lighting Maintenance Districts. This project will ensure that the districts pay their fair and equitable share of the street lighting costs.

The City of Fontana has been working for the last nine years to achieve a geocentric organization. With the rollout of our CRW TrakIT Permitting solution, the city has integrated with GIS the majority of the city operation, with a GIS database at the core of the department's operations. TrakIT completes the integration of GIS within the development services of the City of Fontana.

The Public Works department was the first geocentric department, and brought the Enterprise GIS database into active use within the city. The Police use the same street network for dispatching as Public Works uses for their work order and asset system.

With TrakIT, Code Enforcement, Engineering, Building and Safety, Fire and Planning are using the same Permitting Database and GIS databases to track and transfer information. The TrakIT system provides both a mobile and desktop GIS interface to improve accuracy and productivity. The Mobile TrakIT system was enhanced to our specs to meet the needs of Code Enforcement in a true GIS-centric application.

Some of the most accurate and detailed information about the land we live and work on is captured in CAD-based software. CAD data is predominantly used by land surveyors and civil engineers to map and design everything from parks, roads, and buildings to bridges and flood control channels. This information, stored in CAD-based platforms, requires a level of knowledge and operational understanding that is complex for a non-CAD-minded individual to understand.

This session will focus on the technical process of converting an aerial topographic survey into the Esri Topographic Basemap Template. The information provided will be based on real-world experiences, highlighting successes and failures and how roadblocks were avoided during the conversion process. Included will be tips and tricks on how to avoid common mistakes when converting highly accurate data into GIS features.