drop_columns:
  - 'SOP Notes or Issues'
  - 'Insurance Company\n\n(Survey Answer: do not edit)'
  - 'How would you describe the remediation process\n\n(Please Leave Blank)'
  - 'If a professional company performed some or all of the cleanup please list the company name and location \n\n(Please Leave Blank)'
  - 'Testing Laboratories\n\nIf multiple labs, please indicate what each was testing for\n\nSeparate with &'
  - 'Main/Testing Companies\n\nIf multiple companies, please indicate what each was testing for\n\nSeparate with &'
  - 'Peak Lead Level Floor (µg/ft²)'
  - 'Peak Lead Level Windowsill (µg/ft²)'
  - 'Unit Conversion Notes\n\n(as needed)'
  - 'Peak Lead Level Category (µg/ft²)'
  - 'Sample Collection Methods and Test Types'
  - 'Extra Notes'
  

rename_columns:
  'ID #\n\n(Set by Efram: do not edit)': 'Original ID'
  'Location (nearest intersection)\n\n(Set by Efram: do not edit)': 'Location'
  'Proximity of Nearest Burned Structure\n\n(Survey Answer: do not edit)': 'Proximity of Nearest Burned Structure'
  'Damage Sustained\n\n(Survey Answer: do not edit)': 'Damage Sustained'
  'Remediation Status\n\nThis column should only feature "PRE". Any interior tests done POST remediation should already be listed in the DATA_POST_INT tab\n\n(Set by Efram: do not edit)': 'Remediation Status'
  'Sample Date\n\n(mm/dd/yyyy)\n(Not Provided if date missing. If more than one, separate with new line)': 'Sample Date'
  'Wildfire Debris\n\n(Ash, Char, Soot)\nDetected = any one of these contaminants is found': 'Wildfire Debris'
  'Ash\n\nPeak Detection (Location)\n\n(alphabetized, title case, and plural when necessary)\n\n(Detected NOT in caps)': 'Ash'
  'Soot\n\nPeak Detection (Location)\n\n(alphabetized, title case, and plural when necessary)\n\n(Detected NOT in caps)': 'Soot'
  'Char\n\nPeak Detection (Location)\n\n(alphabetized, title case, and plural when necessary)\n\n(Detected NOT in caps)': 'Char'
  'Lead (Pb) Detection Locations\n\n(list locations of ALL detections)\n\n(alphabetized, title case, and plural when necessary)': 'Pb Detection Location(s)'
  'Location of Peak Positive Lead Sample\n\n(Attic, Interior Floor, Interior Hard Surface, Interior Windowsill, Garage Floor, Garage Hard Surface, HVAC)': 'Max Pb Location'
  'Peak Lead Level (µg/ft²)': 'Max Pb'
  'Asbestos\n\n(what kind, where, and test type)\n(non-specific = PLM)\ne.g., DETECTED: 1 structure Chrysotile (<2,604 s/cm², Interior Floor, TEM)': 'Asbestos'
  'Arsenic (As)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'As'
  'Antimony (Sb)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'Sb'
  'Barium (Ba)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'Ba'
  'Beryllium (Be)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'Be'
  'Cadmium (Cd)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'Cd'
  'Chromium (Cr)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'Cr'
  'Cobalt (Co)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'Co'
  'Copper (Cu)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'Cu'
  'Mercury (Hg)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'Hg'
  'Molybdenum (Mo)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'Mo'
  'Nickel (Ni)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'Ni'
  'Selenium (Se)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'Se'
  'Silver (Ag)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'Ag'
  'Thalium (Tl)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'Tl'
  'Vanadium (V)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'V'
  'Zinc (Zn)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested': 'Zn'

valid_locations_and_epa_limits:
  'Attic': null
  'Interior Floor': 5
  'Interior Hard Surface': 100
  'Interior Windowsill': 40
  'Garage Floor': null
  'Garage Hard Surface': null
  'HVAC': null
  'Location Not Provided': null
  'Interior - Not Specified': null

labeler_codes:
  Person1: 1

# Metals that are in the excel doc. Likely don't want to update these
metal_columns_to_validate:
  - 'Antimony (Sb)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'
  - 'Arsenic (As)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'
  - 'Barium (Ba)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'
  - 'Beryllium (Be)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'
  - 'Cadmium (Cd)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'
  - 'Chromium (Cr)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'
  - 'Cobalt (Co)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'
  - 'Copper (Cu)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'
  - 'Mercury (Hg)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'
  - 'Molybdenum (Mo)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'
  - 'Nickel (Ni)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'
  - 'Selenium (Se)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'
  - 'Silver (Ag)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'
  - 'Thalium (Tl)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'
  - 'Vanadium (V)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'
  - 'Zinc (Zn)\n\n• DETECTED: peak amount (Location)\n• Not Detected\n• Not Tested'

required_non_null_columns:
  - 'Original ID'
  - 'Latitude'
  - 'Longitude'
  - 'Test Entry Assignment'

geospatial_location_column: 'Location (nearest intersection)\n\n(Set by Efram: do not edit)'
orig_lead_column: 'Peak Lead Level (µg/ft²)'
renamed_lead_column: 'Max Pb'
lead_locations_column: 'Lead (Pb) Detection Locations\n\n(list locations of ALL detections)\n\n(alphabetized, title case, and plural when necessary)'
peak_sample_column: 'Location of Peak Positive Lead Sample\n\n(Attic, Interior Floor, Interior Hard Surface, Interior Windowsill, Garage Floor, Garage Hard Surface, HVAC)'
asbestos_column: 'Asbestos\n\n(what kind, where, and test type)\n(non-specific = PLM)\ne.g., DETECTED: 1 structure Chrysotile (<2,604 s/cm², Interior Floor, TEM)'
renamed_asbestos_column: 'Asbestos'
original_wildfire_debris_column: 'Wildfire Debris\n\n(Ash, Char, Soot)\nDetected = any one of these contaminants is found'
original_testing_laboratory_column: 'Testing Laboratories\n\nIf multiple labs, please indicate what each was testing for\n\nSeparate with &'
original_testing_company_column: 'Main/Testing Companies\n\nIf multiple companies, please indicate what each was testing for\n\nSeparate with &'

valid_metal_prefixes:
  - 'DETECTED'
  - 'Not Tested'
  - 'Not Detected'
valid_wildfire_debris_categories:
  - 'Not Tested'
  - 'Not Detected'
  - 'Detected'

# Metals that can be updated for plotting (except for lead -- that is handled above)
metal_columns_to_analyze:
  - 'Sb'
  - 'As'
  - 'Ba'
  - 'Be'
  - 'Cd'
  - 'Cr'
  - 'Co'
  - 'Cu'
  - 'Hg'
  - 'Mo'
  - 'Ni'
  - 'Se'
  - 'Ag'
  - 'Tl'
  - 'V'
  - 'Zn'

asbestos_test_types:
  - 'PLM'
  - 'TEM'
  - 'PCM'