County names in the locations database are formatted like: "Montgomery". Right now our lookups rely on an exact match, so the following wouldn't work: "montgomery" "MONTGOMERY" "Montgomery " "Mont." So we'd like to be more resilient: - [ ] Make state and county lookups case-insensitive - [ ] Trim whitespace from name before performing lookup - [ ] Maybe: explore fuzzier searching (sql "like" clause?) so "Mont." matches
County names in the locations database are formatted like: "Montgomery".
Right now our lookups rely on an exact match, so the following wouldn't work:
"montgomery"
"MONTGOMERY"
"Montgomery "
"Mont."
So we'd like to be more resilient: