SQL requests retrieve land information data for display or download. Running on the Water Service Department's Windows NT server, the system connects to the City's UNIX Web server and GIS data. The application enables users to view a variety of water and sewer data including parcel ownership and facility information. Field personnel can search for an address, assessor parcel number, street intersection, quarter section, and owner name. Other features identify attributes on each layer.
Screen prints provide users with hard-copy output.
Another unique aspect of the application enables users to create mailing labels of defined areas. These labels are helpful for notifying customers about service interruptions and other events. Users retrieve the mailing label information in a Microsoft Excel spreadsheet within the browser. More than half of the department's remote sites already have the new application up and running. Terry Dorschied, the Application Development Team supervisor at the Water Service Department, said that his group is still in the process of training personnel and testing some of the connections to the field offices.