╬ Cory Vardaman

Project Manager

╬ Joe Clark

Assistant Manager

╬ Lisa Albanese

GIS Technician, Web Master

╬ Ethan Roberts

GIS Analyst, Graphics Design

Warrant Visualization and Mapping:

Improved Criminal Information Management Using GIS

Prepared for the New Braunfels Police Department in

response to the Request for Proposal

Summary

The Problem: Un-served warrants

• Offenders “getting away with it”

• Increased administrative backlog”

• Uncollected revenue

The Answer:

• GIS can manage and visualize information

• Provides a useful tool to enhance law enforcement altogether

Purpose

What will Apache Tracker Geospatial do for the NBPD?

• Design a tool to map active warrants

• Graphically display warrants

• Increase efficiency

Scope: New Braunfels ETJ

Why? …The ETJ is the only area NBPD can serve warrants

Data

Data File type SourceAddress Points Shapefile CNB

Center Line Shapefile CNB

Surface Shapefile CNB

Streams/Water Shapefile CNB

Building Footprints Shapefile CNB

Parcels Shapefile CNB

Police Districts Shapefile CNB

Extra Territorial Jurisdiction

Shapefile CNB

Warrant Table .XLS Table NBPD

Methodology

Phase I: Data Preparation/ File Conversion

Phase II: Basic Warrant Tool Development

Phase III: Advanced Tool Construction

Phase IV: Tool Proofing and Refinement

Phase I: Data Preparation

CRIMES Database

Municipal Court Multiple Warrant Data

Phase I: Data Preparation / File Conversion

Task: Obtain and prepare warrant attributes for geocoding

How: Active Warrant File (AWC) Conversion

Goal: Create reference data

BatchingFor ease of data conversion, a sample of active warrants and its attributes will be extracted from the CRIMES warrants database in a tabular spreadsheet .xls. This data will be used as reference data in the geocoding model.

Click to edit the outline text format Second Outline Level

Third Outline Level

Fourth Outline Level

Fifth Outline Level

Sixth Outline Level

Seventh Outline Level

Eighth Outline Level

Ninth Outline LevelClick to edit Master text styles

Second level

Third level

Fourth level

Fifth level

Phase II: Basic Warrant Tool Development

• Task: Match warrant address field to geographic address.

• How: Geocode

Reference Data + Address layers = Address Locator

Address Locator Style

Primary Layer – Point Address Data

Secondary Layer – Street Data to catch unmatched addresses.

• Goal: Create warrant file (point file) address locator as a resource.

Click to edit the outline text format Second Outline Level

Third Outline Level

Fourth Outline Level

Fifth Outline Level

Sixth Outline Level

Seventh Outline Level

Eighth Outline Level

Ninth Outline LevelClick to edit Master text styles

Second level

Third level

Fourth level

Fifth level

Phase III: Advanced Tool Construction

Task: Geocoded warrant file implemented with additional map layers to create:

• File geodatabase

• Map document

Reference map design

How: The selected map layers and the geocoded warrant file will be inputted into a file geodatabase that can be employed into the NBPD server along with the reference ready map document.

Goal: Complete tool

Click to edit the outline text format Second Outline

Level Third Outline

LevelFourth Outline Level Fifth Outline Level

Sixth Outline Level

Seventh Outline Level

Eighth Outline Level

Ninth Outline LevelClick to edit Master text styles

Second level

Third level

Fourth level

Fifth level

Click to edit the outline text format Second Outline

Level Third Outline

LevelFourth Outline Level Fifth Outline Level

Sixth Outline Level

Seventh Outline Level

Eighth Outline Level

Ninth Outline LevelClick to edit Master text styles

Second level

Third level

Fourth level

Fifth level

Phase IV: Tool Proofing and Refinement

Tasks: Implementation, testing, troubleshootingAdditional project considerations (optional)

How: Test run with at Texas State. Test run at Police Department.

Warrant model will be installed within the NBPD server through Mike Parma, GIS Coordinator for New Braunfels. He requests the geoprocessing tool output in geodatabase format configurable to their ESRI servers.

Goal: Satisfactory results in testing and troubleshooting.

Additional Tools

Analysis Purposes

• Dispatchers and Administrative support expressed interest in using the model for analysis purposes such as mapping hot spots or high density locations.

If time permits, the group has the option to work on additional tools:

Querying

Hot Spot Management

• Officers expressed interest in the ability to query warrant data to optimize their search based on criteria they feel is important. Mr. Parmer indicated web mapping applications, such as querying, is task he may have to build into the model in the future.

Implications

Supporting the New Braunfels Police Department in

effectively serving outstanding warrants by:

• providing a tool that dispatchers will use to produce maps

• providing officers a graphic visualization of outstanding warrants

• offering other important updated data including…

1. the number of warrant(s)

2. fine amount

3. age of warrant(s)

4. and any other information contained in the CRIMES warrant records

Timeline

Phase I: Data Preparation/Collection

• .XML warrant file extraction and cleaning

