IACA Resource Center

Welcome to the IACA resource center. All resources such as jobs, articles, books, tips & tricks and software are here. Choose an item from below or a category from the right. IACA members can not only view but comment on resources (members must be logged in to comment).

First | Previous | 5 | 6 | 7 | 8 | 9 | [ 10 ] | 11 | 12 | 13 | 14 | Next | Last ( 446 Resources)


What Could Be: Futurists to Converge on Boston with Forecasts on Religion, Terror, and Medicine (Success Stories)

…Debra Piehl, a member of the World Future Society and the much smaller Police Futurists International, said she studies the future to anticipate technological advances by two groups: law enforcement and criminals…

Beyond The Basics: The Association Matrix (Article)

Eugene Matthews (2010). For years analysts have used the Association Matrix to help develop investigations and support their recommendations. Since its introduction the basics of the association matrix, as well as others, hasn't changed significantly. Here are a couple of suggestions on how to take an old workhorse to a new level.

Agnovi X-Fire (Software)

Vendor: Agnovi Corporation Telephone: 1-866-890-8265 Description: This powerful and easy to use electronic case management software is designed to assist investigators in managing files from initial incident to court disclosure.

The software features include: incident capture, case management, task management, disclosure management, access control, system and officer generated link analysis charts, timeline charting, volume reporting, hyper-linked and indexed case reports and more.

The Hate Directory (Article)

Raymond A. Franklin (2010). A comprehensive Document with links leading to extensive information on documented hate groups that are available on the internet. Very good information.

Policing With An IT Edge - Interview with CBC (Success Stories)

The Saint John police force is pleased with the results of its Intelligence Led Policing, software that maps and potentially reduces criminal trends. Crime Analyst James Stewart speaks to CBC news reporter Sarah Trainor about it.

Better Policing With Microsoft Office (2003 Version) (Book)

Mark A Stallo and Christopher W Bruce (2005). ISBN: 1-4196-0948-3. Description: This book demonstrates how to use Access, Excel, Word and PowerPoint to become more effective and efficient in law enforcement applications. The examples presented in this book concentrate on crime analysis and other police functions. The exercises solve real world problems in law enforcement, using fictional data. The book has been designed for a 40 hour seminar or a semester long college course. College or university faculty are encouraged to review the book for use in a crime analysis and other law enforcement application courses.

The book can be obtained by going to www.booksurge.com

Intelligence-Led Policing (Book)

Jerry H. Ratcliffe (2008). ISBN: 1843923394. Description: What is intelligence-Led policing? Who came up with the idea? Where did it come from? How does it related to other policing paradigms? What distinguishes an intelligence-Led approach to crime reduction? How is it designed to have an impact on crime? Does it prevent crime? What is crime disruption? Is intelligence-Led policing just for the police? These are questions asked by many police professionals, including senior officers, analysts and operational staff, as well as students of policing. The answers to these questions are the subject of this book."Intelligence-Led Policing" brings the concepts, processes and practice of intelligence-Led policing into focus, so that students, practitioners and scholars of policing, criminal intelligence and crime analysis can better understand the evolving theoretical and empirical dynamics of this rapidly growing paradigm. The first book of its kind, enhanced by viewpoint contributions from intelligence experts and case studies of police operations, provides a much-needed and timely in-depth synopsis of this emerging movement in a practical and accessible style.

Crime Analysis For Problem-Solvers (in 60 Small Steps) (Book)

Ronald Clarke and John Eck (2005). ISBN: B002D0917I. Description: This 60-step manual assumes that you are an experienced analyst and that you are accustomed to providing the kind of information needed to support police operations. It builds on your experience to prepare you for a different analytic role as a key member of a problem-solving team. Indeed, the latest writings on problem-oriented policing see crime analysts as central to this new way of policing communities. These writers argue that many of the weaknesses of current practice result from the insufficient involvement of well-trained crime analysts at each stage of the problem-solving process.

The manual prepares you for this new role by providing you with a basic knowledge of problem-oriented policing and the related fields of environmental criminology and situational crime prevention.

Better Policing With Microsoft Office 2007 (Book)

Christopher W. Bruce & Mark A. Stallo (2009). ISBN: 1-4392-5328-5. Description: This book demonstrates how to use Access, Excel, Word and PowerPoint to become more effective and efficient in law enforcement applications. The examples presented in this book concentrate on crime analysis and other police functions. The exercises solve real world problems in law enforcement, using fictional data. The book has been designed for a 40 hour seminar or a semester long college course. College or university faculty are encouraged to review the book for use in a crime analysis and other law enforcement application courses.

The book can be ordered on Amazon.

Exploring Crime Analysis (second Edition) (Book)

International Association of Crime Analysts (2009). ISBN: 1-4392-2042-5. Description: Full coverage of the essential skills and knowledge sets required to be a good crime analyst. Includes: crime analysis fundamentals, mapping, statistics, research methods for problem-solving, criminology theory, spreadsheets, presentations, publications, critical thinking, and more.

