Answer the question
In order to leave comments, you need to log in
Nested sets for FIAS?
Colleagues, by eliminating bad practices, I am trying to achieve a relatively correct solution.
Yuzayu FIAS discovered for himself the fact that the depth of the address can be different.
For example:
Voronezh region
-----Verkhnemamonsky district
---------s. Lower mamon
Moscow
----- Naro-Fominsk district
-------- city of Vereya
------------ village Kryuchki
Of course I want to be wrong, but the depth is different, in addition to all sorts of villages there many more others.
I'm already thinking about Nested sets, since FIAS lies in a flat structure that looks like just Nested sets
Add left right lvl and voila, Nested sets.
Has anyone done this?
As a result, I want to get address trees.
The roots will naturally be autonomous okrugs.
The only thing that confuses is the amount of data on the bush.
Answer the question
In order to leave comments, you need to log in
I did denormalization for elastic and made a graph. Both are ok. First. Option for full-text search and typos, and the second option for the sake of experimenting with performance. Nested set is not needed here. Do not confuse tasks)
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question