Initially, We were using the Google geocode API to populate the countries, states and cities databases. We were generating that data according to the users location. It's very important to us to have a very well structured database for place and location data, it allow us the make very specific queries, and it's important to offer very well filtered information.
Recently, the Geocode service terms were updated. And now we can't use it in the project. For this reason, we have changed the way in that it works.
New features
Platform administrators can load States and Cities from .xls file.
In order to solve the problem caused by the change in the term of use of the Geocode service, we have implemented a new way to create the states and cities database. Now, platform administrators can upload an excel file with a list of states and cities of a specific country.
That means that now, users can only register companies in specific countries with pre-loaded information about states and cities. That's good, because it will allow us create a legal frame more focussed with the law in some specific countries. Cannabis is a complicated topic in a lot of countries yet. That will let us to create visibility ads for a more particular group of people.
Now, Platform administrators can find this page in their settings dashboard:
Here, platform administrators can upload a group of state-city elements for a specific country. This form accepts a .xls file with the information, and the city and state instances are created for the country specified in the "country code" field.
The .xls file must have a column with the states names, and a column with the city names. I have created all states and cities for Colombia and US. I'm hope to find .xls files with all the states and cities of Uruguay, Canada and México, countries with special legal improvements around the cannabis industry. We must to update this information in the application homepage.
Previously, in the company form, there was a button to get user location, and in this way, the country-state-city instances were created. Now, User can create companies only in Colombia and USA (Per now, we have to find reliable databases about states and cities to add another country).
So, the previous autocomplete field was changed by three select fields in the company form. Country, state and city. There are AJAX requests that update the state field when the country select is changed, and AJAX requests that update the city field when the state select is changed. Now, that select field don't look cool, but @cunigarro will take care of that.
In this way, we can create very specific location queries. This new feature not only affects the company create form. The profile form and the job offer form were changed too.
Now, I will be searching for other database to upload. There are just some minor features that we need to fix yet, so we will be working on it as fast as we can.
How to contribute
QueryJane has been developed using the Django framework. You can fork the project, and run it locally is very easy. Follow the steps described in the open source repository installation guide. The project has been configured using Docker. you only need to install Docker and follow these steps.
Future work.
Have happy days ✌