Forum Discussion
AdministratorMap different municipalities with the same name
AdministratorHello, thank you for your reply. The columns are classified as follows:
Township = County
Department = 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?
Super UserYou would do that in your data model where the department table would filter the municipality table.
- Syndicate_Admin
The departments column does filter municipalities, but it also filters municipalities of the same name from other departments. Is there a way for you to only filter the municipalities of the selected department?
- lbendlin
can you provide sample data that illustrates the issue?
- Syndicate_Admin
An example is the screenshot I put in the first message. Here's another one to illustrate better.
On the map on the right the department is selected, on the map on the left, apart from the municipalities of that department, other municipalities that belong to other departments are selected (other blue dots are seen outside the limits of the department).What I am looking for is that only the municipalities that are within the selected department are selected.
Thank you