Forum Discussion
AdministratorMap different municipalities with the same name
Hello, I am trying to make a map of shapes with municipalities and departments. I have a map of departments and one of municipalities, linked to the table with the information I want to show. When I select a municipality, in both maps the department to which it belongs is selected, the problem is that, in the map of municipalities municipalities are also selected municipalities of the same name that are in other departments.
I have already tried concatenating the columns municipality and department in one and relate it to my data but it does not work. All columns are categorized into country, department, and municipality. Could someone please help me?
Attached screenshot of the maps and table:
In advance I very much appreciate your help 🙂
7 Replies
- lbendlin
Super User
How did you geo-classify your columns? And why did you include mundepais? That is not something the geocoding service can use.
Do you have more details like postal codes or Lat/Lon pairs that you could use to help the geocoding service?
Syndicate_AdminHello, thank you for your reply. The columns are classified as follows:
Township = CountyDepartment = State or province
Codpais = Country/region
The mundepais column was a test I did to know if being the municipality and department to which it belongs in the same column, I only select the municipalities that belong to that department, but it did not work. That column is classified as City, but I didn't use it anymore because I saw that the test didn't work.
I don't have postcodes or Lat/Long coordinates.
What I am looking for is that, when selecting a department, in the map of municipalities only the municipalities that belong to that department are selected, not those of the same name of other departments , how could I achieve it?
- lbendlin
You would do that in your data model where the department table would filter the municipality table.
