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 | 4 | 5 | 6 | 7 | 8 | [ 9 ] | 10 | 11 | 12 | 13 | Next | Last ( 446 Resources)


HunchLab (Software)

Vendor: Azavea Telephone: 215-925-2600 Description: HunchLab provides law enforcement agencies with easy-to-use tools for crime mapping and analysis delivered via the web browser. It is an ideal solution for local, state, and national law enforcement agencies as well as fusion centers. HunchLab provides capabilities that extend far beyond basic crime visualization tools. Through geographic data mining and risk forecasting, HunchLab provides actionable intelligence that agencies can use to more effectively deploy resources.

Key features:
- Crime Analysis: intelligence dashboard, clustered incident maps, trend identification and animation, temporal analysis
- Early Warning: statistical and threshold-based alerting
- Risk Forecasting: near repeat pattern analysis and incident load forecasting

Crime analysts winning 'chess game' against criminals in Surrey (Success Stories)

The analysts sift through the daily complaint files, crunch down the info and enter it into a database, then map things out, searching for common themes. If everything works out, voila! A trend is identified...

Link Explorer (Software)

Vendor: Xanalys Limited Telephone: +44 161 941 7792 Description: Link Explorer is a desktop software application that allows you to apply powerful query and analysis techniques to your data, presenting the answers in a range of visualisations such as link charts, time lines, maps and reports.

By modelling data as set of objects (people, places, events, etc.) and the associations that exist between them, Link Explorer provides clarity to complex data sets.

Connect directly to an existing database or use Link Explorer's import features to collate data from different sources. Link Explorer will allow you slice and dice your data, pulling interesting sets of results from one chart into another, or drilling into key objects to reveal associated information.

Knoxville Police Chief Praises Crime Analysis (Success Stories)

In this TV10 interview, Knoxville Chief Sterling Owen discusses crime decreases in the city of Knoxville and attributes some of their success to the crime analysis unit.

Sorting Access Crosstab Columns (Tip)

Have you ever created a Access crosstab (crime by month, for example), and the columns ended up sorted alphabetically as April, August, December...instead of January, February, March?

This quick tip shows you an easy way to fit it:


This works in Access 2003 and up.

Use A Digital Certificate To Encrypt Your Personal E-Mail (Article)

Michael Chesbro (2010). Instructions on how to obtain a personal digital certificate and use it to encrypt e-mail.

A digitally signed and encrypted e-mail confirms that the message actually came from you, that it has not been altered during transmission, and because it's encrypted it can only be read by the intended recipient (i.e. the person whose digital certificate you used to encrypt the message).

Fast and Easy Search for your Outlook Email (Tip)

In the search bar in Microsoft Outlook 2007, you can enter keywords and Outlook will search for those words in the current folder. But you can also add other filters without having to do an advanced search (which takes longer).

For example, you can go to your sent items folder and enter this into the search box:

to:joe smith contents: robbery bulletin

To retrieve emails that you sent to Joe Smith pertaining to a robbery bulletin.

Or you can search your inbox, read mail, or other folders for:

from: susan davis subject: survey

To get emails from susan about that survey you were supposed to complete for her.

This Microsoft website lists all of the available options: http://tinyurl.com/22mpdlx for doing quick searches in Outlook 2007.

Split time from dates and times in multiple fields (Tip)

Use this function to split time from date/time fields

Function ACalcSTime(d1 As Range, t1 As Range, d2 As Range, t2 As Range) As String
Dim dt_start As Date
Dim dt_end As Date

'Make sure the start time has a colon separating hours and minutes
foo = t1.Value
If Len(foo) = 4 Then foo = Left(foo, 2) & ":" & Right(foo, 2)
dt_start = d1.Value & " " & foo

'Make sure the end time has a colon separating hours and minutes
foo = t2.Value
If Len(foo) = 4 Then foo = Left(foo, 2) & ":" & Right(foo, 2)
dt_end = d2.Value & " " & foo

dt_split = ((dt_end - dt_start) / 2) + dt_start

ACalcSTime = dt_split
End Function

Sort by font color in Excel 2007 (Tip)

This quick tip: http://tinyurl.com/4rlrlq2
shows you how to sort Excel data by font color.

Integrated Intelligence And Crime Analysis: Enhanced Information Management For Law Enforcement Leaders (Book)

