Queryjane - Development Update - Country, State and City features.

QueryJane is a web application developed with Django that allows to connect with companies and experts in different sectors of the cannabis industry. Beta version is available [here](https://queryjane.net/).

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.

---

GitHub Account

https://github.com/aaquirogal
Pull request

---

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.

We have pending some administrative requirements, so, we will be working on it. There are still some final features in the "TO DO" list in our Trello board.

Take a look to our public trello board. This is the easiest way to know our roadmap.

If you want to contribute, please join my Discord

Have happy days ✌