"Our office adopted FileMaker Pro as its primary database solution in the early 1990s," notes Ronald Baldwin, the county Director of Emergency Services. "The office was responsible for managing a large amount of data from 2300 business sites, making it easy for businesses to comply, thus improving the quality and accuracy of data in the database and making the data immediately available to public safety agencies for their use in emergency response. The office also wanted a database application that could be developed and maintained by non–technical persons in the office to eliminate over reliance on outside consultants and third party applications."
FileMaker Pro has proven to be a sound foundation for the development of our web–based compliance system.
The office worked with Richard Carlson Consulting, Inc. to implement a web–based Hazardous Materials Program Compliance System, creating a web based interface to the main FileMaker Pro database using WebStar and Lasso software. Businesses log into the system using unique passwords, and are able to adjust or update their emergency response plan information as needed. These updates result in an automatic notification to Office of Emergency Services personnel, so that hard copies may be printed out for backup. Public safety agencies are issued their own passwords, granting immediate 24–hour access to the entire database, so that if an emergency happens, the necessary response plan is just a click away. All telephone contacts or correspondence related to the system can also be generated automatically from within the database which contains over 5300 facility records — both existing and defunct businesses — along with 18,000 records documenting specific characteristics and quantities of individual hazardous materials handled in the community. All of this information is managed using a series of 10 related FileMaker Pro databases.