Crime Analysis With Crime Mapping (2nd Edition) (Book)

Rachel Boba (2008). ISBN: 1412968585. Description: One of the first books to bring crime analysis and crime mapping to an undergraduate audience and the only introductory core text available on the topic, this Second Edition of Crime Analysis with Crime Mapping provides an overview of the field, covers key analytical techniques, and discusses crime prevention and the role of crime analysis in effective policing. Enriched by author Rachel Boba’s unique perspective as an experienced academic and former crime analyst, the book offers a thorough introduction to the field as well as guidelines for practice.

Crime Analysis with Crime Mapping is designed for undergraduate and graduate courses in Criminology, Criminal Justice, Forensic Science, Criminal Investigation, GIS, Geography, and Sociology. Relevant for current and future crime analysts as well as other police practitioners, the book is valuable for practitioner training in crime analysis and crime mapping.

MapInfo Crime Profiler (Software)

Vendor: Pitney Bowes Business Insight Telephone: 1-800-327-8627 Description: MapInfo Crime Profiler™ is a highly specialized application, which provides a set of tools and mode of presentation designed specifically for the needs of crime analysts working within law enforcement agencies. It enables crime analysts to use sophisticated statistical manipulation techniques without having to enter complex queries, and reflects the typical workflow of a crime analyst.

MapInfo Crime Profiler™ removes the need for analysts to devote a substantial proportion of their efforts to time-consuming statistical manipulation, such as creating macros or pivot tables in SPSS or MS Excel. Instead, these tasks are automated through a dashboard interface. It allows the analyst to choose automated options including:

• Multiple real-time hotspotting options and kernel density visualization;
• Integrated 3D imagery including CCTV footage;
• User-specified temporal analysis (contrasting day/night or other time profiles);
• Automatic graphing and mapping creation, linking and updates; and
• Automated data, table and workspace utilities.

Crime Analyst Featured in Textbook (Success Stories)

While most people are familiar with patrol officers and police detectives, Mark Bridge's job is lesser known. "Most people who I tell that I am a crime analyst think it's CSI," he said…

REX  (Software)

Vendor: Agnovi Corporation Telephone: 1-866-890-8265 Description: Easy to use software designed for entity tracking, gang tracking and storage of information and intelligence. It is designed to be able to permit the user to enter information and immediately identify linkages based on information in the database. This software also provides system generated link analysis charts or permits the user to generate their own charts.
This system generates numerous reports including entity reports and file reports. All the reports are in a searchable PDF format with the attachments automatically hyper-linked.

Reviving The Cold Case: An Analytical Approach To Case Closure (Article)

Dobbs, Mark R. and Michael T. Voss (2009). Crime analysts are always trying to find new ways to apply their skills and hone their craft. The vast majority of us are thinkers; we are curious problem solvers who believe that our ability to benefit our agencies is limited only by the latitude we are given. It is understandable then that we should seek out more opportunities to apply our skills and make more positive impacts within our jurisdictions. It is this general attitude that led us to get involved in investigating cold cases.

Transitioning to Office 2007 - Where'd That Button Go? (Tip)

So IT just loaded Office 2007 on your computer, and you have no idea what this ribbon thingy is? Having trouble finding a particular button in an Office 2007 program? No problem!

This site contains an Excel workbook for each Office application that lists the old location and the new location for every feature:


Each tab represents a menu in Office 2003. Go to a tab, look for the feature on the left, and it will tell you where to find that feature in Office 2007. Very handy reference for learning Office 2007!

Police Crime Analyst Uses New Programs (Success Stories)

…the department crime analyst now has new computer programs to pinpoint high-crime areas, which are immediately fed into a laptop in a patrol car. Officers can find on-screen warrant information, the Return Home Registry for missing persons, where active parolees live and up-to-date crime bulletins. "Previously, officers got all of their information in briefing," Sellers said. "But when it's on the computer, it's in their face."

GPD Crime Analyst, Student are Honored (Success Stories)

A crime analyst at the Gainesville Police Department was honored for her dedication to an international professional association….

CRIMEMAP (Email List)

This group is the updated forum from the old Crime Mapping listserv. It reflects the changes and advancements in the field over the last 10 years to include visualization, statistical analysis and the respective geographic principles and theories.. Host Organization: Crime Mapping Research Center. Contact:

Custom Time Range Function For Excel (Article)

Steve Miller, Ventura County Sheriff's Dept (2010). This PDF explains how to create a custom Excel function that converts time to a range (i.e. 5:20 becomes 5:00 to 6:00).

Rounded Time and Range (Tip)

If you have a time in Excel and want a time range that respects 24-hour format time, here is a custom function. Tested in Excel 2000 and 2003.

if you need help adding the code to Excel, please see the related article here: http://www.iaca.net/Articles.asp?AID=95

