You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

What table(s) store US cities and counties?

Accepted answer


In order to show the names of the counties/cities that correspond to the numeric codes that are are stored in various Oracle tables, I need to know the name(s) of the table(s) that store this information. Better yet, if someone could provide me with SQL queries to pull this information (City/County codes and meaningful names), I would appreciate it.

Content (required):

For example, when running the below query for a particular person id, it returns numeric codes in CONTEXT_VALUE1 and CONTEXT_VALUE2. I know that CONTEXT_VALUE1 of 23 equates to US state MI (Michigan). However, I am trying to find the table that stores county codes and their meanings, as well as city codes and their meanings. In the below snip-it, I believe that CONTEXT_VALUE2 of 145 equates to "Saginaw", but I need to find the table that stores this information.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!