Back to SAG Winners 2004

St. Johns River Water Management District

View Photo(s) of Award Presentation

Project Goal

The project goal is to develop an Internet GIS application to search and display water and environmental permits to the public. The application should use live SDE and Oracle databases through a secure technology environment. Any permit data changes will be reflected on the web application immediately. The web site should be easy to use for any one who may not have deep knowledge of GIS. The application should also include the latest Digital Ortho-Photos and other relevant GIS data layers. The application and data should be available all the time.

Learn more about us

Learn more about our application

View larger image

Business Problem Solved

The Consumptive Use Permitting (CUP) program includes consumptive use permit compliance and enforcement and water shortage plan support and enforcement. All persons who want to use large amounts of water, except those exempt by statute or District rule, are required to obtain a CUP. Permits for consumptive use are issued for a finite duration and, upon expiration, must be renewed. Since 1991, all water users have been required to report their water use by using a water meter or by an alternative method approved by the District.

Environmental Resource Permitting (ERP) is a tool for managing the effects of land use changes on water quantity, water quality, and wetland habitat. The program includes permit application review, compliance activities, outreach to the regulated public, and rule development. Monitoring and research activities that focus on discharges of surface water from agricultural areas also fall under the program. In addition, the program provides for collection of data on wetlands and completion of periodic assessments of wetland status and trends.

The Regulatory Permit Search Tool provides a geographic user interface to retrieve CUP/ERP permit information from the District central database over the Internet. Users can find out permit information by selecting county, permit No., section, township and user-defined area. It also can export the permit information to other reporting software such as Excel.

Technology Implemented

The CUP/ERP GIS query tool is built on the ESRI, Microsoft and Oracle technology. ArcIMS HTML viewer is the foundation for customization. Oracle and ArcSDE are used to store enterprise geo-spatial and tabular database.

Microsoft Internet Information Server is used as a web server. We also use Active Server Page (ASP) and JavaScript as development tools to customize the website. Microsoft ODBC connections are used to fetch data from a production database inside of firewall and display them on the Internet. A secure Internet infrastructure is implemented to connect database from Internet to the District’s enterprise database.

Development Team Biography

Jim Ren, Application Development Coordinator
Wei Sun, Senior Software Engineer
Jochen Floesser, Senior Software Engineer
Robert Presley, GIS Coordinator at Resources Management Department

View larger image