Jerry H. Ratcliffe (2007). ISBN: . Description: Data and information about the criminal environment and criminal activity abound: the challenge is to corral this wealth of data into knowledge that can enhance decision making, improve strategies to combat crime, and increase crime prevention benefits. In other words, the aim is to convert data and information into actionable intelligence. This report is designed to identify the key challenges limiting criminal intelligence sharing, the aims of the integrated analysis model, and the way that all police departments, big or small, can work individually and collectively towards the new intelligence-led policing paradigm of modern policing.

Problem Analysis In Policing (Book)

Rachel Boba (2003). ISBN: . Description: This report introduces and defines problem analysis and provides guidance on how problem analysis can be integrated and institutionalized into modern policing practices. This report is not a “how to” guide on conducting problem analysis, but is a summary of ideas and recommendations about what problem analysis is, what skills and knowledge are necessary to conduct it, and how it can be advanced by the police community, academia, the federal government, and other institutions. The ideas and recommendations in this report come primarily from a two-day forum conducted in February 2002 by the Police Foundation and the US Department of Justice’s Office of Community Oriented Policing Services (COPS Office), in which a group of academics, practitioners, and policy makers came together to discuss problem analysis and make recommendations for its progress. This report is a culmination of the concepts and ideas that were discussed in the forum and includes specific, relevant statements made by participants.

Selecting The Best Analyst For The Job: A Model Crime Analyst Assessment Process For Law Enforcement Agencies (Book)

Karen L. Amendola and Greg Jones (2010). ISBN: . Description: The rapid growth in applications and usage of crime mapping and analysis in law enforcement agencies in recent years has increased job opportunities for new analysts. As crime analysis has become an established profession, there is a need for consensus about the specific knowledge, skills, abilities, and other characteristics and the extent of formalized training necessary for new analysts. Through various discussion channels, including in-house forums, focus groups, visits with crime analysis units, and participation at annual crime mapping conferences, the Police Foundation’s Crime Mapping and Problem Analysis Laboratory recognized the importance of creating hiring standards and a systematic and comprehensive hiring process for selecting highly capable crime analysts. This publication and accompanying appendices on CD-ROM focus on defining the job of a crime analyst and on a model procedure for selecting the best possible crime analyst for a law enforcement agency

Troopers Use Science, Geography to Target Drunk Drivers (Success Stories)

…Analysts like Marcia Marsh chart each crash, then overlays that with other data such as where 911 calls come in reporting suspected drunks. Using that, enforcement strategies are plotted, so troopers can be in position around these hot spots to intercept drunk drivers, before they crash and kill...

View Analysts Notebook Charts for Free (Tip)

Download the free ChartReader application from here:


to view charts creating using i2's Analysts's Notebook.

It Strategic And Operational Controls (Book)

John Kyriazoglou, CICA, M.S., B.A (Hons) (2010). ISBN: . Description: BOOK SYNOPSIS

This book is about Information Technology (IT) Strategic and Operational Controls. IT controls enable and support all management levels of the organization (top, middle, and lower) to accomplish the IT strategic and operational goals of the organization. The book covers all the IT areas and is structured in ten chapters and a set of appendices, as noted below:


Vital information on how to systematically implement IT strategic and operational controls to support and enhance your organisation!

Nowadays, integrated information systems can significantly magnify the accrued benefits of a given project and greatly strengthen an organisation, but such benefits are balanced by a serious risk. If IT systems are not used in a disciplined manner they can create havoc and they frequently bring about unexpected results and catastrophe, as shown by the rise in security incidents and computer-based crimes.

Master IT controls concepts and issues. Written with practicality and convenience in mind, this book is an ideal tool for those without specialised technical expertise seeking to understand IT controls and their design, implementation, monitoring, review and audit issues.

Minimise risk and maximise benefits. This book provides a comprehensive guide to implementing an integrated and flexible set of IT controls in a systematic way. It can help organisations to formulate a complete culture for all areas which must be supervised and controlled; allowing them to simultaneously ensure a secure, high standard whilst striving to obtain the strategic and operational goals of the company.

