I am working on having a map made that will show the location of users based on the information they put in their profile fields during registration (things like City, State, Zip Code, etc).
My developer for the map is telling me that the data is being saved in a “meta” format and that there are no unique identifiers for these given fields (City, State, etc.)
What the database is doing is collecting user’s data, and storing it in column named “meta” there’s no identifier that is city, country or postal code, etc. In order to get this data for the map I will need the data to be placed in a separate columns for each category.
How can I accomplish this?
Thank you in advance.
WP vers. 5.3.2