1 / 7

Los Angeles County Sheriff

Los Angeles County Sheriff . Level of effort to incorporate the N-DEx XSD to participate in testing. Mapped to N-DEx XSD Successfully submitted data for validation Over 1040 man hours committed to N-DEx Current near real-time submissions via CJIS WAN. Los Angeles County Sheriff.

phuoc
Download Presentation

Los Angeles County Sheriff

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Los Angeles County Sheriff • Level of effort to incorporate the N-DEx XSD to participate in testing. • Mapped to N-DEx XSD • Successfully submitted data for validation • Over 1040 man hours committed to N-DEx • Current near real-time submissions via CJIS WAN

  2. Los Angeles County Sheriff • Started contribution to N-DEx March 2005 • Started by mapping LARCIS data element to N-DEx schema • Mapped LARCIS data to N-DEx schema version 1.0.4 (about 300 elements) • Built processes to extract, transform and submit LARCIS data to N-DEx. • Successfully submitted approx. 40,000 SOAP* messages (about a month of incident data) to FBI SOAP server) • *Simple Object Access Protocol (see www.xml.org)

  3. Los Angeles County Sheriff • Cost? • Used an old development server = $0 • Red Hat Linux, Oracle BPEL = $40,700 • One consultant = $72,800 = $113,500

  4. Los Angeles County Sheriff • WHY? • N-DEx Bundle Ver1.0.4 has about 300 elements • LARCIS has 130 tables and over 3,000 elements • Finding the right data element to map difficult • Designed a database just for that purpose • Load all the table columns into the database • Mark the column that has no value (reduces count) • Further reduce data elements by ranking the data relevance • Map remaining LARCIS to N-DEx (reasonable time) • Generate the mapping reports from the database

  5. Los Angeles County Sheriff • RECOMMENDATIONS • Need a development tool • Supports the creation of mapping • Convert to XML document • Web services (SOAP) • Eases the learning curve • Allows for a faster adoption • We used Oracle BPEL Desinger and Process Manager

  6. Los Angeles County Sheriff • RECOMMENDATIONS (cont.) • Dedicated Staff • Knowledge of GJXDM • Starting out mapping with few elements, then build the process to produce the XML document (can be sent via email) • FBI feedback • Repeat the process until you have the complete mapping

  7. GOOD LUCK

More Related