Benefits to business include:
(1) Understand and control the associated risks of IT systems. This book contains practical advice and illustrates solutions to the
tremendously complicated problems of designing, implementing and auditing new and existing systems, making use of practical and easily customisable examples.
(2) Increase management’s aptitude to achieve operational goals. With well-controlled, integrated and robust IT systems, you can gain a comparative advantage in a
competitive environment, whilst ensuring that information is relevant, accurate and timely.
(3) Ensure high standards within your IT systems. For each covered aspect of control, this book provides audit programmes and checklists to help management and auditors
carry out reviews and audits. As an additional aid, there is an appendix comprising guidelines and examples of ‘how to enhance’ IT security, IT policies and ethical code.
Auditors will find reference to a large number of very relevant tools for use in auditing and reviewing IT operations.

Making use of a clear and pragmatic presentation, this book provides a thorough description of all elements of IT controls in a systematic and detailed way,
allowing managers, IT professionals, practitioners and auditors to customise examples to their own specific purpose. It is a comprehensive tool for anyone who
wishes to cement their understanding of IT controls and, most importantly, for those who aim to realise the full capacity of information systems, whilst rigorously controlling the concomitant risks.

VAIL - Virtual Analyst Intelligence Logic (Software)

Vendor: Sentinel Software Group Telephone: 888-892-6096 Description: VAIL ( Virtual Analyst Intelligence Logic ) dramatically increase the productivity and efficiency of traditional crime analysis by automatically ‘crunching’ available source systems and identifying qualified leads or patterns that human analysts can then review, verify and take action against. The VAIL engine continually analyzes input sources using codified analytic best practices and delivers a more consistent and broader analysis of all available information than could be achieved using traditional analysis tools and techniques – and in real time. The system identifies patterns using all the available information in structured and unstructured narrative fields including people and their relationships, time and place, vehicles, narcotics, weapons, gangs and organizations, numbers or identifiers like phone numbers and most importantly descriptive modus-operandi or other personal traits.

List of State and Local Government Agencies (Tip)

A website list of agencies by state that you may find helpful: http://www.statelocalgov.net

Howard County Public Safety Officials Trim Money, Not Patrols (Success Stories)

…despite making cuts elsewhere in its spending plan, the department added a crime analyst to its force. Adding the analyst, McMahon said, is a money-saving move…

LAPD Tries to Predict Crimes Before They Occur (Success Stories)

The future of crime fighting begins with a story about strawberry Pop-Tarts, bad weather and Wal-Mart…

Maptitude Mapping Software (Software)

Vendor: Caliper Corporation Telephone: 617-527-4700 Description: The Maptitude Geographic Information System (GIS) is a lower priced professional mapping software system that provides everything you need to realize the benefits of desktop mapping and spatial analysis within a single package.

Google Alerts - Receive Email Updates of Relevant Google Results (Tip)

Google Alerts are email updates of the latest relevant Google results (web, news, etc.) based on your choice of query or topic.

Google Alerts uses the Google search function to locate recent content based on your chosen search terms and then sends that content to your e-mail.
The search terms can include advanced search functions, such as “filetype:” and “site:”.

For example to search on just government domains you would enter your search term followed by “site:.gov”, and if you only wanted to search for MS Excel spreadsheets you would enter your search term followed by “filetype:xls”.

Each alert you create allows you to choose whether you want to search everything (i.e. all of Google), or limit your search to news, blogs, video, or discussions.

You can receive an e-mail with your results as the happen, or once daily, or once weekly.

Google Alerts is an excellent tool for keeping track of a specific topic as it is identified by Google.

Henrico Woman Credited with Catching the Granddad Bandit (Success Stories)

WRIC TV 8 Video clip showcases the work of analyst Joyce Salmon.

New Police Program Identifies High-Risk Areas (Success Stories)

Kansas City police are deploying a new tool which could drastically change the way officers patrol neighborhoods…

Joe Friday Couldn’t Do This (Success Stories)

Burlington - It wasn’t too long ago that police departments around the country still used one of the oldest methods available to deter criminals from plying their trade: An officer walking a beat…

Persistent Number Sequence in Excel (Tip)

If you want a column of numbers that keep a certain sequence when you delete rows, use this tip as a guide. If you have a list like this:

1 foo
2 bar
3 baz

with the numbers in column A, you would want a value of 1 in cell A1. Then, all other cells in column A would have this formula:

=INDIRECT("A" & ROW()-1)+1

First | Previous | 4 | 5 | 6 | 7 | 8 | [ 9 ] | 10 | 11 | 12 | 13 | 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.