Rem TimeRange - return a time +/- the number of hours from a specified time
Rem Parameters:
Rem intime - the base time
Rem hrange - the value to add and subtract to get the time range
Function TimeRange(intime As Date, hrange As Integer) As String
Dim ret As String
Dim h As Integer 'Hour of intime, beginning of the time range
Dim range_end As Integer 'High end of the range
' Calculate range start
h = Hour(intime) 'Get the hour from the base time to use as the range's starting time (we don't really need the minutes)
str_h = Trim(Str(h)) 'Convert hour to a string
If Len(str_h) = 1 Then str_h = "0" & str_h 'Make sure starting hour is 2 digits (so mornings < 10 AM have a leading 0)
'Calculate range end
range_end = h + hrange
If range_end > 24 Then range_end = range_end - 24 'Wrap the hour around to the next day if it exceeds midnight
st_range_end = Trim(Str(range_end))
If Len(st_range_end) = 1 Then st_range_end = "0" & st_range_end 'Make sure ending hour is 2 digits (so mornings < 10 AM have a leading zero)
ret = str_h & ":00 to " & st_range_end & ":00" 'Construct the string with the time range
TimeRange = ret
End Function

Schedule Access Macros to Run While You Sleep (Tip)

The tip below will allow you to automatically run a macro in Microsoft Access. While you can automatically run a macro when Access opens just by naming it autoexec (see http://www.iaca.net/AnalystToolbox.asp?TID=106) , the approach described here allows you to run a macro by any name. Best of all, you can schedule it to run whenever you want!

1) Create a macro in Access and add whatever actions you want to run.
2) Make sure that the very first action is SetWarnings = Off. In Access 2007, you must make sure the database is in a trusted location, then click the "Show All Actions" button from the design tab before the Set Warnings action will be available to use in a macro.
3) Make sure the last two actions are SetWarnings = On, followed by Exit.
4) Also remove any MsgBox actions if you have them.
5) Open Notepad and enter the following code:

cd\Program Files\Microsoft Office\Office11
Msaccess.exe C:\MyFolder\MyDatabase.mdb /x MyMacro

Where C:\MyFolder is the location of the database, MyDatabase is the name of the database, and MyMacro is the name of the macro within the database.

If the database is on a server share, you would use something like this:

Z:\MyServerFolder\ MyDatabase.mdb /x MyMacro (if the Z drive is mapped)


\\CityServer1\Police\ MyServerFolder\ MyDatabase.mdb /x MyMacro (if there is not a mapped drive)

6) In Notepad, go to File | Save As. Change the “Save as type” to ‘All Files’ and name the file with a .’bat’ extension. For example, “MyImporter.bat” or “Scheduler.bat”. You do not have to save the file in the same folder, but it need to be on the same drive.
7) Almost done! At this point, you can double click the batch file (*.bat) to open Access, run the macro, and exit. There is one final step to automate it – you need to schedule a task which calls the batch file, which in turn calls the Access Macro.
8) Open Windows Task Scheduler (Start | Programs | Accessories | System Tools | Scheduled Tasks).
9) Create a new task. When prompted to choose the program to run, click the browse button and browse to the bat file you just created. Specify a run time & frequency.
10) That’s it! On the day(s) and time(s) specified in the task, the batch file will open Access and fire off the macro, and then everything will close when it is complete.

Police Investigation: Importance In A Globalized World (Article)

HERBERT GONÇALVES ESPUNY (2008). This article deals with the importance of the criminal investigation in the context of a globalized world.

ATLAS.ti (Software)

Vendor: ATLAS.ti Scientific Software Development GmbH Telephone: +49 30 31 99 88 971 Description: ATLAS.ti helps you to uncover the complex phenomena hidden in your data. ATLAS.ti offers a powerful and intuitive work environment designed to keep your focus centered on your material.

Starlight Visual Information System (Software)

Vendor: Future Point Systems, Inc Telephone: 650-931-8660 Description: Starlight Visual Information System™ is a comprehensive visual analytics platform that transforms mountains of data into actionable intelligence. We provide software for visually managing, understanding, and deriving new knowledge from massive quantities of heterogeneous information.

Starlight tames information overload and enables users to extract new value from data of all types. We automatically organize and summarize large collections of information and present the results in easily interpretable graphical formats. In essence, Starlight is a “force multiplier”, enabling investigators and analysts to do more work with greater efficiency, accuracy, and higher levels of productivity. Using Starlight, analysts rapidly attain high-value results leading to faster time-to-decision.

First | Previous | 5 | 6 | 7 | 8 | 9 | [ 10 ] | 11 | 12 | 13 | 14 | Next | Last


Filter by Category

Search Resources


Submit a Resource



IACA members can subscribe to the RSS Resource Center. Members can receive notifications of all new resources, specific resources, all new comments, or comments only on a specific item.

If you are not member, click here to apply.