DESKTOP MAPPING FOR

FLOODPLAIN DETERMINATION

Any large metropolitan city such as Los Angeles is expected to have difficulties in managing its infrastructure. The City's Stormwater Management Division is certainly no exception. With more than 3,000 miles of storm drain conduits and over 6,400 catch basins, the management and dissemination of this information is a daunting task. To address this issue, The City of Los Angeles has contracted Psomas and Associates to provide GIS consulting services. Over the past two years, Psomas has digitally converted the City's entire storm drain system and has also developed a number of tools that have been used to access the City's stormwater GIS database.

Many of the tools designed by Psomas and Associates have integrated the most recent technologies for desktop GIS. This paper will present one of many applications that have been developed by Psomas for the City of Los Angeles' Stormwater Management Division. More specifically, we will demonstrate the effectiveness of using tools like MapObjects and Internet Map Server. In both cases, Psomas has integrated into the City's workplace, easy to use interfaces allowing City staff, or the general public, to access critical flood zone information for any property within the City.


 

I. BACKGROUND

The City of Los Angeles, with it's more than 1 million residents, is one of the largest metropolitan cities in the United States. Having more than 10,000 acres of commercial and residential landuse falling within the 100-year floodplain, Los Angeles has its share of problems with public safety and health as it relates to stormwater drainage. Additionally, the topography and often-severe weather, subjects many communities of Los Angeles to frequent localized flooding. To mitigate these conditions, the City manages an enormous number of stormdrain catch basins and conduits which re-direct storm-waters to local channels and eventually to the sea.

Protecting the safety, health and welfare of the City's residents, is one of the primary goals of the Los Angeles Stormwater Management Division. The proper mapping of these areas of the City are critical to an adequate floodplain management strategy and, the protection of the City's residents. As part of a several year program, the City of Los Angeles has entered into a far-reaching program which encompasses the GIS mapping of all stormdrain facilities, FEMA floodplains and applications to utilize this data.

II. OBJECTIVES

As with most large municipalities within the nation, Los Angeles has developed a series of broad-ranged flood management programs to meet with FEMA's National Flood Insurance Program (NFIP) guidelines. FEMA's Federal Insurance Administration runs the NFIP which makes flood insurance available to residents of communities that adopt and enforce floodplain management ordinances which represent sound land use practices. More than 18,000 communities participate and more than 3 million home and business policies are in force.

Floodplain management responsibilities are shared among federal, state, regional, and local governments. It is however, the local governments like Los Angeles, that have the most direct control in floodplain management through landuse planning and regulation, land acquisition and management, and as sponsors of the flood insurance program. With a city the size of Los Angeles administering such a large program for homes and businesses, it only seems fit that a database management system like GIS, play a critical role in managing it all.

One of the primary goals of the flood insurance program is to improve public safety and health. Additionally however, there are local government based incentives to follow the guidelines and implement positive, forward-thinking flood abatement programs. The most notable of these incentives is a federal review of municipal programs. Once a review has taken place, a city is given a rating for their program. In the event that the city's program has improved the rating, the outcome results in lower flood insurance premiums for the citizens and businesses that need to obtain flood insurance.

This paper presents one of the many applications that have been developed by Psomas and Associates to provide unique and creative solutions in floodplain mitigation for the City of Los Angeles. The application described herein, has provided the City of Los Angeles a robust toolkit which has allowed staff to query, visualize and report on stormwater related data within seconds. Psomas and Associates have also helped to develop a standardized and consistent response to stormwater related questions from the public. Moreover, the long-term implications of this paper's application indicate that data and resources that have been collected may be available via the Web, in a short period of time.

III. THE AUTOMATION OF APPLICATION CRITICAL DATALAYERS

This paper describes an application that was designed to analyze the locations of homes and businesses within the City of Los Angeles as they relate to the 100-year and 500-year floodplains. However, without the proper GIS database or infrastructure in place, much of what the project team has accomplished would not be possible.

The Stormwater Management Division (SMD) has relied on the cooperation and sharing of other City divisions for much of their critical application datalayers. In the application described below, SMD had to rely on Survey and Mapping's digital parcel database to accurately locate any one of the 980,000 addresses within the City. The parcel database was also used for spatial analysis in the project's application. The project was fortunate to have the Survey and Mapping group already have the parcel database converted. This conversion effort was a 10-year project, and encompassed the mapping of more than 780,000 parcels within the City of Los Angeles boundary.

