# Visualize zipcodes on Kibana Maps **URL:** \ **Category:** Kibana\ **Tags:** maps\ **Created:** [October 13, 2020, 7:41am UTC](https://discuss.elastic.co/t/visualize-zipcodes-on-kibana-maps/251860 "2020-10-13T07:41:03Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Baptiste\_Orsoni](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/baptiste_orsoni/32/45225_2.png) [@Baptiste\_Orsoni](https://discuss.elastic.co/u/Baptiste_Orsoni)\ **Post date:** [October 13, 2020, 7:41am UTC](https://discuss.elastic.co/t/visualize-zipcodes-on-kibana-maps/251860/1 "2020-10-13T07:41:03Z")
Hello everyone, I have csv data with information about users and in particular their zip code. I wanted to know how it was possible to display these zip codes on Kibana Maps knowing that I don't have the longitude and latitude information for these zip codes. I integrated a csv test document in which I modified the mapping to transform my zip code data into geo\_point but I was unable to display anything on a map. Thank you in advance for your help. My best regards, Baptiste Orsoni ---
**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\ **Post date:** [October 13, 2020, 9:15am UTC](https://discuss.elastic.co/t/visualize-zipcodes-on-kibana-maps/251860/2 "2020-10-13T09:15:32Z")
Hi @Baptiste_Orsoni, Elastic Maps Service provides [Zip codes](https://maps.elastic.co/#file/usa_zip_codes) for the US so you can use directly the [Choropleth](https://www.elastic.co/guide/en/kibana/current/maps-add-choropleth-layer.html) wizard. If you are working with another country you will have to find the zip countries dataset, upload it to Elasticsearch, and finally you can run a [term join](https://www.elastic.co/guide/en/kibana/current/terms-join.html) with your data index to render the map. > [@Baptiste\_Orsoni](#): > > I integrated a csv test document in which I modified the mapping to transform my zip code data into geo\_point but I was unable to display anything on a map. Can you provide more details of this process? How did you convert your zipcodes into `geo_point`? Have you generated an index pattern? ---
**Author:** ![Baptiste\_Orsoni](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/baptiste_orsoni/32/45225_2.png) [@Baptiste\_Orsoni](https://discuss.elastic.co/u/Baptiste_Orsoni)\ **Post date:** [October 13, 2020, 9:53am UTC](https://discuss.elastic.co/t/visualize-zipcodes-on-kibana-maps/251860/3 "2020-10-13T09:53:09Z")
Hi @jsanz Thanks for the quick answer. Unfortunately I'm working in France with french zip codes but I'll try to find french zip codes dataset as you suggested. > [@jsanz](#): > > Can you provide more details of this process? How did you convert your zipcodes into `geo_point` ? Have you generated an index pattern? For the conversion of the zipcodes : - I uploaded my csv doc via the Data Visualizer of the Machine Learning process. - After the upload and import of my doc, I went to the advanced options where I've added in the mapping : "location\_geo" : { "type" : "geo\_point" } and in the ingest pipeline : "append": { "field": "location\_geo", "value": "{{zipcode}}" } ("zipcode" corresponding to my parameter retrieving zipcodes in my doc). But I suspected that the French postal codes were not going to appear as if by magic. My goal is to display the number of users per zip code on the map, so I wanted to know what method you recommend to do this in the best possible way. Thanks again for your help, Baptist Orsoni ---
**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\ **Post date:** [October 13, 2020, 10:58am UTC](https://discuss.elastic.co/t/visualize-zipcodes-on-kibana-maps/251860/4 "2020-10-13T10:58:07Z")
> [@Baptiste\_Orsoni](#): > > But I suspected that the French postal codes were not going to appear as if by magic. Sorry but that is not how it works. The process you followed works for CSVs with full coordinates in your dataset. This needs two steps: 1. Find your geospatial dataset. [This page](http://download.geonames.org/export/zip/) may be a good starting point for you, since it apparently contains France postcodes as points. You could upload that to Elasticsearch using the same tooling you already used. 2. Map your data. Once you have your postal codes up in your cluster you should be able to create the `Term join` layer I mentioned earlier. I don't know if there are other official datasets for France postalcodes. It's a type of dataset that is always a bit tricky to find and [problematic to use for spatial analysis](https://carto.com/blog/zip-codes-spatial-analysis/), even it may be your best option depending on your project. ---
**Author:** ![Baptiste\_Orsoni](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/baptiste_orsoni/32/45225_2.png) [@Baptiste\_Orsoni](https://discuss.elastic.co/u/Baptiste_Orsoni)\ **Post date:** [October 13, 2020, 11:59am UTC](https://discuss.elastic.co/t/visualize-zipcodes-on-kibana-maps/251860/5 "2020-10-13T11:59:48Z")
Very well, I will try this two steps. Thanks for your help. Have an excellent week ! ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 10, 2020, 11:59am UTC](https://discuss.elastic.co/t/visualize-zipcodes-on-kibana-maps/251860/6 "2020-11-10T11:59:54Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.