• CRIMES Dispatch system “batching”

• Testing of converted files

• Data collection 

 

 

 

 

Phase II: Basic Warrant Development Tool

• Address locator referencing (standardized address)

• Warrant file geocoding

• Additional refinement 

 

 

 

Phase III: Advanced Tool Construction

• Geocoded warrant file implementation

• Creation of file geodatabase and map document

• Model streamlining

• Reference map design

 

 

Phase IV: Tool Proofing and Refinement

Model enhancement with data recycling

Warrant model installed and tested on NBPD

server

Troubleshooting

Additional project considerations

 

 

 

Mon Tue Wed Thur Fri Sat Sun

27 28 29 1 2 3 4

5 6 7 8 9 10 11

12 13 14 15 16 17 18

19 20 21 22 23 24 25

26 27 28 29 30 31 1

Mon Tue Wed Thur Fri Sat Sun

30 31 1 2 3 4 5

6 7 8 9 10 11 12

13 14 15 16 17 18 19

20 21 22Proposal Presentation

23 24 25 26

27 28 29 1 2 3 4

Mon Tue Wed Thur Fri Sat Sun

26 27 28 29 30 31 1

2 Progress

Report

3 4 5 6 7 8

9 10 11 12 13 14 15

16 17 18 19 20 21 22

23 24 25 27 27 28 29

30 

1 2 3 4 5 6

Mon Tue Wed Thur Fri Sat Sun

30 1 2 3 4Final Report

5 6

7 8 9 10 11 12 13

14 15 16 17 18 19 20

21 22 23 24 25 26 27

28 29 30 31 1 2 3

February

March

April

May

1

2

4

56

7

89

10

11

3

Timeline

Phase I: Data Preparation/Collection

• .XML warrant file extraction and cleaning

• CRIMES Dispatch system “batching”

• Testing of converted files

• Data collection 

 

 

 

 

Phase II: Basic Warrant Development Tool

• Address locator referencing (standardized address)

• Warrant file geocoding

• Additional refinement 

 

 

 

Phase III: Advanced Tool Construction

• Geocoded warrant file implementation

• Creation of file geodatabase and map document

• Model streamlining

• Reference map design

 

 

Phase IV: Tool Proofing and Refinement

Model enhancement with data recycling

Warrant model installed and tested on NBPD

server

Troubleshooting

Additional project considerations

 

 

 

Mon Tue Wed Thur Fri Sat Sun

27 28 29 1 2 3 4

5 6 7 8 9 10 11

12 13 14 15 16 17 18

19 20 21 22 23 24 25

26 27 28 29 30 31 1

Mon Tue Wed Thur Fri Sat Sun

30 31 1 2 3 4 5

6 7 8 9 10 11 12

13 14 15 16 17 18 19

20 21 22Proposal Presentation

23 24 25 26

27 28 29 1 2 3 4

Mon Tue Wed Thur Fri Sat Sun

26 27 28 29 30 31 1

2 Progress

Report

3 4 5 6 7 8

9 10 11 12 13 14 15

16 17 18 19 20 21 22

23 24 25 27 27 28 29

30 

1 2 3 4 5 6

Mon Tue Wed Thur Fri Sat Sun

30 1 2 3 4Final Report

5 6

7 8 9 10 11 12 13

14 15 16 17 18 19 20

21 22 23 24 25 26 27

28 29 30 31 1 2 3

February

March

April

May

1

2

4

56

7

89

10

11

3

Timeline

Phase I: Data Preperation/Collection

• .XML warrant file extraction and cleaning

• CRIMES Dispatch system “batching”

• Testing of converted files

• Data collection 

 

 

 

 

Phase II: Basic Warrant Development Tool

• Address locator referencing (standardized address)

• Warrant file geocoding

• Additional refinement 

 

 

 

Phase III: Advanced Tool Construction

• Geocoded warrant file implementation

• Creation of file geodatabase and map document

• Model streamlining

• Reference map design

 

 

Phase IV: Tool Proofing and Refinement

Model enhancement with data recycling

Warrant model installed and tested on NBPD

server

Troubleshooting

Additional project considerations

 

 

 

Mon Tue Wed Thur Fri Sat Sun

27 28 29 1 2 3 4

5 6 7 8 9 10 11

12 13 14 15 16 17 18

19 20 21 22 23 24 25

26 27 28 29 30 31 1

Mon Tue Wed Thur Fri Sat Sun

30 31 1 2 3 4 5

6 7 8 9 10 11 12

13 14 15 16 17 18 19

20 21 22Proposal Presentation

23 24 25 26

27 28 29 1 2 3 4

Mon Tue Wed Thur Fri Sat Sun

26 27 28 29 30 31 1

2 Progress

Report

3 4 5 6 7 8

9 10 11 12 13 14 15

16 17 18 19 20 21 22

23 24 25 27 27 28 29

30 

1 2 3 4 5 6

Mon Tue Wed Thur Fri Sat Sun

30 1 2 3 4Final Report

5 6

7 8 9 10 11 12 13

14 15 16 17 18 19 20

21 22 23 24 25 26 27

28 29 30 31 1 2 3

February

March

April

May

1

2

4

56

7

89

10

11

3

Timeline

Phase I: Data Preperation/Collection

• .XML warrant file extraction and cleaning

• CRIMES Dispatch system “batching”

• Testing of converted files

• Data collection 

 

 

 

 

Phase II: Basic Warrant Development Tool

• Address locator referencing (standardized address)

• Warrant file geocoding

• Additional refinement 

 

 

 

Phase III: Advanced Tool Construction

• Geocoded warrant file implementation

• Creation of file geodatabase and map document

• Model streamlining

• Reference map design

 

 

Phase IV: Tool Proofing and Refinement

Model enhancement with data recycling

Warrant model installed and tested on NBPD

server

Troubleshooting

Additional project considerations

 

 

 

Mon Tue Wed Thur Fri Sat Sun

27 28 29 1 2 3 4

5 6 7 8 9 10 11

12 13 14 15 16 17 18

19 20 21 22 23 24 25

26 27 28 29 30 31 1

Mon Tue Wed Thur Fri Sat Sun

30 31 1 2 3 4 5

6 7 8 9 10 11 12

13 14 15 16 17 18 19

20 21 22Proposal Presentation

23 24 25 26

27 28 29 1 2 3 4

Mon Tue Wed Thur Fri Sat Sun

26 27 28 29 30 31 1

2 Progress

Report

3 4 5 6 7 8

9 10 11 12 13 14 15

16 17 18 19 20 21 22

23 24 25 27 27 28 29

30 

1 2 3 4 5 6

Mon Tue Wed Thur Fri Sat Sun

30 1 2 3 4Final Report

5 6

7 8 9 10 11 12 13

14 15 16 17 18 19 20

21 22 23 24 25 26 27

28 29 30 31 1 2 3

February

March

April

May

1

2

4

56

7

89

10

11

3

Timeline

Phase I: Data Preperation/Collection

• .XML warrant file extraction and cleaning

• CRIMES Dispatch system “batching”

• Testing of converted files

• Data collection 

 

 

 

 

Phase II: Basic Warrant Development Tool

• Address locator referencing (standardized address)

• Warrant file geocoding

• Additional refinement 

 

 

 

Phase III: Advanced Tool Construction

• Geocoded warrant file implementation

• Creation of file geodatabase and map document

• Model streamlining

• Reference map design

 

 

Phase IV: Tool Proofing and Refinement

Model enhancement with data recycling

Warrant model installed and tested on NBPD

server

Troubleshooting

Additional project considerations

 

 

 

Mon Tue Wed Thur Fri Sat Sun

27 28 29 1 2 3 4

5 6 7 8 9 10 11

12 13 14 15 16 17 18

19 20 21 22 23 24 25

26 27 28 29 30 31 1

Mon Tue Wed Thur Fri Sat Sun

30 31 1 2 3 4 5

6 7 8 9 10 11 12

13 14 15 16 17 18 19

20 21 22Proposal Presentation

23 24 25 26

27 28 29 1 2 3 4

Mon Tue Wed Thur Fri Sat Sun

26 27 28 29 30 31 1

2 Progress

Report

3 4 5 6 7 8

9 10 11 12 13 14 15

16 17 18 19 20 21 22

23 24 25 27 27 28 29

30 

1 2 3 4 5 6

Mon Tue Wed Thur Fri Sat Sun

30 1 2 3 4Final Report

5 6

7 8 9 10 11 12 13

14 15 16 17 18 19 20

21 22 23 24 25 26 27

28 29 30 31 1 2 3

February

March

April

May

1

2

4

56

7

89

10

11

3

Project Budget: Development

Development

Depreciation

Supplies/Maintenance

Licensing/Software

Travel Expenses

400 Total Hours11 Weeks

$9,400

60%

Project Budget: Licensing/Software

Development

Depreciation

Supplies/Maintenance

Licensing/Software

Travel Expenses

$5208

34%

Industry Leading ESRI ArcGIS PackageUtilized by experienced individualsProduces a quality product targeted for other licensees

Project Budget: Subsidiary Expenses

Development

Depreciation

Supplies/Maintenance

Licensing/Software

Travel Expenses

$4403%

$270.832%

$1201%

Total: $15,439.16

Final Deliverables► Warrant Tool and Geodatabase*

► Final Report (Hard Copy)

► Display Poster

► Electronic Data Copy (CD Format)

• Additional Shapefiles

• Metadata

• Final Report

• Power Point Presentation

• Manuals

• Readme File

Note: All electronic deliverables will undergo format compatibility

Conclusions

• Will be a user friendly tool that can be easily updated

• Assist with “in the field time management”

• Enhance planning operations

• Help provide a foundation for further GIS integration

Questions…

Point of Contact: Ethan Roberts…………..…ethanroberts@txstate.edu