French Map visualization

[Mohcine]

Hello everybody,

I actually have a problem to visualize french counties and cities on a map chart. In fact, i only have names of counties and cities and zipcodes of cities. However, i can’t visualize neither of them on the map, it is like the map can only show US Map by default. Does anyone know how to display a map of France without latitude an longitude fields ?

PS : i have latitude and longitude (of accidents)  fields which i used to create a location dimension but it doesn’t display anything on the map (i defined their type to “number” in the view in the develop section)

regards,

[Dawid]

That’s because there isn’t a map with French counties and cities in Looker. As you can see here: https://docs.looker.com/exploring-data/visualizing-query-results/map-regions-options

The only available maps out-of-the-box are:

• Austin, Texas (ZIP Codes): Use data grouped by Austin zip codes (for region or point maps) or lat/long locations (for point maps only)
• New York City (ZIP Codes): Use data grouped by NYC zip codes (for region or point maps) or lat/long locations (for point maps only)
• San Francisco Peninsula (ZIP Codes): Use data grouped by San Francisco peninsula zip codes (for region or point maps) or lat/long locations (for point maps only)
• United Kingdom (Postcode Areas): Use data grouped by UK postal codes (for region or point maps) or lat/long locations (for point maps only)
• United States: Use data grouped by US states (for region maps only), zip codes (for point maps only), or lat/long locations (for point maps only)
• World: Use data grouped by country (for region maps only) or lat/long locations (for point maps only)

Anything else, you have to upload your own map to Looker and make sure that the names match what you have in the database. I did that for Spanish administrative regions with separate maps of Comunidades, Provinicias, Comarcas, and Municipalities

[Mohcine]

Hey @Dawid , thanks for your answer. I’m new to looker so when you say upload my own map, where should i do that and in which format this map should be ?

[Dawid · Accepted solution]

You could use this map that’s available: https://github.com/deldersveld/topojson/blob/master/countries/france/fr-departments.json

In this TopoJSON file, you have these data points:

NAME_2 is what should match your data. If it doesn’t, there may have to be some other steps. What I had to do was to also convert topoJSON to CSV, upload it to my database and cross-reference my data with the map’s data. Then I join it in Looker and the labels are always the same because they use the same source (map).

Here’s another one: https://france-geojson.gregoiredavid.fr/

[Mohcine]

Thanks @Dawid, this is really helpful. I’m gonna try this solution and see how to make it work.

Thanks again !

Mohcine