| 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 SFTPFileZilla or WinSCP may be used. For login details, contact the Department of Justice. I'm using WinSCP, and here are some screenshots.  After logging in, you have two options: "TEST" for the test environment and "PROD" for the production environment.   In this image, I used the term "PROD," which stands for the production environment. The structure of the TEST environment is the same. I have two options after selecting "PROD": "incoming to DOJ" and "responses from DOJ." In the "incoming to DOJ" area, you can upload four distinct file types. I select the "XML" folder because I am uploading XML files. I usually begin my initial upload with 1000 files. If everything goes well, I'll upload 5,000, 10,000, and ultimately 20,000 files. DOJ has a service that operates at night to handle these files. After the files have been processed, a report will be given to the "responses from DOJ" folder. A csv file containing the following report may be found: SDCS Summary [Agency-ORI] [Date].csv. Submitting STOP Data through Web Service- to be updated - | You describe it, I build itGreat software is not cheap to make.
|