Fix 6786

- Handle Month DD YYYY dates
- Add dictionary checks in geocode and lookup modules
- Add exception handling in transform_spatial