Welcome, Guest
I highly recommended that you sign up an account with DOJ CLEW (California Law Enforcement Web) for AB953 technical resources: https://clew.doj.ca.gov/sd-ab953. There you will find information on: system interface diagrams & specifications, lookup tables, and technical data dictionary.
On this page, I will quickly describe how to send your STOP data to the DOJ using a self-hosted web application. You may choose between Secure File Transfer Protocol (SFTP) and Web Service.

Each agency is required by the DOJ to report its statistics to the DOJ by April 1st of the following year. DOJ supports four data formats: XML, JSON, Excel, and CSV. I'll go through the two most frequent data types: XML and JSON. Other data kinds may be found in the technical data dictionary. Sample of XML and JSON format can be downloaded here: XML Sample and JSON Sample.

Submitting STOP Data through SFTP

FileZilla or WinSCP may be used. For login details, contact the Department of Justice. I'm using WinSCP, and here are some screenshots.
WinSCP LoginWinSCP Logged-in
After logging in, you have two options: "TEST" for the test environment and "PROD" for the production environment.
WinSCP LoginWinSCP Logged-in
In this illustration, I chose "PROD," which stands for the production environment. The TEST environment has the same structure. I have two choices after choosing "PROD": "incoming to DOJ" and "responses from DOJ." You may upload four different file types in the "incoming to DOJ" field. I choose the "XML" folder since I am uploading XML files.

On my initial upload, I often start off with 1000 files. I'll upload 5,000, 10,000, then 20,000 files if all goes well. To handle these files, DOJ has a service that operates at night. A report will be delivered into the "responses from DOJ" folder after the files have been processed. A report with the following name may be found in a csv file: SDCS Summary [Agency-ORI] [Date].csv.

Submitting STOP Data through Web Service

- to be updated -

You describe it, I build it

Great software is not cheap to make. Never use bad software.
MR Quick Services
Merge PDF Files
HTML to PDF
PrivacyAboutContact