Case Tracking and Mapping System Developed for the United States Attorney's Office, Southern District of New York, 1997-1998

This collection grew out of a prototype case tracking and crime mapping application that was developed for the United States Attorney's Office (USAO), Southern District of New York (SDNY). The purpose of creating the application was to move from the traditionally episodic way of handling cases to a comprehensive and strategic method of collecting case information and linking it to specific geographic locations, and collecting information either not handled at all or not handled with sufficient enough detail by SDNY's existing case management system. The result was an end-user application designed to be run largely by SDNY's nontechnical staff. It consisted of two components, a database to capture case tracking information and a mapping component to link case and geographic data. The case tracking data were contained in a Microsoft Access database and the client application contained all of the forms, queries, reports, macros, table links, and code necessary to enter, navigate through, and query the data. The mapping application was developed using Environmental Systems Research Institute's (ESRI) ArcView 3.0a GIS. This collection shows how the user-interface of the database and the mapping component were customized to allow the staff to perform spatial queries without having to be geographic information systems (GIS) experts. Part 1 of this collection contains the Visual Basic script used to customize the user-interface of the Microsoft Access database. Part 2 contains the Avenue script used to customize ArcView to link the data maintained in the server databases, to automate the office's most common queries, and to run simple analyses.