We currently have an Estate Agent / Real Estate website where each house has its address details entered into columns in its row in a MySQL database.
We have a Geolocation search system built in to the website (IE a search form where the visitor can type the Town or Post Code, select a search radius and find properties within that radius). However this currently relies on the Latitude & Longitude of the house being entered into the database.
We need to remove the requirement for our webmasters to find & enter the Lat & Long values for each house they add. So that would take the form of either:
i) (Preferable) - Converting the Geolocation system we have to not refer to Lat & Long at all, but use the values in the Post/Zip code or Town fields only
ii) Alter the "Add new house" system such that it automatically determined the Lat & Long values for each house added, this would achieve the same goal.
We would prefer i) as the solution if possible, as we currently have a number of houses without Lat & Long values and would prefer our webmasters didn't have to go back and add them. This would be required if ii) was implemented.
We require the system to work worldwide using any international Post/Zip code.
The website uses Joomla 3.4 as the Content Management System, and the houses are intered in the back end as K2 items using a modified K2 items form. Please contact us if you need to see the website in question, or have any questions about the code involved.