/sworn-officer-import

an archive of raw data received via FOIA and some import/merge logic

Primary LanguagePython

The import requires our current django CPDB to run, but the logic should be understandable to anyone with python experience.

For the officers_import_data.csv the first column is either:

  • a positive integer, then it is matched as an officer

  • a -1: this means we will create the officer, the following rows are that officers new ID

  • a 0: could not be matched because there are multiple records this could belong to. Should be decided manually. I've added the possible matching/conflicting officer IDS after the last star column, starting at column U

a -2: possible merge, same as with 0, the possible merging officer ids are listed at the end