# Problems while uploading Geojson data in Kibana Maps (Elastic Cloud) **URL:** \ **Category:** Kibana\ **Tags:** maps\ **Created:** [April 20, 2020, 9:52pm UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936 "2020-04-20T21:52:05Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Pato\_Loza](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pato_loza/32/66242_2.png) [@Pato\_Loza](https://discuss.elastic.co/u/Pato_Loza)\ **Post date:** [April 20, 2020, 9:52pm UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936/1 "2020-04-20T21:52:06Z")
Hi! First of all, thanks to anyone who can help me with this. I had some problems trying to add some GEOJSON data in Kibana Maps. The problems is that when I try to upload a file it keeps charging and charging but nothing happens and even after an hour it keeps doing this process without any error, result or any kind of alert (illustration 1). It is important to say that I am working with the Kibana deployment (v7.6.2) of Elastic Cloud, nevertheless when i try to upload the SAME FILE in my Kibana (localhost:5601) it works perfectly. (illustration 2). Can someone help me with this, does anyone know how to solve it please? Additional info: - File weight (7037Kb) - Type: Point - Number of features: 3455 points ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/4/f436f5ab3606dfe1060a6272ad82a5eb71caf630.jpeg) Upload Error ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/6/a6b35551888755a6a27cfd7dba42c481cf89a85e.png) File working in localhost:5601 ---
**Author:** ![LizaD](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lizad/32/51074_2.png) [@LizaD](https://discuss.elastic.co/u/LizaD)\ **Post date:** [April 21, 2020, 2:23am UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936/2 "2020-04-21T02:23:54Z")
Hi @Pato_Loza, Welcome to our community! Is there any browser console error when you see this issue on cloud? Thanks, Liza ---
**Author:** ![Pato\_Loza](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pato_loza/32/66242_2.png) [@Pato\_Loza](https://discuss.elastic.co/u/Pato_Loza)\ **Post date:** [April 21, 2020, 3:06am UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936/3 "2020-04-21T03:06:52Z")
Thanks for answering me Liza! No, no errors are displayed in the browser console nor in Kibana. Let me tell you that I tried with another lighter geojson file, and it worked, but with this specific one it didn't. I am wondering if it is because i am using a free trial of Elastic Cloud!. Are there restricions like this in the free trial or not? Please, let me know if you think that could be another reason for this error! ---
**Author:** ![LizaD](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lizad/32/51074_2.png) [@LizaD](https://discuss.elastic.co/u/LizaD)\ **Post date:** [April 21, 2020, 3:19am UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936/4 "2020-04-21T03:19:41Z")
Thanks @Pato_Loza, Let me see if one of our Kibana maps experts @thomasneirynck can advise what to check next before we route to Cloud. There should not be a restriction on this in Cloud trial, but I could be wrong, it is interesting that you tried same file on-prem and it worked, are both your cloud and on-prem using the same version 7.6.2? Regards, Liza ---
**Author:** ![Pato\_Loza](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pato_loza/32/66242_2.png) [@Pato\_Loza](https://discuss.elastic.co/u/Pato_Loza)\ **Post date:** [April 21, 2020, 3:49am UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936/5 "2020-04-21T03:49:19Z")
In my localhost:5601 I am using Kibana v7.6.1 and in cloud v7.6.2. Additionally, I tried to solve the problem changing the deployment version in Elastic Cloud from v7.6.2 to v 7.5.2 but i didn't work too. Thanks Liza! ---
**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:** [April 21, 2020, 7:54am UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936/6 "2020-04-21T07:54:31Z")
Hi @Pato_Loza, Would it be possible to share the geojson file for use to take a look? Without errors in the browser console, it is hard to guess what may be happening, and it will definitely be faster than having to search for the cloud logs. Have you tried in your localhost with 7.6.2? ---
**Author:** ![Pato\_Loza](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pato_loza/32/66242_2.png) [@Pato\_Loza](https://discuss.elastic.co/u/Pato_Loza)\ **Post date:** [April 21, 2020, 1:59pm UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936/7 "2020-04-21T13:59:52Z")
Thanks for your help @jsanz!, i just sent you the aforementioned geojson through drive link in a message. > [@jsanz](#): > > Have you tried in your localhost with 7.6.2? No, i haven't but let me try Thanks, ---
**Author:** ![Pato\_Loza](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pato_loza/32/66242_2.png) [@Pato\_Loza](https://discuss.elastic.co/u/Pato_Loza)\ **Post date:** [April 21, 2020, 2:48pm UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936/8 "2020-04-21T14:48:43Z")
@jsanz i tried in localhost with kibana v7.6.2 and it worked! ---
**Author:** ![pgoldtho](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pgoldtho/32/66901_2.png) [@pgoldtho](https://discuss.elastic.co/u/pgoldtho)\ **Post date:** [April 21, 2020, 6:42pm UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936/9 "2020-04-21T18:42:52Z")
I found [https://www.elastic.co/blog/how-to-ingest-geospatial-data-into-elasticsearch-with-gdal](https://www.elastic.co/blog/how-to-ingest-geospatial-data-into-elasticsearch-with-gdal) to be a more reliable way to load spatial data into Elasticsearch. The Kibana UI limits the size geojson files you can upload (and requires a pre-processing step if your start point is a shapefile). Follow the instructions on [https://github.com/OSGeo/gdal/tree/master/gdal/docker](https://github.com/OSGeo/gdal/tree/master/gdal/docker) to get a version of gdal that works with Elastic (I'm using osgeo/gdal:alpine-normal-latest) Incidentally, I've found Kibana Maps on Elastic Cloud to be flakey. I've seen similar errors to the one in your screenshot when the Elastic Cloud Kibana instance crashes. ---
**Author:** ![LizaD](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lizad/32/51074_2.png) [@LizaD](https://discuss.elastic.co/u/LizaD)\ **Post date:** [April 21, 2020, 9:38pm UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936/10 "2020-04-21T21:38:41Z")
Hi @Pato_Loza, Can you also send me the file as you did for @jsanz? I can try it as well to see if I can reproduce. Unless the file contains sensitive information, then I understand. Thanks, Liza ---
**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:** [April 22, 2020, 9:36am UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936/11 "2020-04-22T09:36:31Z")
@Pato_Loza I could load your datasets into our cloud (7.6.2) without any issue: ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/7/5792c64d0312a62e988a06bc2506d90ee4b0736c.png) I can only assume computing power as the difference between environments. What are your cloud deployment specs? the second dataset has rather large polygons, you may want to simplify them, remove unused fields, etc. In our experience [mapshaper](https://mapshaper.org/) is a nice tool (with a [cli version](https://github.com/mbloch/mapshaper/wiki/Introduction-to-the-Command-Line-Tool)) for this kind of boundary layers since it retains the topology of the polygons. Also, as @pgoldtho mentioned, you may prefer to use `ogr2ogr` for big datasets, since you have much better control of your mapping, dozens of input formats, etc. ---
**Author:** ![Pato\_Loza](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pato_loza/32/66242_2.png) [@Pato\_Loza](https://discuss.elastic.co/u/Pato_Loza)\ **Post date:** [April 22, 2020, 1:45pm UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936/12 "2020-04-22T13:45:07Z")
@pgoldtho thanks for answering, it is good to know that I am not the only one who have this error. Do you know how can use GDAL in Elastic Cloud?. I was checking out the links that you posted bellow, but i don't really know how used it in order to upload data into Elastic Cloud. Or maybe @jsanz could help me with this? FInally, answering your question I am using the recommended specs of an "I/O Optimized" deployment. ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/4/64c7d2badb3eefac6fae8e4fa96c58da256410ae.png) Thanks!, ---
**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:** [April 22, 2020, 2:47pm UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936/13 "2020-04-22T14:47:02Z")
That deployment is perfectly capable of managing this and way bigger datasets. Since this seems an issue with our cloud service, I suggest you to open a support ticket, details [here](https://www.elastic.co/cloud/elasticsearch-service/support). Please include this post for reference. * * * Regarding using `ogr2ogr`, the blog post explains how to use the tool. You have the Elasticsearch endpoint in the deployment interface. ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/3/3333f2a158d658713b52d783947376bd2e9f7460.png) The thing is that the current stable release of the tool is still not compatible with Elasticsearch 7 yet. The easiest way to execute the tool at this moment is by using a Docker image, but you need some "fluency" with both tools to debug any issues you may find. The workflow I would use is: 1. Clean and optionally simplify the file: ```auto $ mapshaper -i DPA_CANTONAL_S.geojson \ -clean -verbose -simplify "80%" \ -o DPA_CANTONAL_S.clean.geojson ``` 1. Upload to your cluster given a `ES_URL`, `USER`, and `PASSWORD` assuming the file is in the working directory ```auto $ docker run --rm -u $(id -u ${USER}):$(id -g ${USER}) \ -v $(pwd):/data \ osgeo/gdal:alpine-small-latest \ ogr2ogr -nln cantonal_test -f Elasticsearch \ "https://USER:PASSWORD@ES_URL" \ /data/DPA_CANTONAL_S.clean.geojson ``` 1. Check the index `cantonal_test` has been generated and populated ```auto $ curl "https://USER:PASSWORD@ES_URL/_cat/indices/cantonal*?v" health status index uuid pri rep docs.count docs.deleted store.size pri.store.size yellow open cantonal_test bNy5iTM6SHujMAm2h9t2zA 1 1 221 0 10mb 10mb ``` 1. Load it in Maps ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/e/ded9123ed944ff310489c2999dedeac19655199b.png) Hope it helps ---
**Author:** ![pgoldtho](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pgoldtho/32/66901_2.png) [@pgoldtho](https://discuss.elastic.co/u/pgoldtho)\ **Post date:** [April 22, 2020, 3:02pm UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936/14 "2020-04-22T15:02:59Z")
You'll need to install docker ([https://docs.docker.com/get-docker/](https://docs.docker.com/get-docker/)) if don't already have it. Then run `docker pull osgeo/gdal:alpine-normal-latest` to download a gdal image. You only need to run the docker pull command once. After that you can run something like this to upload your data: ```auto docker run --rm -v /Users:/Users osgeo/gdal:alpine-normal-latest ogr2ogr -skipfailures \ ES:https://elastic:es-password@cloudinstance.us-central1.gcp.cloud.es.io:9243 \ $PWD/FL_Wetlands.shp ``` This assumes you are using a Mac. Change `-v /Users:/Users` to `-v /home/home` on Linux. Haven't tried this on Windows ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 20, 2020, 3:03pm UTC](https://discuss.elastic.co/t/problems-while-uploading-geojson-data-in-kibana-maps-elastic-cloud/228936/15 "2020-05-20T15:03:05Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.