I am crunching a large amount of information based on Open Records Act requests, and am forced to deal with an agency that is dodging my actual request through pure semantics.
Each item includes longitude and latitude, but I also requested "county" which they have not submitted.
I have requested that information in a new ORA request, but those can, and frequently do take weeks for this government agency to reply.
If I could calculate the county myself within my database I'd be delighted.
Is there a ready-made calculation or script step that can calculate the county based on latitude and longitude?
Waiting on government agencies to respond is not something I'm fond of doing, especially when they don't WANT to respond.