In addition to requiring the City's parcel database, the application design required that all FEMA floodplains within the City be digitally converted. At the project's inception, a digital version of the FIRM maps was not available for Los Angeles County. This dictated that all of the 100-year and 500-year floodplains be digitized by hand. Today however, a majority of the nation's most populous regions have the FIRM maps converted. This data, known as the digital Q3 Flood Data, can be acquired through FEMA. For more information on Q3 Flood Data, please jump to http://www.fema.gov/MSC/q3flooda.htm. The project team is truly excited about the ramifications of this data's availability. The Q3 Flood Data should open the door to surrounding municipalities as well as other cities within the nation that have Q3 Flood Data. These cities can now take advantage of the City of Los Angeles' research and development work.

IV. FLOODPLAIN DETERMINATION GIS - THE APPLICATION

A. Design Goals

When the Stormwater Management Division made the decision to use GIS to help manage the National Flood Insurance Program, it was realized that there were a number of powerful applications that could be developed with current and forthcoming technologies. Seeing the opportunities in the technology, SMD had set out on an aggressive path to develop some of the nation's most resourceful applications in stormwater management.

At the forefront in development and research for SMD were Psomas and Associates. Psomas and Associates has been the primary consultant for the City of Los Angeles and possess some of the region's top programmers which have provided unique GIS solutions for the stormwater management program.

One of the primary criteria that was established from the outset of the project was the need for a consistent graphical user interface (GUI), one in which a variety of tool-sets can be placed. Some of these tools would consist of check boxes, drop-down lists, input fields and of course, maps. Recognizing the need for a specialized user environment, Psomas employed both Visual Basic 4.0 from Microsoft, and MapObjects 1.1 from Esri. The powerful combination of both software products has allowed Psomas and Associates to develop applications that provide the design flexibility that SMD was looking for.

The use of GIS has been essential in SMD meeting its goals for the NFIP guidelines. Seeing GIS as the tool that could satisfy spatial database and application needs, it was not apparent as to how the GUI solution would be addressed. It was not until the release of MapObjects 1.0 in the Fall of 1996, that the project team knew that they had found a solution. By bringing in object linking and embedding (OLE) technology, Psomas and Associates was able to integrate maps, their attributes and the data that is derived from the Visual Basic form. See figure 1 below. The result is a seamless and very robust user-interface that exchanges information effortlessly.

Figure 1: Floodplain Determination Application GUI

By bringing these two technologies together, Psomas and Associates was able to provide SMD a tool-set that allowed for quicker response to floodplain inquiries. Additionally, the application design eliminated the need for paper FIRM maps. Both improvements would yield a much more consistent response in the interpretation of maps and data resulting in quick, efficient and accurate dissemination of floodplain information to the public.

B. Major Application Features

MapObjects:

The primary function of this application is its ability to accurately identify whether or not a parcel falls within a floodplain. Subsequent to this identification process, the application will report specific floodplain details to the operator of the application. These details are relayed to someone who has inquired about the property. The information is then used to assess whether or not a property needs to obtain flood insurance.

The parcel query process has incorporated the strengths of both MapObjects and Visual Basic's Database Jet Engine. After an operator has entered an address to be searched, the Database Jet Engine takes over. Within less than 2 seconds, a database of 980,000 addresses is searched and all possible matches are returned in a scrolling list. It is this scrolling list that is used to identify the actual GIS parcel polygon. This unique method has been used because it was found that VB's Database Jet Engine was significantly faster at identifying address components than MapObjects. Once the operator has selected from the list of possible matches, MapObjects is engaged to take the unique parcel identifier from the selected address record and find its corresponding polygon among the more than 780,000 within the City of Los Angeles. The total elapsed time is approximately 3 seconds.

Following the selection of the parcel is when MapObjects plays its most significant role in GIS functionality. It is at this point that all spatial operations required for map and report output are performed. A variety of spatial queries take place to identify whether or not a parcel polygon falls within a floodplain. However, it is somewhat more difficult than just saying yes or no as to whether this property is within the floodplain.

All 3 spatial operations are required to obtain an accurate assessment of a property's liability. Total elapsed time for the above operations is approximately 2 seconds.

The Floodplain Determination application will also print out map reports for sending to the requestor. The map product generated is a representation of the screen's map window, pertinent floodplain attribute information and a FEMA FIRM map legend. See figure 3 below.

 

Figure 3: Sample Output Report

 

Visual Basic:

One of the more pronounced features of the Floodplain Determination application is the easy-to-use graphical user interface. The entire interface was designed and developed using Visual Basic 4.0. Some of the more notable features in the VB interface design are described below.

Information fields on the user-interface display all critical floodplain variables. Variables include floodplain zone, FIRM community number, FIRM panel number, depth of floodplain or its elevation and the effective date of the FIRM map.

Accounting for who is operating the application as well as who calls in to get floodplain information is of paramount importance to the Stormwater Management Division. To monitor these variables, the interface provides for input of this data as well as other call related information. Much of the data is placed in a log file for future query and tracking or in a form letter.

Form letter capability was a unique request for this application. In almost every inquisition for floodplain information, the City of Los Angeles is required to send out an official letter to the requestor, indicating the status of their property. See figure 6. This letter contains some essential information, like name, address and property address, however it also contains critical floodplain related information that was acquired from the application's spatial analysis. The final product is a two page pre-formatted letter that just needs to be initialed and sent out with a map enclosure.

Figure 6: Form Letter Generated from Floodplain Determination Application

C. Application Users

Stormwater Management Division staff are the sole users of the application currently. There are anywhere from 3 to 4 staff members at a time that receive floodplain related phone calls and use the Floodplain Determination application to answer the inquiries.

In the near future however, the project team has scheduled to release to the public a diluted version of the application via the Internet.

D. System Requirements and Configuration

The below is an outline of the recommended hardware, software and operating system that would be required for the application to function properly. In addition, we have listed other peripheral hardware and software that have been used during the project.

Other significant peripheral equipment and software:

E. Application Limitations

Many floodplain applications have incorporated intersection based spatial analysis. Meaning, that if a property is found partially within a floodplain, its polygon is "intersected" by that floodplain. The result allows for a more definitive calculation of what area falls within the floodplain and what area falls outside of that floodplain. Typically, analysis such as this would require pre-processing from within ArcInfo. The Stormwater Management Division had to make a decision from the outset regarding this type of analysis. SMD concluded that precise intersection analysis of floodplain data (mapped at 1:400 scale) could not be accurately compared to the City's parcel database (mapped at 1:50 scale). Furthermore, it was not practical to incorporate this technology into the application, so a more straight-forward (in, out or partially in) analysis was incorporated.

V. CONCLUSIONS

With respect to the project application's objectives, Psomas and Associates has successfully met with Stormwater Management Division's expectations. The Floodplain Determination application is helping the Stormwater Management Division meet with the National Flood Insurance Program guidelines. Additionally, the work-flow procedures have been stream-lined to allow more staffing hours on important safety and health related projects.

The GIS application technology that has been described will be a strategic element to Stormwater Management Division's service to the public. Further enhancements and additional NFIP related applications will continue to move the City of Los Angeles into the future using GIS.

With technology ever-changing in the GIS industry, it often times seems unclear as to the right direction to take with using software. During this project however, it has become more apparent that the integration of both MapObjects and Visual Basic is a solution that provides for enormous flexibility. Additionally, these technologies are somewhat seamless in their transition to the Internet. After all, it is the Internet that will ultimately become the purveyor of public information.

VI. ACKNOWLEDGMENTS

My personal gratitude goes to Guchuan Liu. He has made this project application a remarkable success for the Stormwater Management Division. Additional thanks go out to the remainder of the project team whom have worked so diligently on the design, development and implementation of the Floodplain Determination application.


AUTHOR INFORMATION

Rick Ayers, Assistant Project Manager and GIS Analyst

Psomas and Associates, Los Angeles Office

600 South Spring Street, Suite 1608

Los Angeles, California 90014

Tel: 213-623-3905, Fax: 213-623-3813, Email: rayers@psomas.com

 

Guchuan Liu, GIS Programmer

Psomas and Associates, Los Angeles Office

600 South Spring Street, Suite 1608

Los Angeles, California 90014

Tel: 213-623-3905, Fax: 213-623-3813, Email: gliu@psomas.com

 

Wing Tam, Engineering Manager

Stormwater Management Division, City of Los Angeles

650 South Spring Street, Suite 700

Los Angeles, California 90014

Tel: 213-847-5225 , Fax: 213-847-5443, Email: wtam@eng.ci.la.ca.us

 

Blake Murillo, Vice President

Psomas and Associates, Santa Monica Office

600 South Spring Street, Suite 1608

Los Angeles, California 90014

Tel: 213-623-3905, Fax: 213-623-3813, Email: bmurillo@psomas.com