# Multiple geopoint & multilanguage document

**URL:** <https://discuss.elastic.co/t/multiple-geopoint-multilanguage-document/22193>\
**Category:** Elasticsearch\
**Created:** [February 16, 2015, 4:45pm UTC](https://discuss.elastic.co/t/multiple-geopoint-multilanguage-document/22193 "2015-02-16T16:45:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Niko\_Para](https://avatars.discourse-cdn.com/v4/letter/n/71c47a/32.png) [@Niko\_Para](https://discuss.elastic.co/u/Niko_Para)\
**Post date:** [February 16, 2015, 4:45pm UTC](https://discuss.elastic.co/t/multiple-geopoint-multilanguage-document/22193/1 "2015-02-16T16:45:21Z")

</div>

Hello everyone,

I need advice.

For the purposes of the project, I need to search near me locations based  
on phrases entered by the user in smart phones.

The problem: a phrase or text can be translated into hundreds of languages  
and can be a tagged on hundreds of thousands of locations.

I would like search results to be fast and efficient, at the same time I  
want to avoid duplication of the text.

So I imagined documents organized in this way:

{  
"locations":[  
{  
"address": "address here..",  
"location": "40.715, -74.011"  
},  
{  
"address": "address here..",  
"location": "44.715, -76.011"  
},  
{  
"address": "address here..",  
"location": "96.715, 45.011"  
},  
// NEXT 100.000 location

],  
"messages":[  
{  
"eng":{"title":"English title", "body":"body text.."},  
"fra":{"title":"French title", "body":"body text.."},  
"spa":{"title":"------ title", "body":"body text.."},  
"deu":{"title":"------ title", "body":"body text.."},  
"ned":{"title":"------ title", "body":"body text.."},  
"por":{"title":"------ title", "body":"body text.."},  
"arb":{"title":"------ title", "body":"body text.."},  
// NEXT 100 translations in the different languages  
}

]

}

Is this the correct way?

Also, the number of locations will change frequently. If I have a document  
with a couple of hundred of thousands of locations, how fast is the update  
of this document?

Thanks

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/83580d74-45fb-429a-a0a9-81c25a165d29%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/83580d74-45fb-429a-a0a9-81c25a165d29%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Niko\_Para](https://avatars.discourse-cdn.com/v4/letter/n/71c47a/32.png) [@Niko\_Para](https://discuss.elastic.co/u/Niko_Para)\
**Post date:** [March 7, 2015, 11:00pm UTC](https://discuss.elastic.co/t/multiple-geopoint-multilanguage-document/22193/2 "2015-03-07T23:00:53Z")

</div>

_I refresh this question._

I have tons of data in a complex many to many relationship through a join  
model, assuming that it is a MySQL database. But in reality, data will be  
stored in the graph db as arangodb or neo4j

[Model A: multi langual text] -\> [Join Model: reference keys and additional  
fields] \<- [Model B: geolocation, address, ..]

My application needs to search for the nearest location from the Model B,  
then to find a text in the Model A, which is connected to the Model B.

I know that for each connection can create an entry in the ES, but it gives  
me an enormous number of identical text documents where the only difference  
is in the data from the Model B and Join Model. Please note that any  
document of Model A may be over 2MB in size.

I want to ask, is it possible to create an EC entry as I described above  
(See the first post)?

So save tons of locations in a single document, with associated  
multilingual Text?

Thank you.

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/169ff2c3-69b2-4490-925b-ae0f5aab5052%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/169ff2c3-69b2-4490-925b-ae0f5aab5052%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 12:27am UTC](https://discuss.elastic.co/t/multiple-geopoint-multilanguage-document/22193/3 "2017-07-06T00:27:52Z")

</div>

Closed on July 6, 2017, 12:27am UTC