Skip to content

Make state and county lookups resilient against non-conformant data #26

@prestoncabe

Description

@prestoncabe

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    Status

    Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions