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

Version Date: Jan 18, 2006 View help for published

Cite this study |

Principal Investigator(s): View help for Principal Investigator(s)
Colin Reilly, City University of New York. Hunter College; Victor Goldsmith, City University of New York. Hunter College

https://doi.org/10.3886/ICPSR02929.v1

Version V1

Summary View help for Summary

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.

Citation View help for Citation

Reilly, Colin, and Goldsmith, Victor. Case Tracking and Mapping System Developed for the United States Attorney’s Office, Southern District of New York, 1997-1998. [distributor], 2006-01-18. https://doi.org/10.3886/ICPSR02929.v1

Export Citation:

  • RIS (generic format for RefWorks, EndNote, etc.)
  • EndNote

Funding View help for Funding

United States Department of Justice. Office of Justice Programs. National Institute of Justice (98-LB-VX-0004)

Subject Terms View help for Subject Terms

Geographic Coverage View help for Geographic Coverage

Time Period(s) View help for Time Period(s)

1997-07 -- 1998-10

Date of Collection View help for Date of Collection

1997-07 -- 1998-10

Data Collection Notes View help for Data Collection Notes

  1. The user guide and codebook are provided as a Portable Document Format (PDF) file. The PDF file format was developed by Adobe Systems Incorporated and can be accessed using PDF reader software, such as the Adobe Acrobat Reader. Information on how to obtain a copy of the Acrobat Reader is provided on the ICPSR Web site.

Study Purpose View help for Study Purpose

This collection grew out of a prototype case tracking and mapping application that was developed for the United States Attorney's Office (USAO), Southern District of New York (SDNY). The SDNY is the federal prosecuting office for Manhattan and Bronx counties in New York City, as well as Westchester County and several other northern counties. The office's primary mission is to investigate and prosecute federal crimes in these counties. The case tracking and mapping application was developed for SDNY to move from the traditionally episodic way of handling cases to a comprehensive and strategic method. The purpose was to create a system that could collect case information and link it to specific geographic locations, and collect information either not handled at all or not handled with sufficient enough detail by SDNY's existing case management system. This would give SDNY the ability to cut across agency lines and establish geographic connections between criminals and federal cooperators. The system allowed an in-depth analytic capacity of the entire federal landscape for the Southern District of New York.

Study Design View help for Study Design

The system that was created 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 study 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.

Unit(s) of Observation View help for Unit(s) of Observation

Other

Data Source View help for Data Source

Visual Basic script and Avenue script

Data Type(s) View help for Data Type(s)

Presence of Common Scales View help for Presence of Common Scales

None.

Original Release Date View help for Original Release Date

2000-09-11

Version History View help for Version History

2018-02-15 The citation of this study may have changed due to the new version control system that has been implemented. The previous citation was:
  • Reilly, Colin, and Victor Goldsmith. CASE TRACKING AND MAPPING SYSTEM DEVELOPED FOR THE UNITED STATES ATTORNEY'S OFFICE, SOUTHERN DISTRICT OF NEW YORK, 1997-1998. ICPSR version. New York, NY: City University of New York [producer], 2000. Ann Arbor, MI: Inter-university Consortium for Political and Social Research [distributor], 2000. http://doi.org/10.3886/ICPSR02929.v1

2006-01-18 File CB2929.ALL.PDF was removed from any previous datasets and flagged as a study-level file, so that it will accompany all downloads.

Notes

  • The public-use data files in this collection are available for access by the general public. Access does not require affiliation with an ICPSR member institution.

  • The citation of this study may have changed due to the new version control system that has been implemented.