I
I
Igor2020-11-14 21:17:37
nested set
Igor, 2020-11-14 21:17:37

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

1 answer(s)
I
Ivan Shumov, 2020-11-14
@inoise

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 question

Ask a Question

731 491 924 answers to any question